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-58335 | 2026-08-18T19:27:03Z | mariana | — | ferguson | 1992-09-24·· | — | - | null | mariana.ferguson72@outlook.com | UNKNOWN·· | — | — | — | null | null |
| TPA | TPA-58448 | 2026-01-12T03:25:35Z | DONNA | — | STONE | 18-10-1996 | UNKNOWN | UNKNOWN | N/A·· | ·- | 8866 Grand Avenue #816 | JACKSONVILLE | FL | 32259 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-62947 | 2026-06-02T08:32:22Z | AMBER | — | FOWLER | 19780217 | N/A | - | +1 556 511 5934 | — | 355 Maple Ave | Columbus | OH·· | 43264 | NULL | MEDICARE-ADV-A |
| TPA | TPA-61471 | 2026-09-16T07:43:55Z | ·Ethan | — | Sanchez | 1971-12-04 | UHC-35179-03 | — | N/A | UNKNOWN | 1217 OAK ST | San Antonio | tx | 78252 | GRP-1709 | - |
| TPA | TPA-57608 | 2026-06-29T00:17:23Z | Barbara | ···· | Garza | 1980-86-23 | NULL | null | ·null | — | 3720 MESA DR | Dallas | TX | 75268 | GRP-3315 | CORE-HMO |
| TPA | TPA-58708 | 2026-02-20T00:35:17Z | camila | ·· | maldonado | 1945-12-01 | UNKNOWN | — | 710-889-4874 | null | UNKNOWN | N/A | null | N/A | NULL | MEDICARE-ADV-B |
| TPA | TPA-52782 | 2026-05-23T03:15:30Z | JASON | Z. | MORALES·· | 1947-11-11 | NULL | •••-••-7228 | 17029978960 | — | 3993 Desert Sky Blvd | Charlotte | NC | 28246 | -·· | — |
| TPA | TPA-51951 | 2026-02-22T16:17:21Z | ·Boyd, Willie | — | — | ·10/16/04 | UHC-34280-19 | •••-••-5586 | — | null | 2977 River Rd | Gilbert | AZ | ·85261 | UNKNOWN | ···· |
| TPA | TPA-54211 | 2026-04-07T00:19:13Z | Garzza | — | Justin | 1950-05-24 | ···· | — | 826.783.1888 | N/A | 3979 Park Pl | COLUMBUS·· | OH | 43216 | - | — |
| TPA | TPA-54635 | 2026-03-17T15:29:39Z | Madison | — | Wheeler | 2008-01-14 | ·UNKNOWN | •••-••-9652 | 5154299 | — | 4424 Forest Avenue | Columbus | OH | 43276 | — | options-ppo |
| TPA | TPA-59537 | 2026-06-05T23:31:58Z | Larry | — | Simpson | Jan 25, 1973 | - | - | — | — | — | ·NULL | N/A | — | GRP-3770 | SELECT-EPO |
| TPA | TPA-53576 | 2026-03-27T04:39:45Z | RICHARD | — | SILVA | 2005-06-25 | UHC-51819-30 | ·null | ·244-350-6833 | — | 4024 Lake View Rd | Gilbert | AZ | — | GRP-8876 | null |
| TPA | TPA-61989 | 2026-04-15T23:34:39Z | STEVEN | N.·· | WELCH | 2002-11-08 | UHC-34050-08 | - | — | null | 9598 Mountain View Drive | Atlanta | GA | 30368 | — | NULL |
| TPA | TPA-60490 | 2026-04-25T13:59:42Z | Ralph | M | Fisher | 18-03-1989 | UHC-77097-62 | - | ·null | ralph.fisher@hotmail.com | 5993 BAYSHORE DR | Las Vegas | NV | — | N/A | OPTIONS-PPO |
| TPA | TPA-53165 | 2026-07-06T19:39:34Z | jason | F. | ryyan | 06/10/93 | — | null | — | - | 1933 LAKE VIEW ROAD | Gilbert·· | AZ | 85207-0159 | GRP-8340 | null |
| TPA | TPA-55399 | 2026-03-17T03:03:19Z | ralph | — | fox | 1970-06-04 | NULL | UNKNOWN | null | null | 2658 Indian School Road·· | Orlando·· | FL | 32800 | null | N/A |
| TPA | TPA-56326 | 2026-01-28T03:35:46Z | Theresa | B. | Mills | 2000-03-14 | NULL | — | -·· | — | 2359 Market Street | ·TUCSON | AZ | 85714 | NULL·· | medicare-adv-a·· |
| TPA | TPA-54293 | 2026-02-17T07:31:18Z | AMBER | — | LI | 1943-02-26 | - | — | — | — | 2607 Apache Blvd #414·· | Eden Prairie | MN | 55397 | — | — |
| TPA | TPA-60217 | 2026-08-05T19:36:24Z | lisa | S | anderson | 1951-12-09 | null·· | •••-••-4127 | N/A | ···· | 2347 Market St | Jacksonville | FL | 32216 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-59020 | 2026-02-04T08:06:27Z | Jose | N. | Wells | 06/15/1968 | — | - | 4147465634 | null | 409 Baseline Road | Chandler | AZ | 85238 | — | — |
| TPA | TPA-52007 | 2026-06-24T20:02:32Z | Gary | — | ·Hansen | 1975-05-10 | N/A | — | UNKNOWN | — | NULL | — | - | — | GRP-3801 | — |
| TPA | TPA-51428 | 2026-04-05T17:06:04Z | Jacob | — | Larson | 1956-04-26 | uhc-52805-48 | ·NULL | 4215827082 | - | — | UNKNOWN | — | — | UNKNOWN | UNKNOWN |
| TPA | TPA-58879 | 2026-06-25T01:31:40Z | SCOTT | ·· | HUGHES | 1958-01-10 | UHC-53716-26 | •••-••-3559 | — | - | 5069 Lincoln Way | ORLANDO | FL | 32854·· | — | UNKNOWN |
| TPA | TPA-57914 | 2026-09-03T09:29:02Z | Lawrence | — | Garrett | 1997-06-23 | N/A | N/A·· | — | — | 2120 Lake View Rd | Eden Prairie | MN | 55355 | null | NAVIGATE-HMO |
| TPA | TPA-60554 | 2026-04-09T12:39:59Z | LUIS | — | HUNT | 19460312 | UNKNOWN | - | — | UNKNOWN·· | — | N/A | NULL | — | GRP-2043 | — |
| TPA | TPA-56618 | 2026-09-19T01:11:48Z | Diego·· | — | Armstrong | 1954-07-13 | null | •••-••-9275 | +1 957 558 3266 | NULL | ·6146 Canyon Road | Dallas | Texas | 75284 | null | — |
| TPA | TPA-52348 | 2026-03-17T16:42:40Z | SOPHIA | — | HUGHS | 23-11-2006 | NULL | — | N/A | N/A | 2143 BAYSHORE DRIVE | Tempe | Arizona | 85230 | GRP-1599 | MEDICARE-ADV-B |
| TPA | TPA-61874 | 2026-01-17T16:16:22Z | PHILIP | — | JOHNSTON | 1966-07-26 | ···· | •••-••-4955 | ·null | N/A | 9556 River Road | Tucson | Arizona | 85789 | — | ···· |
| TPA | TPA-54094 | 2026-04-05T11:12:20Z | Jessica | — | Ellis | 1997-03-05 | NULL | NULL | (890) 818-4992 | ···· | N/A | NULL | — | null | ·· | ···· |
| TPA | TPA-55891 | 2026-09-27T20:36:38Z | ·nicholas | — | ·gibson | 2005-05-25 | UHC-22877-52 | •••-••-4387 | — | - | 8407 Ocean Avenue | AUSTIN | TX | 78718 | N/A | NULL |
| TPA | TPA-59623 | 2026-01-10T16:19:46Z | TERRY | — | POWELL | Jun 24, 1971 | UHC-79657-29 | — | (265) 763-4139 | TERRY.POWELL@YAHOO.COM | 3918 MAPLE AVE | Austin·· | TX | N/A | ···· | N/A |
| TPA | TPA-58437 | 2026-03-27T00:53:44Z | Judith | — | Gray | 1951-09-12 | N/A | NULL | - | JUDITH.GRAY44@YAHOO.COM | 5837 HILLCREST ROAD | Eden Prairie | MN | 55360 | UNKNOWN | NULL |
| TPA | TPA-61158 | 2026-05-03T16:15:17Z | Ahmed | ·· | Hoffman | 1979-12-22·· | — | •••-••-4533 | 397.975.6989·· | ahmed.hoffman@hotmail.com | 1307 PINE DR | Dallas | TX | 75200 | N/A | UNKNOWN |
| TPA | TPA-52788 | 2026-01-31T22:37:27Z | Ryan | ···· | Rios | 1797-01-16 | — | — | UNKNOWN | null | 4656 Maple Ave | Miami | fl | 33173 | — | CHOICE-PLUS-PPO |
| TPA | TPA-56941 | 2026-10-08T11:54:54Z | JEFFREY | — | EVANS | 1997-04-07 | NULL | •••-••-6878 | — | null | 9743 SUNSET BLVD·· | JACKSONVILLE | FL | 32221 | — | null |
| TPA | TPA-54172 | 2026-02-20T23:18:27Z | Isabella | — | Parker | ·1955-02-11 | N/A | •••-••-8799 | 380-315-5498 | NULL | 3506 Grand Avenue | GLENDALE | AZ | 85339 | NULL·· | — |
| TPA | TPA-57681 | 2026-04-15T01:45:06Z | jess | ···· | ·rios | 2005-04-05 | — | - | - | UNKNOWN | 656 Hillcrest Road | Jacksonville | FL | 32277 | UNKNOWN | — |
| TPA | TPA-63115 | 2026-02-22T21:19:24Z | Snyder, Christine | — | — | 19930425 | — | NULL | — | christine.snyder@outlook.com | 5818 River Rd | ·Gilbert | AZ | 85299 | — | UNKNOWN |
| TPA | TPA-62917 | 2026-07-18T17:14:31Z | Sophia | — | Mendoza | ·02/04/2002 | — | NULL·· | 8356945 | — | 2611 Lake View Road | Gilbert | AZ | 85235 | GRP-0834 | CORE-HMO |
| TPA | TPA-61957 | 2026-04-18T19:24:10Z | Lauren | — | Reyes | 1969-12-25 | — | - | (632) 458-1766 | N/A | 6923 Main Street Apt 21 | Las Vegas | NV | 89123 | NULL | ·UNKNOWN |
| TPA | TPA-51892 | 2026-05-05T13:16:29Z | Raymond | — | Hanon | May 20, 1990 | NULL | •••-••-6383 | null | — | 3321 GRAND AVE | Atlanta | GA | 30388 | GRP-2799 | CORE-HMO |
| TPA | TPA-58849 | 2026-10-06T19:34:56Z | ANDREA | — | ·KIM | 1945-04-05 | ·NULL | ·· | null | — | 4014 Washington Street | Charlotte | NC | 28255 | null | — |
| TPA | TPA-54160 | 2026-01-19T18:29:52Z | diana | — | woods | 1989-12-02 | — | •••-••-4364 | +1 655 325 7920 | - | 795 Sage Court | San Diego | CA | 92137 | — | null |
| TPA | TPA-60264 | 2026-06-25T10:32:02Z | Harold | — | Ramirez | NULL | - | N/A | — | — | 6606 Forest Ave | Charlotte | NC | 28260 | UNKNOWN | UNKNOWN |
| TPA | TPA-55431 | 2026-03-24T19:37:02Z | JUAN | — | SANTIAGO | ·05/17/88 | null | ·null | 859-303-4625 | — | 166 Union St | PLANO·· | Texas | 75037 | NULL | MEDICARE-ADV-A |
| TPA | TPA-63972 | 2026-05-21T19:33:05Z | Samantha | — | Meyer | 1994-09-03 | ···· | null | 427-552-6247 | NULL·· | — | - | ·UNKNOWN | — | — | OPTIONS-PPO |
| TPA | TPA-54170 | 2026-01-15T14:43:52Z | Helen | — | Garza | 14-10-1945·· | — | UNKNOWN | - | NULL | 1514 HIGHLAND AVE | EDEN PRAIRIE | MN | 55378 | GRP-5200 | N/A |
| TPA | TPA-61983 | 2026-05-23T05:16:34Z | FATIMA | Y | FISHER | UNKNOWN | N/A | UNKNOWN | 5763013331 | fatima.fisher@aol.com | 8668 Oak St | San Diego | CA | 92121·· | — | — |
| TPA | TPA-56890 | 2026-06-08T06:16:48Z | AUSTIN | — | REID | 6/25/1958 | UNKNOWN | ·null | ·623-443-9959 | austin.reid48@outlook.com | 6147 Harbor Blvd | Mesa | az | — | GRP-1410 | - |
| TPA | TPA-56538 | 2026-07-18T12:21:34Z | ·henry | — | perkins | 1980-07-05 | NULL | •••-••-1054 | 451.906.0510 | NULL | N/A | - | - | — | GRP-8785 | NULL |
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:37.728Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty