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-52989 | 2026-07-30T17:33:20Z | JACOB | — | KING | 1970-03-14 | - | •••-••-7035 | — | JACOB.KING64@YAHOO.COM | 7963 Lake View Rd | Tempe | AZ | null | -·· | — |
| TPA | TPA-58023 | 2026-04-03T18:15:19Z | Julia | — | Tran | 07/16/73 | N/A | UNKNOWN | N/A | UNKNOWN | 7521 Meadow Lane | SACRAMENTO | CA | 95824 | — | UNKNOWN |
| TPA | TPA-57528 | 2026-02-12T04:22:18Z | Brian | — | Gutierrez | 1995-03-11 | UHC-44758-23 | null | — | ·- | 6475 CENTRAL AVENUE | Sacramento | CA | 95874 | UNKNOWN | UNKNOWN |
| TPA | TPA-63163 | 2026-04-04T00:04:10Z | Densie | — | Lynch | 1965-06-12 | NULL | UNKNOWN | (870) 628-0498 | UNKNOWN | 4354 SUNSET BOULEVARD | Phoenix | Arizona | — | — | — |
| TPA | TPA-58920 | 2026-09-01T05:12:33Z | JANICE | — | LUCAS | 1943-11-03 | — | •••-••-0504 | — | N/A | 4330 Oak Street | Fresno | CA·· | 93759 | — | — |
| TPA | TPA-50422 | 2026-03-26T20:47:47Z | KAYLA | — | HARRIS | 1946-08-10 | — | •••-••-1943 | N/A | — | 1704 ELM STREET | Seattle | WA | ·98114 | GRP-8535 | N/A |
| TPA | TPA-51738 | 2026-03-18T18:11:48Z | ETHAN | — | RIOS | 19920513 | NULL | NULL | — | null | ·· | null | UNKNOWN | UNKNOWN | UNKNOWN | NULL |
| TPA | TPA-57629 | 2026-04-01T17:47:29Z | ·Judith | — | Aguilaar·· | 1973-09-08 | ·null | — | 2192322792 | JUDITH.AGUILAR@PROTON.ME | 7008 Hillcrest Road | Atlanta | GA | 30303 | GRP-7970·· | N/A |
| TPA | TPA-62645 | 2026-06-22T19:49:51Z | KATHLEEN·· | ···· | CARR | 8/2/1968 | null | NULL | — | — | 9618 Desert Sky Boulevard | Glendale | AZ | 85381·· | ·GRP-8922 | SELECT-EPO |
| TPA | TPA-53900 | 2026-09-26T06:08:23Z | Marc | — | Snyder | 1958-10-04 | N/A | N/A | 7227663606 | — | 7609 Central Ave | Tampa | FL | 33672 | N/A | NULL·· |
| TPA | TPA-51316 | 2026-08-05T15:37:17Z | Patricia | — | Miller | 1943-02-16 | NULL | null·· | UNKNOWN | ···· | 1760 PINE DR | ·Denver | CO | 80257 | GRP-1376 | NULL |
| TPA | TPA-58078 | 2026-02-20T17:32:46Z | Sean | — | Stephens | 19790826 | UNKNOWN | NULL | null | NULL | 9699 Indian School Rd | Mesa | AZ | 85258-0214 | GRP-9487 | MEDICARE-ADV-A |
| TPA | TPA-53535 | 2026-05-28T03:10:16Z | SHARON | ···· | RAMOS | 1953-01-12 | UHC-77208-14 | •••-••-8410 | UNKNOWN | SHARON.RAMOS63@ICLOUD.COM | 6173 Meadow Ln | Phoenix | AZ | 85063·· | — | — |
| TPA | TPA-58029 | 2026-07-28T22:03:12Z | ALBERT | — | PHILLIPS | 9/27/1952 | UHC-14335-88 | •••-••-8887 | — | UNKNOWN | — | — | — | UNKNOWN | — | MEDICARE-ADV-B |
| TPA | TPA-55054 | 2026-03-11T23:45:01Z | CHRISTINA | — | MALDONADO | 1957-06-20 | ·· | NULL | N/A | UNKNOWN | 8246 Valley View Drive | EDEN PRAIRIE | MN | 55379-9726·· | GRP-5251 | - |
| TPA | TPA-53572 | 2026-05-18T02:03:57Z | Emma | U | Scott | 1979-11-19 | — | •••-••-9709 | 14338464340 | — | 3917 Lake View Rd | Tampa·· | FL | 33607 | — | — |
| TPA | TPA-59976 | 2026-01-07T14:55:16Z | Fisher, Doris | — | — | 1999-12-25 | NULL | •••-••-2846 | 3082115052 | - | — | — | - | — | GRP-3673 | OPTIONS-PPO·· |
| TPA | TPA-57481 | 2026-08-21T18:16:16Z | ·ROY | — | REYES | 12/28/1982 | N/A | N/A | — | roy.reyes65@hotmail.com | UNKNOWN | UNKNOWN | null | - | — | MEDICARE-ADV-B |
| TPA | TPA-62930 | 2026-03-28T06:44:13Z | ·SOFIA | — | ALVAREZ·· | 1970-01-10 | - | •••-••-7418 | — | sofia.alvarez@aol.com | 3305 MESA DRIVE | Orlando·· | FL | 32802 | — | NULL |
| TPA | TPA-52001 | 2026-02-28T01:18:40Z | judith | — | carroll | 1939-03-06 | N/A | — | — | — | ·9103 Church Street | Phoenix | AZ | 85075 | - | NAVIGATE-HMO |
| TPA | TPA-58632 | 2026-05-22T16:59:30Z | hannah | — | morales | 17-03-2008 | UNKNOWN | UNKNOWN | — | NULL | — | — | ·· | — | GRP-0686 | — |
| TPA | TPA-61143 | 2026-07-26T11:22:58Z | Micheel | V. | Cole | 1958-07-12 | NULL | •••-••-0352 | — | - | N/A·· | UNKNOWN·· | NULL | N/A | GRP-5610 | NULL |
| TPA | TPA-62799 | 2026-03-20T04:44:52Z | Gardner, Willie | — | — | 1989-02-19 | UHC-17309-82 | •••-••-6891 | ·UNKNOWN | NULL | 3227 CENTRAL AVE | Atlanta | Georgia | 30388 | null | UNKNOWN |
| TPA | TPA-57673 | 2026-01-25T02:47:08Z | EMILY | — | HARRIS·· | 25-10-1967 | UHC-11654-18 | - | NULL | N/A | 5568 Apache Blvd | Orlando | FL·· | 32860 | GRP-1238 | NAVIGATE-HMO |
| TPA | TPA-62234 | 2026-09-14T12:14:00Z | NATALIE | — | COOPER | 25-11-1985 | — | null | 618.731.7542 | - | 8026 SUNSET BLVD #892 | Columbus | OH | ·43200 | GRP-4622 | NAVIGATE-HMO |
| TPA | TPA-58844 | 2026-10-15T21:56:11Z | SAMUEL | — | ALVAREZ | 1939-10-18 | — | •••-••-7888 | ·5411557 | ·UNKNOWN | 7856 Highland Avenue | COLUMBUS | OH | 43282 | GRP-2511 | MEDICARE-ADV-A |
| TPA | TPA-54294 | 2026-05-30T07:19:37Z | OLIVIA | — | ·BRADLEY | 4/23/1969 | UNKNOWN | •••-••-6752 | null | ···· | 3185 Apache Blvd | Las Vegas | NV·· | 89116-3631 | — | — |
| TPA | TPA-59669 | 2026-04-10T09:52:03Z | Ruth | — | Sandoval | 1984-05-06 | - | — | 14138603758 | N/A | 1894 Mountain View Dr·· | Las Vegas·· | NV | 89130 | GRP-3120 | N/A |
| TPA | TPA-61296 | 2026-06-28T01:47:55Z | TIMOTHY | — | LAWRENCE | 6/15/1973 | UHC-34368-51 | •••-••-8923 | (334) 428-6808 | null | 5015 PARK PLACE | TEMPE | AZ | N/A | NULL | MEDICARE-ADV-A |
| TPA | TPA-56183 | 2026-05-22T19:02:54Z | MARK | — | GARZA | 1946-07-07 | — | - | 526-875-5930 | — | 7320 WASHINGTON ST | Charlotte | NC | 28201 | - | N/A |
| TPA | TPA-56008 | 2026-07-27T09:14:38Z | Ruth | — | Brooks | 11/18/1962 | — | — | (447) 218-7387 | N/A | 298 Church St | ·DENVER | CO | 80237-3686 | GRP-8909 | NULL |
| TPA | TPA-54594 | 2026-05-29T16:56:49Z | Marilyn | — | Hilll | 1991-04-08 | - | - | 278.658.3127 | - | 8995 Desert Sky Boulevard | ·Tucson | AZ | 85792-2420 | GRP-6054·· | MEDICARE-ADV-B |
| TPA | TPA-51999 | 2026-06-07T17:32:20Z | Susan | R. | Perz | 1949-07-28 | — | UNKNOWN | 7632615146 | null | 4019 Sage Court·· | Nashville | TN | 37255 | GRP-3588 | — |
| TPA | TPA-63386 | 2026-02-01T09:04:03Z | Terry | ···· | Salazar | 12/06/46 | UHC-65903-57 | •••-••-2525 | - | terry.salazar82@yahoo.com | — | UNKNOWN | — | null | — | UNKNOWN |
| TPA | TPA-58304 | 2026-05-21T07:27:17Z | Camila | — | Tran | 1958-03-13 | — | NULL | — | - | ·1343 Forest Avenue | PHOENIX | AZ | 85032 | N/A | MEDICARE-ADV-A |
| TPA | TPA-62105 | 2026-03-27T07:04:09Z | Jason·· | — | Scott | 4/3/1950·· | N/A | — | — | — | — | null | — | — | GRP-5803 | — |
| TPA | TPA-63538 | 2026-09-21T23:44:33Z | Reynolds, Nicole | ···· | — | 1976-07-11·· | — | •••-••-1144 | - | NICOLE.REYNOLDS@PROTON.ME | 1456 MEADOW LN | Nashville | TN | 37260 | NULL | NULL |
| TPA | TPA-63042 | 2026-03-31T00:40:02Z | PATRICIA | — | WILSON | 1962-09-25 | NULL | - | 2682941704 | NULL | 7558 Mesa Dr | COLUMBUS | OH | 43220 | GRP-6763 | NAVIGATE-HMO |
| TPA | TPA-59614 | 2026-02-06T17:59:38Z | HELEN | — | GORDON | Jul 15, 2006 | NULL | •••-••-7028 | N/A | helen.gordon@yahoo.com | 5110 Main St | Glendale | AZ | 85395 | — | MEDICARE-ADV-B |
| TPA | TPA-51145 | 2026-02-22T05:45:50Z | Charlotte | — | Shaw | 11/28/1941 | null | — | N/A | N/A | 9013 CANYON RD | Chandler | Arizona | 85211-3642 | - | CORE-HMO |
| TPA | TPA-64363 | 2026-08-06T06:07:14Z | ·Sandra | — | Scott | 1974-11-01 | UHC-00116-94 | — | — | — | 3389 Harbor Blvd | Las Vegas | Nevada | 89158 | NULL | — |
| TPA | TPA-51268 | 2026-07-26T08:09:31Z | Willie | — | Williamson | Feb 11, 1980 | UHC-87207-77 | — | 4746465626 | — | - | NULL | null | — | GRP-4073 | — |
| TPA | TPA-51804 | 2026-07-07T14:16:20Z | Chritsina | — | Austin | 05/12/68 | — | — | - | — | 1879 Forest Avenue Apt 39 | Orlando | FL | 32880 | UNKNOWN | NULL |
| TPA | TPA-53167 | 2026-03-24T08:37:56Z | kyle | — | lopez | 1956-05-05 | — | N/A·· | N/A | kyle.lopez@aol.com | NULL | — | NULL | - | — | UNKNOWN |
| TPA | TPA-64338 | 2026-06-10T13:12:45Z | SARA | — | NUNEZ | 1940-06-09 | UHC-01441-42 | — | N/A | NULL·· | 3337 MARKET STREET·· | LOS ANGELES | CA | 90049 | GRP-8431·· | CHOICE-PLUS-PPO |
| TPA | TPA-63321 | 2026-03-24T22:53:36Z | SAMUEL | ···· | OLIVER | 1955-11-01 | NULL | N/A | — | NULL | 6300 Mountain View Drive | San Antonio | ·TX | 78299 | — | MEDICARE-ADV-A |
| TPA | TPA-58962 | 2026-08-20T08:06:42Z | Carol | Y | Ortega | 1996-01-15 | — | •••-••-2750 | UNKNOWN | N/A | NULL | ·· | — | null | null | null |
| TPA | TPA-58610 | 2026-04-11T23:17:32Z | roy | — | obrien | 19-09-2008 | — | UNKNOWN | — | - | 3089 Mountain View Drive | Houston | TX | 77061 | — | null |
| TPA | TPA-55820 | 2026-02-23T13:46:16Z | WEYNE | Y. | ·MURRAY | 2000-42-01 | N/A | •••-••-4072 | +1 435 799 9217 | — | 4458 Lincoln Way | Las Vegas | NV | 89181-2861 | — | - |
| TPA | TPA-50023 | 2026-02-19T20:27:42Z | ·ANDREA | — | MURPHY | 1945-01-09 | - | NULL | — | null | 3741 Spring Street | Atlanta | GA | 30350 | N/A | 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:40.600Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty