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-288262026-01-02T12:42:24ZADAMXVEGA12/27/74null•••-••-78205372467498adam.vega39@proton.me3130 Cedar LnSan DiegoCA92181—choice-plus-ppo
PRVPRV-248612026-01-24T02:42:50ZJEREMY—BISHOP1971-03-21UHC-33995-12··(396) 804-2203jeremy.bishop41@yahoo.com7906 LAKE VIEW RDMinneapolisMN55450nullNULL
PRVPRV-262722026-03-30T12:22:57ZVICTORIA—·ESTRADA18-09-1995UHC-18975-43•••-••-2934·N/A—1939 PARK PLACE Apt 19SEATTLEWashington98124nullN/A
PRVPRV-263552026-01-28T20:55:05ZALEXANDER—RIVERA1958-07-12UHC-52912-99N/A5126817146alexander.rivera@gmail.com298 Washington StPhoenixAZ··85087null—
PRVPRV-247632026-08-16T07:29:48ZSean—·Allen1967-11-11N/A•••-••-796416972892673—9243 Union StSeattleWA98183-··MEDICARE-ADV-A
PRVPRV-280872026-08-02T05:15:21ZBRUCE—VAQZUEZnullUHC-72856-87•••-••-6208831.966.9136—null—·null—nullSELECT-EPO
PRVPRV-230322026-08-06T20:21:14ZJulieXCox1948-06-25——(341) 838-6041··julie.cox67@icloud.com4661 Market StreetAustinTX78737—-··
PRVPRV-222012026-02-27T02:01:04Zelijah—aguilar12/19/1996—UNKNOWNnull—-—UNKNOWN··——UNKNOWN
PRVPRV-218882026-04-11T09:10:11ZJOSEPH—CARPENTER1962-01-19—UNKNOWN(732) 394-5307—611 Church StLAS VEGASNVNULL-—
PRVPRV-270212026-10-17T12:52:02ZJanice—Allen1969-04-25UHC-89622-69•••-••-7192(736) 861-4572NULL948 Union StNashvilleTN·37289—N/A
PRVPRV-268612026-05-07T14:30:03ZJOSHUA··—MORRIS2006-05-07-NULLUNKNOWNUNKNOWN8949 Mesa DrHoustonTX77074—N/A
PRVPRV-241542026-06-12T01:37:30ZTIMOTHYNRICE1994-11-24·····UNKNOWNnullNULL8880 FOREST AVENUELAS VEGASNV89193—null
PRVPRV-205842026-06-16T11:48:51ZTYLEER··—MITCHELL1981-06-17·UHC-18397-61-16029846082····null———NULL··-
PRVPRV-250012026-04-16T18:09:02ZMENDEZ—JORDAN19710610UHC-72598-96-696-366-7600JORDAN.MENDEZ@OUTLOOK.COMN/A-N/ANULLNULLMEDICARE-ADV-A
PRVPRV-200682026-04-02T14:59:48ZDiane—Lucas1950-03-12—•••-••-2558·(980) 994-6134—3522 Jefferson AvenueTampaFL·33637——
PRVPRV-273292026-09-22T15:04:13ZGAY—RICEJun 5, 1983UHC7924720N/A(658) 703-7804UNKNOWN9612 Union StDenver·CO80219-MEDICARE-ADV-B
PRVPRV-249302026-08-11T18:09:44ZCARLOS—FORD6/22/1973UHC-51499-08•••-••-8864(854) 479-6446··—3488 Palm DrTUCSONAZ85712--
PRVPRV-284372026-05-05T17:51:03Z Sophia—Park3/8/1970UHC1480943UNKNOWN779-697-1528—6165 Grand AvenueAustinTX78742—OPTIONS-PPO
PRVPRV-226172026-08-10T11:34:52ZAlice—Fox28-01-1956NULL•••-••-3661755.691.8267N/A4968 Mountain View DriveCharlotteNC28291-7104N/A—
PRVPRV-260922026-07-27T22:59:25ZRoyX.YoungApr 11, 1964nullnull6443274383UNKNOWN3149 Mountain View DriveJacksonvilleFL·32273UNKNOWNMEDICARE-ADV-B
PRVPRV-294842026-09-30T23:38:34ZWei—MarshallNov 21, 1979UHC-81522-17··—7992959881-6514 Mountain View Dr·ScottsdaleAZ85239—null
PRVPRV-264592026-08-01T03:11:29ZKAYLA—RICE1997-11-11UNKNOWN•••-••-36266258098kayla.rice@yahoo.com3442 Church StGILBERTArizona85272null—
PRVPRV-26806 2026-06-18T13:58:03ZAlan—Adams1967-08-10UHC-50559-22—2804951766ALAN.ADAMS4@ICLOUD.COM3569 MEADOW LNMinneapolisMN55480—MEDICARE-ADV-A··
PRVPRV-201552026-03-01T05:47:34ZCATHERINES.GOMEZ1944-12-26—null(932) 368-9026nullNULLUNKNOWN——-—
PRVPRV-238472026-05-13T04:04:40ZSUSAN—WONG··1939-04-05——4805225549—730 Desert Sky BoulevardSACRAMENTOCA95826····N/A
PRVPRV-289242026-09-19T16:08:24ZAmandaNCollins1995-12-18UHC-44091-18N/A3985287707—503 Meadow Lane··Las VegasNV89196-N/A
PRVPRV-206642026-07-05T12:38:49ZNancy—Bennett1940-03-16UHC-28664-92—(412) 255-5921null7655 Bayshore DriveDenverCO80244UNKNOWN—
PRVPRV-228332026-06-06T20:27:54ZTurner, Brenda——03-08-1983··UHC-44384-04———1252 Mountain View DriveColumbusOH43294——
PRVPRV-216272026-08-22T17:36:36Z ·Alexander, Kimberly——06/01/1955·NULL—16808536998··UNKNOWN8543 FOREST AVEChandlerArizona85243—null··
PRVPRV-264062026-04-14T12:18:58ZPhilip—Andrews19700806—UNKNOWN9803898782UNKNOWN5061 Elm StreetNASHVILLE··TN··37274-0813—CHOICE-PLUS-PPO
PRVPRV-251452026-07-19T07:57:35ZRoger—Edwards2002-01-01nullnull(878) 219-9861ROGER.EDWARDS@PROTON.ME1085 Forest AvenuePlanoTexas··null—
PRVPRV-253422026-08-20T20:09:59ZLisaQLee1970-07-14—-(594) 907-0880—589 ELM STREETNashvilleTN——-
PRVPRV-230112026-07-19T19:15:59ZJerry—Woods1995-08-03UHC-83700-12UNKNOWN—·null2742 OAK STREETMINNEAPOLISMN55406-9973NULL-
PRVPRV-218282026-01-08T14:16:58Z BRYAN—VALDEZJul 24, 1964UHC-23489-04•••-••-97993205360215—5054 LAKE VIEW ROADMesaAZ85254-CHOICE-PLUS-PPO
PRVPRV-256642026-02-23T08:01:17ZReyes—Braadley1949-11-12UHC-33181-94—·-BRADLEY.REYES@PROTON.MEUNKNOWNnullnullN/A—N/A
PRVPRV-233862026-07-06T03:34:02Z Melissa—Jordan···1981-10-21—null·6308822653—1628 Central AvenueMesaAZUNKNOWN—UNKNOWN
PRVPRV-284562026-03-05T10:41:22ZShirley—Patel19901108————8596 Mountain View DrFresnoCalifornia93740UNKNOWNnull··
PRVPRV-267862026-06-03T19:20:43ZLAWRENCE—SNYDER2007-03-28UHC-47696-50—8643689815·NULL2275 Harbor BlvdMiamiFL33157UNKNOWNnull
PRVPRV-239792026-02-16T23:49:19Z·Douglas—Welch1980-07-10UHC-34288-43—17235375636—3626 HILLCREST ROADDallasTX75250N/AN/A
PRVPRV-231322026-10-11T07:59:52ZSamuel—Marshall2008-01-11UHC-42128-45NULL19107025386null185 Union StColumbusoh43242·nullMEDICARE-ADV-A
PRVPRV-210962026-10-02T04:37:14ZDot—Clark03/13/89N/A·-851-880-3134··dorothy.clark57@icloud.com9671 Sunset BlvdSAN ANTONIOTX78258UNKNOWN-
PRVPRV-210022026-01-24T06:55:49Z GregoryTElliott08/16/1961·UHC-34661-18N/A3168762135-1131 Central AveATLANTAGA30332N/AOPTIONS-PPO
PRVPRV-29137 2026-03-01T10:02:39ZWatkins, Kathryn——1957-03-14UHC-05724-67•••-••-0586(343) 452-5990N/A2121 Union StNashvilleTN37261NULLnull
PRVPRV-226662026-01-03T14:03:31Zkenneth····carroll1972-70-18UNKNOWNnull(277) 667-4397—5265 Maple Avenue Apt 38DallasTX75298NULLMEDICARE-ADV-B
PRV PRV-242722026-08-10T19:39:07ZEthan··—Robertson7/21/2000null·····N/AN/A7669 Maple AveSan AntonioTX78202——
PRVPRV-218552026-06-11T22:05:44ZJOSEPHPSANCHEZ1950-03-16UHC-03075-13———1777 Central AvenueSan AntonioTX78272nullN/A
PRVPRV-223612026-03-12T06:47:29ZHamilton, Emma——Feb 10, 1973N/ANULL12894302431—9143 ELM STREET Apt 40SeattleWA98152UNKNOWN—
PRVPRV-284112026-08-07T16:25:33ZCARLOS—HENRYJul 13, 1980UNKNOWN··17703973382N/A1706 Jefferson AveMinneapolisMNN/A——
PRVPRV-219842026-10-04T08:10:06ZPatricia—Mendez07/01/04··N/AN/A···-7575 Union StMinneapolisMN55404—MEDICARE-ADV-A··
PRVPRV-215952026-07-12T01:24:38Z·STEPHENDFIELDS1988-05-24-null7257173083··—3886 Cedar LaneCharlotteNC28264—N/A
9,596 rows, page 128 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:53.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty