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-54100 | 2026-09-14T01:21:05Z | Teresa | — | Graene | 10/05/66 | — | — | ···· | TERESA.GREENE49@YAHOO.COM | 6237 Oak Street #186 | San Diego | CA | N/A | - | N/A |
| TPA | TPA-63511 | 2026-04-07T01:35:17Z | ·SUSAN | — | LARSON | 1966-04-24 | UNKNOWN | UNKNOWN | - | - | 8213 Indian School Rd | Orlando | FL | 32859 | GRP-0366 | -·· |
| TPA | TPA-50821 | 2026-06-28T23:42:22Z | Stephens, Ethan | A | — | 21-04-1996·· | NULL | — | NULL | N/A | 7458 Washington Street·· | Eden Prairie | ·MN | 55337-8665 | ·· | — |
| TPA | TPA-63327 | 2026-06-29T01:14:17Z | Brian | — | Evnas | 1955-01-05 | - | •••-••-3077 | (397) 422-0095 | — | 7147 Cedar Lane | Nashville | TN | — | GRP-9425 | SELECT-EPO |
| TPA | TPA-61075 | 2026-08-12T10:31:06Z | Marcus | — | Wallace | 1954-02-11 | UNKNOWN | •••-••-7655 | — | UNKNOWN | 5894 Bayshore Drive | MIAMI | FL | 33162-8793 | ·GRP-5795 | NULL |
| TPA | TPA-64182 | 2026-03-15T15:53:40Z | JERRY | — | DAY·· | 1966-12-18 | — | NULL | (767) 767-4930·· | - | — | NULL | — | UNKNOWN | GRP-9749 | N/A |
| TPA | TPA-57852 | 2026-01-08T11:19:17Z | Aaron | — | Jensen | 1969-05-08 | N/A | N/A | - | UNKNOWN | 5197 BASELINE RD | Scottsdale | AZ | 85227 | GRP-8687 | - |
| TPA | TPA-63180 | 2026-08-21T01:44:29Z | AISHA | — | SALAZAR | 11/10/1953 | — | null | 2307272 | N/A | 2129 Jefferson Avenue | Nashville | TN | 37292 | — | MEDICARE-ADV-A |
| TPA | TPA-60416 | 2026-08-01T18:58:16Z | Scott | — | Smith | 1976-11-03 | UHC-03157-35 | •••-••-1281 | 6786618333 | scott.smith96@hotmail.com | N/A | N/A | UNKNOWN | ·- | UNKNOWN | OPTIONS-PPO |
| TPA | TPA-62121 | 2026-04-09T10:26:19Z | Campbell, Martha | — | — | 1970-12-14 | null | — | 4176077919 | N/A | 3970 Harbor Boulevard | Gilbert | AZ | 85201 | GRP-7158 | UNKNOWN |
| TPA | TPA-60941 | 2026-05-04T02:37:32Z | Ethan | — | Wlch | 1941-06-23 | UHC6119641 | - | — | — | 9226 Lake View Road #443 | MINNEAPOLIS | MN | 55409 | GRP-8880 | - |
| TPA | TPA-60702 | 2026-06-27T09:17:29Z | Deborah | — | Vargas | 06/26/44 | NULL | •••-••-3169 | ·null | — | - | N/A | - | — | N/A | MEDICARE-ADV-A |
| TPA | TPA-62613 | 2026-04-19T01:05:54Z | Perkins, Haroold | O | — | 2007-02-14 | — | ···· | 816-228-8594 | — | null | null | null | UNKNOWN | NULL | — |
| TPA | TPA-51751 | 2026-02-01T14:54:57Z | MCHAEL | — | MARSHALL | 1971-09-20 | NULL | •••-••-0745 | 385-742-0765 | UNKNOWN | 5910 Main Street·· | Denver | CO | 80250 | UNKNOWN | — |
| TPA | TPA-56065 | 2026-01-01T12:31:59Z | SCOTT | H. | HAMILTON | 1944-01-26 | UNKNOWN | •••-••-5536 | 16845883514 | - | 234 Broadway | Orlando | fl | ·· | NULL | UNKNOWN |
| TPA | TPA-62894 | 2026-03-21T17:06:59Z | ISABELLA | — | FOX | 1977-01-22·· | — | N/A·· | (415) 955-1595 | null | 9600 Highland Avenue | Columbus | OH | 43286 | - | — |
| TPA | TPA-59109 | 2026-10-01T10:00:19Z | bryan | — | graham | 04-09-1999 | — | — | null | - | 301 Baseline Rd | Denver | co | 80251 | UNKNOWN | UNKNOWN |
| TPA | TPA-52598 | 2026-10-15T17:04:28Z | alan | — | carr | 1966-03-01 | — | - | - | NULL | 7594 Sage Ct | Glendale·· | AZ | 85373 | N/A | null |
| TPA | TPA-62032 | 2026-05-26T22:54:50Z | Ortega, Christine | W. | — | 19690922·· | N/A | — | null | christine.ortega7@aol.com | ·3529 MARKET ST | San Diego | CA | 92177-3393 | GRP-3842 | OPTIONS-PPO |
| TPA | TPA-56091 | 2026-08-28T11:51:07Z | Katherine | — | Porter | 5/1/1945 | N/A | - | N/A | ·· | - | N/A | - | N/A | NULL | — |
| TPA | TPA-52282 | 2026-01-26T04:49:59Z | KATHY | — | LUCAS | 2000-07-16 | null | N/A | null | NULL | null | N/A | UNKNOWN·· | UNKNOWN | - | SELECT-EPO |
| TPA | TPA-61618 | 2026-03-05T10:49:57Z | Gloria | ···· | Alvarez | 9/4/1956 | N/A | •••-••-3717 | 484.215.4398 | — | — | UNKNOWN | null | null | N/A | OPTIONS-PPO |
| TPA | TPA-56471 | 2026-06-24T18:25:51Z | Luna, Mariana·· | — | — | 12/20/1951 | — | N/A | ·(910) 562-2104 | N/A | 9580 Bayshore Dr | Minneapolis | MN | 55438 | GRP-4372 | — |
| TPA | TPA-63612 | 2026-06-27T16:23:19Z | Lawrence | — | Silva | 17-07-1974 | NULL | - | 208-348-7666 | — | 5164 Canyon Road | Fresno | CA | 93726 | — | — |
| TPA | TPA-64393 | 2026-03-12T06:48:30Z | SARA | F | RICHARDSON | 10/24/69 | N/A | - | - | - | 7411 LAKE VIEW ROAD | Houston | TX | 77089 | NULL | — |
| TPA | TPA-52022 | 2026-04-22T16:46:57Z | linda | — | gomez | 04/14/94 | ···· | — | — | — | ·8638 River Rd | Jacksonville·· | Florida | 32251 | GRP-6378 | OPTIONS-PPO |
| TPA | TPA-62992 | 2026-06-24T16:19:19Z | KEVIN | — | JIMENEZ | 1992-11-03 | — | -·· | null | — | 1553 DESERT SKY BOULEVARD | Orlando | FL | ·32857 | GRP-4171 | ·· |
| TPA | TPA-60424 | 2026-10-01T05:39:17Z | Donna | ···· | Owens | 8/12/1956 | — | — | 257-438-1946 | UNKNOWN | — | NULL | — | NULL | — | - |
| TPA | TPA-51500 | 2026-08-14T23:13:44Z | Joan | — | Mitchell | ·1977-11-24 | — | •••-••-2905 | UNKNOWN | ···· | 315 HILLCREST ROAD | Los Angeles | CA | 90088 | NULL·· | NULL |
| TPA | TPA-63248 | 2026-02-18T14:26:19Z | ·Payne, Madison | — | — | 1995-11-13 | N/A | •••-••-9680 | NULL | UNKNOWN | 1413 CENTRAL AVE | Nashville | TN·· | 37260 | null | — |
| TPA | TPA-54752 | 2026-05-25T07:22:51Z | ERIC | — | LANE | 1948-11-21 | - | •••-••-2669 | +1 598 637 3246 | — | 1483 MEADOW LANE | FRESNO | CA | 93756 | — | — |
| TPA | TPA-63850 | 2026-04-12T04:53:53Z | CYNTHIA | — | MARTINEZ | 1996-09-25 | — | ···· | null | — | 7315 BROADWAY | Gilbert | AZ | 85227 | — | MEDICARE-ADV-A |
| TPA | TPA-63657 | 2026-08-16T00:46:37Z | Ethan | S. | ·Garza | 2002-06-26 | ···· | ·- | (349) 681-5937 | null | 9873 MARKET ST | Atlanta | GA | 30335 | GRP-5429 | NULL |
| TPA | TPA-57421 | 2026-07-08T17:41:17Z | Howard, Kathleen | ·· | — | 1986-01-21 | null | •••-••-4315 | 7765295 | — | 3370 Oak St | Houston | TX | 77060 | GRP-1240 | — |
| TPA | TPA-56748 | 2026-04-17T04:17:08Z | ·Wilson, Pamela | — | — | Jul 21, 1942 | UHC-01249-68 | •••-••-8814 | 9678349119 | UNKNOWN | 175 Camelback Rd | San Antonio | Texas | — | NULL | OPTIONS-PPO |
| TPA | TPA-61170 | 2026-09-04T19:38:27Z | Roy | ···· | Spencer | 1981-07-16 | null | •••-••-3293 | null | - | 7299 Main Street | FRESNO | CA | 93758 | — | CORE-HMO |
| TPA | TPA-56391 | 2026-06-27T09:23:54Z | Sandra | ·· | Guzman | 03/22/41 | UNKNOWN | N/A | 309-940-3596 | UNKNOWN | 1098 CENTRAL AVE | CHANDLER | AZ | 85241 | N/A | MEDICARE-ADV-B |
| TPA | TPA-64192 | 2026-06-10T21:16:31Z | ANGELA | — | ORTIZ | 1957-07-23 | — | — | — | N/A | 8747 OAK STREET | PHOENIX | AZ | 85041-5582·· | — | OPTIONS-PPO |
| TPA | TPA-50830 | 2026-04-14T06:54:53Z | Santiago | — | Carter | 1994-09-01 | N/A | UNKNOWN | NULL | NULL | UNKNOWN | null | null | — | — | — |
| TPA | TPA-61283 | 2026-03-07T02:19:29Z | BYAN | — | VAZQUEZ | 2000-06-07 | - | - | — | null | 9177 Canyon Rd | Sacramento | CA | 95830 | ···· | N/A |
| TPA | TPA-53682 | 2026-07-23T04:51:22Z | vinent | — | moreno | 1975-02-13 | ·- | •••-••-2815 | 9744288 | NULL | 9606 Pine Dr | Jacksonville | FL | 32278 | GRP-7730 | null |
| TPA | TPA-55415 | 2026-02-04T12:44:02Z | Natalie | — | Reid | 1974-05-23 | - | •••-••-8290 | UNKNOWN | - | 8152 MEADOW LANE | ORLANDO | ·FL | 32822 | — | — |
| TPA | TPA-64162 | 2026-07-15T14:01:25Z | Jeff | — | Warren | 2001-02-27 | ·· | NULL | 646-429-7828 | NULL | 5097 MOUNTAIN VIEW DRIVE Apt 1 | Minneapolis | MN | 55464 | - | UNKNOWN |
| TPA | TPA-56807 | 2026-10-04T21:55:02Z | Arjun | G. | ·Martinez | 1938-06-17 | ·- | •••-••-5991 | (595) 534-9977 | arjun.martinez@hotmail.com | ·210 Union St | Minneapolis | Minnesota | 55436 | GRP-4562 | N/A |
| TPA | TPA-64332 | 2026-10-05T01:17:46Z | Diego | — | Lawrence | 11/27/1978 | null | - | 847.646.9423 | diego.lawrence@outlook.com | — | null | NULL | ·· | — | CHOICE-PLUS-PPO |
| TPA | TPA-51758 | 2026-08-04T20:09:06Z | Nicole | D. | Harris | 08/04/55 | null | - | UNKNOWN | nicole.harris@outlook.com | 3260 Cedar Ln | ·FRESNO | CA | null·· | null | ·- |
| TPA | TPA-63894 | 2026-02-21T10:11:01Z | Isabella | — | Sims | ·11/28/1954 | N/A | •••-••-3356 | ·238-640-6617 | NULL | 6026 Baseline Rd | Dallas | TX | 75260 | - | null |
| TPA | TPA-52941 | 2026-08-22T00:33:54Z | Castillo, Donald | — | — | 1942-07-26 | N/A | •••-••-3920 | (518) 342-4288 | null | NULL | null | null | null | NULL | SELECT-EPO |
| TPA | TPA-61473 | 2026-01-29T22:12:41Z | KEVIN | — | ORTEGA | 1950-11-09·· | N/A | - | UNKNOWN·· | — | 7358 Oak Street | Houston | ·TX | - | - | UNKNOWN |
| TPA | TPA-50907 | 2026-03-25T10:05:42Z | Ruht | ·· | Mendez | 2007-11-17 | — | •••-••-2827 | — | — | 7365 Spring St | San Antonio | TX | 78277-5165 | — | CORE-HMO |
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:36.708Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty