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-63335 | 2026-08-27T14:41:16Z | ·GARY | — | RYAN | 1965-08-20 | N/A | — | — | UNKNOWN | ·3177 Canyon Road | Tucson·· | AZ | 85783 | NULL | OPTIONS-PPO |
| TPA | TPA-51488 | 2026-05-26T06:08:40Z | Austin | — | Reid | 1941-04-21 | UHC-86036-53 | •••-••-1981 | (443) 365-1405 | N/A | 9802 Palm Dr | Plano | ·TX | 75017 | GRP-1561 | N/A |
| TPA | TPA-51570 | 2026-10-06T09:17:32Z | Edward | N | Porter | 19990728 | — | N/A | — | edward.porter69@gmail.com | 226 Broadway | Houston | TX | — | GRP-6337 | — |
| TPA | TPA-50461 | 2026-05-10T07:44:57Z | Henry | — | Gray | 21-12-1950 | null | ·NULL | - | NULL·· | - | N/A | NULL | UNKNOWN | NULL | — |
| TPA | TPA-53587 | 2026-05-09T17:09:37Z | Philip | — | Bleck | 1955-02-06 | UHC6869247 | — | +1 818 343 1032 | philip.black@outlook.com | 1873 Forest Ave | HOUSTON | TX | 77015 | GRP-8027 | — |
| TPA | TPA-53186 | 2026-06-25T03:39:16Z | Green, Amber·· | — | — | 1981-11-20 | — | •••-••-7384 | ·(334) 545-1443 | UNKNOWN | ·6965 BASELINE ROAD | ·CHARLOTTE | NC | 28269 | GRP-4423 | N/A |
| TPA | TPA-52824 | 2026-02-21T01:05:11Z | philip | ·· | bradley | 06/28/1945 | - | UNKNOWN | N/A | null | 2457 Hillcrest Rd | Minneapolis | MN | 55448-4345 | GRP-9547 | — |
| TPA | TPA-56175 | 2026-04-21T17:43:57Z | JUDITH | — | FOSTER | 19720703 | ·· | - | null | — | 6667 Elm Street | Dallas | TX | 75243 | — | NULL |
| TPA | TPA-61752 | 2026-08-10T18:17:34Z | SARA | ···· | CRUZ | 1962-05-20 | null | — | UNKNOWN | UNKNOWN | — | UNKNOWN·· | UNKNOWN | — | — | — |
| TPA | TPA-52211 | 2026-07-18T02:27:35Z | Smith, Michelle | M | ·· | 5/10/2003 | — | •••-••-1321 | — | michelle.smith34@proton.me | ·5366 Main St | Fresno | CA | 93769 | — | NULL |
| TPA | TPA-63937 | 2026-09-07T02:56:42Z | PATRICIA | ···· | PARKER | Jul 15, 1956 | UNKNOWN | - | N/A | — | 2919 Lake View Rd | Tucson | AZ | 85743-3332 | - | ·OPTIONS-PPO |
| TPA | TPA-54686 | 2026-06-17T01:18:01Z | Garza, Ahmed | — | — | 1967-12-09 | - | — | ·· | — | 9602 Palm Dr | Nashville | TN | 37292 | UNKNOWN | MEDICARE-ADV-A |
| TPA | TPA-53405 | 2026-02-03T13:54:52Z | Rachel | — | Hart | - | — | N/A | — | N/A·· | - | N/A | null | — | GRP-6761 | MEDICARE-ADV-A |
| TPA | TPA-59444 | 2026-01-21T18:59:59Z | WILLIAM | — | PAYNE | 07/04/1942 | - | UNKNOWN | — | N/A·· | 6262 Sunset Blvd #599 | Charlotte | North Carolina | 28204-9300 | GRP-0858 | NAVIGATE-HMO |
| TPA | TPA-63454 | 2026-04-15T09:57:43Z | Stephan | — | ·Herrera | 18-05-1951 | ·NULL | UNKNOWN·· | — | N/A | 1373 PARK PLACE | Minneapolis | MN | NULL | UNKNOWN·· | NULL |
| TPA | TPA-57136 | 2026-09-25T19:13:34Z | Chrristian | — | ·Moreno | 05-07-1942 | UHC-86524-23 | - | 5028061704·· | christian.moreno@proton.me | 5524 HIGHLAND AVENUE | Phoenix | AZ | 85089 | NULL | — |
| TPA | TPA-62898 | 2026-08-31T06:57:57Z | ·Fox, Brandon | — | — | Aug 1, 1977 | — | ·· | NULL | NULL | 7835 Meadow Ln | ·Phoenix | AZ | 85092 | - | - |
| TPA | TPA-52215 | 2026-07-27T02:01:48Z | Alan·· | — | ·Aguilar | 1941-11-05 | UHC-72077-72 | •••-••-6116 | ·· | null | 7777 Hillcrest Road | Miami | FL | 33170 | N/A | null |
| TPA | TPA-61880 | 2026-04-11T16:50:43Z | DORIS | ···· | BRADLEY | 01/11/42 | NULL | — | (419) 862-5164 | - | 1142 Palm Drive | AUSTIN | TX | 78771·· | GRP-2202 | — |
| TPA | TPA-60151 | 2026-08-26T06:13:01Z | Tarry | D | Stone·· | 1976-06-03 | — | •••-••-1810 | NULL·· | — | 7619 Ridge Road #100 | Charlotte | ·NC | 28260-5789 | GRP-1866 | NULL |
| TPA | TPA-53647 | 2026-10-16T21:30:41Z | Alice | B | Owens | 1997-06-09 | - | •••-••-7050 | NULL | alice.owens78@yahoo.com | 591 Camelback Road | SEATTLE | WA | 98151 | — | - |
| TPA | TPA-61597 | 2026-02-07T05:28:22Z | Adam | — | Carlson | 19900420 | UHC-39092-80 | — | 707-969-4443 | adam.carlson80@outlook.com | 2767 LAKE VIEW RD | Denver | CO | 80281 | GRP-4644 | MEDICARE-ADV-B |
| TPA | TPA-60212 | 2026-08-09T15:27:46Z | Mark | — | Larson | 1950-10-25 | null | — | (744) 825-5384 | N/A | 4811 PINE DRIVE | Seattle | WA | 98125 | - | UNKNOWN |
| TPA | TPA-61781 | 2026-05-02T01:20:46Z | RALPH | — | JACOBS | 1999-04-07 | N/A | — | UNKNOWN | null | 1278 River Road | Phoenix | AZ | 85090 | N/A | — |
| TPA | TPA-54479 | 2026-02-28T08:57:23Z | Olivia | — | Sanders | 19480406 | null | N/A | - | NULL | 9646 CHURCH ST | Tampa | FL | 33604 | — | NAVIGATE-HMO |
| TPA | TPA-58190 | 2026-06-18T21:37:38Z | Sra | — | Owens | 1958-12-28 | NULL | NULL | — | ·- | 6873 Market St | Phoenix | AZ | 85085 | N/A | MEDICARE-ADV-A |
| TPA | TPA-56489 | 2026-05-08T05:50:50Z | Luis | — | Cruz | Apr 5, 1954 | UHC8262456·· | null | - | UNKNOWN | 1564 GRAND AVE | Nashville | TN | 37283-6136 | GRP-2676 | SELECT-EPO |
| TPA | TPA-51012 | 2026-06-18T05:02:10Z | PAMELA | — | JENSEN | ·1984-10-04 | — | — | (634) 477-5907 | — | UNKNOWN | UNKNOWN | — | — | — | NULL |
| TPA | TPA-63409 | 2026-09-17T04:06:30Z | Diaz | — | Kelly | ·1996-08-11 | — | NULL·· | 2416917221 | kelly.diaz9@outlook.com | 5998 MESA DR | Austin | TX | 78785 | GRP-1589 | — |
| TPA | TPA-61183 | 2026-06-04T04:55:04Z | Ana | — | Fernandez | 1968-02-05 | - | null | — | N/A | 5819 HILLCREST ROAD | FRESNO | CA | 93789 | UNKNOWN | UNKNOWN |
| TPA | TPA-50028 | 2026-10-09T20:06:29Z | Fatima | — | Lynnch | 2001-08-22 | — | - | — | — | 7675 Harbor Boulevard | COLUMBUS | Ohio | 43200 | — | - |
| TPA | TPA-55388 | 2026-04-01T20:40:03Z | Jennifer | ···· | Le | 1952-03-04 | - | •••-••-9377 | N/A | — | — | N/A | NULL | N/A·· | GRP-8354 | - |
| TPA | TPA-61002 | 2026-02-07T14:06:11Z | Angela | — | Carpenter | 1990-07-20 | uhc-21076-40 | •••-••-9200 | - | N/A | 4829 Jefferson Ave | Austin | TX | 78752 | — | UNKNOWN |
| TPA | TPA-51637 | 2026-06-05T17:24:52Z | DEBRA | — | FERNANDEZ | 1970-12-20 | - | — | +1 726 442 0692 | debra.fernandez@outlook.com·· | 9207 River Road | Austin | TX | 78722·· | N/A | SELECT-EPO |
| TPA | TPA-64306 | 2026-05-20T18:20:16Z | Justin | L | Cruz | 1944-09-18 | NULL | — | — | ·justin.cruz@icloud.com | 2917 Ridge Rd | San Antonio | TX | 78273 | - | — |
| TPA | TPA-60920 | 2026-08-10T10:38:55Z | Daniel | — | Elliott | 11-12-1941 | NULL | •••-••-2020 | N/A | — | 4953 Washington St | Eden Prairie | Minnesota | 55370 | NULL | ·MEDICARE-ADV-A |
| TPA | TPA-53523 | 2026-05-24T15:59:00Z | Kate | ·· | ·Frod | 1939-07-16 | UHC1111953 | — | ·null | null | 9302 Main St | Tucson | AZ | 85720 | ···· | NULL |
| TPA | TPA-55795 | 2026-06-09T07:04:35Z | doothy | — | valdez | Feb 6, 1990 | UHC-33215-14 | NULL | — | — | — | — | UNKNOWN | null | NULL | CORE-HMO |
| TPA | TPA-63527 | 2026-10-12T18:38:40Z | Rachel | — | Meyer | ·1999-08-10 | UHC-39130-61 | — | 877-900-4809 | RACHEL.MEYER@GMAIL.COM | 8031 Valley View Dr | Jacksonville | ·FL | 32247 | NULL | — |
| TPA | TPA-62842 | 2026-10-06T07:31:12Z | Arjun | — | Hudson | 1999-04-14 | UHC-69955-67 | •••-••-5127 | -·· | arjun.hudson@aol.com | 4237 SUNSET BLVD | Gilbert | AZ | 85297 | UNKNOWN·· | NULL |
| TPA | TPA-54753 | 2026-07-16T23:00:26Z | Lane, Eric | — | — | 1948-11-21 | UNKNOWN | •••-••-2669 | 5986373246 | null | 1483 Meadow Ln | Fresno | CA | 93756 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-53539 | 2026-09-14T17:38:33Z | ANGELA | — | SALAZAR | 1979-06-05 | - | - | ·699.641.2968 | N/A·· | 5809 Mountain View Dr | MINNEAPOLIS | MN | 55406-1289 | - | — |
| TPA | TPA-62608 | 2026-03-09T00:01:12Z | mei | — | olson | 09/21/1956 | UHC-06921-33 | •••-••-4543 | (554) 773-8539 | NULL | 6886 Pine Dr #534 | Sacramento | CA | 95863 | UNKNOWN | — |
| TPA | TPA-60471 | 2026-10-01T03:47:57Z | EVELYN | — | HANSEN | 19710508 | NULL | — | — | NULL | 3438 LAKE VIEW ROAD·· | Las Vegas·· | NV | 89115 | GRP-8167 | null |
| TPA | TPA-58531 | 2026-03-07T01:35:24Z | Keith | — | Cole | 19501104 | UHC-98804-07 | •••-••-6861 | — | KEITH.COLE@PROTON.ME | 4613 Grand Ave | SAN ANTONIO | TX | 78255 | UNKNOWN | — |
| TPA | TPA-50058 | 2026-01-28T05:13:02Z | Vincent | — | Ruiz | 2005-09-28 | ···· | — | 17193792334·· | N/A | 3625 Church St | Orlando | FL | 32803 | GRP-9465 | — |
| TPA | TPA-61977 | 2026-04-17T14:43:35Z | Jezse | — | Russell | Apr 14, 1983 | UNKNOWN·· | — | — | jesse.russell77@gmail.com | 8446 Camelback Road | PHOENIX | AZ | 85088 | GRP-9470 | NAVIGATE-HMO |
| TPA | TPA-55094 | 2026-01-06T14:08:27Z | Harrison, Alice | — | — | 08-04-1996·· | null | •••-••-4814 | — | — | — | null | N/A | null | - | OPTIONS-PPO |
| TPA | TPA-55409 | 2026-01-10T15:34:47Z | Thomas | — | Richards | 1945-02-21 | — | N/A | - | - | 4221 Oak Street | LAS VEGAS | NV | 89129-1560 | null | null |
| TPA | TPA-57675 | 2026-08-02T15:24:00Z | Rachel | N. | Evans | 1992-12-22 | — | — | (649) 835-6296 | — | 6573 Grand Ave | Eden Prairie | MN | UNKNOWN | GRP-3050 | 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:40.632Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty