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-20221 | 2026-08-05T02:18:34Z | ·Andrea | — | Collins | 1997-07-26 | UNKNOWN | NULL | 643.942.1120 | ANDREA.COLLINS@OUTLOOK.COM | 7314 Mountain View Drive | ·Houston | ·TX | 77074 | — | - |
| PRV | PRV-23924 | 2026-06-01T01:09:32Z | Myers, Brian | I | — | 1996-02-11 | NULL | NULL | 277.577.4358 | brian.myers@icloud.com | 9050 MESA DR | TEMPE | AZ | 85221 | N/A | N/A |
| PRV | PRV-25655 | 2026-03-04T05:47:37Z | ahmed | — | sanders | 10/26/1960 | UHC-07701-06 | — | 4209977132 | — | 2821 Sunset Boulevard | Sacramento | CA | 95877 | UNKNOWN | — |
| PRV | PRV-25407 | 2026-09-29T19:42:12Z | Billy | T | Ryan | 6/1/1941·· | — | null | 571.774.4679 | null | 9764 UNION STREET | Scottsdale | AZ | ·85241 | ·- | ·N/A |
| PRV | PRV-23672 | 2026-02-14T17:00:06Z | carlos | — | hunt | 1971-12-18 | — | — | (317) 598-1099 | CARLOS.HUNT@GMAIL.COM | 1181 DESERT SKY BOULEVARD | San Diego | CA | null | - | UNKNOWN |
| PRV | PRV-26518 | 2026-05-04T16:19:36Z | MATTHEW | — | ·SCHMIDT | 1990-04-09 | UNKNOWN | - | +1 787 696 0213 | UNKNOWN | 3401 Pine Drive | Glendale | AZ | 85381 | NULL | — |
| PRV | PRV-20413 | 2026-04-28T22:07:18Z | ·CHRISTOPHER | — | ESPINOZA | 09/18/1994 | UHC-74983-53 | •••-••-0053 | 820-883-1326 | NULL | 5093 Lake View Road | Eden Prairie·· | MN | 55378 | — | - |
| PRV | PRV-21374 | 2026-09-13T03:42:32Z | PATRICIA·· | ···· | SIMMONS | 1963-12-19 | — | •••-••-2151 | (684) 293-5793 | — | 320 Sage Ct | Los Angeles | CA | 90029 | ···· | - |
| PRV | PRV-23775 | 2026-05-27T12:27:15Z | JUUDY·· | — | STEVENS | 1962-08-11 | UHC-82487-20 | ·· | 4019688917 | NULL | 3652 PALM DRIVE | Los Angeles | CA | 90041 | - | MEDICARE-ADV-A |
| PRV | PRV-23849 | 2026-02-17T18:53:38Z | Walter | F. | Bowmna·· | 11/01/54 | null | - | (517) 490-6631 | UNKNOWN | NULL | — | NULL | N/A | null | N/A |
| PRV | PRV-26820 | 2026-03-16T02:55:48Z | Watkins | N | Amber | 1976-10-16 | ·UHC-11916-11 | N/A | 295-461-0659 | — | 9383 BASELINE RD | Tempe | Arizona·· | 85292-7594 | — | — |
| PRV | PRV-27820 | 2026-03-19T15:53:12Z | Steven | — | Spencr | 1937-06-20 | — | •••-••-7859 | (325) 918-5673 | steven.spencer77@aol.com | 7438 Cedar Lane | SAN DIEGO | CA | ·92179 | null | — |
| PRV | PRV-21180 | 2026-07-23T23:28:57Z | Nicholas | — | Crawford | 02-03-2005 | UHC-87530-99 | •••-••-8352 | (949) 681-4784 | nicholas.crawford@hotmail.com | 8939 PALM DRIVE | Houston | TX | 77065 | null | MEDICARE-ADV-B |
| PRV | PRV-21330 | 2026-08-13T09:02:49Z | rebecca | — | ·munoz | 19580921 | — | •••-••-9541 | 348-573-6847 | — | 8264 HILLCREST ROAD #969 | CHARLOTTE | NC | 28260 | ·· | N/A |
| PRV | PRV-25637 | 2026-07-21T18:10:45Z | Lauren | L·· | Washington | 1965-10-28 | UHC-74755-05 | NULL | 8856518679 | - | — | - | — | ·- | NULL | — |
| PRV | PRV-20738 | 2026-03-26T07:51:30Z | BRUCE | — | MYERS | 7/10/1997 | N/A | — | (623) 978-7690 | bruce.myers@yahoo.com | 162 Ridge Road | San Antonio | TX | 78202 | — | — |
| PRV | PRV-22469 | 2026-08-10T17:47:08Z | Pamela | — | Gardner | 1964-03-03 | null | NULL | (302) 821-4106 | - | NULL | N/A | — | — | - | — |
| PRV | PRV-28602 | 2026-08-11T11:17:51Z | Alan | — | Contreras·· | 1/11/1948 | UHC-91768-91 | UNKNOWN | 15119444560 | alan.contreras69@icloud.com | N/A·· | - | UNKNOWN | NULL | N/A | null |
| PRV | PRV-23864 | 2026-07-07T13:23:21Z | hannah | — | nelson | 1960-11-08 | NULL | •••-••-6292 | N/A | — | ·8044 Grand Ave | Tucson | AZ | 85723·· | - | - |
| PRV | PRV-28371 | 2026-04-26T20:05:59Z | RANDY | E | CARPENTER | 11/13/1977 | — | — | (208) 603-3139 | RANDY.CARPENTER57@HOTMAIL.COM | null | N/A | NULL | — | - | N/A |
| PRV | PRV-22901 | 2026-08-01T17:07:42Z | HENRY | T | ESPINOZA | Jul 26, 1959 | — | •••-••-0232 | 6701432 | henry.espinoza23@outlook.com | 1745 Church St·· | Austin | TX | null | null | - |
| PRV | PRV-23207 | 2026-09-30T12:24:30Z | ALN·· | ·· | MORGAN | 1976-06-02 | ·UNKNOWN | N/A | (284) 511-6754 | N/A·· | 9755 ELM ST | Glendale | AZ | 85398-6767 | UNKNOWN | UNKNOWN |
| PRV | PRV-25162 | 2026-09-26T12:57:39Z | ROBERT | — | SOTO | 1978-02-19·· | NULL | NULL | N/A | robert.soto97@yahoo.com | ···· | - | — | N/A | — | — |
| PRV | PRV-20291 | 2026-10-03T04:16:54Z | CHRISTIAN | I | WILLIAMSON | 8/5/1974·· | UHC-01208-77 | null | (664) 670-2564 | - | 3455 Oak Street·· | Chandler | AZ | 85285 | — | null |
| PRV | PRV-26109 | 2026-01-31T14:48:58Z | CHRISTOPHER | — | RUSSELL | May 19, 1958 | null | — | (767) 888-0764 | CHRISTOPHER.RUSSELL@HOTMAIL.COM | — | — | — | N/A | null | N/A |
| PRV | PRV-23684 | 2026-06-27T06:46:56Z | Jack | W | Ryan | Aug 5, 1945 | N/A | — | (827) 688-6418 | ···· | 6718 CHURCH STREET | Scottsdale | ·AZ | 85251 | — | — |
| PRV | PRV-20208 | 2026-02-17T23:43:28Z | Crawford, Alice | K | — | 1953-10-20 | UHC-75258-47 | •••-••-2674 | (819) 744-5112 | NULL | — | N/A | ·null | NULL·· | — | — |
| PRV | PRV-22268 | 2026-03-31T21:27:13Z | Judith | — | Perry | 8/23/1979 | UHC-06397-90 | — | 398-587-2713 | N/A·· | 6815 Canyon Road | Miami | FL·· | 33191 | UNKNOWN | — |
| PRV | PRV-28272 | 2026-02-26T18:47:45Z | timothy | L·· | walker | 09/04/1987 | UHC-34814-20 | NULL | 583-302-8834·· | null | 9048 Washington St | PLANO | TX | 75044 | ·UNKNOWN | - |
| PRV | PRV-25998 | 2026-08-10T20:47:07Z | Emma | — | Pena | 15-12-2007·· | — | UNKNOWN·· | 2135477737 | UNKNOWN·· | ·1716 Sunset Blvd | Austin | TX | 78701 | ·· | options-ppo |
| PRV | PRV-21050 | 2026-07-28T01:52:29Z | DIANE | Y | ROBINSON | 05/24/40 | UNKNOWN | — | (456) 335-8471 | ·null | 6707 Spring Street | Orlando | FL | 32806 | — | NULL |
| PRV | PRV-23720 | 2026-03-31T11:42:55Z | JUSTIN | — | LAWRENCE | 06/12/1945·· | UHC-56970-09 | •••-••-2110 | null | — | 1593 Spring Street | Miami | Florida | NULL | — | ·NULL |
| PRV | PRV-23104 | 2026-05-06T19:53:20Z | Amed | H. | Wells | 19880211·· | NULL | null | — | NULL | 7072 Central Ave | Columbus | OH | 43298 | - | — |
| PRV | PRV-21695 | 2026-09-17T15:12:41Z | Lauren | — | Rivera | 11/07/62 | UHC-27701-96 | •••-••-8047 | 3962587334 | null | 3282 Canyon Rd | Austin | TX | 78734 | null | N/A |
| PRV | PRV-23021 | 2026-08-30T08:36:40Z | Collins, Cheryl | — | — | 04/14/92 | — | ···· | 478-325-1355·· | — | 5401 Church Street #246 | Los Angeles | CA | — | — | - |
| PRV | PRV-24337 | 2026-10-03T18:13:32Z | RUTH | N. | HICKS | 1/27/2006 | NULL·· | — | N/A | — | 4785 Pine Dr·· | ·Tampa | ·FL | 33616-7639 | null | — |
| PRV | PRV-25810 | 2026-02-12T13:10:57Z | ANNA | — | FOWLER | 2001-05-23 | UHC-90627-10 | •••-••-5286 | NULL | UNKNOWN | 4001 Harbor Boulevard | Nashville·· | TN | 37245 | - | MEDICARE-ADV-B |
| PRV | PRV-22141 | 2026-05-08T02:25:17Z | CARLOS | L. | MONTGOMERY | 05/18/56 | NULL·· | - | 343-411-7803 | — | 9412 Broadway | Austin | TX | 78724 | — | UNKNOWN |
| PRV | PRV-21274 | 2026-05-18T10:35:51Z | BRANDON | — | SALAZAR | 19650121 | UNKNOWN | •••-••-2297 | 7157691691 | brandon.salazar95@icloud.com | 4338 RIVER ROAD | Mesa | az | ·85268 | — | OPTIONS-PPO |
| PRV | PRV-25006 | 2026-04-26T03:18:38Z | Kayla | — | Ellis | 22-06-1953 | — | •••-••-8808 | 600-790-9574 | — | 3107 Union St | ATLANTA | GA | 30353·· | ·NULL | NULL |
| PRV | PRV-28561 | 2026-08-30T01:27:29Z | Lisa | — | Taylor | 1983-09-14 | UHC-20686-86 | - | 2418473837 | null | 1069 BASELINE ROAD | Eden Prairie | MN | 55389 | - | — |
| PRV | PRV-25164 | 2026-08-24T12:59:46Z | Jean | — | Reed | 1949-09-15 | — | •••-••-4126 | 3579207839 | JEAN.REED@ICLOUD.COM·· | 5322 Sage Court Apt 38 | Fresno | CA | 93714 | - | NULL |
| PRV | PRV-27821 | 2026-06-02T04:51:02Z | STEPHANEI | J | MOORE | 07/04/78 | UHC-96480-12 | UNKNOWN | 5987382091 | stephanie.moore@gmail.com | 4646 Ridge Rd | San Antonio | TX | 78256-9403 | NULL | — |
| PRV | PRV-28685 | 2026-06-28T14:30:26Z | Christine | — | Moore | ·06/10/54 | NULL | — | (924) 427-5063 | — | 8018 MAPLE AVENUE | Scottsdale | AZ·· | 85267 | UNKNOWN | ·- |
| PRV | PRV-26062 | 2026-08-22T19:12:31Z | GLORIA | ·V | JOHNSON | 1987-03-02 | UHC-44130-97·· | — | ·16965214868 | gloria.johnson@proton.me | 3218 Hillcrest Road #876·· | Orlando | FL | 32826 | NULL | — |
| PRV | PRV-22388 | 2026-02-27T07:16:43Z | shirlay | — | welch | 1944-11-10 | ···· | — | 5096102614 | N/A | 5380 Washington St | MIAMI | Florida | 33147 | — | NAVIGATE-HMO |
| PRV | PRV-29060 | 2026-09-09T16:11:20Z | Mariana | ···· | Vargas·· | 1944-09-26 | UHC-68701-44 | — | 888-446-0464 | NULL | ·4191 Willow Court | Los Angeles | ca | 90062 | N/A | — |
| PRV | PRV-21195 | 2026-05-06T15:19:59Z | Judith | — | Cruz·· | Dec 27, 1945 | UNKNOWN | •••-••-6737 | 2975241766 | judith.cruz34@gmail.com | 2981 Highland Avenue | Miami | FL | 33173 | null | - |
| PRV | PRV-25200 | 2026-07-29T08:01:44Z | HENRY | — | JACOBS | 1983-09-26 | N/A | - | 3334796139 | — | 9810 Palm Drive | Houston·· | TX·· | 77083 | NULL | MEDICARE-ADV-B |
| PRV | PRV-24157 | 2026-06-22T10:56:36Z | Huughes, Lisa | — | — | 2005-08-28 | — | null | (433) 556-3172 | lisa.hughes@yahoo.com·· | 3596 MAIN STREET #498 | Las Vegas | NV | 89178 | NULL·· | N/A |
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:43:03.764Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty