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-22875 | 2026-08-10T03:48:54Z | ·Mariana | ···· | Le | 1997-11-10 | - | UNKNOWN | 3095152774 | — | 733 LAKE VIEW ROAD | Dallas | Texas | 75243 | UNKNOWN | N/A |
| PRV | PRV-23078 | 2026-08-20T09:22:00Z | SCOT | M | MARQUEZ | 2003-11-17 | UHC-37992-31 | — | (482) 418-9535 | NULL | 2286 Ocean Avenue | Gilbert | AZ | ·85251 | - | — |
| PRV | PRV-25042 | 2026-06-29T07:07:38Z | BEVERLY | — | EVANS | 08-10-1988 | - | — | +1 890 904 8210 | UNKNOWN | 9591 VALLEY VIEW DRIVE | Las Vegas | Nevada | 89124 | UNKNOWN | NULL |
| PRV | PRV-21884 | 2026-06-18T02:38:49Z | Mary | A | Ward | 12/7/1961 | UHC-18681-66 | UNKNOWN·· | 8258766177 | — | null | UNKNOWN | NULL | ···· | — | ·UNKNOWN |
| PRV | PRV-20197 | 2026-02-12T21:33:37Z | LINDA | Y | OLIVER | 1945-06-19 | NULL | — | 975-320-9662 | LINDA.OLIVER70@OUTLOOK.COM | 8742 Baseline Road | Tampa | FL | 33609-0180 | N/A | N/A |
| PRV | PRV-20069 | 2026-09-22T11:44:18Z | ELIJEH | — | PENA | 07/20/97 | NULL | — | 637-428-6005 | elijah.pena@proton.me | 7649 Union Street | TUCSON | ·AZ | 85794-4886 | - | UNKNOWN |
| PRV | PRV-24628 | 2026-03-13T20:12:46Z | Theresa | — | ·Young | 1940-01-10 | NULL | null | null | — | 97 Broadway #250 | Sacramento | CA | 95843 | — | N/A |
| PRV | PRV-20938 | 2026-10-03T17:08:46Z | CAROLYN T. | — | WOODS | Nov 9, 1950 | ·UHC3794183 | UNKNOWN | 16155849864 | N/A·· | 998 Mountain View Drive | San Antonio | TX | 78284·· | NULL | — |
| PRV | PRV-28568 | 2026-04-18T12:57:32Z | theresa·· | — | stephens | 10/20/1963 | — | — | (878) 554-4791 | theresa.stephens32@gmail.com | 5288 Market Street | Tempe | AZ | 85225 | — | — |
| PRV | PRV-21704 | 2026-07-28T09:31:58Z | Harvey, Ben | — | — | 1949-06-01 | UHC-69892-51 | N/A | 16196052892 | NULL·· | 2760 Apache Boulevard | Tucson | ·AZ | 85744·· | — | N/A |
| PRV | PRV-21241 | 2026-10-17T10:36:01Z | Bradley, George | — | — | 1978-09-01 | UHC-28120-86 | — | (659) 432-1783 | george.bradley43@hotmail.com | 114 Highland Avenue | Denver | CO | 80226 | — | - |
| PRV | PRV-25339 | 2026-04-09T19:51:34Z | Austin·· | — | Thomas | 5/28/2004 | — | UNKNOWN | 2043320144 | - | 9416 OCEAN AVENUE | Sacramento | California | 95859 | NULL | null |
| PRV | PRV-21278 | 2026-09-14T12:57:11Z | RUSSELL | D | DAVIS | 08-06-1962 | NULL | NULL | 7999432 | russell.davis61@outlook.com | 1029 Spring Street | Columbus·· | OH | — | - | — |
| PRV | PRV-21205 | 2026-09-07T03:56:12Z | MARIA | — | WARREN | Jun 28, 1940 | - | NULL | null | N/A | 4096 Canyon Road | ·Fresno | CA | 93708 | -·· | CHOICE-PLUS-PPO |
| PRV | PRV-23599 | 2026-03-17T16:19:24Z | Ruth | Z. | Contreras | 1979-05-04 | - | UNKNOWN | 5595469929 | — | 7697 Lincoln Way | Houston | TX | 77038 | N/A | N/A·· |
| PRV | PRV-24133 | 2026-09-01T14:23:48Z | Lori, Ferguson·· | — | — | 20060826 | UHC-87498-51 | — | 284-902-6276 | lori.ferguson48@outlook.com | 2459 HIGHLAND AVENUE | Glendale | AZ·· | 85352 | N/A | NULL |
| PRV | PRV-22811 | 2026-05-07T15:07:18Z | BRIAN | — | REID | 1972-04-13 | NULL | null | 279-212-0513 | brian.reid46@proton.me | 7920 Valley View Dr | Orlando | ·fl | ·32843 | ·UNKNOWN | MEDICARE-ADV-B·· |
| PRV | PRV-25530 | 2026-08-07T17:52:18Z | CYNTHIA | — | ·PERKINS | 01/11/1954 | — | null | +1 788 288 5535 | N/A | 3711 Mountain View Dr | Plano | TX | ·75017 | — | NULL |
| PRV | PRV-27128 | 2026-02-11T05:31:13Z | Carol | — | ·Vargas | 19510318 | N/A | — | — | ·· | 3390 WASHINGTON STREET #749 | Jacksonville | FL | ·32204 | UNKNOWN | — |
| PRV | PRV-23729 | 2026-02-04T16:50:05Z | Barbara | — | Boyd | 1966-09-24 | UHC-51193-31 | NULL | 633-614-6338 | NULL | 9280 VALLEY VIEW DR | Las Vegas | NV | 89118 | — | — |
| PRV | PRV-28590 | 2026-08-28T20:36:39Z | ben | G. | wright | May 17, 1974 | UHC-86998-36 | •••-••-6980 | 3266584477 | - | 9599 Ocean Ave | Orlando | ·FL | 32824 | UNKNOWN | UNKNOWN |
| PRV | PRV-27744 | 2026-10-10T08:47:17Z | Donald·· | — | Morales | 15-12-1965 | UHC-67538-62 | — | +1 889 294 0574 | NULL | 9049 RIDGE ROAD·· | Atlanta | GA | 30395 | - | NULL |
| PRV | PRV-28534 | 2026-06-17T14:08:37Z | Stephanie | N. | Ruiz | 1960-09-07 | — | UNKNOWN | (524) 870-0134·· | — | 7665 Mesa Dr | Los Angeles | ·CA | 90093 | UNKNOWN | — |
| PRV | PRV-26773 | 2026-03-10T07:20:19Z | Jeffrey | ·· | Dixon·· | 1990-09-22 | UHC-96821-69 | — | 860-684-9054 | jeffrey.dixon@proton.me | 9173 Grand Ave | Miami | FL | 33106 | N/A | UNKNOWN |
| PRV | PRV-28526 | 2026-08-01T01:35:04Z | ARJUN | — | HUDSON | Apr 14, 1999 | UHC-69955-67 | NULL | 3663862344 | — | 4237 Sunset Boulevard | Gilbert | AZ | 85297 | N/A | NULL |
| PRV | PRV-24472 | 2026-03-08T07:35:56Z | FRANK | ·· | NELSON | 1997-09-14 | UHC4106777 | ·null | 17286510565 | frank.nelson87@outlook.com | 9185 Elm Street | Chandler | AZ | 85222 | — | NAVIGATE-HMO |
| PRV | PRV-20470 | 2026-07-27T03:19:43Z | JOE·· | W. | OLSON | 1974-08-05 | UHC-29037-70 | — | 951-722-7677 | joe.olson38@aol.com | 8587 MEADOW LANE Apt 8 | MINNEAPOLIS | MN | — | — | — |
| PRV | PRV-26324 | 2026-06-25T00:43:32Z | Lukia | — | Vazquez·· | 1970-06-11·· | — | UNKNOWN | (633) 759-9464 | UNKNOWN | 4165 Meadow Lane | Fresno | CA | ·93711 | UNKNOWN | - |
| PRV | PRV-23418 | 2026-01-22T23:24:54Z | Juan | — | Coleman | 26-05-2008 | - | UNKNOWN | 968-361-6772 | — | ·8188 DESERT SKY BOULEVARD | SACRAMENTO | CA | 95880 | — | CHOICE-PLUS-PPO |
| PRV | PRV-24203 | 2026-02-06T02:14:19Z | HENRY | — | JEKNINS | 06/23/52 | UHC-25569-64 | — | (829) 749-8342 | NULL | 8487 Washington St | San Diego | ca | 92100 | — | MEDICARE-ADV-B |
| PRV | PRV-22079 | 2026-10-01T02:05:56Z | Elliott, Judy | — | ·· | 1971-40-05 | UHC-82303-32 | ···· | 6653081200 | ·null | 3769 SAGE COURT Apt 28 | Jacksonville | Florida | 32293 | null | CORE-HMO |
| PRV | PRV-28558 | 2026-06-15T23:14:20Z | Kathleen·· | ·· | Le·· | Jun 8, 1987 | ·UHC-95340-31 | UNKNOWN | null·· | — | 8323 Bayshore Drive | Tucson | AZ | 85782 | — | N/A |
| PRV | PRV-26943 | 2026-10-11T09:21:27Z | ETHAN | — | PHHILLIPS | Mar 7, 1996·· | NULL | NULL | (553) 998-1186 | — | 8497 Oak St | Gilbert | Arizona | 85282 | - | N/A |
| PRV | PRV-23232 | 2026-07-04T00:09:24Z | VIRGINIA·· | A | LYNCH | 2002-12-21 | UHC-46988-53 | •••-••-1031 | 541.555.7444 | - | 8501 VALLEY VIEW DR | ATLANTA | Georgia | 30374-3669 | N/A | MEDICARE-ADV-A |
| PRV | PRV-21222 | 2026-04-28T14:09:59Z | Jacqueline | — | Jimenez | Sep 7, 1950 | UHC-16993-83 | •••-••-8587 | null | ·jacqueline.jimenez36@icloud.com | 7066 Highland Avenue Apt 4 | Orlando | FL | 32875 | UNKNOWN | ···· |
| PRV | PRV-26194 | 2026-06-17T08:23:23Z | HENRY | ·· | MYERS | 1953-05-04 | — | N/A | 213-207-1418 | - | 2969 Cedar Lane·· | LAS VEGAS | NV | 89100 | — | — |
| PRV | PRV-28113 | 2026-04-13T13:15:57Z | Wong, Grace·· | ·· | — | 12/03/00 | NULL·· | •••-••-1643 | — | - | ·3571 Spring Street | Sacramento | CA | 95834 | NULL | null |
| PRV | PRV-27883 | 2026-05-12T14:19:42Z | LARRY | — | STEPHENS | 1941-12-13 | NULL | N/A | (757) 385-6113 | larry.stephens36@hotmail.com | 6390 Camelback Road·· | Las Vegas·· | NV | 89126 | ·UNKNOWN | UNKNOWN |
| PRV | PRV-23291 | 2026-04-11T15:19:58Z | — | — | — | 1957-02-01 | UHC-03087-94 | UNKNOWN | — | mason.gardner@proton.me | 1165 OAK STREET | Tucson | AZ | 85786 | — | — |
| PRV | PRV-28904 | 2026-08-23T05:12:45Z | VALENTINA | T | GUERRERO | 1977-09-18 | UHC-71193-02 | •••-••-1057 | 15686668856 | — | ·7765 Grand Avenue | Columbus | OH | ·43232 | NULL | — |
| PRV | PRV-28696 | 2026-10-07T17:24:29Z | HENRY | ·· | KING | 12/02/89 | NULL | null | null | henry.king54@outlook.com | 3949 Central Avenue Apt 11 | Las Vegas | NV | — | NULL | MEDICARE-ADV-B |
| PRV | PRV-23550 | 2026-06-19T07:33:25Z | Barbara | — | ·Schultz | 1997-02-25 | — | •••-••-0188 | ·+1 730 343 2627 | UNKNOWN | 1266 SPRING STREET | Dallas | TX | 75294 | UNKNOWN | N/A |
| PRV | PRV-27796 | 2026-04-10T05:01:27Z | Ntahan | — | Wech | 2003-12-10 | UHC-78955-81 | - | 7209696266 | NATHAN.WELCH69@AOL.COM | 1747 Sunset Blvd | FRESNO | CA | 93799 | null | — |
| PRV | PRV-22000 | 2026-02-01T05:44:31Z | benjamin | B. | davis | ·1971-12-09 | ·NULL | — | 9637881778 | benjamin.davis8@gmail.com | 4361 Cedar Lane | Las Vegas | NV | 89151 | — | — |
| PRV | PRV-21437 | 2026-02-02T05:40:06Z | Natalie | — | Hicks | 2004-09-04 | UHC-35559-15·· | null | +1 638 444 4698 | N/A | 3013 Palm Dr #677 | San Antonio | TX | 78246 | N/A | — |
| PRV | PRV-28205 | 2026-04-20T12:13:16Z | BEVERLY | — | WILLIAMS | 1987-03-25 | — | ·· | 317-496-6872 | — | 3490 Cedar Lane | Phoenix·· | AZ·· | 85066 | null | CORE-HMO |
| PRV | PRV-26763 | 2026-07-16T11:50:41Z | JOYCE | — | PORTER·· | 1964-11-26·· | ·· | N/A | 16717641555 | N/A | — | N/A | — | ·· | — | — |
| PRV | PRV-20436 | 2026-08-26T03:35:50Z | Gomez, Mark | — | — | 1959-12-09 | ·UHC-95727-77 | N/A | (513) 870-0456 | — | 5174 Meadow Ln | SEATTLE | ·Washington | ·98159 | — | UNKNOWN |
| PRV | PRV-24504 | 2026-05-17T09:29:05Z | Camila·· | — | Brown | 1951-11-17 | - | UNKNOWN | +1 609 980 3556 | NULL | 3113 FOREST AVENUE | Orlando | FL | ·32832 | — | null |
| PRV | PRV-20094 | 2026-03-08T06:17:50Z | ·Kyle | ···· | Mason | 2008-03-16 | UHC-92667-29 | ···· | — | — | 5993 Bayshore Drive | Chandler·· | AZ | 85256-6065 | — | 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:43:00.493Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty