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-24514 | 2026-08-22T10:59:31Z | Rivera, Brandon | — | — | 1991-04-07 | UHC-19255-33 | - | 773-552-1965 | — | 5041 Jefferson Ave | ·Glendale | AZ | 85328 | — | null |
| PRV | PRV-28532 | 2026-10-06T16:05:22Z | fatima | X | duncan | 26-09-2001 | - | — | (523) 651-3541 | - | 2074 CEDAR LANE | Los Angeles | California | 90070 | N/A | null |
| PRV | PRV-21456 | 2026-06-28T04:17:18Z | Richard | — | Washington | 1988-08-26 | UHC-88068-66 | •••-••-0154 | (374) 751-1524 | — | 8525 Baseline Rd | Eden Prairie | MN | 55344 | — | NULL |
| PRV | PRV-21324 | 2026-08-06T01:01:46Z | ·Karen | M | Campbell·· | 1967-07-12 | — | - | 3704473086 | KAREN.CAMPBELL49@OUTLOOK.COM | 3013 Market St | San Antonio | TX | ·78271 | UNKNOWN | ···· |
| PRV | PRV-26106 | 2026-08-26T09:09:46Z | Ross, Stephanie | — | — | Feb 27, 1998 | null | - | 437-505-8933 | — | 504 SUNSET BLVD | Austin·· | TX·· | 78795 | N/A | — |
| PRV | PRV-27474 | 2026-09-21T01:39:05Z | Evelyn | — | Meddina | 1964-03-05·· | UHC-73118-36 | N/A | (773) 826-0718 | evelyn.medina27@hotmail.com | — | UNKNOWN | — | — | — | — |
| PRV | PRV-26118 | 2026-04-15T13:59:57Z | Li, Donald U | — | — | 1938-05-07 | UHC-27526-41·· | N/A | — | — | 3587 Desert Sky Blvd | Phoenix | AZ | 85048 | null | CORE-HMO |
| PRV | PRV-25555 | 2026-02-01T14:30:14Z | — | K | — | 03/24/01 | UHC-80415-30 | — | 578.941.6159 | null | NULL | — | — | NULL | UNKNOWN·· | NULL |
| PRV | PRV-25608 | 2026-04-24T10:22:20Z | Rachel | — | Jimenez | 19640508 | UHC-73124-86 | UNKNOWN | +1 474 308 9998 | N/A·· | 7348 Harbor Blvd | CHARLOTTE | NC | 28224 | N/A | UNKNOWN |
| PRV | PRV-28871 | 2026-02-11T21:42:05Z | JEREMY | — | HUNT | 1955-08-12 | UHC-59297-43 | N/A | 612-285-7965·· | null | null | UNKNOWN | - | UNKNOWN | null | NULL |
| PRV | PRV-25031 | 2026-05-31T23:53:40Z | Joe | — | Powell | Jul 20, 1960 | UHC-80342-40 | N/A | ···· | joe.powell@hotmail.com | 5587 HARBOR BLVD | Tampa | FL | 33642 | N/A | null |
| PRV | PRV-23453 | 2026-03-20T12:36:49Z | Nicole | — | Vasquez | 02/03/51 | ·UHC-78209-60 | UNKNOWN | 798-406-8344 | UNKNOWN | 1687 Mesa Drive | Scottsdale | az | 85258 | UNKNOWN | — |
| PRV | PRV-27060 | 2026-01-12T21:18:49Z | Cynthia | N. | Elliott | 11/12/2006 | null | NULL | (315) 833-0590 | - | 9783 Grand Avenue | ·Scottsdale | AZ | null | N/A | — |
| PRV | PRV-20593 | 2026-04-15T01:42:08Z | NATALIE | H | MORGAN | 1939-06-07 | UHC-30565-43 | - | 2799938126 | UNKNOWN | 902 Broadway | Tucson | AZ | 85721 | N/A | CHOICE-PLUS-PPO |
| PRV | PRV-27498 | 2026-02-09T18:45:28Z | ELISABETH | — | WEAVER | 19850709 | UHC-21629-88 | — | 5016577 | — | 2357 Ocean Ave | San Antonio | TX | 78239 | — | NULL |
| PRV | PRV-21212 | 2026-04-25T01:27:38Z | CHARLOTTE | — | DUNN | 1987-10-01 | — | UNKNOWN | (587) 434-1669 | — | 6874 BROADWAY | Denver | CO | 80250 | — | — |
| PRV | PRV-26005 | 2026-07-12T16:54:13Z | steven | — | espinoza | 1947-08-14 | UHC-18936-71 | null | 8096724689 | — | 116 LAKE VIEW RD | Dallas | TX | 75225 | — | - |
| PRV | PRV-25433 | 2026-05-16T08:45:49Z | Bobby | — | Rodriguez | 1967-01-04 | UHC-12282-59 | - | 4503408 | — | 2655 BAYSHORE DRIVE Apt 13 | Phoenix | AZ | 85052-9810 | — | — |
| PRV | PRV-21414 | 2026-07-23T02:25:30Z | AHMED | — | VAZQUEZ | 08/09/55 | UHC-66130-93·· | - | 914-254-1272 | NULL | 6035 Oak Street | Fresno | CA | 93723 | — | NULL |
| PRV | PRV-24847 | 2026-10-10T13:15:03Z | Bettty B | — | Soto | 2008-12-20 | N/A | •••-••-6594 | (499) 592-5720 | betty.soto@gmail.com·· | 2184 SAGE COURT | JACKSONVILLE | FL | 32234 | - | N/A |
| PRV | PRV-20050 | 2026-09-21T13:42:39Z | austin·· | ·· | hart | 1961-05-21 | N/A | •••-••-8701 | NULL | null | 6027 APACHE BLVD | Mesa | AZ | 85259 | — | ·· |
| PRV | PRV-24891 | 2026-05-05T09:30:20Z | Victoria | — | Taylor | 19841203 | NULL | null | 594.403.5375 | UNKNOWN | 5710 HARBOR BOULEVARD·· | San Diego | CA | 92190·· | null | - |
| PRV | PRV-26616 | 2026-03-14T23:47:29Z | SHARON | ·· | CAMPBELL | 1956-06-07 | UHC-06772-04 | — | 446-504-1093 | SHARON.CAMPBELL@PROTON.ME | 878 Canyon Rd | TUCSON | AZ | 85718 | — | N/A |
| PRV | PRV-27669 | 2026-08-16T19:28:25Z | christopher | — | mendoza | 1986-10-10 | — | — | 3393631130 | - | 1970 CENTRAL AVE | Nashville | Tennessee·· | 37268 | ·· | MEDICARE-ADV-A |
| PRV | PRV-26897 | 2026-02-14T02:24:25Z | Patel, Barbara | O. | — | 1957-02-05 | - | •••-••-6215 | 210-812-1415 | null | 6265 BAYSHORE DR | Houston | TX | ·77093 | UNKNOWN | — |
| PRV | PRV-21892 | 2026-02-08T23:41:51Z | Albert Q. | — | Kennedy | 12/05/45 | UHC-89191-01 | NULL | (290) 839-2311 | albert.kennedy@hotmail.com | null | ·N/A | null | null | - | CHOICE-PLUS-PPO |
| PRV | PRV-23183 | 2026-02-18T13:41:07Z | ERIC | — | ·PIERCE | 08/25/1955 | N/A | N/A | 828.658.8563 | ERIC.PIERCE10@YAHOO.COM | 8456 Canyon Road | Gilbert | AZ·· | 85279·· | — | — |
| PRV | PRV-28106 | 2026-05-12T02:05:52Z | Alexis | — | Bennett | 1968-06-04 | N/A | — | 967-433-3853 | null | 8577 BROADWAY | SACRAMENTO | CA | 95882 | null | -·· |
| PRV | PRV-20868 | 2026-07-21T22:15:56Z | Kathleen | O | Gibson | 2007-07-19 | UHC-89929-38 | — | 335-247-3029 | kathleen.gibson@gmail.com·· | 4256 WASHINGTON STREET | Seattle | WA | 98147-4550 | ·NULL | - |
| PRV | PRV-20411 | 2026-04-10T10:59:59Z | JOAN | ·· | NUNEZ | 23-10-2001 | UNKNOWN | null·· | 650-779-8099·· | — | ·6137 Mountain View Dr | Las Vegas | NV | 89168 | N/A·· | — |
| PRV | PRV-24456 | 2026-05-21T19:41:49Z | Logan | S | Romero | 1948-08-03 | UHC-29691-98 | ·NULL | (216) 338-6986 | logan.romero3@outlook.com | 3367 Central Avenue | LOS ANGELES | CA | 90020-5875 | NULL | - |
| PRV | PRV-23062 | 2026-01-10T09:10:03Z | Carol | — | Hart | 5/28/1945 | ···· | NULL | 381-242-0123 | null | 7981 PINE DR Apt 13 | AUSTIN | Texas | 78789 | — | — |
| PRV | PRV-28559 | 2026-09-13T15:51:01Z | Kathy | — | Le | 1987-06-08 | — | •••-••-6622 | 9124584030 | UNKNOWN | 8323 Bayshore Dr | Tucson | AZ | 85782-2695 | UNKNOWN | NULL |
| PRV | PRV-26901 | 2026-08-21T05:40:49Z | ERIC | ···· | BOWMAN | 1972-09-14 | null | — | 6125890 | N/A | 6475 PINE DR | Orlando | FL | 32845 | NULL | UNKNOWN |
| PRV | PRV-21917 | 2026-02-20T22:47:22Z | alan | — | montgomery | 04/12/79 | NULL | — | NULL | alan.montgomery85@aol.com | 8755 Jefferson Ave | ·COLUMBUS | OH | 43287 | UNKNOWN·· | — |
| PRV | PRV-29425 | 2026-02-26T08:37:39Z | Judy | ···· | Morrison | 1964-06-15 | UHC-54028-49 | N/A | 7017695054 | — | 9692 Main St | AUSTIN | TX | 78753 | — | — |
| PRV | PRV-22131 | 2026-02-26T17:44:58Z | henry | — | roberts | ·Oct 21, 1969 | ·- | — | +1 685 607 8523 | — | 7955 Sage Ct #199 | Chandler | Arizona | 85285 | NULL | - |
| PRV | PRV-20143 | 2026-06-26T04:58:19Z | SANTIAGO | ···· | PETERS | 1999-11-21 | UHC-16126-85 | null | — | — | 8248 WILLOW CT | San Antonio | Texas | 78210 | UNKNOWN | null |
| PRV | PRV-28888 | 2026-07-29T21:17:51Z | Cheryl | — | Maldonado | 1999-06-02 | UHC-31630-48 | - | — | NULL | 2734 Hillcrest Road | JACKSONVILLE | FL | 32216-3294 | UNKNOWN | - |
| PRV | PRV-23930 | 2026-01-06T06:19:27Z | Eugene | ·· | Hanson | 1955-06-03 | UHC-51392-83 | NULL | 7994356982 | eugene.hanson@outlook.com | 4699 Washington Street | ATLANTA | Georgia | 30324 | — | — |
| PRV | PRV-24905 | 2026-05-22T01:20:54Z | YUKI | — | WARD | 1948-12-23 | NULL | — | +1 377 710 8627 | yuki.ward@hotmail.com | 4400 Central Ave | Miami | FL | 33132 | UNKNOWN | — |
| PRV | PRV-22683 | 2026-05-26T10:15:59Z | Zachary | O. | ·Nichols | 1973-09-11 | ·UHC-39053-23 | N/A | 6344942060 | ZACHARY.NICHOLS92@AOL.COM | 7771 HARBOR BOULEVARD | Atlanta | GA | 30378 | UNKNOWN | — |
| PRV | PRV-27544 | 2026-01-27T07:19:15Z | Aaron | — | Nnez | 1987-02-13 | NULL | N/A | 4428633 | — | 4931 Market Street | Tucson | AZ | 85739 | — | — |
| PRV | PRV-29226 | 2026-02-03T16:10:25Z | LARRY | — | WONG | 10/02/2001 | UHC-68223-92 | null | ·738-589-5507 | — | ·5452 Ridge Rd | ORLANDO·· | ·FL | 32886 | — | CHOICE-PLUS-PPO |
| PRV | PRV-20869 | 2026-02-08T20:49:56Z | KATHLEEN | — | ·GIBSON | 2007-07-19 | N/A | •••-••-6058 | 3352473029 | N/A | ·- | UNKNOWN | — | — | UNKNOWN | N/A |
| PRV | PRV-23971 | 2026-07-19T11:29:16Z | ·Ryan | V | Harvey | 1976-06-26 | UHC-08814-34 | - | — | ryan.harvey46@outlook.com | 5411 Harbor Blvd #701 | Mesa | AZ | 85272 | — | — |
| PRV | PRV-20074 | 2026-04-03T09:39:13Z | MADISON | — | ·BOYD | 1997-10-09 | UNKNOWN | NULL | 495-763-1430 | madison.boyd@yahoo.com | 5761 Central Ave | Nashville | Tennessee | ·37230 | null·· | NULL |
| PRV | PRV-27486 | 2026-04-23T08:10:46Z | Paul | — | Cole | 1987-03-25 | — | null | (390) 291-9357 | paul.cole@proton.me | 5765 INDIAN SCHOOL ROAD | Tempe | AZ | 85246-2108 | - | NULL |
| PRV | PRV-28673 | 2026-03-29T17:54:15Z | Albert | ···· | Richardson | 1959-07-23 | UHC-60875-14 | ·UNKNOWN | ···· | N/A | N/A | — | null | N/A | — | NULL |
| PRV | PRV-29069 | 2026-05-11T05:12:15Z | Lee, Natan | G | — | 1995-03-24 | N/A | — | 15087645433 | null | ·9123 Desert Sky Blvd #870 | Plano | TX | 75098 | — | 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.057Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty