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-55823 | 2026-08-30T06:31:15Z | Hoffman, Joan | — | — | 09/22/1942 | NULL | •••-••-4097 | 296-775-6034 | N/A | 4691 River Road | Scottsdale | AZ | 85203 | GRP-5949 | N/A |
| TPA | TPA-53593 | 2026-09-26T19:55:35Z | Virginia | — | Hanzon | 1953-08-12 | UHC-89231-07 | — | — | — | 2261 Willow Ct | Jacksonville | FL | — | GRP-2366 | null |
| TPA | TPA-55242 | 2026-07-10T21:37:05Z | KEITH | — | MILLS | 1969-12-07 | UNKNOWN | null | — | keith.mills47@hotmail.com | null | - | UNKNOWN | N/A | — | CHOICE-PLUS-PPO |
| TPA | TPA-62614 | 2026-07-09T01:38:27Z | Phillips, Natalie | — | — | 1986-10-11 | NULL | — | 855-418-0423 | - | 1429 Cedar Lane | Gilbert | AZ | 85213 | ·GRP-4885 | — |
| TPA | TPA-58031 | 2026-04-12T06:36:17Z | AUSTIN | — | PATTERSON | 19561018 | — | — | — | austin.patterson77@outlook.com | 5188 Sunset Blvd | Tempe | AZ | 85211 | ···· | — |
| TPA | TPA-60297 | 2026-04-16T04:18:58Z | Virginia | — | Guerrero | 1945-06-21 | — | null | 512-817-1485 | virginia.guerrero19@icloud.com | — | null | NULL | UNKNOWN | GRP-9916 | SELECT-EPO |
| TPA | TPA-52571 | 2026-09-28T20:17:40Z | Samuel | — | Wilson | 2003-04-10 | — | •••-••-3185 | null | - | 4811 BROADWAY | Sacramento | ca | 95865 | UNKNOWN | UNKNOWN |
| TPA | TPA-61511 | 2026-07-16T19:09:58Z | Kayla·· | — | Brooks | 0907-20-20 | - | •••-••-0745 | null | NULL | 9810 Forest Avenue | Miami | Florida | ·33105 | GRP-2026 | — |
| TPA | TPA-50342 | 2026-08-05T14:27:36Z | Shirley | W | Bell | 1971-11-04 | - | •••-••-1150 | — | shirley.bell22@hotmail.com | 8891 Washington Street | Houston | ·TX | 77050-5318 | — | null |
| TPA | TPA-62972 | 2026-02-02T19:18:39Z | Gloria·· | — | Howerd | ·20000207 | UHC-86207-58 | •••-••-2458 | — | — | 3701 RIDGE ROAD | Mesa | AZ | null | GRP-1824 | — |
| TPA | TPA-53254 | 2026-08-20T03:56:30Z | Tony | ·· | Holmes·· | 04/26/1960 | ·- | - | — | — | UNKNOWN | null·· | N/A | null | GRP-8582 | — |
| TPA | TPA-53830 | 2026-01-02T01:04:35Z | BRENDA | S | JIMENEZ | 1946-09-24 | — | null | NULL | NULL | 3317 Mountain View Drive | Atlanta | GA | 30315 | — | navigate-hmo |
| TPA | TPA-50314 | 2026-05-26T08:11:23Z | Betty | — | Simpson | 19850311 | N/A | — | — | NULL | 3543 Elm Street | ·Plano | TX | 75010-5800 | N/A | null |
| TPA | TPA-61264 | 2026-03-23T13:17:37Z | Johnston, Scott | — | — | 10-08-1965 | UHC-34433-48 | — | null | NULL | 7864 OAK STREET | Nashville | TN | 37209 | ·UNKNOWN | — |
| TPA | TPA-51846 | 2026-06-10T03:56:00Z | Judith | — | Cruz | 12/27/1945 | NULL | •••-••-6737 | — | UNKNOWN | 2981 Highland Avenue | Miami | FL | 33173 | - | OPTIONS-PPO |
| TPA | TPA-63599 | 2026-05-22T15:20:26Z | Judy | — | Armstrong | 1940-08-04 | NULL | •••-••-0672 | 334.933.0130 | JUDY.ARMSTRONG78@PROTON.ME | — | — | null | ·· | — | UNKNOWN |
| TPA | TPA-53688 | 2026-01-07T23:04:50Z | Patty | — | Chavez | 1998-04-09 | — | - | — | NULL | ·3111 Desert Sky Blvd | Denver | CO | 80237 | ·· | ·· |
| TPA | TPA-62978 | 2026-07-02T04:12:05Z | Margaret | ···· | Knight | 1952-08-24 | N/A | •••-••-3088 | 638-437-4725 | UNKNOWN | 5141 HARBOR BLVD | Columbus | oh | 43294 | — | MEDICARE-ADV-A |
| TPA | TPA-57492 | 2026-08-29T05:36:45Z | KENNETH | — | HENRY | 2001-05-17·· | — | — | 5245542623 | kenneth.henry85@icloud.com | 4427 Forest Avenue·· | Dallas | TX | 75208 | GRP-1486 | UNKNOWN |
| TPA | TPA-59139 | 2026-06-17T19:30:01Z | brandon | — | johnston | 1979-09-16 | - | — | — | UNKNOWN | 9503 Lake View Road | Seattle | wa | 98108 | GRP-7301 | CHOICE-PLUS-PPO |
| TPA | TPA-53361 | 2026-05-26T06:06:29Z | Jose | — | ·Munoz | 08/05/04 | ···· | — | — | ·· | — | UNKNOWN | — | - | GRP-5580 | N/A |
| TPA | TPA-64320 | 2026-04-24T23:39:56Z | Katherine | — | Ross·· | Aug 1, 1956 | — | — | NULL | katherine.ross@gmail.com | 942 Spring Street | Mesa | Arizona | 85244 | NULL | NAVIGATE-HMO |
| TPA | TPA-62746 | 2026-05-01T15:42:39Z | Adam | — | Barnes | Jun 8, 1951 | UNKNOWN | ·null | ···· | ·null | 7258 Union St | Seattle | WA | 98140 | UNKNOWN | NAVIGATE-HMO |
| TPA | TPA-62993 | 2026-06-24T16:19:19Z | KEVIN | — | JIMENEZ | 1992-11-03 | — | -·· | null | — | 1553 DESERT SKY BOULEVARD | Orlando | FL | ·32857 | GRP-4171 | ·· |
| TPA | TPA-52115 | 2026-01-19T14:14:25Z | joyce | — | wright | 1966-01-14 | null | N/A | (366) 891-7778 | JOYCE.WRIGHT@ICLOUD.COM | — | N/A | NULL | - | GRP-5882 | MEDICARE-ADV-A |
| TPA | TPA-53694 | 2026-05-29T15:15:46Z | ZACHARY | ···· | WEBER·· | 1945-01-21 | — | — | - | N/A | ·1671 ELM STREET | Miami | FL | 33142 | ···· | MEDICARE-ADV-A·· |
| TPA | TPA-55090 | 2026-03-17T05:17:52Z | John | — | Rivera | 2006-11-10 | — | •••-••-1719 | 929-584-7598 | — | 1199 SAGE CT | San Diego | CA | 92126 | — | null |
| TPA | TPA-55258 | 2026-04-10T05:59:31Z | Sophia | — | Montgomery | 1947-01-08 | NULL | null | 7222811380 | sophia.montgomery@hotmail.com·· | 2573 OAK STREET | Austin | TX | 78708-9244 | GRP-0647 | NULL |
| TPA | TPA-55609 | 2026-02-27T18:01:22Z | Ethan | U. | Turner | 1979-07-21 | UHC-63512-82 | •••-••-5644 | NULL | ETHAN.TURNER2@HOTMAIL.COM | 3909 CENTRAL AVE | Seattle | WA | ·98119 | GRP-1641 | NULL |
| TPA | TPA-54542 | 2026-03-20T18:57:05Z | Ana | — | Robinson | 1955-02-02 | UNKNOWN | ·· | (487) 986-0691 | ana.robinson@proton.me | 3989 Indian School Rd | SAN DIEGO | CA | null | - | — |
| TPA | TPA-53077 | 2026-02-23T20:42:46Z | Jkae | — | Kim | 1958-07-15 | — | — | ···· | - | 8072 ELM ST | Jacksonville | FL | 32291 | GRP-6972 | — |
| TPA | TPA-63499 | 2026-05-25T22:25:50Z | Eric·· | V. | ·Owens | 08/24/1963 | null | ·N/A | NULL | NULL | 1197 WILLOW COURT | Orlando | FL | 32872·· | — | ···· |
| TPA | TPA-55983 | 2026-05-27T16:21:08Z | Price, Gregory | — | — | 1944-02-04 | UHC-92493-94 | — | N/A | null | 2317 Church St #594 | Houston | TX | 77050 | — | - |
| TPA | TPA-56492 | 2026-04-28T23:07:25Z | priya | Y | schultz | 1969-11-28 | UHC-36322-49 | — | 4144723519 | NULL | 4149 Ocean Avenue | Miami | FL | 33195 | GRP-9323 | — |
| TPA | TPA-58207 | 2026-10-02T05:37:01Z | WILLIE | Y | MILLER | Jul 8, 1998 | — | null | (810) 255-8749 | — | 1508 CANYON RD | ATLANTA | GA | 30394 | N/A | UNKNOWN |
| TPA | TPA-54269 | 2026-07-19T13:27:58Z | Jean | — | Adams | 12/27/1949 | — | NULL·· | UNKNOWN | UNKNOWN | 7441 OAK ST | ORLANDO | FL·· | 32897 | NULL | UNKNOWN |
| TPA | TPA-51598 | 2026-09-03T20:22:15Z | Valentina | — | Gonzalez | 1995-09-13 | null | — | UNKNOWN | null | 1832 Highland Ave | Eden Prairie | MN | 55336 | GRP-9579·· | ·CHOICE-PLUS-PPO |
| TPA | TPA-51365 | 2026-04-21T03:02:04Z | VIRGINIA | — | NICHOLS | 07-12-1988 | UHC9894114 | — | 12417139080 | UNKNOWN | 5032 Canyon Rd | Eden Prairie | MN | ·55380 | null | UNKNOWN |
| TPA | TPA-59480 | 2026-06-10T16:58:10Z | Beverly | — | Taylor | 19521103 | UHC-23926-10 | - | NULL | UNKNOWN | 294 Market Street | Fresno | CA | 93790-6792·· | GRP-6305·· | null |
| TPA | TPA-60699 | 2026-08-17T03:06:09Z | Charles | ···· | Murray | 1951-01-15 | NULL | — | — | CHARLES.MURRAY@ICLOUD.COM | 5473 Mesa Drive #768 | San Diego | CA | 92199 | GRP-6232 | select-epo |
| TPA | TPA-56849 | 2026-01-30T12:31:41Z | Philip | — | Carroll | 19420622 | ·NULL | NULL | (388) 640-3080 | PHILIP.CARROLL19@OUTLOOK.COM | 4716 Highland Ave | San Diego | CA | 92130 | GRP-0439 | MEDICARE-ADV-B |
| TPA | TPA-50804 | 2026-04-26T00:02:05Z | Betty | T. | Peters | 1221-89-40 | - | — | — | betty.peters36@aol.com | 7521 Camelback Rd | ·Sacramento | CA | 95881 | null | MEDICARE-ADV-A |
| TPA | TPA-58269 | 2026-04-18T02:48:24Z | CAROL·· | — | WALKER | 1946-02-09 | — | •••-••-4417 | — | NULL | 8826 CANYON RD #879 | Sacramento | CA | 95891 | NULL | NULL |
| TPA | TPA-55498 | 2026-05-07T13:19:40Z | DOROTHY | — | MILLER | 1954-02-12 | UNKNOWN | null | (236) 989-1020 | — | 4955 Mountain View Dr·· | Orlando | FL | 32881 | GRP-3708 | — |
| TPA | TPA-50936 | 2026-05-18T07:14:21Z | Jimmy | — | Marshall | 20060903 | — | ·- | - | null | 2554 Willow Court | San Antonio | TX | 78240 | GRP-9673 | MEDICARE-ADV-B |
| TPA | TPA-57264 | 2026-10-02T14:42:30Z | Janet | X | Henderson | 1976-07-16 | — | — | (984) 308-6993 | janet.henderson@hotmail.com | 7039 MOUNTAIN VIEW DRIVE Apt 28 | Houston | TX | null | UNKNOWN | ·NULL |
| TPA | TPA-58837 | 2026-08-28T07:26:34Z | EVELIN | — | DELGADO | 1961-10-05 | N/A | NULL | 13543686826 | — | 495 CHURCH ST·· | Plano | TX | 75074 | ···· | NULL |
| TPA | TPA-58344 | 2026-09-05T11:43:18Z | LUIS | — | SMITH | 1986-03-25 | — | •••-••-4487 | 2957745010 | UNKNOWN | 1207 Camelback Road·· | Columbus | OH | 43268·· | GRP-2488 | null |
| TPA | TPA-59754 | 2026-06-05T09:50:17Z | Reynolds, Joyce | K | — | 1963-10-28 | ·null | - | UNKNOWN | ···· | 3813 HARBOR BLVD | ·Sacramento | CA | - | - | CHOICE-PLUS-PPO |
| TPA | TPA-63426 | 2026-06-05T13:51:06Z | VINCENT | — | MEYER | 1984-12-22 | — | - | — | UNKNOWN | 237 Sage Ct | Plano | TX | 75014 | UNKNOWN | — |
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.080Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty