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-61533 | 2026-03-23T07:22:32Z | Mateo | — | Sims | 1959-11-11 | null | — | 954-437-2608 | — | 7841 BAYSHORE DRIVE | Phoenix | AZ | 85007 | — | — |
| TPA | TPA-58827 | 2026-06-11T23:05:48Z | Lisa | Z | Bradley | 04/28/83 | — | - | 645-850-1258 | — | 4817 Baseline Rd | ·Nashville | TN | 37263 | N/A | null |
| TPA | TPA-50834 | 2026-01-28T13:11:10Z | Albert | — | Miller | 1940-02-09 | - | null | UNKNOWN | — | 5580 HILLCREST ROAD | Orlando | FL | 32870-4188 | — | NULL |
| TPA | TPA-60798 | 2026-07-19T03:51:30Z | Eric | ···· | Castillo | 1996-03-25 | N/A | •••-••-5503 | null | N/A | 8778 Ocean Ave #605 | Minneapolis | MN | 55400 | GRP-0871 | CORE-HMO |
| TPA | TPA-56722 | 2026-02-13T16:32:18Z | Alan | — | Cole | 1941-01-04 | UNKNOWN | •••-••-9544 | — | ···· | 5628 FOREST AVE | Austin | TX | null | GRP-6191 | MEDICARE-ADV-B |
| TPA | TPA-61340 | 2026-01-29T04:46:05Z | Reyes, Aaron | — | — | 1946-09-11 | N/A | — | 240-610-6259 | aaron.reyes@hotmail.com | 7541 CANYON RD | Charlotte | NC | 28228 | GRP-1943 | N/A |
| TPA | TPA-56316 | 2026-10-01T03:47:02Z | Cheryl | — | Jacobs | 10-07-1974 | NULL | — | (835) 253-8081 | UNKNOWN | 8057 HARBOR BOULEVARD | Minneapolis | ·MN | 55439 | GRP-5660 | SELECT-EPO |
| TPA | TPA-63580 | 2026-08-22T23:41:36Z | ·Bowman, Fatima | — | — | ·Jun 8, 1989 | — | — | N/A | UNKNOWN | - | — | null | — | GRP-8357 | null |
| TPA | TPA-58175 | 2026-07-01T15:09:33Z | Roy | — | Simpson | 1956-07-16 | uhc-12089-16 | — | null | NULL | UNKNOWN | N/A | ·N/A | null | — | CHOICE-PLUS-PPO |
| TPA | TPA-52755 | 2026-01-25T21:15:08Z | NICOLE | — | SNYDER | 09-01-1950 | null | - | 436.901.8841 | - | 1353 Elm Street | Columbus | OH | 43206 | N/A | NULL |
| TPA | TPA-51610 | 2026-05-02T16:57:38Z | ANA | — | STEWART | ·1954-07-21 | - | — | — | ana.stewart@proton.me | 2654 Sunset Boulevard | Fresno | California | 93776 | N/A | SELECT-EPO |
| TPA | TPA-55907 | 2026-08-03T22:50:16Z | Abigail | — | Walker | 1944-08-21 | N/A | N/A | — | - | 9062 Ridge Rd | SACRAMENTO | CA | 95815 | GRP-8031 | NAVIGATE-HMO |
| TPA | TPA-52630 | 2026-05-05T15:15:42Z | steven | — | ortega | Mar 27, 1941 | UHC-06063-03 | — | — | N/A | — | UNKNOWN·· | NULL | UNKNOWN | — | — |
| TPA | TPA-59283 | 2026-06-17T17:04:46Z | DENNIS·· | ···· | PARK | 1948-06-15 | ·· | •••-••-0816 | 623.983.3077 | null | 5191 Ocean Avenue | ·Charlotte | NC | 28222-6983 | N/A | — |
| TPA | TPA-53809 | 2026-04-18T21:59:58Z | JERRY | — | LEE | 06/25/2002 | N/A | N/A | 7912415308 | jerry.lee22@proton.me | 8472 Main Street | Mesa | ·AZ | null | — | CORE-HMO |
| TPA | TPA-54673 | 2026-02-16T10:01:28Z | Kayla | — | ·Adams | 19600919 | - | UNKNOWN | 18122304566 | N/A | UNKNOWN | NULL | N/A | UNKNOWN | ·- | SELECT-EPO |
| TPA | TPA-60432 | 2026-07-29T04:05:44Z | JERRY | — | YOUNG | 1989-07-01 | — | N/A | — | N/A | 2539 Lincoln Way | Chandler | AZ | 85294 | N/A | — |
| TPA | TPA-55565 | 2026-02-19T22:52:59Z | Jesse | ·· | Morgan | 10/11/46 | UHC-62080-24 | N/A | (896) 535-2730 | NULL | ·5089 Indian School Rd | Denver | Colorado | 80289 | GRP-7532 | N/A·· |
| TPA | TPA-58952 | 2026-04-03T00:08:08Z | Gomez, Kayla | — | — | 1981-07-08 | NULL | •••-••-3016 | — | null | 8000 LAKE VIEW RD | PLANO | TX | 75012 | null | - |
| TPA | TPA-59592 | 2026-01-21T12:38:09Z | Wei | — | Lawrence | 1949-01-10 | NULL | NULL | null | — | 2144 MAIN STREET·· | Atlanta | GA | 30343 | — | MEDICARE-ADV-B |
| TPA | TPA-62516 | 2026-09-04T03:09:42Z | Scott | — | Medina | 03/06/38 | — | null | N/A | scott.medina31@yahoo.com | 637 Spring St | Orlando | ·FL | 32855 | — | — |
| TPA | TPA-51493 | 2026-02-09T17:00:56Z | Anthony | N | Salazar | 2004-01-25 | — | UNKNOWN | N/A | — | 3940 Hillcrest Road | Plano | Texas | 75007-4343·· | GRP-6882 | null |
| TPA | TPA-55393 | 2026-02-01T07:42:50Z | doris | — | mills | NULL | — | — | (848) 514-7047 | N/A | - | UNKNOWN | — | NULL | NULL | ·- |
| TPA | TPA-58606 | 2026-08-16T14:44:59Z | Owens, Kathryn | — | — | 1998-02-24 | - | ···· | 8044125741 | — | 9096 Elm St | Jacksonville | FL | 32220 | null | NULL |
| TPA | TPA-51191 | 2026-08-22T15:15:12Z | GARY | — | ·MARTIN | 1975-05-19 | UNKNOWN | UNKNOWN | - | NULL | - | NULL | null | null | null | NAVIGATE-HMO |
| TPA | TPA-53452 | 2026-06-17T09:40:26Z | thomas | — | day | 1955-03-09 | UHC-43689-23 | ·· | - | N/A | 990 Sunset Blvd | Gilbert | AZ | 85268 | N/A | ·· |
| TPA | TPA-62929 | 2026-03-28T06:44:13Z | ·SOFIA | — | ALVAREZ·· | 1970-01-10 | - | •••-••-7418 | — | sofia.alvarez@aol.com | 3305 MESA DRIVE | Orlando·· | FL | 32802 | — | NULL |
| TPA | TPA-54038 | 2026-04-21T23:33:31Z | Elliott, Cynthia | B | — | 2007-09-02 | null | — | null | UNKNOWN | 9248 Sage Ct | SAN ANTONIO | ·TX | 78200 | NULL | OPTIONS-PPO |
| TPA | TPA-56291 | 2026-02-26T02:28:15Z | Gerald Q | — | Nguyen | 1995-06-26·· | UNKNOWN | •••-••-4030 | (927) 237-5570 | NULL | 1542 GRAND AVENUE | Miami | FL | ·33167 | — | ·- |
| TPA | TPA-57420 | 2026-01-05T00:49:05Z | SANDRA | — | HOFFMAN | 1969-10-27 | - | null | NULL | UNKNOWN | - | — | UNKNOWN | — | GRP-2091 | — |
| TPA | TPA-51149 | 2026-01-06T03:59:18Z | ALAN | — | JACBS | N/A | — | UNKNOWN | (364) 578-7610 | - | — | N/A | - | — | GRP-1565 | ·· |
| TPA | TPA-58790 | 2026-06-08T07:39:42Z | Davis, Wayne | — | — | 19560525 | UNKNOWN·· | — | null | ·· | N/A | null | N/A | NULL | - | NULL |
| TPA | TPA-51240 | 2026-03-31T20:47:45Z | Coleman, Wayne | — | — | 1961-12-22 | UHC-27015-08 | •••-••-2659 | — | null | 691 Grand Ave | Tampa | FL | ·33621 | N/A | NULL |
| TPA | TPA-56809 | 2026-02-17T20:26:31Z | Hawkins, Katherine | — | — | 2002-12-12 | ·null | •••-••-9277 | NULL | ·UNKNOWN | 7014 Valley View Dr | Austin | Texas | ·78788 | null | NULL |
| TPA | TPA-59328 | 2026-01-23T14:44:25Z | RALPH | ···· | WANG | 1952-06-03 | NULL | •••-••-6174 | null | — | ·7240 Grand Avenue | Atlanta | Georgia | 30344 | UNKNOWN | SELECT-EPO |
| TPA | TPA-53278 | 2026-06-04T11:11:41Z | barbara | M | estrada | Sep 28, 1942 | UHC-62835-15 | UNKNOWN | 444-474-9446 | barbara.estrada@yahoo.com·· | 5846 Highland Ave | GLENDALE | az | 85303-9874 | GRP-8658 | NAVIGATE-HMO |
| TPA | TPA-51919 | 2026-01-28T04:56:54Z | Ralph | — | Fuller | 1960-12-07 | UHC-80671-65 | — | +1 856 249 3207 | null | 4024 Market St | Tempe | AZ | 85241 | — | MEDICARE-ADV-B |
| TPA | TPA-51643 | 2026-05-28T11:18:32Z | cheryl | — | collins·· | 1973-08-10 | — | •••-••-9198 | N/A | cheryl.collins45@proton.me | 4864 Jefferson Ave | Nashville | TN | 37244 | ·- | UNKNOWN |
| TPA | TPA-56110 | 2026-07-04T22:16:50Z | Eugene | — | Evans | 09/28/1975 | - | •••-••-9208 | ·(511) 302-9399 | — | ·9216 Main St | EDEN PRAIRIE·· | ·MN | 55338-5427 | NULL | N/A |
| TPA | TPA-59425 | 2026-08-28T15:02:12Z | DAVID | — | HILL | 2/17/1969 | UNKNOWN | — | UNKNOWN | null | 2886 Mountain View Drive | SAN DIEGO | CA | 92173 | — | SELECT-EPO·· |
| TPA | TPA-57875 | 2026-06-22T02:39:03Z | Andrea | — | Carter | 1968-01-14 | — | NULL | null | NULL | 589 Bayshore Drive | HOUSTON | Texas | 77082 | — | OPTIONS-PPO |
| TPA | TPA-57876 | 2026-06-05T01:19:09Z | Kennedy, Joan | — | ·· | 1999-02-03 | null | — | null | - | 1032 Highland Ave | Minneapolis | MN | null | - | N/A |
| TPA | TPA-51986 | 2026-06-05T18:52:06Z | Douglas | — | Gilbert | 10/23/1994 | — | - | N/A | DOUGLAS.GILBERT@GMAIL.COM | 7249 MARKET STREET | San Antonio | TX | 78216 | null | NULL |
| TPA | TPA-52796 | 2026-10-02T13:09:53Z | Brcue | R | ·Jacos | 4/21/1950 | N/A | — | 2109894072 | bruce.jacobs@gmail.com | 6148 Sunset Blvd | TUCSON | AZ | 85723 | GRP-9840 | NAVIGATE-HMO |
| TPA | TPA-51996 | 2026-02-04T18:19:36Z | Arthur | — | Freeman | 1957-12-26 | ·- | - | ·UNKNOWN | UNKNOWN | 4412 Forest Avenue | Tucson | AZ·· | 85789 | GRP-4238 | CHOICE-PLUS-PPO |
| TPA | TPA-61955 | 2026-09-24T22:08:56Z | brittany | — | watson | 1971-04-25 | UHC-75844-21 | null | 3348380907·· | — | 3073 MARKET ST | SACRAMENTO | ca | 95874 | GRP-3967 | N/A |
| TPA | TPA-54824 | 2026-05-15T03:00:38Z | JOSHUA | — | BROWN | 1974-08-18 | — | ·null | null | JOSHUA.BROWN@PROTON.ME | ·6299 Meadow Lane Apt 27 | Glendale | AZ | 85311 | null | SELECT-EPO |
| TPA | TPA-56189 | 2026-09-19T19:15:44Z | Fatima | — | Boyd | 1985-07-28 | — | NULL | 17457946116 | null | 7311 SAGE COURT·· | Fresno | CA | 93791 | ···· | - |
| TPA | TPA-60147 | 2026-05-01T20:39:11Z | KAREN | — | GREEN | 1953-06-27 | — | •••-••-3796 | ·16726132324 | NULL | 1578 Camelback Rd | Dallas | TX | 75298 | GRP-6062 | SELECT-EPO |
| TPA | TPA-53297 | 2026-01-10T17:59:00Z | JEFFREY | — | JENSEN | 8/17/1965 | UNKNOWN | N/A | — | jeffrey.jensen85@aol.com | ·6869 Willow Ct | Tempe | AZ | 85287 | ···· | 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:36.718Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty