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-55660 | 2026-08-27T12:51:37Z | Robert | — | Hall | 22-03-1946 | UHC-74797-86 | UNKNOWN | N/A | — | 1833 Oak Street | Sacramento | California | 95893 | null | N/A |
| TPA | TPA-54223 | 2026-02-14T04:23:30Z | George | ···· | Baker | 1944-02-06 | — | ·· | NULL | — | 4291 Hillcrest Rd #202 | San Diego | CA | ·92122 | GRP-7267 | - |
| TPA | TPA-56953 | 2026-04-07T20:04:51Z | janet | — | ·vega | 1962-07-19 | — | NULL | — | ·janet.vega73@yahoo.com | 6144 Baseline Road Apt 2 | ·Eden Prairie | MN | 55362 | GRP-6238 | — |
| TPA | TPA-55861 | 2026-04-11T19:49:19Z | ISABELLA | — | STEWART | 1995-11-01 | — | NULL | +1 915 976 8851 | — | ·9036 Mesa Drive | Charlotte | NC | 28239 | — | CORE-HMO |
| TPA | TPA-59123 | 2026-10-07T14:27:39Z | JACK | — | KELLEY | 5/5/1960 | null | •••-••-2973 | N/A | — | ·6336 Spring St | Austin | TX | 78736 | NULL | select-epo |
| TPA | TPA-51589 | 2026-05-16T22:28:38Z | Grace | W | Castillo | 1959-01-05 | — | null | UNKNOWN | — | 561 Bayshore Dr | San Antonio | TX | - | GRP-1791 | MEDICARE-ADV-A |
| TPA | TPA-55904 | 2026-02-11T14:06:29Z | Tyler·· | X. | ·Dominguez | 11/27/1982 | — | NULL | UNKNOWN | — | 7545 Canyon Road | Nashville | Tennessee | 37239 | NULL | — |
| TPA | TPA-52375 | 2026-03-13T23:34:51Z | Randy | — | Hill | 1982-10-03 | - | •••-••-6096 | +1 351 285 5122 | randy.hill3@outlook.com | ·234 Canyon Rd | Fresno | ·CA | - | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-60985 | 2026-09-26T20:54:38Z | ·DIANE | ·· | GEORGE | 1953-11-21 | ·UHC-91159-53 | — | — | — | 900 River Rd | SCOTTSDALE | AZ | 85239 | GRP-5459 | - |
| TPA | TPA-54744 | 2026-03-22T13:52:39Z | DOROTHY | — | ·GARCIA | 1949-05-15 | null | •••-••-7755 | 824.932.3499 | — | 6761 Sunset Boulevard·· | Denver | CO | 80299 | GRP-4305 | UNKNOWN |
| TPA | TPA-63545 | 2026-07-28T01:25:14Z | Logan | — | Silva | 1957-07-14 | UHC-62864-84·· | — | UNKNOWN·· | — | 8826 CHURCH STREET | ·Seattle | WA | 98183 | — | N/A |
| TPA | TPA-62553 | 2026-04-22T15:49:49Z | Murray, Joyce | — | — | 04/01/84 | — | — | (466) 327-3964 | joyce.murray@yahoo.com | — | - | NULL | N/A | null | — |
| TPA | TPA-62134 | 2026-08-09T12:57:28Z | GRACE | — | THOMPSON | 1957-11-22 | N/A·· | •••-••-4990 | 8669846590 | - | 7788 Market Street | LAS VEGAS | NV·· | 89116 | GRP-6913 | null |
| TPA | TPA-50964 | 2026-01-09T20:17:42Z | ALAN | — | ·GOMEZ | 14-09-1970·· | null | •••-••-3272 | — | — | 4112 Central Avenue | Plano | TX | 75038 | GRP-8928 | N/A |
| TPA | TPA-55975 | 2026-01-12T20:37:58Z | SAMUEL | — | COOK | 1977-90-05 | ···· | — | null | samuel.cook92@yahoo.com | 6529 Sunset Boulevard | Atlanta | GA | 30330 | UNKNOWN | — |
| TPA | TPA-58548 | 2026-09-02T05:13:34Z | Gloria | — | Stone | 12/8/1945 | NULL | — | — | gloria.stone25@icloud.com | 2470 INDIAN SCHOOL ROAD·· | Fresno | California | 93724 | GRP-8983·· | ···· |
| TPA | TPA-61375 | 2026-05-24T05:00:17Z | JOAN | J | SOTO | 1981-05-17 | UNKNOWN | •••-••-7068 | — | null | 1004 APACHE BLVD | LOS ANGELES | CA | 90000 | GRP-7130 | MEDICARE-ADV-B |
| TPA | TPA-50038 | 2026-06-27T01:14:05Z | JOSHUA | — | BURKE | 1994-09-03 | — | — | 329.762.7345 | N/A | 6405 Hillcrest Rd | Denver | CO | 80285·· | UNKNOWN | — |
| TPA | TPA-57639 | 2026-04-23T22:01:59Z | Lawrence | — | Chapman | 20-10-1975 | — | •••-••-6989 | N/A | null | 3172 OCEAN AVE | Austin | TX | 78770 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-52032 | 2026-02-06T06:08:31Z | Sofia | V. | Lane | 1964-08-03 | UHC1577892 | null | N/A | null | 5091 SAGE CT | Scottsdale | AZ | 85283·· | - | — |
| TPA | TPA-57223 | 2026-02-14T20:39:46Z | Henry·· | — | Le | 3/22/2005 | ·· | — | (229) 607-8696 | henry.le13@outlook.com | 2816 Lincoln Way | MINNEAPOLIS | MN | 55471 | UNKNOWN | UNKNOWN |
| TPA | TPA-55587 | 2026-02-07T18:38:10Z | Justin | — | Wilon | Mar 27, 1974 | — | null | ···· | N/A | 5123 CAMELBACK ROAD | ·PLANO | TX | 75001 | — | — |
| TPA | TPA-54430 | 2026-01-04T08:57:24Z | Guerrero, Karren | — | — | 1980-06-26 | — | UNKNOWN | 3723771339 | karen.guerrero@hotmail.com | 7928 Bayshore Drive | Orlando | FL | 32854-3945 | N/A·· | NULL |
| TPA | TPA-57622 | 2026-05-03T12:14:06Z | JERRY | — | ADAMS | 1969-04-08 | N/A | UNKNOWN | — | — | 5849 Maple Avenue | Scottsdale | AZ | 85289 | - | UNKNOWN |
| TPA | TPA-58586 | 2026-09-28T02:52:34Z | WILLIE | — | GARCIA | 1939-05-09 | null | •••-••-0533 | (595) 296-9080 | — | 2073 Church St | Sacramento | CA | 95855 | GRP-3309 | ·SELECT-EPO |
| TPA | TPA-52461 | 2026-03-04T10:16:18Z | JEAN·· | — | MILLS | Apr 7, 1961 | - | — | — | — | 6528 GRAND AVENUE | COLUMBUS | OH | 43232 | UNKNOWN | NULL |
| TPA | TPA-53658 | 2026-10-06T06:24:52Z | Hamilton, Shirley | — | — | 1967-04-03 | — | — | N/A | UNKNOWN | 7867 CANYON RD | Jacksonville | Florida | 32207 | GRP-7388 | MEDICARE-ADV-A |
| TPA | TPA-53913 | 2026-03-24T21:45:39Z | KEITH·· | — | ·WASHINGTON | 1945-03-09 | — | •••-••-8483 | — | — | 273 Harbor Boulevard | Nashville | TN·· | 37275 | — | — |
| TPA | TPA-62569 | 2026-09-13T11:27:39Z | Parker, Dennis | ·Y | — | 1962-03-23 | UNKNOWN | N/A | (742) 381-6539 | - | 9885 HILLCREST RD·· | Phoenix | AZ | 85089 | — | - |
| TPA | TPA-57030 | 2026-03-11T04:09:30Z | Nancy | — | Freeman | 2005-06-03·· | — | null | (817) 664-7855 | N/A·· | 3985 Washington Street·· | Fresno | CA·· | 93786 | — | MEDICARE-ADV-A |
| TPA | TPA-56717 | 2026-03-27T16:07:13Z | Kim | — | Marquez | 1941-05-15·· | UNKNOWN | N/A·· | 9042302544 | UNKNOWN | 1432 Valley View Dr #394 | Las Vegas | NV | 89170 | — | OPTIONS-PPO |
| TPA | TPA-52556 | 2026-10-06T02:19:45Z | Griffin, Aisha | — | — | 04-09-2005 | NULL·· | — | (366) 784-2451 | NULL | 5361 Elm Street | Chandler | AZ | 85229 | N/A | — |
| TPA | TPA-53479 | 2026-07-27T19:18:15Z | Santos, Scott | — | — | 1961-03-20 | null | •••-••-0965 | null | N/A | — | - | N/A | — | — | ·UNKNOWN |
| TPA | TPA-54709 | 2026-09-05T01:57:10Z | Keith | B | Olson | 3/5/2006 | — | — | 9494048924 | keith.olson11@gmail.com·· | 500 Highland Ave | Sacramento | CA | 95828 | GRP-1095 | — |
| TPA | TPA-55571 | 2026-05-29T20:57:36Z | brenda | — | henry | 2004-01-05 | null·· | •••-••-3723 | — | N/A | 2034 Cedar Ln | CHANDLER | ·AZ | 85232 | UNKNOWN | ···· |
| TPA | TPA-55095 | 2026-05-30T03:13:59Z | MICHAEL | — | PARKER | ·1942-08-22 | — | null | N/A | — | 2195 Church St | Seattle | WA | 98158 | GRP-8729 | ···· |
| TPA | TPA-58680 | 2026-04-01T15:28:39Z | Mary | — | Webb | 1990-08-23 | UNKNOWN | — | UNKNOWN | mary.webb67@hotmail.com | NULL | null | - | — | NULL·· | — |
| TPA | TPA-51834 | 2026-02-21T17:25:17Z | joseph | — | gray | 08/06/54 | — | null·· | null | NULL | 907 Cedar Lane #569 | Phoenix | ·AZ | 85044·· | GRP-4566 | — |
| TPA | TPA-61927 | 2026-07-29T05:47:32Z | arthur | — | davis | 1997-09-01 | - | — | UNKNOWN | null | — | NULL | — | N/A | null | null |
| TPA | TPA-61023 | 2026-04-24T17:21:05Z | SOFIIA | L | SMITH | ·05/13/88 | — | N/A | 382-938-2876 | UNKNOWN | 6410 OAK STREET | Tempe | AZ·· | 85257 | GRP-7497 | — |
| TPA | TPA-59138 | 2026-10-01T13:32:19Z | Deborah | ·· | Little | 2005-05-14 | ·· | •••-••-7411 | 18137891280 | — | 16 Sunset Boulevard | Miami | FL | 33125 | NULL | — |
| TPA | TPA-58611 | 2026-03-08T00:41:11Z | OBrien, Roy | — | — | 20080919 | ·UHC3936394 | ·· | (871) 834-4031·· | - | — | UNKNOWN | null | NULL | GRP-5401·· | CHOICE-PLUS-PPO·· |
| TPA | TPA-51693 | 2026-05-16T14:35:06Z | Vicky | — | Ford | 1988-05-02 | N/A | — | — | VICTORIA.FORD@OUTLOOK.COM | 1293 Mountain View Drive | Miami | ·FL | UNKNOWN | UNKNOWN | — |
| TPA | TPA-56053 | 2026-10-14T15:01:26Z | Edwards, Jean | L | — | 04/04/1956 | — | N/A | 4527366468 | — | 8902 CENTRAL AVE | Mesa | AZ | 85238 | GRP-0584 | -·· |
| TPA | TPA-55241 | 2026-05-18T01:02:19Z | NICHOLAS | — | MORGAN | ·1977-02-06 | UNKNOWN | UNKNOWN | 2687427 | ·NULL | 4559 UNION ST | SACRAMENTO | CA | 95839 | UNKNOWN | SELECT-EPO |
| TPA | TPA-56356 | 2026-07-24T00:20:00Z | BRYAN | — | FLORES | 1958-05-09 | — | NULL | null | NULL | 8892 RIVER ROAD | Mesa | AZ | 85222 | - | ···· |
| TPA | TPA-64300 | 2026-04-03T19:24:09Z | Lori | — | Luna | 20050402 | — | NULL | NULL | lori.luna@icloud.com | 6738 MESA DRIVE | Atlanta | GA | 30328 | NULL | — |
| TPA | TPA-54114 | 2026-04-07T07:15:26Z | LAWRENCE | — | WHEELER | 1990-43-18 | NULL | •••-••-3350 | — | - | 6746 Meadow Lane | Orlando | FL | 32804 | ·null | NAVIGATE-HMO |
| TPA | TPA-62747 | 2026-01-13T12:03:15Z | Andrea | — | Espinoza | Apr 26, 1975 | ·null | •••-••-5390 | NULL | ANDREA.ESPINOZA@PROTON.ME | 3610 Highland Ave | Chandler | AZ | 85235 | NULL·· | CORE-HMO |
| TPA | TPA-62721 | 2026-06-18T14:18:38Z | rebecca | G | fox | 2000-12-04 | UHC0560141 | NULL·· | N/A | — | 7732 Harbor Blvd | EDEN PRAIRIE | MN | 55371 | — | CORE-HMO |
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:53.747Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty