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
Third-party administrator only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TPA | TPA-54358 | 2026-07-17T03:26:17Z | Espinoza, Herny | — | — | 1959-07-26 | NULL | •••-••-0232 | 354-670-1432 | ·- | 1745 Church St | Austin | tx·· | 78795 | GRP-5548 | ·· |
| TPA | TPA-58249 | 2026-08-28T21:09:42Z | Gray | — | Brown | 01/24/1950·· | — | null | - | — | 5247 Jefferson Avenue #286 | Tucson | AZ | 85789 | — | — |
| TPA | TPA-61386 | 2026-04-28T02:38:30Z | amy | — | ruuiz | 20050411 | NULL | — | 2073820208 | NULL | 347 Indian School Rd | Gilbert | Arizona | 85269 | ·GRP-4631 | NAVIGATE-HMO |
| TPA | TPA-53923 | 2026-03-30T15:59:07Z | Brandon | — | Hanson | 11/20/58 | UNKNOWN | •••-••-6046 | 16632974563 | — | 5096 MESA DR | ·LOS ANGELES | California·· | UNKNOWN | GRP-3633·· | CHOICE-PLUS-PPO |
| TPA | TPA-52212 | 2026-08-27T10:53:00Z | Michelle | — | Smith | 2003-05-10 | null | N/A | UNKNOWN·· | NULL | 5366 Main St·· | FRESNO | California | 93769 | GRP-9198 | — |
| TPA | TPA-53893 | 2026-07-16T10:02:42Z | Noah | — | Salazar | Mar 3, 1994 | — | •••-••-2783 | 9539753018 | N/A | 5710 Maple Avenue·· | Jacksonville | FL | 32270 | — | CHOICE-PLUS-PPO |
| TPA | TPA-60939 | 2026-07-15T02:17:42Z | MARIA | — | MEYER | 2004-07-12 | — | — | 922-978-3918 | — | 5396 Union St | MIAMI | FL·· | 33105 | null | UNKNOWN |
| TPA | TPA-50838 | 2026-09-22T03:29:11Z | Kyle | ···· | Phillips | 19-08-1964 | - | N/A | — | — | 4114 Cedar Lane | Chandler | AZ | 85235 | GRP-7078 | SELECT-EPO |
| TPA | TPA-60457 | 2026-01-17T17:51:23Z | Gloria | — | Miller | 1950-12-10 | — | — | 770-840-1543·· | gloria.miller@gmail.com | 58 FOREST AVE | PLANO | TX | 75023 | null | — |
| TPA | TPA-56374 | 2026-10-15T08:15:51Z | STEVEN | — | FULLER | 1977-02-14 | ·UHC-48850-17 | •••-••-0842 | null | — | 9564 Mountain View Dr | CHANDLER | AZ·· | 85292 | — | N/A |
| TPA | TPA-50207 | 2026-10-12T20:38:45Z | ANDREA | ···· | JORDAN | 1938-12-18 | — | •••-••-0260 | — | — | 9521 Ocean Avenue | Fresno | CA | 93755 | N/A | null |
| TPA | TPA-59026 | 2026-08-29T16:29:25Z | Diego | ···· | Jimenez | 2005-03-07 | NULL | •••-••-7130 | — | diego.jimenez@hotmail.com | 6107 Palm Dr | Houston | TX | 77097-7685 | GRP-1007 | SELECT-EPO |
| TPA | TPA-52474 | 2026-01-20T15:42:40Z | MIKE | — | WARD | 1943-01-07 | — | ···· | — | — | 7019 Spring Street | San Antonio | Texas | 78263 | — | - |
| TPA | TPA-60262 | 2026-06-08T06:42:35Z | Evelyn | — | Palmer | 01/03/1956 | — | null | 5335273349 | NULL | — | UNKNOWN | — | — | GRP-2603 | UNKNOWN |
| TPA | TPA-57640 | 2026-03-05T09:28:47Z | JAMES | D | GARRETT | 19610217 | ·· | — | +1 588 903 1339 | UNKNOWN | 7858 SPRING ST | Sacramento | CA | ·NULL | NULL | — |
| TPA | TPA-54925 | 2026-02-28T23:14:08Z | GAABRIEL | — | CASTILLO | 01-10-1990 | UHC-46808-96 | UNKNOWN | — | - | 1163 Church St | Plano | TX | 75066 | GRP-7105 | ·UNKNOWN |
| TPA | TPA-64382 | 2026-03-10T00:28:22Z | PAMELA | — | FRANKLIN·· | 1977-06-13 | null | - | (916) 714-3901 | UNKNOWN | 8256 PINE DRIVE | ·San Antonio | TX·· | 78223 | GRP-3605 | null |
| TPA | TPA-64171 | 2026-09-27T16:54:00Z | Carolyn | — | Gonzalez | 10/04/07 | - | •••-••-6968 | NULL | — | — | — | ·UNKNOWN | — | — | — |
| TPA | TPA-59386 | 2026-09-04T01:50:40Z | ELIJAH | — | CLARK | 03/23/1966 | UHC-01209-61 | •••-••-5760 | — | — | 3071 Oak St | CHANDLER | AZ | 85295 | null | N/A |
| TPA | TPA-51943 | 2026-03-24T15:39:15Z | emily | — | hicks | 09/02/1990 | UNKNOWN | •••-••-7151 | — | — | 207 Camelback Road | Seattle | WA | ·98112 | ·null | — |
| TPA | TPA-58794 | 2026-02-22T03:47:13Z | Arjun | — | Jones | 19-06-1979 | N/A | — | — | arjun.jones@hotmail.com | 5653 Spring St | Mesa | AZ·· | 85223 | UNKNOWN | — |
| TPA | TPA-51318 | 2026-03-28T16:49:23Z | Kimberly | — | ·Parker | 2002-12-14 | UNKNOWN | •••-••-0955 | (881) 676-8176 | KIMBERLY.PARKER9@PROTON.ME | ·· | N/A | UNKNOWN | N/A·· | ·· | OPTIONS-PPO |
| TPA | TPA-57863 | 2026-09-28T05:20:08Z | AMY | — | FERGUSON | 1944-01-22 | UHC-39422-02 | — | 206-889-5002 | null | 3896 Camelback Road #655 | Tucson | AZ | null | ·GRP-1224 | UNKNOWN·· |
| TPA | TPA-50131 | 2026-05-03T00:05:14Z | James | — | Romero | 8/19/1992 | UHC-88315-39 | null | NULL | N/A | 2891 Sunset Blvd·· | DALLAS | TX | 75283 | GRP-8547 | — |
| TPA | TPA-50692 | 2026-07-25T09:34:21Z | Mei | — | Sullivan | ·1949-12-19 | UHC-32594-17 | — | (716) 424-4082 | — | N/A | null | — | N/A·· | null | SELECT-EPO |
| TPA | TPA-58415 | 2026-07-16T18:57:08Z | Mei | — | Singh | 1995-02-07 | N/A | — | 845-511-3448 | NULL | — | - | N/A | null | null | NULL |
| TPA | TPA-61627 | 2026-08-28T19:19:35Z | Andrea | — | Hawkins | 03-03-1975 | null | •••-••-0027 | ·- | — | null·· | N/A | NULL | - | — | NULL |
| TPA | TPA-54687 | 2026-07-12T13:09:21Z | ·robertson | M. | ahmed | 1973-04-27 | - | •••-••-1019 | 16092877561 | — | ·· | ·- | — | N/A | UNKNOWN | CHOICE-PLUS-PPO·· |
| TPA | TPA-55053 | 2026-08-19T22:13:44Z | Martha | — | Ellis | Dec 9, 1950 | UNKNOWN | - | UNKNOWN | null | 2887 Highland Avenue | Charlotte | nc·· | 28292-1925 | null | — |
| TPA | TPA-60290 | 2026-03-15T05:34:26Z | JACOB | — | ·CRUZ | 19640627 | UNKNOWN | — | (973) 299-1035 | JACOB.CRUZ@PROTON.ME | NULL | — | null | UNKNOWN | NULL | N/A |
| TPA | TPA-57941 | 2026-07-26T08:11:20Z | CARL·· | N·· | VALDEZ | Feb 3, 1964 | — | null | NULL | CARL.VALDEZ@YAHOO.COM | ·6049 Forest Ave | ATLANTA | Georgia | 30380 | UNKNOWN | CORE-HMO |
| TPA | TPA-53997 | 2026-09-24T01:51:35Z | NICOLE | — | PHILLIPS | 19560711·· | UNKNOWN | - | — | nicole.phillips@hotmail.com | 6579 Central Ave | TUCSON | AZ | 85754 | null | NULL |
| TPA | TPA-58648 | 2026-01-30T11:13:01Z | Aisha | — | ·Hoffman | 1939-04-24 | - | — | — | UNKNOWN | 341 SAGE COURT | San Diego | CA | 92111-0455 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-62635 | 2026-01-31T07:28:44Z | Ana | — | Carr | ·1981-08-17 | — | N/A | ·(589) 837-3919 | NULL | 3689 Pine Dr | LOS ANGELES | CA | 90074·· | null | — |
| TPA | TPA-51803 | 2026-02-12T00:04:15Z | maria | X. | allen | ·12/08/1963 | NULL | — | (801) 201-5427 | MARIA.ALLEN@AOL.COM | 4502 Hillcrest Rd | Phoenix | AZ | 85052 | - | MEDICARE-ADV-B |
| TPA | TPA-54775 | 2026-07-14T16:18:57Z | WAYNE | — | BENNETT | ·19-04-1949 | NULL | — | null | - | ·4620 Baseline Road | Columbus | OH | 43225 | — | N/A |
| TPA | TPA-53270 | 2026-07-30T15:58:22Z | ANN | — | SULLIVAN | 19920826 | - | •••-••-4115 | 9422849100 | UNKNOWN | 4276 Desert Sky Boulevard | Glendale | AZ | 85391·· | null | — |
| TPA | TPA-50706 | 2026-04-10T15:37:59Z | Diego | — | Mills | 19940421 | - | •••-••-2553 | - | diego.mills@proton.me | null | null | UNKNOWN | - | NULL | NULL |
| TPA | TPA-59201 | 2026-06-19T13:26:59Z | Pamela | — | Arnold | ·19731119 | null | UNKNOWN | 2399355420 | null | 1082 MAPLE AVE·· | San Diego | ca | 92184 | — | MEDICARE-ADV-A |
| TPA | TPA-57211 | 2026-06-27T10:04:44Z | Black, Laura | — | — | 1958-12-07 | null | •••-••-2326 | — | - | 3594 Washington St | HOUSTON | TX | 77092-5464 | - | N/A |
| TPA | TPA-57785 | 2026-02-27T08:46:45Z | JOSH | — | SNYDER·· | 1948-08-20 | — | UNKNOWN | (863) 517-3380 | — | 2793 Desert Sky Boulevard | Atlanta | GA | 30380 | — | MEDICARE-ADV-B |
| TPA | TPA-63775 | 2026-09-24T18:49:43Z | virginia·· | — | fernandez | 06/03/73 | — | UNKNOWN | — | — | 3072 Ocean Avenue | Jacksonville | FL | 32215 | null | N/A |
| TPA | TPA-56459 | 2026-08-27T20:05:11Z | Santiago | ·· | Wong | 1981-08-16 | — | null | — | — | 7006 Mesa Dr | Jacksonville | Florida | 32243 | null | — |
| TPA | TPA-60332 | 2026-08-15T22:35:57Z | DAVID | — | WOODS | ·1938-05-26 | - | •••-••-1067 | null | DAVID.WOODS80@ICLOUD.COM | 1578 Union St | Nashville | TN | 37211 | null | UNKNOWN |
| TPA | TPA-54200 | 2026-05-29T11:05:28Z | AISHA | — | STEPHENS | 04/17/1996·· | — | — | 706-504-4094 | aisha.stephens@gmail.com | 2778 Valley View Dr | Minneapolis | MN | ·55435 | GRP-5913 | ·· |
| TPA | TPA-62617 | 2026-07-01T14:36:34Z | Henry | — | Hunter | 1946-09-13 | N/A | •••-••-1528 | — | henry.hunter@aol.com | — | - | — | ·N/A | NULL·· | — |
| TPA | TPA-63939 | 2026-02-26T05:38:00Z | Christian | — | Hnry | 1946-10-11 | ·UHC6083889 | •••-••-4678 | - | NULL | 1252 JEFFERSON AVENUE | Scottsdale | AZ | 85203 | — | — |
| TPA | TPA-53040 | 2026-06-04T00:38:50Z | MELISSA | C. | SALAZAR | 4/25/1994 | NULL | N/A | N/A | — | 8316 Apache Blvd | SACRAMENTO | California | 95885 | - | UNKNOWN |
| TPA | TPA-54737 | 2026-07-18T23:03:05Z | Flores, Raymond | — | — | 2007-11-09 | — | — | — | ·RAYMOND.FLORES58@ICLOUD.COM | ·147 Apache Boulevard | Eden Prairie | MN | 55357 | GRP-6350 | — |
| TPA | TPA-51197 | 2026-05-06T23:34:29Z | Dorothy | — | Ward | 1/18/1951 | — | NULL | 8963014926 | - | ·1415 Camelback Rd | Chandler | AZ | 85276 | — | — |
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.132Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty