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-24946 | 2026-08-10T18:05:04Z | KIMBERLY | L | PAYNE | 04/07/1942 | UHC-83579-91 | null | 932.314.1309 | — | 4517 Bayshore Dr | Jacksonville | FL | 32253 | — | — |
| PRV | PRV-28155 | 2026-04-27T05:10:12Z | DONNA | — | ·RAMOS | 1995-10-06 | uhc-64152-85 | - | 782-723-6431 | ·donna.ramos17@hotmail.com | 7499 Baseline Road | Tempe | AZ | 85278 | — | NAVIGATE-HMO |
| PRV | PRV-26122 | 2026-05-14T13:53:18Z | JANET | — | PRICE | 1971-08-18 | — | null | 9793164552 | JANET.PRICE@GMAIL.COM | NULL | — | NULL | NULL | — | N/A |
| PRV | PRV-22092 | 2026-05-23T20:45:53Z | Stephen | — | Parker | 19960810 | UHC-23565-74 | null | — | — | 272 Church Street | TUCSON | Arizona·· | 85744 | — | — |
| PRV | PRV-28872 | 2026-04-04T04:53:58Z | Ana | G | Kelly | 1984-10-08 | — | N/A·· | 651-831-7698 | ·ana.kelly@aol.com | 8504 Willow Ct | Charlotte·· | NC | 28212·· | — | SELECT-EPO |
| PRV | PRV-20713 | 2026-05-14T17:11:30Z | Bobby | — | Park | 1979-02-20 | — | NULL | (284) 764-6550 | N/A | 3122 PARK PLACE | Nashville | TN | 37230 | UNKNOWN | ···· |
| PRV | PRV-24489 | 2026-08-20T22:49:07Z | Walsh, Betty | — | ·· | 1988-09-04 | - | •••-••-2068 | - | N/A·· | 3850 Maple Ave | Sacramento | CA | 95804 | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-24055 | 2026-08-21T01:29:42Z | JULIE | ···· | LI | 1986-01-24 | — | NULL | 931-274-6436 | julie.li80@outlook.com | 2088 Ocean Avenue | Miami | FL | 33136 | — | ·· |
| PRV | PRV-29185 | 2026-06-27T21:20:16Z | ·Peter | ·P. | Roberts | 2009-09-12 | UHC-81497-96 | - | UNKNOWN | peter.roberts95@proton.me | 1031 Grand Ave | Plano | TX | 75042 | UNKNOWN | null |
| PRV | PRV-25762 | 2026-07-03T11:33:59Z | JACOB·· | — | JACOBS·· | Jan 6, 2002·· | — | •••-••-9476 | (212) 356-3818 | N/A | 2374 Jefferson Avenue | Columbus·· | OH | 43296 | — | N/A·· |
| PRV | PRV-28720 | 2026-02-21T19:14:12Z | Ruth | — | Holmes | 3/6/1960 | UNKNOWN | •••-••-6003 | (742) 318-3301 | — | UNKNOWN | null | NULL | UNKNOWN | — | — |
| PRV | PRV-24971 | 2026-09-17T17:49:38Z | Carol | — | Hansen | 2000-06-19 | UHC-25657-98 | - | - | carol.hansen@outlook.com | ·4776 Bayshore Drive | Jacksonville·· | FL | 32282 | null | CORE-HMO |
| PRV | PRV-24811 | 2026-06-22T13:18:28Z | Theresa | — | Hawkins | ·2007-04-19 | UHC-64409-76 | •••-••-3240 | 459.243.7844 | N/A | 9763 CENTRAL AVENUE | Austin | TX | 78741 | — | NULL |
| PRV | PRV-26328 | 2026-06-09T15:23:39Z | PETER | ···· | FERGUSON | 1948-03-25 | — | ·· | (400) 418-5678 | — | 1560 Central Avenue·· | Houston | TX | 77066 | — | NULL |
| PRV | PRV-25217 | 2026-03-09T23:02:15Z | OLIVIA | — | OWES | 1991-09-11 | - | NULL | (941) 526-2112 | — | 275 Oak Street | Jacksonville | FL | 32248 | — | — |
| PRV | PRV-25176 | 2026-08-02T21:21:54Z | Joyce K | — | Snyder·· | Jan 7, 1961 | UHC-38342-05 | •••-••-6007 | 678-253-9977 | joyce.snyder@yahoo.com | 7991 MEADOW LANE | Glendale | AZ | 85350 | N/A | UNKNOWN |
| PRV | PRV-27713 | 2026-04-17T23:21:07Z | joe | S. | mills | 1948-12-08 | — | UNKNOWN | (845) 708-7300 | - | 2003 MOUNTAIN VIEW DRIVE #463 | Miami | FL·· | 33167 | UNKNOWN | — |
| PRV | PRV-23955 | 2026-09-11T14:20:14Z | Patricia | E. | Greene | 1965-08-26 | — | — | 7617988670 | — | 4374 Canyon Rd | ·NASHVILLE | TN | 37259-4507 | null | — |
| PRV | PRV-20906 | 2026-01-11T05:37:46Z | Joyce | ·· | Hunt | 2068-19-83 | — | - | 12477112906 | joyce.hunt90@icloud.com | 2307 Sage Court | Phoenix | AZ | 85069 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-21686 | 2026-09-07T04:37:45Z | Emily | — | Bradley | 2005-11-03 | UHC-18201-75 | — | (231) 205-6743 | UNKNOWN·· | 1546 Bayshore Dr | Chandler | AZ | 85239 | — | — |
| PRV | PRV-21090 | 2026-08-15T13:43:16Z | donna | — | hughes | 1994-12-11 | UHC-61161-67 | •••-••-8453 | (820) 864-5508 | — | ·5811 DESERT SKY BOULEVARD | Columbus·· | oh | — | null | ·· |
| PRV | PRV-26932 | 2026-09-09T02:30:12Z | Eugene | — | Harper | 1961-01-04 | ·NULL | UNKNOWN | 7052485267 | null | 787 Baseline Road | Dallas | ·TX | 75286 | — | — |
| PRV | PRV-20903 | 2026-08-15T14:24:31Z | Mary | U. | Daniels | 09/15/69 | ·N/A | N/A | (326) 242-6146 | — | 3406 MARKET STREET | Denver | Colorado | 80259 | NULL | — |
| PRV | PRV-25003 | 2026-07-18T02:23:04Z | Michelle | — | Chavez | 1992-04-26 | UHC3697940·· | null | +1 764 418 0305 | — | 5832 Sunset Boulevard #499 | Scottsdale | ·AZ | 85288 | — | CORE-HMO |
| PRV | PRV-21289 | 2026-04-17T20:01:37Z | HENRY | ·Y. | LITTLE | 1979-03-06 | UNKNOWN | •••-••-2406 | 14777783428 | - | 6925 Hillcrest Road | Plano | TX | — | UNKNOWN | — |
| PRV | PRV-28040 | 2026-01-21T21:19:12Z | Richards, Adam | — | — | 2008-09-20 | — | UNKNOWN | ·(776) 455-7343 | N/A | 1893 Sage Court | Miami | FL | 33111 | — | N/A |
| PRV | PRV-26295 | 2026-03-29T23:15:24Z | Carolyn | ···· | Park | 1956-12-06 | UHC0426459 | — | (552) 555-1251 | — | 2140 Union Street | Scottsdale | AZ | 85248 | - | N/A |
| PRV | PRV-21772 | 2026-01-11T03:50:12Z | Debra | — | Collins | 1980-11-19 | UHC8601085 | — | (678) 495-2922·· | NULL | ···· | N/A | UNKNOWN | N/A | — | NAVIGATE-HMO |
| PRV | PRV-21020 | 2026-06-18T09:15:43Z | Kenneth | — | Gomez | 1985-03-06 | ·UHC-06126-03 | null·· | (931) 494-3332 | ·null | 6290 Hillcrest Road | Gilbert | AZ | 85261 | — | — |
| PRV | PRV-20555 | 2026-02-14T16:49:06Z | OBRIEN | — | VALENTINA | 06/13/65 | UHC-50153-59 | •••-••-9746 | 857.841.2143 | null | NULL·· | NULL | - | null | - | choice-plus-ppo |
| PRV | PRV-28103 | 2026-07-08T03:06:12Z | Ray | — | Phillips | 1/28/1995 | — | — | 4037341297 | raymond.phillips@yahoo.com | 1479 Baseline Rd·· | GLENDALE·· | AZ | 85314 | NULL | NULL |
| PRV | PRV-27587 | 2026-01-23T21:17:03Z | Freeman, Eugene | ·· | — | 1961-12-23 | NULL | — | 8543837439 | eugene.freeman57@gmail.com | 5162 Lincoln Way | SCOTTSDALE | az | 85251 | - | — |
| PRV | PRV-24844 | 2026-01-25T07:13:57Z | Arthur | — | Wagner | 06/18/54 | UHC-89496-41 | N/A | +1 580 272 0480 | ·arthur.wagner@proton.me | 6277 Spring St | Tempe | az | 85224 | N/A | N/A |
| PRV | PRV-29048 | 2026-04-19T00:35:23Z | PATRICIA | — | KING | 06/23/67 | UHC-26700-94 | — | 4872781868 | patricia.king89@hotmail.com | 5936 Willow Ct | Dallas | TX | 75246 | — | - |
| PRV | PRV-21264 | 2026-03-21T20:08:07Z | Matthew | — | White | 19730219 | ·UHC-78331-45 | N/A | N/A | matthew.white35@icloud.com·· | 8059 VALLEY VIEW DR·· | Gilbert | az·· | 85224 | — | MEDICARE-ADV-A |
| PRV | PRV-23757 | 2026-05-26T23:51:48Z | Heather | — | ·Pierce | 1975-03-11 | NULL | ·- | +1 896 968 1540 | UNKNOWN | 1540 Maple Avenue Apt 11 | San Antonio | TX | ·78253 | — | — |
| PRV | PRV-26043 | 2026-03-18T20:57:22Z | Kayla | — | Pena | 1969-01-04 | UHC-82931-02 | UNKNOWN·· | ·7610808 | — | 6436 Ridge Road | ·Atlanta | GA | 30308 | null | CHOICE-PLUS-PPO |
| PRV | PRV-21301 | 2026-06-01T01:36:19Z | Jose | E | McDonald | 7/13/1985 | UHC-98359-06 | - | (519) 989-7721 | — | 3515 UNION STREET | ·San Antonio | TX | 78273 | — | - |
| PRV | PRV-25123 | 2026-04-03T15:15:49Z | Brittany | — | ·Aguilar | 16-11-2000 | - | NULL | (748) 264-4177 | N/A | — | N/A | — | — | UNKNOWN | null |
| PRV | PRV-21981 | 2026-06-20T13:47:36Z | GLORIA | — | STONE | 4/3/1965 | N/A | •••-••-3166 | (486) 337-6974 | UNKNOWN | - | — | NULL | N/A | - | — |
| PRV | PRV-21001 | 2026-02-16T18:09:16Z | ·Thomas | — | Fowler | 1998-02-20 | uhc-84561-07 | — | 13234559978 | — | 4295 Lincoln Way | CHANDLER | AZ | 85237 | — | — |
| PRV | PRV-28511 | 2026-08-30T02:54:23Z | Walter | — | Payne·· | 4/8/1960 | — | N/A·· | (749) 670-1442 | WALTER.PAYNE99@AOL.COM | 1587 Camelback Rd | Tempe | AZ | ·85229 | — | — |
| PRV | PRV-26156 | 2026-06-09T16:16:28Z | Diego | ···· | Matthews | 1938-12-01 | UHC-11271-69 | -·· | 15157312831 | - | 4858 Mountain View Drive | TUCSON | AZ·· | 85708-0798 | UNKNOWN·· | — |
| PRV | PRV-20606 | 2026-03-26T06:28:08Z | RANDY | D | BARNES | 2000-03-03 | UHC1973093 | — | (240) 899-1504 | - | 429 Union Street | HOUSTON | Texas | 77094 | - | — |
| PRV | PRV-23896 | 2026-03-18T09:22:53Z | Martinez, Linda | — | — | 1949-11-21·· | — | NULL | 642-238-9030 | — | — | UNKNOWN | null | NULL | null | — |
| PRV | PRV-29340 | 2026-07-05T03:50:24Z | ·maria | — | moore | 8/7/1952·· | UHC-35971-23 | null | +1 206 966 3752 | maria.moore@icloud.com | 3317 Lincoln Way | Atlanta | GA | 30369 | UNKNOWN | — |
| PRV | PRV-24478 | 2026-06-23T14:30:43Z | Ben | — | Ford | 1980-12-26 | UHC8324350 | •••-••-2338 | 315-710-6711 | null | 2760 Broadway | Orlando | FL | 32825 | NULL | - |
| PRV | PRV-28293 | 2026-06-30T10:08:05Z | GREGORY | — | CRUZ | 1974-01-27 | - | ·· | (986) 584-3553 | — | 5351 Market St | JACKSONVILLE | FL | 32255·· | - | — |
| PRV | PRV-22717 | 2026-08-11T12:22:57Z | Sandra | — | Fox | 1971-01-19 | — | •••-••-7161 | +1 235 287 5157·· | — | 8751 Washington Street | Las Vegas | NV | 89156 | - | — |
| PRV | PRV-22242 | 2026-03-01T15:47:41Z | Hannah | — | Clark | 1981-05-15 | UHC-95602-29 | — | 6819926218 | hannah.clark4@outlook.com | 2713 Jefferson Ave | Fresno | California | 93737 | UNKNOWN | NAVIGATE-HMO |
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.720Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty