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-51044 | 2026-02-11T17:46:04Z | sandra | — | smith | 1967-08-12 | NULL | UNKNOWN | N/A | N/A·· | ·2812 MAPLE AVENUE | Denver | CO·· | 80280 | GRP-5088 | — |
| TPA | TPA-57792 | 2026-09-05T02:36:49Z | Raymond | ·· | Richards | 20040217 | — | ···· | 6152665615 | — | — | — | — | UNKNOWN | GRP-7888 | UNKNOWN |
| TPA | TPA-60653 | 2026-07-31T20:28:51Z | ·Henry | — | Delgao·· | 05/26/1981 | UNKNOWN | NULL | NULL | — | 5525 Oak Street | Minneapolis | MN | 55456 | — | MEDICARE-ADV-A |
| TPA | TPA-61060 | 2026-08-19T05:15:22Z | Elijah | ·· | Williams | 1959-10-23 | null·· | •••-••-0416 | 5933260049 | null | — | — | - | null | UNKNOWN | — |
| TPA | TPA-53815 | 2026-08-17T22:16:59Z | Nathan | — | Bennett·· | 1952-12-14 | ·N/A | - | 9715566125 | — | 2690 Lincoln Way | Denver·· | CO | N/A | null | MEDICARE-ADV-A |
| TPA | TPA-60238 | 2026-09-03T20:16:50Z | Davis, Aisha | U | — | 1941-09-24 | UHC-53783-77 | — | NULL | null·· | 7376 Broadway | Orlando | FL | NULL | — | ·NULL |
| TPA | TPA-50390 | 2026-09-02T20:11:09Z | Donald | — | Morrison | 1970-11-26 | — | NULL | ·null | - | 6285 PARK PLACE | Denver | CO | 80283 | GRP-7842 | — |
| TPA | TPA-60099 | 2026-02-18T18:02:46Z | Jeff | — | Payne | 1966-11-15 | — | — | - | UNKNOWN | 8073 Lake View Road | Tempe | AZ | 85256 | N/A | null |
| TPA | TPA-51325 | 2026-04-16T16:37:23Z | Richard | — | Andrews | 18-08-1990 | - | ·NULL | null | richard.andrews3@yahoo.com | 5035 Pine Drive | GLENDALE | AZ | 85337 | — | NULL |
| TPA | TPA-56003 | 2026-04-10T14:47:03Z | jerry | — | phillips | 19591023 | — | N/A | — | - | NULL | - | — | — | GRP-4457 | CHOICE-PLUS-PPO |
| TPA | TPA-51397 | 2026-04-08T13:15:01Z | RACHEL | — | WASHINGTON | 19651102 | null | UNKNOWN | (564) 474-5667 | — | 7169 Broadway | Glendale | AZ | ·NULL | NULL | null |
| TPA | TPA-62162 | 2026-07-22T02:50:43Z | Christina·· | — | Henry | 7/1/1959 | null | •••-••-9380 | 3152998014 | CHRISTINA.HENRY@OUTLOOK.COM | 2414 Ocean Avenue | Glendale | AZ | 85300 | — | SELECT-EPO |
| TPA | TPA-61859 | 2026-04-06T21:41:42Z | Paul | — | Bailey | 1944-02-13 | — | •••-••-6166 | — | NULL | 8032 Church Street | MESA | AZ | 85208 | — | null |
| TPA | TPA-52362 | 2026-06-13T21:58:38Z | ·Billy | ···· | ·OBrien | 1985-09-16 | ·null | — | (794) 261-8321 | null | ·4827 Meadow Ln | Tucson | AZ | 85782 | GRP-3551 | MEDICARE-ADV-B |
| TPA | TPA-60073 | 2026-10-06T15:11:36Z | Ross | H | Benjamin | 1945-12-11 | — | ·NULL | — | BENJAMIN.ROSS@OUTLOOK.COM | ···· | N/A | — | UNKNOWN | - | MEDICARE-ADV-A |
| TPA | TPA-51385 | 2026-03-18T23:33:04Z | Henry | T | Bishop | 1969-11-06 | UNKNOWN·· | null | UNKNOWN | - | 1886 CHURCH STREET | Atlanta | Georgia | — | NULL | — |
| TPA | TPA-55092 | 2026-03-29T17:14:21Z | Elizabeth | — | Crawford | 07/18/02 | NULL·· | UNKNOWN | +1 611 353 1127 | elizabeth.crawford26@gmail.com | 6310 HILLCREST RD | Houston | TX | NULL | GRP-1340 | — |
| TPA | TPA-53369 | 2026-05-20T17:22:48Z | Peter | — | Kelly | Jul 9, 1981 | ·UHC-28833-25 | - | null | N/A | 8295 Mountain View Drive | Las Vegas | NV | 89106 | NULL | OPTIONS-PPO |
| TPA | TPA-55143 | 2026-05-05T01:16:06Z | alice | — | reed | 1960-03-07 | — | — | — | — | 8551 Park Pl | Tucson | AZ | 85740 | NULL | — |
| TPA | TPA-53292 | 2026-08-31T16:58:44Z | Daniel | — | Le | 1973-04-26 | UNKNOWN | UNKNOWN | — | UNKNOWN | — | - | — | null | ·GRP-3481 | null |
| TPA | TPA-57438 | 2026-03-25T21:28:27Z | Brenda | — | Ortiz | 5/20/1973 | UHC-96228-35 | — | — | brenda.ortiz@proton.me | 4107 PALM DRIVE | Fresno | CA | 93701 | GRP-9741 | CORE-HMO |
| TPA | TPA-54436 | 2026-02-20T19:21:43Z | Oliver, Dylan | — | — | 01/17/58 | N/A | — | — | N/A | UNKNOWN | N/A | NULL | - | GRP-9860 | CHOICE-PLUS-PPO |
| TPA | TPA-62705 | 2026-06-28T17:13:48Z | Debra | — | Lane | 1964-09-16 | ·UHC-47729-91 | •••-••-0592 | 4969140218 | null | 8702 Sage Ct | Miami | FL | 33167 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-51948 | 2026-05-16T13:12:09Z | Jesse | ···· | Santos | 1981-06-19 | UNKNOWN | N/A | — | ···· | ·8431 PALM DRIVE | Phoenix | az | 85086 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-52612 | 2026-04-02T01:34:57Z | Hunt | — | Stephanie | 1938-10-16 | ···· | UNKNOWN | (456) 202-0786·· | NULL | 1688 Grand Ave | San Diego | CA | - | GRP-6011 | null |
| TPA | TPA-62636 | 2026-02-05T15:34:48Z | ·Ana | — | Carr | 1981-08-17 | null | UNKNOWN | 5898373919 | - | 3689 PINE DRIVE | Los Angeles | CA·· | 90074 | NULL | — |
| TPA | TPA-51977 | 2026-01-30T16:28:05Z | john | ···· | west | 1938-01-22 | N/A | •••-••-1810 | 17749919668 | UNKNOWN·· | 8348 Market St | Austin·· | TX | 78748 | GRP-0838 | — |
| TPA | TPA-57267 | 2026-08-07T13:26:55Z | MARTHA | — | HAWINS | 2004-12-04 | NULL | — | — | NULL | 3240 Baseline Rd | Houston | TX·· | ·77021 | GRP-1714 | CORE-HMO |
| TPA | TPA-50908 | 2026-03-15T13:51:40Z | Porter, Danielle | U. | — | 8/16/1946 | UHC-05123-51 | •••-••-0823 | 6659659857 | NULL | 4668 APACHE BOULEVARD | LAS VEGAS | NV | 89173 | GRP-2986 | — |
| TPA | TPA-51413 | 2026-06-11T05:12:12Z | Morrison, Jesse | — | — | 1941-12-22 | - | N/A | null | JESSE.MORRISON@HOTMAIL.COM | ·1714 Bayshore Drive | CHARLOTTE | North Carolina | 28236-9928 | GRP-6587 | — |
| TPA | TPA-50310 | 2026-09-10T03:15:46Z | Carolyn | — | Jones | 1975-12-23 | - | — | N/A | CAROLYN.JONES62@YAHOO.COM | ·6889 Elm Street | Mesa | AZ·· | 85223 | — | N/A |
| TPA | TPA-56020 | 2026-05-27T18:24:24Z | ·Samantha | — | Diaz | 19980823 | N/A | ···· | ·· | NULL | 1859 Meadow Lane | TUCSON | az | 85789 | — | MEDICARE-ADV-A |
| TPA | TPA-63247 | 2026-02-15T04:15:44Z | Knight, Denise | — | — | 20050302 | - | UNKNOWN | — | denise.knight2@outlook.com | 7847 Central Ave | San Antonio | TX | 78282 | UNKNOWN | NULL |
| TPA | TPA-53296 | 2026-03-21T15:47:28Z | DENNIS | — | SANTOS | 1998-09-18·· | - | - | N/A | dennis.santos@proton.me | 2748 SAGE CT | Tucson | AZ | 85743 | — | null |
| TPA | TPA-63210 | 2026-06-12T16:10:53Z | SHIRLAY | — | BOWMAN | 11/14/08 | — | NULL | NULL | — | 2368 Spring St | Columbus | OH | 43267 | GRP-2162 | — |
| TPA | TPA-56905 | 2026-01-25T03:30:34Z | JERRY | — | BROOKS | 2006-11-13 | - | - | - | — | ·9445 Market Street | Glendale | Arizona | 85372 | — | — |
| TPA | TPA-62728 | 2026-04-20T14:18:49Z | DYLAN | — | LYNCH | 1999-03-16 | UNKNOWN | •••-••-8535 | UNKNOWN | - | 5219 BASELINE ROAD | ORLANDO | FL | 32866 | — | — |
| TPA | TPA-58201 | 2026-04-11T19:31:24Z | Charles | Y | Armstrong·· | 19980913 | null·· | — | ···· | — | 5832 Grand Avenue | SEATTLE | WA | 98104 | — | - |
| TPA | TPA-56866 | 2026-06-14T14:18:41Z | KIMBERLY | — | ·HARVEY | 1986-05-25 | — | — | 5593519059 | UNKNOWN | — | — | N/A | NULL | N/A | CHOICE-PLUS-PPO |
| TPA | TPA-63209 | 2026-08-07T04:16:22Z | ·willie | — | harper | 1980-12-06 | — | •••-••-7013 | — | - | 426 Desert Sky Blvd | HOUSTON | TX | 77019 | ···· | SELECT-EPO |
| TPA | TPA-57815 | 2026-06-04T06:05:12Z | Noah | — | Rogers | 1958-04-08 | — | ·null | (882) 423-5999 | N/A | NULL | N/A | - | - | — | OPTIONS-PPO |
| TPA | TPA-53096 | 2026-05-28T03:29:49Z | CHRISTOPHER | — | DUNCAN | 2003-06-26 | — | - | 870.588.9502 | NULL | — | UNKNOWN | NULL | — | — | N/A |
| TPA | TPA-55224 | 2026-06-16T15:51:11Z | Johhn | — | Sanders | 1999-07-08 | NULL | — | NULL | — | 7846 Mountain View Dr | Plano | TX | 75075 | - | UNKNOWN |
| TPA | TPA-60006 | 2026-07-27T07:26:03Z | SHARON | — | ·GARZA | 1994-02-05 | — | •••-••-2454 | 4454233349 | - | 9247 Highland Avenue | COLUMBUS | Ohio | 43298 | N/A | MEDICARE-ADV-A |
| TPA | TPA-55228 | 2026-04-25T05:40:22Z | GARZA | — | NATALIE | 1984-06-04 | UHC-86293-53 | UNKNOWN | (512) 698-7446 | natalie.garza@outlook.com | 6728 Elm St | Austin | TX | 78794-5917 | GRP-8916 | — |
| TPA | TPA-63483 | 2026-08-03T05:47:47Z | Rachel | — | Turner | ·03-04-1990 | UNKNOWN | •••-••-2949 | ·N/A | - | 3221 Central Ave | Phoenix | AZ | 85069 | — | NULL |
| TPA | TPA-62191 | 2026-02-08T00:40:44Z | SEAN | C. | CUNNINGHAM | Mar 27, 1976 | NULL | UNKNOWN | 17413625672 | null | 9346 Cedar Ln | EDEN PRAIRIE·· | MN | 55308-0835 | — | - |
| TPA | TPA-53307 | 2026-08-19T00:55:09Z | DIANA | X | MURPHY | 1963-09-13 | — | NULL | (763) 528-5128 | DIANA.MURPHY7@YAHOO.COM | 800 Market Street | Mesa | AZ | 85260 | GRP-7521 | MEDICARE-ADV-A·· |
| TPA | TPA-59329 | 2026-09-15T08:08:29Z | Price, Steven | R | — | 1939-01-16·· | UNKNOWN | UNKNOWN | (806) 404-8558 | — | 2043 Grand Avenue | Houston | tx | 77062 | UNKNOWN | - |
| TPA | TPA-59539 | 2026-01-19T22:05:08Z | Larry | — | Simpson | Jan 25, 1973·· | UHC-81950-28 | •••-••-9850 | - | — | 406 Lincoln Way·· | Charlotte | NC | 28235 | — | SELECT-EPO |
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:49.107Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty