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-59200 | 2026-03-18T20:02:22Z | Arnold | — | Pamela·· | 1973-11-19 | ·· | — | 239.935.5420 | — | 1082 MAPLE AVENUE·· | San Diego | CA | 92184·· | — | - |
| TPA | TPA-62682 | 2026-02-12T05:28:31Z | Joe | — | Perry | 1940-12-09 | - | •••-••-9224 | 5905279824 | N/A | 4480 Willow Ct | Denver | CO | 80275 | NULL | SELECT-EPO |
| TPA | TPA-58940 | 2026-07-19T22:58:01Z | ·Raymond | — | Mills | 1957-05-17 | - | null | 498.661.6054 | - | -·· | null | NULL | — | GRP-2475 | — |
| TPA | TPA-50396 | 2026-02-26T06:41:23Z | RAYMOND | — | WALKER | 07/26/05 | N/A·· | •••-••-2796 | — | N/A | 1409 Washington St | Mesa | AZ | 85247 | NULL·· | — |
| TPA | TPA-53996 | 2026-03-05T11:50:16Z | GABRIEL | — | MUNOZ | 1938-08-21 | N/A | NULL | ···· | NULL | 1299 Indian School Road | Glendale | AZ | 85370 | GRP-1393 | - |
| TPA | TPA-54271 | 2026-02-09T13:47:43Z | Matthew | — | Jones | 2002-04-11 | UHC7156308 | - | — | null | 5855 Broadway | AUSTIN | TX | 78700 | NULL | null |
| TPA | TPA-63903 | 2026-03-18T18:42:18Z | RICHARD | — | CLARK | 1972-10-03 | ·· | •••-••-1712 | 799-278-2888 | - | 569 FOREST AVE | Atlanta | GA | 30377 | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-61271 | 2026-07-18T20:42:51Z | Christian | — | Austin | Oct 2, 1946 | UNKNOWN | — | NULL | — | 7010 Baseline Rd·· | Phoenix | AZ | 85049 | — | null |
| TPA | TPA-54669 | 2026-06-18T22:16:05Z | EUGENE | — | PETERSON | 1942-11-20 | - | NULL | N/A | eugene.peterson@gmail.com | 2480 Ocean Ave | Minneapolis | MN | 55489-3355 | UNKNOWN | UNKNOWN |
| TPA | TPA-57210 | 2026-09-18T02:07:05Z | Burns, Douglas | — | — | 1994-09-24 | null | •••-••-8816 | UNKNOWN | — | 344 Church St | FRESNO·· | CA | — | GRP-0330 | MEDICARE-ADV-A |
| TPA | TPA-62394 | 2026-10-14T16:22:15Z | Sharon | ·R. | Hoffman | 1974-03-02 | — | -·· | null | - | 342 Baseline Road | Mesa | AZ | 85209·· | GRP-6185 | NULL |
| TPA | TPA-56602 | 2026-01-16T11:46:49Z | EUGENE | — | KENNEDY | 1955-02-04 | UHC-35358-92 | •••-••-6878 | N/A | — | ·4602 Grand Ave | Fresno | CA | ·93727 | GRP-3376 | null |
| TPA | TPA-57856 | 2026-04-22T10:16:35Z | ALAN | — | BRADLEY | ·10/03/1975 | null | — | 967-518-0224 | - | 5811 RIVER ROAD | Glendale | AZ | 85343 | UNKNOWN | SELECT-EPO |
| TPA | TPA-50969 | 2026-08-22T03:25:11Z | Luccas, Betty | — | — | 12/10/1984 | — | null | UNKNOWN | - | 8176 Mesa Drive | ·Nashville | Tennessee | 37212 | GRP-1182 | MEDICARE-ADV-A |
| TPA | TPA-54202 | 2026-06-03T02:27:10Z | Wei | — | Jenkiins | 1985-01-01 | null | N/A | ·6257616400 | null | 2854 Elm St | Nashville | Tennessee | 37253-9128 | N/A | - |
| TPA | TPA-53386 | 2026-01-31T18:34:56Z | Paul | — | Little | 1696-04-09 | - | UNKNOWN | N/A | N/A | 7967 Sage Ct | Tampa | FL | 33667 | - | NULL |
| TPA | TPA-57319 | 2026-01-29T19:25:13Z | DOUGLAS | — | JONES | 1993-04-21 | — | — | (715) 992-7250 | — | N/A | NULL | — | null | GRP-1712 | — |
| TPA | TPA-64330 | 2026-05-18T13:20:17Z | Laura | — | Torres | 1972-04-11 | — | •••-••-0815 | N/A | — | 3253 Willow Ct | Columbus | OH | N/A | — | null |
| TPA | TPA-57998 | 2026-05-23T17:34:48Z | Gloria, Hayes B | — | — | 2006-11-05 | UHC-74017-49 | NULL | - | GLORIA.HAYES99@OUTLOOK.COM | 9821 Spring Street·· | Fresno | CA | 93770 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-53503 | 2026-03-21T01:09:56Z | Donald | ···· | Castro | 1984-06-20 | NULL·· | UNKNOWN | 15994772484 | N/A | 1823 MOUNTAIN VIEW DR | Tampa | FL | 33607 | GRP-3747·· | — |
| TPA | TPA-60529 | 2026-05-06T15:14:21Z | ALICE | ·· | MEYER | 1980-10-04·· | UHC-24459-46 | NULL | — | UNKNOWN·· | 7448 Mesa Dr | CHANDLER | AZ | 85272 | NULL | — |
| TPA | TPA-61203 | 2026-01-16T04:18:11Z | Roger | V | Warren | 1962-09-09 | null·· | •••-••-6711 | 267.483.6157 | — | 6569 MOUNTAIN VIEW DR·· | Nashville | TN | 37282-7923 | GRP-2251 | CHOICE-PLUS-PPO |
| TPA | TPA-63563 | 2026-09-05T09:03:07Z | JANICE | — | SALAZAR | ·8/16/1959 | — | •••-••-3525 | - | ·UNKNOWN | 5992 Palm Dr | Tempe | AZ | 85222 | NULL | NAVIGATE-HMO |
| TPA | TPA-51726 | 2026-02-10T03:16:36Z | Andrea | D. | Alvarado | Apr 4, 2001 | - | null | ·NULL | UNKNOWN | 5259 Pine Dr | Mesa | AZ·· | 85207 | — | — |
| TPA | TPA-56870 | 2026-04-14T11:39:16Z | Bryant, George | — | — | 19651115 | ·- | — | N/A | NULL | 2407 Bayshore Drive | San Diego | CA | ·92181 | GRP-4194 | ·N/A |
| TPA | TPA-59428 | 2026-08-04T08:50:23Z | Natalie | — | Morgan | 6/10/1984 | N/A | — | (895) 777-5802 | N/A | 597 Washington St·· | Miami | FL | ·33111 | UNKNOWN | — |
| TPA | TPA-57631 | 2026-02-22T01:57:54Z | Danielle | ···· | Joran | 12/20/1973 | NULL | — | (855) 458-7156 | — | 2275 Hillcrest Road | Sacramento | CA | - | GRP-0200 | null |
| TPA | TPA-62232 | 2026-01-22T20:19:13Z | WAYNE | — | FERNANDEZ·· | 12/03/1941 | — | - | ·14989514706 | — | 6873 CANYON ROAD | JACKSONVILLE | FL | 32269 | — | — |
| TPA | TPA-56856 | 2026-08-03T07:01:26Z | CHARLES | — | MATTHEWS | 12-05-1952 | — | - | 462-311-8794 | - | ·8323 Market St | ·Los Angeles | CA | 90080 | GRP-0705 | UNKNOWN |
| TPA | TPA-53303 | 2026-01-24T09:41:24Z | Justin | — | Little | Jun 17, 1966 | null | •••-••-6925 | 657-911-5337 | — | 7591 CEDAR LN | Houston | TX | 77007 | null | null |
| TPA | TPA-55353 | 2026-07-07T09:30:03Z | ·Fowler, Brittany | ···· | — | Nov 7, 1995 | — | •••-••-6907 | 12982697516 | BRITTANY.FOWLER40@PROTON.ME | 3562 APACHE BOULEVARD | Austin·· | TX | ·78742-6853 | NULL | — |
| TPA | TPA-54027 | 2026-10-18T17:20:52Z | Daniel | — | Pena | 1978-06-28 | UNKNOWN·· | — | 256.699.0956 | N/A | 3626 Meadow Lane | Columbus | OH | 43291 | GRP-5166 | - |
| TPA | TPA-51457 | 2026-05-06T03:38:28Z | Rachel | — | Hart | ·1963-10-16 | UHC-02912-42 | — | null·· | ···· | N/A | NULL | UNKNOWN | — | GRP-1043 | NULL |
| TPA | TPA-51134 | 2026-03-10T06:45:29Z | Brandon·· | — | Rice | 1986-03-14 | - | •••-••-2512 | — | N/A | null | UNKNOWN | ·· | — | — | UNKNOWN |
| TPA | TPA-58157 | 2026-10-15T07:53:09Z | GERALD | ···· | ORTEGA | 1979-90-05 | NULL | - | N/A | gerald.ortega28@proton.me | 8711 Cedar Ln Apt 29 | Columbus | OH | 43291 | NULL | N/A |
| TPA | TPA-50800 | 2026-10-04T13:42:42Z | Anthony | — | Hernandez | 2003-01-03 | UNKNOWN | •••-••-0203 | UNKNOWN | ANTHONY.HERNANDEZ32@GMAIL.COM | 8512 Mesa Dr | Scottsdale | AZ | 85269 | GRP-1908 | ·CHOICE-PLUS-PPO |
| TPA | TPA-58373 | 2026-01-02T10:42:34Z | CARL | — | MARSHALL | 19630722 | N/A | N/A | 16894527111 | — | N/A·· | null | — | — | GRP-8514 | — |
| TPA | TPA-61901 | 2026-01-22T18:48:06Z | JUAN | — | HUNTER | 1965-09-22 | ·UNKNOWN | •••-••-6245 | — | NULL | 5057 VALLEY VIEW DR Apt 18·· | Chandler | AZ | 85249 | - | UNKNOWN |
| TPA | TPA-57855 | 2026-01-27T05:14:50Z | Justni | L | ·Gordon | 1958-09-10 | - | null | 343.782.8464 | — | 8913 MOUNTAIN VIEW DR | Phoenix | AZ | 85069 | — | - |
| TPA | TPA-60030 | 2026-07-10T01:24:30Z | Jacqueline | — | Willsi | 05/09/1998 | NULL | null | ·6387119546 | — | ·1671 Market Street | ·DENVER | Colorado | — | GRP-3069 | — |
| TPA | TPA-63022 | 2026-02-04T03:18:27Z | Bobby·· | — | ·Salazar | 1978-06-09 | N/A | NULL | 927-391-1269 | - | 6704 Main St Apt 24 | Seattle | WA | 98194-8388 | — | N/A |
| TPA | TPA-57442 | 2026-01-07T03:57:18Z | SOFIA | — | MYERS | 1992-03-21 | — | — | (842) 645-8625 | UNKNOWN | — | null·· | null | — | ·GRP-5435 | — |
| TPA | TPA-62662 | 2026-06-25T18:02:05Z | SOPHIA | O | BURTON | 2008-08-13 | - | •••-••-2894 | UNKNOWN | sophia.burton@gmail.com | 7187 OAK STREET | Scottsdale | AZ | ·85244 | GRP-0567 | select-epo |
| TPA | TPA-61475 | 2026-03-03T07:46:18Z | Joe | ···· | Adams | 1953-01-18 | UNKNOWN | - | 549-448-1146 | — | — | — | - | — | — | — |
| TPA | TPA-62899 | 2026-10-04T10:33:42Z | ·Ramos, Virginia | — | — | 04/27/89 | — | N/A | N/A | virginia.ramos29@outlook.com | NULL | UNKNOWN | ·N/A | — | GRP-9685 | OPTIONS-PPO |
| TPA | TPA-53691 | 2026-08-24T02:46:01Z | BOBBY | ·· | ANDERSON | 1978-03-09 | UHC-53467-07 | •••-••-3027 | 853-451-0543 | null | 3664 Harbor Boulevard | Minneapolis | MN | 55491 | ·GRP-0391 | null |
| TPA | TPA-63394 | 2026-06-23T20:28:25Z | ·CHERYL | — | CARROLL | 1988-05-10 | — | UNKNOWN | NULL·· | — | 3772 Elm St | Phoenix | AZ | 85051 | — | NAVIGATE-HMO |
| TPA | TPA-60491 | 2026-04-21T02:02:04Z | Jacob | — | Turner | 1993-10-01 | UNKNOWN | — | — | — | 5366 Church Street | NASHVILLE | TN | 37234 | ·GRP-9158 | UNKNOWN·· |
| TPA | TPA-55695 | 2026-09-05T19:57:55Z | kevin | — | rivera | 09-08-1943 | - | — | 365-398-4769 | UNKNOWN | 881 Spring Street | Eden Prairie | MN | ·55386 | null | — |
| TPA | TPA-58617 | 2026-04-21T12:30:19Z | Walker, Bryan | — | — | 1962-11-10 | N/A | •••-••-7771 | UNKNOWN | N/A·· | 385 OAK ST | Miami·· | FL | — | — | medicare-adv-a·· |
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:43.421Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty