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-61242 | 2026-06-16T15:35:46Z | PRIYA | ···· | SMITH | Feb 13, 1955 | null·· | •••-••-9768 | null | NULL | 743 RIDGE ROAD | Tucson | AZ | ·85746-3903 | GRP-6981 | null |
| TPA | TPA-59216 | 2026-08-11T19:36:06Z | DANIELLE | ·· | ELLIS | Mar 12, 1941 | UHC6728547 | NULL | - | — | 7010 GRAND AVE | ·DENVER | CO | 80233 | — | MEDICARE-ADV-A |
| TPA | TPA-58722 | 2026-10-04T03:23:22Z | ·Perkins, Grace | — | — | 07/20/2008 | UHC-06554-47·· | ·- | (225) 601-7695 | — | 9709 Willow Court Apt 21 | Tempe | AZ | 85269 | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-52230 | 2026-03-25T19:15:43Z | Margareet | — | McCoy | 07/09/69 | N/A | •••-••-2988 | NULL | margaret.mccoy@icloud.com | 4305 Meadow Ln | Denver | CO | 80235 | — | CORE-HMO |
| TPA | TPA-60810 | 2026-09-21T17:28:48Z | Justin | G | Bowman | 1980-11-01 | N/A | •••-••-9804 | — | NULL | 1535 Washington St | Austin | Texas | 78731 | GRP-3415·· | MEDICARE-ADV-B |
| TPA | TPA-53116 | 2026-01-01T05:25:25Z | Sarah | — | Bryant | 1943-10-16 | uhc-10170-91 | — | null | — | 3900 Meadow Ln | Mesa | AZ | 85253 | ·NULL | — |
| TPA | TPA-59759 | 2026-06-30T22:52:38Z | DIANA | A | SPENCER | 08/19/1942 | — | — | +1 690 379 2927 | ·diana.spencer79@icloud.com | — | null | — | N/A | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-50092 | 2026-05-31T09:06:42Z | Kayla | — | Park | 12/07/63 | - | - | 7192186 | — | 976 Camelback Rd | Los Angeles | California | 90001 | UNKNOWN | — |
| TPA | TPA-56282 | 2026-04-11T09:58:20Z | ·RACHEL | — | KELLEY | Aug 18, 1977 | UNKNOWN | •••-••-7968 | UNKNOWN | rachel.kelley94@aol.com | 7186 Oak Street | Orlando·· | Florida | 32883 | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-50333 | 2026-07-25T11:54:42Z | Robinson, Patrick | R. | — | 1977-04-11 | UHC-78696-43 | N/A | 277.645.6911 | — | 7387 BAYSHORE DRIVE | Sacramento | CA | 95862 | GRP-0647 | — |
| TPA | TPA-54422 | 2026-08-23T17:41:54Z | ·DEBRA | — | BRADLEY | 1971-01-11 | — | •••-••-9405 | — | ···· | 1134 Maple Ave·· | Scottsdale | AZ | 85254 | ·- | NAVIGATE-HMO |
| TPA | TPA-59619 | 2026-05-31T08:46:13Z | ANDREA | — | MARQUEZ | 10/18/2008 | UHC-63854-86 | •••-••-0277 | ·16473618372 | — | 7039 Grand Ave | HOUSTON | TX | 77056-8822 | — | CORE-HMO |
| TPA | TPA-63785 | 2026-09-02T01:00:58Z | Alexis·· | — | Elliott | 1965-02-04 | - | ·· | ·- | — | 9576 Cedar Ln | Atlanta | GA | 30344-9779 | N/A | — |
| TPA | TPA-63712 | 2026-05-23T12:34:02Z | Robert | — | Patterson | ·1982-10-18 | — | N/A | N/A | N/A | 8502 RIDGE ROAD | PHOENIX | AZ | 85004 | null | NULL |
| TPA | TPA-54336 | 2026-06-08T05:06:12Z | EVELYN | — | GARDNER | 1981-08-14 | NULL | null | UNKNOWN | ·NULL | 7508 Highland Ave | Los Angeles | CA | 90020 | N/A | - |
| TPA | TPA-64273 | 2026-08-20T09:07:24Z | ARJUN | — | KENNEDY | 1955-04-24 | — | — | 15762675777 | arjun.kennedy88@hotmail.com | 9731 Washington St | Charlotte | NC | ·28205 | ···· | — |
| TPA | TPA-50854 | 2026-09-23T01:12:12Z | Beverly | — | Ramos·· | 1944-03-10·· | - | •••-••-4586 | 9183627716 | beverly.ramos@yahoo.com | N/A | null | UNKNOWN | N/A | GRP-6907 | CORE-HMO |
| TPA | TPA-61298 | 2026-04-18T17:35:00Z | Lauren | — | Ray | 1956-01-12 | N/A | •••-••-0043 | (356) 809-7738 | — | 9749 MEADOW LN | ORLANDO | fl | 32822-9648 | N/A | — |
| TPA | TPA-52937 | 2026-10-13T23:08:58Z | Raymond | — | Rodriguez | 09/11/80·· | UNKNOWN | UNKNOWN | 7043124628 | raymond.rodriguez73@proton.me·· | ·UNKNOWN | null | null | — | null | CHOICE-PLUS-PPO |
| TPA | TPA-51126 | 2026-06-15T11:14:37Z | Richardson, Gregory | ·· | — | 1960-04-11 | NULL | •••-••-6149 | null | - | 1687 Palm Dr | Dallas | Texas | 75271·· | — | — |
| TPA | TPA-60960 | 2026-08-28T14:50:31Z | SOFAI | — | LUCAS | 1969-04-12 | UNKNOWN·· | •••-••-4505 | (660) 644-2234 | NULL | — | null | — | UNKNOWN | GRP-9903 | CORE-HMO |
| TPA | TPA-54707 | 2026-07-21T18:08:39Z | Carl | — | Gilbert | 23-08-1966 | null | ·NULL | (578) 322-6069 | carl.gilbert45@proton.me | 2361 Camelback Rd | San Diego | ca | 92186 | — | UNKNOWN |
| TPA | TPA-56783 | 2026-05-05T22:30:18Z | Porter, Lucia | W | — | 02/23/44 | - | •••-••-1119 | null | N/A | 8965 Canyon Road | San Antonio | TX | 78234 | N/A | null |
| TPA | TPA-64085 | 2026-07-10T21:21:16Z | Amy | — | Pena | 1939-08-28 | UHC-89660-26 | — | - | - | — | - | — | UNKNOWN | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-52405 | 2026-08-26T20:49:35Z | Alice | — | Bailey | 07/02/1988 | UHC-77231-18 | •••-••-4792 | ·NULL | ·UNKNOWN | 5898 Forest Avenue | Tempe | AZ | ·85268-7656 | GRP-3959 | NULL |
| TPA | TPA-60330 | 2026-03-10T12:53:28Z | Kevin | — | Guerrero | 1985-05-16 | UNKNOWN | — | UNKNOWN | N/A | - | N/A | UNKNOWN | null | ·· | NULL |
| TPA | TPA-54660 | 2026-04-08T14:00:44Z | Carl | — | Long | 1982-10-17 | UNKNOWN | - | (609) 431-1303 | CARL.LONG48@HOTMAIL.COM | 4180 MAPLE AVENUE | Orlando | FL | 32860 | — | ···· |
| TPA | TPA-54348 | 2026-09-17T23:14:34Z | OMAR | — | WONG | 1952-11-11 | — | NULL | 237.237.5706 | — | N/A | — | — | ·null | — | - |
| TPA | TPA-62065 | 2026-02-17T10:52:09Z | Lisa·· | — | OBrien | ·24-10-2004 | — | •••-••-3758 | (967) 750-5355 | UNKNOWN | 3140 Lake View Road | Tucson | AZ | 85730 | NULL | null |
| TPA | TPA-58609 | 2026-03-12T16:27:34Z | TERRY | — | BANNKS | 1947-12-03 | NULL | •••-••-0231 | 813-939-7603 | null | 1760 Highland Avenue | Orlando | FL | 32830 | UNKNOWN·· | — |
| TPA | TPA-52294 | 2026-01-30T02:51:58Z | Robert | — | Ross | 1997-08-18 | — | •••-••-2371 | null | robert.ross@proton.me | 6404 Central Ave | Gilbert | Arizona | ·85224 | NULL | — |
| TPA | TPA-51129 | 2026-01-14T04:02:56Z | Richards, Aisha | — | — | 1955-10-16 | — | UNKNOWN | — | N/A | 7394 Harbor Boulevard | Dallas | ·TX | 75295 | — | — |
| TPA | TPA-54036 | 2026-07-06T03:03:56Z | BRADLEY | — | LUCAS | 2001-04-05 | N/A | •••-••-4016 | 3905803750 | null | — | — | — | N/A·· | — | null |
| TPA | TPA-59597 | 2026-08-15T10:08:54Z | DORIS | — | DOMINGUEZ·· | ·2006-04-06 | N/A | N/A | null | ···· | 2312 Canyon Rd | Los Angeles | CA | 90011 | — | N/A |
| TPA | TPA-62523 | 2026-07-08T21:30:25Z | Jonathan | — | Brooks | 03/02/1999 | UNKNOWN | NULL | N/A·· | JONATHAN.BROOKS22@AOL.COM | 4731 Sunset Boulevard | Los Angeles | CA | 90089 | N/A | UNKNOWN |
| TPA | TPA-52513 | 2026-08-05T13:39:16Z | Ruth | — | Hanson | 19850606 | UHC7302203 | UNKNOWN | (826) 534-5553 | RUTH.HANSON83@OUTLOOK.COM | 3317 Church Street | TEMPE | AZ | 85236 | null·· | NULL |
| TPA | TPA-56457 | 2026-07-20T00:18:21Z | Bill | — | Powell | 1/13/1973 | UHC9277503 | — | - | NULL | ·1719 Ridge Road | Eden Prairie | ·MN | 55337 | — | — |
| TPA | TPA-53952 | 2026-03-01T02:41:34Z | Arjun | — | Flores | 1978-12-09 | N/A | NULL | 436-408-9508 | arjun.flores1@icloud.com | 2271 Elm St | Chandler | AZ | 85215 | — | - |
| TPA | TPA-64013 | 2026-07-11T01:06:32Z | ·Carolyn | — | ·Spencer | ·1938-09-09 | NULL | — | — | — | 9870 Oak St·· | Atlanta | GA | 30334-3537 | NULL | MEDICARE-ADV-A |
| TPA | TPA-55721 | 2026-01-02T19:41:39Z | Angela | — | Watkins | 1997-08-02 | NULL | — | - | null | 2215 CANYON ROAD | Tampa | FL | 33613 | — | CORE-HMO |
| TPA | TPA-58106 | 2026-05-19T22:56:34Z | Jerry | — | Patal | Jul 1, 1984 | — | null | UNKNOWN | — | 8468 Lake View Rd | Minneapolis | MN | 55427 | N/A | null |
| TPA | TPA-54580 | 2026-02-26T15:26:55Z | JOE | ·· | LANE | 10-01-1974 | N/A | — | 236-751-8115 | null | 1430 CAMELBACK ROAD·· | AUSTIN | TX | 78797 | NULL | N/A |
| TPA | TPA-50935 | 2026-06-25T10:28:06Z | REBECCA | — | CLARK | 2004-07-06 | UHC-91106-06 | •••-••-5857 | null | null | 4900 Market Street | SAN ANTONIO | TX | 78263 | null | N/A |
| TPA | TPA-63306 | 2026-05-05T04:35:10Z | LINDA | — | WATSON | 2005-10-21 | - | •••-••-5674 | 3808961733 | — | 3703 PARK PL | Minneapolis | MN | 55493 | — | null |
| TPA | TPA-61168 | 2026-09-22T05:49:07Z | SANTIAGO | — | BAKER | 02/27/91 | N/A | — | UNKNOWN | NULL | 3643 Park Pl | Los Angeles | CA | 90027 | GRP-5960 | — |
| TPA | TPA-60348 | 2026-06-24T16:12:10Z | Alan | — | Simmons·· | 1995-04-25 | UNKNOWN | NULL | (414) 236-1332 | N/A·· | 4788 Indian School Rd | Gilbert | AZ | 85260 | GRP-7414·· | — |
| TPA | TPA-58856 | 2026-05-03T16:31:27Z | — | — | — | 1966-06-07 | — | •••-••-8582 | N/A | null | 723 Camelback Road | Chandler | AZ·· | 85211 | GRP-1006 | — |
| TPA | TPA-63067 | 2026-04-10T18:20:26Z | Luis | — | Nichols | Aug 2, 1975 | — | null·· | — | luis.nichols62@icloud.com | 7229 Union Street | Seattle | WA | 98198 | N/A | null |
| TPA | TPA-54754 | 2026-08-21T00:48:00Z | AMY | — | MARTIN | 1950-07-24 | ·uhc-11699-14 | ·N/A | 2844651645·· | - | 5564 Apache Blvd #266 | Mesa | Arizona | 85212 | ·GRP-9429 | CHOICE-PLUS-PPO |
| TPA | TPA-60472 | 2026-01-14T13:23:12Z | CHRIS | — | PADILLA | 2006-02-11 | UNKNOWN | — | 254.521.5146·· | UNKNOWN | 2873 BASELINE ROAD | ·TUCSON | AZ | 85796 | GRP-1499 | - |
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.443Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty