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-61723 | 2026-06-06T17:15:03Z | SUSAN | — | HARRIS | ·1979-02-09 | UHC-09269-29 | N/A | NULL | NULL | 7073 Willow Ct #317 | SCOTTSDALE | AZ | 85247 | UNKNOWN | — |
| TPA | TPA-51231 | 2026-08-18T00:19:37Z | Douglas | — | Henderson | 03/09/1973 | null | null | — | douglas.henderson@gmail.com | 5324 Central Ave | Denver | CO | 80279 | GRP-8114 | null |
| TPA | TPA-61237 | 2026-01-19T19:11:50Z | Teresa·· | — | Powell | 1981-09-23 | - | •••-••-4306 | UNKNOWN | N/A | 6134 CEDAR LN | Orlando | FL·· | 32863 | - | CHOICE-PLUS-PPO |
| TPA | TPA-59551 | 2026-08-15T23:26:36Z | Alan | — | Bradley | Sep 10, 1971 | — | •••-••-3172 | — | — | 5458 Oak Street | Tampa | FL | 33633·· | NULL | ·- |
| TPA | TPA-54045 | 2026-07-04T08:48:28Z | Kevin | — | Kennedy | 1964-11-08 | - | UNKNOWN | 211-783-2212 | KEVIN.KENNEDY82@GMAIL.COM | NULL | - | null | - | — | N/A |
| TPA | TPA-58753 | 2026-03-29T08:24:56Z | DORYS | — | HOFMAN | 1938-11-04 | UNKNOWN | — | — | doris.hoffman62@proton.me·· | ·3017 Indian School Rd | Gilbert | AZ | 85218 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-59390 | 2026-02-03T09:18:25Z | logan | — | myers | 1966-08-28 | - | ·UNKNOWN | NULL | logan.myers@hotmail.com | - | N/A | - | — | N/A | — |
| TPA | TPA-50012 | 2026-05-06T13:27:24Z | Sara | J | Contreras | 1973-04-10 | UHC-46492-52 | •••-••-8041 | +1 328 428 9584 | SARA.CONTRERAS60@ICLOUD.COM | 4401 River Road | Seattle | WA | 98159·· | - | — |
| TPA | TPA-50283 | 2026-07-28T06:45:19Z | Lauren | — | Spencer | 1956-03-13 | N/A | ·- | — | — | 9516 VALLEY VIEW DRIVE Apt 7 | Mesa | ·AZ | 85280-7386 | - | ·MEDICARE-ADV-A |
| TPA | TPA-51617 | 2026-08-25T14:53:15Z | Don | — | Young | 1967-05-24 | NULL | •••-••-3572 | 722-888-1214 | UNKNOWN | 5271 Lake View Rd | Denver | CO | 80288 | NULL | — |
| TPA | TPA-53317 | 2026-02-19T20:19:25Z | mary | — | howard | 1996-01-03 | null | •••-••-6238 | 16785435829 | -·· | 3561 Desert Sky Blvd | COLUMBUS·· | OH | 43253 | GRP-8124 | - |
| TPA | TPA-53015 | 2026-04-10T03:47:00Z | Susan | — | Edwars | 1977-01-25 | null | N/A | +1 210 922 0629·· | NULL | 9543 MAIN ST | Sacramento | ·CA | 95803 | null | ·- |
| TPA | TPA-61670 | 2026-07-15T12:33:51Z | Luis | — | Campbell | Feb 25, 1941 | N/A | UNKNOWN | 259-515-3539 | — | 3241 Union Street | Tampa | FL | 33684 | null | SELECT-EPO |
| TPA | TPA-63753 | 2026-02-23T04:50:30Z | DEBRA | ···· | BURTON | 08/18/1998 | NULL | — | UNKNOWN | — | 639 CEDAR LANE | PLANO | TX | 75074 | ·NULL | medicare-adv-a |
| TPA | TPA-64190 | 2026-10-14T10:44:56Z | SHARON | — | ALVARADO | 6/14/1977 | ···· | •••-••-9887 | UNKNOWN | sharon.alvarado11@yahoo.com | 3441 Mountain View Drive | Eden Prairie | MN·· | 55346 | — | UNKNOWN |
| TPA | TPA-59781 | 2026-08-03T23:25:14Z | Luis | ···· | Tucker | 1953-09-13 | UHC-25918-17 | •••-••-7803 | null | luis.tucker30@yahoo.com | ·4409 Hillcrest Road | Atlanta | GA | 30307 | GRP-6928 | — |
| TPA | TPA-64290 | 2026-01-21T15:48:04Z | Debra | — | Stevens | 19530519 | NULL | •••-••-7923 | ·6884376812 | debra.stevens72@aol.com | 1289 Lincoln Way | Denver | CO | 80211 | — | — |
| TPA | TPA-63176 | 2026-03-15T02:09:10Z | ·Aadm | — | Sanders·· | 2005-02-09·· | NULL | ·· | 3464053 | — | ·5341 RIDGE ROAD | TEMPE | AZ | 85206-3730 | - | NAVIGATE-HMO |
| TPA | TPA-63645 | 2026-06-28T23:21:48Z | ·Nicholas | ·· | Moorales | 24-01-1978 | UHC-12314-49 | •••-••-9297 | — | nicholas.morales28@hotmail.com | 7526 Broadway | FRESNO | CA | 93710 | GRP-4752 | MEDICARE-ADV-B |
| TPA | TPA-62592 | 2026-07-31T09:25:29Z | NICOLE | — | NUNEZ | 12-08-1991 | N/A | N/A | (487) 806-3447 | null | 1464 Cedar Ln | AUSTIN | TX | 78747 | null | NAVIGATE-HMO·· |
| TPA | TPA-55615 | 2026-08-30T21:55:39Z | Christina | — | Larson | 1955-07-09 | N/A | null | — | christina.larson80@aol.com | 4690 RIDGE RD·· | Scottsdale | AZ | 85255·· | N/A | — |
| TPA | TPA-58776 | 2026-05-12T11:52:04Z | LISA | — | HARRISON | 1983-07-19 | null | N/A | - | — | 2224 Ocean Avenue | Minneapolis | MN | 55431 | - | OPTIONS-PPO |
| TPA | TPA-58695 | 2026-04-01T06:17:24Z | Peter | ·· | Weber | ·2001-08-01 | ···· | •••-••-1036 | 539-548-0458 | — | 7181 CANYON RD | Houston | ·TX | — | — | null |
| TPA | TPA-61993 | 2026-08-06T10:18:09Z | Philip | T. | Burke | 07/13/67·· | — | NULL | — | — | 5182 Apache Boulevard | Plano | TX | 75068 | — | UNKNOWN |
| TPA | TPA-59812 | 2026-07-14T10:22:58Z | Heather | — | Cox | 1957-09-25 | ·- | UNKNOWN | NULL | - | 613 RIDGE RD | Los Angeles | CA | 90008-1684 | — | — |
| TPA | TPA-50971 | 2026-08-24T02:45:26Z | vincent | — | mendez | 1961-01-26·· | ·NULL | UNKNOWN | (344) 671-4778 | VINCENT.MENDEZ@YAHOO.COM | 721 Sunset Boulevard | MESA | AZ | 85220 | — | MEDICARE-ADV-A |
| TPA | TPA-61765 | 2026-02-11T15:58:27Z | BARBARA | — | ·COOPER | 1993-09-17 | N/A | NULL | (492) 742-8526 | ·· | 1440 FOREST AVENUE | Tempe | AZ | 85245 | N/A | ·· |
| TPA | TPA-63891 | 2026-01-04T10:06:54Z | ·SHIRLY | — | JENKINS | 19730517 | UHC-29779-72 | •••-••-0707 | NULL | — | 7004 WASHINGTON STREET | NASHVILLE | TN | 37207 | GRP-9851 | null |
| TPA | TPA-55662 | 2026-05-14T10:06:31Z | Robert | — | Hall | 22-03-1946·· | - | null | — | N/A | 1833 OAK STREET | Sacramento | CA | 95893 | — | NULL |
| TPA | TPA-64213 | 2026-07-13T06:34:34Z | Alexis | — | Hicks | 1950-12-06 | — | NULL | null | NULL | 7538 MARKET STREET Apt 33 | ·Seattle | WA·· | 98165 | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-63622 | 2026-09-07T01:55:18Z | Sam | — | Ray | 1967-10-28 | null·· | •••-••-7152 | (642) 613-9010 | ···· | 1864 Indian School Rd | GILBERT·· | AZ | 85244 | NULL | null |
| TPA | TPA-53055 | 2026-01-22T06:24:37Z | Bryant, Stephen·· | ·· | — | 1977-04-15 | N/A | •••-••-1729 | N/A | — | 9317 Lincoln Way | GLENDALE | ·AZ | 85384 | GRP-4877 | MEDICARE-ADV-B |
| TPA | TPA-54390 | 2026-02-13T12:17:19Z | Fatima | — | Simmons | 03/09/99 | UHC-08560-99 | — | UNKNOWN | NULL | 388 Church St | Columbus | OH | 43239 | GRP-5546·· | — |
| TPA | TPA-60017 | 2026-03-03T13:52:10Z | cheryl | — | barnes | 02-10-1966 | N/A | - | — | UNKNOWN | 6986 Mountain View Dr #845 | Tempe | Arizona | 85286 | — | - |
| TPA | TPA-55285 | 2026-06-01T19:00:48Z | ERIC | — | JORDAN | 1988-01-16 | ···· | — | 884-768-0878 | ERIC.JORDAN10@AOL.COM | ·6155 Mesa Dr | Nashville | TN | 37240 | - | null |
| TPA | TPA-61568 | 2026-06-22T14:25:01Z | Barbara | — | Dunn | 01/04/07 | UHC-34994-98 | •••-••-1077 | null | N/A | 8620 CEDAR LANE | ·Miami | FL | 33198 | — | - |
| TPA | TPA-55802 | 2026-06-28T21:31:11Z | Lori | — | Butler | 02-02-1989 | ·null | - | NULL | NULL·· | 1700 Spring Street | Atlanta | GA | 30383 | N/A | — |
| TPA | TPA-59897 | 2026-03-06T23:44:22Z | Mark·· | D | Perez | May 13, 1962 | ·N/A | ···· | 611-940-6836 | — | 8922 Canyon Rd | Los Angeles | CA | 90089·· | N/A | CORE-HMO |
| TPA | TPA-62811 | 2026-02-10T20:18:04Z | Hall, Harold | — | — | 1978-02-20 | — | — | UNKNOWN | HAROLD.HALL71@ICLOUD.COM | 4518 Union Street | Dallas | TX | 75298 | GRP-5064 | CORE-HMO |
| TPA | TPA-55922 | 2026-08-03T05:35:56Z | Isabella·· | I. | Nelson | 1992-04-21 | N/A | — | — | null | null | — | — | N/A·· | GRP-1444 | N/A |
| TPA | TPA-53721 | 2026-10-15T18:27:27Z | BRYAN | — | PALMER | 1940-24-01 | UHC-88787-64 | NULL | — | - | 7401 Lincoln Way | Los Angeles | CA | UNKNOWN | GRP-0108 | — |
| TPA | TPA-60755 | 2026-08-09T07:42:44Z | Medina, Amy | — | — | 1997-03-22 | — | UNKNOWN | — | UNKNOWN | 4249 APACHE BOULEVARD | San Diego | CA·· | 92133 | N/A | UNKNOWN |
| TPA | TPA-55852 | 2026-05-24T03:44:01Z | KEVIN | — | THOMPSON | 1948-01-11 | null | •••-••-5096 | 3994531456 | - | 2487 MAPLE AVE | Charlotte | NC | 28260 | — | N/A |
| TPA | TPA-59249 | 2026-02-27T21:27:38Z | SANTTIAGO | — | PATTERSON | 1978-05-19 | N/A | — | null | NULL | 6551 Mesa Drive | Charlotte | NC | 28248 | — | — |
| TPA | TPA-60969 | 2026-10-05T18:12:18Z | Zachary·· | — | Gibson | 2001-08-24 | NULL·· | - | — | — | — | — | — | N/A | — | N/A |
| TPA | TPA-62454 | 2026-08-05T23:54:30Z | jerry | ···· | mendez | 1963-06-22 | UNKNOWN | — | — | — | 5505 CANYON ROAD #908 | Las Vegas | NV | 89199-5355 | GRP-8579 | MEDICARE-ADV-B |
| TPA | TPA-63040 | 2026-06-15T10:37:02Z | Raymond | — | Duncan | 1952-03-16 | — | — | — | ·null | 7105 Park Place #607 | Orlando | FL | 32833 | UNKNOWN | ·N/A |
| TPA | TPA-56832 | 2026-04-26T07:49:59Z | ·CAROLYN | — | STEVENS | 2005-09-16 | N/A | •••-••-9026 | 553-991-5428 | — | 5431 Forest Ave | Seattle | WA | 98176 | — | UNKNOWN |
| TPA | TPA-59098 | 2026-05-15T07:06:51Z | Carol | — | Rogers | 6/14/1973 | — | ···· | null | carol.rogers@hotmail.com | 6820 Hillcrest Rd | MINNEAPOLIS | MN | 55427 | - | ·medicare-adv-a |
| TPA | TPA-57498 | 2026-09-19T01:41:12Z | Madison | — | Taylor | 1957-06-12 | — | — | UNKNOWN | UNKNOWN | 4368 SAGE CT | SACRAMENTO | CA | 95847 | ·null | -·· |
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:43:03.439Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty