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-60202 | 2026-04-05T23:28:43Z | ·KIMBERLY | — | CHAPMAN | 1980-11-22 | — | — | 425-892-9299 | — | 3546 Meadow Ln | Mesa | AZ | 85213 | NULL | medicare-adv-b |
| TPA | TPA-57343 | 2026-02-02T12:15:00Z | Melissa | — | Holmes | 1950-12-25·· | — | •••-••-0491 | — | ·· | 7566 Spring Street #263 | San Antonio | TX | UNKNOWN | - | ·· |
| TPA | TPA-62149 | 2026-04-20T12:46:27Z | ERIC | I. | ·SCHMIDT | 05/04/05 | NULL | N/A | — | — | 311 Meadow Ln | Mesa | AZ | UNKNOWN | N/A | SELECT-EPO |
| TPA | TPA-57414 | 2026-06-29T14:45:58Z | MATTHEW | — | WATKINS | Mar 2, 2009 | - | ·NULL | N/A | NULL | 3179 Baseline Rd | JACKSONVILLE | FL | 32231 | GRP-5868 | ·· |
| TPA | TPA-62638 | 2026-10-10T13:40:15Z | Sara | — | Evans | 1998-10-06 | — | •••-••-1644 | — | - | 2141 UNION STREET | Charlotte | NC | 28242·· | — | — |
| TPA | TPA-59066 | 2026-08-16T11:24:10Z | Ralph | ···· | Nichols | 6/14/1962 | UNKNOWN | NULL | NULL | ralph.nichols60@outlook.com | 5689 Lincoln Way | ·Chandler | ·AZ | 85269 | NULL | NULL |
| TPA | TPA-58903 | 2026-08-15T04:37:16Z | Susan | — | Ross | 1983-01-02 | — | — | ·N/A | — | 5344 Mountain View Drive·· | Houston | TX | 77096 | GRP-3191 | — |
| TPA | TPA-51320 | 2026-04-17T19:30:39Z | ·Kimberly | — | Parker | 2002-12-14 | — | •••-••-0955 | ·(881) 676-8176 | — | 7164 Elm St | CHANDLER | AZ | 85227 | null | null·· |
| TPA | TPA-53470 | 2026-08-31T21:24:13Z | Alan | U. | Patterson | 2007-11-15 | — | UNKNOWN | ·18663359802 | — | 5417 Baseline Road | Seattle | WA | 98140 | GRP-0728 | MEDICARE-ADV-A·· |
| TPA | TPA-63175 | 2026-08-18T12:23:53Z | JAKE·· | — | MARQUEZ | 1945-06-08 | ·UHC-72121-60 | — | - | jacob.marquez@outlook.com | 8943 MARKET ST | Columbus | Ohio | 43293 | GRP-7989 | UNKNOWN |
| TPA | TPA-58433 | 2026-06-08T01:43:06Z | PATRICIA | — | ALLEN | 2002-08-27 | — | •••-••-4516 | — | ·patricia.allen@gmail.com | 2191 Cedar Ln | CHARLOTTE | NC | 28254 | GRP-9729 | CORE-HMO |
| TPA | TPA-60921 | 2026-06-13T09:54:41Z | DOUGLAS | — | SANTOS | 1976-05-26 | null | — | - | — | N/A | null | — | — | N/A | null |
| TPA | TPA-64263 | 2026-01-28T03:03:57Z | ·Cheryl | — | OBrien | 1938-08-14 | UHC-58364-11 | •••-••-2112 | NULL | — | 7836 Union Street | Chandler·· | AZ | 85253 | - | N/A |
| TPA | TPA-53160 | 2026-05-12T16:03:57Z | alan | W | lynch·· | 1971-03-12 | UHC-94055-27 | N/A | — | UNKNOWN | 1005 DESERT SKY BOULEVARD | Orlando | FL | 32837 | ·· | — |
| TPA | TPA-58815 | 2026-07-09T18:24:39Z | Jeremy | A | Roberts | 1994-12-02 | UNKNOWN | •••-••-6376 | — | NULL | 9863 Sage Court | Columbus | oh | null | UNKNOWN | N/A |
| TPA | TPA-59510 | 2026-01-31T13:28:12Z | MELISSA | — | ROBERTS | 2003-02-12 | N/A | — | N/A | UNKNOWN | 4456 Sage Court | Fresno | CA | 93791 | — | NULL |
| TPA | TPA-56663 | 2026-06-19T11:56:44Z | Madison·· | M | Cole·· | 1952-05-22·· | — | UNKNOWN | — | -·· | — | ·null | N/A | NULL | UNKNOWN | N/A |
| TPA | TPA-50904 | 2026-09-12T11:58:20Z | Logan | — | Marshall | 2008-08-25 | — | •••-••-0447 | 404-532-6018 | UNKNOWN | 6646 Sage Ct | Tampa | ·FL | 33684 | — | — |
| TPA | TPA-53409 | 2026-03-05T20:34:03Z | rebecca | X | clark | ·Jun 12, 1990 | — | •••-••-5160 | 940-363-9048 | NULL | 9740 Oak Street | JACKSONVILLE | fl | 32208 | NULL | — |
| TPA | TPA-57468 | 2026-06-02T12:46:24Z | willie | — | harper·· | 2000-09-13 | UNKNOWN | NULL | ·434-850-5661 | - | 750 Central Ave | Gilbert | AZ | 85211 | null | MEDICARE-ADV-B |
| TPA | TPA-50946 | 2026-01-25T15:15:16Z | Heather | — | Valdez | 03/06/1966 | — | •••-••-4980 | UNKNOWN | N/A | 8589 MOUNTAIN VIEW DRIVE | Tampa | FL·· | UNKNOWN | GRP-2416 | — |
| TPA | TPA-50789 | 2026-02-05T18:58:40Z | robert | — | lawrence | 1947-08-14 | — | •••-••-0740 | 304-628-3850 | robert.lawrence84@yahoo.com | 2875 ELM STREET | COLUMBUS | ·OH | 43237 | GRP-8765 | MEDICARE-ADV-A |
| TPA | TPA-60331 | 2026-02-27T16:24:20Z | DAVID | — | WOODS | 1938-05-26 | NULL | •••-••-1067 | 16292712914 | david.woods80@icloud.com | 1578 Union St | Nashville | TN | 37211 | GRP-5364 | — |
| TPA | TPA-55433 | 2026-02-07T15:19:38Z | shirley | — | harris | 1994-07-02 | UNKNOWN | •••-••-5080 | (515) 788-1596 | — | 3593 GRAND AVENUE | Plano | TX | ·75006 | ·GRP-1272 | NULL |
| TPA | TPA-61486 | 2026-05-14T05:02:55Z | christian | — | salazar | ·2005-12-52 | — | ·N/A | 6930370 | — | 6140 ELM STREET | Columbus | OH | 43202 | N/A | — |
| TPA | TPA-56886 | 2026-09-15T02:35:07Z | SUSAN·· | Z | MARTIN | Dec 27, 2006 | UHC-48771-56 | - | — | - | 5676 Central Ave | Seattle | WA | 98103 | — | MEDICARE-ADV-B |
| TPA | TPA-50375 | 2026-07-31T23:05:13Z | Lori | — | Warren·· | 09-12-1976 | null | N/A | 3949103879 | — | 4758 Highland Avenue | Los Angeles | CA | 90065 | GRP-1439 | — |
| TPA | TPA-62323 | 2026-04-10T02:50:36Z | Mary | — | Herrera | 3/20/1973 | ·UHC-96852-32 | •••-••-6708 | +1 829 918 9312 | MARY.HERRERA86@AOL.COM | 7943 Palm Dr | Houston | TX | 77040 | null | OPTIONS-PPO |
| TPA | TPA-58409 | 2026-03-07T08:54:04Z | Nicole | — | Carr | 1960-06-14 | null | NULL | — | ·N/A | 7331 Pine Drive | Phoenix | AZ | 85053 | GRP-6509 | - |
| TPA | TPA-52522 | 2026-07-20T20:48:56Z | Zachary | — | Thompson | 11/22/1973 | UHC-15871-31 | — | — | — | — | N/A | — | UNKNOWN | N/A | null |
| TPA | TPA-52597 | 2026-04-14T03:05:55Z | deborah | — | baker | Jun 22, 1994 | — | UNKNOWN | N/A | DEBORAH.BAKER71@PROTON.ME | N/A | NULL | ·· | UNKNOWN | UNKNOWN | CHOICE-PLUS-PPO |
| TPA | TPA-61642 | 2026-01-27T21:03:43Z | George | — | Turner | 2008-08-15 | — | •••-••-4391 | — | — | 798 Highland Ave | Las Vegas | NV | 89173 | UNKNOWN | N/A |
| TPA | TPA-64087 | 2026-06-17T01:38:10Z | Ann | — | Perez | 08/11/1993 | UNKNOWN | N/A | - | — | 2559 Baseline Rd | Phoenix | AZ | 85046 | N/A | — |
| TPA | TPA-53866 | 2026-04-15T11:34:37Z | ·JACK | C | PIERCE | 15-12-1958 | - | null | — | — | 4710 Jefferson Avenue | Miami | Florida | 33123 | GRP-7737 | MEDICARE-ADV-B |
| TPA | TPA-50324 | 2026-01-11T04:25:11Z | WEI | — | ·HUGHES | 19870727·· | — | ·· | - | NULL·· | ·9840 Maple Ave | Austin | TX | 78785 | GRP-4724 | SELECT-EPO |
| TPA | TPA-58876 | 2026-09-24T20:52:24Z | FRANK | — | LYNCH | 1946-11-05 | NULL | — | NULL | NULL | 3708 APACHE BOULEVARD | Scottsdale | ·AZ | 85215 | UNKNOWN | N/A |
| TPA | TPA-60827 | 2026-03-15T01:21:17Z | Keith | ·· | Varggas | 1955-03-05 | ···· | — | — | UNKNOWN | — | UNKNOWN | ·- | — | UNKNOWN·· | NULL |
| TPA | TPA-55317 | 2026-03-14T04:03:10Z | Elizabeth | — | Munoz | 19460311 | UHC-50406-95 | •••-••-1760 | UNKNOWN | elizabeth.munoz@outlook.com | 4796 SPRING STREET | Columbus | ·OH | - | N/A | — |
| TPA | TPA-61539 | 2026-04-22T16:10:12Z | RUSSELL | — | MALDONADO | 1947-12-10·· | — | NULL | 2859137369 | N/A | 6230 RIVER RD | Eden Prairie | MN | 55330 | null | - |
| TPA | TPA-51481 | 2026-02-04T14:44:59Z | Mariana | ·· | Webb | ·1959-07-07 | UHC-20825-98 | — | NULL | N/A | 9040 CANYON ROAD | Houston | TX | 77026 | null | N/A |
| TPA | TPA-58513 | 2026-02-05T21:58:41Z | MELISSA | — | MCDONALD | 2001-06-20 | UHC-49869-26 | - | 461-932-7306 | null | 4944 Pine Dr | Los Angeles | CA | 90076 | ·GRP-4429 | NULL |
| TPA | TPA-61845 | 2026-01-06T06:29:17Z | garcia | — | priya | 1967-07-19 | UNKNOWN | •••-••-7437 | -·· | — | 2276 BROADWAY | Dallas·· | TX | 75216 | N/A | MEDICARE-ADV-B |
| TPA | TPA-54340 | 2026-02-01T17:20:18Z | Mason | — | Gonzalez | 03/11/1992 | — | •••-••-6288 | ·UNKNOWN | — | 720 Pine Dr Apt 35 | Atlanta | GA | — | NULL | UNKNOWN |
| TPA | TPA-52210 | 2026-07-28T20:38:02Z | Mrshall, Bryan | ·· | — | 1959-12-05 | — | ·null | NULL | NULL | ·4458 SPRING STREET | HOUSTON·· | TX | 77077 | NULL | null |
| TPA | TPA-58809 | 2026-05-18T13:12:42Z | MARIA | — | HOLMES | 6/28/1944 | ·N/A | N/A | ···· | — | 3447 DESERT SKY BOULEVARD | Tempe | AZ | 85290 | — | — |
| TPA | TPA-51221 | 2026-08-28T23:25:51Z | Martha | — | Chapman | 1947-11-06 | null | — | +1 564 512 9782 | null | 6938 LINCOLN WAY Apt 5 | Seattle | wa | 98146 | N/A | — |
| TPA | TPA-53087 | 2026-01-22T10:38:31Z | Heather | — | ·Vazquez | Dec 4, 1979 | UHC-76947-93 | — | N/A | null | 5238 HARBOR BOULEVARD | Chandler | AZ | 85258 | — | UNKNOWN |
| TPA | TPA-58026 | 2026-01-08T06:36:52Z | ahmed | I | adams·· | 6012-20-01 | N/A | NULL | null | - | 3121 Union Street | Las Vegas | NV | 89139 | — | ···· |
| TPA | TPA-51034 | 2026-04-20T03:41:23Z | Maria | — | Wilson | 19740417 | UHC-68690-35 | •••-••-8109 | ·- | — | — | NULL | — | — | - | CORE-HMO |
| TPA | TPA-63156 | 2026-08-24T04:17:59Z | Omar·· | — | Gonzalez | 1968-04-12 | UHC-96715-90 | N/A | N/A | null | 7931 FOREST AVENUE | Plano | TX·· | 75052 | — | - |
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:43.602Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty