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-52392 | 2026-06-07T06:20:30Z | ·Jesse | — | Hughes | 06/22/1956 | ·UNKNOWN | NULL | N/A | — | - | — | null | — | null | UNKNOWN |
| TPA | TPA-62760 | 2026-03-11T03:52:29Z | Susan | I | Fields | ·1959-01-25 | UHC-67312-24 | — | N/A | susan.fields11@outlook.com | 8220 Grand Ave | ATLANTA | ga | UNKNOWN | null | — |
| TPA | TPA-60379 | 2026-02-11T12:38:18Z | ·ethan | K. | phillips | 1996-03-07 | UHC-99113-47·· | •••-••-0171 | (553) 998-1186 | null | 8497 Oak Street | Gilbert | AZ | 85282 | NULL | — |
| TPA | TPA-57197 | 2026-02-14T04:47:25Z | Lori | — | Walsh | ·1995-11-06 | N/A | •••-••-2908 | — | null | N/A | NULL | — | - | N/A | — |
| TPA | TPA-51434 | 2026-07-17T02:00:27Z | ·Judy | — | Harvey | 5/25/1961 | N/A | — | NULL | - | 6205 Highland Avenue | San Antonio | tx | 78210 | NULL | null |
| TPA | TPA-54610 | 2026-05-18T21:57:13Z | KAYLA | — | BAILEY·· | 1981-10-10 | — | null | (641) 974-0117 | — | 5758 PINE DRIVE Apt 24 | Columbus | OH | 43256 | UNKNOWN | - |
| TPA | TPA-52708 | 2026-08-31T18:46:25Z | ALAN | W | TRAN | 1970-06-06 | null | — | 4134792832 | UNKNOWN | 7475 Valley View Drive | Nashville | TN | 37292 | N/A | null |
| TPA | TPA-61510 | 2026-02-09T01:10:34Z | Arnold, Wei | — | — | 1976-05-23 | UHC-93430-91·· | N/A | (593) 649-6455 | UNKNOWN | 9213 Pine Dr | Glendale | AZ | 85331-2525 | — | — |
| TPA | TPA-51957 | 2026-05-09T13:41:15Z | Mason | — | Duncan | 4/28/1984 | — | null | NULL | ·- | — | — | — | — | GRP-9429 | MEDICARE-ADV-A |
| TPA | TPA-50678 | 2026-07-27T01:09:17Z | Jordan | — | Rice | 2007-11-12 | null | N/A | NULL | N/A | 6869 RIDGE ROAD | MIAMI | Florida | 33112 | — | null |
| TPA | TPA-53276 | 2026-06-03T00:50:33Z | THERSEA | — | LITTLE | 1957-10-27 | null | •••-••-5259 | 247-540-2381 | — | ·3599 Meadow Ln | Eden Prairie | MN | - | GRP-7435 | NULL·· |
| TPA | TPA-51380 | 2026-05-16T15:18:16Z | paul | — | holmes | 1975-10-09 | UNKNOWN | •••-••-9106 | +1 841 290 9308 | N/A | 8631 Canyon Rd | Scottsdale | AZ | 85245 | GRP-6870·· | UNKNOWN |
| TPA | TPA-58949 | 2026-03-01T17:08:47Z | JEAN | G | MARTIN | 1980-08-25 | - | UNKNOWN | — | UNKNOWN | - | — | UNKNOWN | null | GRP-1341 | SELECT-EPO |
| TPA | TPA-55511 | 2026-03-28T13:17:29Z | Henry | — | Pierce | 2007-07-20 | — | UNKNOWN | 917-913-8692 | NULL | 6795 PARK PL | Plano | TX | 75007·· | UNKNOWN | CORE-HMO |
| TPA | TPA-54897 | 2026-03-22T11:51:32Z | Jose | ·· | Morrison | Aug 14, 1962 | null | •••-••-7863 | — | — | 3629 Park Place | Tucson | ·AZ | - | — | NAVIGATE-HMO |
| TPA | TPA-59996 | 2026-01-26T02:41:02Z | Julie | — | Weaver | 19770906 | null | •••-••-0072 | null | NULL | NULL | NULL | null | — | null | — |
| TPA | TPA-54496 | 2026-02-24T22:21:13Z | Martha | — | ·Price | UNKNOWN | — | UNKNOWN | 18369054353 | — | null | — | UNKNOWN | — | GRP-0545 | - |
| TPA | TPA-50090 | 2026-02-24T23:48:45Z | isabella | — | fernandez | 1959-07-24 | — | •••-••-6367 | — | — | 9875 Forest Avenue | Eden Prairie | MN | 55304 | GRP-4599 | N/A |
| TPA | TPA-53968 | 2026-01-09T01:44:51Z | Alice | — | Franklin | ···· | null | - | (626) 522-6363·· | — | 845 BROADWAY | Tampa | FL | 33628-8194 | — | MEDICARE-ADV-A |
| TPA | TPA-58378 | 2026-01-16T03:55:19Z | Willie | F | Ray | 1961-09-01 | UHC-49421-70 | ·null | UNKNOWN | ·WILLIE.RAY77@OUTLOOK.COM | 271 Valley View Drive | Las Vegas | NV | UNKNOWN | GRP-6777 | - |
| TPA | TPA-60927 | 2026-08-31T21:17:27Z | ·Heather | — | Carr | 1940-09-28 | null | null | null | N/A | 7272 SPRING STREET | San Antonio | Texas | 78284 | GRP-1362 | — |
| TPA | TPA-54254 | 2026-05-17T05:48:26Z | Christian | — | Morales·· | Mar 3, 1962 | — | UNKNOWN | — | christian.morales85@icloud.com | 2651 PALM DRIVE Apt 3 | MIAMI | FL | 33117·· | GRP-9935 | ·N/A |
| TPA | TPA-57129 | 2026-08-21T12:37:44Z | Nicholas | ···· | Alexander | 04/25/89 | NULL | •••-••-9411 | 7916354300 | NULL | 6192 Canyon Road | MESA | AZ | 85282 | — | MEDICARE-ADV-B |
| TPA | TPA-57543 | 2026-04-03T04:04:22Z | Owens, Nicole | — | — | 9/15/1974 | N/A | null·· | — | N/A | NULL | — | null | - | null | - |
| TPA | TPA-63057 | 2026-04-15T20:09:28Z | Marya | — | Stone | 1970-12-01 | — | •••-••-7873 | — | — | 2623 Church Street | San Diego | CA | UNKNOWN | — | UNKNOWN |
| TPA | TPA-59323 | 2026-08-22T16:47:38Z | Alice | — | Gonzalez | 1968-02-14 | NULL | •••-••-4801 | 9108248546 | NULL | 8283 Mesa Dr | Sacramento | CA | 95872 | GRP-4208 | — |
| TPA | TPA-55267 | 2026-08-08T20:56:37Z | Gonzales, Martha | N. | — | 8/18/2002 | null | •••-••-6070 | +1 719 481 0776 | martha.gonzales@gmail.com | 4367 CHURCH ST | Scottsdale | AZ | 85254 | N/A | CORE-HMO |
| TPA | TPA-54316 | 2026-01-03T23:29:46Z | charlotte | — | mills | 22-05-1978 | N/A | NULL | — | — | 352 Ridge Rd | Tempe | AZ | 85251 | null | ·OPTIONS-PPO |
| TPA | TPA-54215 | 2026-09-24T22:17:53Z | DANIELLE | — | TORRES | 16-09-2003 | ···· | — | 855.832.4572 | danielle.torres70@outlook.com | 4732 Willow Court·· | CHANDLER | AZ | 85293 | N/A | — |
| TPA | TPA-51404 | 2026-02-15T02:32:24Z | Zachary | — | Reynolds | 2006-09-10 | NULL | null | (907) 767-2286 | UNKNOWN·· | 1038 Main St | ·Plano | TX | 75037 | ·NULL | null |
| TPA | TPA-54514 | 2026-08-19T00:17:21Z | DONNA | — | HOFFMAN | ·UNKNOWN | - | — | 14402656997 | donna.hoffman57@outlook.com | 5099 Canyon Road | COLUMBUS | OH | 43264 | GRP-3895 | MEDICARE-ADV-A |
| TPA | TPA-54995 | 2026-05-25T14:06:58Z | sndra | — | clark | 1967-09-06 | - | — | NULL | - | 9762 Apache Boulevard | Gilbert | AZ | 85260 | — | OPTIONS-PPO |
| TPA | TPA-53442 | 2026-01-08T23:07:10Z | DENISE | — | LANE | 1943-08-19 | UNKNOWN | N/A·· | +1 386 361 6140 | — | 8532 Sage Court | Houston | Texas | 77041 | GRP-2309 | CHOICE-PLUS-PPO |
| TPA | TPA-56990 | 2026-08-29T13:35:09Z | SANDRA | ···· | ·RUSSELL | 1995-02-25 | - | — | 615-821-3623 | N/A | 6195 Main St | Tempe | AZ | 85275 | GRP-7966 | CORE-HMO |
| TPA | TPA-61968 | 2026-06-12T15:07:05Z | JUSTIN·· | — | COX | 24-02-1948 | UNKNOWN | •••-••-6014 | — | UNKNOWN | 614 Ridge Road | Atlanta·· | GA·· | 30383 | NULL | null |
| TPA | TPA-63085 | 2026-10-18T22:00:29Z | DYLAN·· | — | FERNANDEZ·· | 20060809 | - | — | - | ·· | 467 Indian School Rd | Denver | CO | 80234-9087 | GRP-0792·· | MEDICARE-ADV-A |
| TPA | TPA-52572 | 2026-07-07T19:03:12Z | Jacob | — | ·Sullivan | 2008-05-24 | ·- | UNKNOWN | null | N/A | 1349 Ocean Ave | Scottsdale | AZ | NULL | NULL | NULL |
| TPA | TPA-64027 | 2026-05-13T23:12:21Z | ·DANIELLE | ·· | RODRIGUEZ | 1978-12-08 | — | — | NULL | danielle.rodriguez@yahoo.com | 4491 Pine Drive | Columbus | OH | 43250 | N/A | - |
| TPA | TPA-54264 | 2026-07-28T08:17:50Z | Kimberly | — | Hernandez | 1979-10-17 | - | NULL | 728.806.6834 | — | 1697 Desert Sky Boulevard | Chandler | AZ | 85254 | ·· | MEDICARE-ADV-A |
| TPA | TPA-62866 | 2026-08-08T10:02:20Z | James | G | Herrera | 2005-03-03 | N/A | •••-••-6859 | — | james.herrera@gmail.com | 4491 Church Street | DENVER | CO | 80228 | GRP-8823 | null |
| TPA | TPA-58799 | 2026-04-05T13:30:59Z | DOUGLAS | ···· | ·LUNA | 11/25/1990 | UNKNOWN | — | 336-718-3888 | null | 8652 Willow Court | Atlanta | GA | 30367 | UNKNOWN | null |
| TPA | TPA-59395 | 2026-01-01T09:18:05Z | ·cynthia | — | baker | 1939-09-16 | — | N/A | — | — | 5643 PARK PL | ·Phoenix | AZ | 85044 | — | CORE-HMO |
| TPA | TPA-57687 | 2026-06-30T19:12:43Z | JESSICA | — | FERNANDEZ | ·1951-04-07 | - | — | null | - | 3338 HIGHLAND AVE | AUSTIN | TX·· | NULL·· | - | MEDICARE-ADV-B |
| TPA | TPA-63375 | 2026-06-03T18:22:21Z | NATALIE | Z. | SILVA | 1982-06-24 | — | — | - | — | 6923 BAYSHORE DR·· | Eden Prairie | MN | UNKNOWN | GRP-7877 | CORE-HMO |
| TPA | TPA-54230 | 2026-07-26T07:14:51Z | Kim, Jeremy | — | — | 09/06/1942 | null·· | •••-••-5450 | null | NULL | — | - | N/A | UNKNOWN | — | UNKNOWN |
| TPA | TPA-64193 | 2026-07-03T15:50:45Z | ISABELLA | K | MENDOZA | 1939-09-25 | UHC-57834-93·· | — | 607-721-3717 | — | null | ·N/A | - | - | null | — |
| TPA | TPA-57871 | 2026-05-08T06:24:07Z | Alexander | — | Wood | 1960-12-15 | - | •••-••-7035 | NULL | — | 5121 JEFFERSON AVENUE | Scottsdale | AZ | 85212 | GRP-8927 | ·NULL |
| TPA | TPA-55713 | 2026-06-09T18:54:32Z | Laura | C | Hill·· | 1985-12-11 | ·- | •••-••-6103 | — | NULL | 3213 SUNSET BLVD | Sacramento | CA | 95897 | GRP-8454 | — |
| TPA | TPA-61470 | 2026-09-24T02:13:52Z | Guerrero, Dylan | ·G. | — | 10/15/01 | — | •••-••-2588 | - | — | — | — | — | - | — | - |
| TPA | TPA-63724 | 2026-09-13T11:58:28Z | Ashley | — | Mendoza | 09-02-1974 | UHC1009884·· | null | 5016939670 | ASHLEY.MENDOZA@AOL.COM | NULL | — | ·N/A | — | GRP-9166 | — |
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.408Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty