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-20144 | 2026-04-11T07:22:07Z | Santiago | — | Peters | 1999-11-21 | UHC-16126-85 | - | 9094043613 | — | 8248 Willow Ct | San Antonio | ·tx | 78210 | N/A | MEDICARE-ADV-B |
| PRV | PRV-28995 | 2026-08-01T20:02:04Z | HIROSHI | G | WRIGHT | 1959-12-12 | UHC-21577-09 | NULL | (482) 963-8739 | ·· | 2169 Main St | Chandler | AZ | 85272 | N/A | CORE-HMO |
| PRV | PRV-28349 | 2026-05-01T15:43:49Z | Shirley | — | Gordon | 1945-10-15 | UHC-16318-59 | — | — | — | 734 Park Pl | Los Angeles·· | CA | 90082 | UNKNOWN | CHOICE-PLUS-PPO |
| PRV | PRV-25163 | 2026-01-19T01:28:44Z | Caimla | K | Robertson | ·1939-04-07 | UHC-95495-01 | null | 9267903067 | null | 7795 Elm St | Plano | TX | 75010-2336 | UNKNOWN | null |
| PRV | PRV-25258 | 2026-10-05T17:45:39Z | Robert | — | Palmer | 1977-11-13 | null | •••-••-6008 | ·(890) 322-1400 | NULL | 2089 Ocean Ave | Miami | Florida | — | — | — |
| PRV | PRV-25348 | 2026-08-16T08:14:37Z | Jordan | — | Perry | 1955-11-17 | UHC7761754 | •••-••-5501 | 16209529652 | jordan.perry85@hotmail.com·· | 6145 SUNSET BOULEVARD | PHOENIX·· | AZ | 85072 | — | MEDICARE-ADV-B |
| PRV | PRV-24338 | 2026-09-13T03:53:01Z | Pamela | K. | Butler | 11/10/1995 | UHC-80952-81 | — | ·975-740-3631 | PAMELA.BUTLER3@PROTON.ME·· | 8619 Spring St | Miami | ·Florida | 33198 | NULL | null |
| PRV | PRV-29548 | 2026-04-29T05:09:58Z | AMBER | ···· | GRIFFIN | 1939-12-09 | — | — | +1 406 891 4367 | amber.griffin@icloud.com | 6088 Desert Sky Boulevard | San Diego | CA | 92193 | - | null |
| PRV | PRV-25100 | 2026-01-25T09:23:52Z | Willie | C | Elliott | 01/20/43 | UHC-22957-69 | •••-••-6820 | — | willie.elliott@yahoo.com | 9782 RIDGE RD·· | Tempe | Arizona | 85289 | — | null |
| PRV | PRV-25826 | 2026-08-13T12:39:31Z | Mason | — | Wells | 2/13/2004 | UHC-76605-77 | - | +1 282 241 4322 | mason.wells@yahoo.com | — | — | — | — | N/A | — |
| PRV | PRV-24312 | 2026-09-15T14:55:12Z | Emily·· | — | Matthews | 1969-03-01 | UHC-29986-98 | — | UNKNOWN | NULL | 7506 Indian School Road | Houston | TX | 77060 | null | N/A |
| PRV | PRV-26155 | 2026-05-28T15:11:21Z | peter·· | — | arnold | 1996-09-19 | - | null·· | 634-720-8004 | — | 3662 Ocean Avenue | Charlotte·· | ·NC | 28282 | null | ···· |
| PRV | PRV-23163 | 2026-04-14T02:45:40Z | ·Maria A | — | Vazquez | 1980-02-04 | — | - | 247-836-4773 | -·· | 8005 Mountain View Dr | Plano | TX | 75021 | NULL | UNKNOWN |
| PRV | PRV-28298 | 2026-06-13T06:12:40Z | MARCUS | Q | HARVEY | 1952-12-13 | — | - | ·· | ·N/A | 2799 Bayshore Drive | Charlotte | NC | ·28212 | null | — |
| PRV | PRV-24748 | 2026-06-11T02:28:26Z | Sharon | A. | Valdez | 1983-05-27 | UHC-61180-43 | NULL | 827-976-2605 | NULL | ·5645 HIGHLAND AVENUE | Phoenix | AZ | 85000-4542 | — | UNKNOWN |
| PRV | PRV-23617 | 2026-05-09T23:24:31Z | CYNTHIA | D. | WATKINS | Aug 3, 2002 | UHC-69888-49 | - | 8673673280 | UNKNOWN | 5861 Highland Avenue·· | ORLANDO | FL | ·32875 | UNKNOWN | — |
| PRV | PRV-22172 | 2026-07-18T21:34:30Z | Dorothy | — | Medina | 1967-10-19 | UHC-55197-73 | N/A | 940.733.4986·· | ·NULL | 1837 Pine Drive | Houston | Texas | 77041 | null | - |
| PRV | PRV-20762 | 2026-02-13T16:44:59Z | cheryl | — | dunn | 1988-05-22 | UHC-52816-13 | null | (776) 857-4988 | — | 6558 Canyon Road·· | Columbus | OH·· | 43256 | — | — |
| PRV | PRV-21594 | 2026-05-27T13:29:06Z | Fernandez, Luis | R. | — | 1939-03-16 | UHC-80478-13 | - | UNKNOWN | LUIS.FERNANDEZ59@AOL.COM | 6230 Camelback Road Apt 21 | Austin·· | TX | 78790 | — | NULL |
| PRV | PRV-29174 | 2026-05-13T06:01:26Z | WILLIAM | — | COLLINS | 17930109 | null | UNKNOWN | 4868085700·· | NULL·· | 6271 Cedar Ln | SAN ANTONIO | TX | 78218 | UNKNOWN | NULL |
| PRV | PRV-23797 | 2026-09-12T18:23:41Z | Sophia | — | Ferguson | 1956-12-12·· | - | null | ·618-871-5819 | - | 5698 Baseline Rd | San Antonio | TX | 78225 | — | N/A |
| PRV | PRV-26499 | 2026-04-06T11:35:27Z | Alan | — | Pery | 1958-11-22 | UHC-67699-54 | null | (243) 735-4474 | alan.perry7@yahoo.com | 5216 Desert Sky Blvd·· | Austin | tx | 78739 | null | UNKNOWN |
| PRV | PRV-26251 | 2026-02-07T14:24:13Z | Samuel | — | Hart | 1982-03-15 | - | ·N/A | 3894222135 | — | 3954 Desert Sky Blvd | TUCSON | AZ | 85744 | — | NULL |
| PRV | PRV-21557 | 2026-02-06T09:45:21Z | Mari | ···· | Ramos | 7/8/1947 | null | — | (462) 271-6464 | NULL | 4261 Maple Ave | Tucson | ·AZ | 85707 | — | — |
| PRV | PRV-24709 | 2026-03-14T06:14:12Z | DIEGO | — | LANE | 1943-06-06 | ···· | - | 6715745117·· | - | 1277 Baseline Road·· | San Diego | CA | 92186 | - | NULL |
| PRV | PRV-23693 | 2026-05-21T06:21:38Z | Christina | M | Herrera | 1954-09-19 | — | — | 14422218009 | — | 6995 PINE DRIVE | Plano | TX | 75052 | N/A | NULL |
| PRV | PRV-23642 | 2026-03-10T08:05:49Z | Bruce | — | Garrett | 1989-08-06 | UHC-03054-95 | NULL | 884-282-1720 | - | 2966 Harbor Boulevard | ·Glendale | Arizona | 85324 | — | null |
| PRV | PRV-25498 | 2026-05-15T20:47:07Z | ryan | — | hernandez | 19590119 | UHC5181013 | N/A | 5727094583 | ryan.hernandez@icloud.com | 6988 Sage Court·· | CHARLOTTE | NC | 28205 | ···· | - |
| PRV | PRV-23072 | 2026-02-01T08:19:14Z | EUGENE | L | PETERSON | 1942-11-20 | - | •••-••-7733 | (867) 972-5228 | eugene.peterson@gmail.com | 2480 Ocean Avenue | Minneapolis | MN | 55489 | - | NULL |
| PRV | PRV-26170 | 2026-04-18T14:17:01Z | Alexander, Nick | — | ·· | 02/23/1955 | UHC-81486-07 | — | 546-695-0028 | nicholas.alexander96@gmail.com | 6174 Central Avenue | SAN DIEGO | CA | 92154 | ·· | NULL·· |
| PRV | PRV-21810 | 2026-02-21T20:34:57Z | Gloria | Y | Carroll | 1962-06-15 | — | — | 374-442-5197 | GLORIA.CARROLL@GMAIL.COM | 731 Washington St | Denver | CO | 80227 | UNKNOWN | - |
| PRV | PRV-21787 | 2026-02-09T21:12:38Z | TERESA | — | REID | 1988-07-24 | null | null | 6166325139 | — | — | N/A | NULL | NULL | - | NAVIGATE-HMO |
| PRV | PRV-29531 | 2026-04-04T20:02:40Z | Dot | U. | ·Fernandez | 1958-06-18 | UNKNOWN | N/A | — | NULL | 4640 PINE DR Apt 37 | ·San Diego | CA | NULL | — | ·null |
| PRV | PRV-28473 | 2026-03-31T08:41:54Z | Nicholas | O | King | May 2, 1992 | UHC-48082-65 | — | NULL | nicholas.king@yahoo.com | 2780 Oak St | San Antonio | TX | 78231-1339·· | null | NULL |
| PRV | PRV-29260 | 2026-01-07T11:08:32Z | Gloria | N. | Hudson | 1976-06-26 | — | NULL | — | GLORIA.HUDSON@HOTMAIL.COM | 603 Maple Avenue | Tucson | AZ | 85789 | null | N/A |
| PRV | PRV-27025 | 2026-06-01T14:36:24Z | Rogers, Amanda | ···· | — | 1938-02-02 | UHC-77469-13 | - | 917-774-8046 | — | 6473 Spring St | Glendale | AZ | ·85331 | — | NULL·· |
| PRV | PRV-21320 | 2026-04-19T18:25:55Z | Castro | — | John | 10/13/1993 | UHC-60495-95 | - | 627-407-9906 | — | 3188 Spring Street Apt 20 | Orlando | FL | 32840 | — | UNKNOWN |
| PRV | PRV-29022 | 2026-04-17T21:51:49Z | matthew | — | cox | 01/15/1952 | UHC-62478-86 | •••-••-4456 | 850-983-4923 | ···· | 6971 PARK PL | Atlanta | GA | 30377-8560 | UNKNOWN | null |
| PRV | PRV-27030 | 2026-02-14T07:02:07Z | BRADLEY | — | DANIELS | 1938-07-26 | UHC-73036-62 | •••-••-8649 | (510) 466-5254 | N/A | 9430 Lincoln Way | Los Angeles | CA | 90046 | NULL | — |
| PRV | PRV-26601 | 2026-07-19T04:58:51Z | JUDITH | — | MITTCHELL | 1311-19-57 | UHC-88504-27 | N/A | 8349633162 | N/A | 6212 Meadow Lane | Tucson | AZ | — | ···· | UNKNOWN |
| PRV | PRV-20944 | 2026-08-19T22:13:08Z | Santiago, Samuel | V. | ·· | 1981-08-01 | UHC-16102-10 | UNKNOWN | (385) 495-9264 | N/A | UNKNOWN | — | NULL | N/A | UNKNOWN | — |
| PRV | PRV-26951 | 2026-03-30T17:17:13Z | Pamela | — | Johnston | 1979-07-12 | UHC-19171-30 | ·null | — | null | 4813 OAK STREET | Orlando | FL | — | — | NULL·· |
| PRV | PRV-23811 | 2026-01-28T08:13:56Z | Aaron | — | Rojes | 11/08/1980 | UHC-11544-93 | - | 13164352379 | aaron.rojas71@hotmail.com | 1121 Union Street | HOUSTON·· | TX | 77058 | NULL | UNKNOWN |
| PRV | PRV-23294 | 2026-05-03T14:31:25Z | tyler | — | rojas | 1966-04-24 | UHC-54791-86 | — | 878.833.8549 | null | - | UNKNOWN | — | - | null | UNKNOWN |
| PRV | PRV-22134 | 2026-03-27T11:56:55Z | Carl | S. | Knight·· | 19650206 | UHC-18875-60 | •••-••-5908 | (216) 295-7397 | carl.knight84@yahoo.com | 6964 MAIN STREET | Charlotte | NC | 28295 | N/A | — |
| PRV | PRV-22689 | 2026-07-25T20:09:31Z | SOPHIA | — | PATTERSON | 1968-12-23 | null | null | (232) 719-4960 | UNKNOWN | 6635 Church Street | Jacksonville | FL | 32284-6975 | — | — |
| PRV | PRV-21110 | 2026-05-08T13:11:33Z | Amy | — | Wagner | — | UHC-05819-84 | — | 611-286-7706 | — | ·1324 Bayshore Dr | Columbus | OH | 43269 | N/A | null |
| PRV | PRV-21549 | 2026-01-11T17:36:42Z | Scott | — | Garrett | 1996-08-08 | — | — | — | UNKNOWN | 4175 Broadway | Atlanta | GA | 30332 | null | N/A |
| PRV | PRV-23470 | 2026-10-03T10:32:50Z | LISA·· | O. | WALKER | 1960-01-24 | uhc-66353-78 | N/A | — | NULL | 3284 Mesa Dr | Atlanta·· | Georgia | 30361 | — | — |
| PRV | PRV-26907 | 2026-09-29T11:14:00Z | Gray, Betty | — | — | 10/1/1982 | UHC-11992-16 | •••-••-8344 | 268-955-1181 | — | 1627 Mesa Drive | Miami | FL | 33186 | — | ·NULL |
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:40.640Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty