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-27097 | 2026-04-27T18:40:40Z | Margaret | — | ·Thomas | 1983-12-03 | UHC-08861-07 | •••-••-9253 | (852) 946-5608 | UNKNOWN·· | 8443 Canyon Rd | San Diego | CA | 92158 | N/A | MEDICARE-ADV-B |
| PRV | PRV-28066 | 2026-05-10T16:07:21Z | Bryant, Jamees | — | — | 1982-01-07 | UHC-17281-99·· | UNKNOWN | (576) 591-2996 | — | null | NULL | — | — | - | OPTIONS-PPO |
| PRV | PRV-27297 | 2026-08-20T04:01:51Z | Lawrence | — | Ramirez | 1971-02-09 | UHC-73167-84 | N/A | 7125755715 | LAWRENCE.RAMIREZ91@GMAIL.COM | 863 Bayshore Drive | Los Angeles | CA | 90061·· | — | NULL |
| PRV | PRV-22379 | 2026-10-08T04:31:11Z | Nathan | — | ·West | Oct 16, 1970 | ·UHC-00293-65 | - | 859-533-6082·· | NATHAN.WEST@GMAIL.COM | 8702 Valley View Dr | Phoenix | AZ | 85003 | - | - |
| PRV | PRV-25121 | 2026-10-06T03:04:57Z | BRITTANY | — | AGUILAR | 11/16/00 | UHC-06610-34 | UNKNOWN | 17482644177 | — | ·4574 WILLOW CT | Gilbert | AZ | 85208 | — | — |
| PRV | PRV-23289 | 2026-04-28T18:37:03Z | Mariana | — | Hert | 1950-10-09 | UHC-94804-40 | — | 640-328-0672 | null | 4835 Pine Drive | Scottsdale | az | 85211 | N/A | UNKNOWN |
| PRV | PRV-22475 | 2026-07-13T15:23:01Z | ·Denise | — | Olson | 05/11/1951 | — | NULL | 237-453-3779·· | denise.olson@outlook.com | 9865 Maple Avenue | PHOENIX | AZ | 85064·· | — | UNKNOWN |
| PRV | PRV-22265 | 2026-05-10T10:55:50Z | Emma | A | Graham | 1978-09-13·· | UNKNOWN | •••-••-2363 | 246-462-1374 | UNKNOWN | 6542 Central Avenue | Glendale | AZ·· | 85306 | — | ···· |
| PRV | PRV-22549 | 2026-09-16T18:30:45Z | Harold | N. | Bailey | 1979-08-05·· | UHC-21670-98·· | •••-••-5786 | (767) 529-7167 | ·harold.bailey29@outlook.com | 2892 Maple Ave | Tucson | AZ | 85756 | N/A·· | null |
| PRV | PRV-24276 | 2026-02-14T06:09:30Z | Rob | — | Duncan | 1956-10-18 | UHC-28650-79 | NULL | 8733497340 | — | 7875 Jefferson Avenue | Las Vegas | nv | 89148 | — | — |
| PRV | PRV-25513 | 2026-09-30T15:31:54Z | ethan | — | davis | Dec 20, 1973 | UNKNOWN | •••-••-9788 | 629.201.9441 | ethan.davis82@proton.me | ·6281 River Road | EDEN PRAIRIE | MN | 55344 | null | N/A |
| PRV | PRV-20558 | 2026-06-15T17:19:06Z | SAMUEL | — | BURNS | 2001-12-03 | — | ···· | 6133657225 | NULL | 3883 CANYON RD | SEATTLE | WA | 98162 | — | ···· |
| PRV | PRV-27877 | 2026-01-29T06:37:32Z | AHMED | — | RUSSELL | 1951-03-24 | UNKNOWN | — | 291-494-9633 | ahmed.russell6@icloud.com | 9679 Hillcrest Road | Los Angeles | ·CA | 90087 | — | — |
| PRV | PRV-29030 | 2026-07-30T16:15:50Z | Arthur | T | Reid | Jun 5, 1952 | — | NULL·· | 449-974-2444 | arthur.reid@proton.me | null | null | — | — | -·· | NULL |
| PRV | PRV-22151 | 2026-03-07T05:15:18Z | Bradley·· | — | Carr | 1998-11-03 | — | — | N/A·· | N/A | 2339 JEFFERSON AVE | Phoenix | AZ | 85029 | — | N/A |
| PRV | PRV-22497 | 2026-01-07T17:15:05Z | Christian | — | Marshall | 01/04/1994 | UHC-58093-69 | N/A | ·848-509-1616 | null | 5719 Sunset Blvd | Minneapolis | MN | 55478 | UNKNOWN | MEDICARE-ADV-B |
| PRV | PRV-26585 | 2026-08-11T16:49:55Z | Woods, Noah | — | — | ·02-10-1969 | NULL | - | UNKNOWN | — | 3225 Church St | Glendale | AZ | 85337·· | ···· | — |
| PRV | PRV-27847 | 2026-08-21T15:23:31Z | jeffrey | — | gordon | 1944-07-06 | NULL | •••-••-7041 | - | null | 7623 Spring Street | Sacramento | CA·· | 95836 | -·· | — |
| PRV | PRV-28635 | 2026-08-04T06:32:15Z | KYLE | — | RICHARDSON | 1976-01-01 | N/A | N/A | 19023234080 | N/A·· | 4860 Willow Ct | SCOTTSDALE | AZ | 85278 | UNKNOWN | — |
| PRV | PRV-29109 | 2026-01-01T11:06:55Z | YUIK | L. | PETERS | 1993-07-02 | NULL | •••-••-0220 | 443-379-1540 | — | 7982 River Road | Atlanta | GA | 30354-0622 | UNKNOWN | - |
| PRV | PRV-26424 | 2026-06-05T18:21:27Z | Graham, Nancy | — | — | ·03/19/59 | UNKNOWN | null | 7094605128 | nancy.graham@gmail.com | 4350 Apache Boulevard | Seattle | WA | 98197 | ·- | — |
| PRV | PRV-27138 | 2026-09-28T17:15:58Z | SUSAN | ·· | VAZQUEZ | 20070906 | UHC-84134-22 | •••-••-5878 | +1 320 698 7761 | ·· | 7588 Apache Blvd | Eden Prairie | MN | ·55378 | ·· | SELECT-EPO |
| PRV | PRV-24985 | 2026-05-06T20:02:54Z | JOHN | — | CONTRERAS | 12/13/45 | — | N/A | 14568026616 | UNKNOWN | 3814 UNION ST | Tucson | AZ | 85718-1881 | ···· | - |
| PRV | PRV-25404 | 2026-09-03T15:27:37Z | KAYLA | — | REID | Nov 6, 1950 | - | •••-••-6098 | 9527451399 | — | 1181 Sage Court | Plano | TX | 75014-1296 | NULL | — |
| PRV | PRV-28054 | 2026-07-09T22:34:17Z | CHRISTOPHER | — | TUCKER | 1938-10-15 | UNKNOWN | NULL | (271) 489-2637 | ·- | 6081 Mountain View Dr | PHOENIX | Arizona | 85001-6050 | NULL | NULL |
| PRV | PRV-28303 | 2026-09-04T10:11:37Z | Andrew | — | McCoy | 1986-06-03 | - | — | +1 867 720 9579 | ANDREW.MCCOY@GMAIL.COM | 343 Pine Dr | TEMPE | AZ | 85210 | - | MEDICARE-ADV-B |
| PRV | PRV-21352 | 2026-06-09T15:07:45Z | Olivia | F | Mendoza·· | ·19500820 | UNKNOWN | NULL | (309) 267-7353 | null | 5633 Willow Ct·· | Mesa | AZ | 85279-8552 | N/A | — |
| PRV | PRV-22941 | 2026-03-08T00:42:38Z | THMAS | ·· | REID | 09-06-1998 | UHC-15942-46 | ·· | 8642650053·· | null | 5700 BROADWAY | Jacksonville·· | Florida | 32274 | - | — |
| PRV | PRV-23024 | 2026-09-13T09:17:59Z | Sean | Z | Bishop·· | Feb 13, 1972 | N/A | •••-••-6228 | (327) 768-3915 | NULL | 1837 Grand Ave | Los Angeles | CA | 90082·· | N/A | — |
| PRV | PRV-21440 | 2026-05-24T06:27:54Z | Kelly | J | Wight | 08/05/1988·· | UHC-66125-58 | N/A | 3649000823 | null·· | 4952 Mesa Drive | San Antonio | TX | null | UNKNOWN | UNKNOWN |
| PRV | PRV-27551 | 2026-08-10T03:46:56Z | Logan | R. | Gibson | ·12/08/1961 | UHC-11992-08 | — | (554) 902-5162 | — | 5444 Union St #140 | Sacramento·· | CA·· | 95815 | NULL | — |
| PRV | PRV-22443 | 2026-03-28T12:52:26Z | SHIRLEY | ·· | BUTLER | 19930906 | UHC-47514-26 | NULL | 2996140395 | UNKNOWN | 218 Canyon Rd | Phoenix | AZ | 85006 | — | — |
| PRV | PRV-27458 | 2026-05-18T13:32:47Z | Jennifer | ·· | Payne | ·18-12-1968 | — | •••-••-5345 | (937) 537-7924 | null | 8320 Willow Court | Glendale | AZ | N/A | — | — |
| PRV | PRV-28052 | 2026-07-19T23:14:31Z | HENRY | V. | OBRIEN | Feb 8, 1954 | ·UHC-71537-80 | •••-••-1380 | 2409165120 | henry.obrien@gmail.com | 1614 Camelback Road | Atlanta | GA | — | — | null |
| PRV | PRV-24641 | 2026-01-26T19:53:50Z | Bryannt, George·· | — | — | 11/15/1965 | ·NULL | NULL | 9212495557 | george.bryant@aol.com | 2407 BAYSHORE DRIVE | SAN DIEGO | ca | 92181 | — | — |
| PRV | PRV-21661 | 2026-03-26T10:28:49Z | HAROLD N. | — | RAY | 1946-09-21 | UHC-61684-71 | N/A | 4365981 | - | 5887 JEFFERSON AVENUE | Phoenix | AZ | 85047 | null | NULL |
| PRV | PRV-27001 | 2026-03-25T16:18:40Z | Vigrinia | — | Maldonado | 0212-80-06 | UNKNOWN·· | N/A | ·(884) 630-1812 | null | 4553 Main St | SACRAMENTO | CA | 95889 | - | — |
| PRV | PRV-23777 | 2026-08-19T21:09:48Z | ·JUDY | — | STEVENS | 1962-08-11 | UHC-82487-20 | •••-••-3696 | 4019688917 | NULL | 3652 Palm Drive | Los Angeles | CA | 90041 | — | MEDICARE-ADV-A |
| PRV | PRV-22020 | 2026-02-13T04:53:27Z | Alexander | — | Davis | 1979-12-27 | ·· | UNKNOWN | +1 292 747 4296 | UNKNOWN | 8974 ELM STREET | Scottsdale | AZ | ·85295-4053 | - | — |
| PRV | PRV-28024 | 2026-05-02T00:28:05Z | daniel | — | nunez | 1954-01-09 | UHC-37947-01 | ·null | 12176217578 | daniel.nunez62@aol.com | 580 Church St | Glendale | AZ | 85333 | — | null |
| PRV | PRV-29093 | 2026-08-10T01:34:08Z | JEAN | — | MCCOY | 12/9/1963 | UHC5924439·· | N/A | 550.737.1454 | NULL | 343 MAPLE AVE | Tampa | FL | 33600 | — | — |
| PRV | PRV-27395 | 2026-05-01T00:18:20Z | AHMED | — | ROSE | 11/01/1972 | — | NULL | 9007684149 | - | 4535 Camelback Road·· | Seattle | WA | 98143-6655 | null | — |
| PRV | PRV-22911 | 2026-04-18T10:47:40Z | Sofia | — | Weaver | 1968-06-05 | UHC-51460-08 | •••-••-1587 | (359) 360-1826 | N/A | 1381 UNION STREET | Mesa | ·AZ | 85234 | UNKNOWN | — |
| PRV | PRV-27761 | 2026-01-02T17:03:01Z | gloria | A | fernandez | 19540105 | UHC-87618-90 | •••-••-1402 | 748.438.0394 | ·· | 8069 River Road | Dallas | TX | 75203 | — | — |
| PRV | PRV-28279 | 2026-04-04T14:54:33Z | Diane | — | Little·· | ·1956-02-14 | — | - | ·625-317-7654 | diane.little@gmail.com | 9056 Washington Street | Orlando | FL | 32845 | null | — |
| PRV | PRV-26411 | 2026-01-03T23:10:43Z | ntaalie | — | ·ward | 1959-04-17 | UHC-22202-45 | UNKNOWN | 15949289595 | NULL | 2490 Apache Blvd | Gilbert | AZ | 85264-8473 | — | N/A |
| PRV | PRV-23518 | 2026-05-24T09:41:05Z | Carlos | ···· | Alvarez | 10/26/77 | N/A | — | 17704001467 | carlos.alvarez@gmail.com | 4812 River Road | ·Dallas | TX | 75238 | — | — |
| PRV | PRV-28603 | 2026-07-08T01:55:03Z | Donald | — | Banks | 19710613 | null | UNKNOWN | 474-235-5070·· | - | 5222 Camelback Road | Austin | TX | 78730 | null | CORE-HMO |
| PRV | PRV-26314 | 2026-07-26T22:17:22Z | Nicholas | F.·· | Dunn | ·1959-08-22 | UHC-05520-26 | UNKNOWN | 9774443061 | null·· | 5990 Pine Drive #277 | Mesa | AZ | 85242 | - | — |
| PRV | PRV-26711 | 2026-03-03T19:14:02Z | zachary | — | olosn | 1993-09-06 | uhc-00455-39 | UNKNOWN | — | null | — | N/A | null | NULL | null·· | 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:43.444Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty