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-55270 | 2026-06-25T06:36:07Z | Pamela | U | Ortega | 19560827 | uhc-81594-20 | NULL | 703-746-0429 | - | 871 Baseline Rd | SEATTLE | ·WA | 98157·· | UNKNOWN | NULL |
| TPA | TPA-63816 | 2026-01-13T08:37:28Z | Priya | — | Fernandez | 2007-10-11 | - | NULL | (944) 988-3064 | — | — | — | - | null | NULL | MEDICARE-ADV-B |
| TPA | TPA-52228 | 2026-02-19T11:39:51Z | ·Ward, Lawrence | — | — | 1983-01-07·· | UHC-20136-99 | null | — | — | 664 Elm Street | Tempe | AZ | null | — | navigate-hmo |
| TPA | TPA-50913 | 2026-08-30T08:23:58Z | ISABELLA | — | KELLLY | ·01/12/1974 | UNKNOWN | - | 2429136605 | — | 4031 Church St | ·SACRAMENTO | CA | 95891 | - | N/A |
| TPA | TPA-51242 | 2026-08-08T06:47:54Z | Peter | — | ·Brooks | 1965-09-18·· | N/A | — | ·NULL | N/A | 2138 UNION STREET #748·· | SEATTLE | WA | 98164 | - | — |
| TPA | TPA-64350 | 2026-07-03T05:38:19Z | Donald·· | — | Wallace | 1966-05-22 | — | — | N/A | donald.wallace@yahoo.com | 3382 MAIN ST | Austin | TX | 78763 | — | — |
| TPA | TPA-64084 | 2026-08-20T11:31:08Z | Juan·· | G | Miers | 2000-11-12 | N/A | — | 9623449518 | juan.myers87@hotmail.com | 5401 Park Pl | Dallas | TX | 75281 | — | - |
| TPA | TPA-59705 | 2026-07-07T16:37:47Z | Wonng, Raymond | — | — | 1994-04-14 | — | - | UNKNOWN | N/A | 6869 UNION STREET | ·Los Angeles | CA | 90038 | GRP-8997 | — |
| TPA | TPA-60056 | 2026-05-19T21:07:07Z | Fuller, Benjamin | — | — | 1980-12-22 | null | •••-••-8704 | UNKNOWN | — | 3136 Main St·· | Glendale | AZ | 85370 | UNKNOWN | ···· |
| TPA | TPA-59713 | 2026-07-31T19:47:26Z | Gregoyr | — | Henry | 1960-12-01 | NULL | •••-••-6547 | NULL | — | 5640 Market St | Glendale | AZ | 85379 | — | null |
| TPA | TPA-62275 | 2026-03-19T13:08:26Z | Samuel | — | Yang | 1982-10-08 | UHC0360529 | •••-••-4799 | null·· | N/A | NULL | N/A | — | — | GRP-3425 | null |
| TPA | TPA-57916 | 2026-10-09T07:43:28Z | MARY | — | COX | ·07/26/74 | — | — | — | - | 8749 Indian School Rd·· | Seattle | WA | 98151-2903 | — | N/A |
| TPA | TPA-63264 | 2026-02-06T00:35:58Z | BILLY | — | MEDINA | 19800523 | N/A | ·NULL | - | NULL | null | — | N/A | - | GRP-6504 | NULL |
| TPA | TPA-52246 | 2026-07-08T19:55:39Z | Walter | U. | ·Alvarado | 1988-09-16 | — | UNKNOWN | null | — | 1370 Washington Street | Tempe | AZ | 85256 | GRP-3984 | - |
| TPA | TPA-57770 | 2026-05-03T21:49:19Z | FATIMA | — | DANIELS | 2007-06-08 | null | null | NULL | UNKNOWN | 500 Desert Sky Blvd | Plano | TX | 75014·· | UNKNOWN | CORE-HMO |
| TPA | TPA-52441 | 2026-05-28T08:26:17Z | Sara | — | ·Carr | 2001-07-14 | - | •••-••-6696 | 5049452051 | NULL | ·1350 MARKET ST | Scottsdale | AZ | 85238 | — | — |
| TPA | TPA-56388 | 2026-04-24T16:48:48Z | Joan | — | Torres | 1963-04-07 | — | •••-••-2325 | N/A | - | 7239 RIDGE RD | ORLANDO | FL | 32894 | null | - |
| TPA | TPA-56960 | 2026-10-12T03:29:26Z | Noah·· | — | Burton | 1959-02-27 | — | — | — | UNKNOWN | 6852 MEADOW LANE #186 | Jacksonville | FL | 32259-1801 | - | - |
| TPA | TPA-61463 | 2026-09-19T02:25:33Z | Stephanie | — | Collins·· | 1959-12-06 | ·UNKNOWN | NULL | — | stephanie.collins@outlook.com·· | — | — | null | UNKNOWN | null | — |
| TPA | TPA-55592 | 2026-08-30T13:25:57Z | Burke, Russell | — | — | 01/18/59 | — | NULL | N/A | ·N/A | 6780 Mountain View Drive | Los Angeles·· | CA | 90080 | GRP-6261 | MEDICARE-ADV-A |
| TPA | TPA-59853 | 2026-02-05T06:02:52Z | Stephen | — | Dominguez | 19970223 | UHC-14104-16 | N/A·· | 5108078448 | stephen.dominguez23@aol.com | 2598 Jefferson Ave | Phoenix | AZ | 85058 | GRP-7513 | MEDICARE-ADV-B |
| TPA | TPA-53212 | 2026-07-27T06:58:58Z | GERALD | — | GOMEZ | ·2004-12-16 | NULL | UNKNOWN | (838) 378-3808 | UNKNOWN | 4632 Ocean Avenue | Houston | TX | 77029 | — | NAVIGATE-HMO |
| TPA | TPA-51038 | 2026-08-30T17:16:42Z | Elizabeth | — | Olson·· | 1939-01-23 | - | - | 5194125939 | — | 7186 Camelback Road | Las Vegas | NV | 89198·· | GRP-0537 | MEDICARE-ADV-B |
| TPA | TPA-55218 | 2026-05-08T10:25:27Z | AHMED | — | GEORGE | 04/19/1989 | - | N/A | NULL | ahmed.george@yahoo.com | — | ·null | null | — | N/A | null |
| TPA | TPA-53424 | 2026-03-10T16:21:22Z | mark | Z | webb | 02/19/79·· | NULL | •••-••-1319 | (435) 598-9637·· | mark.webb97@proton.me | 7988 Cedar Ln | Gilbert | ·AZ | 85268 | — | UNKNOWN |
| TPA | TPA-64247 | 2026-08-02T09:35:24Z | Jordan | — | Butler | 1948-10-22 | — | •••-••-7755 | — | N/A | 8496 River Rd | Jacksonville | FL | 32275 | N/A | ·- |
| TPA | TPA-59173 | 2026-01-26T22:11:27Z | Vincent | — | Castro | 1991-51-17 | N/A | •••-••-2125 | — | — | 6652 VALLEY VIEW DR | ORLANDO | FL | 32852 | - | NULL |
| TPA | TPA-54727 | 2026-04-11T14:49:17Z | OLIVIA | Q. | HALL | 02/10/65 | UHC-36984-14 | - | NULL | — | 7950 Park Place | Mesa | ·AZ | 85242 | UNKNOWN·· | null |
| TPA | TPA-56848 | 2026-04-22T14:57:55Z | JSESE | — | SINGH | Feb 14, 1988 | NULL | — | +1 924 263 5331 | jesse.singh@hotmail.com | 5619 Palm Drive·· | HOUSTON | TX | 77092 | NULL | null |
| TPA | TPA-59083 | 2026-09-10T12:02:01Z | LAUREN | — | GUTIERREZ | 1942-10-10 | NULL | — | (440) 908-3769 | N/A | 5474 Indian School Road | CHANDLER | Arizona | 85220·· | UNKNOWN | - |
| TPA | TPA-55635 | 2026-06-30T06:42:56Z | GEORGE | ·· | PADILLA | 2005-01-20 | NULL | — | — | — | 7600 VALLEY VIEW DR | CHARLOTTE | NC | ·28274 | — | MEDICARE-ADV-B |
| TPA | TPA-61011 | 2026-07-12T07:06:40Z | Lawrence | ···· | Kelly | 1942-12-20 | UNKNOWN | •••-••-8656 | 454-295-0274 | - | 9622 Central Avenue | ·Fresno | CA | 93798 | — | null |
| TPA | TPA-63573 | 2026-06-05T00:40:10Z | diego | — | weaver | ·08/19/1970 | UHC9722955·· | null | 4447441769 | null | null | - | UNKNOWN | — | — | N/A |
| TPA | TPA-54143 | 2026-02-01T07:11:25Z | Rebecca | — | Ferguson | 1939-04-11 | ···· | •••-••-4126 | 243-630-2509 | NULL | 429 Harbor Blvd Apt 7 | Tampa | FL | 33658 | — | N/A |
| TPA | TPA-63430 | 2026-05-22T04:12:07Z | Fisher, Omar | V | — | 1995-03-19 | UNKNOWN | — | — | NULL | 8386 Ocean Avenue | Las Vegas | NV | null | N/A | NAVIGATE-HMO |
| TPA | TPA-50157 | 2026-10-06T23:47:55Z | Victoria | J. | Lynch | ·1995-10-10 | null | •••-••-2565 | NULL | NULL·· | 9353 BASELINE ROAD | Jacksonville | FL | UNKNOWN | N/A | — |
| TPA | TPA-57997 | 2026-09-02T08:13:49Z | Ryan | — | Rose | ·1962-12-20 | N/A | UNKNOWN | 526.544.5466 | N/A | 6663 Highland Ave | Houston | TX | 77093 | — | null |
| TPA | TPA-63287 | 2026-01-10T16:41:54Z | Nathan | ·· | Campbell | 11/19/85 | UHC-33373-43 | N/A | 8525258031 | — | 8466 LAKE VIEW ROAD | Seattle | WA | 98103-4713 | GRP-4604 | — |
| TPA | TPA-58277 | 2026-08-02T21:48:01Z | Dylan | — | Graham | 1991-04-20 | UNKNOWN | UNKNOWN | +1 633 211 6626 | dylan.graham13@yahoo.com | 5316 Harbor Blvd | Chandler | AZ | 85237-3876 | — | — |
| TPA | TPA-59688 | 2026-08-02T04:21:54Z | Alexander | — | Turner | 1965-08-27 | — | NULL | N/A | null | 429 Pine Drive #222 | Sacramento | CA | 95897 | — | ·MEDICARE-ADV-A |
| TPA | TPA-54493 | 2026-07-27T00:21:50Z | Omar | — | Estrada | 07/13/56 | NULL | - | 3688103781 | omar.estrada22@gmail.com | 5347 SUNSET BLVD | Minneapolis | mn | 55405 | GRP-3803 | UNKNOWN |
| TPA | TPA-57253 | 2026-01-15T18:05:09Z | MATTHEW | ·F. | LI | 11/22/1954 | null·· | null | 989-806-6435 | — | - | - | — | — | — | - |
| TPA | TPA-54026 | 2026-05-10T01:16:48Z | Hernandez, Samuel·· | R | — | 10/22/80 | - | — | N/A | — | 6839 JEFFERSON AVE | ORLANDO | FL | 32889·· | null | MEDICARE-ADV-B |
| TPA | TPA-50656 | 2026-08-09T02:21:44Z | Amanda | — | Lee | 1944-07-18 | UNKNOWN | — | null | NULL | 114 MESA DRIVE | Atlanta | GA | 30338 | N/A | SELECT-EPO |
| TPA | TPA-54023 | 2026-06-06T22:29:36Z | Shirley | — | McDonald | 1949-08-25 | — | null | NULL | ·- | 3937 Church Street | San Diego | CA | 92164 | - | N/A |
| TPA | TPA-50905 | 2026-04-24T20:40:51Z | Gray, Anthony | Z | — | 1947-05-21 | - | null | 4984169169 | UNKNOWN | 3721 Park Place | Miami | FL | 33102 | — | OPTIONS-PPO |
| TPA | TPA-55696 | 2026-06-26T06:08:17Z | Cheryl | — | Gonzales | 1958-02-01·· | null | •••-••-4731 | — | null·· | 7206 MARKET ST | Mesa | AZ | 85274 | GRP-8180·· | — |
| TPA | TPA-57266 | 2026-03-24T07:42:50Z | Martha | — | Hawkins | 2004-12-04 | UHC-77244-10 | N/A | UNKNOWN | — | 3240 Baseline Road | Houston | TX | 77021 | GRP-1714 | N/A |
| TPA | TPA-59246 | 2026-03-04T01:21:34Z | Judith | — | Foster·· | 1961-06-06 | UHC-14918-29 | •••-••-1913 | (980) 398-3758 | ···· | 8367 SAGE COURT | Dallas | TX | ·· | GRP-6190 | - |
| TPA | TPA-55082 | 2026-10-02T18:05:48Z | Katherine | — | Bowman | null | null | UNKNOWN | UNKNOWN | ·· | 4963 CENTRAL AVE | Mesa | AZ | - | NULL·· | null |
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:52.209Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty