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-60696 | 2026-07-11T12:52:47Z | Jeessica | — | Dominguez | 06/07/1987 | N/A | •••-••-5943 | — | — | - | NULL | N/A·· | — | GRP-1512 | MEDICARE-ADV-B |
| TPA | TPA-62787 | 2026-03-09T18:46:37Z | GARY·· | B | WANG | ·1996-04-02 | null | null | — | N/A | 8882 Jefferson Ave | Los Angeles | CA | 90014 | GRP-3657·· | — |
| TPA | TPA-60005 | 2026-03-14T09:21:18Z | — | P | — | 1994-02-05 | N/A | null | N/A | null | 9247 Highland Ave | ·Columbus | OH | 43298 | GRP-5018 | — |
| TPA | TPA-52586 | 2026-09-09T06:23:34Z | RACHEL | — | CAMPBELL | 19-02-2005 | - | null | 682-419-6892 | — | 3867 CEDAR LANE | LAS VEGAS | NV | 89101 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-60709 | 2026-08-31T18:14:55Z | Emma | — | Wright | 1978-08-21 | NULL | UNKNOWN | 18372116674 | null | 4449 Jefferson Ave | ·Chandler | az | 85228 | NULL | - |
| TPA | TPA-53476 | 2026-06-03T04:15:52Z | NOAH | — | EDWARDS | 1972-07-04 | NULL | •••-••-8317 | 947-881-4147 | — | 7980 Baseline Road | Houston | TX | 77075 | GRP-6077 | — |
| TPA | TPA-52095 | 2026-09-01T09:11:21Z | ROY | Q. | BENNETT | 1950-11-23 | null | — | — | — | NULL | — | — | - | GRP-4177 | N/A |
| TPA | TPA-62093 | 2026-05-13T07:16:33Z | Deborah | — | Perry | 1941-09-28 | — | •••-••-1377 | (481) 608-5049 | UNKNOWN·· | 1929 Oak St | Fresno·· | ca | 93777 | N/A | — |
| TPA | TPA-53336 | 2026-04-03T11:05:24Z | Diana | — | Oliver | ···· | N/A·· | ·- | — | DIANA.OLIVER@OUTLOOK.COM | 7663 MAPLE AVENUE | Columbus | ·OH | 43222 | ·- | - |
| TPA | TPA-51368 | 2026-05-06T23:25:27Z | NATALIE | — | JAMES | 3/18/1972 | - | — | 17689467689 | ·· | 5951 DESERT SKY BOULEVARD | Scottsdale | AZ | 85237-8976 | N/A | — |
| TPA | TPA-51787 | 2026-02-12T19:07:42Z | Alberrt I. | — | Kim | 1989-09-03 | ···· | •••-••-6891 | — | - | 2264 PINE DRIVE | Tucson | az | 85784 | ·N/A | UNKNOWN |
| TPA | TPA-61963 | 2026-01-04T08:49:40Z | Bishop, Ruth | E. | — | 5/13/1990·· | null | N/A | (573) 436-4466 | N/A | 804 OAK STREET | Atlanta | GA | 30347 | — | N/A |
| TPA | TPA-51410 | 2026-10-03T15:34:51Z | jean | — | contreras | 1943-06-21 | ·UHC-29251-65 | N/A | (255) 593-0153 | NULL | 3730 Hillcrest Road | San Antonio·· | Texas | 78202 | GRP-8349 | - |
| TPA | TPA-59042 | 2026-05-19T02:11:46Z | Juan | — | Lewis | 1964-04-09 | UHC-51931-21 | UNKNOWN | (928) 275-9792 | juan.lewis@yahoo.com | 4772 JEFFERSON AVE | Scottsdale | Arizona | null | UNKNOWN | CORE-HMO·· |
| TPA | TPA-59905 | 2026-07-05T14:18:38Z | Pamela | ·· | Tran | 1947-60-05 | UHC0205122 | •••-••-2858 | null | pamela.tran@proton.me | 4889 SPRING STREET | Sacramento | CA | ·UNKNOWN | — | - |
| TPA | TPA-61329 | 2026-03-05T23:50:28Z | ZACHARY | — | DIXON | ·1989-11-18 | UHC5393956 | UNKNOWN | — | - | 6095 SAGE CT | Chandler | AZ | — | - | — |
| TPA | TPA-57412 | 2026-02-11T13:51:35Z | MARILYN | — | ELLIOTT | Dec 8, 1984 | ·· | •••-••-1549 | 984-290-8816 | null | 5553 Lake View Rd | Gilbert | AZ | 85253 | — | N/A |
| TPA | TPA-53184 | 2026-06-22T18:14:04Z | Katherine | — | Banks | 1965-10-15 | — | •••-••-8753 | ·UNKNOWN | null | ·914 Willow Ct | Tucson | az | - | NULL | null |
| TPA | TPA-55953 | 2026-01-07T18:38:31Z | ·Contreras, Kenneth | — | — | 19870502 | — | ·· | 278-500-5180 | NULL | 9101 RIDGE ROAD #840 | Atlanta | GA | N/A | — | — |
| TPA | TPA-50022 | 2026-09-26T02:52:04Z | ANDREA·· | — | MURPHY·· | 1/9/1945 | ···· | •••-••-0613 | N/A | null | 3741 Spring St | Atlanta | GA | 30350-5997 | - | null |
| TPA | TPA-55740 | 2026-07-10T04:05:55Z | DANIELLE | — | THOMPSON | 05/12/93 | UHC-07773-71 | null | — | null | 5664 Ridge Road | Columbus | OH | 43221-1078 | UNKNOWN | UNKNOWN |
| TPA | TPA-63283 | 2026-03-04T06:16:04Z | Dennis | ·· | Mason | 1966-10-24 | — | — | 467-275-7285 | — | 3294 Lincoln Way | Orlando | FL | 32868 | — | — |
| TPA | TPA-59003 | 2026-09-03T19:43:04Z | Frank | — | Munoz | 1968-01-24 | UNKNOWN | N/A·· | +1 446 616 9201 | UNKNOWN | 2100 INDIAN SCHOOL RD | SAN DIEGO | ·CA | null | UNKNOWN·· | null |
| TPA | TPA-63313 | 2026-06-03T01:06:58Z | ·Willie | — | Chavez | 10/12/1952 | - | — | - | - | 2780 Desert Sky Blvd | Plano | TX | 75096-4999 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-50715 | 2026-02-17T19:26:36Z | ·JUDY | — | SCHULTZ | ·Nov 5, 1971 | — | •••-••-5919 | (674) 458-3506 | — | 3200 Ridge Rd | MINNEAPOLIS | MN·· | N/A | NULL | - |
| TPA | TPA-59193 | 2026-04-29T18:29:50Z | Angela | — | Lee | 1983-06-07 | UHC-45982-35 | •••-••-0460 | 962-440-5853 | N/A | 7108 Meadow Ln | Sacramento·· | CA | 95803 | — | UNKNOWN·· |
| TPA | TPA-59033 | 2026-06-12T19:23:34Z | Donald | — | Wallace | 1977-01-23 | - | •••-••-5741 | (249) 323-6181 | — | 7020 Forest Avenue | Columbus | OH | 43255 | null | — |
| TPA | TPA-50401 | 2026-05-31T14:09:29Z | RALPH | — | ·KIM | 1948-04-13 | — | •••-••-7423 | - | null | 6508 Church Street | Sacramento | CA | 95893 | GRP-4159 | — |
| TPA | TPA-60315 | 2026-03-30T05:36:33Z | Nathan | ·T | Robinson | 19560718 | NULL | •••-••-7072 | ·2533232530 | — | 6682 Ridge Road | Glendale | AZ | 85384 | null | — |
| TPA | TPA-50659 | 2026-08-17T11:32:23Z | Cheryl | — | Cunningham | 1949-09-03 | UHC-44238-01 | — | - | ···· | 1762 Cedar Lane | Chandler | AZ | 85280 | UNKNOWN | — |
| TPA | TPA-59769 | 2026-03-06T13:57:37Z | Alice | W | Graham | — | — | — | 6428106306 | ·- | 952 HILLCREST RD | LAS VEGAS | NV | 89121 | — | SELECT-EPO |
| TPA | TPA-55556 | 2026-04-08T21:38:58Z | REBECCA·· | — | ANDREWS | 08/03/1990 | UNKNOWN | — | null | ···· | 4917 Jefferson Avenue | Dallas | TX | 75232 | null | NULL |
| TPA | TPA-56232 | 2026-01-17T06:38:38Z | DANIEL | J | LARSON | Jul 4, 1969 | null | - | — | null | 5189 JEFFERSON AVENUE | Seattle | wa | 98194 | NULL | N/A |
| TPA | TPA-62152 | 2026-02-26T22:30:33Z | ·Brian | ···· | Matthews | Sep 19, 1964 | NULL | NULL | — | N/A | 6673 Meadow Lane | Miami | FL | 33132 | UNKNOWN | — |
| TPA | TPA-50599 | 2026-04-26T22:39:02Z | Jason·· | — | Barnes | ·1943-04-05 | null | N/A | NULL | ·· | 7993 Elm St | Los Angeles | CA | 90057·· | GRP-5170 | null |
| TPA | TPA-51672 | 2026-06-06T07:43:13Z | Mei | — | Rogers | 1954-02-16 | — | •••-••-7004 | 15149794371 | — | 4173 Pine Dr | San Antonio | TX | 78273 | — | — |
| TPA | TPA-56473 | 2026-06-09T11:56:40Z | WEI·· | — | DUNN | 1940-65-02 | — | - | 375-612-1702 | - | 6309 Lincoln Way | PLANO | TX | 75041 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-56093 | 2026-06-10T17:02:52Z | Lucia | — | Hawkins | 1997-04-05 | UNKNOWN | null | (562) 883-6646 | UNKNOWN | ·N/A | - | NULL | — | — | - |
| TPA | TPA-50221 | 2026-08-20T15:19:36Z | Kimebrly·· | — | Henry | 19470926 | null | •••-••-3184 | UNKNOWN | UNKNOWN | N/A | N/A | — | null·· | NULL | null |
| TPA | TPA-51854 | 2026-05-29T23:40:06Z | Russell, Gabreil | — | — | 1955-12-23 | UHC-05189-61 | UNKNOWN | — | NULL | 4477 Washington Street | Columbus | OH | ·43258 | - | UNKNOWN |
| TPA | TPA-64355 | 2026-02-20T09:00:24Z | Ahmed | — | Adams | 1986-11-16 | NULL | - | — | NULL | ·670 Meadow Ln | San Antonio | TX | 78269 | GRP-4766 | SELECT-EPO |
| TPA | TPA-55543 | 2026-01-19T15:28:48Z | SANDRA | — | NELSON | 1965-05-01 | UNKNOWN | ·N/A | 352.614.8150 | sandra.nelson@icloud.com | 699 DESERT SKY BLVD | Fresno | CA | 93771·· | GRP-6045 | N/A |
| TPA | TPA-53262 | 2026-01-28T13:30:18Z | Camila | — | Herrera | 1970-12-22 | N/A | — | — | — | 4528 Union Street | San Diego | CA | 92120 | GRP-9201 | MEDICARE-ADV-A |
| TPA | TPA-62235 | 2026-07-29T11:25:56Z | John | — | Lynch | 3/2/1973 | NULL | — | 953-771-3252 | — | null | - | — | null | - | NULL·· |
| TPA | TPA-63442 | 2026-05-22T13:28:48Z | MATT·· | — | ELLIS | 1967-12-06 | UNKNOWN·· | NULL | (948) 371-9182 | NULL | 4838 JEFFERSON AVE | HOUSTON | TX | - | GRP-2532 | - |
| TPA | TPA-60349 | 2026-09-22T18:29:39Z | Alan | — | Simmons | 1995-04-25 | uhc-07767-31 | — | null | — | 4788 INDIAN SCHOOL ROAD | Gilbert | AZ | 85260-3746 | — | SELECT-EPO |
| TPA | TPA-57000 | 2026-01-30T01:51:42Z | Larry | I | Mendoza | 11/8/1972 | N/A | — | (594) 343-5727 | N/A | 3521 MAPLE AVENUE #694 | Charlotte | NC | 28203 | UNKNOWN | — |
| TPA | TPA-55921 | 2026-07-01T16:10:48Z | Isabella | — | Nelson | 21-04-1992·· | N/A | •••-••-5926 | 5203335188 | ISABELLA.NELSON@OUTLOOK.COM | 2964 Grand Ave | Austin | TX | 78797 | ·· | N/A |
| TPA | TPA-50897 | 2026-10-02T11:06:34Z | Daniel | — | Lawrence | 1978-07-10 | UHC-97508-22 | — | 872-669-8499 | null | ·8162 SPRING ST | PLANO | TX | ·75004 | UNKNOWN | UNKNOWN |
| TPA | TPA-60682 | 2026-04-19T20:51:26Z | Randy | — | Hall | 19820127 | NULL | null | 13269836537 | randy.hall43@hotmail.com | 8707 VALLEY VIEW DR | Phoenix | AZ | 85004 | GRP-7235 | — |
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.391Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty