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
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-25873 | 2026-08-27T13:13:26Z | GRACE | — | CARR | 1938-12-11 | ···· | ···· | (803) 335-4003 | null | 9265 Palm Drive | Minneapolis | MN | 55427 | — | SELECT-EPO |
| PRV | PRV-21710 | 2026-03-30T12:26:11Z | FATIMA | — | ANREWS | 1965-10-25 | UHC-06226-03 | •••-••-9077 | 467-437-5628 | FATIMA.ANDREWS73@OUTLOOK.COM | 7295 Lincoln Way | Tucson | AZ | 85733 | — | CHOICE-PLUS-PPO |
| PRV | PRV-28896 | 2026-06-15T15:44:44Z | Russell, Douglas | — | ···· | 1997-07-01 | — | •••-••-1890 | - | — | ·3018 Harbor Blvd Apt 3 | Sacramento | CA | 95872 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-27627 | 2026-05-24T07:33:51Z | Samantha | — | Murphy | 1977-09-03 | UHC-20022-73 | N/A | 700-347-2354 | samantha.murphy@yahoo.com | 2756 Hillcrest Road | Las Vegas | nv | 89195 | null | - |
| PRV | PRV-29164 | 2026-04-25T18:51:01Z | Sims, Carl·· | — | ···· | 19640626 | UHC-22625-51 | — | 18967386776 | NULL | 3056 Indian School Road | TUCSON | AZ | 85781 | N/A | UNKNOWN |
| PRV | PRV-26363 | 2026-02-02T20:30:44Z | Diana | — | Vazquez | 1993-07-23·· | UHC-02734-70 | ·NULL | (470) 891-3657 | null | 5173 River Rd | Jacksonville | FL | NULL | ···· | null |
| PRV | PRV-21763 | 2026-07-10T23:22:57Z | ·John V. | — | ·Richards | 9160-01-18·· | UHC9644175 | •••-••-2183 | 934.737.8156 | — | N/A·· | N/A | NULL | null | - | N/A |
| PRV | PRV-20228 | 2026-02-04T20:28:44Z | ANNA | S | FISHER | 1990-90-28 | — | •••-••-6064 | (938) 446-6330 | anna.fisher@yahoo.com | 6576 Camelback Road | Los Angeles | California | — | ·N/A | - |
| PRV | PRV-21895 | 2026-09-18T05:40:29Z | HELEN | — | WEBB | 2/27/1971 | NULL | — | 231-739-5609 | — | 8349 Broadway #599 | Los Angeles | CA | 90035 | — | NULL |
| PRV | PRV-28138 | 2026-10-02T00:44:16Z | Billy | — | ·Romero | 1992-09-22 | UHC5131112 | UNKNOWN | UNKNOWN | NULL | 6253 Church St | MESA | AZ | 85294 | N/A | — |
| PRV | PRV-25771 | 2026-06-24T20:13:21Z | Lewis, Brenda | — | — | 19771020 | UHC-78243-99 | — | 9142238628 | BRENDA.LEWIS51@GMAIL.COM | 4565 Church Street | Las Vegas | ·NV | 89169 | — | N/A |
| PRV | PRV-23042 | 2026-04-27T10:01:11Z | YUKI·· | — | ·POWELL | 1971-05-24 | — | NULL | (851) 223-7099·· | UNKNOWN | 402 LINCOLN WAY | Glendale | AZ | 85390 | - | CORE-HMO·· |
| PRV | PRV-23381 | 2026-03-02T11:03:01Z | Crawford | C | Carlos | 1969-08-09·· | UHC-73470-50 | ·· | 15208811292 | — | 4540 CENTRAL AVENUE·· | Atlanta | ·GA | 30376 | - | MEDICARE-ADV-B·· |
| PRV | PRV-24080 | 2026-08-29T20:14:34Z | Mei·· | Q. | Lane | 1963-07-23 | — | - | 283-228-1350 | mei.lane@yahoo.com | 6232 Hillcrest Rd | Las Vegas | ·NV | 89186 | - | UNKNOWN |
| PRV | PRV-24125 | 2026-05-23T18:26:32Z | Mateo | ···· | Wright | 1949-05-26 | N/A | NULL | null | N/A | 4302 Harbor Blvd | Columbus | Ohio | 43234 | — | null·· |
| PRV | PRV-22215 | 2026-06-29T21:23:20Z | Hannah | — | Dean | 1988-08-19·· | UHC-24263-66 | ·null | 371-283-2774 | ·hannah.dean61@outlook.com | 9624 Maple Avenue | Dallas | TX | 75217·· | UNKNOWN·· | ·- |
| PRV | PRV-23451 | 2026-04-09T12:04:22Z | Frances | — | Porter | 8/20/1962 | UNKNOWN | — | (632) 939-7159 | NULL | 5689 BAYSHORE DRIVE | Las Vegas | NV | 89157 | UNKNOWN | UNKNOWN |
| PRV | PRV-29064 | 2026-03-15T07:45:20Z | BENJAMIN | I | ·JONES | — | UHC-75457-98 | UNKNOWN | +1 793 647 7754 | N/A | ·5630 BASELINE ROAD | Plano | Texas·· | 75019-4756 | NULL | CORE-HMO |
| PRV | PRV-21018 | 2026-05-04T08:30:20Z | Larry L.·· | — | Mills | Jan 13, 1998·· | — | — | 526-557-8622 | ·larry.mills95@aol.com | 155 Harbor Boulevard #679 | GILBERT | az | 85209 | null | CHOICE-PLUS-PPO |
| PRV | PRV-22418 | 2026-05-14T03:21:56Z | ·Priya | Z | Clark | 1940-07-26 | null | N/A | 7576815457 | priya.clark96@aol.com | 2277 Bayshore Drive | Plano | ·TX | UNKNOWN | null | MEDICARE-ADV-B |
| PRV | PRV-20521 | 2026-08-20T16:43:44Z | Virginia | E | Castillo | 06-06-1992 | UHC-00947-15 | UNKNOWN | ·NULL | VIRGINIA.CASTILLO47@HOTMAIL.COM | 6133 Canyon Road | LOS ANGELES | CA | 90090 | N/A·· | null |
| PRV | PRV-26059 | 2026-03-04T21:24:44Z | Mason | ·V. | Sanchez | 1953-01-04 | - | null | — | mason.sanchez@yahoo.com | 1884 Forest Avenue | San Antonio | Texas | 78278-5225 | UNKNOWN | N/A |
| PRV | PRV-28704 | 2026-09-21T20:13:37Z | BETTY | — | BURKE | 1966-02-08 | — | UNKNOWN | 384-280-6656 | — | ·4250 Mountain View Drive | PHOENIX | AZ | 85086 | N/A | NAVIGATE-HMO |
| PRV | PRV-22946 | 2026-08-14T15:32:59Z | Evelyn | F | Campbell | 5/21/1999 | UHC-88927-95 | — | (374) 766-7952 | evelyn.campbell@yahoo.com | 8276 Spring St | Orlando | FL | 32860 | NULL | MEDICARE-ADV-A |
| PRV | PRV-26888 | 2026-04-12T22:16:38Z | Ana | — | Foster | 1989-09-08 | NULL | — | 13276168309 | NULL | 4119 Union St | Tempe | AZ | 85288-1567·· | UNKNOWN·· | N/A |
| PRV | PRV-24391 | 2026-09-09T23:31:21Z | Paul | — | Pena | Mar 24, 1987 | null | — | null | NULL | 1244 FOREST AVENUE | Eden Prairie | MN | 55334 | N/A | - |
| PRV | PRV-27663 | 2026-09-27T14:25:02Z | CHARLOTTE | H. | HARRISON | 7/9/1984 | UHC-95450-37 | — | 6477884467 | — | 6728 ELM ST | Seattle | WA | 98198 | N/A | -·· |
| PRV | PRV-26214 | 2026-03-07T23:21:14Z | Jeremy | O | Barnes | 25-11-1995 | — | null | N/A | jeremy.barnes@icloud.com | 8573 OCEAN AVE | Chandler | ·AZ | 85261 | -·· | UNKNOWN |
| PRV | PRV-28494 | 2026-08-21T03:33:20Z | Joe | — | Burns | 1984-01-14 | - | N/A | ·639-807-7273 | NULL | 3433 INDIAN SCHOOL ROAD | Houston | ·TX | 77076 | - | UNKNOWN |
| PRV | PRV-28080 | 2026-05-12T11:16:17Z | Isabella | — | Reed | Aug 24, 1987 | ·UHC-76255-44 | — | (768) 660-5539 | NULL | ·8519 Main Street #811 | Gilbert | AZ | 85250·· | — | — |
| PRV | PRV-26030 | 2026-04-24T19:47:07Z | WILLEI | ···· | ·CARLSON | 1985-10-01 | null·· | - | 9242564054 | willie.carlson@aol.com | 9215 Ocean Ave | Minneapolis | MN | 55427 | NULL | navigate-hmo·· |
| PRV | PRV-23507 | 2026-02-04T05:38:41Z | Marilyn | — | Nunez | 1974-08-16 | UHC-13171-62 | — | 489.716.4544 | — | 4466 BROADWAY | JACKSONVILLE | FL | 32235 | UNKNOWN | N/A |
| PRV | PRV-27207 | 2026-07-22T20:52:47Z | ·Samuel | — | Simmnos | 1945-05-25 | ·UHC-47169-69 | — | — | SAMUEL.SIMMONS54@HOTMAIL.COM | 519 GRAND AVE | Orlando | FL | 32885 | — | null |
| PRV | PRV-27303 | 2026-07-15T18:23:22Z | jackie | — | carr | 1959-05-17 | UHC-40230-33·· | UNKNOWN | (529) 603-8209 | jacqueline.carr20@yahoo.com | null | null | — | — | N/A | NULL |
| PRV | PRV-26754 | 2026-03-25T09:19:48Z | Diane | — | Hunt | ·Jul 11, 1974 | — | — | 7882369 | diane.hunt38@hotmail.com | 772 Bayshore Dr | Austin | TX | ···· | NULL | — |
| PRV | PRV-27193 | 2026-08-08T19:50:02Z | SARAH | — | RIVERA | 1991-04-26 | NULL·· | •••-••-5036 | 909.756.6613 | sarah.rivera99@hotmail.com | 9867 Sage Court | Scottsdale | ·AZ | 85224 | null | NAVIGATE-HMO |
| PRV | PRV-24989 | 2026-02-04T02:36:35Z | Jessica Z | — | Rose | Jul 7, 1993 | ·- | •••-••-3037 | ·2272110953 | — | 1250 Oak Street | ATLANTA | Georgia | NULL | UNKNOWN | UNKNOWN |
| PRV | PRV-20401 | 2026-08-14T08:43:21Z | MARILYN | — | LONG | 1982-08-17 | UHC-18585-05 | •••-••-7168 | +1 469 651 5047 | marilyn.long37@outlook.com | 4829 OAK STREET | Atlanta | Georgia | 30357·· | — | NULL |
| PRV | PRV-24297 | 2026-02-17T07:44:16Z | ·Emily | — | Alvarado | 1961-09-28 | UHC-66506-48 | — | N/A | emily.alvarado82@icloud.com | 7977 River Road | Glendale | AZ | 85328 | UNKNOWN·· | null |
| PRV | PRV-27010 | 2026-04-05T11:57:20Z | SANDRA | H | VASQUEZ | Sep 12, 1938 | uhc-61566-57·· | — | 8314744473 | SANDRA.VASQUEZ93@AOL.COM | 5203 Church Street | ·Dallas | TX | null | — | ·null |
| PRV | PRV-24876 | 2026-07-28T06:33:58Z | Kenneth | — | Miller | 1954-07-05 | UHC-52938-21 | UNKNOWN | 280-953-8433 | KENNETH.MILLER@YAHOO.COM | - | — | ···· | NULL | null | ·null |
| PRV | PRV-23214 | 2026-08-16T06:22:31Z | Carter, Eryc | E. | ·· | Dec 19, 1938·· | - | - | ·+1 229 674 4903 | null | 9773 Ocean Avenue | Sacramento | CA | 95837 | null | UNKNOWN |
| PRV | PRV-23845 | 2026-04-09T13:33:42Z | RONALD | — | SNYDER | 1957-07-20 | N/A | ···· | NULL·· | null | 1398 Harbor Blvd·· | Tampa | Florida | UNKNOWN | — | — |
| PRV | PRV-20879 | 2026-09-18T18:05:39Z | MARIA | J.·· | PEREZ | Feb 1, 2000 | - | •••-••-5110 | 5874100049 | N/A | 4692 Grand Avenue | Denver | CO | 80296 | — | UNKNOWN |
| PRV | PRV-24984 | 2026-09-10T06:17:43Z | KATHY | — | HOWARD | 21-01-1986 | NULL | - | 790.776.5295 | — | 3370 Oak Street | Houston | TX | NULL·· | null | UNKNOWN |
| PRV | PRV-23029 | 2026-08-16T09:52:51Z | ·Joyce | — | Roberts | Jan 12, 2007 | — | — | - | null | 2751 JEFFERSON AVE | LOS ANGELES | California | 90046 | null | MEDICARE-ADV-B |
| PRV | PRV-20582 | 2026-05-28T00:05:43Z | beverly | — | ramos | 1944-03-10 | — | — | 918-362-7716 | BEVERLY.RAMOS@YAHOO.COM·· | 5540 Canyon Road | Fresno | CA | null | — | UNKNOWN |
| PRV | PRV-23203 | 2026-02-27T21:26:12Z | pamela | — | jacobs | 1988-02-02 | UHC-33484-83 | — | null | NULL | 3967 Highland Ave | Atlanta | GA | 30382 | — | — |
| PRV | PRV-29015 | 2026-02-09T03:37:09Z | Lawrence | — | Silva | 1974-07-17 | — | — | 208-348-7666 | lawrence.silva72@gmail.com·· | 5164 Canyon Road | FRESNO | CA | 93726-8939 | UNKNOWN | — |
| PRV | PRV-23767 | 2026-05-29T11:55:48Z | stephanie | — | castro | 1984-06-09 | — | — | +1 225 374 7528 | — | 6077 Market St | TUCSON | AZ | 85790 | NULL | CHOICE-PLUS-PPO |
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:49.116Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty