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-62079 | 2026-08-08T17:26:13Z | ryan | — | nichols | 1978-02-25 | — | UNKNOWN | 12705479337 | ·ryan.nichols@aol.com | ·4417 Camelback Rd | San Diego | ca | 92172 | GRP-7653 | SELECT-EPO |
| TPA | TPA-59670 | 2026-06-15T16:40:26Z | Eddie | — | Sancez | 09/13/51 | ·UNKNOWN | UNKNOWN | 922-588-5292 | edward.sanchez@yahoo.com | 9732 Market Street | Nashville | TN | 37268 | — | CORE-HMO |
| TPA | TPA-58950 | 2026-07-02T18:29:14Z | CYNTHIA | — | SILVA | 1957-06-20 | — | — | — | null | 434 Highland Avenue | Nashville | tn | 37233-5518 | GRP-3249 | - |
| TPA | TPA-62241 | 2026-09-15T06:39:09Z | debra | U | rley | ·1972-01-01 | — | — | — | debra.riley@gmail.com | 6684 BROADWAY | HOUSTON | TX | 77005 | null | ···· |
| TPA | TPA-52534 | 2026-01-14T22:56:02Z | OBrien | M | Jacob | 1949-07-03 | UHC-92455-51 | •••-••-7013 | NULL | — | 9669 Mountain View Dr | Jacksonville | FL | ·32281 | — | MEDICARE-ADV-A |
| TPA | TPA-64223 | 2026-02-06T14:32:31Z | Dennis | — | Rojas | 1945-11-25 | NULL | ·· | 7405536272 | NULL | 5077 Church St | Orlando | FL | 32897 | N/A | MEDICARE-ADV-A |
| TPA | TPA-52692 | 2026-08-21T10:02:30Z | ·zachary | F | hudson | 1952-12-12 | NULL·· | NULL | — | zachary.hudson@hotmail.com | 3391 JEFFERSON AVENUE | GILBERT·· | AZ | 85288 | null·· | N/A |
| TPA | TPA-51669 | 2026-06-10T19:05:36Z | CAMILA | ···· | WALSH | 4/22/1956 | - | — | UNKNOWN | N/A | 238 MARKET STREET | Miami | FL | 33187 | N/A | OPTIONS-PPO |
| TPA | TPA-52786 | 2026-03-06T02:06:53Z | Lawson, Kathryn | — | — | 08/08/59 | UNKNOWN | — | NULL | NULL | 6646 CANYON ROAD | ORLANDO | FL·· | 32893-2044 | GRP-6279 | UNKNOWN |
| TPA | TPA-58865 | 2026-10-18T14:48:19Z | DANIEL | — | GREENE | 2007-02-23 | — | •••-••-5166 | — | ·· | — | — | N/A | NULL | GRP-7763 | NAVIGATE-HMO |
| TPA | TPA-57520 | 2026-05-31T07:51:51Z | Turner, Joe | — | ···· | 12/1/1987·· | NULL | - | 13745157975 | joe.turner@hotmail.com | 55 Union Street | Charlotte | NC | ·28296 | N/A | — |
| TPA | TPA-51956 | 2026-08-15T01:36:26Z | ·Natalie | — | King | 1946-01-09 | null | •••-••-6898 | 4347836508 | ···· | 5353 Valley View Drive | MESA | AZ | 85256-3177 | GRP-5298 | — |
| TPA | TPA-51287 | 2026-02-09T21:21:34Z | Ward, Carolyn | — | ·· | 20040316 | UHC-59025-32 | — | 516-229-7629 | -·· | 9472 Desert Sky Boulevard | Chandler·· | AZ | 85298 | GRP-0864 | — |
| TPA | TPA-58165 | 2026-10-06T10:07:43Z | ralhp | ···· | montgomery | ·1968-03-03 | null | •••-••-4585 | (471) 322-0386 | null | 8841 Central Avenue | Jacksonville | Florida | 32223 | null | - |
| TPA | TPA-58222 | 2026-05-23T14:16:14Z | John | N | Santiago | 20-10-1958 | UNKNOWN | •••-••-2672 | N/A | — | — | null | UNKNOWN·· | NULL | null | NULL |
| TPA | TPA-58349 | 2026-08-26T12:23:53Z | david | — | mason | ·1938-07-25 | N/A | ·· | NULL | ·N/A | 4860 Mountain View Drive | Jacksonville | FL | 32255 | — | N/A |
| TPA | TPA-64413 | 2026-04-26T18:02:59Z | ·BENJAMIN | — | OLSON | 1977-02-25 | ·null | •••-••-4771 | — | ···· | — | N/A | — | — | N/A | N/A |
| TPA | TPA-56860 | 2026-06-30T20:25:28Z | JOYCE | — | HANZON | 05/26/1953 | — | •••-••-4461 | N/A | joyce.hanson@proton.me | 7759 MARKET STREET | TEMPE | AZ | 85255 | - | — |
| TPA | TPA-54363 | 2026-07-03T06:41:16Z | CHARLOTTE | — | GORDON | 07/13/83 | null | NULL | - | charlotte.gordon36@proton.me | 4034 Mountain View Drive Apt 36 | ·Orlando | FL | 32879 | GRP-2764 | — |
| TPA | TPA-51292 | 2026-08-26T05:32:21Z | GRACE | ·A | ELLIOTT | 1962-10-24 | N/A | UNKNOWN | 685-682-0613 | N/A | 9174 Lincoln Way | Denver | CO | 80200 | GRP-7439 | — |
| TPA | TPA-62988 | 2026-01-15T10:05:46Z | emily·· | ·· | roberts | 1955-07-11 | — | •••-••-7036 | ·956-528-6935 | null | 6341 Meadow Lane | TUCSON·· | Arizona | 85745 | - | — |
| TPA | TPA-50057 | 2026-08-11T01:19:28Z | Doris | — | Mendoza | 1986-11-26 | NULL | null·· | — | — | 5532 MAIN STREET Apt 30 | ·Tempe | AZ | 85298 | N/A | ·NULL |
| TPA | TPA-60505 | 2026-07-20T15:30:15Z | Diana | — | Aguilar | 2003-11-20 | — | — | N/A | — | 2189 Jefferson Ave | Eden Prairie | MN | 55348 | — | - |
| TPA | TPA-57919 | 2026-04-20T19:29:12Z | Julie | — | Ortiz | 2006-09-17 | null | •••-••-8027 | — | — | 2497 Ocean Ave | Seattle | WA | ·· | — | UNKNOWN |
| TPA | TPA-53226 | 2026-02-23T20:01:54Z | Debra | — | Bryant | 02/27/97 | UHC-21572-64 | •••-••-8315 | 7429382378 | ·N/A | 2076 Ocean Ave | Dallas | TX | 75226 | GRP-3572 | NAVIGATE-HMO |
| TPA | TPA-61725 | 2026-07-22T18:36:50Z | GABRIEL | — | GUERRERO | May 17, 1942 | - | UNKNOWN | 321-224-6482 | GABRIEL.GUERRERO98@HOTMAIL.COM | 6262 Mountain View Drive | Houston·· | TX | ·77005 | N/A | CORE-HMO |
| TPA | TPA-56997 | 2026-09-27T07:15:23Z | ·patrick | — | fisher | 1985-08-03 | NULL | •••-••-4357 | ·(777) 329-5953 | ···· | 8910 Camelback Road | PLANO | TX | 75099-0386 | null | UNKNOWN |
| TPA | TPA-53966 | 2026-05-02T02:11:58Z | DORIS | — | STEWART | 1968-03-04 | — | UNKNOWN | (619) 451-1077 | NULL | 5776 Sage Ct | MINNEAPOLIS | mn | 55480 | ···· | ·UNKNOWN |
| TPA | TPA-51508 | 2026-01-24T07:02:42Z | RAYMOND | — | RILEY | 1973-12-25 | - | •••-••-8821 | 812-843-1450 | — | 375 MARKET ST | Scottsdale | AZ | 85269 | null | OPTIONS-PPO |
| TPA | TPA-58702 | 2026-06-05T20:48:50Z | HAROLD | — | PETERSON | 2004-06-22 | — | — | 3279938860·· | NULL | - | — | UNKNOWN | UNKNOWN | GRP-5851 | - |
| TPA | TPA-57460 | 2026-04-08T20:28:41Z | Emma | — | Tucker | May 9, 1964·· | null | •••-••-0858 | — | UNKNOWN | 8985 Hillcrest Road | FRESNO | ·CA | 93774 | N/A | NAVIGATE-HMO |
| TPA | TPA-59963 | 2026-04-06T07:56:24Z | Morris, Wei | — | — | 1970-02-14 | UNKNOWN | — | — | — | 9555 Central Ave | Mesa | AZ | 85253-7208 | N/A | ·UNKNOWN |
| TPA | TPA-53272 | 2026-04-16T04:57:39Z | Amy | — | Vasquez | 19510414 | NULL | UNKNOWN | — | — | 5795 MAPLE AVENUE | GLENDALE | AZ | 85335 | GRP-0284 | MEDICARE-ADV-B |
| TPA | TPA-55367 | 2026-02-13T20:01:09Z | Fuller, Sean | L | — | 1986-08-24 | — | null | - | sean.fuller@aol.com | 1395 Grand Ave | ·Chandler | az | 85201 | — | NAVIGATE-HMO |
| TPA | TPA-58719 | 2026-06-30T09:09:33Z | ROGER | — | FERGUSON | 1960-04-12 | UHC-15165-36 | •••-••-7303 | N/A | roger.ferguson@gmail.com | 4199 Church St | Glendale | Arizona | ·85349 | N/A·· | — |
| TPA | TPA-50393 | 2026-08-08T15:31:42Z | Albert | — | Henderson | 03-10-2008 | ·UNKNOWN | •••-••-3452 | — | — | 4658 Maple Ave | ·Scottsdale | ·AZ | 85240 | - | — |
| TPA | TPA-61785 | 2026-03-31T17:45:40Z | ·kelly | ·· | mason | 1950-04-08 | - | null | 6127365124 | ···· | ·527 Jefferson Avenue | EDEN PRAIRIE | MN | 55374·· | NULL | — |
| TPA | TPA-62631 | 2026-04-02T13:49:31Z | Meissa | — | Valdez | ·1958-04-10 | UHC9256661 | •••-••-6597 | NULL | NULL | 1948 Lincoln Way #128 | Fresno | CA | 93740 | GRP-6613 | medicare-adv-b |
| TPA | TPA-55997 | 2026-03-30T04:47:32Z | Dnaiel | — | Sanchez | 2004-03-03 | — | null | — | daniel.sanchez48@outlook.com | 345 Main Street | Austin | ·Texas | 78799 | null | - |
| TPA | TPA-61213 | 2026-02-21T13:01:05Z | paul | — | cole | Mar 25, 1987 | UHC-19182-68 | — | N/A | — | 5765 Indian School Rd | TEMPE | AZ | 85246 | UNKNOWN | null |
| TPA | TPA-60153 | 2026-10-03T05:27:44Z | Donald | — | Weaver | 07/01/1967 | null·· | NULL | 871-988-2023 | ·UNKNOWN | 9560 Valley View Dr | Columbus | OH | 43203 | GRP-0154 | core-hmo |
| TPA | TPA-54151 | 2026-03-26T03:32:14Z | Aguilar, Jacob | R. | — | UNKNOWN | UHC-45993-82 | •••-••-7886 | 13825439235 | NULL | 8043 Palm Dr·· | Tampa | FL | 33622 | N/A | — |
| TPA | TPA-60008 | 2026-02-21T14:07:46Z | Gutierrez, Russell | — | — | 1986-01-15 | NULL | - | null | — | 1669 MARKET STREET | Minneapolis | MN | 55454 | - | N/A |
| TPA | TPA-55418 | 2026-02-07T03:42:55Z | KEVIN | — | HERNANDEZ | 1969-07-03 | null | N/A | 777-625-4173 | N/A | ·7438 RIDGE RD | MINNEAPOLIS | ·MN | 55473 | NULL | — |
| TPA | TPA-53542 | 2026-02-26T20:01:00Z | Kimberly | — | Maldonado | Feb 8, 1991 | UNKNOWN | ·NULL | NULL·· | kimberly.maldonado29@gmail.com | 8564 WASHINGTON STREET | Columbus | OH | 43255 | null | ·NAVIGATE-HMO |
| TPA | TPA-62447 | 2026-10-12T12:25:16Z | BRANDON | — | COLLINS | 1981-07-08 | ·· | NULL | (330) 520-9122 | N/A | 1704 DESERT SKY BLVD·· | Tampa | ·FL | — | null | — |
| TPA | TPA-61053 | 2026-01-13T02:07:54Z | Eric | — | Walker | 1939-07-14 | UHC-52069-26 | •••-••-1375 | N/A | N/A·· | 59 Willow Ct | PHOENIX | AZ | 85086 | N/A | — |
| TPA | TPA-53304 | 2026-04-15T20:31:38Z | ROGER | — | WHITE | 19480805 | — | — | — | — | 1413 Meadow Ln | ·MIAMI | FL | 33135 | GRP-5884 | SELECT-EPO |
| TPA | TPA-52303 | 2026-07-05T10:04:12Z | MEGAN | ·· | WATKINS·· | 10/10/97 | UHC-36574-72 | — | 2086708343 | NULL | 2995 MOUNTAIN VIEW DR | San Diego | CA | 92132·· | - | NULL |
| TPA | TPA-53715 | 2026-02-09T10:12:32Z | Garrett, Brenda | ·· | — | 1985-09-28 | UHC-01984-24 | — | 254-733-3168 | BRENDA.GARRETT80@ICLOUD.COM | 3668 Ridge Road | Phoenix | AZ | 85018 | GRP-6092 | — |
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:53.701Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty