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

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
PRVPRV-217062026-09-07T12:42:29ZPaul—Patel1940-45-19UHC-58061-85—264-913-8217PAUL.PATEL48@AOL.COM3976 Park PlaceTampaFlorida33646UNKNOWNUNKNOWN
PRVPRV-256722026-04-30T19:54:21ZARTHUR—MORRISON1988-09-03UHC-75672-61··3417974398··—3735 MEADOW LANEMIAMIFL33105N/ANULL
PRVPRV-294552026-08-05T11:56:02ZCHUCKA.NUNEZ1953-05-25UHC-42084-71-862-710-4283charles.nunez@gmail.com1663 Mesa DrSeattleWA98179——
PRVPRV-209092026-09-19T21:47:02ZChristianNLawsonFeb 12, 1975null•••-••-3766(659) 257-4429christian.lawson64@aol.com5942 Baseline RdGilbertAZ—N/ACORE-HMO··
PRVPRV-238872026-03-07T09:56:36ZMills, Ana——06/13/1998—UNKNOWN782-284-9623NULL7015 Union StLas VegasNV··89176—UNKNOWN
PRVPRV-27952 2026-04-02T06:15:45ZPIRYA—LITTLE1949-11-22NULL•••-••-4529(752) 816-8242priya.little46@outlook.com9710 DESERT SKY BLVDColumbusOhio43213NULL—
PRVPRV-274072026-01-02T13:04:17ZARTHUR—WALLACE1961-07-10-•••-••-0935·(665) 866-7099—N/AnullUNKNOWN—-OPTIONS-PPO
PRVPRV-261952026-07-22T09:01:58ZHenry—MyeersMay 4, 1953NULL-(213) 207-1418N/A2969 Cedar LaneLas VegasNV89100-4663UNKNOWN—
PRVPRV-237462026-04-19T20:52:25ZAMY—ARMSTRONG08-05-1999UNKNOWNUNKNOWN16942393198UNKNOWN4161 Apache BlvdPhoenixAZ85069-—
PRVPRV-228392026-07-26T21:42:29ZGeorge—Banks1987-07-19UHC-71568-86UNKNOWN2085759809george.banks@aol.com8067 Washington StColumbusOH43209-7355—NULL
PRVPRV-200522026-03-10T14:06:25ZAnthony R—Maldonado1958-06-17·UHC-57454-98—881-629-8459UNKNOWN7136 SAGE CT #287·DallasTX75246UNKNOWN··-
PRVPRV-257942026-02-06T16:54:48ZVictoria—Howard1961-09-20UHC-87606-64•••-••-9870·5888107099null9758 Oak StSAN DIEGOCA92142-3316N/A—
PRVPRV-275042026-01-21T06:53:20ZETHAN—SPENCER2002-01-09·UHC-46162-88UNKNOWN(280) 748-6166ethan.spencer11@yahoo.com8718 Ocean AvenueAtlantaGA30361-1270nullNULL
PRVPRV-280962026-08-20T19:11:44ZTYLER··—SANDERS1995-01-19NULL··UNKNOWN·(649) 724-4073tyler.sanders@aol.com1664 Forest Avenue·MINNEAPOLIS·MN55456——
PRVPRV-279742026-03-14T19:29:42ZKENNETH—BURTON1950-06-10—N/A276-754-6196—8977 Central AveFRESNO·CA—·N/A—
PRVPRV-294602026-05-13T19:23:22ZMelissa··Gibson03/15/46—•••-••-13429548196908·melissa.gibson@aol.com8469 Oak StCOLUMBUSOH43204UNKNOWN-
PRV PRV-223572026-07-12T22:10:00ZNathan—Hayes1951-10-28UHC-76338-71-(950) 436-7991—null-·---—
PRVPRV-210272026-08-30T13:01:52ZChristian—Perez1978-01-11UHC-47113-40—750-759-8645christian.perez61@yahoo.com··9660 GRAND AVENUETempeAZ85211——
PRVPRV-236662026-06-02T16:07:42ZDennis—Castro2000-05-06null•••-••-9730·3268442329dennis.castro@yahoo.com5520 Washington Street Apt 16MiamiFlorida33174··MEDICARE-ADV-A
PRVPRV-244602026-07-14T14:44:54ZLindaCMcDonald03/12/87··UHC-89393-86UNKNOWN3404830878—4266 BROADWAY Apt 3MiamiFL33192-0201-UNKNOWN
PRV PRV-222772026-06-26T01:45:33Z·Patrick—·Morris1992-10-26·N/A-··533.515.1382patrick.morris92@proton.me3131 Palm DriveEden PrairieMN··55381—-
PRVPRV-282432026-09-18T05:13:32ZLauren—Dunn1950-02-24UHC-63768-04nullUNKNOWN—5143 Meadow LnLas VegasNV89119N/A··
PRVPRV-206382026-05-12T15:14:43ZBryan—Payne19561224—····3395765null·5689 Jefferson AvenueSEATTLE·Washington98150NULL··
PRVPRV-253642026-02-10T20:07:38ZEric—HayesnullUNKNOWNUNKNOWN—-4894 Spring Street #773JacksonvilleFL32264-—
PRVPRV-287962026-08-27T02:09:41ZGaryP.Chapman1980-12-12—UNKNOWN6247951058null8674 Lake View RoadSan DiegoCA92145——
PRVPRV-239802026-08-05T05:38:43ZSnyder, Adam——1964-09-27UHC-25891-48—·5934629771·-9660 Market Street Apt 28·DenverCO—null·-
PRVPRV-222442026-01-18T18:10:48ZALBBERT—MURRAY1998-02-28UNKNOWNnullUNKNOWNN/A—null—nullN/A—
PRVPRV-263672026-07-21T12:57:29ZFrank····Carpenter1999-02-27UHC-16808-12NULL7222778346FRANK.CARPENTER@GMAIL.COM1999 Cedar LaneAustinTX78737——
PRVPRV-208912026-07-23T10:14:17ZJUDITH—RIVERA1968-04-15·N/A—7262201UNKNOWN5604 Ridge Road··Los AngelesCA90005UNKNOWNN/A··
PRVPRV-208442026-10-10T08:22:47ZCAROL—SNYDER1966-06-27—NULL-CAROL.SNYDER62@HOTMAIL.COM6212 Baseline RoadLas Vegas··Nevada89100nullN/A
PRVPRV-204422026-06-18T15:01:18ZDennis—Garcia19981112-null5945612155DENNIS.GARCIA32@PROTON.ME1989 Valley View DriveGilbertAZ85287——
PRVPRV-263092026-03-29T01:54:47ZWalterXBarnesMar 12, 1942UNKNOWN—978-817-2803N/A——UNKNOWN-—NULL
PRVPRV-240722026-04-11T14:45:52ZJOAN—ALVARADO07/21/1946UHC-00087-63··(882) 368-8818joan.alvarado@yahoo.com8314 FOREST AVE Apt 24··Miami·FL33182—CORE-HMO
PRVPRV-255782026-08-04T03:41:12ZBilly—Austin1992-05-22—N/AN/ABILLY.AUSTIN97@PROTON.ME29 Lincoln WayFresnoCA93774—SELECT-EPO
PRVPRV-230802026-09-17T06:29:47Znancy··—valdez1952-03-12UNKNOWN•••-••-7901(883) 355-3974-963 Canyon RoadChandlerAZ85295··nullN/A
PRVPRV-264632026-05-16T09:04:06ZSANDRA·ASTEVENS1963-08-22UHC-88900-39•••-••-40923853865840—6300 Lake View RdTempeAZ—UNKNOWN-
PRVPRV-284962026-05-08T18:24:29ZSusan—Barnes1999-01-17———-9887 Lincoln WaySEATTLE··WA·98149NULL—
PRVPRV-280422026-06-01T20:02:29ZGloriaWWardSep 2, 1968··UNKNOWNnull496-892-4413gloria.ward92@yahoo.com-N/A—NULLUNKNOWNN/A
PRVPRV-212472026-02-12T09:22:45ZTereasNGeorge02-06-1971··nullnull(498) 560-3209teresa.george62@outlook.com·1320 RIDGE RDSan DiegoCalifornia92124-0966UNKNOWN—
PRVPRV-258152026-07-04T16:11:45ZWarren, Eugene——3/23/1965UHC-16651-20—573.990.4544··—4103 Bayshore Dr Apt 24GilbertAZ85277null-
PRVPRV-263902026-05-15T21:22:00ZPAMELAQGRANT06/15/49—•••-••-0999+1 712 335 3593·pamela.grant@proton.me6343 MAPLE AVENUEDenverCO80235N/A—
PRVPRV-225812026-03-26T12:06:23ZJUDITHH.LOPEZ1955-12-23UHC-71589-82—+1 865 650 4963-7203 Market StreetColumbusOH43283-0367N/ANULL
PRVPRV-229232026-04-01T13:30:28ZReyes, Melissa——6/10/1989UHC-62424-65•••-••-3004257-967-6112melissa.reyes11@gmail.com8766 Hillcrest RdLOS ANGELESCA90034N/AN/A
PRVPRV-201702026-02-23T05:26:38Z STEPHANIE—HAMILTON1986-01-08UHC-85850-81NULL18273998162STEPHANIE.HAMILTON96@GMAIL.COM6645 HIGHLAND AVEPhoenixAZ··85085N/AOPTIONS-PPO
PRVPRV-244442026-04-16T18:29:52ZJannet—Hernandez·Apr 8, 1956UHC-93819-19N/A942.362.5956janet.hernandez@outlook.com5958 MEADOW LNTampaFL·33687-3831NULL—
PRVPRV-206332026-08-21T07:29:03ZLUISRFREEMAN··Jul 1, 1981—····437-813-6234-·147 Central AvenueTucsonaz85797NULLCORE-HMO
PRVPRV-205202026-10-03T07:56:15ZMATEO··—WARREN1972-02-18—•••-••-46626628564848N/A9718 Elm Street Apt 32SacramentoCA95860——
PRVPRV-269662026-07-22T14:28:52ZRandy—Soto07-12-1943UHC-23233-32UNKNOWN8336914874UNKNOWN8000 PINE DRIVEDallasTX75231-—
PRVPRV-270082026-04-18T11:43:50ZLisaMKennedy10-11-1957-—(651) 934-5047N/A5138 Harbor BoulevardMesaAZ85204N/ANULL
PRVPRV-243872026-01-30T12:19:37ZPRIYAB.RICE1957-12-11UNKNOWNNULL208.433.0337··priya.rice71@icloud.com9320 BAYSHORE DR #865ChandlerAZ85250—null
9,596 rows, page 8 of 192PreviousNext

Bronze layer rules

What is guaranteed for downstream layers

  • As received
    Values are stored exactly as the feed delivered them, including whitespace, inconsistent casing and placeholder tokens such as NULL or N/A.
  • No transformation
    Bronze is never edited in place. Every fix lives in silver and is traceable back here by record ID.
  • Line number preserved
    The line number records each row's position in the source file, so a value can be located in the original extract.
  • Load timestamp
    The load timestamp marks when the row landed in the lakehouse; this batch landed 2026-10-19T19:54:25.436Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty