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-28797 | 2026-01-31T07:30:21Z | Julia | ·C | Coleman | 12/01/1958 | UHC9922013 | UNKNOWN | 657-942-2685 | N/A | — | — | null | — | NULL | NULL |
| PRV | PRV-25315 | 2026-09-21T16:57:42Z | Ford, Ann | — | — | 1/9/1943 | UHC0824081 | •••-••-8040 | 3800885 | — | 3659 Ridge Rd | HOUSTON | tx | 77081 | NULL | CHOICE-PLUS-PPO |
| PRV | PRV-23886 | 2026-09-13T18:58:05Z | Scott | — | Rose | 1985-06-01 | ·- | — | 700-872-2117 | ·SCOTT.ROSE56@GMAIL.COM | 954 Canyon Road | San Diego | CA | 92102 | NULL | NAVIGATE-HMO |
| PRV | PRV-21255 | 2026-09-17T00:00:15Z | Smith, Gregory | — | — | 1984-03-20 | N/A | •••-••-6900 | 5117960269 | ···· | 6641 Mesa Dr | SEATTLE | Washington | 98150-1469 | — | — |
| PRV | PRV-21572 | 2026-07-24T23:09:51Z | Sara | — | ·Patel | 03/22/2002 | UHC4872833 | NULL | 767.839.8428 | — | 1780 Baseline Road | Tucson | AZ | 85768 | — | null |
| PRV | PRV-27191 | 2026-03-11T16:30:13Z | Jacob | N | Gonzales | 2003-01-01 | - | •••-••-8266 | 3134028045 | ·UNKNOWN | 3611 Jefferson Avenue | Dallas | TX | 75220 | NULL | NULL |
| PRV | PRV-21237 | 2026-05-07T18:29:34Z | YUKI | — | CARTER | 1955-09-25 | UHC-07808-75 | NULL | 5249797747 | — | 4834 CENTRAL AVE | San Diego | California | 92122 | - | CHOICE-PLUS-PPO |
| PRV | PRV-26189 | 2026-01-04T09:37:00Z | KATHLEEN | U. | CLARK | 08/17/1981 | UHC-96127-46 | null | — | - | 3451 SUNSET BLVD | Orlando | FL | 32860 | N/A | NULL |
| PRV | PRV-20769 | 2026-02-07T01:36:59Z | CHRISTINE | — | HENRY | 26-04-1952 | — | — | 9073872354 | christine.henry@proton.me | 217 Elm Street | Charlotte | NC | ·28262 | - | N/A |
| PRV | PRV-20191 | 2026-02-26T05:04:02Z | JANET | — | HART | 1942-01-26 | UHC-01803-67·· | NULL | — | NULL | 9204 GRAND AVE | TUCSON | AZ | 85701 | null | UNKNOWN |
| PRV | PRV-25867 | 2026-04-19T00:28:46Z | DOUGLAS | — | RICE | 09/12/1968 | UHC7187598 | •••-••-2923 | 8242225479 | N/A | 6348 Pine Dr | Chandler | AZ | 85274 | — | N/A |
| PRV | PRV-28549 | 2026-06-27T04:40:30Z | Carolyn | — | Morris | 1971-09-01 | — | — | 492-492-7674 | NULL | N/A | UNKNOWN | UNKNOWN·· | N/A | — | null |
| PRV | PRV-26210 | 2026-02-04T22:23:55Z | Mason | — | Ortiz | 08-02-2008·· | uhc-43983-84 | — | 8272432942 | — | 9428 Lake View Rd | Tempe | az·· | 85262 | — | N/A |
| PRV | PRV-25170 | 2026-05-18T11:04:44Z | joseph | — | welch | 19991219 | - | UNKNOWN | 4597137279 | joseph.welch53@outlook.com | 4470 APACHE BLVD Apt 25 | SAN ANTONIO | TX | 78275 | UNKNOWN | null |
| PRV | PRV-27107 | 2026-05-31T23:06:26Z | Ruiz, Kevin | — | — | 1971-07-27 | null | null | NULL | null | 5977 DESERT SKY BLVD | Austin | TX | 78758 | — | UNKNOWN |
| PRV | PRV-21499 | 2026-01-21T01:30:46Z | Pierce, Charlotte | D | — | 1952-11-13 | - | •••-••-5056 | null | charlotte.pierce@gmail.com | ·6045 Meadow Lane | San Antonio | TX | 78265 | NULL | - |
| PRV | PRV-25592 | 2026-08-14T01:27:26Z | Henry | — | Jordan | May 2, 1968 | uhc-15997-66 | — | ·361-243-1772 | null | 3607 Ridge Rd | TAMPA | FL | ·33646 | - | null |
| PRV | PRV-26458 | 2026-09-05T02:10:56Z | kayla | — | rike | 1997-11-11 | — | null | 5106258098 | kayla.rice@yahoo.com·· | 3442 Church St | GILBERT | AZ | 85272 | — | N/A |
| PRV | PRV-23735 | 2026-06-11T06:51:50Z | Gerald | M. | Pena | 1978-10-23 | UHC4230414 | UNKNOWN | 15304689264 | gerald.pena92@hotmail.com | 9382 Bayshore Drive | Phoenix | AZ | 85038 | -·· | — |
| PRV | PRV-24759 | 2026-01-12T03:21:58Z | BRENDA | O | WONG | 02/16/52 | UHC-83913-18 | NULL | ·2307310131 | - | 2021 Willow Ct | Miami | FL | 33163 | - | — |
| PRV | PRV-20246 | 2026-03-08T09:54:04Z | Roy | G | Fisher | 02-07-1967 | N/A | — | — | N/A | 323 BASELINE RD | TAMPA | FL | ·33699 | NULL | null |
| PRV | PRV-24545 | 2026-05-19T13:15:38Z | angela | — | willis | 11/27/84 | UHC-64489-28 | — | 389-224-5136 | — | 4786 Hillcrest Road | Seattle | WA | 98195 | - | — |
| PRV | PRV-25731 | 2026-01-06T08:54:55Z | Cheryl | — | Brown | 7/19/2005 | NULL | null | - | — | 872 Willow Court Apt 37 | Las Vegas | NV | 89105 | — | medicare-adv-a |
| PRV | PRV-28964 | 2026-01-01T15:20:45Z | EDWARD | — | ·HICKS | 04/06/1989 | — | — | 6545484363 | — | 3192 Mesa Drive·· | Columbus | OH | 43209 | UNKNOWN | NULL |
| PRV | PRV-29095 | 2026-10-04T14:06:15Z | Jean | X | McCoy | 1963-12-09 | UHC-59244-39 | N/A | 550-737-1454 | jean.mccoy@icloud.com | 343 Maple Avenue | TAMPA | FL | 33600 | — | - |
| PRV | PRV-29310 | 2026-07-23T17:21:01Z | Jeremy | — | Carroll | 19810704 | — | — | 346-330-7896 | jeremy.carroll@outlook.com | ·9384 CHURCH STREET | LAS VEGAS | NV | ·89118 | UNKNOWN | null |
| PRV | PRV-22682 | 2026-10-17T13:39:59Z | Emma | — | Spencer | ·1943-06-15 | UHC-81963-03 | •••-••-0488 | +1 662 694 7590·· | — | 8003 Market Street | Orlando | fl | 32818 | null | UNKNOWN |
| PRV | PRV-24261 | 2026-05-02T18:53:44Z | ·Maria | — | Flores | 1989-02-23 | UHC-15319-51·· | NULL | (690) 629-2295 | null | 7307 Oak Street | Tempe | AZ | 85237-4217 | NULL | N/A |
| PRV | PRV-28047 | 2026-01-17T12:51:39Z | Christian | X. | Holmes | 1951-08-01 | - | NULL | 549-487-5285 | CHRISTIAN.HOLMES94@OUTLOOK.COM | 4067 Highland Avenue | ·Minneapolis | Minnesota | — | N/A | - |
| PRV | PRV-28333 | 2026-07-30T15:34:14Z | ARTHUR | — | RIVERA | 1966-04-15 | null | UNKNOWN | 9749466383 | ARTHUR.RIVERA45@PROTON.ME | 8948 APACHE BLVD | HOUSTON | TX | 77054 | NULL | — |
| PRV | PRV-21455 | 2026-01-12T23:47:13Z | Camila | S | Murphy | 1977-05-27·· | UHC3218512 | — | 764-807-6360 | camila.murphy@outlook.com | 7655 FOREST AVE | Scottsdale | AZ | 85253 | NULL | N/A |
| PRV | PRV-21669 | 2026-01-02T02:58:40Z | ANTHONY | X.·· | FOX | 1958-07-09·· | UHC-20928-76 | N/A | 979-204-9229 | — | 3622 DESERT SKY BLVD #104 | Eden Prairie | MN | 55305 | UNKNOWN | options-ppo |
| PRV | PRV-29103 | 2026-07-03T23:54:56Z | BETTY | S·· | WOODS | 1992-04-01 | N/A | - | (941) 985-7185 | UNKNOWN | 3963 Lincoln Way | Gilbert | AZ | 85214 | UNKNOWN | NULL |
| PRV | PRV-23555 | 2026-03-15T18:00:17Z | RALPH | — | SALAZAR | 1996-04-23 | — | null | 940.380.6927 | - | 1632 Pine Drive | Glendale | AZ | 85335 | — | — |
| PRV | PRV-21315 | 2026-09-02T04:42:57Z | Eugene | — | ·Tucker | 07/13/1989·· | UHC-26271-13 | N/A | (795) 530-7172 | — | 9002 Maple Ave | Glendale | AZ | 85380 | N/A | UNKNOWN |
| PRV | PRV-27078 | 2026-09-12T13:51:10Z | Mark | — | Kelly | 19781013 | UHC2048609 | - | 2392338348 | N/A·· | 9319 MAIN ST | San Diego | California | 92127 | ·null | null |
| PRV | PRV-28172 | 2026-01-08T19:42:30Z | Juan | — | Bell | 2003-09-11 | UHC-85192-55 | •••-••-8012 | 807-310-5821 | juan.bell73@proton.me | 2193 Lake View Rd | Sacramento | CA | 95804 | — | — |
| PRV | PRV-20549 | 2026-04-17T09:45:57Z | Ana | ···· | Garcia | 13-05-2003 | N/A | null | — | — | 7115 Ocean Avenue | DENVER | CO | ·80252 | — | ·SELECT-EPO |
| PRV | PRV-29110 | 2026-10-13T01:56:15Z | YUKI | — | PETERS | 1993-07-02 | - | UNKNOWN | 14433791540 | N/A | 7982 River Rd | Atlanta | GA·· | 30354 | ·N/A | UNKNOWN |
| PRV | PRV-27628 | 2026-03-19T18:58:17Z | Mark | — | Jimenez | 20201116·· | UHC-49159-10 | — | 6236480630 | UNKNOWN | 6303 Oak St #211 | Phoenix | ·AZ | 85071 | — | N/A |
| PRV | PRV-29583 | 2026-01-11T13:13:31Z | Steve | ···· | Marquez | Jan 24, 2002 | ·UHC-20259-21 | null | 877.285.4623·· | ·UNKNOWN | 1142 HILLCREST ROAD | Sacramento | California | 95864 | — | N/A |
| PRV | PRV-25086 | 2026-09-04T08:23:34Z | Tyler | — | Singh | 2002-04-12 | — | N/A·· | (954) 637-5251 | TYLER.SINGH14@AOL.COM | 7305 Valley View Drive | Las Vegas | NV | 89124 | NULL | UNKNOWN |
| PRV | PRV-27111 | 2026-09-15T18:54:31Z | Ana | J | Simpson | 1953-01-28 | UHC-12624-94 | null | 955-955-3953 | N/A | 2287 VALLEY VIEW DRIVE | SAN ANTONIO | TX | 78220 | - | choice-plus-ppo |
| PRV | PRV-28433 | 2026-09-05T11:58:54Z | andrea | — | boyd | 4/15/2001·· | null | — | +1 428 810 2609 | UNKNOWN | 6842 HARBOR BLVD | Columbus | OH | 43208 | UNKNOWN | UNKNOWN |
| PRV | PRV-23708 | 2026-03-21T00:09:33Z | MEGAN | R. | PORTER | ·01/10/75 | UHC-46101-45 | - | — | N/A | 3600 Harbor Blvd | San Antonio | Texas | 78210 | — | options-ppo |
| PRV | PRV-21286 | 2026-04-09T00:16:42Z | NICOLE | — | SMITH | 12/16/57 | UNKNOWN | - | — | — | 7305 Canyon Rd | ·Mesa | AZ | 85226 | — | UNKNOWN |
| PRV | PRV-27293 | 2026-07-05T05:03:50Z | christopher | ···· | contreras | 1951-12-19 | UHC-60511-18 | null | 420-975-3682 | — | 8960 MAIN ST Apt 14 | LAS VEGAS | Nevada | 89176 | — | — |
| PRV | PRV-23147 | 2026-07-13T11:11:04Z | dennis | — | watkins | 1951-30-20 | UHC-79949-24 | •••-••-1435 | 685-639-4199 | ·dennis.watkins@yahoo.com | ·7949 Jefferson Avenue | San Diego | California | 92197 | N/A | — |
| PRV | PRV-23379 | 2026-02-06T09:18:25Z | Anna | — | Edwards | 2007-08-12 | — | - | 5888661153 | anna.edwards@aol.com·· | ·4080 PALM DRIVE | Tucson | AZ | 85782 | null | - |
| PRV | PRV-20070 | 2026-09-04T19:26:38Z | HENRY | — | BROWN | Aug 21, 1998 | UHC-21741-37 | N/A | 7043968916 | N/A | 3158 Indian School Road #376 | MIAMI | FL | 33178-2232 | ···· | — |
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:43.597Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty