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-22757 | 2026-01-09T22:52:35Z | Ethan | H | Dixon | 1987-11-14 | UHC-82724-83 | •••-••-5066 | (362) 210-4993 | - | 7408 DESERT SKY BOULEVARD | Seattle | WA | 98143 | UNKNOWN | N/A |
| PRV | PRV-21856 | 2026-08-30T19:33:23Z | JORDAN | K | RICHARDS·· | 1964-04-15 | NULL·· | null | — | NULL | 4417 MARKET STREET | Charlotte | NC | 28204 | null | — |
| PRV | PRV-21963 | 2026-09-07T00:57:01Z | Keith | ···· | Dixon | Nov 24, 2004·· | N/A | •••-••-6339 | +1 294 585 6444 | KEITH.DIXON@PROTON.ME | 8405 Meadow Lane | Las Vegas | NV | 89176 | null | null |
| PRV | PRV-29467 | 2026-07-07T00:21:12Z | Peter | — | Marhall | 19681023 | ·· | UNKNOWN | - | — | 6560 Camelback Rd | Tampa | FL | 33646 | — | MEDICARE-ADV-B |
| PRV | PRV-26834 | 2026-06-08T14:49:28Z | Matt | — | Jordan | 05/25/64 | UHC1115875 | NULL | — | MATTHEW.JORDAN@HOTMAIL.COM | 9371 Camelback Rd | Scottsdale | AZ | 85240 | — | UNKNOWN |
| PRV | PRV-22561 | 2026-07-15T03:36:35Z | DEBRA | S | CHVEZ | 1977-11-01 | UHC-26552-93 | — | 8766771832 | debra.chavez12@aol.com | 1967 Highland Ave | Sacramento | CA | 95831 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-28072 | 2026-10-08T16:07:02Z | Michael | B | Robertson·· | Mar 7, 1983 | — | UNKNOWN | 361.784.2407 | — | 2002 Sunset Blvd | Eden Prairie | MN | 55307 | NULL | null |
| PRV | PRV-24285 | 2026-03-23T16:08:42Z | MARTHA | ·· | BELL | 1998-07-10 | UHC-16336-86 | — | 2972550745 | - | 8795 Cedar Lane | San Diego | CA | 92145 | — | NULL |
| PRV | PRV-24098 | 2026-08-01T21:45:36Z | ·Jason | — | Cooper | 1955-08-08 | UHC-89789-03 | — | 4467080607 | — | 7903 Main St #205 | PHOENIX | AZ | 85027 | NULL | NULL |
| PRV | PRV-27263 | 2026-02-02T12:10:16Z | CHRISTINA | H. | HAWKINS | 25-10-1975 | - | •••-••-7566 | 2014856966 | UNKNOWN | UNKNOWN | NULL | N/A | null | ·NULL | CORE-HMO |
| PRV | PRV-25798 | 2026-04-27T06:51:45Z | TERESA | — | WALLACE | 1965-10-17 | UHC-19584-98 | NULL | 7375253255 | null | 131 BASELINE ROAD | Tampa | FL | 33684 | — | — |
| PRV | PRV-23223 | 2026-03-24T23:51:18Z | CAMIA | Z. | ROBERTS | 1987-10-16 | UHC4820337 | UNKNOWN | 760-957-0632 | NULL·· | 95 Bayshore Dr | Scottsdale | AZ | 85288 | NULL·· | UNKNOWN |
| PRV | PRV-21863 | 2026-03-25T11:40:57Z | Brian | ···· | Hawkins | ·1978-08-10 | UHC3015073 | null | 6573612030 | null | 1350 Sage Ct | Tucson | AZ | null | — | null |
| PRV | PRV-22104 | 2026-04-13T12:06:31Z | Mateo | ·R | Kelly | ·10-07-1947 | UHC3890832 | — | 489-444-3862 | NULL | 9270 ELM ST | San Diego | California | N/A | UNKNOWN | — |
| PRV | PRV-25948 | 2026-01-13T02:56:03Z | Madison | B | Henderson | 1985-12-16 | UHC-63607-78 | ·· | 500-420-3551 | MADISON.HENDERSON@OUTLOOK.COM | 2197 Highland Ave | SAN DIEGO | CA | 92140 | — | — |
| PRV | PRV-29346 | 2026-03-06T16:52:50Z | NATALIE·· | — | NGUYEN | Aug 14, 1999 | UHC-95171-02 | UNKNOWN | 302-711-7996 | — | — | — | N/A·· | ···· | NULL | ·N/A |
| PRV | PRV-21192 | 2026-02-23T07:53:48Z | Ruth | — | McDonald | 3/4/1968 | ·UHC-22060-18 | •••-••-1986 | NULL | null | 9368 Market Street | SACRAMENTO | CA | 95876-9029 | - | N/A |
| PRV | PRV-23926 | 2026-09-09T14:33:19Z | Noah | — | Padilla | 09/20/84 | UNKNOWN | •••-••-7658 | 412-883-1061 | ·noah.padilla@outlook.com | N/A | N/A | UNKNOWN | — | NULL | — |
| PRV | PRV-29094 | 2026-04-29T02:40:36Z | Jean | X. | McCoy | 1963-12-09 | UHC-59244-39 | — | (550) 737-1454 | null | - | — | N/A | NULL | NULL | -·· |
| PRV | PRV-22381 | 2026-04-29T18:36:38Z | Marcus | Y | Scott | 2003-02-20 | UHC-58921-89 | - | (547) 567-6342 | marcus.scott@icloud.com | 2530 HARBOR BOULEVARD | Mesa | AZ | 85252·· | — | — |
| PRV | PRV-24330 | 2026-04-11T11:48:49Z | Willie | — | McCoy | 1994-10-23 | UHC-22083-44 | •••-••-3023 | ···· | NULL | 1428 Cedar Lane | Fresno | CA | 93781 | NULL·· | — |
| PRV | PRV-24501 | 2026-01-21T05:09:20Z | AMY | F. | BAKER | 1967-05-15 | - | N/A | (693) 992-1271 | — | 4115 Palm Dr | Chandler | AZ | 85223·· | null | NAVIGATE-HMO |
| PRV | PRV-20538 | 2026-03-31T20:43:50Z | MADISON | ·J. | WELCH | 12/10/1946 | UHC-40299-97·· | UNKNOWN | 5966626268 | - | 2397 Hillcrest Road | Phoenix | Arizona | 85076 | — | — |
| PRV | PRV-21781 | 2026-02-22T03:23:07Z | Amber | — | Valdez | ·19540928 | UNKNOWN | ·N/A | 7809788208 | UNKNOWN | 7773 Highland Ave | ·Miami | FL | 33103 | NULL | null |
| PRV | PRV-29209 | 2026-04-09T01:41:38Z | adrea | — | aguilar | 1971-03-17 | N/A | ···· | 286-484-7135 | — | 8116 INDIAN SCHOOL RD | Scottsdale | AZ·· | 85264 | N/A | — |
| PRV | PRV-21754 | 2026-07-03T19:12:47Z | Oliver, Helen | — | — | 1953-06-11 | UHC0929496 | UNKNOWN | 8110663 | NULL | null | N/A | — | UNKNOWN | N/A | — |
| PRV | PRV-24900 | 2026-09-09T09:36:42Z | sophia | — | guerrero | 1972-06-06 | UHC-35263-16 | NULL | 3778730768 | UNKNOWN | 1068 Grand Ave | CHARLOTTE | NC | 28226 | null | null |
| PRV | PRV-26312 | 2026-06-25T10:00:22Z | Jean | ·· | Jones | 1941-09-09·· | — | null | ·964-235-4663 | JEAN.JONES50@HOTMAIL.COM | — | — | — | - | — | — |
| PRV | PRV-25802 | 2026-07-23T17:49:27Z | Mery·· | — | Franklin | 1942-09-17 | UHC-63571-51 | — | 219.870.8516 | null | 728 Washington Street | Austin·· | TX | 78725 | NULL | NULL |
| PRV | PRV-24719 | 2026-05-15T04:09:57Z | Thomas | — | Ortiz | 1973-04-08 | UNKNOWN | ·N/A | 467-361-4795 | thomas.ortiz60@outlook.com | 5104 Cedar Lane | Las Vegas | NV | 89109 | N/A | — |
| PRV | PRV-27283 | 2026-07-07T07:06:54Z | Susan | C. | Wang | 1949-05-05 | NULL | •••-••-1430 | — | - | 7919 SAGE CT·· | Scottsdale·· | AZ | 85269 | N/A | SELECT-EPO |
| PRV | PRV-23602 | 2026-07-24T08:26:28Z | Benjamin | — | Robinson | 02-11-2006 | UHC-34560-42 | — | 2866185207 | — | 5706 Church Street | Scottsdale·· | AZ | 85295 | — | - |
| PRV | PRV-25917 | 2026-06-19T16:29:52Z | SAMEL | — | SULLIVAN | 2006-01-05 | - | •••-••-9782 | 356-534-5198 | NULL | 2208 Indian School Rd | Seattle | WA | 98182 | — | - |
| PRV | PRV-21236 | 2026-03-15T20:01:30Z | Stephen | — | Hicks·· | 03/01/2003 | UNKNOWN | null | 359-556-4090 | UNKNOWN | 2494 OAK STREET | AUSTIN | Texas | 78782 | NULL | — |
| PRV | PRV-22968 | 2026-03-03T18:12:08Z | JAMES | I. | MCDONALD | ·1959-03-20 | UHC-97198-99 | •••-••-1862 | 4352519505 | — | 209 Mountain View Drive | Fresno | CA | N/A | N/A | CORE-HMO |
| PRV | PRV-23805 | 2026-01-25T02:26:08Z | Jannet | — | Gray | 2003-04-10 | N/A | null | NULL | — | 1374 Spring Street | GLENDALE | AZ | 85378 | — | CORE-HMO |
| PRV | PRV-21953 | 2026-05-23T18:07:47Z | DONALD | ·· | TORRES | Sep 18, 1963 | UNKNOWN | - | 758-748-5754 | UNKNOWN | 4999 Jefferson Ave | Charlotte | NC·· | 28240 | — | NULL |
| PRV | PRV-23714 | 2026-07-08T03:22:14Z | Josh | — | Herrera | 3/17/1971 | — | •••-••-7389 | +1 300 274 3617 | NULL·· | 7826 MESA DRIVE | Denver | CO | 80228 | N/A | — |
| PRV | PRV-23620 | 2026-03-12T02:11:17Z | LAUREN | A | SIMS | 2007-05-19 | UHC-90640-63 | N/A | 853-724-0105 | - | 8513 Lincoln Way | Atlanta | GA | 30306-2897·· | NULL | - |
| PRV | PRV-26477 | 2026-07-14T04:27:10Z | JONATHAN | M·· | GIBSON | 1978-02-08 | UHC-88509-08 | - | 612-659-7893 | - | ·3380 Lake View Rd | SEATTLE·· | WA | — | UNKNOWN | — |
| PRV | PRV-25165 | 2026-08-23T11:16:46Z | Baker, Maria | — | — | 19720228 | ···· | •••-••-7055 | 6509038382 | - | 5242 Hillcrest Road | Nashville | TN | 37262·· | NULL | ·medicare-adv-b |
| PRV | PRV-28308 | 2026-02-15T19:30:20Z | Warren, Santiago | — | — | ·01/17/1989 | UHC-28156-54 | •••-••-4275 | 588-558-7323 | UNKNOWN·· | 5906 Pine Dr | Glendale | AZ | 85305 | — | — |
| PRV | PRV-21331 | 2026-04-07T05:05:18Z | Christopher | — | Mendez | 1967-07-10 | UHC-51704-12 | •••-••-6897 | 7709234423 | — | 2371 UNION ST | Gilbert | AZ | 85281 | UNKNOWN | — |
| PRV | PRV-21590 | 2026-02-23T07:09:53Z | Nathan | — | OBrien | 1939-09-27 | UHC-35857-33 | N/A | 9205194785 | null | 9887 Apache Boulevard | TEMPE | AZ | 85200 | N/A | NULL |
| PRV | PRV-26690 | 2026-07-16T17:51:58Z | William | — | Miller | 19980823 | — | •••-••-0351 | (406) 291-1484 | null | 1812 Bayshore Drive | Eden Prairie | MN | 55378 | N/A | N/A |
| PRV | PRV-21513 | 2026-04-10T13:15:14Z | Logan | — | Rivera | 1989-06-13 | UHC-64260-62 | N/A | 957-556-4909 | UNKNOWN | 7090 Maple Ave | Mesa | AZ | 85237 | ·N/A | NULL |
| PRV | PRV-29220 | 2026-04-29T10:22:40Z | Ryan, Lauren | — | — | 1942-09-62 | UHC-05185-18 | •••-••-8856 | 3286179340·· | — | 514 LAKE VIEW ROAD | Glendale | AZ | 85314 | UNKNOWN | ···· |
| PRV | PRV-20064 | 2026-03-27T22:05:26Z | DEBORAH | T. | MURRAY | 4/24/2003 | UHC-81038-07 | UNKNOWN | — | NULL | 3737 Baseline Rd | Scottsdale | Arizona | 85253-9027 | — | NULL |
| PRV | PRV-20948 | 2026-06-22T17:52:49Z | KEITH | — | BENNETT | 1990-50-26 | -·· | — | null | N/A | ·1922 Ocean Ave | Jacksonville | FL | 32227-9027 | — | NULL |
| PRV | PRV-26469 | 2026-02-15T23:23:33Z | Maria | — | Wells | ·2005-07-01 | UNKNOWN | UNKNOWN | (531) 858-6325 | maria.wells@aol.com | 2693 Highland Ave #966·· | Eden Prairie | MN | 55364 | - | 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:37.772Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty