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-24987 | 2026-06-06T16:19:19Z | Jean | ·Z | ·Collins | 1917-03-07 | — | UNKNOWN | — | — | 4646 MAIN ST | Tucson | AZ | 85755 | ·UNKNOWN | - |
| PRV | PRV-24448 | 2026-05-16T08:49:59Z | Scott | — | Marshall | 2006-04-02 | — | •••-••-7494 | 5498864722 | — | 728 Grand Ave | Chandler | AZ | 85223 | — | — |
| PRV | PRV-29001 | 2026-01-01T00:36:17Z | LARRY | — | HANSEN | 19990813 | — | ·NULL | +1 475 258 7529 | LARRY.HANSEN@OUTLOOK.COM·· | 5799 Union St | TUCSON | az | ·85752 | NULL | — |
| PRV | PRV-28975 | 2026-06-20T01:01:22Z | Betty | — | Griffin | 1956-00-28 | UHC-23779-75 | - | (391) 827-4461 | betty.griffin@aol.com·· | 4989 Central Avenue | Las Vegas | NV | 89163 | — | CHOICE-PLUS-PPO |
| PRV | PRV-23192 | 2026-01-18T18:18:34Z | Debra | — | Vargas | 13-12-1992 | - | •••-••-5586 | ·742-783-3185 | NULL | 7717 HILLCREST RD | TEMPE | AZ | 85269 | UNKNOWN | — |
| PRV | PRV-25444 | 2026-01-17T01:36:05Z | KENNETH | — | FISHER | 1957-09-07 | N/A | NULL | 8189970147 | null | 8808 Harbor Boulevard | Tucson | AZ | 85745 | N/A | N/A |
| PRV | PRV-23698 | 2026-09-10T06:03:13Z | DIANA | — | BROWN | 1961-08-05 | UHC-44223-69·· | — | 6417758041 | — | 4932 Oak St | Miami | Florida | 33133 | — | null |
| PRV | PRV-26990 | 2026-02-08T01:02:20Z | ·DORIS | — | BARNES | 1980-03-13 | — | - | UNKNOWN | - | 9519 Washington St | Denver | CO | 80204 | N/A | UNKNOWN |
| PRV | PRV-26061 | 2026-06-24T15:37:06Z | CATHERINE·· | — | CONTRERAS | ·1972-02-12 | UHC-37529-48 | N/A | 360.576.9314·· | CATHERINE.CONTRERAS32@HOTMAIL.COM | 8879 Grand Ave | Dallas | TX | 75291 | N/A | UNKNOWN |
| PRV | PRV-22935 | 2026-07-12T16:31:51Z | Samantha | — | Weber·· | 1989-05-20 | ·· | •••-••-4301 | (671) 663-4990 | — | 4622 Palm Dr | Sacramento | CA | 95837 | — | N/A |
| PRV | PRV-22149 | 2026-02-24T21:35:07Z | LUCIA | E. | BUTLER | 12/24/97 | UHC6494999 | •••-••-0147 | 2629085 | ·NULL | 3810 River Rd | Denver | Colorado | ·80210 | N/A·· | null |
| PRV | PRV-24840 | 2026-06-09T19:28:15Z | DEBORAH·· | — | MALDONADO | 1958-04-28 | N/A | •••-••-1985 | 839.439.2191 | ·DEBORAH.MALDONADO@HOTMAIL.COM | 904 Canyon Road | Fresno | ·CA | — | — | OPTIONS-PPO |
| PRV | PRV-24422 | 2026-09-21T10:11:37Z | Thersea | — | Harris | 1958-09-18 | UHC-49222-72 | N/A | 7336906 | — | 7303 VALLEY VIEW DRIVE | Miami | FL·· | 33145-1520 | - | — |
| PRV | PRV-27224 | 2026-03-16T13:49:01Z | ·Billy | — | Larson | 1991-03-08 | UHC-69765-55 | — | NULL | UNKNOWN·· | 2175 Mesa Drive | Austin | TX | 78780 | - | - |
| PRV | PRV-21961 | 2026-06-20T05:40:05Z | Noah | — | Nguyen | 1976-10-23 | UHC-84004-09 | N/A | +1 962 394 9341 | noah.nguyen77@gmail.com | ·2884 LAKE VIEW RD Apt 7 | Gilbert | Arizona | 85245 | null | N/A |
| PRV | PRV-25876 | 2026-01-25T02:47:15Z | Valentina | A | Estrada | 1981-09-04 | — | •••-••-8159 | (906) 789-4692 | — | 3708 RIVER RD | Nashville·· | TN | 37236 | NULL | UNKNOWN |
| PRV | PRV-23040 | 2026-05-22T20:20:25Z | Gary | — | Simpson | null | UHC-25382-23 | NULL | — | gary.simpson14@gmail.com | 963 MEADOW LN | ·Nashville | TN | 37238 | UNKNOWN | N/A |
| PRV | PRV-26276 | 2026-07-23T00:16:31Z | Emma | K. | Hayes | 1947-11-22 | UHC-08659-93 | — | (438) 618-4440·· | N/A | 7363 Cedar Ln | CHARLOTTE | North Carolina | 28215 | UNKNOWN | SELECT-EPO·· |
| PRV | PRV-25926 | 2026-10-03T07:36:42Z | Stephen | ···· | Richardson | 05/28/2001 | UHC-35712-05 | — | 435.206.5878 | — | 9587 Meadow Lane | Charlotte | NC | 28232 | ·· | — |
| PRV | PRV-28035 | 2026-01-26T05:24:05Z | Deborah | — | Perry | 1941-09-28 | UHC-90537-38 | — | (481) 608-5049 | deborah.perry19@aol.com | 1929 Oak St | FRESNO | California | 93777 | — | — |
| PRV | PRV-20206 | 2026-03-10T19:16:25Z | ALBERT | — | MORALES | 1949-06-03 | null | — | — | ···· | 4504 Lake View Rd | ·Gilbert | AZ | 85215 | NULL | -·· |
| PRV | PRV-23510 | 2026-01-18T11:52:09Z | Hamlton, Jean | W | — | 1965-02-08 | UHC7714918 | — | (416) 714-3383 | — | 4244 Oak St | Tempe | ·AZ | — | N/A | N/A |
| PRV | PRV-27554 | 2026-07-13T04:19:20Z | Bradley | — | Flures | 1978-11-17 | UHC-20706-40 | N/A | 19034300334 | UNKNOWN | 3417 INDIAN SCHOOL ROAD | Gilbert | Arizona | N/A | UNKNOWN | MEDICARE-ADV-A |
| PRV | PRV-21777 | 2026-08-24T00:48:47Z | MARK | — | FOSTER | 1939-07-22 | — | N/A | 984-626-3981 | - | 4474 SAGE COURT Apt 34 | Fresno | CA | 93713 | UNKNOWN | — |
| PRV | PRV-21531 | 2026-10-11T15:12:01Z | Camila | T.·· | Snyder | 1993-06-09 | — | — | N/A·· | UNKNOWN | 3515 WILLOW COURT | Miami | FL | 33192 | — | UNKNOWN |
| PRV | PRV-27778 | 2026-06-20T23:49:48Z | DIANA | — | CONNTRERAS | 1973-04-08 | — | — | 15289202590 | UNKNOWN | ·9178 Lake View Rd | Miami | FL | 33199 | — | UNKNOWN |
| PRV | PRV-22794 | 2026-08-19T09:05:29Z | Jess | — | Bennett | 19910502 | UHC-98542-11 | null | 9145260374 | JESSICA.BENNETT@AOL.COM | ·5439 CAMELBACK ROAD | Denver | CO | 80206 | ·· | N/A |
| PRV | PRV-26255 | 2026-01-11T17:21:18Z | Martha | — | Sullivan | 02/09/07 | UHC-67909-78 | — | (976) 687-5087 | ·martha.sullivan64@gmail.com | 4612 VALLEY VIEW DR | Denver | CO | 80254 | N/A | NULL |
| PRV | PRV-20530 | 2026-09-09T12:57:03Z | Priya | — | Bryant | 1995-09-20 | — | — | +1 969 874 4362 | null | 2965 Lake View Rd | Chandler | AZ | 85288 | - | — |
| PRV | PRV-20128 | 2026-01-10T17:18:08Z | Harold | Y. | ·Cole | 26-09-1946 | UHC-46572-82 | •••-••-6624 | 444-942-3700 | — | 5148 LINCOLN WAY | ·San Antonio | TX | 78244 | null | null |
| PRV | PRV-23664 | 2026-09-07T13:54:04Z | FRANK | — | WEST | 19-07-2008 | null | •••-••-4262 | 3652722280 | UNKNOWN·· | 9071 Cedar Ln Apt 4 | Tempe | AZ | 85266 | — | choice-plus-ppo |
| PRV | PRV-25967 | 2026-07-21T14:45:54Z | Hiroshi F | — | Little | 08-07-1951 | UHC-78883-18 | — | (655) 740-4130 | hiroshi.little73@gmail.com | 7461 Sage Ct·· | Sacramento | ·CA | ·95845 | - | — |
| PRV | PRV-26655 | 2026-06-30T17:11:35Z | Randy | — | Green | 2005-06-07 | — | null | 2489980247 | randy.green39@outlook.com | ·49 Ocean Avenue | Tempe | Arizona | 85211·· | UNKNOWN | ·SELECT-EPO |
| PRV | PRV-24549 | 2026-02-16T23:44:14Z | Long, Bryttany | — | ···· | 6/2/1978 | ·· | — | 665-747-8820 | — | 6125 Forest Avenue | TEMPE | az | 85245 | - | NAVIGATE-HMO |
| PRV | PRV-27984 | 2026-08-23T02:07:04Z | Johnston, Albert | U | — | 1961-05-09 | UHC-58242-57 | — | (554) 877-8504 | albert.johnston@icloud.com | 5512 HIGHLAND AVENUE | Tucson | AZ | 85750-9877 | — | NULL |
| PRV | PRV-26985 | 2026-07-06T17:34:05Z | Jerry | U | Young | 1989-07-01 | UHC-52799-01 | — | 2719414876 | jerry.young9@gmail.com·· | 2539 Lincoln Way | Chandler | AZ | 85294 | — | CHOICE-PLUS-PPO |
| PRV | PRV-26656 | 2026-06-29T21:37:48Z | Gloria | — | Dean·· | 1938-09-23 | null | UNKNOWN | 240-492-3032 | GLORIA.DEAN@AOL.COM | - | N/A | N/A | - | - | MEDICARE-ADV-B |
| PRV | PRV-21848 | 2026-06-14T05:33:11Z | Mason | — | Wagner | 08/16/1962 | UHC-02115-55 | — | 3182055 | — | -·· | N/A | N/A | ·null | — | null |
| PRV | PRV-26132 | 2026-05-11T18:39:57Z | Carolyn | — | Kennedy | 19480806 | UHC-02309-97 | — | 539.752.8324 | -·· | ·5655 Main St #179 | Glendale | AZ | 85336 | — | CORE-HMO |
| PRV | PRV-25711 | 2026-09-27T13:56:27Z | MEI | ·· | WEST | 19670626 | ·UNKNOWN | — | - | MEI.WEST@GMAIL.COM | NULL | NULL | — | null | N/A | - |
| PRV | PRV-21332 | 2026-07-14T04:19:09Z | George·· | — | Kim | 1946-06-06 | UHC-68057-28·· | - | (403) 378-4424 | george.kim@yahoo.com | 4350 Church Street | Denver | CO | 80236 | — | null |
| PRV | PRV-24585 | 2026-01-09T16:22:20Z | Carolyn | — | ·Fields | 11-10-1953 | — | — | 351-522-3530 | N/A | 9599 Lincoln Way | Tampa | FL | 33611 | null | — |
| PRV | PRV-28222 | 2026-03-28T14:14:12Z | brown | — | mary | 8/18/2006 | UHC-47472-45 | •••-••-4125 | (413) 798-6407 | mary.brown@aol.com | 2062 Willow Court | TAMPA·· | ·FL | 33638 | NULL | NULL |
| PRV | PRV-24471 | 2026-08-22T22:13:15Z | Frank | F. | Nelson | 1997-09-14 | — | •••-••-1902 | 6510565 | UNKNOWN | 9185 Elm St | ·CHANDLER | Arizona | 85222 | - | NULL |
| PRV | PRV-26299 | 2026-08-26T02:56:25Z | Hill, Alexis | — | — | 1952-02-12 | UHC-64036-10 | - | ·NULL | NULL | 4089 RIVER RD | Tucson·· | Arizona | 85788 | N/A | - |
| PRV | PRV-28691 | 2026-01-29T07:42:58Z | McDonald, Charles | — | — | 1940-38-24·· | ·UHC7561383 | — | null | null | — | — | UNKNOWN | NULL | N/A | - |
| PRV | PRV-27866 | 2026-09-02T07:59:54Z | Chriistian | — | ·Patel | ·19-02-1995 | N/A | •••-••-2300 | 12496531835 | NULL | 1065 MAPLE AVE | Atlanta | Georgia | 30358 | — | N/A·· |
| PRV | PRV-26751 | 2026-09-29T19:55:53Z | Benjamin | — | Brooks | 2008-12-09 | UHC-58222-55 | - | 448-916-6617 | N/A | 9416 DESERT SKY BOULEVARD | SAN DIEGO | California | UNKNOWN | N/A | NULL |
| PRV | PRV-20161 | 2026-02-05T08:15:50Z | Santiago | — | Bennett | ·19880199 | - | ·N/A | (483) 769-0416 | santiago.bennett@icloud.com | 5393 PALM DRIVE | SAN DIEGO | ca | 92142 | — | SELECT-EPO |
| PRV | PRV-21133 | 2026-01-25T16:02:34Z | JUDY | — | GOMEZ | ·1977-08-81 | UHC-18172-29·· | UNKNOWN | 940-250-4971 | ·JUDY.GOMEZ2@HOTMAIL.COM | 8411 Canyon Rd | Orlando | FL | 32840 | ···· | 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:38.499Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty