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-250372026-02-04T18:47:02ZWilliamX.Gonzales1977-08-17·UHC-92544-37—(462) 939-1825—2689 MARKET STREETMINNEAPOLISMN55475nullNULL
PRVPRV-215852026-07-29T01:33:02ZMARILYN—FISHERApr 16, 1985UNKNOWNUNKNOWN(632) 788-1364marilyn.fisher93@icloud.com··4815 SAGE CTSan AntonioTexas78201--
PRVPRV-277182026-08-25T09:38:31ZMARKMMARQUEZ1953-02-28N/A•••-••-16597106427661-3821 Ridge RdLAS VEGASNevada89133-CHOICE-PLUS-PPO
PRVPRV-253692026-05-11T05:04:24ZBRIANM.MCCOY1958-07-15UHC-72352-98NULL220-492-3173brian.mccoy12@aol.com8242 Union StreetTempeAZ85238-4313NULL—
PRVPRV-255992026-03-13T01:57:02ZYoung, Carlos——1985-03-14UHC2206837—7564710943··8579 Spring StTAMPAFL33678-null
PRVPRV-213082026-07-01T14:59:42ZJudith—Carroll1939-03-06UNKNOWNnull(220) 253-8358N/A-N/A—·N/A-NULL
PRVPRV-256202026-05-31T11:37:25ZCARL··—MARSHALL22-07-1963UHC-27566-03····+1 689 452 7111carl.marshall@hotmail.com1078 Forest Ave··GilbertAZNULL——
PRVPRV-257062026-03-02T09:48:19Zelijah—munoz11/23/1957——16608676097—7576 Jefferson AveHoustonTX77004N/AMEDICARE-ADV-B
PRVPRV-259292026-08-04T14:39:35ZPeter—Reyes·1944-10-12·UHC-30205-67—(945) 696-9470UNKNOWN6145 BROADWAYDenverco80228nullN/A··
PRVPRV-256882026-06-20T22:16:27Z Helen—Estrada1945-12-08UHC6382595N/A286-599-9236-5639 Spring StLas VegasNV89134···nullnull
PRVPRV-202332026-07-06T05:51:40ZArthur·WStephens19500225—NULL(933) 610-6282—8084 Union StORLANDOFL32888—··
PRVPRV-241632026-04-10T22:14:43Zrachel—kellly1944-02-27UHC-94298-23··null+1 856 402 6237—572 MARKET STREETChandler·AZ85231··-····
PRVPRV-293582026-07-08T01:09:59ZTheresa—SimsJan 16, 1984UHC-55226-19—+1 521 885 1317NULL9244 Canyon RoadJacksonvilleFL32261—MEDICARE-ADV-A
PRVPRV-219852026-08-10T18:17:09ZAlexander, JaniceK—2008-05-23····•••-••-6818887-452-3752UNKNOWN··8708 Central AvenueSacramentoCA95832-1512N/ANULL
PRVPRV-29344 2026-05-21T00:44:13ZMICHAEL—GARRETT2003-11-10UHC-15377-59NULL419-682-7958-63 Harbor Boulevard Apt 8Scottsdale·AZ85285N/ANAVIGATE-HMO
PRVPRV-237992026-06-30T08:50:46ZfrankAhoward07/01/71UHC-33748-51•••-••-49812546683803frank.howard85@icloud.com··5872 JEFFERSON AVENUENashvilleTN37253-6395—OPTIONS-PPO
PRVPRV-254872026-06-26T08:32:26ZRUTH—BELL1991-06-20—-6492200725N/A5894 Central AveSCOTTSDALEAZ85240——
PRVPRV-200082026-04-26T09:27:56ZDonaldR.Cole6/28/2002UHC-90325-35N/A··2237524319——null·-N/A——
PRVPRV-214302026-04-02T13:19:53ZZACHARY—ORTEGA1947-11-11UHC-23727-64•••-••-1649—N/A7811 WASHINGTON STFresnoCAN/AnullUNKNOWN
PRVPRV-216682026-04-19T17:41:28ZMATTHEWAFULLER··1986-01-08UHC-61724-23—nullmatthew.fuller67@hotmail.com3540 Apache BlvdAUSTINTX78704··N/A—
PRV PRV-221522026-05-25T14:05:47ZSara—Richardson2002-11-24—UNKNOWN5574408247SARA.RICHARDSON10@HOTMAIL.COM-——N/A—·N/A
PRVPRV-242022026-08-13T16:29:32ZTylerM.Woods20-04-1982UHC-14817-37·UNKNOWNN/AUNKNOWN7877 Ridge RoadHoustonTXnull—NULL
PRVPRV-223042026-06-11T21:51:53ZDavid··—Marshall2008-01-19NULL-430.314.1225—·N/A———NULLSELECT-EPO
PRVPRV-207752026-09-22T00:55:57Zterry—elliott1980-07-19UHC-19456-25NULL16812696009··N/A610 OAK STREETDallas··TX75226-3526——
PRVPRV-202472026-08-28T22:01:13ZLaurraASullivan1974-11-11—•••-••-633316567179083··—1021 Highland AvenueAtlantaGeorgia30378-N/A··
PRVPRV-295062026-04-26T17:00:22ZJula—Feilds1992-07-08UHC-03539-69NULL··6579697UNKNOWN7380 BAYSHORE DRIVEPhoenixAZ85050UNKNOWN—
PRV PRV-211612026-02-13T18:06:39ZChristopher—Williamson··2002-02-28null··NULL5136237039--··—UNKNOWNUNKNOWNNULL··null
PRVPRV-265132026-09-07T22:18:16Zvincent—campbell1982-11-20UHC-21729-18N/A+1 313 725 7856vincent.campbell@proton.me6665 Pine DrSan AntonioTX78254··N/A
PRVPRV-263392026-02-12T17:18:28ZannaY.greene1986-02-14UNKNOWN•••-••-8419(987) 521-7391··ANNA.GREENE20@YAHOO.COM9359 Lake View RoadDenverCO80222-··
PRVPRV-227142026-05-30T15:46:22ZCAROL—LANE1956-06-01—-(575) 749-9827carol.lane@gmail.com7896 Willow CourtMESAAZ85250UNKNOWNN/A··
PRVPRV-239072026-02-02T21:12:03ZBell, Andrew——08/20/64UHC1539125—+1 277 242 8230····5494 Union StreetSan AntonioTX78287··N/AMEDICARE-ADV-A
PRVPRV-279352026-04-27T04:19:53ZMendoza, Adam——02/27/1956UHC-49778-06N/A+1 823 822 5670nullN/A—-null—MEDICARE-ADV-B··
PRVPRV-22324 2026-01-12T04:31:52ZAmanda—Peters03-11-1967····N/A928-968-9090-2524 SPRING STMinneapolisMN55488··N/A
PRVPRV-202452026-06-27T01:20:30Z·Sofia—Chavez1996-12-23UHC-70365-92--SOFIA.CHAVEZ25@GMAIL.COM3709 Sunset BlvdLos AngelesCA90067null···NAVIGATE-HMO
PRVPRV-25321 2026-09-09T21:00:57ZKEVIN—CUNNINGHAM1962-09-09UHC-16646-65NULLnull—4566 Forest AvenuePhoenixAZ85099N/A—
PRVPRV-277252026-05-16T12:36:11Zdavid—day1970-01-08··UHC-71063-24N/A5623205DAVID.DAY43@ICLOUD.COM7470 PARK PLDenverCO80292UNKNOWNUNKNOWN
PRVPRV-244672026-05-25T13:12:09ZDANIEL—HUNTER1990-12-19—NULL—DANIEL.HUNTER@GMAIL.COM3802 Mesa DriveNashvilleTN37296—NULL
PRVPRV-249982026-05-09T03:37:09ZJulia—Carpenter·1939-09-16UHC-53528-15UNKNOWN8972660610UNKNOWN3269 SAGE COURTGilbertAZ85291——
PRVPRV-219262026-04-08T05:24:55ZCAMILA—SANTIAGO1940-08-03UHC-21140-26····550-821-6953camila.santiago7@gmail.com1728 VALLEY VIEW DRIVEScottsdaleAZ·UNKNOWN-—
PRVPRV-20897 2026-08-10T03:37:13ZDiego—Williams1978-12-01—N/A(682) 765-9100N/A1963 Willow CourtChandlerAZ85252NULL—
PRVPRV-230162026-09-29T11:14:27Z·PatH·Sanchez19550409UHC-04893-31·NULL(219) 986-5988patrick.sanchez@proton.me8588 CHURCH STDallasTX··75215NULLNULL
PRVPRV-27316 2026-01-28T03:28:24ZNOAH—YANG1944-11-23UHC-46307-49null12468735326··noah.yang1@aol.com7976 Central AveCharlotteNC28286—UNKNOWN
PRVPRV-233622026-07-14T01:26:58ZAnn—Williamson10-04-1963—null5353523822ann.williamson25@proton.me402 ELM STREETMIAMI·FL33107·NULLNAVIGATE-HMO
PRVPRV-227312026-10-02T10:08:19ZANNA—THOMPSON1973-04-05UHC-22617-58null6345069772—3663 Willow CourtSacramentoCA95859—MEDICARE-ADV-B
PRVPRV-286222026-03-17T08:31:28ZMASON—WALSH1973-11-18UHC-13566-73··-··—UNKNOWN3634 MEADOW LNSan AntonioTX78263UNKNOWN—
PRVPRV-247982026-09-08T16:34:38ZthomasX.—·1964-08-10UHC3721739•••-••-0541(445) 590-6485THOMAS.LAWRENCE3@GMAIL.COM5476 Mountain View DriveCharlotteNC28276N/A—
PRVPRV-213872026-03-20T10:07:12ZWilliam—Fox·1961-11-11UHC-95380-97—(375) 348-9670UNKNOWN2561 SPRING STCharlotteNC28243-NULL
PRVPRV-27063 2026-07-03T20:12:29ZJason—Burns1975-12-26UHC-85963-06N/A7353537719jason.burns@gmail.com5434 CAMELBACK ROADEden PrairieMN—-UNKNOWN
PRVPRV-287922026-02-27T09:28:55ZVIRGINIAASANTIAGO19920313UHC-36147-93•••-••-5255+1 223 402 2365virginia.santiago@hotmail.com4239 SPRING STREETScottsdaleAZ85275—UNKNOWN
PRVPRV-213562026-06-17T15:46:05ZAmy—·FullerAug 24, 1982—NULL749-276-0762—6125 PINE DRIVETucsonAZ85746nullCORE-HMO
9,596 rows, page 16 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-22T12:42:36.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty