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-54972 | 2026-05-04T19:42:00Z | SAMUEL | — | TURNER | 12-07-1966 | — | - | N/A | NULL | 7369 VALLEY VIEW DRIVE | Minneapolis | MN | 55442 | null | — |
| TPA | TPA-59136 | 2026-09-16T05:54:00Z | Mason | ···· | Lawson | 1965-01-10 | N/A | •••-••-9123 | - | — | ···· | — | — | — | null | SELECT-EPO |
| TPA | TPA-64071 | 2026-09-10T03:49:04Z | BEVERLY | — | SINGH | 1958-07-28 | UHC-78091-79 | - | - | N/A | 8154 Sunset Boulevard | Seattle | WA | 98132 | UNKNOWN | NULL |
| TPA | TPA-63957 | 2026-09-29T20:04:28Z | MARY | V.·· | HUDSON·· | 1995-01-14 | — | •••-••-5740 | 775-479-7193 | MARY.HUDSON51@PROTON.ME | 9385 MESA DRIVE·· | San Diego | CA | 92171 | N/A | NULL |
| TPA | TPA-57571 | 2026-01-12T15:30:19Z | ·Don | — | Harper | 11/02/1975 | N/A | null | (677) 533-8231 | NULL | — | NULL | NULL | — | - | null·· |
| TPA | TPA-53223 | 2026-01-07T14:07:02Z | CAROLYN | — | MORALES | 19530420 | UNKNOWN | — | — | NULL | 395 Church St | ·Austin | TX | 78795 | - | CHOICE-PLUS-PPO |
| TPA | TPA-59757 | 2026-02-05T02:44:28Z | JON | — | ALVARADO | 1/3/1956 | UNKNOWN | NULL | — | null | UNKNOWN | null | UNKNOWN | - | NULL | null |
| TPA | TPA-53180 | 2026-01-08T04:26:27Z | ·Wei | — | Day | 1964-04-22 | - | UNKNOWN | UNKNOWN | UNKNOWN | 3556 Baseline Rd | SEATTLE | WA | — | — | MEDICARE-ADV-B |
| TPA | TPA-58918 | 2026-01-09T09:17:37Z | Tyler | — | Li | 1940-02-08 | N/A | ·· | null | UNKNOWN·· | 3573 Grand Ave | Las Vegas | NV | 89111 | ···· | ·NULL |
| TPA | TPA-58817 | 2026-05-30T15:29:40Z | ·nicholas | — | sanchez | 1985-04-16 | - | NULL | 205-496-0238 | NULL | 3184 Canyon Rd | San Antonio | TX | 78264-8166 | GRP-9470 | null |
| TPA | TPA-58058 | 2026-09-18T00:20:44Z | timothy | P | castillo | 12/13/53 | — | null | 8052847670 | UNKNOWN | 3418 Baseline Rd | Tucson | AZ | — | — | — |
| TPA | TPA-60084 | 2026-03-07T09:20:22Z | ·Stephanie | — | Williamson | 1949-05-06 | UHC-63783-56 | NULL | 972.934.1424 | N/A | 4702 CENTRAL AVE | Austin | TX | 78722 | null | — |
| TPA | TPA-60038 | 2026-02-22T21:41:39Z | ·JOSE | — | WAGNEER | 01/15/2000 | - | null·· | NULL | null | 2135 Spring Street | Scottsdale | AZ | 85211 | N/A | — |
| TPA | TPA-63074 | 2026-01-02T10:30:35Z | Alexis | — | Armstrong | 2004-09-05 | ···· | NULL | (456) 603-3923 | — | 9668 Lincoln Way | Scottsdale | AZ | 85212·· | — | NULL·· |
| TPA | TPA-53697 | 2026-07-30T22:01:30Z | ·Jacqueline | ···· | Adams | 06/09/96 | — | — | -·· | ·null | NULL | null | — | ·NULL | null | N/A |
| TPA | TPA-59856 | 2026-04-12T03:27:58Z | DAVID | — | WNG | 1968-08-14 | — | N/A | 12914464962 | N/A | 7085 Bayshore Drive | Atlanta | GA | 30360 | null | UNKNOWN |
| TPA | TPA-63896 | 2026-06-27T17:25:43Z | Walter | — | Williamson | 1967-02-23 | UNKNOWN | N/A | +1 454 618 4185 | WALTER.WILLIAMSON63@ICLOUD.COM·· | 7659 Desert Sky Blvd | Plano | TX | 75042 | N/A | NULL |
| TPA | TPA-61872 | 2026-03-25T09:48:19Z | Cunninham, Stephanie | — | — | Mar 16, 1953 | NULL | ·null | 402-467-6799 | — | 5452 LINCOLN WAY #983 | Glendale·· | AZ·· | NULL | UNKNOWN·· | N/A |
| TPA | TPA-53121 | 2026-02-05T21:35:09Z | CAMILA | G | OLSOON | 07-01-1949 | ·UNKNOWN | NULL·· | — | ·· | 3970 Sage Ct | ATLANTA | ·GA | 30342 | - | NAVIGATE-HMO |
| TPA | TPA-62792 | 2026-01-04T05:58:22Z | Gregory | — | Gonzales | 1961-02-08 | — | ···· | (860) 646-5190·· | gregory.gonzales75@hotmail.com·· | 2432 Highland Ave | Scottsdale | AZ | 85294 | GRP-5571 | CHOICE-PLUS-PPO |
| TPA | TPA-60454 | 2026-06-29T09:26:09Z | christina | N | rogers | 1994-12-16 | NULL | N/A | NULL | UNKNOWN | 2490 Lincoln Way | Tampa | FL | 33627 | — | NULL |
| TPA | TPA-57454 | 2026-03-23T21:52:33Z | CHRISTINA | — | JOHNSTON | 07/26/63 | UHC-64381-56 | — | 652-243-0840 | — | 1967 Central Ave | Jacksonville | Florida | 32245 | ·GRP-6350 | — |
| TPA | TPA-50488 | 2026-04-11T22:31:08Z | eugene | — | ·dean | Oct 24, 1963 | — | — | null | eugene.dean80@outlook.com | 1762 Oak Street | Scottsdale | AZ | 85211 | GRP-4832 | null |
| TPA | TPA-61996 | 2026-07-14T15:20:08Z | CHERYL | — | GORDON | 7/20/1988 | — | NULL·· | 318-596-8691 | — | 1913 ELM ST | Eden Prairie | MN | 55335 | GRP-7881 | — |
| TPA | TPA-55279 | 2026-06-02T21:44:33Z | BRIAN | — | HOFFMAN | 06/22/1965 | — | N/A | null | NULL | 3389 BASELINE RD | Gilbert·· | AZ | 85245 | N/A·· | — |
| TPA | TPA-55606 | 2026-05-11T14:08:53Z | Austin | — | Simpson | 02/27/1993 | — | — | — | null | 3090 OCEAN AVE | LOS ANGELES | CA | - | null | OPTIONS-PPO |
| TPA | TPA-60739 | 2026-06-15T11:00:56Z | Omar | — | Perez | 2/5/1976 | - | •••-••-9918 | — | omar.perez64@outlook.com | null | UNKNOWN | null | N/A | GRP-4313 | — |
| TPA | TPA-53706 | 2026-01-11T03:15:51Z | BOBBY | — | JACOBS | 1942-09-25 | — | null | — | — | 1545 JEFFERSON AVE | SAN ANTONIO | TX | 78285 | GRP-3977 | null |
| TPA | TPA-53354 | 2026-07-24T05:59:50Z | eric | — | bannks | 1956-02-08 | -·· | •••-••-5342 | 9595534496 | eric.banks@yahoo.com | 776 CENTRAL AVE | Gilbert | AZ | ·· | — | — |
| TPA | TPA-63924 | 2026-03-19T16:45:15Z | Sophia | — | Gonzales | 1944-04-12 | — | •••-••-3669 | +1 909 320 7163 | NULL | 9811 Ocean Avenue | Minneapolis | MN | ·55454 | - | — |
| TPA | TPA-51360 | 2026-02-22T10:32:37Z | Diego | — | Daniels | 10/13/1953 | UNKNOWN | - | NULL | ·null | 3198 Highland Avenue | Eden Prairie | MN | 55357 | — | OPTIONS-PPO |
| TPA | TPA-56689 | 2026-05-16T12:35:59Z | RUTH | — | SALAZAR | 11/24/1940 | — | - | UNKNOWN | ruth.salazar@yahoo.com | 2527 CENTRAL AVE | Houston | TX | 77011-7572 | - | MEDICARE-ADV-B |
| TPA | TPA-59213 | 2026-07-19T02:37:02Z | Kayla·· | — | Tucker | 1958-05-12 | uhc-60897-29 | null | — | NULL | 5351 Desert Sky Blvd | Las Vegas | NV | 89133 | — | — |
| TPA | TPA-62367 | 2026-01-26T08:21:15Z | Gray, Elizabeth | — | — | ·1958-06-25 | — | ·UNKNOWN | 976-753-7265 | — | 3136 Sunset Blvd | Minneapolis | MN | 55488 | - | NULL |
| TPA | TPA-58027 | 2026-01-08T06:36:52Z | ahmed | I | adams·· | 6012-20-01 | N/A | NULL | null | - | 3121 Union Street | Las Vegas | NV | 89139 | — | ···· |
| TPA | TPA-61547 | 2026-05-28T02:48:42Z | Dorothy | J·· | James | 1991-07-04 | NULL | •••-••-8828 | null | - | 5547 Broadway | Charlotte | NC | 28217 | - | SELECT-EPO |
| TPA | TPA-50582 | 2026-06-25T09:27:12Z | MATEO | — | WEAVER | 04/01/52 | UHC0620931 | — | UNKNOWN | mateo.weaver86@icloud.com | — | - | - | N/A | UNKNOWN | N/A |
| TPA | TPA-58605 | 2026-06-21T13:07:48Z | gabriel | ·· | ward | 1943-02-02 | — | •••-••-5431 | +1 330 701 3173 | UNKNOWN | 998 PINE DRIVE | San Antonio | TX | 78250-6766 | — | NULL |
| TPA | TPA-61318 | 2026-06-14T02:48:31Z | Grant, Larry | — | — | 1947-01-22 | UHC-85640-98 | NULL | — | null | 5685 WASHINGTON STREET | Austin | Texas | 78785 | GRP-9160 | OPTIONS-PPO |
| TPA | TPA-54648 | 2026-06-08T15:14:41Z | Christina | — | Hart·· | 1954-04-21 | — | ·· | (839) 983-3023 | - | 6532 Bayshore Dr | Las Vegas | NV | 89144 | NULL | — |
| TPA | TPA-52911 | 2026-09-14T05:12:04Z | Jimmy | A | Butler | Aug 9, 1955 | null | •••-••-2738 | 2764282583 | N/A | 4933 Valley View Drive | Tempe | AZ | 85204 | N/A | UNKNOWN |
| TPA | TPA-53428 | 2026-01-12T01:17:20Z | Henry | — | Cruz | 1938-06-10 | — | •••-••-3399 | ·- | — | 8192 APACHE BLVD | Los Angeles | CA | 90080 | GRP-5260 | NULL |
| TPA | TPA-64473 | 2026-04-24T02:24:19Z | Eugene | — | Daniels·· | Feb 5, 1994 | UHC-59501-35 | N/A | — | N/A | 9891 Oak Street | Mesa | AZ | 85232 | ·· | UNKNOWN |
| TPA | TPA-57240 | 2026-08-23T15:23:15Z | Aisha | — | Gibsson·· | 1941-12-19 | — | — | ·UNKNOWN | — | — | - | UNKNOWN | UNKNOWN | — | OPTIONS-PPO |
| TPA | TPA-62419 | 2026-08-11T20:47:07Z | ·STEPHEN | — | PADILLA | 1989-03-27 | — | UNKNOWN | NULL | NULL | 212 Church St | Jacksonville | FL | 32236 | GRP-6344 | NAVIGATE-HMO |
| TPA | TPA-54332 | 2026-03-23T07:52:38Z | MARIA | — | BAILEY | 28-05-1989 | UHC-08893-22 | N/A | 490-949-0878 | maria.bailey82@aol.com | UNKNOWN | — | — | NULL | — | — |
| TPA | TPA-57056 | 2026-04-18T00:44:45Z | Maria | — | Fernandez | 1991-07-03 | — | •••-••-5244 | — | MARIA.FERNANDEZ98@AOL.COM | ·3638 Canyon Rd | Gilbert | AZ | 85280 | UNKNOWN | — |
| TPA | TPA-63246 | 2026-04-29T08:04:28Z | Dylan | — | Warren | 1952-05-22 | — | •••-••-7358 | UNKNOWN | — | 2857 Main St | San Diego | California | 92134 | null | MEDICARE-ADV-B |
| TPA | TPA-52734 | 2026-07-15T17:04:48Z | Jennifer | S | Cook | Sep 14, 1997·· | N/A | — | — | N/A | ·4635 CAMELBACK ROAD #957 | Orlando | FL | 32860 | ···· | NULL |
| TPA | TPA-53241 | 2026-09-21T02:52:29Z | Lucia | — | Payne·· | 01/05/1989 | — | — | — | — | 2663 BROADWAY | Plano | Texas | 75075 | GRP-8258 | - |
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.764Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty