Raw sources
Raw sources (bronze)
Rows from every feed, stored exactly as received. Normalisation happens in the silver layer, where each change is flagged.
ENREnrollment
43,101
raw rows
- Usable
- 42,871
- Flagged
- 84%
- No member ID
- 2%
- Linked
- 29,405
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
CLMClaims
32,829
raw rows
- Usable
- 32,674
- Flagged
- 74%
- No member ID
- 35%
- Linked
- 30,209
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
TPAThird-party administrator
14,474
raw rows
- Usable
- 14,404
- Flagged
- 77%
- No member ID
- 85%
- Linked
- 11,671
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
PRVProvider network
9,596
raw rows
- Usable
- 9,546
- Flagged
- 80%
- No member ID
- 50%
- Linked
- 8,676
- First seen
- 2026-01-01
- Last seen
- 2026-10-18
Raw events
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-26097 | 2026-01-20T01:58:45Z | GREGORY | U | HUSDON | Aug 14, 1968 | UHC-14069-21 | — | (276) 955-8963 | ···· | 7983 HILLCREST RD | Plano | TX | 75060 | ···· | UNKNOWN |
| PRV | PRV-21193 | 2026-01-29T00:45:45Z | LOGAN | — | MENDOZA | 7/19/1997 | UHC-83159-66 | ···· | (326) 456-3054 | N/A | 5812 JEFFERSON AVENUE | Tucson | AZ | 85728 | — | NULL |
| PRV | PRV-21930 | 2026-04-19T18:36:20Z | RALPH | S | ROGERS | 19840918 | - | •••-••-0034 | 775.645.9301 | UNKNOWN | 6073 Palm Drive | ·Tempe | AZ | 85247 | N/A | — |
| PRV | PRV-26856 | 2026-01-17T19:06:29Z | Jessica | — | Baker | 1977-11-26 | UHC-47501-58 | null | (432) 496-5121 | — | 9664 Willow Ct | Nashville | TN | 37259 | — | choice-plus-ppo |
| PRV | PRV-22925 | 2026-03-20T11:12:10Z | Pamela | — | ·Ruiz | 1970-10-10 | UHC-62098-03 | — | +1 950 525 8522 | UNKNOWN | 1086 Meadow Lane | Tampa | FL | 33666 | ·N/A | null |
| PRV | PRV-24810 | 2026-05-25T08:49:29Z | hannah | — | valdez | 1981-05-11 | — | •••-••-9475 | (779) 483-0431 | null | 5846 Canyon Rd | Nashville | TN | 37202 | — | - |
| PRV | PRV-23911 | 2026-01-20T16:08:58Z | Santiago | — | Tran | 1983-11-27 | NULL | N/A | — | SANTIAGO.TRAN43@YAHOO.COM | ·549 River Road | Austin | TX | 78742·· | — | NULL |
| PRV | PRV-23361 | 2026-08-04T12:31:50Z | AMY | — | WOODS | 1998-06-08 | UHC-57366-89 | null | 2328896648 | NULL | 5269 Canyon Road | Plano | Texas | 75013 | N/A | — |
| PRV | PRV-29011 | 2026-04-29T01:15:55Z | Vincent | — | Gray | ·1942-01-27 | UHC-05842-82 | — | 12417880612 | N/A·· | 4845 Bayshore Dr | LAS VEGAS | Nevada | ·89165 | ·null | ·NULL |
| PRV | PRV-29307 | 2026-01-07T13:48:19Z | DAVID·· | — | HUNTER | 1957-02-20 | NULL | NULL | 8163133970·· | — | 9047 Harbor Boulevard | Las Vegas | NV | 89153·· | N/A | - |
| PRV | PRV-20427 | 2026-09-03T07:19:04Z | WILLIE | — | VALDEZ | 1943-12-12 | UHC-40042-33 | null | 5905463036 | ·- | 4034 River Road #898 | Minneapolis | MN | 55475·· | — | null |
| PRV | PRV-28449 | 2026-04-21T00:36:09Z | ANTHONY | A | WRIGHT | Jun 16, 1957 | ···· | - | 8565647937 | anthony.wright@proton.me | 4821 River Road | SCOTTSDALE | AZ·· | 85231 | NULL | N/A |
| PRV | PRV-26270 | 2026-04-26T06:01:06Z | VICTORIA | — | ESTRADA | 1995-09-18 | null | null | 7884148482 | null | null | ···· | UNKNOWN | — | UNKNOWN | N/A |
| PRV | PRV-22009 | 2026-03-24T15:43:20Z | ·Charles | — | Lewis | — | - | UNKNOWN | +1 477 741 3745 | — | 3573 Indian School Road | SEATTLE | WA | 98102 | null | MEDICARE-ADV-B |
| PRV | PRV-28056 | 2026-06-27T03:59:16Z | LORI | — | ELLIS | 1947-10-21 | — | UNKNOWN·· | null | — | 7470 Bayshore Drive | ·Scottsdale | AZ | — | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-26977 | 2026-05-23T10:36:27Z | NATALIE H. | — | DUNCAN | Mar 22, 1972 | UHC-88287-19 | - | 6413717461 | natalie.duncan@aol.com | ·930 Meadow Ln | Las Vegas | NV | 89125 | null | UNKNOWN |
| PRV | PRV-27932 | 2026-07-28T14:59:49Z | Daniel | Y | Jensen | 1974-09-12 | UHC-77446-05 | •••-••-4861 | 9178022537 | — | 3605 Baseline Rd | CHANDLER | AZ·· | 85239 | NULL | null |
| PRV | PRV-29087 | 2026-03-24T22:30:36Z | Karen·· | — | Yeng | 1977-08-27 | UHC8452942 | - | 974.906.4192 | - | 1854 ELM ST | Orlando | FL | 32873 | NULL | — |
| PRV | PRV-23607 | 2026-07-13T11:35:43Z | CYNTHIA | X | DUNN | 1973-06-23 | null | •••-••-2215 | - | — | 5109 River Rd | Nashville | TN | 37230 | N/A | — |
| PRV | PRV-27610 | 2026-02-04T10:36:46Z | Reed, Dunna | ···· | — | 1985-11-09 | null | null | 4475624458 | DONNA.REED@YAHOO.COM | 9147 Park Pl | Jacksonville·· | FL | 32242 | ·NULL | OPTIONS-PPO |
| PRV | PRV-27245 | 2026-04-28T04:17:21Z | dylan | — | welch | Jul 5, 1956 | UHC-40221-33·· | •••-••-3047 | 6029260546 | NULL | 5659 OCEAN AVENUE | San Diego | CA | 92115 | null | — |
| PRV | PRV-28421 | 2026-02-05T21:02:15Z | Aisha | M. | Cox | 1948-11-27 | — | — | (785) 759-3363·· | aisha.cox80@proton.me | 3223 Harbor Boulevard | Las Vegas | NV | null | N/A | — |
| PRV | PRV-29203 | 2026-05-19T05:36:27Z | Jordan | — | Brooks | 1963-03-19 | uhc-55414-72 | ·NULL | 7516578927 | — | ·9719 CHURCH ST | PLANO | TX·· | 75053 | — | — |
| PRV | PRV-21685 | 2026-03-12T01:13:13Z | ·christina | K. | ·washington | 03/02/57 | NULL | — | (493) 556-3798 | UNKNOWN | 6381 Palm Dr | Las Vegas | NV | 89126 | — | NULL |
| PRV | PRV-24636 | 2026-05-29T16:40:33Z | Sophia | — | Lee | 3/11/2003 | null | N/A | 5425709844 | NULL | 528 Ocean Avenue | Gilbert | Arizona | 85227 | — | ·MEDICARE-ADV-A |
| PRV | PRV-29595 | 2026-06-16T21:53:20Z | ZACHARY | — | MENDEZ | 26-01-2003 | UHC-28618-02 | null | (833) 714-1304 | ZACHARY.MENDEZ90@OUTLOOK.COM | 8894 Lake View Road | ATLANTA | GA | 30373 | null | — |
| PRV | PRV-20294 | 2026-09-14T14:00:43Z | Reid·· | — | Santiago | 1991-05-21·· | ·UHC-51553-43 | — | (228) 224-1894 | santiago.reid14@aol.com | 8160 Willow Ct | Sacramento | California | 95874 | null | SELECT-EPO |
| PRV | PRV-22399 | 2026-02-02T22:28:53Z | Sofia | — | Porter | 2002-07-04 | UHC-53417-68 | N/A | 12304349910 | - | 1396 Apache Boulevard | Austin | TX | 78708 | - | NULL·· |
| PRV | PRV-22535 | 2026-05-13T23:51:55Z | Cynthia | ···· | Chan | 03/08/2008 | null | - | (430) 976-2568 | ·N/A | 7374 LAKE VIEW RD | Charlotte | NC | 28200 | — | - |
| PRV | PRV-25463 | 2026-03-24T05:37:20Z | Dunn, Billy | — | — | 19-08-1938 | UHC9464231 | N/A | — | BILLY.DUNN67@AOL.COM | 8982 MOUNTAIN VIEW DR | ·Chandler | Arizona | 85225 | — | — |
| PRV | PRV-20718 | 2026-08-08T08:59:32Z | Christian | ·· | Gomez | 1984-11-27 | UNKNOWN | N/A | (439) 387-4184 | N/A | 7865 Bayshore Dr | Austin | TX·· | 78733 | N/A | OPTIONS-PPO |
| PRV | PRV-27964 | 2026-01-16T00:58:48Z | Margaret | — | Foster | ·28-06-1950 | null·· | — | ·287-921-8901 | N/A | 9550 Highland Avenue | Phoenix | Arizona | — | — | MEDICARE-ADV-A |
| PRV | PRV-28215 | 2026-02-27T12:30:23Z | HELEN | — | GARCIA | 1/28/1973 | UHC-38530-83 | - | 9082605200 | — | 8801 FOREST AVENUE #953 | Fresno | CA | 93720 | ···· | — |
| PRV | PRV-21601 | 2026-01-09T10:46:26Z | Gutierrez, Wayne | — | ···· | 1982-11-13 | null | — | 14287131616·· | N/A | 7979 Park Place | MIAMI | FL | 33196 | — | N/A·· |
| PRV | PRV-23880 | 2026-04-14T20:38:19Z | jeremy | — | romero·· | Nov 14, 1954 | UHC-73018-04 | •••-••-2072 | 13467871225 | — | 4322 Bayshore Dr | Sacramento | California | 95834 | null | UNKNOWN |
| PRV | PRV-25609 | 2026-08-20T02:50:32Z | Kyle·· | — | Bryant | 1976-09-16 | UHC4565855 | null | 15824359988 | — | 3140 Ocean Avenue | Nashville | TN | 37281 | — | — |
| PRV | PRV-22196 | 2026-01-16T21:53:23Z | Natalie | W | Wang | 2000-08-13 | UHC-11557-27 | null | ·· | - | ·5773 Baseline Road | Minneapolis | MN | 55489 | — | — |
| PRV | PRV-24066 | 2026-02-10T02:12:13Z | Harold | I | Allen | 1982-05-24 | UHC-32188-32 | — | UNKNOWN | — | 4801 Mountain View Drive | Atlanta | GA | 30350·· | - | - |
| PRV | PRV-29445 | 2026-09-29T08:56:54Z | Jonathan | — | Schultz | 1945-06-08 | — | •••-••-3626 | 937-378-5066 | jonathan.schultz62@hotmail.com | N/A | - | UNKNOWN | N/A | — | ·· |
| PRV | PRV-26573 | 2026-01-20T03:14:12Z | Terry | Z | Kennedy | 2004-08-12 | ·· | — | (565) 954-2295 | ·null | 1735 FOREST AVE | Austin | TX | — | UNKNOWN | — |
| PRV | PRV-21299 | 2026-05-02T01:05:34Z | johnny | ···· | west | 1938-01-22 | — | — | 774.991.9668 | NULL | 8348 MARKET ST | Austin | TX | 78748 | - | ·· |
| PRV | PRV-21890 | 2026-04-19T20:59:35Z | ·Marcus | J | Delgado | 1990-12-17 | UHC-19436-23 | N/A | 19009239963 | null | 2234 Camelback Rd | Glendale | Arizona | 85375 | NULL | — |
| PRV | PRV-24762 | 2026-05-27T03:49:27Z | Thomas·· | A | Raymond | — | uhc-02723-41 | N/A | (827) 461-4635 | NULL·· | 7605 Harbor Blvd | Phoenix | AZ | 85007 | — | UNKNOWN·· |
| PRV | PRV-24343 | 2026-05-30T17:27:53Z | Lynch, John | — | — | 1985-12-18 | UHC-71698-36 | ·- | (461) 960-6705 | - | 4927 Ocean Ave | CHARLOTTE | NC | null | UNKNOWN | null |
| PRV | PRV-20971 | 2026-02-07T09:05:38Z | Wayne | H | Wang | ·1963-02-23 | UHC-60912-66 | UNKNOWN | 4217820 | NULL | 9494 Market Street | Jacksonville | FL | 32293 | N/A | NULL |
| PRV | PRV-20688 | 2026-03-21T03:21:00Z | Vazquez, Pamela | — | — | 1976-04-22 | UHC-24088-91 | NULL | +1 265 771 8014 | - | 2062 Park Pl | FRESNO | CA | 93758 | - | - |
| PRV | PRV-27787 | 2026-04-03T16:47:15Z | Anna | — | Ruiz | 6/2/1956 | NULL | ·· | 484-343-9310 | — | 8106 Canyon Road | Atlanta·· | Georgia | ·30390-9057 | UNKNOWN | - |
| PRV | PRV-26161 | 2026-06-14T00:15:14Z | THOMPSON | ···· | BARBARA | 19671028 | N/A | N/A | 6273534245 | BARBARA.THOMPSON@OUTLOOK.COM | 8600 Washington Street | TEMPE | AZ | 85233 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-23742 | 2026-07-18T13:56:42Z | heather | ·· | chapman | 12/02/1981 | UHC-90502-74 | - | 679.508.1731 | null | 7036 PARK PL | Minneapolis | MN | 55418 | NULL | - |
| PRV | PRV-28005 | 2026-05-30T13:38:59Z | Jeffrey | X | Fernandez·· | 1967-12-26 | UHC-50567-88 | - | (270) 239-4330 | JEFFREY.FERNANDEZ5@ICLOUD.COM | 1440 Market St | Tucson | AZ | 85737 | - | NULL |
Bronze layer rules
What is guaranteed for downstream layers
- As receivedValues are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
- No transformationBronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
- Line number preservedThe line number records each row's position in the source file, so a value can be located in the original extract.
- Load timestampThe load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-22T12:43:03.394Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty