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-64289 | 2026-05-03T23:07:48Z | Amanda | — | Yang | 1941-10-25 | UNKNOWN | •••-••-0259 | 257-522-3460 | — | 7632 Pine Drive | Dallas | TX | 75255 | ·- | MEDICARE-ADV-B |
| TPA | TPA-59954 | 2026-05-06T08:53:02Z | betty | — | cox | 01/01/44 | ·N/A | UNKNOWN | — | NULL | 3527 Central Ave | JACKSONVILLE | FL | 32275 | — | MEDICARE-ADV-B |
| TPA | TPA-55360 | 2026-04-29T03:44:07Z | Lori | — | Foster | 1982-11-06 | - | — | — | LORI.FOSTER@ICLOUD.COM | ·N/A | — | null | — | null | ·- |
| TPA | TPA-52000 | 2026-08-19T02:36:44Z | Joyce | ···· | Roberts | 1989-04-18 | — | UNKNOWN | null·· | null | 7877 Meadow Ln | Gilbert | AZ | 85221 | — | SELECT-EPO·· |
| TPA | TPA-58479 | 2026-10-07T14:00:19Z | Williamson, Kenneth | — | — | 2005-08-17 | N/A | N/A | NULL | kenneth.williamson89@aol.com | 2871 Lake View Rd | Seattle | WA | 98135-8819 | — | null |
| TPA | TPA-60279 | 2026-09-07T19:51:00Z | jonathan | — | burke | 1994-02-09 | — | •••-••-7461 | UNKNOWN | - | 2114 Spring St | Dallas | ·TX | — | N/A | ···· |
| TPA | TPA-52573 | 2026-03-30T10:38:45Z | ETHAN | ·· | LEE | 19950501 | null | N/A | — | NULL·· | 999 Church St | ·Mesa | AZ | 85219·· | — | - |
| TPA | TPA-53084 | 2026-10-05T00:41:24Z | Janet | — | McDonald | 05-06-1982 | N/A | ·NULL | 397.533.7165 | - | 5152 SUNSET BLVD·· | Tempe | AZ | 85297 | ···· | - |
| TPA | TPA-50036 | 2026-04-17T17:40:29Z | Austin | O | Aguilar | 1993-07-28 | ·· | — | null | — | 3665 River Road | Los Angeles | CA | 90049-8393 | — | NULL |
| TPA | TPA-59637 | 2026-03-15T15:26:40Z | BEVERLY | — | VASQUEZ | 01/13/1980 | — | •••-••-5735 | 2784063649 | — | 3211 Meadow Ln | DENVER | CO | 80216 | GRP-1181 | — |
| TPA | TPA-51859 | 2026-09-07T17:08:16Z | Fuller, Nick | — | — | 08-02-1983 | UHC-17681-49 | •••-••-7616 | null | — | 4462 Sage Ct | LAS VEGAS | NV | 89144 | GRP-8651 | - |
| TPA | TPA-58338 | 2026-01-27T16:45:11Z | ·Evans | — | Joseph | 1997-07-02 | UNKNOWN | •••-••-3863 | — | JOSEPH.EVANS@YAHOO.COM·· | 7198 OAK ST | Tempe | AZ | 85236 | GRP-4953 | NAVIGATE-HMO |
| TPA | TPA-55290 | 2026-06-29T08:28:21Z | ·BRITTANY | — | DIAZ·· | 19740308 | null | — | 327-691-2675 | — | 4481 Ocean Ave | San Antonio | Texas | 78234 | GRP-0560 | NULL |
| TPA | TPA-60669 | 2026-08-16T01:40:35Z | PETER | — | WELLS | 05/19/46 | — | •••-••-9910 | NULL | — | 2917 MESA DR | Miami | Florida | 33128 | - | CORE-HMO |
| TPA | TPA-55414 | 2026-08-07T12:54:35Z | JNICE | — | COOK | 1946-04-28 | UNKNOWN | ·NULL | ·- | UNKNOWN | — | NULL | N/A | N/A | GRP-9179 | null |
| TPA | TPA-59816 | 2026-10-04T16:20:16Z | LINDA | — | ROSS | Jun 14, 1969·· | — | •••-••-0937 | — | N/A | 9275 Ridge Rd | Chandler | AZ | 85246 | ···· | UNKNOWN |
| TPA | TPA-53986 | 2026-10-11T02:36:16Z | Truner, Jacqueline·· | E. | — | 11/12/00 | UHC-69964-16 | N/A | NULL | NULL | 898 LINCOLN WAY | Austin | TX | 78789 | — | ·· |
| TPA | TPA-63250 | 2026-03-01T18:21:00Z | Li, Carolyn | ·· | — | Jul 28, 1947 | N/A·· | — | null | NULL | 6525 Highland Avenue | Nashville | TN | 37205 | N/A·· | — |
| TPA | TPA-56842 | 2026-02-24T13:45:50Z | BEVERLY | — | HUNTER | 1996-11-15 | — | null | N/A | — | UNKNOWN | — | — | N/A | - | — |
| TPA | TPA-55649 | 2026-05-16T21:23:53Z | Ryan | — | Grant | 1989-09-27 | UHC-15044-36 | NULL | 740-436-3040 | — | 6174 Valley View Drive | Tucson | AZ | 85708-5407 | GRP-4283 | - |
| TPA | TPA-59994 | 2026-04-05T04:17:07Z | Elizabeth | — | ·Estrada | 1985-01-04 | — | — | null·· | — | 4614 Church St | San Antonio | TX | ·78249 | ···· | null·· |
| TPA | TPA-63076 | 2026-03-08T07:47:32Z | DOROTHY | — | GRAY | 09/19/01 | — | •••-••-4721 | — | ·N/A | 1611 Market Street #488 | Denver | CO | null | UNKNOWN | null |
| TPA | TPA-61073 | 2026-07-20T11:41:24Z | Jacob | — | Green | 1976-06-19 | — | •••-••-7300 | — | ·· | 1279 Sunset Blvd | Los Angeles | CA | 90003-8224 | ·GRP-3888 | UNKNOWN |
| TPA | TPA-60672 | 2026-07-07T09:00:41Z | Stephanie | — | Porter | 1974-01-20 | N/A·· | null | - | N/A | ·3850 Jefferson Ave | Los Angeles | California | 90086 | — | MEDICARE-ADV-B |
| TPA | TPA-53103 | 2026-01-06T21:59:49Z | Ralph | ···· | Daniels | 7/7/2001 | — | N/A | UNKNOWN | null | 3822 SAGE CT | ·Phoenix | az | 85082 | GRP-9160 | CORE-HMO |
| TPA | TPA-52649 | 2026-09-10T07:55:51Z | PATRICK | — | WEST·· | 1961-09-23 | UHC-73334-92 | •••-••-8470 | (320) 454-5775 | null | 5599 Maple Avenue | Tampa | FL | 33640 | - | CORE-HMO |
| TPA | TPA-57552 | 2026-03-22T07:43:34Z | Cooper, Danny | E | ···· | 1969-07-18 | NULL | •••-••-4235 | 620-801-1209 | — | 6979 DESERT SKY BOULEVARD | SEATTLE | WA | 98167 | N/A | N/A |
| TPA | TPA-50171 | 2026-06-07T20:23:25Z | ralph | — | ellioott | 19930626 | NULL | — | — | — | 3733 LAKE VIEW RD | Eden Prairie | MN | 55372-4782 | — | MEDICARE-ADV-A |
| TPA | TPA-55992 | 2026-09-18T07:32:23Z | Elijah | Y. | ·Castillo | 27-10-1939 | — | NULL | 780.730.3324 | - | 2196 ELM ST | Chandler·· | AZ | — | null | medicare-adv-b |
| TPA | TPA-50026 | 2026-04-02T05:40:42Z | NATALIE | — | SALAZAR | 02/22/1957 | NULL | •••-••-7860 | - | ·· | — | NULL | NULL | - | — | NAVIGATE-HMO |
| TPA | TPA-52308 | 2026-07-07T15:49:46Z | Alexis | ···· | Washington | 1997-12-03 | ·NULL | •••-••-0450 | NULL | N/A | 5669 Valley View Dr | Columbus | OH | 43234-8286 | - | — |
| TPA | TPA-54606 | 2026-08-06T22:14:29Z | Sam | — | Martinez | 1964-04-01 | N/A | •••-••-6049 | N/A·· | — | 6530 Cedar Ln | ·Glendale | AZ | N/A | — | - |
| TPA | TPA-63473 | 2026-08-31T15:45:42Z | kevin | — | andrews | 1982-03-06·· | NULL | — | - | — | 7867 Ocean Ave #777 | San Diego | CA | 92114 | — | OPTIONS-PPO |
| TPA | TPA-52071 | 2026-02-21T04:06:26Z | Mason, Anna | I. | — | 01/02/1972·· | - | N/A | N/A | NULL | N/A | UNKNOWN | — | — | — | ·UNKNOWN |
| TPA | TPA-63038 | 2026-09-13T11:13:18Z | Peter | — | Patterson | 03/14/2005 | UHC-20937-46·· | NULL | NULL | UNKNOWN | 6888 OAK ST | EDEN PRAIRIE | MN | ·55389 | NULL | ·OPTIONS-PPO |
| TPA | TPA-64315 | 2026-07-02T21:18:29Z | CARL | — | SIMMONS | 2003-03-11 | UHC-25020-08 | — | — | null | 5222 Ocean Avenue·· | Denver·· | CO | — | — | N/A |
| TPA | TPA-59234 | 2026-01-15T08:27:48Z | ·linda | ·· | hart | 12/22/51 | — | •••-••-1640 | N/A | — | - | - | ·- | - | N/A | null |
| TPA | TPA-57361 | 2026-02-24T08:55:03Z | Grace | — | Hernandez·· | 1950-12-14 | — | •••-••-1760 | (207) 528-9147 | — | ·1280 SUNSET BLVD Apt 5 | Chandler | AZ | 85229 | null | N/A·· |
| TPA | TPA-57119 | 2026-02-19T12:49:59Z | Glooria | — | Harper | 1943-06-01 | UHC-02195-39 | N/A | 13983749184 | ·· | 5253 RIVER ROAD·· | Plano | TX | 75089 | N/A | N/A |
| TPA | TPA-62673 | 2026-02-07T06:02:53Z | Rebcca | ·· | Chavez | 1950-01-16 | NULL | — | 726.325.4587 | REBECCA.CHAVEZ44@OUTLOOK.COM | 5053 Pine Drive | HOUSTON | TX | 77045 | — | ·· |
| TPA | TPA-54859 | 2026-08-27T19:01:49Z | Madison | — | Rios | 03/13/83 | UHC-86944-52 | — | 231-458-7048 | null | 8428 DESERT SKY BLVD·· | ·Eden Prairie | mn | — | GRP-3291 | — |
| TPA | TPA-56841 | 2026-03-10T06:33:29Z | Beverly | — | Hunter | 11/15/1996 | UHC-61579-57 | UNKNOWN | ·773-672-2371 | - | - | null | null | — | — | NULL |
| TPA | TPA-52728 | 2026-08-02T11:03:34Z | justin | — | parker | 1994-05-17 | null | — | N/A | — | 2669 HIGHLAND AVENUE | Glendale | AZ | 85327 | GRP-6516 | CHOICE-PLUS-PPO |
| TPA | TPA-54762 | 2026-01-25T13:36:55Z | Donald | ···· | McDonald | 1996-06-01 | — | •••-••-1770 | UNKNOWN | — | 9776 MARKET ST | Austin | TX | 78784 | N/A | SELECT-EPO |
| TPA | TPA-62382 | 2026-07-31T10:55:27Z | ·LAUREN | — | CASTILLO | ·1995-02-27 | UNKNOWN | N/A | 583-830-2953 | — | 1958 Highland Avenue | AUSTIN | TX | 78734-0935 | — | UNKNOWN |
| TPA | TPA-52227 | 2026-10-09T12:47:12Z | Jacobs, Nathan | — | — | Jul 4, 1946·· | NULL | UNKNOWN | null | nathan.jacobs@aol.com | 3405 Pine Dr | Seattle | wa | 98114 | N/A | UNKNOWN |
| TPA | TPA-60401 | 2026-01-13T00:58:01Z | JOAN | S | KNIGHT | 1997-11-15·· | null | null | (941) 470-3845 | joan.knight19@outlook.com | 3802 Highland Ave | Fresno | CA | 93796·· | GRP-2850 | N/A |
| TPA | TPA-54604 | 2026-05-17T08:51:24Z | Daniel | — | Hawkins | 15-06-2006 | N/A | •••-••-4435 | — | daniel.hawkins20@aol.com | 6882 Harbor Blvd | GILBERT | AZ | 85221 | - | NULL |
| TPA | TPA-61947 | 2026-05-24T20:13:56Z | Santiago | — | Collins·· | 2001-06-10 | N/A | •••-••-8350 | (917) 405-3500 | ···· | - | — | -·· | NULL | GRP-6369 | — |
| TPA | TPA-63699 | 2026-02-26T17:06:59Z | Douglas·· | — | Smith·· | 1939-02-21 | - | - | 3554501225 | N/A | 6704 Valley View Drive | Seattle | WA | 98166-2375 | N/A | MEDICARE-ADV-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 preservedline_no records each row's position in the source file, so a value can be located in the original extract.
- Load timestamploaded_at marks when the row landed in the lakehouse; this batch landed 2026-10-21T12:37:53.958Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty