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-53826 | 2026-02-26T04:41:45Z | Samuel | — | ·Watkins | 28-04-1979 | ·null | — | - | SAMUEL.WATKINS79@OUTLOOK.COM | — | N/A | UNKNOWN | NULL | — | - |
| TPA | TPA-55808 | 2026-08-22T06:36:43Z | BRUCE | — | HCKS | ·1978-02-20 | UNKNOWN | — | — | — | 632 Sunset Blvd | Charlotte | NC | - | N/A | N/A |
| TPA | TPA-59912 | 2026-07-17T09:40:04Z | Keith | — | Foster | Jan 10, 1973 | - | null | N/A | null | null | N/A | — | null | — | CHOICE-PLUS-PPO |
| TPA | TPA-53104 | 2026-09-28T14:24:08Z | JOSEPH | — | WHEELER | 1971-03-15 | — | — | — | ···· | 8613 Canyon Rd·· | ·CHANDLER | az·· | 85228 | N/A | — |
| TPA | TPA-61173 | 2026-03-01T16:31:00Z | Gloria | ·· | Clark | 1976-08-27 | UHC-28114-30 | N/A | N/A | ·GLORIA.CLARK@OUTLOOK.COM | 5774 Indian School Road | Sacramento | California | - | NULL | MEDICARE-ADV-B |
| TPA | TPA-58262 | 2026-04-14T01:34:14Z | SAMUEL | ·· | OLIVER | 1968-03-01·· | — | UNKNOWN | 580-929-4918 | - | 3743 CHURCH ST | Houston | TX·· | 77089 | NULL | - |
| TPA | TPA-55195 | 2026-10-06T11:34:27Z | cynthia | — | maatthews | 1985-07-10 | - | ·NULL | N/A | — | — | UNKNOWN | — | NULL | null | MEDICARE-ADV-B |
| TPA | TPA-56552 | 2026-10-09T22:26:58Z | randy | — | meyer | 19840726 | UHC-39293-88 | •••-••-7205 | UNKNOWN | null | 2773 Mountain View Drive | Tucson | AZ | 85753 | — | N/A |
| TPA | TPA-52898 | 2026-01-29T06:15:19Z | Alexis | — | Schltz | 1942-08-23 | null | — | 480-906-0013 | ALEXIS.SCHULTZ65@HOTMAIL.COM | 4330 Sage Court·· | Minneapolis | ·MN | 55467 | — | N/A |
| TPA | TPA-52470 | 2026-02-18T17:31:41Z | Larry | — | Jackson | ·1943-03-16 | UHC-86916-41 | •••-••-6111 | 917.894.0301 | N/A | 9602 Church St | ·Seattle | WA | 98124-0084 | GRP-7625 | OPTIONS-PPO |
| TPA | TPA-53533 | 2026-07-07T01:04:32Z | Joe | — | Coleman | 07/16/52 | — | - | +1 213 613 2067 | - | 5241 Cedar Ln·· | Mesa | Arizona | NULL | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-64450 | 2026-08-13T06:07:08Z | Juan | — | Morales | 1995-06-09·· | - | null | null | ·NULL | 8572 Valley View Drive | Gilbert | az | 85253 | — | - |
| TPA | TPA-55432 | 2026-05-03T07:47:26Z | Keith | — | McDonald | 1941-01-01 | ·· | null | 416-591-3789 | null | 1076 Apache Blvd | Sacramento | CA | 95814·· | GRP-5117 | — |
| TPA | TPA-62006 | 2026-05-04T18:46:55Z | Jeffrey | — | Lawrence | 1977-08-09 | N/A | •••-••-2734 | UNKNOWN | — | 2828 HIGHLAND AVE | Dallas | TX | 75212 | null | — |
| TPA | TPA-60962 | 2026-02-02T11:59:42Z | LORI | — | SANDERS | 1943-10-16 | UNKNOWN | null | — | N/A | 1021 Maple Avenue | ·Mesa | AZ | — | NULL | medicare-adv-a |
| TPA | TPA-52042 | 2026-07-10T15:34:40Z | ALBERT | — | MURPHY | 1953-11-18 | UNKNOWN | •••-••-2798 | +1 925 681 1998 | null | 3133 LINCOLN WAY | Miami | FL | 33132 | GRP-0425 | MEDICARE-ADV-A |
| TPA | TPA-56959 | 2026-02-04T20:21:12Z | Bennett, George | — | — | 1984-02-09 | UHC-71808-02 | •••-••-1969 | — | — | 4299 MOUNTAIN VIEW DRIVE | Orlando | FL | 32817 | — | N/A |
| TPA | TPA-58431 | 2026-09-19T10:33:08Z | Joyce | — | Reid·· | 1965-10-13 | UHC-05392-10 | N/A | 3467266979 | JOYCE.REID76@HOTMAIL.COM | 3296 Sunset Boulevard | Scottsdale | az | ·85241 | null | MEDICARE-ADV-B |
| TPA | TPA-50021 | 2026-06-07T21:02:43Z | CHRISTIAN | — | RUIZ | 1940-09-26 | - | N/A | - | — | 1131 Union Street Apt 26·· | Columbus | OH | 43273 | GRP-4152 | MEDICARE-ADV-B |
| TPA | TPA-61161 | 2026-08-14T09:51:17Z | JOAN | — | WEBB | ·09/03/2005 | null | - | (343) 338-7023 | - | 8859 Ridge Road | DENVER | Colorado | 80293 | GRP-3488 | MEDICARE-ADV-B |
| TPA | TPA-50355 | 2026-04-17T19:17:51Z | WEI | — | PATTERSON | 1949-07-04 | N/A | — | (918) 331-9313 | N/A | 4830 ELM STREET | San Antonio | Texas | 78235 | - | — |
| TPA | TPA-59401 | 2026-05-30T09:15:49Z | Noah | — | Cook | 1966-08-22 | null | •••-••-6209 | (755) 228-4724 | N/A | N/A | — | N/A | — | — | ·· |
| TPA | TPA-53311 | 2026-07-11T07:28:42Z | Sanchez, Bruce | — | — | 1966-12-13 | UNKNOWN | UNKNOWN | 940.948.3206 | null | 9891 Highland Ave | Tempe | Arizona | 85216 | ·null | — |
| TPA | TPA-53985 | 2026-03-23T16:22:07Z | Julie | — | Hamilton | 1976-02-10 | N/A | null | 614-543-9499 | null | ·· | null | N/A | - | UNKNOWN | N/A |
| TPA | TPA-62837 | 2026-06-30T23:27:08Z | Walter | — | Henry | 1984-06-04 | — | — | — | — | UNKNOWN | UNKNOWN | — | - | null | — |
| TPA | TPA-54777 | 2026-03-27T13:14:48Z | EVELYN | — | GARRETT | 1942-11-19 | — | - | (525) 768-7724 | null | — | null | null | — | GRP-1269 | NAVIGATE-HMO |
| TPA | TPA-63300 | 2026-05-01T13:15:27Z | PRIYA | H. | ESTRADA | 1980-01-15 | UHC-63095-70 | •••-••-7289 | N/A | NULL | 9798 SAGE COURT | Columbus | OH | 43245 | GRP-7519 | CORE-HMO |
| TPA | TPA-60933 | 2026-03-13T04:51:52Z | Charles | — | ·Reid | 06/14/1969 | NULL | •••-••-7330 | N/A | — | 3202 Lincoln Way | Tempe | az | 85211-8658 | — | NULL |
| TPA | TPA-50015 | 2026-08-02T15:35:07Z | Kayla | — | ·Chapman | 12/14/1944 | — | — | ·678-840-8311 | UNKNOWN | 713 HARBOR BOULEVARD | Scottsdale·· | AZ | 85255 | null | — |
| TPA | TPA-59361 | 2026-04-01T14:35:50Z | James·· | ···· | Gardner | 1963-10-04 | UNKNOWN | UNKNOWN | — | — | 2078 SUNSET BLVD | NASHVILLE | TN | NULL | GRP-5871 | ·· |
| TPA | TPA-53784 | 2026-09-24T12:36:17Z | Rodriguez, Ethan | — | — | 05/11/38 | — | •••-••-8157 | (521) 783-7170 | null | 980 Sage Court | LOS ANGELES | CA | ·N/A | UNKNOWN | CORE-HMO |
| TPA | TPA-54976 | 2026-05-11T17:53:52Z | Cheryl | — | Andrews | 19711124 | UNKNOWN | •••-••-6341 | UNKNOWN | UNKNOWN | N/A | NULL | — | — | GRP-8155 | NULL |
| TPA | TPA-56215 | 2026-07-01T04:01:19Z | Jeesse | — | Ward | 2002-03-04 | N/A | •••-••-7511 | 221-673-4126 | ·UNKNOWN | 1208 Elm St | NASHVILLE | TN | 37290 | - | — |
| TPA | TPA-53565 | 2026-03-23T11:09:18Z | ·Peters, Judith | — | — | - | ·null | — | — | — | ·- | UNKNOWN | UNKNOWN·· | — | N/A | ···· |
| TPA | TPA-59913 | 2026-06-13T21:30:39Z | WALTER | — | SIMMONS | Oct 6, 1964 | N/A | ·· | null | - | 434 Bayshore Dr | Austin | TX | 78729 | — | CHOICE-PLUS-PPO |
| TPA | TPA-57352 | 2026-01-15T22:20:52Z | CAMILA | — | ROMERO | 1941-04-20 | UNKNOWN | null | — | - | 6264 Forest Ave·· | Tampa | FL | 33674-5677 | GRP-3049 | ·· |
| TPA | TPA-58588 | 2026-01-24T12:48:03Z | Rachel | — | Freeman | 19751207·· | — | •••-••-8242 | N/A | ·null | UNKNOWN | N/A | NULL | null | N/A·· | UNKNOWN |
| TPA | TPA-63470 | 2026-06-26T05:26:11Z | terry | — | medina | ·1993-05-16 | UNKNOWN | — | ·459.614.3385 | NULL | 9507 Camelback Road | Columbus | OH | 43278 | GRP-4025 | - |
| TPA | TPA-53281 | 2026-09-10T15:52:56Z | Sophia | — | Back | 2005-12-01 | — | — | — | - | 5644 HILLCREST RD | Dallas | Texas | 75255 | NULL | NAVIGATE-HMO |
| TPA | TPA-56954 | 2026-04-07T20:04:51Z | janet | — | ·vega | 1962-07-19 | — | NULL | — | ·janet.vega73@yahoo.com | 6144 Baseline Road Apt 2 | ·Eden Prairie | MN | 55362 | GRP-6238 | — |
| TPA | TPA-56846 | 2026-09-11T22:31:45Z | CAMILA | — | MOORE | 2004-08-02 | — | N/A | N/A | — | 9833 Lake View Rd | Chandler | AZ | 85231 | — | null |
| TPA | TPA-60308 | 2026-01-06T17:03:20Z | Christian | — | Kelley | Nov 28, 2008 | NULL | N/A | 952-733-6216 | UNKNOWN | 2826 Union Street | COLUMBUS | OH | 43245 | — | N/A |
| TPA | TPA-63521 | 2026-08-04T18:38:22Z | Peter | — | Burton | 12/18/1996 | null | — | — | null | 9727 Cedar Ln | Houston | tx | 77034 | null | NAVIGATE-HMO |
| TPA | TPA-63399 | 2026-07-23T03:18:33Z | Judith | — | Davis | 06/09/77 | UHC-83672-30 | — | — | null | 5600 Meadow Lane | Glendale | AZ | 85361 | N/A | NULL |
| TPA | TPA-63786 | 2026-01-12T09:43:04Z | Allexis | — | Elliott | Feb 4, 1965 | UNKNOWN | •••-••-1033 | — | alexis.elliott7@gmail.com | 9576 Cedar Ln·· | Atlanta | GA | 30344 | GRP-0160 | — |
| TPA | TPA-51232 | 2026-04-17T18:23:23Z | Stephen | — | Ray | 19570119 | N/A | ···· | — | NULL | - | N/A | - | null | — | NULL |
| TPA | TPA-56401 | 2026-07-04T06:33:56Z | ·Collins, Jesse | H | — | 1987-04-01 | - | — | — | — | 7476 Grand Avenue #511 | COLUMBUS | OH·· | 43212 | GRP-4313 | SELECT-EPO·· |
| TPA | TPA-51245 | 2026-08-23T03:45:37Z | roy·· | — | tucker | 1946-01-17 | UHC-34706-33 | NULL | — | — | ·7341 Oak Street | ATLANTA | GA | 30300 | null | OPTIONS-PPO |
| TPA | TPA-54857 | 2026-08-06T12:59:36Z | Carl | — | Thompson | ·1958-01-03 | UNKNOWN | - | N/A | NULL | 683 SPRING ST | Orlando | FL | 32803 | - | — |
| TPA | TPA-63783 | 2026-01-17T13:31:52Z | Kelley, Jason | — | — | 1949-01-20 | - | N/A | 5817554 | N/A | 4295 PALM DRIVE | LAS VEGAS | NV | 89140 | GRP-2214 | - |
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:43:03.447Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty