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
Provider network only, ordered by line number
| Source | Record | Received | First | Middle | Last | DOB | Member ID | SSN | Phone | Address | City | State | ZIP | Group | Plan | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRV | PRV-25991 | 2026-06-27T11:27:09Z | FRANCES | P | VALDEZ | 1957-04-24 | UHC-77875-73 | •••-••-5343 | ·(246) 606-1892 | FRANCES.VALDEZ67@HOTMAIL.COM | NULL | — | — | — | UNKNOWN | — |
| PRV | PRV-27633 | 2026-01-23T21:41:52Z | Stephanie | — | Vasquez | 1949-05-18 | UHC-25440-72 | N/A | ·515-797-0273 | NULL | 6735 Central Ave | Seattle | Washington | 98131 | — | — |
| PRV | PRV-24667 | 2026-10-02T21:11:08Z | Jerry | — | Brooks | 2006-11-13 | ·· | — | (930) 429-1308 | NULL | 9445 Market Street·· | Glendale | AZ·· | 85372 | NULL | ·null |
| PRV | PRV-25205 | 2026-05-23T03:56:27Z | andrew | — | lawson | 1940-01-10 | -·· | •••-••-7594 | 3407428230 | UNKNOWN·· | 8968 Willow Court #183 | ORLANDO·· | FL | ·32895 | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-25560 | 2026-01-23T23:47:47Z | ·eugene | — | nunez | 19690128 | UNKNOWN | - | +1 489 935 0703 | — | 2385 Mesa Dr | Sacramento | California | 95807 | null | ·· |
| PRV | PRV-25939 | 2026-06-22T16:33:23Z | kayla·· | — | richards·· | 01/10/76 | UHC-42568-66 | N/A | 12535320764 | — | 2779 Pine Drive | DALLAS | TX | 75256 | null | - |
| PRV | PRV-20027 | 2026-05-31T05:13:21Z | FATIMA | A. | LYNCH | 2000-08-22 | UHC-78829-59 | UNKNOWN | 351-868-2231 | N/A | 7675 Harbor Blvd·· | COLUMBUS | OH | 43200 | NULL | ·NULL |
| PRV | PRV-25173 | 2026-04-21T11:09:14Z | RACHEL | — | WEBB | 2001-04-13 | — | ·· | 312-762-5131 | rachel.webb99@aol.com | 5298 MAPLE AVENUE | Atlanta·· | GA | 30378 | ···· | — |
| PRV | PRV-29050 | 2026-09-27T13:29:33Z | MICHELLE·· | — | ·BOWMAN | 1971-10-24 | - | null | - | — | 7317 OAK STREET | Tampa | FL | 33639 | NULL·· | SELECT-EPO |
| PRV | PRV-22441 | 2026-05-31T16:12:47Z | Nathan | I. | Olson·· | 1977-08-18 | UNKNOWN | — | 8935064456 | nathan.olson@hotmail.com | 7553 Central Ave | Houston | ·TX | 77034 | - | — |
| PRV | PRV-22330 | 2026-05-23T10:24:19Z | Judith | — | Gardner | 1996-07-24 | UHC-21987-43 | UNKNOWN | (743) 902-8198 | null | 9762 MAIN ST | ·Phoenix | AZ | 85077 | NULL | — |
| PRV | PRV-26269 | 2026-07-24T12:58:07Z | DIANA | ·· | LANE | 1990-09-25 | ·UHC-80512-97 | null | ·18243077412 | NULL | 3391 Indian School Rd #279 | Mesa | AZ | 85265-1306 | NULL | UNKNOWN |
| PRV | PRV-26911 | 2026-03-14T04:59:08Z | JACK J | — | SMITH | 07/24/50 | UHC-36697-29 | — | 956.682.4215 | jack.smith@icloud.com | 4569 SPRING ST | San Antonio | TX | 78247 | null·· | CORE-HMO |
| PRV | PRV-24074 | 2026-10-06T15:05:15Z | DAVID | I. | HERNANDEZ | 6/28/1987 | UHC-79977-02 | UNKNOWN·· | 3086821 | david.hernandez@aol.com | 8201 CAMELBACK RD | ·Orlando | FL·· | - | UNKNOWN | NAVIGATE-HMO |
| PRV | PRV-21622 | 2026-04-27T14:44:22Z | Welker, Alice | — | — | — | UHC-55066-76 | — | +1 308 417 5809 | null | 3598 Willow Court | Minneapolis | MN | 55437 | N/A | — |
| PRV | PRV-23972 | 2026-02-15T13:51:18Z | frank | — | baker | 1990-09-08 | - | - | 774-260-1092 | ·UNKNOWN | 2429 Sage Ct | Glendale | AZ | 85307-3547 | — | - |
| PRV | PRV-28764 | 2026-03-08T16:12:00Z | Danielle, Weaver | — | — | 06/27/71 | UHC-98676-06 | — | N/A | danielle.weaver90@yahoo.com | 724 Palm Dr | ·Atlanta | GA | 30341-0857 | NULL | - |
| PRV | PRV-22177 | 2026-04-19T23:41:34Z | Garrett, Madison | O | — | 04/18/42 | UHC-53981-25·· | NULL | 3276414185 | UNKNOWN | — | — | — | — | — | NULL |
| PRV | PRV-21311 | 2026-02-26T04:32:57Z | JACOB | — | SIMPSON | 1/24/2000 | UHC0292618·· | — | N/A | — | 4452 MAPLE AVENUE | CHARLOTTE | North Carolina | 28267 | NULL | UNKNOWN |
| PRV | PRV-25907 | 2026-08-19T05:57:46Z | LAWRENCE | — | JACKSON | 08-10-1972 | UHC-33336-58 | — | +1 430 293 3514 | — | 8802 Harbor Blvd·· | Nashville | TN | 37265 | - | — |
| PRV | PRV-28787 | 2026-01-08T01:27:00Z | carolyn | — | li | 1947-07-28 | — | •••-••-2424 | (774) 976-4183 | carolyn.li71@outlook.com·· | — | ·N/A | — | - | NULL | ·· |
| PRV | PRV-22954 | 2026-02-12T05:28:31Z | Christine | — | Morales | Jan 19, 2007 | null | NULL | 567.467.7874·· | — | 8944 Forest Ave | Charlotte | NC | ·28211 | ·N/A | UNKNOWN |
| PRV | PRV-28722 | 2026-01-18T19:18:07Z | Brenda | — | Bennett | 1963-03-11 | — | — | — | ·brenda.bennett2@outlook.com | 6951 Sunset Blvd | ·SAN DIEGO | CA | ·92121 | null | — |
| PRV | PRV-24731 | 2026-01-23T03:46:55Z | Jazon | — | Thompson·· | 1949-08-01 | UHC-34426-37 | - | 938-505-7920 | ·jason.thompson@icloud.com | 1522 Market St | Las Vegas | NV | 89126 | NULL | MEDICARE-ADV-B |
| PRV | PRV-20328 | 2026-02-12T15:35:58Z | Ortega, Sara | — | — | 02/06/1976 | null | - | +1 914 601 9464 | - | 5180 Church Street | Fresno | CA | 93729 | — | NAVIGATE-HMO |
| PRV | PRV-27798 | 2026-08-26T07:44:13Z | Gerald | — | Robertson | 20-09-1945 | UHC5225314 | — | 3807900615 | NULL | ·2789 Palm Dr Apt 26 | Phoenix | AZ | 85083 | UNKNOWN | null |
| PRV | PRV-23598 | 2026-07-09T15:10:31Z | ·Ruth Z | — | Contreras | 1978-05-04 | UHC-90999-03 | — | 5469929 | — | null | - | NULL | UNKNOWN | null | — |
| PRV | PRV-27020 | 2026-07-06T06:01:57Z | NICHOLAS | — | GONZALEZ | 19640411 | NULL·· | NULL | (643) 615-2977 | UNKNOWN | 6958 Lincoln Way | LOS ANGELES | CA | ···· | UNKNOWN | — |
| PRV | PRV-23431 | 2026-02-02T23:31:45Z | BRUCE | — | SANTOS | 19380313 | N/A | — | 3278008470 | ·bruce.santos@gmail.com | 9658 PINE DRIVE | Gilbert | AZ | 85288 | - | NAVIGATE-HMO |
| PRV | PRV-20726 | 2026-03-22T05:42:34Z | Camila | — | Woods | 1994-01-23 | UHC-11477-78 | — | ·538-590-8180 | CAMILA.WOODS@ICLOUD.COM·· | 1429 LINCOLN WAY | Jacksonville·· | FL | 32284 | — | — |
| PRV | PRV-21633 | 2026-02-13T00:36:56Z | Andrew·· | — | Chavez | 1997-09-10 | UHC-24032-03 | UNKNOWN | 6108062111 | ·N/A | ·1473 Indian School Rd | Nashville | TN | 37243 | UNKNOWN | — |
| PRV | PRV-20885 | 2026-05-05T09:02:56Z | Amber | — | Castro | ·1973-03-24 | N/A | — | 8467697820 | — | 1117 INDIAN SCHOOL RD | Gilbert | AZ | ·85223 | ·null | UNKNOWN |
| PRV | PRV-23815 | 2026-03-18T08:45:09Z | Samuel | Q | Lnych | 12/12/81 | ·UHC-18157-27 | UNKNOWN | (730) 634-4799 | samuel.lynch7@hotmail.com | 689 Market St | PLANO | TX | 75095-5845 | — | — |
| PRV | PRV-21215 | 2026-07-19T21:42:32Z | Snyder, Randy Q | — | — | 1989-06-16 | N/A | •••-••-7888 | (431) 818-6468 | randy.snyder@hotmail.com | 398 Broadway | San Antonio | TX | 78213 | N/A | — |
| PRV | PRV-22006 | 2026-08-26T05:07:51Z | Cheryl | — | Rivera | 09/14/63 | — | •••-••-3505 | ·UNKNOWN | — | ·7489 Apache Boulevard | Phoenix | AZ | 85039·· | N/A | — |
| PRV | PRV-28848 | 2026-03-29T18:42:06Z | Jacobs, Omar | — | — | 1943-10-14 | UHC-10426-17 | N/A | UNKNOWN | N/A | 1000 Washington St | Dallas | Texas | — | N/A | ···· |
| PRV | PRV-23231 | 2026-03-28T13:19:22Z | JUAN | — | DIXON | 1982-04-10 | UNKNOWN | - | (490) 737-4820 | UNKNOWN | 7198 CHURCH ST #782 | Atlanta | GA | 30367 | null | CHOICE-PLUS-PPO |
| PRV | PRV-20772 | 2026-01-11T18:13:17Z | KENNETH | — | PERKINS | 1996-07-07 | UHC-46973-89 | — | 9846081911 | kenneth.perkins@hotmail.com | 6141 MAPLE AVENUE | Glendale | AZ | 85301 | UNKNOWN·· | null |
| PRV | PRV-28241 | 2026-07-04T10:49:23Z | Priya·· | ···· | Lopez | 1947-04-09 | - | •••-••-2663 | +1 207 656 6795 | PRIYA.LOPEZ@AOL.COM | 6000 HARBOR BOULEVARD | CHANDLER | AZ·· | 85296 | — | - |
| PRV | PRV-27696 | 2026-06-14T22:42:17Z | james | N. | bishop | 1953-11-23 | UHC-85304-86 | — | (899) 921-9614 | UNKNOWN | - | UNKNOWN | UNKNOWN | — | UNKNOWN | N/A |
| PRV | PRV-23018 | 2026-08-14T12:36:53Z | Stevens, Melissa | — | ·· | Feb 18, 1956 | UHC-08975-82 | — | 2935934937 | melissa.stevens31@outlook.com·· | 4400 BROADWAY·· | Plano | TX | 75091 | null | UNKNOWN·· |
| PRV | PRV-28260 | 2026-01-08T18:43:47Z | KEVIN | D | MATTHEWS | 1965-08-15·· | — | •••-••-3093 | 6038237 | KEVIN.MATTHEWS@AOL.COM | 6609 Mesa Dr | Houston | Texas | 77074 | - | NULL |
| PRV | PRV-23484 | 2026-05-19T19:37:38Z | Bishop, Michael | — | ·· | 05/08/41 | UHC4061739 | - | +1 247 858 1256 | NULL | 5310 Lincoln Way | Tempe | ·AZ | 85231 | N/A·· | — |
| PRV | PRV-23861 | 2026-01-23T16:47:44Z | CYNTHIA | — | RAY | 1944-07-28 | — | NULL | 19855465699 | NULL | 2807 Lake View Rd | Houston | ·TX | NULL | — | null |
| PRV | PRV-22450 | 2026-03-30T01:09:50Z | Julia | — | Jenseen | 1958-06-21 | UHC-89834-38 | •••-••-8652 | 389-461-8707 | — | ·8583 Sage Court | FRESNO | CA | 93784 | N/A | - |
| PRV | PRV-21333 | 2026-03-09T14:51:18Z | SOPHIA | — | HOWELL | 1997-04-28 | null | ···· | (492) 467-4792 | N/A·· | 2377 Apache Blvd | San Diego | California·· | 92144·· | N/A | N/A |
| PRV | PRV-27394 | 2026-06-17T02:00:44Z | Theresa | — | Taylor | 4/11/1982 | UHC-55739-27 | null | 15392222883 | — | 2310 MESA DRIVE | Los Angeles | CA | 90081 | NULL | null |
| PRV | PRV-23966 | 2026-03-29T09:39:16Z | Lisa | — | Rivera | 09-10-1938 | UHC-02876-16 | •••-••-4426 | 6105169168 | lisa.rivera@hotmail.com·· | 4615 Apache Boulevard | Mesa | AZ | 85216 | UNKNOWN | - |
| PRV | PRV-27046 | 2026-03-10T09:36:37Z | BETTY | — | ROSE | 1945-03-03 | — | •••-••-7919 | (600) 356-2475 | - | 8135 CENTRAL AVE | Columbus | OH | 43210 | — | null |
| PRV | PRV-29221 | 2026-01-08T18:01:12Z | JENNIFER | — | SCHMIDT | 2003-07-05 | UHC-29055-65 | — | 606.475.0635 | JENNIFER.SCHMIDT@GMAIL.COM | 3969 Camelback Road | LOS ANGELES | ca | 90096 | — | 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 preservedline_no records each row's position in the source file, so a value can be located in the original extract.
- Load timestamploaded_at marks when the row landed in the lakehouse; this batch landed 2026-10-21T12:37:53.957Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty