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-58309 | 2026-02-06T14:18:42Z | Billy | — | Austin | 05/22/92 | — | — | 8977240676 | - | UNKNOWN | — | — | — | ·UNKNOWN | SELECT-EPO |
| TPA | TPA-51006 | 2026-08-25T10:23:16Z | ETHAN | — | DANIELS | 26-09-1950 | UHC-99842-56 | null | — | NULL | - | NULL | NULL | null | — | — |
| TPA | TPA-61849 | 2026-05-14T22:07:49Z | DEBORAH | — | MARTIN | 1956-07-01 | ·UHC5213904 | — | NULL | deborah.martin68@outlook.com | 8438 Ridge Road | Houston | TX | 77077 | UNKNOWN | SELECT-EPO |
| TPA | TPA-63350 | 2026-05-09T04:50:41Z | GABRIEL | ·· | PRICE | 1985-07-23 | -·· | •••-••-3054 | 5046017098 | N/A | 3420 Elm St | LAS VEGAS | NV·· | 89103 | — | OPTIONS-PPO |
| TPA | TPA-56897 | 2026-06-29T04:14:16Z | Walsh, Henry | — | — | 27-08-1949 | null | ·· | 18319492219·· | HENRY.WALSH@GMAIL.COM | 7903 Meadow Ln | Gilbert | AZ·· | 85277-1631 | UNKNOWN | — |
| TPA | TPA-50432 | 2026-03-31T09:57:15Z | Theresa | — | ·Santiago | 03/28/1976·· | — | N/A | UNKNOWN | NULL | 9056 Bayshore Drive | Phoenix | AZ | 85029 | UNKNOWN | ···· |
| TPA | TPA-52394 | 2026-05-21T23:42:07Z | Diane | ···· | Santigao | 1982-08-20 | N/A | •••-••-8297 | 612-483-5022 | null | — | UNKNOWN | UNKNOWN | null | — | - |
| TPA | TPA-57346 | 2026-07-09T12:05:41Z | Matthew | — | Munoz | — | null | - | (845) 412-7928 | — | 9083 MAIN STREET | Las Vegas | NV | 89138 | GRP-8645·· | SELECT-EPO |
| TPA | TPA-54427 | 2026-10-18T12:35:41Z | Eric | — | Aguilar | 26-07-1974 | — | ·N/A | NULL | eric.aguilar61@aol.com | 3345 Lincoln Way | Austin | TX | 78754 | GRP-9882 | N/A |
| TPA | TPA-59027 | 2026-08-21T03:31:06Z | MARTHA | — | SALAZAR | 06/10/1982 | — | •••-••-6779 | UNKNOWN | — | 1310 FOREST AVE·· | Orlando | Florida | ·32859 | GRP-4450 | CORE-HMO |
| TPA | TPA-50747 | 2026-08-01T10:28:55Z | Jake | — | Diaz | 1951-10-15 | - | — | 2629357695 | — | 37 Camelback Rd | Glendale | AZ | 85327 | — | UNKNOWN |
| TPA | TPA-64321 | 2026-10-02T19:36:17Z | Debra | — | Stone | 1962-03-19 | N/A | ·· | null | null | 57 Mesa Dr·· | Eden Prairie | MN | 55335-5983 | ···· | N/A |
| TPA | TPA-64252 | 2026-03-03T01:24:56Z | AMY | C | ·BOWMAN | 08/19/01 | UHC-43285-35 | — | N/A | — | 6542 Valley View Dr | Eden Prairie | MN | 55368 | GRP-8999 | N/A |
| TPA | TPA-58867 | 2026-07-08T09:25:46Z | Jackie | — | Ferguson | 25-09-1974 | N/A | — | 17605113432·· | — | 1854 Ocean Ave·· | ORLANDO | Florida | 32806 | - | ·· |
| TPA | TPA-58567 | 2026-05-31T00:45:14Z | Jerry | — | Lane | 1949-10-23 | - | - | NULL | — | — | — | null | - | — | ·· |
| TPA | TPA-62951 | 2026-02-02T15:52:41Z | ETHAN | — | RUIZ | ·1968-03-27 | — | UNKNOWN | - | — | 9415 Willow Ct | ·Gilbert | AZ | 85215 | — | OPTIONS-PPO |
| TPA | TPA-59476 | 2026-04-13T22:00:55Z | donald | — | stewart | 7/6/2000 | null | NULL | 12256334194 | null | — | — | N/A | null | N/A | - |
| TPA | TPA-50373 | 2026-05-07T14:21:27Z | Bryan | — | Turner | 19510908 | — | •••-••-2182 | — | — | 1071 BASELINE ROAD | Houston | TX | 77049 | null | — |
| TPA | TPA-64419 | 2026-06-15T10:48:59Z | roger | — | knight | 1977-11-15 | UNKNOWN | NULL | — | null | 6386 RIVER RD | Chandler | AZ | NULL·· | GRP-8539 | — |
| TPA | TPA-54638 | 2026-08-12T13:36:16Z | teresa | ···· | wong | 1980-10-10 | — | NULL | 14522791791 | - | 3782 Valley View Drive | ·Austin | TX | 78794 | NULL | null |
| TPA | TPA-59903 | 2026-07-06T07:56:23Z | Lori | — | Wang | 19730424 | — | •••-••-9875 | N/A | N/A·· | NULL | UNKNOWN | — | — | UNKNOWN | UNKNOWN |
| TPA | TPA-55581 | 2026-08-10T03:12:01Z | Maria | — | Schmidt | 2002-05-17 | — | - | — | null | 4327 River Road | Los Angeles | CA | ·90070 | GRP-8087 | — |
| TPA | TPA-53123 | 2026-10-10T11:43:53Z | BRENDA | — | MILLS | 1991-04-18 | — | N/A | null | brenda.mills29@icloud.com | — | — | UNKNOWN | NULL | GRP-8609 | — |
| TPA | TPA-53925 | 2026-02-14T17:00:36Z | JOYCE | — | WATKINS | 02/16/1994 | — | — | — | UNKNOWN | 8082 APACHE BOULEVARD | Houston | TX | 77092 | - | CORE-HMO |
| TPA | TPA-50503 | 2026-09-02T04:50:42Z | mark | C. | johnson | 19820203 | NULL | •••-••-5297 | 576-560-6988 | mark.johnson6@proton.me | 4650 Market Street | Las Vegas | NV | 89145 | GRP-5880 | NULL |
| TPA | TPA-63331 | 2026-08-28T22:48:48Z | Christian·· | I | Simmons | 1990-69-04 | — | — | — | — | 8494 CENTRAL AVENUE | Phoenix | ·az | 85092 | — | ·· |
| TPA | TPA-64420 | 2026-08-07T00:37:10Z | Amy | — | Graham | 2004-10-25 | — | UNKNOWN | NULL | amy.graham@aol.com | - | ···· | UNKNOWN | NULL | null | N/A |
| TPA | TPA-57603 | 2026-04-06T10:54:41Z | Lisa | S | Gardner | 02/21/1972 | UHC-73897-42 | •••-••-0346 | null | N/A | 4855 Sunset Boulevard | LAS VEGAS | ·NV | 89139 | — | NAVIGATE-HMO |
| TPA | TPA-52297 | 2026-05-12T20:59:20Z | Paul | — | Fernnadez | 1989-03-22·· | NULL | N/A | NULL·· | PAUL.FERNANDEZ@HOTMAIL.COM | 3114 BROADWAY | Scottsdale | AZ | 85204 | NULL | ·CORE-HMO |
| TPA | TPA-51346 | 2026-02-12T11:58:52Z | Melissa | — | Thompson | Aug 26, 1990·· | N/A | — | (929) 355-5709 | - | 9669 Valley View Drive | Orlando·· | FL | 32889·· | GRP-8032 | null |
| TPA | TPA-51466 | 2026-07-06T15:35:30Z | Dorothy | — | Rogers | 1976-08-24 | - | NULL | N/A | N/A | 7012 Union St·· | Seattle | WA | ·98106 | — | UNKNOWN |
| TPA | TPA-60060 | 2026-10-07T01:30:17Z | James | — | Fox | 1948-04-27·· | - | - | - | — | 3685 Market St·· | HOUSTON | TX | 77049 | - | — |
| TPA | TPA-54484 | 2026-01-27T08:13:29Z | ·MTAEO | — | HARRIS | 19432106 | N/A·· | •••-••-9289 | NULL | ·· | NULL | — | NULL | — | GRP-5510 | - |
| TPA | TPA-56275 | 2026-02-04T02:06:07Z | PATRICK | R | EVANS | 1977-02-01 | UHC-91421-44 | — | 6859068697 | NULL | — | — | — | — | GRP-3794 | SELECT-EPO |
| TPA | TPA-54546 | 2026-04-25T06:49:33Z | ALBERT | ·· | STEPHENS | 1967-02-04 | ·N/A | •••-••-8177 | 12968297461 | albert.stephens@outlook.com | 5794 RIDGE ROAD | Columbus | Ohio | 43213 | null | ·NAVIGATE-HMO |
| TPA | TPA-61320 | 2026-03-04T01:57:19Z | Rose, Madison | — | — | 11/16/66 | UHC-58752-22·· | •••-••-2912 | — | — | 3811 Bayshore Drive | Scottsdale | AZ | 85291 | GRP-2831 | -·· |
| TPA | TPA-61266 | 2026-08-06T05:56:53Z | BILLY | — | GREEN | 1939-11-06 | — | — | 464-626-4015 | — | 1467 SAGE COURT | Las Vegas | NV·· | 89165 | UNKNOWN | N/A |
| TPA | TPA-50025 | 2026-04-28T03:04:22Z | Valentina | — | Warren | 1959-11-17 | UHC-64240-81 | - | 17375366901 | — | 9049 MAPLE AVE | DALLAS | TX·· | 75225 | UNKNOWN | ·CORE-HMO |
| TPA | TPA-61186 | 2026-04-06T17:11:34Z | Shirley | — | Thomas | 01/03/50 | N/A | UNKNOWN | ·891-494-2053 | NULL | 4157 Jefferson Ave | San Diego | CA | 92155 | — | N/A |
| TPA | TPA-53657 | 2026-10-17T10:39:07Z | JESSICA | — | VGEA | 1967-09-05 | — | ·N/A | (768) 876-0369 | jessica.vega37@hotmail.com·· | 8510 Ridge Rd | Dallas | ·TX | 75225 | — | — |
| TPA | TPA-61206 | 2026-08-04T10:33:41Z | JASON | — | HANSEN | 19911227·· | null | null | (591) 254-3812 | N/A | 4417 Sage Ct Apt 33 | Eden Prairie | MN | 55345 | null | null |
| TPA | TPA-59163 | 2026-04-01T09:21:55Z | NOAH | — | HALL | 02-05-1967 | N/A | — | - | — | 8762 Desert Sky Blvd | TAMPA | FL | 33644 | GRP-4915 | null |
| TPA | TPA-52262 | 2026-03-24T04:17:32Z | George | — | Farnklin | 1964-06-09 | - | — | 587-368-4956 | NULL | - | UNKNOWN | N/A | UNKNOWN | — | — |
| TPA | TPA-63189 | 2026-03-06T15:34:45Z | LOGAN | — | PAYNE | 08-04-1986 | - | N/A | — | null | 279 Apache Blvd | ·Orlando | FL | 32830 | GRP-0549 | NAVIGATE-HMO |
| TPA | TPA-60882 | 2026-05-01T02:59:55Z | JOYCE | — | COLEMAN | ·1971-05-08 | — | - | ·(735) 547-1842 | joyce.coleman85@gmail.com | 5607 MEADOW LN #325 | Los Angeles | CA | 90068 | — | null |
| TPA | TPA-56241 | 2026-08-01T00:54:52Z | Jessica | J. | ·Barnes | 1985-08-04 | null | •••-••-7174 | - | null | null | - | null | — | — | — |
| TPA | TPA-57495 | 2026-10-11T12:11:33Z | ross | — | ruth | 1973-06-03 | — | NULL | UNKNOWN | — | 4968 LINCOLN WAY | CHANDLER | az | 85285 | NULL | - |
| TPA | TPA-50325 | 2026-05-23T13:47:10Z | STEPHEN | C. | MURPHY | 1955-10-14 | UHC-00291-43 | N/A | ·6837202601 | null | 9309 Ridge Road | Nashville | Tennessee | 37202·· | N/A | null |
| TPA | TPA-50803 | 2026-09-10T23:23:21Z | HIROSHI | I. | REYNOLDS | 21-06-1965 | UHC-14204-71 | •••-••-3799 | NULL | ·· | 2054 Sunset Blvd | Sacramento | CA | 95897-3490 | GRP-3130 | CORE-HMO |
| TPA | TPA-50453 | 2026-02-05T11:02:51Z | Maria | — | Harrison | 1998-01-02 | UNKNOWN | •••-••-5727 | — | null | - | UNKNOWN | N/A | - | ···· | UNKNOWN |
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-19T19:54:25.431Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty