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-20471 | 2026-10-18T08:15:33Z | Joe | W | Olson | Aug 5, 1974 | UHC-29037-70 | UNKNOWN | 9517227677 | NULL | 8587 MEADOW LN | Minneapolis | MN | 55480·· | — | UNKNOWN |
| PRV | PRV-26442 | 2026-01-24T13:09:52Z | Wilson, Katherine | Z. | — | 1991-03-22 | NULL | N/A | +1 594 318 2924 | — | 9140 Union Street | NASHVILLE | TN | 37272 | - | — |
| PRV | PRV-28161 | 2026-06-18T09:49:08Z | WALTER | — | WILLIS·· | Jun 12, 1941 | UHC-67611-72 | •••-••-5572 | 18569997249 | walter.willis@gmail.com | 9245 OCEAN AVENUE | Las Vegas | NV | 89150 | NULL·· | — |
| PRV | PRV-24602 | 2026-07-12T14:47:54Z | Timothy | B | Brown | 1962-05-07 | UHC-81996-24 | UNKNOWN | null | TIMOTHY.BROWN@PROTON.ME | 2918 Highland Ave | ·Charlotte | NC | 28209 | — | NULL |
| PRV | PRV-20403 | 2026-03-19T15:27:04Z | ALBERT | P | CLRK | 1977-05-15 | - | •••-••-5153 | 2532948 | albert.clark@proton.me | — | UNKNOWN | null | null | N/A | — |
| PRV | PRV-22806 | 2026-07-19T02:41:39Z | Kevin | — | Willis | 1965-03-08 | — | — | 13349820388 | N/A | 3862 Washington Street | Denver | CO | 80231 | — | — |
| PRV | PRV-23931 | 2026-08-29T09:39:49Z | Isabella | U.·· | Payne | Jun 9, 1990 | N/A | — | 930-615-1880 | — | 2458 Forest Avenue | ·Houston | TX | 77019 | — | null |
| PRV | PRV-23233 | 2026-01-02T08:18:06Z | Keith | B | Jones | 1956-01-16 | UNKNOWN | NULL | 6736730358 | KEITH.JONES50@HOTMAIL.COM | 4325 Church St | Gilbert | AZ | 85296-7217 | — | NULL |
| PRV | PRV-28133 | 2026-10-01T17:12:29Z | Brandon T | — | Bennett | 1939-08-21 | — | •••-••-1843 | 8373045542 | ·brandon.bennett29@hotmail.com | 1280 Camelback Road #719 | Tucson·· | AZ | 85732 | UNKNOWN | UNKNOWN |
| PRV | PRV-25488 | 2026-01-04T14:01:48Z | Kelly | — | Warren | 06-01-1998·· | ···· | — | 873-241-0158 | kelly.warren@outlook.com | 4879 HARBOR BLVD | Minneapolis | MN | 55421 | N/A | — |
| PRV | PRV-23199 | 2026-07-18T21:35:57Z | JOHUA | — | BROWN | 1974-08-18 | null | — | 15856525206 | joshua.brown@proton.me | 6299 Meadow Lane | Glendale | AZ | 85311 | — | - |
| PRV | PRV-22947 | 2026-07-06T06:06:30Z | ·LUIS | — | HALL | 09/26/1973 | UHC0904755·· | null | 7395664678 | LUIS.HALL19@AOL.COM | 136 OCEAN AVENUE | Columbus | OH | 43201 | — | — |
| PRV | PRV-28418 | 2026-07-30T03:30:26Z | ·Lawrence | — | Little | 1939-09-04 | — | •••-••-4325 | 258-835-4136 | N/A | 8794 HARBOR BLVD | Phoenix | AZ | 85094 | — | — |
| PRV | PRV-22776 | 2026-08-18T01:57:50Z | Santus, Timothy | S. | — | 1980-07-26 | N/A | •••-••-2661 | 9562094053·· | timothy.santos84@outlook.com | ·null | — | N/A | UNKNOWN | - | NULL |
| PRV | PRV-24373 | 2026-06-30T12:11:36Z | Doris | X | Carroll | 1985-10-24 | — | UNKNOWN | 477-602-8146 | doris.carroll@proton.me·· | 5143 Indian School Road | Dallas | TX | 75295 | N/A | - |
| PRV | PRV-20020 | 2026-05-21T11:22:56Z | JESSICA | — | LUNA | 2006-05-07 | UHC-27513-91 | — | 3832553615 | JESSICA.LUNA66@ICLOUD.COM | 3156 Sage Ct | Glendale | ·AZ | 85329 | ···· | — |
| PRV | PRV-20404 | 2026-03-16T14:51:26Z | ABLERT | — | CLARK | 19770515 | UHC-36686-91 | NULL·· | 18862532948 | albert.clark@proton.me | 7039 Apache Boulevard | Eden Prairie | MN | 55330 | — | null |
| PRV | PRV-27402 | 2026-10-16T22:43:33Z | Eric | — | Fowler | 2000-03-07 | UHC1186383 | ·UNKNOWN | 631.535.5894 | UNKNOWN | 3681 Market Street | Denver·· | CO | 80281 | NULL | UNKNOWN |
| PRV | PRV-20648 | 2026-05-01T06:30:06Z | — | — | — | 16-12-1963 | — | •••-••-3469 | ·9434918669 | null | 6990 Sunset Blvd | Dallas | TX | 75285-7350 | — | N/A |
| PRV | PRV-24039 | 2026-09-25T16:00:32Z | Bruce | — | Banks | 1983-06-21 | UNKNOWN·· | •••-••-3666 | (351) 586-0335 | BRUCE.BANKS47@ICLOUD.COM | 5040 Harbor Blvd | ATLANTA | GA | 30334 | ·N/A | MEDICARE-ADV-B·· |
| PRV | PRV-27244 | 2026-06-02T10:03:12Z | DYLAN | — | WELCH | 1956-07-05 | UHC-40221-33 | N/A | (602) 926-0546 | null | 5659 Ocean Ave | SAN DIEGO | California | 92115 | — | — |
| PRV | PRV-20494 | 2026-06-08T02:13:35Z | Eric | ·· | Wood | 1994-08-23 | UHC8995689 | — | 13518241256 | — | 6996 Canyon Rd | Denver | CO | ·80288-1471 | — | NAVIGATE-HMO |
| PRV | PRV-21447 | 2026-08-23T09:27:44Z | Carl | — | Dean | 1972-03-28 | N/A | N/A | 5768443760 | null | 9585 OAK STREET | TAMPA | FL | 33642 | - | CORE-HMO |
| PRV | PRV-20611 | 2026-01-16T19:15:04Z | Austin | — | ·Cox | 1973-03-17 | UHC-51901-82 | — | 2669825790 | — | 6963 Maple Ave | Scottsdale | ·Arizona | 85267 | — | UNKNOWN |
| PRV | PRV-20880 | 2026-01-16T06:55:16Z | ·Richardson, Jose | E | — | 27-08-1960 | N/A | - | — | — | 9388 Cedar Ln | Nashville | TN | — | N/A | navigate-hmo·· |
| PRV | PRV-23010 | 2026-10-11T23:02:29Z | SOPHIA | — | JENKINS | 19641206 | UHC-20692-63 | •••-••-4378 | 19223981116 | — | 1597 BAYSHORE DRIVE #231 | MIAMI | FL | 33141 | — | null |
| PRV | PRV-22146 | 2026-09-14T20:59:59Z | Bobby | — | Turner | 02/19/1938 | UHC-59366-90 | — | 8524179 | - | 7255 CHURCH ST | Houston | TX | 77053 | UNKNOWN | null |
| PRV | PRV-21379 | 2026-01-17T17:21:42Z | Mateo | — | Rivera | 9177-04-04 | NULL | — | (537) 447-0369 | N/A | 115 CANYON ROAD | Scottsdale | AZ | 85207-6439 | — | UNKNOWN |
| PRV | PRV-28992 | 2026-06-11T10:56:19Z | timothy·· | — | carter | 02/01/41 | UHC-21773-28 | NULL | 9864805461 | null | 405 SAGE COURT | Sacramento·· | CA | 95803-5319 | null | UNKNOWN |
| PRV | PRV-27096 | 2026-07-09T09:33:40Z | brian | — | oliver | 01/27/1950 | UNKNOWN | NULL | 4297986364 | — | 6033 BAYSHORE DR | Glendale | AZ | NULL | — | null |
| PRV | PRV-29334 | 2026-09-17T00:39:13Z | Watson, Sean | — | ···· | 06/23/1998·· | UHC-89921-87 | NULL | 19307044332 | null | 9192 Apache Boulevard | COLUMBUS | OH | 43218 | N/A | - |
| PRV | PRV-26091 | 2026-05-07T12:39:37Z | Omar | — | Guerrero | 2/11/1949 | NULL | UNKNOWN | 276-733-8359 | omar.guerrero@proton.me | 6655 CHURCH STREET | Atlanta | GA·· | 30399 | - | CHOICE-PLUS-PPO |
| PRV | PRV-24115 | 2026-05-29T04:14:50Z | deborah | R | burke | 12/12/1985 | UNKNOWN | null | (693) 581-6501 | N/A | - | — | — | UNKNOWN | N/A | MEDICARE-ADV-B |
| PRV | PRV-27595 | 2026-09-09T04:06:00Z | MARC | — | THOMPSON·· | 1996-04-15 | UHC-71607-73 | •••-••-5009 | 4012247216 | — | — | — | null | N/A | null | MEDICARE-ADV-B |
| PRV | PRV-25039 | 2026-01-24T14:22:30Z | ·DAN | — | JIMENEZ | 01/18/59 | UHC-38087-84 | — | (250) 338-5724 | — | -·· | null | N/A | — | — | — |
| PRV | PRV-26454 | 2026-09-25T02:19:12Z | Maria | — | Simpson | 2007-12-22 | UHC-29411-66 | — | ·(343) 949-4307 | NULL | — | — | — | N/A | - | null |
| PRV | PRV-25486 | 2026-02-05T08:49:52Z | Denise | J. | Armstrong | 1973-06-18 | UHC-73122-43 | null | 13074122511 | N/A | 6088 DESERT SKY BLVD·· | Miami | FL | 33183-9401 | UNKNOWN | ·null |
| PRV | PRV-28727 | 2026-06-01T18:17:54Z | brian | — | ramos | 08/15/1971 | ·null | null | 7093802338 | brian.ramos25@outlook.com | 134 MARKET ST | Fresno | California | 93714 | NULL | null |
| PRV | PRV-25153 | 2026-02-11T00:19:42Z | JUDY | L | SILVA | 13-11-1973 | — | — | 5246309303 | — | 4581 River Road | Tempe·· | AZ | 85296 | NULL | - |
| PRV | PRV-27260 | 2026-03-24T04:55:53Z | William | — | Rivera | 1971-03-13 | UHC-47674-88 | — | (512) 281-0729 | — | — | — | — | — | NULL | — |
| PRV | PRV-26220 | 2026-07-18T01:47:05Z | ·Davis, Omar | T·· | ·· | 11/19/80 | — | •••-••-5075 | ·7883665174 | - | 2400 Mountain View Drive | Nashville | TN·· | ·37241 | N/A | — |
| PRV | PRV-25613 | 2026-10-17T22:17:41Z | ASHLEY | — | BLACK | 1979-05-21 | UHC-06518-66 | •••-••-4027 | (294) 946-4773·· | ashley.black@proton.me | 9803 Harbor Boulevard | Orlando | FL | 32838·· | ···· | null |
| PRV | PRV-20607 | 2026-09-10T11:09:05Z | Kiimberly | — | Vazquez | 1971-03-08 | - | null | 2569427753 | kimberly.vazquez@aol.com | 866 Maple Avenue | Nashville | TN | 37263 | N/A | — |
| PRV | PRV-25745 | 2026-06-14T05:18:27Z | Megan | — | Thomas | Oct 14, 1998 | UHC-49695-95 | — | +1 908 549 3516 | ·null | 2120 HIGHLAND AVENUE | Dallas | TX | 75221 | UNKNOWN | ·· |
| PRV | PRV-25649 | 2026-03-08T12:42:45Z | Emily | — | Jimenez | 01/09/74 | — | UNKNOWN·· | 19217438580 | NULL | 2840 SPRING ST | Minneapolis | Minnesota | 55416 | - | — |
| PRV | PRV-25605 | 2026-02-10T19:23:48Z | JENNIFER·· | ···· | MARTINEZ | 1972-10-26 | — | ·NULL | ·396-595-9532 | — | - | — | - | UNKNOWN | — | SELECT-EPO |
| PRV | PRV-27975 | 2026-04-09T15:18:42Z | harold | — | murpy | 8/24/1948·· | UHC-22265-13 | - | 3436309579 | ···· | NULL | N/A | NULL·· | — | N/A | ·· |
| PRV | PRV-21877 | 2026-03-12T19:20:49Z | ruth | U·· | mccoy | 03-01-2001 | - | N/A | (582) 260-4573 | N/A | 1090 Maple Avenue | San Antonio | TX | 78253 | — | ·· |
| PRV | PRV-22333 | 2026-04-13T04:44:26Z | Alan | U | Patterson | 11/15/2007 | UHC-71714-83 | ···· | 18663359802 | ALAN.PATTERSON@OUTLOOK.COM·· | 5417 Baseline Road | Seattle | WA | 98140 | — | UNKNOWN |
| PRV | PRV-27090 | 2026-08-26T13:55:53Z | ·Nunez, Laura | — | — | 1969-01-27 | — | •••-••-0371 | 8584732755 | null | 3323 Harbor Boulevard Apt 1 | FRESNO | California | 93704 | — | CHOICE-PLUS-PPO |
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:42:53.737Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty