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-25808 | 2026-02-03T01:55:36Z | Dylan | — | Robinson | 15-07-2007 | N/A | ·NULL | 5043219582 | ···· | 3396 Maple Avenue | Orlando | FL | 32819·· | — | null |
| PRV | PRV-28980 | 2026-08-02T01:31:51Z | George | — | Williamson | 1953-03-23 | UHC-20277-01 | — | 3152509653 | NULL | N/A | — | — | null | ·UNKNOWN | - |
| PRV | PRV-26225 | 2026-04-17T08:43:26Z | Ethan | T | Bowman | 1986-05-20 | N/A | •••-••-1992 | ·657-966-9526 | ETHAN.BOWMAN90@GMAIL.COM | 1390 MESA DRIVE | San Diego | CA | 92126 | - | MEDICARE-ADV-A |
| PRV | PRV-26868 | 2026-01-15T15:44:25Z | Sean | S | James·· | 19780506 | — | — | 911-275-7314 | ·sean.james@yahoo.com | 7309 Mountain View Drive | Tucson | AZ | 85758-0773 | NULL | - |
| PRV | PRV-26159 | 2026-05-10T00:00:23Z | Evelyn | — | Rios | Aug 16, 1993 | - | — | ·973.873.0967 | UNKNOWN | 5133 Grand Ave | Tucson·· | AZ | 85754 | UNKNOWN | UNKNOWN |
| PRV | PRV-25709 | 2026-05-26T09:01:18Z | Madison | — | Wheeler | 1956-01-01 | N/A | •••-••-0015 | (773) 385-1670 | - | 612 Oak St | JACKSONVILLE | FL | 32210 | — | null |
| PRV | PRV-20685 | 2026-07-21T12:30:48Z | Alan | — | Rice | 1989-01-27 | UHC-29266-34 | null | +1 953 514 2867 | UNKNOWN | 4973 Church Street | TUCSON | AZ | 85721 | NULL | — |
| PRV | PRV-20781 | 2026-01-06T07:16:45Z | SANRDA | K | WALLACE | 1943-05-15 | null | •••-••-1024 | (638) 385-7939 | N/A | 9327 Lincoln Way | Mesa | AZ | ·85228-4799 | — | MEDICARE-ADV-A |
| PRV | PRV-25235 | 2026-09-17T12:52:44Z | Lucia | — | Smith | Mar 23, 1948 | ·null | NULL | 15488750873 | — | 4835 Church Street | Nashville | TN | 37261-3630 | — | - |
| PRV | PRV-28937 | 2026-05-13T13:49:20Z | GEORGE | — | ESTRADA | 1989-06-18 | UHC-50821-50 | ···· | 2235002919 | - | ·3618 Canyon Road | Atlanta·· | GA | 30300-2262 | — | UNKNOWN |
| PRV | PRV-24965 | 2026-03-12T03:23:16Z | DANIELLE·· | — | GARZA | 07-11-1978 | null | UNKNOWN | (964) 863-1091 | — | 2118 Desert Sky Blvd | ·Charlotte | NC | 28241-8918 | null | NULL |
| PRV | PRV-29172 | 2026-07-13T11:10:09Z | Heather | N | Reid | 03/26/1993 | ·NULL | •••-••-3441 | 705-997-2860 | — | 5533 Maple Avenue | Fresno | California·· | 93711 | N/A·· | NAVIGATE-HMO |
| PRV | PRV-25157 | 2026-01-03T05:04:27Z | Natalie·· | — | Miller | 01/18/1995 | UHC-17934-72 | — | (818) 261-1742 | UNKNOWN | 9031 Apache Blvd | ·Scottsdale | AZ | 85210-0799 | — | MEDICARE-ADV-A |
| PRV | PRV-23326 | 2026-04-28T09:51:09Z | Douglas | ···· | Harvey | 1967-01-02 | UHC-07499-94 | N/A | UNKNOWN | N/A | 5111 Broadway | Nashville | TN | 37248 | — | - |
| PRV | PRV-21262 | 2026-01-16T15:49:05Z | Matthew | Y | White | 1973-02-91 | null | null | 478.464.4206 | matthew.white35@icloud.com | 8059 Valley View Drive | GILBERT | AZ | 85224 | null | — |
| PRV | PRV-21521 | 2026-09-10T14:46:38Z | Kevin | N | Harper | Apr 1, 1974 | N/A | •••-••-8102 | 16918473856 | ···· | 8224 Ocean Ave | Charlotte | NC | N/A | N/A | NULL |
| PRV | PRV-23449 | 2026-01-17T16:21:11Z | scott | — | ·cruz | 3/8/1990 | null | •••-••-2410 | +1 429 652 2500 | UNKNOWN | 3854 CEDAR LANE #320·· | Austin | TX | 78740 | null | — |
| PRV | PRV-22253 | 2026-09-25T12:35:12Z | Logan | R. | Burton | UNKNOWN | NULL | N/A | 352-273-1320 | logan.burton69@proton.me | 9374 Canyon Rd | Houston | TX | ·77017 | NULL | NULL·· |
| PRV | PRV-24331 | 2026-07-11T23:21:01Z | jacob | K. | carr | 1995-12-25 | UHC-36540-95 | ···· | +1 736 378 1750 | ·jacob.carr14@aol.com | 473 Grand Avenue·· | SAN ANTONIO | TX | 78203 | — | N/A |
| PRV | PRV-24333 | 2026-02-05T01:49:28Z | Bradley | — | Santos | 1975-08-20 | UNKNOWN | NULL | 18174485674·· | — | ·326 Forest Avenue | San Diego | CA·· | 92144 | — | - |
| PRV | PRV-24301 | 2026-09-10T07:31:56Z | Doris D | — | Watson | 1951-12-05 | UHC-23249-96 | •••-••-5103 | 5264765344 | doris.watson25@hotmail.com | 6258 Forest Ave | Charlotte | NC | 28267-5455 | — | OPTIONS-PPO |
| PRV | PRV-26660 | 2026-06-14T19:14:49Z | Dylan | ···· | Reid | 12/05/43 | ·UHC-30535-48 | •••-••-7085 | 645.547.4498 | ·· | 2056 Mesa Drive | Plano | TX | 75058 | — | ·· |
| PRV | PRV-24967 | 2026-06-09T06:07:38Z | Sandoal, Mark·· | — | ·· | 22-03-2006 | NULL | ···· | ·(962) 937-1862 | ·null | 6181 Mountain View Dr | Houston | TX | 77048-2131 | — | - |
| PRV | PRV-24736 | 2026-03-02T14:16:37Z | Ruth | P. | Herrera | 1956-11-26 | UHC-48021-37 | ·null | (501) 325-9208 | - | 8527 Park Place | Tucson·· | AZ | 85713 | - | — |
| PRV | PRV-23026 | 2026-05-21T21:08:16Z | Herrera, Austin | — | — | 12-09-2002 | UNKNOWN | — | UNKNOWN | ·AUSTIN.HERRERA30@GMAIL.COM | 9279 Park Pl | CHARLOTTE | NC·· | 28268 | null | null |
| PRV | PRV-25317 | 2026-07-30T04:17:08Z | Nicholas | — | Hall | 1938-10-17 | UHC-04610-89 | ·· | 612-702-6918 | — | 5369 BROADWAY | Dallas | TX·· | 75273 | - | UNKNOWN |
| PRV | PRV-23736 | 2026-03-24T06:30:42Z | Gerald | M | Pena | 10/23/78 | UHC-42304-14 | — | N/A | — | 9382 BAYSHORE DRIVE | Phoenix | Arizona | 85038 | — | null |
| PRV | PRV-20101 | 2026-08-02T07:46:12Z | aisha | — | martinez | 1982-02-27 | UHC-74899-52 | UNKNOWN | (721) 246-4143 | — | 6467 Broadway | Orlando | FL | 32886 | — | ···· |
| PRV | PRV-20658 | 2026-07-03T21:46:15Z | Steve | ·· | Mason | 1949-01-20 | UHC-11372-10 | NULL | 7267442355 | stephen.mason@icloud.com | 5037 Ocean Ave | Columbus | OH | 43224·· | - | - |
| PRV | PRV-27970 | 2026-06-06T13:16:51Z | LAUREN | ·· | HOFFMAN | 1940-07-25 | UHC-16769-64 | •••-••-5396 | N/A | — | 1201 Meadow Lane | Jacksonville | FL | 32203 | — | ·UNKNOWN |
| PRV | PRV-25052 | 2026-03-09T17:41:08Z | Gerald | — | Jenkins | ·2007-05-41 | — | — | 522-556-6908 | gerald.jenkins@outlook.com | 9796 Desert Sky Boulevard | CHANDLER | AZ | 85242 | N/A | NULL |
| PRV | PRV-22284 | 2026-03-29T18:35:59Z | Peters, Jacqueline | — | — | 1986-06-16 | ·· | — | +1 436 464 6550 | - | 9069 Forest Avenue | Jacksonville | FL | 32228 | null | N/A |
| PRV | PRV-26737 | 2026-02-22T17:03:15Z | Alan | J. | Wang | 1945-05-20 | - | UNKNOWN | ···· | — | 6676 Spring St | Jacksonville | FL | 32292 | null | - |
| PRV | PRV-28935 | 2026-08-12T19:20:20Z | ·DANIEL | — | ·TURNER | 2006-91-82 | UHC-52643-65 | — | 4509372554 | daniel.turner@outlook.com | — | - | null | — | UNKNOWN | — |
| PRV | PRV-27019 | 2026-04-23T07:11:03Z | Johnson, Yuki | — | — | 7/6/1960 | - | •••-••-2250 | 2568028066 | — | — | ·NULL | N/A | NULL | UNKNOWN | CORE-HMO |
| PRV | PRV-20140 | 2026-03-26T01:45:38Z | JOAN | — | BRYANT | 1958-12-01 | - | UNKNOWN | 525.388.7592 | joan.bryant@gmail.com | ·6477 Spring St | Mesa | Arizona | 85287 | - | — |
| PRV | PRV-22795 | 2026-07-17T08:01:12Z | Debra | — | Mitchell | 7/23/1988 | UHC-96771-59 | — | 388-337-9800 | NULL | 7275 Lincoln Way | LAS VEGAS | NV | — | null | NULL·· |
| PRV | PRV-25950 | 2026-07-06T18:14:09Z | Henry | — | Roberts | 1947-04-50 | — | null | 12096128754 | N/A·· | 709 CAMELBACK RD | Phoenix | ·AZ | 85059 | — | UNKNOWN |
| PRV | PRV-27175 | 2026-03-30T18:11:15Z | JOSEPH | O. | RICHARDS | 8/11/1959 | null·· | - | 478-882-7316 | — | 821 Broadway | Glendale | AZ | 85333 | - | - |
| PRV | PRV-23383 | 2026-05-30T00:53:40Z | ETHAN | — | TAYLOR | 1961-01-06 | UHC-92353-02 | — | (444) 837-5219 | - | 6658 Highland Avenue | AUSTIN | TX | 78739 | UNKNOWN | NULL |
| PRV | PRV-25440 | 2026-10-11T04:57:31Z | Bobby | — | Wright | Apr 3, 1995 | N/A | UNKNOWN | 484-655-6424 | bobby.wright@outlook.com | 8097 CENTRAL AVE | EDEN PRAIRIE | MN·· | null | null | SELECT-EPO |
| PRV | PRV-28922 | 2026-05-15T13:38:26Z | Billy | — | Wnag | 12/17/52 | N/A | — | (283) 871-0778 | NULL | 9796 Canyon Road #922 | San Antonio | TX | 78246 | N/A | ·· |
| PRV | PRV-24340 | 2026-05-29T15:44:59Z | ·Wei | — | Cooper | 1944-01-22 | — | NULL | (550) 683-3544 | wei.cooper@proton.me | 9506 Sunset Blvd #218 | Orlando | FL | 32808 | N/A | SELECT-EPO |
| PRV | PRV-20316 | 2026-08-13T19:52:51Z | Juan | — | Thompson | 12/24/63 | — | N/A | 6842047158 | UNKNOWN | — | — | — | — | — | - |
| PRV | PRV-21234 | 2026-06-17T19:08:56Z | raymond | H | hanson | 19900520 | UHC-40217-49 | •••-••-6383 | null | — | 3321 Grand Ave | Atlanta | GA | 30388 | UNKNOWN | — |
| PRV | PRV-22920 | 2026-05-01T07:54:09Z | BILLY | ·F. | MENDEZ | ·Dec 26, 1978 | — | UNKNOWN | 2209619 | — | 3385 Desert Sky Blvd·· | Chandler | Arizona | UNKNOWN | UNKNOWN | ···· |
| PRV | PRV-26982 | 2026-06-11T17:24:32Z | ASHLEY | — | WONG | 1981-05-08 | UHC-65191-42 | - | 4245107653 | ashley.wong@icloud.com | 3178 Baseline Road | HOUSTON | Texas | 77083·· | NULL | — |
| PRV | PRV-25049 | 2026-08-20T23:00:19Z | Juan | — | McCoy | 1958-08-17 | UHC6248662 | - | N/A | JUAN.MCCOY@AOL.COM | 8094 Market Street | Chandler | Arizona | 85237-7851 | - | MEDICARE-ADV-A·· |
| PRV | PRV-21948 | 2026-08-21T17:55:20Z | terry | — | kelly | Feb 1, 1981 | UHC-39031-08 | — | UNKNOWN | — | 2627 Highland Avenue | Phoenix | AZ·· | 85077 | — | — |
| PRV | PRV-28593 | 2026-05-16T05:25:34Z | Joseph | — | Riley | 11/28/1974 | — | — | UNKNOWN·· | N/A | 6915 HILLCREST RD | Gilbert·· | AZ | 85223 | - | - |
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:56.160Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty