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-63449 | 2026-06-13T20:37:02Z | Phillips, Ralph | — | — | 1983-08-09 | - | — | — | — | 6178 PARK PLACE·· | Austin | TX | ·78712 | UNKNOWN | — |
| TPA | TPA-53757 | 2026-09-11T19:14:32Z | larry | — | payne | 1969-07-14 | null | — | (648) 342-6301 | — | 2134 PINE DRIVE | Sacramento | CA | 95849 | GRP-7825 | null |
| TPA | TPA-64294 | 2026-08-26T13:41:10Z | ALAN | — | ESTRADA | 19810101 | N/A | NULL | — | null·· | 7463 CANYON ROAD | DALLAS | TX | - | — | null |
| TPA | TPA-58981 | 2026-07-13T07:04:10Z | Camila | — | ·Miller | 1956-04-10 | - | — | — | N/A | 9117 Willow Ct | Tucson·· | AZ | 85727 | GRP-5287 | UNKNOWN |
| TPA | TPA-56854 | 2026-09-16T12:28:56Z | Susan | — | Padilla | 06/25/1952 | UNKNOWN | •••-••-1359 | 404-216-1177 | NULL | 7190 SUNSET BLVD | Glendale | AZ | — | — | — |
| TPA | TPA-58364 | 2026-04-27T21:53:17Z | Amy | — | Riley | Mar 5, 1957 | NULL | — | — | NULL | 4668 Jefferson Ave | Seattle | WA | 98123 | null | ·NULL |
| TPA | TPA-57117 | 2026-02-13T04:22:05Z | STEVEN | — | YOUNG | 1950-05-13 | — | — | N/A | NULL | 6301 OCEAN AVE | Las Vegas | NV | 89102-1745 | — | ·· |
| TPA | TPA-60579 | 2026-03-20T08:12:25Z | JERRY | — | SILVA | 1958-10-15 | null | - | - | NULL | 8957 CAMELBACK ROAD | CHANDLER·· | AZ | 85243 | — | — |
| TPA | TPA-63360 | 2026-08-04T03:20:12Z | RYAN | — | ·HANSEN | 1974-02-25 | ·UHC-08451-93 | — | +1 461 690 8946 | RYAN.HANSEN@YAHOO.COM | 871 Meadow Lane | San Antonio | TX | 78250-2438 | N/A | MEDICARE-ADV-B |
| TPA | TPA-54690 | 2026-01-17T15:39:35Z | ZACHARY | — | FRANKLIN | 1940-06-23 | N/A | N/A·· | null | zachary.franklin71@icloud.com | - | ·N/A | null | — | — | null |
| TPA | TPA-54406 | 2026-04-24T10:58:06Z | Sarah | — | Campbell | 1945-02-09 | ·null | — | 5063846435 | sarah.campbell@proton.me | — | — | N/A | — | null | null·· |
| TPA | TPA-63707 | 2026-07-06T11:28:18Z | sandra·· | — | cunningham | 1962-04-13 | - | NULL | - | - | 2627 Jefferson Ave #820 | LOS ANGELES·· | CA | 90069 | GRP-1459 | — |
| TPA | TPA-56529 | 2026-08-21T19:25:46Z | PRIYA | ·· | EDWARDS | 1999-07-14 | ·N/A | NULL | UNKNOWN | NULL | 2881 Bayshore Drive | San Antonio | TX·· | 78280-8887 | — | -·· |
| TPA | TPA-62841 | 2026-03-23T04:11:58Z | Tom | I | Cruz | 1998-03-20 | UHC-85435-68 | null | UNKNOWN | THOMAS.CRUZ@GMAIL.COM | 5054 Main Street | ·PHOENIX | AZ | 85085 | null | - |
| TPA | TPA-63624 | 2026-01-09T08:53:58Z | Wheeler, Pamela | — | — | 1971-02-19 | N/A | — | UNKNOWN | N/A | - | UNKNOWN | - | — | GRP-4531 | options-ppo |
| TPA | TPA-52971 | 2026-06-09T18:27:48Z | Bruce | — | Robinson | 1945-08-13 | — | NULL | 7333020034 | - | 2956 Spring Street | Charlotte | NC | 28208 | GRP-6887 | — |
| TPA | TPA-61466 | 2026-10-08T00:15:23Z | Donald | S. | ·Peters | ·1960-07-18 | UHC-55654-50 | — | NULL | N/A | - | — | — | — | GRP-3387 | MEDICARE-ADV-A |
| TPA | TPA-55301 | 2026-01-12T07:58:36Z | Timothy | — | Young | 1949-07-22 | null | •••-••-2768 | 800-671-4748 | — | 2331 Jefferson Ave #257 | Tampa | FL | 33656 | — | null |
| TPA | TPA-61824 | 2026-06-27T23:39:39Z | Shaw, Pamela | — | — | 1999-12-17 | — | •••-••-4344 | 2495146270 | — | 6583 Indian School Road | TAMPA | FL | 33690 | — | null |
| TPA | TPA-63444 | 2026-08-10T23:34:47Z | KAREN | — | AGUILAR | 2007-02-20 | UNKNOWN | •••-••-7881 | 9096220339 | null | 5844 Union St | Sacramento | CA | 95834 | N/A | OPTIONS-PPO |
| TPA | TPA-57384 | 2026-02-20T11:29:59Z | Samuel | — | Montgomery | 1946-10-24 | N/A | •••-••-1727 | — | SAMUEL.MONTGOMERY50@OUTLOOK.COM | 1004 Pine Drive | Sacramento | ca | 95879 | N/A | NULL |
| TPA | TPA-63544 | 2026-08-02T11:41:39Z | Lisa | — | Watkins | 2004-11-03 | — | •••-••-4975 | — | UNKNOWN | 7669 Central Ave | San Antonio | Texas | 78246 | NULL | — |
| TPA | TPA-61027 | 2026-01-09T02:28:56Z | ·JASON | — | WILLIS | ·Apr 20, 1938 | null | •••-••-4507 | 7248061970 | — | 684 Baseline Road | Orlando | Florida | 32812 | N/A | - |
| TPA | TPA-60845 | 2026-04-14T03:19:25Z | Perry, Ashley | — | — | 1968-03-26 | UHC-37171-05 | •••-••-2991 | (257) 436-5078 | null | 697 Park Pl | Fresno | California | null | GRP-3830 | MEDICARE-ADV-B |
| TPA | TPA-55502 | 2026-07-31T07:46:26Z | priya | — | sanchez | 1999-09-05 | UNKNOWN | N/A | — | - | 8031 Jefferson Avenue | Los Angeles | ca·· | 90012 | — | NULL |
| TPA | TPA-60431 | 2026-07-09T19:48:42Z | Sam | — | Collins | 1943-03-02 | ·· | UNKNOWN | 721-760-8699 | samuel.collins@outlook.com | 3152 Valley View Dr | Charlotte | ·NC | 28264 | GRP-0334 | ···· |
| TPA | TPA-57160 | 2026-09-04T10:36:45Z | sandra | — | ortega | 1980-12-26 | N/A | •••-••-2646 | N/A | - | 7314 Hillcrest Rd | Tucson | AZ | 85779 | — | MEDICARE-ADV-B |
| TPA | TPA-55547 | 2026-05-31T10:28:26Z | ROY | — | HART | 1938-02-10 | — | •••-••-3253 | N/A | ·· | 241 Forest Avenue | San Antonio | TX | 78202 | — | MEDICARE-ADV-A |
| TPA | TPA-54109 | 2026-09-28T04:30:22Z | ·Douglas | — | Robinson | 11/27/1974 | NULL | NULL | UNKNOWN | — | 9031 Apache Blvd | Nashville | TN | 37242 | GRP-2881 | MEDICARE-ADV-B |
| TPA | TPA-50069 | 2026-07-15T20:27:41Z | Ruth | — | Ferguson | 1945-10-09 | null | null·· | — | ruth.ferguson@yahoo.com | 9177 Jefferson Avenue | Mesa | Arizona | NULL | null | CORE-HMO |
| TPA | TPA-57987 | 2026-01-01T17:53:18Z | EDWARD | ·· | FOWLER | 2006-03-17 | UNKNOWN | •••-••-7358 | — | — | 630 LINCOLN WAY | Glendale | AZ | 85356 | — | N/A |
| TPA | TPA-64094 | 2026-09-22T02:55:42Z | Michael | — | Garrett | 2003-11-10 | null | N/A | +1 419 682 7958 | — | ·N/A | null | NULL | - | GRP-6106 | - |
| TPA | TPA-58091 | 2026-08-02T05:49:59Z | Hart, Gary | — | — | 1983-01-04 | NULL | NULL | ·· | N/A | 5166 Ridge Rd | Mesa | Arizona | 85272 | N/A | MEDICARE-ADV-B |
| TPA | TPA-57951 | 2026-05-20T20:56:24Z | Kenneth | Q | Fowler | 05/09/1989 | ···· | UNKNOWN | — | ···· | 821 Bayshore Dr | Seattle | WA·· | 98134 | — | ···· |
| TPA | TPA-60433 | 2026-04-01T20:42:37Z | Debra | — | Hall | 04/06/1943 | null·· | null | — | UNKNOWN | ·UNKNOWN | null | N/A | ·null | GRP-4456 | SELECT-EPO |
| TPA | TPA-57736 | 2026-01-01T08:13:00Z | NICHOLAS | — | BROOKS | ·1982-04-20 | UNKNOWN | — | - | nicholas.brooks@icloud.com | 9470 BAYSHORE DRIVE | Fresno | CA | 93760 | - | - |
| TPA | TPA-57237 | 2026-06-28T12:36:40Z | Judith | — | OBrien | 1942-09-19 | UHC6023299 | null | N/A·· | judith.obrien@aol.com | 3631 Highland Avenue | Tempe | AZ | ·85233 | — | ·MEDICARE-ADV-A |
| TPA | TPA-57033 | 2026-09-26T15:22:50Z | Webb, Cynthia | — | — | 1953-08-22 | null | NULL | — | null | 4802 Hillcrest Rd | SCOTTSDALE | AZ | null | GRP-6575 | NULL |
| TPA | TPA-56551 | 2026-01-01T14:44:04Z | Randy | B | ·Meyer | 1984-07-26 | UHC3929388 | UNKNOWN | 7072619905 | — | 2773 MOUNTAIN VIEW DRIVE | Tucson | az | ·85753-2859 | ·- | null |
| TPA | TPA-56187 | 2026-04-24T14:28:46Z | Rios, Keith | — | — | ·08/24/62 | - | NULL | (804) 752-6055 | KEITH.RIOS@OUTLOOK.COM | 1341 Cedar Ln | Glendale | AZ | 85343 | ···· | OPTIONS-PPO |
| TPA | TPA-59810 | 2026-06-27T16:25:58Z | JOHN | — | GORDON | ·Jan 22, 1958 | NULL | — | — | N/A | 5838 Ridge Rd | Minneapolis | mn | 55403 | — | — |
| TPA | TPA-62068 | 2026-06-11T08:45:42Z | HENRY | — | ·MILLER | 1973-10-09 | UHC-88772-03 | null | (340) 277-7216 | NULL | 5855 Ocean Avenue | Plano | TX | 75010 | N/A | - |
| TPA | TPA-55025 | 2026-09-14T10:57:35Z | ·Wei | — | Hanson | 1956-02-20 | — | — | +1 576 301 9804 | NULL | 7792 Spring St #509 | Nashville | TN | 37238 | null | null |
| TPA | TPA-55978 | 2026-04-08T00:08:35Z | Heather, Ramirez | — | — | 1985-09-07 | null | - | N/A | — | 3843 MAIN STREET Apt 18 | Plano | TX | 75050 | GRP-7768 | null |
| TPA | TPA-63301 | 2026-05-16T15:25:06Z | Zachary | — | Harvy | 1982-02-22 | UHC-43673-22 | - | — | UNKNOWN | 7636 Canyon Road | Miami | FL | 33176 | GRP-3992 | ·· |
| TPA | TPA-59307 | 2026-01-20T19:20:40Z | Diaz, Frances | — | — | Nov 19, 1972 | UNKNOWN | •••-••-6499 | — | — | ·5477 Hillcrest Rd | Houston | Texas | 77071-3394 | GRP-0739 | ·null |
| TPA | TPA-52781 | 2026-06-26T07:38:39Z | Lori | — | ·Griffin | 1968-10-22 | UHC-27335-85 | •••-••-7876 | (352) 984-1178 | — | ·3594 Valley View Dr | Houston | TX | 77059 | - | — |
| TPA | TPA-63863 | 2026-06-02T08:58:30Z | ALBERT | — | HOWARD | 2004-09-11 | — | •••-••-3525 | 242-643-8010 | null | N/A | — | NULL | N/A | GRP-2162 | N/A |
| TPA | TPA-50385 | 2026-10-07T16:55:28Z | OBrien, Crl | — | ···· | Oct 12, 1976 | null | — | - | null | NULL | UNKNOWN·· | null | UNKNOWN | — | — |
| TPA | TPA-62393 | 2026-07-03T20:46:24Z | Evelyn, Black | ·· | — | 19531002 | — | N/A | N/A | UNKNOWN | 8411 Union St | Columbus | OH | 43228-9302 | N/A·· | MEDICARE-ADV-A |
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:37.725Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty