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-61230 | 2026-07-07T09:05:31Z | ELIZABETH | ·· | WEAVER | 1985-07-09 | UHC-21629-88 | — | NULL | N/A | 2357 OCEAN AVENUE | San Antonio | ·TX | 78239 | GRP-9943 | ···· |
| TPA | TPA-50815 | 2026-08-27T20:13:07Z | GABRIEL | — | HANSON | 07/24/81 | — | — | 828-645-3056 | — | UNKNOWN | UNKNOWN | UNKNOWN | — | — | — |
| TPA | TPA-51113 | 2026-01-12T01:54:38Z | Perez, Emma | A. | — | 1997-09-25 | — | •••-••-7416 | NULL | NULL | UNKNOWN | — | UNKNOWN | ·N/A | — | N/A |
| TPA | TPA-60601 | 2026-03-27T10:08:43Z | Hayes, Lawrence | ·· | — | 18-11-2003 | UHC-66712-26 | — | (507) 443-9864 | lawrence.hayes@aol.com | 1346 MESA DRIVE | SAN DIEGO | CA | 92171 | NULL | NAVIGATE-HMO |
| TPA | TPA-60436 | 2026-09-15T21:52:37Z | Ronald | — | West | 2007-07-24 | NULL | — | 3499013255 | NULL | ·1699 Union Street | Minneapolis | MN | 55467-8500 | - | — |
| TPA | TPA-52037 | 2026-06-02T15:13:04Z | Cathrine | W. | Padilla | Jun 11, 1967 | UHC-52750-78 | •••-••-2947 | 2318254845 | CATHERINE.PADILLA97@GMAIL.COM·· | 8339 Lincoln Way | Columbus | OH | 43266 | NULL | - |
| TPA | TPA-57885 | 2026-05-14T22:15:19Z | Catherine·· | — | Guzman | 04-08-1981 | — | ·N/A | - | UNKNOWN | 7276 Elm Street #947 | Tempe | AZ | 85295 | - | — |
| TPA | TPA-60511 | 2026-01-26T18:36:30Z | Sean | — | Garrett | 08/10/41 | null | NULL·· | 7509554676 | SEAN.GARRETT27@AOL.COM | 3081 Indian School Road | Tampa | FL | 33662 | N/A | null |
| TPA | TPA-56830 | 2026-01-26T09:10:04Z | Diane | — | Morrison | 1956-04-09 | - | — | — | diane.morrison29@gmail.com | 8104 MOUNTAIN VIEW DR | Gilbert·· | AZ | 85251 | ·GRP-0757 | ·UNKNOWN |
| TPA | TPA-63846 | 2026-08-25T23:41:29Z | Raymond | — | MccDonald | 1946-09-22 | null | N/A | 349-234-6630 | — | 9897 Canyon Rd | ATLANTA | ga | 30362 | null | — |
| TPA | TPA-52369 | 2026-06-13T21:11:28Z | Rebecca·· | — | Astin | 1983-03-26 | — | — | 333-267-8414 | REBECCA.AUSTIN@ICLOUD.COM | 2519 Spring St | Atlanta | GA | 30354 | GRP-2063 | NULL·· |
| TPA | TPA-53008 | 2026-03-24T21:56:19Z | Kimberly | — | Davis | 20000721 | UHC-50056-18 | N/A | 6603828981 | null | ·8133 Union St | Glendale | AZ | 85391 | — | UNKNOWN |
| TPA | TPA-59968 | 2026-05-11T16:03:37Z | ERIC | G | PERKINS | 1999-11-21 | — | — | — | ERIC.PERKINS@HOTMAIL.COM | 7227 Sunset Blvd | Tampa | FL | 33639 | GRP-6080 | CHOICE-PLUS-PPO |
| TPA | TPA-50876 | 2026-09-02T09:56:09Z | Martha | M | Dean | 1989-02-17 | N/A | •••-••-2395 | - | null·· | 5105 SPRING STREET | Tempe | Arizona | N/A | — | medicare-adv-b |
| TPA | TPA-54721 | 2026-04-21T15:54:05Z | Lauren | — | Perry·· | 1954-10-27 | ···· | •••-••-9222 | 966.432.6969 | N/A | 1166 Camelback Rd | Eden Prairie | MN | 55300 | NULL | MEDICARE-ADV-A |
| TPA | TPA-53508 | 2026-05-26T22:14:19Z | Lawrence | — | Diaz | 1938-06-03 | NULL | NULL | (930) 944-0897 | ·lawrence.diaz@gmail.com | 6968 Mesa Drive | Chandler | AZ | 85254 | UNKNOWN | — |
| TPA | TPA-61043 | 2026-05-30T09:35:47Z | sean | — | ·campbell | Dec 12, 1982 | UHC-19745-75 | •••-••-8070 | 366-700-0422 | — | ···· | — | — | UNKNOWN | — | null |
| TPA | TPA-58566 | 2026-03-15T15:28:49Z | Lane, Jerry | — | — | 10/23/1949 | — | — | 5816804 | — | 2060 Ocean Ave | Orlando | FL | 32820·· | ·· | — |
| TPA | TPA-54351 | 2026-06-21T05:23:33Z | ·TERESA | — | HAYES | 1958-07-09 | UNKNOWN | null | — | null | — | — | — | ·- | ·null | NULL |
| TPA | TPA-61847 | 2026-03-13T14:28:05Z | Joe | — | Bishop | 1967-10-04 | ·- | — | — | UNKNOWN | 3979 Elm Street | Gilbert | AZ | 85264 | — | null |
| TPA | TPA-57062 | 2026-07-30T15:52:51Z | CARL | — | SCHMIDT | 0905-91-63 | - | NULL | 7774573348 | - | 1359 PINE DRIVE | Mesa | Arizona | 85254 | GRP-2498 | ·· |
| TPA | TPA-52588 | 2026-03-26T06:37:04Z | dylan | — | stone | 08/01/1980 | N/A | — | 4733786248 | NULL | 9835 Jefferson Ave | Tampa | FL·· | 33640 | - | — |
| TPA | TPA-63448 | 2026-01-05T04:22:19Z | Ralph | — | Phillips | 1983-08-09 | — | •••-••-1883 | 14636004576 | ·· | 6178 PARK PLACE Apt 29 | Austin | TX | 78712 | GRP-6296 | — |
| TPA | TPA-52147 | 2026-02-09T00:03:35Z | JESSICA | — | ·TORRES | ·07/02/1971 | UHC-04919-14 | - | 707.916.4172 | null | ·1126 Elm Street | ATLANTA | GA | 30368 | GRP-1970·· | CHOICE-PLUS-PPO |
| TPA | TPA-60676 | 2026-05-07T22:17:56Z | Sue | — | Vazquez | 2007-09-06 | UHC-84134-22 | UNKNOWN·· | +1 320 698 7761 | null | ·7588 APACHE BOULEVARD | Eden Prairie | MN | 55378 | — | UNKNOWN |
| TPA | TPA-51729 | 2026-08-08T14:25:37Z | Arjun | — | Ray | 19630312 | N/A | UNKNOWN | UNKNOWN | — | 5602 CAMELBACK ROAD·· | Atlanta | GA | 30305 | null | — |
| TPA | TPA-55920 | 2026-09-11T17:50:58Z | Natalie | — | Wang | 05/17/1942 | — | NULL | NULL | NULL | 5516 Market St | AUSTIN | TX | 78786 | — | NULL |
| TPA | TPA-60109 | 2026-06-05T00:06:48Z | ·Amanda | — | Kelly | 2001-05-04 | — | NULL | 5352352423 | null | 2294 SUNSET BOULEVARD | PHOENIX | AZ | 85090 | — | — |
| TPA | TPA-55459 | 2026-06-16T18:31:59Z | Munoz | ·· | Brandon | ·Aug 13, 1954 | — | •••-••-6662 | — | null | 7696 Highland Ave | TEMPE | AZ | — | — | CORE-HMO |
| TPA | TPA-57750 | 2026-07-26T15:55:37Z | Alexis | — | Tran | 01/26/1938 | UHC-80596-07 | •••-••-0444 | (634) 916-6724 | null | 238 Apache Blvd·· | Sacramento | CA | 95836·· | NULL·· | N/A |
| TPA | TPA-51031 | 2026-03-15T04:54:38Z | JAMES | — | ·CHEN | 1961-02-13 | N/A | null | UNKNOWN | NULL | 2201 RIVER ROAD·· | Tucson | AZ | 85704 | N/A | UNKNOWN |
| TPA | TPA-58159 | 2026-02-12T22:25:13Z | ·Elliott, Charlotte | — | — | 1996-01-01 | — | •••-••-7755 | — | null | 7422 Market Street | GLENDALE | AZ | 85322 | GRP-0750 | CORE-HMO |
| TPA | TPA-52697 | 2026-06-28T23:21:55Z | Mariana | — | Peters | 1948-07-02 | UHC-46297-05 | — | N/A | MARIANA.PETERS@PROTON.ME | 210 Highland Ave | SEATTLE | WA | 98129 | — | N/A |
| TPA | TPA-59233 | 2026-05-31T04:38:39Z | ·Jesse | — | Perkins | 04/16/85 | — | - | (732) 969-1671 | NULL | 6341 WILLOW COURT | Nashville | TN | 37225 | N/A | — |
| TPA | TPA-54237 | 2026-04-10T23:10:45Z | Patricia | — | Phillips | 1963-07-20 | — | — | — | N/A | 3971 Jefferson Avenue #862 | Los Angeles | CA | 90010·· | null | null |
| TPA | TPA-57060 | 2026-01-05T06:02:04Z | CAMILA | W | WALSH | 01/13/60 | N/A | •••-••-4489 | (771) 688-5768 | — | 2775 Harbor Boulevard | Tempe | AZ | 85215·· | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-61645 | 2026-01-22T11:04:02Z | Jenen | — | Helen | 11/10/1974 | — | - | 312-673-7421 | null | 5779 Market Street | Charlotte | NC | 28244 | NULL | null |
| TPA | TPA-52627 | 2026-05-09T19:58:45Z | Jimmy | — | Hamilton | 1994-09-27 | null | — | N/A | james.hamilton@gmail.com·· | 2485 MOUNTAIN VIEW DR | Los Angeles | CA | 90040 | NULL | — |
| TPA | TPA-53497 | 2026-06-10T02:25:00Z | Jeremy | — | ·Daniels | 19610221 | ·UHC-81515-12 | — | — | - | 6850 SAGE COURT | Las Vegas | ·Nevada | — | UNKNOWN | ·· |
| TPA | TPA-56292 | 2026-10-13T18:19:51Z | RYAN | — | DUNCAN | 1971-05-26 | — | •••-••-8774 | 4465996390 | ryan.duncan@gmail.com | 6813 Spring St | Scottsdale | ·AZ | 85230 | - | SELECT-EPO |
| TPA | TPA-59397 | 2026-05-27T15:37:30Z | Dylan | — | Bowman·· | Jun 22, 1984 | ·· | — | 438-697-6432 | UNKNOWN | 2383 CEDAR LN | ·Jacksonville | FL | 32237 | N/A | — |
| TPA | TPA-50011 | 2026-08-28T09:19:37Z | Sarah | — | Collins | 1940-09-18·· | — | •••-••-7701 | — | NULL | 6195 Camelback Road | Mesa·· | AZ | 85275·· | N/A | -·· |
| TPA | TPA-54309 | 2026-10-09T02:33:55Z | ANA | — | CUNNINGHAM | 19720303 | UHC-35095-35 | - | (454) 799-9463 | N/A | 1845 DESERT SKY BOULEVARD | Scottsdale | AZ | 85299 | UNKNOWN | — |
| TPA | TPA-61100 | 2026-07-16T17:22:55Z | Rachel | — | Nunez·· | Jun 25, 1959 | — | ···· | N/A | rachel.nunez3@gmail.com | 3897 MARKET STREET | Tampa | FL | 33692 | ·GRP-4845 | — |
| TPA | TPA-60854 | 2026-05-19T20:19:04Z | Janice | — | Jordan·· | 1966-03-24 | ···· | N/A·· | — | — | 774 Washington Street·· | Nashville | TN | 37275 | — | — |
| TPA | TPA-58085 | 2026-05-30T10:41:12Z | Doris | — | Peterson | 1989-06-09 | UNKNOWN | null | null | null | 5401 DESERT SKY BOULEVARD | FRESNO | CA | ·93753 | — | NULL |
| TPA | TPA-60260 | 2026-02-04T03:52:59Z | EVELYN | — | PALMER | 01/03/56 | UNKNOWN | •••-••-7223 | null | — | 2570 Lake View Road | FRESNO | CA | 93770 | GRP-2603 | — |
| TPA | TPA-57795 | 2026-07-15T16:43:03Z | CARLUS | — | MCCOY | 1981-10-23 | null | null | — | N/A | 4191 Grand Avenue | ·Plano | TX·· | 75061 | — | N/A |
| TPA | TPA-54011 | 2026-09-15T08:56:55Z | EMMA | — | ROBERTSON | 1974-03-04 | NULL | — | — | UNKNOWN | ·434 PINE DR | Tempe | AZ | 85242 | null | ·NULL |
| TPA | TPA-58527 | 2026-04-07T07:00:57Z | ·madison | — | knight | 02/05/1984 | UNKNOWN·· | •••-••-1242 | N/A | NULL | 8677 Baseline Road Apt 37 | Atlanta | GA | 30319 | N/A | ·CHOICE-PLUS-PPO |
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:34.805Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty