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-62549 | 2026-04-27T13:58:18Z | ·JUAN | — | WRIGHT | 19920807 | null | •••-••-8324 | N/A·· | null·· | — | N/A | ·UNKNOWN | NULL | GRP-4635 | — |
| TPA | TPA-63644 | 2026-02-19T11:29:37Z | ·Nicholas | — | Morales | 1978-01-24 | — | •••-••-9297 | N/A·· | - | 7526 Broadway | FRESNO | CA | 93710-1785 | ·GRP-4752 | MEDICARE-ADV-B |
| TPA | TPA-57917 | 2026-10-09T07:43:28Z | MARY | — | COX | ·07/26/74 | — | — | — | - | 8749 Indian School Rd·· | Seattle | WA | 98151-2903 | — | N/A |
| TPA | TPA-60995 | 2026-02-14T15:26:34Z | Debrah | — | Luna | 1952-12-05 | - | — | NULL | UNKNOWN | 5251 CAMELBACK RD | Gilbert | AZ | 85233 | - | SELECT-EPO |
| TPA | TPA-53019 | 2026-08-12T10:39:15Z | MARIA | C.·· | HANSON | ·5/16/1991 | — | UNKNOWN | 7124154265 | — | 4857 OAK ST | Tampa | FL | 33644 | GRP-8205 | — |
| TPA | TPA-61546 | 2026-10-06T10:40:00Z | Ryan | — | Gibson | 2000-03-01 | — | NULL | — | ·- | — | — | null | — | UNKNOWN | - |
| TPA | TPA-61590 | 2026-06-23T17:38:39Z | PAUL | W | NGUYEN | 1940-12-21 | — | •••-••-9787 | +1 618 488 9896 | ·paul.nguyen@outlook.com | 5086 PARK PLACE·· | Denver | CO | 80211 | NULL | — |
| TPA | TPA-59471 | 2026-05-26T05:14:58Z | Christian | — | Mendez | 1983-12-11 | UHC3215674 | •••-••-7405 | N/A | christian.mendez66@aol.com | 9346 Market St | Tucson | AZ | 85710 | GRP-7366 | UNKNOWN |
| TPA | TPA-52871 | 2026-05-28T00:49:00Z | Santiago, Yuki | — | — | 04/09/41 | N/A | null | - | — | - | - | UNKNOWN | - | — | ·OPTIONS-PPO |
| TPA | TPA-56607 | 2026-06-02T14:12:55Z | Brenda·· | — | Wilson | 1972-01-28 | UNKNOWN | — | — | N/A | 3725 Central Avenue | TAMPA | FL·· | 33644 | GRP-3922 | — |
| TPA | TPA-53258 | 2026-08-18T10:24:38Z | Carolyn | ···· | Jimenez | 10/28/1947 | N/A | — | (532) 432-2581 | N/A·· | 3589 Pine Dr | COLUMBUS | OH | 43242 | GRP-8630 | — |
| TPA | TPA-56194 | 2026-09-04T00:52:33Z | OMAR | — | WOODS | 19800905 | — | •••-••-9675 | NULL | N/A | 6776 Mountain View Dr Apt 20 | SAN DIEGO | CA | 92146 | GRP-7165 | CORE-HMO |
| TPA | TPA-51952 | 2026-08-22T12:40:15Z | terry | — | diaz | 5/15/1939 | N/A | — | — | — | 4080 Palm Dr | PLANO | TX | N/A | GRP-4461 | — |
| TPA | TPA-56283 | 2026-08-01T00:52:01Z | Rachel | — | Kelley | 8/18/1977 | — | — | — | — | 7186 OAK STREET | Orlando | FL | 32883 | null·· | CHOICE-PLUS-PPO |
| TPA | TPA-63460 | 2026-03-05T05:24:53Z | ·Sarah | — | Sanchez | 1943-03-13 | N/A | ···· | (583) 324-1703·· | sarah.sanchez@outlook.com | 7645 SAGE CT Apt 27 | Fresno | CA | — | GRP-2644 | UNKNOWN |
| TPA | TPA-55067 | 2026-04-10T05:29:01Z | Teresa | — | Lewwis | 06/26/00 | NULL | •••-••-4950 | NULL·· | ·teresa.lewis11@hotmail.com | 7045 Meadow Ln | Dallas | TX | 75282-3095 | GRP-8942 | UNKNOWN |
| TPA | TPA-61244 | 2026-10-02T22:15:11Z | Kelly | A | Stephens | 1994-10-12·· | — | UNKNOWN | ·(702) 721-7283 | — | 5799 MAIN ST | FRESNO | CA | 93733 | — | — |
| TPA | TPA-60362 | 2026-01-12T16:09:50Z | logan | — | rose | May 2, 1964 | ·- | - | +1 443 469 0389 | — | UNKNOWN | NULL | null | UNKNOWN | NULL | — |
| TPA | TPA-58650 | 2026-01-03T03:53:52Z | VIRGINIA | — | WEAVER | ·Sep 24, 1955 | — | NULL | - | — | 5687 Sage Ct | Glendale | ·AZ | 85351 | NULL | — |
| TPA | TPA-53330 | 2026-03-18T17:54:12Z | BRIAN | ·· | PATTERSON·· | 1992-09-23 | — | — | — | - | 6786 PINE DRIVE | ·Scottsdale | AZ | 85266 | - | null |
| TPA | TPA-58384 | 2026-03-02T20:35:50Z | Wheeler, Kevin | ···· | — | 19460421 | — | N/A | — | NULL | 6231 BROADWAY | PLANO | TX | 75022 | N/A | - |
| TPA | TPA-58838 | 2026-08-16T01:27:12Z | Delgado, Evelyn | ···· | — | 1961-10-05 | UHC-46372-43 | N/A | 3543686826 | NULL | 495 Church St | PLANO·· | TX | 75074·· | null | ·CORE-HMO |
| TPA | TPA-52678 | 2026-03-08T19:07:13Z | NICHOLAS·· | — | GOMEZ | 19840117 | UHC-98466-97 | null | — | nicholas.gomez90@yahoo.com | 2392 Willow Ct | Chandler | ·AZ | 85278 | — | MEDICARE-ADV-B |
| TPA | TPA-62965 | 2026-01-27T20:27:09Z | KATHERINE | — | PORTER | 09/10/98 | — | NULL | — | — | 8284 Willow Court | Eden Prairie | MN | 55392 | — | — |
| TPA | TPA-62365 | 2026-01-22T22:33:30Z | diana | — | butler | Oct 24, 1971 | — | ·N/A | — | null | UNKNOWN | - | - | null | - | - |
| TPA | TPA-59549 | 2026-01-31T17:05:59Z | RANDY | — | LYNCH | ·1996-09-27 | UHC-19138-60 | — | — | UNKNOWN | 269 Canyon Road | Eden Prairie | MN | 55336 | NULL | NULL·· |
| TPA | TPA-51642 | 2026-09-28T21:00:04Z | CHERL | — | COLLINS | 1973-08-10 | — | ·· | N/A | UNKNOWN | null·· | N/A | N/A | - | — | -·· |
| TPA | TPA-61433 | 2026-06-01T18:25:54Z | Bryan | — | Dominguez | 12/26/1939 | — | ···· | 970.854.4869 | — | 2269 SAGE COURT | Minneapolis | Minnesota | 55442 | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-59089 | 2026-01-06T09:07:59Z | Fatima | — | Kelly | 10-06-1973 | — | NULL | — | UNKNOWN·· | 4014 Jefferson Avenue | Mesa | ·AZ | 85237 | NULL | null·· |
| TPA | TPA-53351 | 2026-02-05T19:16:07Z | Russell | — | Marshall | 1998-01-25 | — | N/A | 3983496 | N/A | NULL | NULL | — | N/A | — | — |
| TPA | TPA-61820 | 2026-07-18T08:49:43Z | Angela | — | Martinez | 19991019 | — | NULL | UNKNOWN | UNKNOWN | UNKNOWN | null | — | — | - | CORE-HMO |
| TPA | TPA-64401 | 2026-05-14T09:01:37Z | Stephen | B | Watkins | 19661020 | NULL | •••-••-6875 | 360.786.3037 | stephen.watkins@outlook.com | 5875 HARBOR BLVD | GILBERT | AZ | 85240 | UNKNOWN | - |
| TPA | TPA-55505 | 2026-06-09T00:07:23Z | lauren | ···· | holmes | 1992-02-16 | — | •••-••-5065 | (210) 788-5949 | lauren.holmes@proton.me | 8144 Camelback Rd | Austin | Texas·· | — | GRP-8518 | — |
| TPA | TPA-61436 | 2026-01-08T01:36:17Z | Nathan | — | Alvarez | 1999-11-21 | NULL | — | - | UNKNOWN | 3534 Mesa Dr | SEATTLE | WA | 98176 | GRP-1761 | MEDICARE-ADV-A |
| TPA | TPA-58896 | 2026-01-23T07:35:25Z | Carlos | R. | Wells | 2000-05-14 | UHC-40662-02 | •••-••-5616 | 823-958-7856 | UNKNOWN | 3686 SUNSET BOULEVARD | ·Los Angeles | CA | 90008 | — | ·· |
| TPA | TPA-63900 | 2026-08-09T01:05:04Z | Henry·· | — | Jacobs | May 18, 1962 | N/A | N/A | — | N/A | ·6411 FOREST AVE #557 | Las Vegas | NV | 89188 | UNKNOWN | CORE-HMO |
| TPA | TPA-52027 | 2026-03-16T03:58:08Z | CHRISTINA | — | SNYDER | 1943-04-03 | NULL | — | (424) 881-9209·· | NULL | 5219 Willow Court | Phoenix | AZ | 85058 | GRP-0420 | — |
| TPA | TPA-61289 | 2026-02-10T01:37:24Z | Kimberly | — | Bryant | 1999-01-19 | NULL | N/A | (596) 735-1509 | KIMBERLY.BRYANT@ICLOUD.COM | — | N/A | UNKNOWN | — | GRP-9231 | N/A |
| TPA | TPA-63134 | 2026-04-09T02:04:17Z | Jimenez, Christina | — | — | 1945-06-26 | — | N/A | (579) 492-4252 | — | 1998 Desert Sky Boulevard | Scottsdale | AZ | 85279 | null | — |
| TPA | TPA-62308 | 2026-06-18T14:21:57Z | Joyce | — | Nunez | Jan 18, 1991 | ···· | •••-••-4869 | ·· | N/A | 6894 DESERT SKY BOULEVARD | Seattle·· | WA | 98141 | — | NAVIGATE-HMO |
| TPA | TPA-50569 | 2026-02-28T01:53:05Z | Anthony | — | Simpson·· | Nov 27, 1952 | NULL | N/A | +1 660 728 5178 | N/A | 8962 Forest Avenue #351·· | Mesa | AZ | 85249 | UNKNOWN | null |
| TPA | TPA-51973 | 2026-05-07T17:33:26Z | Olivia | — | Walker | 1967-04-24 | null | N/A | null | — | — | — | — | NULL | ·GRP-5519 | — |
| TPA | TPA-64369 | 2026-02-15T05:17:42Z | Willie·· | — | Reyes | 1967-07-18 | UNKNOWN | UNKNOWN | — | willie.reyes22@aol.com | 9120 Mountain View Drive | Nashville | TN | 37225 | GRP-6640 | NULL |
| TPA | TPA-60803 | 2026-07-14T22:05:41Z | Melissa | — | White | 1971-80-14 | N/A | — | null | null | 7238 Canyon Rd | Nashville | TN | 37234 | N/A | — |
| TPA | TPA-52634 | 2026-05-30T20:37:15Z | KENNETH | — | TURNER | 10/21/1956 | ···· | •••-••-6120 | (936) 222-5452 | KENNETH.TURNER@OUTLOOK.COM | 2587 Main St | Glendale | AZ | 85309 | null | — |
| TPA | TPA-55531 | 2026-09-09T19:22:27Z | Jordan | — | Burtoon | 1994-05-09 | — | — | 2104226562 | — | 9072 Forest Ave | LAS VEGAS | NV | 89101 | GRP-7185 | null |
| TPA | TPA-64022 | 2026-08-02T14:47:36Z | Michelle | — | Fuller | 23-01-1967 | UNKNOWN | •••-••-7234 | UNKNOWN·· | MICHELLE.FULLER@OUTLOOK.COM | 3013 Broadway | AUSTIN | TX | 78790 | GRP-4430 | — |
| TPA | TPA-57817 | 2026-01-24T22:08:20Z | Elizabeth | ·· | Stephens | 1968-07-05 | — | •••-••-0121 | ·null | UNKNOWN | 5950 Elm Street·· | Mesa | AZ | 85282 | UNKNOWN | MEDICARE-ADV-B |
| TPA | TPA-51458 | 2026-06-04T19:40:37Z | ashley | — | montgomery | 19911001 | — | null | (259) 224-6684 | null | ·1873 Highland Avenue | Nashville | TN | 37266 | GRP-1149 | N/A |
| TPA | TPA-51367 | 2026-06-04T01:33:49Z | Hannah | — | Sims | 1982-06-23 | NULL | — | — | NULL | 3516 Lake View Rd | Tampa | FL | 33663 | — | — |
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:46.084Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty