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-56208 | 2026-08-08T12:55:59Z | Ruszell | — | Le | 1946-09-18 | UNKNOWN | ·- | UNKNOWN | N/A | 509 Central Avenue | Dallas | TX | 75275 | N/A | - |
| TPA | TPA-63856 | 2026-07-27T05:06:30Z | Wong, Jennifer | X | — | 1956-10-21 | — | — | 4244742948 | - | 3291 Sunset Boulevard | Gilbert | AZ | 85259 | N/A | null |
| TPA | TPA-55164 | 2026-01-14T20:16:31Z | Jensen, Laura | — | — | 2003-06-19 | null | — | null | UNKNOWN | 6137 INDIAN SCHOOL ROAD | Sacramento | CA | 95876-3930 | GRP-7730 | ·· |
| TPA | TPA-64312 | 2026-05-08T07:21:46Z | ·Christina | — | Cooer | 1958-05-08 | N/A | NULL | — | ·NULL | 6821 Sage Court | Miami | FL | ·33179 | NULL | - |
| TPA | TPA-58906 | 2026-06-29T14:07:54Z | KATHERINE | — | PATEL | ·1968-05-21 | null | — | ·N/A | — | 4167 Main St | Houston | TX | 77092 | GRP-1194 | null |
| TPA | TPA-58616 | 2026-05-12T14:59:33Z | BRYAN | — | BRADLEY | 1954-07-16 | — | •••-••-3355 | (416) 969-3117 | ·N/A | 9053 Maple Avenue | Tempe | Arizona | 85288·· | N/A | core-hmo |
| TPA | TPA-52955 | 2026-01-07T07:58:50Z | JEAN | — | HANSEN | 19390420 | — | UNKNOWN | — | UNKNOWN | 8068 Spring St | Denver | CO | 80201 | UNKNOWN | UNKNOWN |
| TPA | TPA-55563 | 2026-10-16T01:36:05Z | DOROTHY | — | LAWSON | 1996-03-21 | N/A | •••-••-8311 | 472.621.7370 | NULL | 9381 HARBOR BLVD | Scottsdale | AZ | 85215 | — | — |
| TPA | TPA-58087 | 2026-06-19T14:39:28Z | Peters, Melissa | — | — | 1963-11-08 | N/A | — | 3029277697 | NULL | 1103 Forest Avenue #117 | Eden Prairie | MN | 55386 | null·· | UNKNOWN |
| TPA | TPA-55464 | 2026-06-05T05:48:12Z | Catherine | Z. | Long | 2007-09-16 | — | •••-••-6189 | 19346528446 | NULL | 2761 JEFFERSON AVE | Mesa | AZ | 85254 | — | — |
| TPA | TPA-51035 | 2026-04-23T18:49:48Z | ·Gerald | — | Gray | 2004-02-11 | — | — | +1 744 793 6070 | GERALD.GRAY80@PROTON.ME | NULL | - | — | UNKNOWN | — | — |
| TPA | TPA-59459 | 2026-05-24T11:20:43Z | Angela | — | Burns | 09/14/1967 | — | — | UNKNOWN | — | ·743 Lake View Rd | SACRAMENTO | CA·· | 95815 | — | — |
| TPA | TPA-50336 | 2026-03-23T06:37:12Z | CARLOS | — | PERKINS | 1998-11-01 | NULL | UNKNOWN | 3264008261 | ···· | NULL | — | — | — | GRP-9762 | ·CORE-HMO |
| TPA | TPA-62001 | 2026-10-09T16:40:59Z | HAROLD | — | MURPHY | 1948-08-24 | — | •••-••-0747 | — | HAROLD.MURPHY@ICLOUD.COM | 7183 River Road | Los Angeles | CA | 90004 | — | options-ppo |
| TPA | TPA-60292 | 2026-08-31T07:40:52Z | Alexander | — | Gardner | ·20080204 | N/A | N/A | N/A | NULL | — | UNKNOWN | N/A | UNKNOWN | GRP-9451 | — |
| TPA | TPA-55282 | 2026-10-17T21:06:07Z | julie | — | bowman | 2000-07-07 | NULL | •••-••-5742 | — | UNKNOWN | 23 Desert Sky Boulevard | HOUSTON | TX | 77066 | NULL | OPTIONS-PPO |
| TPA | TPA-62161 | 2026-08-28T09:07:19Z | Christian | — | ·Meyer | 2007-04-25 | N/A | NULL | 483-455-3818 | — | 2940 Indian School Road | Dallas | TX | 75216·· | — | CHOICE-PLUS-PPO |
| TPA | TPA-51130 | 2026-09-30T07:15:32Z | ·WEI | — | KELLEY | 5/1/1963 | - | — | 12328667732 | — | 1395 Desert Sky Blvd·· | Mesa | AZ | 85238 | — | — |
| TPA | TPA-53687 | 2026-04-29T05:03:41Z | DORIS | — | GEORGE | 19470118 | NULL | — | — | — | 9649 CANYON RD | Plano | TX | 75096-6810 | — | — |
| TPA | TPA-57658 | 2026-06-23T23:54:29Z | Gibson, Elizabeth | — | — | 1955-05-15 | null | NULL | 333-833-1944 | — | 833 SAGE CT | Tampa | FL | 33661 | GRP-1940 | — |
| TPA | TPA-57641 | 2026-09-15T08:40:09Z | Danielle | — | Rojas | 1952-05-16 | ·· | •••-••-4862 | 514-950-9022 | ·UNKNOWN | 4114 Forest Ave Apt 28 | Tucson | AZ | 85762 | NULL | — |
| TPA | TPA-62789 | 2026-09-19T06:32:58Z | VICTORIA | ·· | NUNEZ | 02/24/1991 | N/A | -·· | 791-237-9308 | victoria.nunez@proton.me | 5348 Central Avenue | Houston | Texas | 77087 | UNKNOWN | select-epo |
| TPA | TPA-57333 | 2026-07-21T10:46:35Z | Pamela | — | Sanders | 1960-06-02 | - | N/A·· | — | null | 4856 MOUNTAIN VIEW DRIVE | CHANDLER | AZ | 85272 | — | N/A |
| TPA | TPA-50161 | 2026-01-14T11:06:32Z | katherine | L | payne | 1945-07-05 | — | - | N/A·· | UNKNOWN | 352 Meadow Ln | Miami | FL | 33191 | UNKNOWN | N/A |
| TPA | TPA-62102 | 2026-02-14T10:40:17Z | AMY | — | GONZALEZ | 19850403 | — | •••-••-4811 | NULL | -·· | 6841 River Road | San Diego | California | 92119 | NULL | — |
| TPA | TPA-62870 | 2026-08-19T19:22:11Z | Amy | ·K | Morrison | 06-02-1977 | NULL | — | N/A | NULL | 4055 Palm Dr | Austin | TX | 78794 | — | — |
| TPA | TPA-60976 | 2026-06-27T10:14:59Z | Lucia | — | Morrison | 1945-10-17 | — | N/A | — | null | 889 Sage Court | Plano | TX | 75065·· | UNKNOWN | UNKNOWN |
| TPA | TPA-53111 | 2026-02-06T22:00:44Z | Billy | — | Delgado | 1988-08-24 | null | — | 4876514980 | BILLY.DELGADO43@AOL.COM | N/A | ···· | — | UNKNOWN | NULL | - |
| TPA | TPA-61506 | 2026-08-29T11:42:47Z | russell | R | mendoza | 7/6/1989 | - | •••-••-5776 | - | ·· | 2400 Hillcrest Rd | Tempe | AZ·· | 85215 | - | null |
| TPA | TPA-52915 | 2026-02-27T14:54:12Z | KELLY | E | ORTIZ | Jul 7, 1972 | UHC-39478-81·· | - | 877-643-2736 | null | 311 Ridge Road | Plano | TX | 75065 | - | — |
| TPA | TPA-58836 | 2026-10-10T20:23:36Z | Mark·· | — | Lewis | 1995-06-14 | ···· | — | null | N/A | 1859 INDIAN SCHOOL ROAD Apt 6 | Austin | tx | 78766 | - | — |
| TPA | TPA-61200 | 2026-03-21T07:03:22Z | Andrew | — | Berry | 08-04-2003 | null | ·· | - | null | null | UNKNOWN | — | null | GRP-7342 | N/A·· |
| TPA | TPA-59071 | 2026-10-17T19:25:29Z | mary | — | weber | 1964-12-04 | UHC-98691-21 | N/A | 6949401767 | mary.weber@gmail.com | 8305 Ocean Ave | Glendale | AZ | 85301 | GRP-0323 | — |
| TPA | TPA-52509 | 2026-08-24T19:21:34Z | olivia | U | chavez | 15-01-1973 | — | null | — | ·olivia.chavez21@outlook.com | 5964 Meadow Lane | Atlanta | ·GA | UNKNOWN | — | MEDICARE-ADV-B |
| TPA | TPA-60915 | 2026-02-07T16:49:50Z | BILLY | — | LAWRENCE | 1942-02-09 | UHC-31776-14 | — | 7586116 | - | 187 Cedar Lane | Seattle | WA | 98191 | GRP-6732 | — |
| TPA | TPA-58649 | 2026-09-27T01:10:59Z | Eugene | — | Warren | 1965-03-23 | UNKNOWN | — | 573.990.4544 | — | 4103 Bayshore Dr | Gilbert | AZ | 85277 | GRP-0243 | — |
| TPA | TPA-52041 | 2026-06-11T13:41:20Z | Hall, Keith·· | — | — | 1966-04-03 | NULL | — | — | ·null | 1725 Cedar Lane #423 | Dallas | TX·· | 75243 | NULL | — |
| TPA | TPA-62303 | 2026-01-11T19:55:05Z | Ford, Amanda | — | — | 1946-05-22 | N/A | •••-••-8036 | N/A | NULL | 251 Baseline Road | Tucson | AZ | 85726 | ·N/A | medicare-adv-b |
| TPA | TPA-58039 | 2026-06-25T03:11:08Z | Steven | — | Taylor | 2003-03-25 | UNKNOWN | — | ·NULL | - | 9165 Palm Drive | Gilbert | AZ | 85258 | N/A | null |
| TPA | TPA-50468 | 2026-02-20T14:37:45Z | David | — | Contreras | 1993-11-13 | — | - | UNKNOWN | UNKNOWN | 8288 SPRING STREET | Glendale | AZ | 85345 | GRP-5159 | NAVIGATE-HMO |
| TPA | TPA-56609 | 2026-08-23T15:03:05Z | Victoria | ···· | Maldonado | 1966-01-02 | UHC8868950 | ·N/A | ·(791) 773-4873 | VICTORIA.MALDONADO26@PROTON.ME | 9385 Sage Court·· | ATLANTA | ·GA | 30348 | NULL | N/A |
| TPA | TPA-55984 | 2026-08-06T08:48:39Z | Justin | — | Gilbert | 19791017 | UHC-98842-28 | N/A | N/A | justin.gilbert48@aol.com | 5876 INDIAN SCHOOL ROAD | ·Mesa | AZ | 85232 | — | NULL |
| TPA | TPA-56714 | 2026-05-30T18:07:45Z | CARLOS | ···· | RICHARDSON | 1994-06-02 | null | — | NULL | — | 9280 FOREST AVE | Minneapolis | MN | 55458 | UNKNOWN | UNKNOWN |
| TPA | TPA-61015 | 2026-06-06T06:44:08Z | Wright, Ralph | — | ···· | 13-07-1942 | — | •••-••-9156 | 463.481.7600 | — | 9787 River Rd | Phoenix | AZ | ·85064 | — | ·CHOICE-PLUS-PPO |
| TPA | TPA-57259 | 2026-04-26T05:32:14Z | VALENTINA | — | AGUILAR | 1943-05-19 | - | •••-••-2099 | 238-609-5322 | - | 4653 River Road | Glendale | AZ | 85376 | NULL | CHOICE-PLUS-PPO |
| TPA | TPA-56562 | 2026-05-28T11:06:23Z | RALPH | — | OWENS | 1982-06-19 | ···· | •••-••-3544 | null | - | 5399 Mesa Dr | Charlotte | NC | 28262 | GRP-1151 | - |
| TPA | TPA-53382 | 2026-07-26T01:28:33Z | Roger | — | George | 01/10/83 | - | ·· | 453-347-2618 | NULL | 1902 Washington Street | ·Atlanta | ·GA | 30362 | GRP-4074 | — |
| TPA | TPA-64003 | 2026-07-17T10:36:00Z | Samantha | ···· | Thompson | 1977-08-09 | UHC-17634-87 | null | UNKNOWN | null | 5712 PINE DRIVE | Glendale | AZ | 85306 | null | — |
| TPA | TPA-55135 | 2026-01-21T09:11:50Z | Patick | — | Santos | ·1980-05-01 | — | — | ·N/A | UNKNOWN | 2337 LAKE VIEW RD | Tampa | FL | 33667 | N/A | N/A |
| TPA | TPA-50247 | 2026-01-18T17:24:47Z | Anthony | — | Riley | 1961-09-02 | null | •••-••-9426 | 3408448924 | — | 4452 HARBOR BOULEVARD | San Diego | CA | 92151 | GRP-2514 | — |
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.349Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty