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-63232 | 2026-04-27T08:48:05Z | Katherine | Q | Stephens | 1973-12-22 | null | •••-••-7619 | — | NULL | 7018 Valley View Drive | Mesa | AZ | UNKNOWN | GRP-7315 | — |
| TPA | TPA-53796 | 2026-06-24T11:25:26Z | Ketherine | — | Williamson | 8/27/1999 | null | NULL | NULL | — | 6785 Sunset Blvd | Tucson | Arizona | null | ···· | — |
| TPA | TPA-61659 | 2026-05-27T13:05:59Z | PAUL | — | ESTRADA | 1981-06-25 | - | ·N/A | null | NULL | -·· | ···· | - | null | null | - |
| TPA | TPA-50478 | 2026-04-05T02:53:59Z | HIROSHI | — | HERNANDEZ | 11/21/1961 | ·· | N/A | N/A | — | 1528 Central Avenue | Chandler | AZ | - | UNKNOWN | null |
| TPA | TPA-56164 | 2026-09-06T00:05:29Z | LUIS | — | WALKER | 19800617 | UNKNOWN | — | — | — | NULL | — | ·· | — | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-51202 | 2026-09-26T05:30:59Z | Luis | W | Wallace | 0204-91-39 | - | •••-••-4201 | — | ·null | 6713 Main Street | Columbus | OH | 43232 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-58274 | 2026-08-09T09:21:56Z | Paul | — | White | Mar 22, 1995 | — | •••-••-4893 | 913-868-4896 | — | 3950 ELM STREET | Seattle | WA·· | 98132-9851 | GRP-0726 | — |
| TPA | TPA-61113 | 2026-05-09T15:09:56Z | MARY | — | SMITH | 1945-00-79 | - | — | 569-265-6792 | UNKNOWN | 1344 Apache Boulevard·· | Austin | TX | 78704 | GRP-5726 | - |
| TPA | TPA-62410 | 2026-07-26T17:18:55Z | JOSHUA | — | WALLACE | 1951-01-01 | — | — | - | JOSHUA.WALLACE7@HOTMAIL.COM | 8108 Ocean Ave | LAS VEGAS·· | NV | 89114 | NULL | N/A |
| TPA | TPA-62247 | 2026-09-20T01:49:34Z | FRANCES | ···· | HAWKINS | ·Jan 24, 1946 | UNKNOWN·· | •••-••-5476 | - | - | 1252 Cedar Ln | FRESNO | CA | ·93711 | GRP-0831 | N/A |
| TPA | TPA-57950 | 2026-05-10T22:55:29Z | MITCHELL | — | — | 1971-03-02 | null | N/A | - | UNKNOWN | 9358 Jefferson Avenue Apt 37 | ·DENVER | CO | 80204 | GRP-4438 | — |
| TPA | TPA-58832 | 2026-04-24T12:39:28Z | MARGARET | ···· | BAILEY | 26-01-1954 | — | — | — | MARGARET.BAILEY@OUTLOOK.COM | - | null | NULL | UNKNOWN | UNKNOWN | — |
| TPA | TPA-50835 | 2026-05-22T13:00:37Z | CHRISTOPHER | — | THOMPSON | 1978-06-23 | UHC-09795-33 | N/A | NULL | CHRISTOPHER.THOMPSON@PROTON.ME·· | 3057 Bayshore Drive | Columbus | OH | - | GRP-5317 | MEDICARE-ADV-A |
| TPA | TPA-58505 | 2026-06-20T09:27:37Z | SHARON | — | PERRY | 1953-02-19 | — | •••-••-0936 | ·· | — | 5356 Spring St | Denver | co | 80211·· | GRP-6474 | navigate-hmo |
| TPA | TPA-51918 | 2026-05-02T21:52:59Z | bradly | — | marquez·· | 02-05-2003 | N/A | •••-••-0013 | 7013052868 | bradley.marquez89@hotmail.com | 7375 Lake View Road | Chandler | AZ | 85254 | UNKNOWN | NULL |
| TPA | TPA-55375 | 2026-05-10T15:11:24Z | Boyd, Wayne | — | — | 1960-05-01 | — | •••-••-2458 | - | — | — | — | NULL | — | GRP-8488 | — |
| TPA | TPA-63469 | 2026-02-27T18:45:11Z | evelyn | — | hudson | 07-06-1989 | NULL | — | UNKNOWN | — | 1021 Grand Avenue | Plano | TX | 75034 | UNKNOWN | — |
| TPA | TPA-53864 | 2026-01-22T23:01:27Z | JOHN | — | — | ·1998-09-14 | UNKNOWN | — | UNKNOWN | N/A | 8543 PINE DR | TAMPA | FL | 33642 | - | NULL·· |
| TPA | TPA-60860 | 2026-06-30T17:33:16Z | Larry | — | Bure | 3/5/1966 | UNKNOWN | N/A | 530-352-5883 | — | 1576 BROADWAY | Orlando | FL | 32853 | NULL | - |
| TPA | TPA-60841 | 2026-05-19T09:32:34Z | Joyce | — | Bradley | 1952-04-01 | null | •••-••-2290 | 903.565.4587 | null | — | null | — | — | ···· | null |
| TPA | TPA-58391 | 2026-08-07T08:22:22Z | HELEN | — | GUZMAN | 19870519 | - | •••-••-8033 | — | UNKNOWN | 7313 Maple Avenue | Plano | Texas | 75031 | null | SELECT-EPO |
| TPA | TPA-59524 | 2026-05-17T07:56:14Z | Pamela | Q | Grant | 1949-06-15 | - | - | — | null | 6343 MAPLE AVENUE | ·Denver | CO | 80235-8750 | N/A | null |
| TPA | TPA-58286 | 2026-02-03T22:31:07Z | JUSTIN | — | MRATINEZ | ·07-09-1958 | UHC-20070-18 | •••-••-8362 | 681.930.3791 | N/A | — | — | NULL | — | GRP-0475 | NAVIGATE-HMO |
| TPA | TPA-59488 | 2026-08-18T20:12:40Z | DIANA | — | VAZQUEZ | 1993-07-23 | — | UNKNOWN | N/A | diana.vazquez@proton.me | 5173 RIVER RD | Jacksonville | FL | 32292 | GRP-1046 | — |
| TPA | TPA-54544 | 2026-04-28T03:45:14Z | Lisa | — | Daniels | 1948-04-20 | ·· | null | N/A | — | 420 LINCOLN WAY | Dallas | TX·· | 75216 | ·GRP-4260 | - |
| TPA | TPA-64065 | 2026-06-06T20:49:40Z | White, Lisa | — | — | 1939-07-16 | N/A·· | ·null | UNKNOWN | ·· | 6103 Hillcrest Road | Tucson | AZ | 85768-2955 | - | — |
| TPA | TPA-63633 | 2026-05-08T11:05:47Z | Katherine | — | Gonzalez | 1958-10-26 | — | •••-••-0768 | null | N/A | 3627 Highland Ave | Tampa | FL | 33637 | - | NAVIGATE-HMO |
| TPA | TPA-61608 | 2026-09-11T18:09:03Z | CAMILA | — | ·CHEN | 1977-01-12·· | UNKNOWN | - | (416) 684-0302 | ···· | 130 Harbor Blvd | Glendale | AZ | 85327 | NULL·· | - |
| TPA | TPA-59768 | 2026-03-12T12:35:24Z | RICHARD | ·· | SCHULTZ | 1960-09-04 | NULL·· | - | 676.572.2649 | NULL | 3637 Union Street | Tempe | AZ | 85264 | - | UNKNOWN |
| TPA | TPA-50997 | 2026-02-18T11:34:58Z | Ralph | — | Woods | 1967-07-26 | NULL | null | ···· | UNKNOWN | 6887 Spring St | Tampa | FL | 33671 | GRP-9120 | — |
| TPA | TPA-55063 | 2026-09-15T02:15:27Z | ·lucia | — | bailey | 1938-08-26 | UNKNOWN | - | — | LUCIA.BAILEY@AOL.COM·· | 5146 MEADOW LN | Plano | Texas | 75054 | GRP-4492 | — |
| TPA | TPA-58211 | 2026-10-04T01:52:26Z | Debra | — | Ortega | 1998-11-09 | NULL | — | — | UNKNOWN | — | — | null | UNKNOWN | — | — |
| TPA | TPA-60510 | 2026-05-21T13:21:07Z | Mason | — | Ros | 1980-07-07 | null | — | 705-245-7259 | - | 8660 Central Ave | Houston | TX | 77095 | - | MEDICARE-ADV-B |
| TPA | TPA-54694 | 2026-04-04T17:47:08Z | ·Brandon | Q | Armstrong | 1959-11-13 | — | •••-••-4269 | N/A | — | 2641 Apache Blvd | Denver | CO | 80281 | null | NULL |
| TPA | TPA-58154 | 2026-05-31T04:24:40Z | jonathan | — | phillips | 1973-02-12 | N/A | UNKNOWN | 922-548-4648 | - | 984 Union Street | Tempe | AZ | 85206 | GRP-6734 | CHOICE-PLUS-PPO |
| TPA | TPA-58701 | 2026-07-30T02:48:14Z | SARA·· | — | WAGNER | 1946-04-23 | UNKNOWN | •••-••-9414 | 494.288.6252·· | null | 9658 HIGHLAND AVE | Minneapolis | MN | — | null | NULL |
| TPA | TPA-55645 | 2026-08-05T01:59:49Z | WILLIAM | — | BLACK | 1967-03-21 | null | ·N/A | NULL | — | 5405 Sunset Boulevard Apt 12 | Jacksonville | FL | 32243 | — | OPTIONS-PPO |
| TPA | TPA-59941 | 2026-05-15T04:55:01Z | Isabella | — | Brooks | 07-11-1939 | NULL | •••-••-0410 | 7987376320 | - | UNKNOWN | NULL | NULL | null | GRP-1474 | — |
| TPA | TPA-52951 | 2026-10-05T18:18:42Z | Wayne | — | Elliott | 1944-06-02 | — | - | 491.663.4304 | N/A | 2609 Central Ave | TUCSON | AZ | 85726-6795 | — | OPTIONS-PPO |
| TPA | TPA-61269 | 2026-03-24T03:16:42Z | Nancy | P | Vega | 20000212 | N/A | •••-••-7944 | 6715120415 | - | 9590 HIGHLAND AVE | Tampa | FL | 33679 | null | — |
| TPA | TPA-56041 | 2026-02-09T12:50:36Z | ·Adam | — | Snyder | 1964-09-27 | UHC-25891-48 | null | — | — | null | — | N/A | null | GRP-5672 | UNKNOWN |
| TPA | TPA-52418 | 2026-02-25T12:06:53Z | Grace | ···· | Ramos | 1989-10-27 | — | null | N/A | ···· | 8508 Maple Ave | Minneapolis | mn | — | — | CHOICE-PLUS-PPO |
| TPA | TPA-57084 | 2026-07-15T00:58:14Z | Megan | — | Diaz | 1959-07-04 | — | •••-••-0794 | null | - | 6636 MARKET ST | PLANO | TX | 75098·· | NULL | - |
| TPA | TPA-63501 | 2026-09-09T20:21:24Z | janice | — | chen | 1960-03-01 | NULL | — | 385-580-1421 | ·JANICE.CHEN5@YAHOO.COM | 2548 Union St | Sacramento·· | CA | 95892 | GRP-6383 | - |
| TPA | TPA-61695 | 2026-05-12T01:06:22Z | Michael·· | ·· | Schmidt | 2004-10-28 | - | N/A | +1 579 956 6239 | null | 7258 Harbor Blvd | Dallas | Texas | 75268 | UNKNOWN | null |
| TPA | TPA-63184 | 2026-06-09T07:18:58Z | JASON | — | ORTEGA | 1996-12-07 | UHC4811072 | •••-••-6066 | N/A | — | N/A | UNKNOWN | NULL | null | UNKNOWN | - |
| TPA | TPA-53138 | 2026-02-08T10:12:53Z | STEPHANIE·· | — | ROBERTS | 10/01/45 | — | - | UNKNOWN·· | N/A | UNKNOWN | ·N/A | UNKNOWN | — | NULL | NAVIGATE-HMO |
| TPA | TPA-59679 | 2026-08-12T12:47:53Z | CYNNTHIA | — | JENKINS | Jul 15, 1996 | — | — | — | NULL | 3297 Ridge Road | San Antonio | Texas | N/A | GRP-4706 | NAVIGATE-HMO |
| TPA | TPA-58725 | 2026-01-30T21:13:36Z | Jose | — | Chavez | 4/27/1960 | — | N/A | — | - | 8383 Sage Ct | Scottsdale | AZ | 85277 | - | MEDICARE-ADV-B |
| TPA | TPA-51620 | 2026-10-10T07:51:58Z | Charles | — | Bryaant | 1941-02-14 | — | N/A | 3836539595 | - | 5600 BASELINE ROAD | SAN ANTONIO | TX·· | 78237 | GRP-4748 | N/A |
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-19T19:54:25.439Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty