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-56763 | 2026-01-31T12:28:39Z | Mikhelle | — | Wong | 1959-10-18 | N/A | UNKNOWN | (475) 201-9065 | - | — | null | - | UNKNOWN | — | SELECT-EPO |
| TPA | TPA-58550 | 2026-03-04T06:08:23Z | DYLAN | — | OBRIEN | 1981-08-09 | — | — | 517.995.6815 | NULL | 4022 MEADOW LANE | FRESNO | CA | 93761 | GRP-5228 | NULL |
| TPA | TPA-62648 | 2026-02-21T08:42:08Z | mason | ·· | schultz | 2002-10-21 | ·- | ···· | 2939441597 | UNKNOWN·· | 9103 HIGHLAND AVENUE | COLUMBUS | OH | 43215 | UNKNOWN | — |
| TPA | TPA-53458 | 2026-07-04T14:41:21Z | Kevin | — | ·Chapman | ·1968-09-13 | null | null | NULL | — | 3206 Meadow Lane | Scottsdale | AZ | 85205 | GRP-1525 | ·UNKNOWN |
| TPA | TPA-64025 | 2026-06-16T10:32:29Z | Philip·· | — | Castro | 4/13/1977 | UNKNOWN | - | 447-921-3897 | PHILIP.CASTRO@YAHOO.COM | - | — | N/A | null | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-58727 | 2026-04-10T05:11:40Z | AMBER | — | WATSON | 20010513 | — | — | (426) 323-9948 | NULL | 3827 Church St | Columbus | Ohio | 43256 | NULL | NAVIGATE-HMO |
| TPA | TPA-54605 | 2026-06-03T19:40:23Z | SHAW | ···· | SEAN | 19711201 | — | — | — | SEAN.SHAW@PROTON.ME | NULL | NULL | NULL | UNKNOWN | GRP-2714 | CORE-HMO |
| TPA | TPA-64386 | 2026-10-03T22:10:20Z | Ann | — | Lewis | 1960-10-11 | UHC-05814-43 | UNKNOWN | 815.934.3553 | null | 7741 Mesa Drive | Tampa | FL | 33681 | null | ·NULL |
| TPA | TPA-63190 | 2026-06-23T07:42:39Z | Catherine | ·· | Larson·· | 1971-12-20 | UHC-21179-85 | null | — | — | 2721 Sunset Boulevard | San Diego | CA | 92109 | null | — |
| TPA | TPA-54124 | 2026-03-15T19:02:25Z | ·Marcus | — | Howell | 1970-01-07 | null | N/A | 803-789-4745 | marcus.howell@outlook.com | 521 MOUNTAIN VIEW DR | Denver | CO | 80240 | GRP-8768 | — |
| TPA | TPA-53527 | 2026-08-31T01:45:14Z | Olivia | — | Peterson | 1978-10-24 | ·UHC-16205-24 | •••-••-9630 | — | — | null | — | N/A | — | null | N/A |
| TPA | TPA-51156 | 2026-05-25T09:23:25Z | Rebecca | — | ·Mitchell | 1963-07-21 | - | •••-••-3637 | — | — | 6206 Bayshore Dr | Houston | TX | 77099 | — | NAVIGATE-HMO |
| TPA | TPA-52560 | 2026-01-23T04:47:03Z | MATT | — | ·RYAN | 1972-02-10 | UHC-87039-03 | null | 841-943-9485 | — | 2434 WILLOW COURT | EDEN PRAIRIE | MN | 55386·· | NULL | — |
| TPA | TPA-63289 | 2026-07-27T06:41:38Z | ·SCOTT | B. | ·HOWELL | 1997-12-18 | UHC-04080-62 | •••-••-1005 | - | N/A | 1511 WILLOW CT | SCOTTSDALE | AZ·· | 85241 | null | MEDICARE-ADV-A |
| TPA | TPA-51444 | 2026-09-27T12:00:16Z | brruce | — | ·schultz | 1995-08-09 | null | — | +1 734 251 5216 | N/A | — | — | — | N/A | NULL | CORE-HMO |
| TPA | TPA-50668 | 2026-03-06T17:09:26Z | PATRICK | — | ·HENRY | 1975-08-15 | UHC-39305-02 | •••-••-7400 | 615-226-8122 | — | 4132 Palm Dr | Glendale·· | Arizona | 85350 | - | - |
| TPA | TPA-60508 | 2026-01-23T23:26:59Z | Fatima | — | Carroll | 19450308 | — | UNKNOWN | ···· | — | 3295 Market Street | San Diego | California | 92124 | GRP-5830 | — |
| TPA | TPA-54904 | 2026-02-25T15:32:29Z | Betty | L·· | Wheeler | 2002-10-15 | — | — | 298.946.8378 | — | 2733 Church St | Charlotte | ·NC | 28288 | — | — |
| TPA | TPA-62194 | 2026-03-04T19:36:15Z | Duncan, Russell | ···· | — | 1988-08-26 | NULL | UNKNOWN | N/A | russell.duncan88@hotmail.com | 9339 Apache Boulevard | Scottsdale | ·AZ | 85245 | ·GRP-1374 | — |
| TPA | TPA-55548 | 2026-03-11T10:15:25Z | Roy | — | Hart | 1938-02-10 | — | — | — | N/A | 241 Forest Ave #287 | ·SAN ANTONIO | TX | 78202 | GRP-4491 | MEDICARE-ADV-A |
| TPA | TPA-61515 | 2026-03-16T04:43:34Z | Dorothy | — | Peterson | 1947-10-04 | null | •••-••-1649 | null | null | 1631 CAMELBACK RD | PHOENIX | Arizona | ·85062 | UNKNOWN | — |
| TPA | TPA-63740 | 2026-06-14T18:32:19Z | Julia | M | Roberts | 4/19/1944·· | ·· | N/A | — | null | 5684 Mesa Dr | SAN ANTONIO | TX | 78207 | N/A | UNKNOWN |
| TPA | TPA-59371 | 2026-08-17T16:00:51Z | Christine | U | Ferguson | 9/16/2003 | UHC-41567-67 | - | — | UNKNOWN | 541 Sage Court | FRESNO | CA | 93728 | — | — |
| TPA | TPA-54869 | 2026-06-09T03:52:39Z | Garcia, Lori | T | — | 1993-06-24 | NULL | •••-••-1296 | — | null | 988 Sage Ct | Tampa | FL | 33691 | null | CORE-HMO·· |
| TPA | TPA-60492 | 2026-04-21T02:02:04Z | Jacob | — | Turner | 1993-10-01 | UNKNOWN | — | — | — | 5366 Church Street | NASHVILLE | TN | 37234 | ·GRP-9158 | UNKNOWN·· |
| TPA | TPA-53477 | 2026-01-25T11:35:13Z | MARIA | — | ARNOLD | 1986-03-13 | — | NULL | 747.870.5305 | UNKNOWN | 3117 VALLEY VIEW DRIVE | Mesa | AZ | 85229 | null | NAVIGATE-HMO |
| TPA | TPA-62302 | 2026-04-27T13:45:10Z | DONNA | — | GONZALES | 1979-10-06 | - | - | — | -·· | 6371 Lake View Rd | Eden Prairie | MN | 55356 | N/A | — |
| TPA | TPA-58709 | 2026-04-30T05:34:38Z | Judy | — | Cox | 12/06/86 | — | — | UNKNOWN | — | 6375 Baseline Rd | San Diego | CA | 92186 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-60919 | 2026-01-17T06:56:16Z | Bobby | ···· | Riley | 03/26/1960 | UHC-22969-34 | UNKNOWN | NULL | - | 2284 MAIN STREET | Denver | CO | 80205 | GRP-0296 | SELECT-EPO·· |
| TPA | TPA-54627 | 2026-01-25T06:19:40Z | Christine | — | Gonzales | 05/07/1942 | — | •••-••-3387 | (439) 679-9045 | NULL | 1128 Valley View Drive #687 | Miami | FL | 33127 | GRP-1573 | CORE-HMO |
| TPA | TPA-57091 | 2026-05-14T22:24:08Z | Rebecca | — | Collins | ·1972-06-13 | NULL | •••-••-3354 | ···· | REBECCA.COLLINS@OUTLOOK.COM | — | - | — | — | GRP-2957 | MEDICARE-ADV-A |
| TPA | TPA-59928 | 2026-07-14T22:08:18Z | brittany | — | sandoval | 13-09-1963 | NULL | UNKNOWN | 3088895811 | BRITTANY.SANDOVAL84@PROTON.ME | 9865 Desert Sky Boulevard | Eden Prairie | MN | 55339 | GRP-5457 | NULL·· |
| TPA | TPA-53427 | 2026-02-25T15:08:27Z | Ben | — | Webb | 24-03-1967 | UHC9118173 | •••-••-6253 | 4184709271 | — | 9584 Hillcrest Road | San Diego | CA | 92173 | GRP-1550 | - |
| TPA | TPA-54318 | 2026-01-18T17:36:51Z | Omar·· | — | Foster | 5/16/1992 | N/A | — | +1 240 714 7100 | null | 5197 Highland Avenue | Minneapolis·· | MN·· | 55484 | - | - |
| TPA | TPA-54573 | 2026-08-04T19:54:28Z | Sofia | — | Porter | ·1971-07-26 | NULL | •••-••-9426 | 594.876.5195 | SOFIA.PORTER@PROTON.ME | — | NULL | null | UNKNOWN | ·GRP-8668 | — |
| TPA | TPA-63726 | 2026-09-23T03:50:12Z | stephen | — | washington | 1950-03-07 | null | - | (953) 904-4656 | stephen.washington@proton.me | 7605 Sunset Boulevard #439 | Las Vegas | NV | 89130 | - | UNKNOWN |
| TPA | TPA-51930 | 2026-02-01T17:43:17Z | FRANK | — | ARMSTRONG | 2001-11-08 | UHC-20722-59 | •••-••-9029 | -·· | ·frank.armstrong94@gmail.com | 2103 Forest Ave | Houston | TX | 77016 | N/A | — |
| TPA | TPA-57356 | 2026-07-05T11:21:58Z | Willis, Jerry | F | — | 1998-02-11 | UNKNOWN·· | null | N/A | null | 5985 Camelback Rd | Glendale | AZ | 85396 | NULL | - |
| TPA | TPA-64260 | 2026-09-02T23:01:25Z | Jerry | — | Weber | 02/02/07 | UNKNOWN | •••-••-4213 | - | N/A | 1357 Union St | EDEN PRAIRIE | MN | ···· | - | SELECT-EPO |
| TPA | TPA-50340 | 2026-05-25T17:18:37Z | ·Carlos | ···· | Greene | 1993-10-02 | — | •••-••-0534 | UNKNOWN | — | 1104 Ridge Rd | Las Vegas | NV | 89113 | — | N/A |
| TPA | TPA-61682 | 2026-05-27T14:53:39Z | Dennis | — | Patterson | 19690328 | NULL | UNKNOWN·· | — | ·UNKNOWN | ·3295 Market Street #470 | Eden Prairie | MN | 55374 | ···· | OPTIONS-PPO |
| TPA | TPA-60365 | 2026-05-06T04:45:36Z | ryan | — | ·cox | 1954-05-17·· | N/A | •••-••-2095 | ·UNKNOWN | NULL | 8127 DESERT SKY BLVD | Phoenix | AZ | 85056 | — | — |
| TPA | TPA-51975 | 2026-02-28T00:12:22Z | sofia | — | lynch | 1995-01-03 | - | null | N/A | NULL | 2142 MEADOW LANE | Dallas | TX | 75270 | — | — |
| TPA | TPA-57661 | 2026-06-02T05:54:31Z | Morris, Kelly | — | — | 1994-11-22 | — | ···· | NULL | kelly.morris@proton.me | 6358 Sage Court | Orlando | FL | 32856 | — | — |
| TPA | TPA-52094 | 2026-04-30T09:16:23Z | BRADLEY | ·· | SCHMIDT·· | Apr 16, 1954 | — | •••-••-9408 | 957-353-5031 | — | 7492 Camelback Road | Eden Prairie | MN | 55395 | null | — |
| TPA | TPA-56274 | 2026-08-27T03:03:46Z | JANIKE | — | HUNTER | 1982-03-04 | UHC-06562-97 | NULL | - | janice.hunter55@icloud.com | 4443 Jefferson Ave | Chandler | AZ | 85246-7623 | — | — |
| TPA | TPA-54906 | 2026-09-28T08:43:12Z | Mark | P | ·Kennedy | 2004-06-24 | — | — | null·· | NULL | 8236 MAIN STREET | Jacksonville | Florida | 32202 | null | — |
| TPA | TPA-61644 | 2026-08-10T06:07:04Z | Sandra | ·· | Morrison | 2004-08-01 | NULL | N/A | (320) 330-9882 | — | 1976 SPRING STREET | ·GILBERT | AZ | 85268 | GRP-3141 | — |
| TPA | TPA-50051 | 2026-01-20T01:53:21Z | Dylan | — | Reed | 1950-04-23 | N/A | UNKNOWN | 5409818923 | NULL | 5538 Park Pl | Gilbert | AZ | 85209 | GRP-2673 | — |
| TPA | TPA-58467 | 2026-04-26T17:39:26Z | Angela | ···· | Murray | 2004-11-25 | — | — | NULL | - | 53 ELM STREET | Nashville | TN | 37215 | null | 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-22T12:42:43.614Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty