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-56252 | 2026-05-25T05:25:22Z | ralph | — | wang | 03-12-1957 | null | null | (910) 433-6575 | ·UNKNOWN | — | — | — | null | null | MEDICARE-ADV-B |
| TPA | TPA-52961 | 2026-07-29T04:58:21Z | patricia | — | mendez | 2004-07-01 | N/A | •••-••-9713 | — | patricia.mendez91@gmail.com·· | 7575 Union Street | Minneapolis | MN | 55404 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-60192 | 2026-06-11T07:24:59Z | Christine | — | Cunningham | 1980-12-13 | null | N/A | 346-412-8711 | christine.cunningham@outlook.com | 9251 Ridge Road | Dallas | TX | 75296-9733 | null | OPTIONS-PPO |
| TPA | TPA-54634 | 2026-03-17T15:29:39Z | Madison | — | Wheeler | 2008-01-14 | ·UNKNOWN | •••-••-9652 | 5154299 | — | 4424 Forest Avenue | Columbus | OH | 43276 | — | options-ppo |
| TPA | TPA-60121 | 2026-01-19T20:21:17Z | CHRISTINE | — | GRAHAM | 1955-05-24 | UNKNOWN | - | — | - | 1820 Mesa Dr | Denver | CO | 80298 | GRP-7891 | CHOICE-PLUS-PPO |
| TPA | TPA-62174 | 2026-04-29T13:23:13Z | Brian | — | Patel | 1955-12-13 | NULL | - | 3111600 | NULL | — | — | - | N/A | NULL | — |
| TPA | TPA-50806 | 2026-05-14T18:02:10Z | Lucia | — | Turner | 2001-01-12 | — | •••-••-2461 | null | null | 7359 WILLOW COURT | Charlotte | NC | 28240 | ···· | null |
| TPA | TPA-54875 | 2026-07-18T00:42:13Z | TIMOTHY | — | JONES | 04-03-1952 | - | •••-••-9372 | — | NULL | 4271 Harbor Blvd | PHOENIX | AZ | 85049 | GRP-0582 | MEDICARE-ADV-B |
| TPA | TPA-60197 | 2026-06-17T01:51:22Z | sean | — | webb | 10/08/01 | N/A | •••-••-8006 | 810-217-9880·· | null | 3689 Willow Court | TUCSON | AZ·· | 85768·· | NULL | — |
| TPA | TPA-51440 | 2026-03-30T18:55:48Z | Gerald | ···· | Robertson | 1997-03-28 | UHC8646012 | - | null | - | 7199 Camelback Road | San Diego | CA | ·92127 | UNKNOWN | — |
| TPA | TPA-55589 | 2026-01-18T21:38:53Z | Wilson, Justin | — | — | 27-03-1974 | - | UNKNOWN | 950-462-5876 | - | 5123 Camelback Road | Plano | TX | ·75001-7967 | UNKNOWN | NULL |
| TPA | TPA-54931 | 2026-07-16T21:14:51Z | DONALD | ·· | RUSSELL | 19740222 | -·· | - | NULL | N/A | 5913 MAPLE AVE | Houston | TX | 77046 | — | MEDICARE-ADV-A |
| TPA | TPA-53790 | 2026-05-09T20:25:50Z | Brenda | K | Ferguson | 1952-03-13 | — | •••-••-0547 | ·N/A | — | 7666 Harbor Blvd | Seattle | WA·· | 98150 | NULL | OPTIONS-PPO |
| TPA | TPA-64469 | 2026-01-06T01:26:32Z | Virginia | ·· | Guerrero | 07/02/39 | — | N/A | - | N/A | 7836 Ocean Avenue | Miami | Florida | 33146 | null | NAVIGATE-HMO |
| TPA | TPA-60435 | 2026-10-08T09:11:15Z | Deborah | — | Hendesron | 2008-03-10 | null | — | ···· | — | 2283 GRAND AVENUE | Scottsdale | AZ | 85238 | GRP-2141 | - |
| TPA | TPA-59230 | 2026-03-10T06:39:06Z | PETER | — | FOWLER | 1990-09-28 | N/A | •••-••-3322 | NULL | NULL | 1031 Central Avenue | MESA | Arizona | 85243 | — | — |
| TPA | TPA-55937 | 2026-03-06T09:01:13Z | CHARLES | — | AUSTIN | 1979-02-16 | NULL | — | 8472721 | charles.austin@gmail.com | 787 GRAND AVE | Mesa | AZ | 85271 | UNKNOWN | CORE-HMO |
| TPA | TPA-51511 | 2026-06-16T02:15:20Z | ·Sharon | — | Boyd | 9157-07-20 | — | — | null | - | 4822 Camelback Rd | Minneapolis | MN | 55471 | NULL·· | — |
| TPA | TPA-54303 | 2026-08-20T02:45:11Z | Andrea | — | Sanchez | 19871028 | NULL | N/A | 435-444-3128 | null | 4587 Lake View Rd | Houston | TX | 77087 | GRP-5623 | — |
| TPA | TPA-57596 | 2026-01-27T18:07:19Z | Haansen, Charlotte | M. | — | 1990-73-05 | — | UNKNOWN | — | ·UNKNOWN | 2692 Palm Drive | Scottsdale | AZ | 85271 | NULL | — |
| TPA | TPA-60423 | 2026-08-10T05:02:43Z | SHARON·· | — | ROMERO | Nov 2, 2008 | — | •••-••-5540 | 467-226-9397 | null | 633 Park Place | ORLANDO | fl | 32897 | UNKNOWN | — |
| TPA | TPA-55862 | 2026-03-13T11:04:15Z | Le, Jerry | — | — | 1965-05-13 | null | N/A | (911) 803-7455·· | N/A | N/A | — | null | - | UNKNOWN | NULL |
| TPA | TPA-53666 | 2026-04-07T05:05:14Z | Jack | — | Williams | 19450805 | UHC-49650-74 | — | — | UNKNOWN | 9245 Jefferson Ave | Nashville·· | Tennessee | 37298·· | — | null |
| TPA | TPA-60441 | 2026-06-09T03:21:59Z | Barnes, Linda·· | — | — | 21-10-1984 | UHC-93776-99 | •••-••-6397 | 452-340-7863 | NULL | 1023 Palm Dr | CHANDLER | AZ | 85252 | GRP-4365 | null |
| TPA | TPA-57550 | 2026-04-18T18:28:45Z | Lisa | — | Hernandez | 11/25/1992 | NULL·· | NULL | (985) 554-7360 | N/A | 4517 Grand Ave | San Antonio | TX | ·78207 | — | — |
| TPA | TPA-59864 | 2026-09-10T17:51:17Z | JLIA | — | CERTER | 1993-12-09 | UNKNOWN | •••-••-0316 | - | NULL | 7784 APACHE BLVD | Columbus | ·OH | 43266-4710 | GRP-8066 | — |
| TPA | TPA-56698 | 2026-06-12T13:07:24Z | Jerry | — | Armstrong | 1940-04-10 | UHC-40480-51 | — | — | — | 6898 Mountain View Dr | Phoenix | Arizona | 85058 | GRP-4322 | ·CORE-HMO |
| TPA | TPA-52507 | 2026-05-09T02:27:05Z | Jonathan | — | Foster | 1953-09-06 | N/A | — | NULL | ···· | ·7387 LAKE VIEW ROAD Apt 37 | CHARLOTTE | NC | 28284 | GRP-3212 | null |
| TPA | TPA-56338 | 2026-06-30T09:00:17Z | JULIA | — | MYERS | 01-11-1986 | NULL | — | (982) 560-7743 | ·· | null | UNKNOWN | — | ···· | - | — |
| TPA | TPA-55304 | 2026-05-03T07:19:29Z | Kenneth | — | Harrison | 19610404 | — | N/A | null | kenneth.harrison1@aol.com | 1680 Lake View Rd | Las Vegas | Nevada | 89177 | GRP-5886 | NAVIGATE-HMO |
| TPA | TPA-61305 | 2026-04-29T23:03:12Z | George | — | Warren | 2004-07-22 | — | UNKNOWN | UNKNOWN | null | — | UNKNOWN | NULL | — | GRP-3998 | N/A |
| TPA | TPA-62674 | 2026-09-24T13:21:30Z | Rebecca | — | Chavez | 1950-01-16 | — | UNKNOWN | 726-325-4587 | — | null | — | N/A | ·null | GRP-3359 | NULL |
| TPA | TPA-54345 | 2026-10-03T23:02:49Z | Martha | — | Tucker | 10/14/1988 | — | — | — | — | 7665 JEFFERSON AVENUE | San Antonio | TX | 78241 | GRP-2832 | — |
| TPA | TPA-63870 | 2026-05-07T13:47:08Z | vincent | — | herrera | 1954-11-26 | N/A | — | N/A | — | 6704 Lincoln Way | Charlotte | NC | NULL | — | — |
| TPA | TPA-57396 | 2026-04-05T10:44:25Z | Sophia | — | Ryan | 19580711 | null | — | 5149238202 | N/A | 2546 Ridge Road | Tucson | Arizona | 85754 | — | null·· |
| TPA | TPA-63825 | 2026-08-01T10:55:54Z | Frank | — | Cox | 2005-07-22 | null | UNKNOWN | null | — | UNKNOWN | NULL | — | NULL·· | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-61302 | 2026-10-04T19:38:00Z | SCHULTZ | — | BRYAN | 9147-12-11 | null | — | N/A | null | NULL | — | — | — | null | UNKNOWN |
| TPA | TPA-51219 | 2026-02-20T22:46:06Z | Fields, Pamela | — | — | 1988-04-12 | null | •••-••-5622 | (605) 597-1383 | — | 9331 Spring Street | Charlotte | NC | 28237 | — | MEDICARE-ADV-A |
| TPA | TPA-61172 | 2026-10-03T05:04:12Z | Sarah | T. | Parker | ·23-02-1990 | — | ·· | UNKNOWN | SARAH.PARKER71@PROTON.ME | NULL | — | ·- | — | GRP-8745 | NAVIGATE-HMO |
| TPA | TPA-53548 | 2026-10-14T18:51:49Z | ·Mary | ·I | Thompson | 1977-02-25 | - | •••-••-5704 | NULL | - | 9404 Meadow Lane | Austin | ·TX | 78754 | — | SELECT-EPO |
| TPA | TPA-61698 | 2026-05-26T06:20:03Z | ·Philip | — | Brooks | 07-04-1954 | — | — | (950) 628-2571 | ·- | 2349 Central Ave Apt 29 | Tucson | az | — | - | — |
| TPA | TPA-54839 | 2026-03-11T16:06:42Z | Barbara | R | Espinoza | 2001-10-25 | UNKNOWN·· | •••-••-8312 | — | - | 4396 Valley View Dr | TEMPE | ·Arizona | 85224 | GRP-9236 | — |
| TPA | TPA-52800 | 2026-03-12T18:52:40Z | Virginia | — | Graham | 1943-12-05 | NULL | •••-••-5982 | - | ·- | 4639 Palm Drive | San Diego | CA | 92193 | - | — |
| TPA | TPA-54497 | 2026-10-09T07:25:17Z | Owens, Mark | F | — | ·08/06/46 | - | UNKNOWN | N/A | null | 6488 Cedar Lane | Fresno | CA·· | 93780 | — | NULL |
| TPA | TPA-59437 | 2026-08-19T13:55:38Z | RONALD | — | GUERRERO | 1953-09-22 | - | — | -·· | — | 8347 Market St | Scottsdale | AZ | 85262-0619 | — | OPTIONS-PPO |
| TPA | TPA-51463 | 2026-04-02T17:47:47Z | Rachle | — | Hughes | 19690606 | ·UNKNOWN | NULL | null | — | 3782 Meadow Ln | Glendale | AZ | 85328 | UNKNOWN | ·· |
| TPA | TPA-57854 | 2026-08-09T23:37:09Z | Justin | — | Gordon | 1958-09-10 | UNKNOWN | — | — | ···· | 8913 Mountain View Drive | PHOENIX | AZ | 85069 | — | — |
| TPA | TPA-51903 | 2026-03-12T23:49:18Z | Isabella | — | Burns | 1948-08-20 | null | — | 4113601184·· | ·· | null | N/A | null | UNKNOWN | — | NULL |
| TPA | TPA-60678 | 2026-05-14T13:09:33Z | Arnold, Julie | — | — | 1981-09-06 | null | - | — | UNKNOWN | 9290 OAK ST | Tempe | AZ | 85261-8814 | GRP-5467 | — |
| TPA | TPA-56759 | 2026-05-15T19:21:15Z | Valdez | — | Mariana | 1983-11-22 | N/A | •••-••-6987 | (914) 266-6728 | mariana.valdez31@hotmail.com | 1961 Apache Boulevard | ·Dallas | ·TX | 75267 | - | 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 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:46.445Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty