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-61516 | 2026-05-23T16:13:44Z | Mary | — | Rivera | 1994-11-27 | null | •••-••-1385 | 972.796.3419 | NULL | NULL | N/A | N/A | UNKNOWN | GRP-0974 | - |
| TPA | TPA-53112 | 2026-07-21T00:51:59Z | Allen | — | Gloria | 9/12/1992 | UHC-83991-66 | — | — | NULL | 6590 LAKE VIEW RD | Austin | TX | 78719 | ·GRP-1753 | — |
| TPA | TPA-56156 | 2026-01-15T23:57:03Z | Mary | I | Ruiz | ·20090326 | NULL | •••-••-4379 | N/A | — | 4939 OCEAN AVENUE | San Antonio | Texas | ·· | - | — |
| TPA | TPA-60818 | 2026-05-23T13:05:18Z | Silva, Alex | V | — | ·1984-08-10 | null | - | (325) 851-0146 | alexander.silva87@icloud.com | 5783 Pine Drive | Phoenix | az | 85008·· | — | — |
| TPA | TPA-53678 | 2026-10-07T01:25:04Z | KARAN | — | WELLS | 6/21/1989·· | - | null | 7306647348 | UNKNOWN | 3908 SUNSET BOULEVARD | NASHVILLE | TN | 37236 | ···· | N/A |
| TPA | TPA-54756 | 2026-06-24T07:27:25Z | Albert | — | Santos | 8012-19-85 | N/A | UNKNOWN | 6659790940 | ···· | 2953 Union St | Chandler | ·AZ | 85221-5224 | - | NAVIGATE-HMO |
| TPA | TPA-56661 | 2026-05-16T22:18:13Z | Aaron | — | Peters | 2003-03-09 | UNKNOWN | ·· | null | aaron.peters28@aol.com | 7769 CHURCH STREET Apt 22 | Charlotte | NC | 28242 | UNKNOWN | N/A |
| TPA | TPA-61921 | 2026-03-31T21:41:48Z | Peter | — | Tucker | 1978-02-05 | UNKNOWN | — | 7264565272 | — | 5174 Hillcrest Rd | Houston | TX·· | 77035 | — | CORE-HMO |
| TPA | TPA-59074 | 2026-03-28T00:18:14Z | amanda | — | west | Mar 4, 1947 | — | •••-••-5978 | 8689155554 | null | 2156 Apache Blvd | Las Vegas | NV | 89197 | — | — |
| TPA | TPA-55899 | 2026-09-30T10:01:09Z | Amber | — | Alexander | 26-05-1960 | ·· | •••-••-5368 | 12306384043 | - | 8353 Oak Street | Jacksonville | FL·· | UNKNOWN | null | - |
| TPA | TPA-56730 | 2026-09-13T19:07:03Z | Albert | W. | Gray·· | 15-07-1946 | -·· | ·UNKNOWN | (815) 216-2015 | albert.gray78@yahoo.com | ·3904 Valley View Drive | Dallas | TX | 75273 | null | N/A |
| TPA | TPA-60916 | 2026-10-04T23:46:53Z | Christine | — | Le | 1976-04-22 | null | - | NULL | CHRISTINE.LE@ICLOUD.COM | 6862 Ridge Rd | San Antonio | tx | 78299 | GRP-9167 | ···· |
| TPA | TPA-61136 | 2026-07-20T19:27:24Z | Diane | — | White | 1950-05-18 | — | UNKNOWN·· | - | -·· | 6948 Ocean Ave | Austin | TX | 78737 | GRP-6078 | — |
| TPA | TPA-62960 | 2026-02-03T12:20:45Z | CARL | — | MILLER | 01/16/65 | — | •••-••-0317 | ·9457385035 | carl.miller66@gmail.com | 170 Willow Ct·· | Miami | FL | 33151 | N/A | — |
| TPA | TPA-52551 | 2026-05-08T18:51:44Z | Ralph | ···· | Burns | 1949-01-14 | N/A | •••-••-2760 | 857-974-9999 | — | — | - | — | null | — | ·· |
| TPA | TPA-53031 | 2026-01-26T22:07:44Z | Emily | — | Greene | 11/07/72 | — | •••-••-4423 | 297-555-9707 | NULL | 4133 WILLOW COURT | Chandler | AZ | 85286 | GRP-0245 | NULL |
| TPA | TPA-55398 | 2026-06-29T09:16:11Z | joseph | ···· | ·singh | 14-03-1961 | NULL | UNKNOWN | — | - | 5235 Maple Ave | Glendale | AZ | 85307 | GRP-8452 | MEDICARE-ADV-A |
| TPA | TPA-62465 | 2026-03-03T19:16:43Z | ADAM | — | OBRIEN | 1982-04-02 | null·· | NULL | 4268543684 | ADAM.OBRIEN84@PROTON.ME | 4314 Sunset Boulevard | Chandler | AZ | 85208 | GRP-9159 | — |
| TPA | TPA-53100 | 2026-01-22T18:25:12Z | Angela | — | Sanders | 1975-04-10 | UNKNOWN | •••-••-8223 | null | UNKNOWN | 2301 GRAND AVENUE | JACKSONVILLE | FL | 32217 | GRP-3281 | N/A |
| TPA | TPA-61286 | 2026-03-21T13:31:52Z | Aisha | — | Wallace | 1971-05-21 | N/A | null | 5727424896 | - | — | UNKNOWN | — | — | null | N/A |
| TPA | TPA-59352 | 2026-07-13T20:58:47Z | Lisa | — | Li | 09/23/1999 | UNKNOWN | •••-••-4241 | ·· | N/A | 6577 Ridge Road | SAN DIEGO | CA | 92129-5198·· | — | - |
| TPA | TPA-58899 | 2026-08-10T08:56:53Z | MARIA | — | WELLS | Mar 19, 1945 | null | NULL | — | — | 7304 Mountain View Dr | ·Phoenix | AZ | 85099 | GRP-0601 | null |
| TPA | TPA-53488 | 2026-04-26T02:45:43Z | Abigail | ···· | Long | 1996-01-22 | — | null | null | - | 4841 Oak St·· | Scottsdale·· | AZ | 85234 | — | UNKNOWN |
| TPA | TPA-51541 | 2026-08-13T01:23:55Z | joyce | — | wang | 1980-08-14 | UHC-08056-64 | null | 329-663-5105 | — | 2091 Pine Drive | TUCSON | Arizona | 85787 | — | — |
| TPA | TPA-50878 | 2026-09-13T19:16:04Z | Michael | — | Wihte | 07/18/1955 | N/A | — | — | — | 8484 Spring St | MIAMI | FL | 33110 | GRP-4686 | SELECT-EPO |
| TPA | TPA-51540 | 2026-04-25T19:52:03Z | Charlotte | — | Lewis | 19620915 | UHC-84126-96 | — | 13075157087 | CHARLOTTE.LEWIS37@PROTON.ME | 1093 CHURCH STREET | Denver | CO | 80291 | UNKNOWN | — |
| TPA | TPA-52113 | 2026-02-16T08:26:13Z | ·HEATHER | — | MCDONALD | 1947-01-09 | — | •••-••-2460 | - | UNKNOWN | NULL | NULL | — | NULL | GRP-2642 | NULL |
| TPA | TPA-57362 | 2026-09-23T04:10:47Z | Thomas | — | Black | 1962-10-13 | — | -·· | N/A | UNKNOWN | 9730 Oak Street | Glendale | AZ | 85321 | GRP-3200 | core-hmo·· |
| TPA | TPA-55264 | 2026-03-03T16:17:11Z | Donald·· | — | Park | Jan 9, 1972 | null | — | — | — | 1942 Forest Ave #852 | Gilbert | Arizona | N/A | null·· | UNKNOWN |
| TPA | TPA-56674 | 2026-02-06T11:07:58Z | Marcus | — | Carr | 28-10-1942 | N/A | — | N/A | ···· | 2952 JEFFERSON AVENUE | Tampa | FL | — | ···· | N/A |
| TPA | TPA-57077 | 2026-01-18T22:42:05Z | Ray | U | Dixon | 1967-09-10 | null | null | - | - | 803 APACHE BLVD | Gilbert | AZ | 85243 | GRP-0665 | OPTIONS-PPO |
| TPA | TPA-60102 | 2026-03-06T02:26:27Z | aaron | — | chapman | 3/18/1951 | N/A | NULL | (944) 325-1306 | N/A | 8759 LAKE VIEW RD | San Antonio·· | TX | null | - | - |
| TPA | TPA-56808 | 2026-09-16T08:48:59Z | KATHERINE·· | — | HAWKINS | 2002-12-12 | N/A | ·NULL | null | NULL·· | 7014 VALLEY VIEW DRIVE | AUSTIN | ·TX | 78788 | null | - |
| TPA | TPA-51375 | 2026-09-21T01:37:43Z | SAM | — | WATSON | 1998-11-08 | ···· | - | — | — | — | NULL·· | — | null | null·· | CHOICE-PLUS-PPO |
| TPA | TPA-57859 | 2026-01-19T12:38:26Z | gregory | ···· | smith | 1980-08-27 | N/A | ···· | - | null | 9597 Sage Court | ·Charlotte | NC | 28267·· | GRP-6839 | — |
| TPA | TPA-56244 | 2026-06-07T15:23:40Z | Gabriel | — | Cole | 2007-05-03 | UNKNOWN·· | UNKNOWN | ·(912) 786-2685 | null | 373 Cedar Ln | Houston | TX | 77062 | N/A | - |
| TPA | TPA-57892 | 2026-09-21T15:47:55Z | Betty | — | Patel | 1959-02-07 | null | •••-••-3836 | (742) 779-4631·· | — | 1321 RIVER ROAD #866 | Charlotte | NC | 28291 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-61434 | 2026-08-31T00:48:55Z | Robert | — | Moore | 1986-04-02 | NULL | •••-••-0727 | — | robert.moore@outlook.com | null | - | - | -·· | - | NULL·· |
| TPA | TPA-59730 | 2026-09-22T02:06:03Z | Davis, Amy | — | — | 11/28/1987 | NULL | null | 665-872-1312 | ···· | N/A | NULL | NULL | null | GRP-9851 | — |
| TPA | TPA-58043 | 2026-04-06T22:26:21Z | Bradley | — | Williamson | 1951-10-02 | ·· | •••-••-6219 | UNKNOWN | NULL | 5316 FOREST AVENUE·· | Charlotte·· | NC | 28289 | N/A | ·- |
| TPA | TPA-55540 | 2026-07-12T17:22:48Z | Emily | — | Black | 2/19/1949 | null·· | •••-••-7882 | — | ·null | 8359 DESERT SKY BOULEVARD | JACKSONVILLE | FL | 32287 | GRP-3535 | ·null |
| TPA | TPA-55873 | 2026-04-01T12:57:49Z | Marilyn·· | — | ·Porter | 1945-10-24 | — | NULL | (715) 938-7684 | — | 1787 Mountain View Dr #933 | Gilbert | AZ | 85299·· | null | — |
| TPA | TPA-64051 | 2026-09-20T05:42:26Z | Austin | — | Williamson | 19650211 | UNKNOWN | N/A | null | — | NULL | ·UNKNOWN | UNKNOWN | — | N/A | MEDICARE-ADV-B |
| TPA | TPA-58145 | 2026-03-05T22:33:42Z | NICHOLAS | — | GARRETT | 1987-02-16 | — | — | ·NULL | null | 8090 LINCOLN WAY | Tucson | AZ | 85776 | — | MEDICARE-ADV-A |
| TPA | TPA-57702 | 2026-08-23T04:16:15Z | Larry | ···· | Graham·· | 19890718 | NULL | N/A | 16874061603 | NULL | 7319 Spring St | Scottsdale | AZ | 85253 | GRP-5580 | N/A |
| TPA | TPA-61184 | 2026-07-12T15:19:10Z | PAMELA | — | WILSON | 1970-02-07·· | — | •••-••-9113 | NULL | UNKNOWN | — | — | — | UNKNOWN | UNKNOWN | null |
| TPA | TPA-50593 | 2026-02-07T22:44:50Z | jacob | — | rivera | 1983-11-28 | — | — | ·603-267-7157 | ·NULL | 1216 LINCOLN WAY | Mesa | AZ | 85238 | — | — |
| TPA | TPA-50851 | 2026-06-04T20:23:17Z | Matt | — | Carpenter | 1955-06-10 | UHC-33751-82 | — | +1 236 370 3581 | — | 6282 Desert Sky Boulevard | Orlando | fl | 32857 | — | — |
| TPA | TPA-63498 | 2026-01-16T17:57:03Z | Chris | — | Stephens | 2002-06-22 | — | •••-••-0859 | 387-575-9592 | christopher.stephens23@proton.me | 8367 Oak St | MIAMI | Florida | 33186 | GRP-9481 | null |
| TPA | TPA-55466 | 2026-01-25T01:37:20Z | BRUCE | — | WEBB | 04/24/41 | N/A | — | 961-685-4947 | UNKNOWN | 8500 Elm Street Apt 16 | Tampa | FL | N/A | GRP-5202 | — |
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:46.442Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty