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-28756 | 2026-09-29T14:04:30Z | Jesse | — | Spencer | 2001-01-15 | UHC-70831-73 | •••-••-9760 | (518) 868-1866 | — | 7662 Camelback Road | Tempe | AZ | 85246·· | — | OPTIONS-PPO |
| PRV | PRV-27653 | 2026-05-08T12:44:17Z | KEVIN·· | H | ORTEGA | ·09-11-1950 | - | NULL | — | — | 7358 Oak Street | Houston | TX | 77057 | N/A | — |
| PRV | PRV-26434 | 2026-04-16T14:27:42Z | Carl | F | Santos | NULL | - | null | 3092747997 | ·carl.santos6@outlook.com | 967 VALLEY VIEW DRIVE | Tempe | Arizona | 85227·· | — | — |
| PRV | PRV-24607 | 2026-06-02T21:30:45Z | SOFIA | — | CARPENTER | 12/27/54 | UHC-23990-07 | NULL | 972.789.5012 | sofia.carpenter5@proton.me | 204 Ocean Avenue Apt 9 | Dallas | TX | 75271 | N/A | — |
| PRV | PRV-22411 | 2026-02-07T03:27:21Z | Alice | P | Wang·· | 1938-03-05 | UHC1978363 | — | +1 766 688 2633 | ·UNKNOWN | 9104 River Road | Austin | TX | 78739 | — | — |
| PRV | PRV-28522 | 2026-04-26T18:38:46Z | MARTHA | — | HERRERA | 1956-06-01 | UHC-70389-89 | NULL | (322) 967-0616 | martha.herrera@hotmail.com | 1696 Park Pl | LOS ANGELES | CA | 90054-5212 | null | — |
| PRV | PRV-20552 | 2026-09-04T16:00:12Z | CATHERINE·· | J | BISHOP | 19671017 | — | - | +1 262 891 6417 | null | 513 OCEAN AVENUE | Tempe | AZ | ·85221 | - | MEDICARE-ADV-A |
| PRV | PRV-23554 | 2026-01-16T20:09:07Z | JOHN | Z | ARMSTRONG | 2003-06-27 | — | •••-••-2656 | (211) 724-8758 | — | ·143 SUNSET BOULEVARD | Glendale | AZ | 85360 | N/A | UNKNOWN |
| PRV | PRV-22280 | 2026-03-06T21:10:05Z | ROBERT | — | WEBER | 1982-03-12 | UHC-94741-69 | -·· | — | UNKNOWN | 5930 MAPLE AVE | Chandler·· | Arizona | 85270·· | null | ·NULL |
| PRV | PRV-25937 | 2026-08-21T02:00:02Z | KAYLA | K. | TURNER | Oct 22, 1968 | — | •••-••-0512 | (225) 482-5712 | — | NULL | null | UNKNOWN | — | UNKNOWN | null |
| PRV | PRV-25551 | 2026-10-12T05:57:55Z | Austin | — | Smith | 2006-09-13·· | UHC9597184 | •••-••-1072 | ·null | austin.smith@outlook.com | 8639 LINCOLN WAY | Jacksonville·· | FL·· | 32272 | NULL | MEDICARE-ADV-B |
| PRV | PRV-20655 | 2026-06-04T08:32:33Z | Russell | — | Wood | 19580817 | UHC-18978-12 | — | 650-459-1886 | — | 667 LAKE VIEW ROAD | Phoenix | Arizona | 85043 | UNKNOWN·· | — |
| PRV | PRV-21872 | 2026-03-23T06:40:18Z | Maria | — | Marquez | 1967-08-01 | ·UHC-91326-09 | null | 3512180185 | NULL | 8371 SPRING ST | ATLANTA | GA | 30325 | — | NULL |
| PRV | PRV-24423 | 2026-05-27T13:20:49Z | ·Henry | — | Barnes | Nov 18, 1982 | UHC-94540-32 | - | 7015156130 | — | UNKNOWN | UNKNOWN | — | N/A | UNKNOWN·· | — |
| PRV | PRV-26358 | 2026-02-15T23:39:39Z | GEORGE | X | ROBINSON | 1999-01-11 | UHC-33174-40 | null | 9589138536 | george.robinson48@hotmail.com | 4700 HIGHLAND AVENUE | Miami | FL | 33160·· | ·NULL | — |
| PRV | PRV-23059 | 2026-02-05T11:22:45Z | Rachel | — | Walker | 1941-06-28 | N/A | N/A | NULL | — | ·6112 Elm Street | Gilbert | AZ | 85267 | - | — |
| PRV | PRV-28387 | 2026-10-17T18:16:11Z | Megan | — | Morgan·· | 09/07/97 | — | N/A | null | ·UNKNOWN | 9294 Lake View Road | Tempe | AZ | 85252-8588 | — | N/A |
| PRV | PRV-22412 | 2026-08-03T21:50:44Z | Jennifer | M.·· | Hernandez | Apr 16, 1993 | — | UNKNOWN | 509-240-9310 | null | 2179 PINE DR | Los Angeles | CA·· | 90073 | — | — |
| PRV | PRV-25934 | 2026-09-19T23:30:35Z | wei | — | walker | 1976-05-14 | UHC-30724-80 | - | 7004052828 | UNKNOWN | 9780 RIVER RD | Dallas | Texas | 75270 | - | — |
| PRV | PRV-23879 | 2026-05-27T19:02:15Z | jeremy | — | romero | 11/14/1954 | ···· | — | (346) 787-1225 | UNKNOWN | 4322 Bayshore Drive | Sacramento | CA | 95834 | — | ···· |
| PRV | PRV-22230 | 2026-07-06T18:46:49Z | Samantha | — | Greene | Sep 2, 1976 | UHC-56755-08 | UNKNOWN | (227) 926-1166 | samantha.greene@icloud.com | 1516 HIGHLAND AVENUE | SAN DIEGO | CA | 92151 | N/A | — |
| PRV | PRV-21900 | 2026-02-02T11:21:10Z | judy | — | hughes | 1983-06-14 | UHC-26972-28 | N/A | 740-985-5473 | — | 2731 FOREST AVENUE | Gilbert | AZ | 85239 | — | — |
| PRV | PRV-24543 | 2026-01-19T21:35:36Z | PHILIP | E | MARQUEZ | 1996-12-05 | NULL | — | 499.387.2619 | — | 875 BROADWAY | Seattle | wa | 98117 | — | - |
| PRV | PRV-28385 | 2026-09-22T13:05:16Z | Keith | O | Tran | 1998-05-08 | - | - | +1 812 276 3352 | ·UNKNOWN | 8577 Highland Avenue | Fresno | CA | 93722 | — | — |
| PRV | PRV-26474 | 2026-04-14T11:54:48Z | ·Donald | — | Griffin | 1954-05-14·· | — | ·· | 13372760907 | null | 3360 Mountain View Dr | Austin | TX | 78704 | - | MEDICARE-ADV-A |
| PRV | PRV-27327 | 2026-06-04T16:05:03Z | Alice | V | Butler | 1984-01-25 | UHC-00725-73 | •••-••-8963 | (855) 325-6161 | ALICE.BUTLER60@ICLOUD.COM | 7764 Main Street | Austin | TX | 78749 | — | UNKNOWN |
| PRV | PRV-20075 | 2026-04-20T17:23:44Z | MADISON | H | BOYD | 09-10-1997 | - | null | 495-763-1430 | MADISON.BOYD@YAHOO.COM | 5761 CENTRAL AVE Apt 32 | Nashville | TN | 37230 | — | UNKNOWN |
| PRV | PRV-22055 | 2026-03-08T18:45:23Z | Donna | B | Padilla | 10/28/51 | — | -·· | — | DONNA.PADILLA98@AOL.COM | 6322 Bayshore Drive | Sacramento | CA | 95875 | — | — |
| PRV | PRV-20422 | 2026-06-18T06:49:57Z | Angela | I·· | Hawkins | 1940-08-24 | UHC-86812-10 | NULL | 5688248155 | angela.hawkins73@aol.com | 975 LINCOLN WAY | Minneapolis | MN | 55432 | null | null |
| PRV | PRV-27971 | 2026-10-18T01:06:37Z | LAUREN | V | ·HOFFMAN | 7/25/1940 | UHC-16769-64·· | — | 3378889 | lauren.hoffman99@aol.com | 1201 Meadow Ln | Jacksonville | FL | 32203-5641 | ·- | — |
| PRV | PRV-27739 | 2026-08-22T15:59:46Z | Stephen | — | Morrison | 1999-05-03 | UHC-09325-93 | •••-••-9789 | 665-497-8473 | — | 141 INDIAN SCHOOL RD | Las Vegas | NV | 89145 | NULL | N/A |
| PRV | PRV-27515 | 2026-10-12T02:20:10Z | GRACE | — | ARMSTRONG | 1959-03-16·· | NULL | — | 8696162345 | grace.armstrong32@yahoo.com | 6118 SAGE CT | Scottsdale | az | 85288 | — | NULL |
| PRV | PRV-21869 | 2026-02-02T03:33:56Z | dorothy | — | rose | 11/5/1979 | UHC-42865-97 | — | (781) 580-0226 | -·· | 1083 MARKET ST | Fresno | CA | 93779 | — | NULL |
| PRV | PRV-29360 | 2026-02-15T21:20:16Z | Kevin·· | — | Mitchell | 1962-07-27 | null | null | ·3749794017 | KEVIN.MITCHELL58@HOTMAIL.COM | ·661 Valley View Dr | Dallas | TX | 75223 | N/A | — |
| PRV | PRV-23025 | 2026-06-03T11:39:13Z | ·Lauren | — | Young | 1984-01-17 | null | UNKNOWN | null | lauren.young@proton.me | 9538 Main Street | Eden Prairie | MN | 55361·· | - | UNKNOWN |
| PRV | PRV-27969 | 2026-08-17T05:56:59Z | Kelly·· | Z | Perez | N/A | null | NULL | ·5128188724 | KELLY.PEREZ90@HOTMAIL.COM·· | 8643 Lincoln Way | Sacramento | CA·· | — | null | CORE-HMO·· |
| PRV | PRV-21269 | 2026-01-31T04:35:01Z | Moreno, Scott·· | — | — | 10/06/84 | ·- | — | 8098523632 | - | 3320 Cedar Ln | Dallas | TX | 75245 | — | — |
| PRV | PRV-24850 | 2026-05-11T01:25:19Z | Albert | — | Danieels | 1954-05-11 | UHC-88907-28 | NULL | N/A | N/A | 5558 Oak Street | TAMPA | FL | 33681 | — | ·NULL |
| PRV | PRV-24284 | 2026-08-10T08:27:07Z | ·SANDRA | — | SOTO | 01-10-2001 | UHC-82070-02 | •••-••-9162 | 2129714286 | sandra.soto@proton.me | 9307 Mesa Dr | Denver | CO | 80280 | - | SELECT-EPO |
| PRV | PRV-23528 | 2026-03-03T00:00:14Z | LAURA | ·I | CLARK | 12/25/03 | UHC2111484 | NULL | 7105808930 | laura.clark@outlook.com | 5815 GRAND AVE | Fresno | CA | 93710 | UNKNOWN | UNKNOWN |
| PRV | PRV-22634 | 2026-09-19T03:39:02Z | Kathryn | — | Bailey | 1952-03-04 | NULL | N/A | N/A | KATHRYN.BAILEY@AOL.COM | null·· | — | — | - | NULL | MEDICARE-ADV-A |
| PRV | PRV-22195 | 2026-04-21T09:26:12Z | Barbara | — | ·Gibson | 2001-09-07 | N/A | — | 249.247.0431 | ·- | ·2335 WILLOW COURT | Gilbert | AZ | 85288-1456 | — | null |
| PRV | PRV-20913 | 2026-10-13T15:28:15Z | VINCENT | — | BROOKS | 1946-11-09·· | — | — | 428.290.3653 | VINCENT.BROOKS@AOL.COM·· | — | ·N/A | UNKNOWN | NULL | - | null |
| PRV | PRV-20257 | 2026-09-04T06:36:56Z | albert | ·· | hanson | ·1940-03-10 | UHC-65216-04 | N/A | N/A | albert.hanson33@outlook.com | 7146 CENTRAL AVENUE | Seattle | WA | 98191 | null | NULL |
| PRV | PRV-22657 | 2026-04-27T16:10:16Z | Anthony | — | Jackson | 1944-11-05 | UHC-65660-68 | •••-••-7930 | 9219517579 | UNKNOWN | 561 Main St | LOS ANGELES | California | 90035 | — | ·· |
| PRV | PRV-21137 | 2026-04-07T23:45:26Z | Jesse | — | Ryan | ·25-11-1984 | — | null | 5747534802 | — | 1048 MESA DR | GLENDALE | AZ | 85303 | — | NULL |
| PRV | PRV-25710 | 2026-08-06T02:28:30Z | Nicole | — | Fuller | 19640203 | UHC-31812-89 | N/A·· | (355) 830-6285 | N/A | 9697 OCEAN AVENUE | Orlando | ·FL | 32847 | ·N/A | UNKNOWN |
| PRV | PRV-21548 | 2026-08-25T07:52:17Z | ·ROBERT | — | HOFFMAN | 03/22/85 | - | UNKNOWN | 527-651-7126 | null | 17 Palm Dr | Mesa | AZ | 85243 | — | — |
| PRV | PRV-22990 | 2026-08-13T15:13:31Z | Watkins, Ronald | I | — | 20080626 | N/A | — | 19492320415 | — | 21 Washington St | ·FRESNO | ca | 93792 | - | — |
| PRV | PRV-27015 | 2026-08-06T00:12:17Z | CARLOS | — | JENSEN | 06/19/1988 | UHC-53640-66 | UNKNOWN | — | — | 5801 CANYON RD·· | Tucson | AZ | 85700 | NULL | CORE-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:56.129Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty