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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1404662026-05-18T09:03:49ZmariaD.soto19570124UHC-72498-95•••-••-33874738869095maria.soto57@proton.me9798 Main StreetGilbertAZ85239GRP-6308MEDICARE-ADV-A
ENRENR-1320702026-04-18T04:48:09ZRoyFRobertson1964-02-07UHC-28255-88•••-••-33327098785995roy.robertson54@aol.com6584 Park PlJacksonvilleFL32250GRP-7283OPTIONS-PPO
TPATPA-611672026-08-11T03:14:42ZKeith—Collins12/13/1980—NULL(802) 872-9234null7882 Lincoln Way Apt 14PlanoTX—null-
CLMCLM-4029082026-10-05T22:33:17ZPETERKBROOKS9/18/1965NULL—·NULL····2138 Union StSeattleWA98164N/ANAVIGATE-HMO
ENRENR-1182042026-02-04T14:59:16ZMarthaR.Boyd·1982-10-10UHC-31143-91•••-••-9119+1 701 658 2700martha.boyd@yahoo.com1811 Spring StLas VegasNV89108··GRP-1368NAVIGATE-HMO
PRVPRV-290632026-02-05T14:27:47ZSandra—Cunningham1962-04-13UNKNOWN-—··2627 Jefferson AveLos AngelesCAN/Anull-
ENRENR-1039292026-08-31T00:47:50ZKeithDMorales1973-08-27UHC-51608-34•••-••-48855556704672·keith.morales@yahoo.com9255 WASHINGTON STPLANOtx75009GRP-8759NAVIGATE-HMO
CLMCLM-4246272026-03-24T19:07:41ZAnn—Ferguson28-06-1972UHC4686734•••-••-3557NULLNULL5384 Hillcrest Rd #706Columbus··oh43278··NULL
TPATPA-63307 2026-04-10T02:15:01ZFatima······Anderson1996-07-03UNKNOWNN/AN/AUNKNOWNnull··N/A—null——
TPATPA-517622026-02-07T14:01:32Z·sandra—fuller09/17/83··UHC-21692-45nullN/AUNKNOWN2866 Bayshore DrLos AngelesCA90064-2827—CHOICE-PLUS-PPO
PRVPRV-205222026-05-02T11:38:59ZJEREMY··T.HARPERJan 17, 1981null—18214744500JEREMY.HARPER@YAHOO.COM5522 Baseline RoadLos AngelesCA90093null—
CLMCLM-4113282026-04-16T21:31:46ZBrittanyM.·Wilson19790102UHC-08584-56—NULLUNKNOWN-—N/A-GRP-2110—
TPATPA-560272026-01-04T20:30:06Z laura—mendez1995-12-09NULL•••-••-92582995950017·N/A5085 Bayshore DrPhoenixAZ85046--
ENRENR-1364372026-05-05T08:33:01ZchristinaXestrada·02/07/69uhc-05394-63•••-••-02902575743192christina.estrada@hotmail.com5680 Canyon RdNashvilleTN·37201GRP-9863CORE-HMO
ENRENR-1334172026-09-14T07:43:04ZPAUL—RAMIREZ11-07-1961UHC5752613•••-••-2945692-938-4437paul.ramirez@outlook.com3676 Bayshore DrSan DiegoCalifornia92119·GRP-5859OPTIONS-PPO
TPATPA-524872026-06-28T04:54:42ZANDY—DAVIS1980-03-19NULLNULL940.465.9477—1983 Oak StreetTucsonAZ85725-null
CLMCLM-4210522026-05-01T12:59:58ZFrank··—Howard1984-09-13UHC-75968-98-N/A—4846 ELM ST·GlendaleArizonaNULLGRP-6467····
TPATPA-527732026-06-08T20:35:07ZLOGAN—LUCAS9/26/1985—N/A929-522-3998—3084 DESERT SKY BOULEVARDMesaArizona85281nullNAVIGATE-HMO··
ENRENR-1146242026-05-07T18:39:13ZAnnZ.Gaarrett8/12/1995UHC-09859-50•••-••-75138698980737N/A1339 VALLEY VIEW DRScottsdale·AZ85219GRP-5913NAVIGATE-HMO
CLMCLM-4235122026-04-20T03:21:11Z·VINKENT—PERRY1968-01-10UHC-67325-82··null—····7903 Ocean AveMESAAZ·85217nullNAVIGATE-HMO
TPATPA-52045 2026-06-22T11:11:19ZKATHLEEN—OBRIEN2/5/1988NULLN/AN/A··9351 ELM STLos AngelesCA····GRP-7528··
CLMCLM-4250492026-04-01T04:58:59ZJohnson, Mark——1989-09-14UHC-68075-73•••-••-9441····—3957 Willow CourtSCOTTSDALEAZ85265GRP-5056OPTIONS-PPO
ENRENR-1084542026-06-10T07:40:04ZPriyaV.Stone1946-06-10-•••-••-29739712230293priya.stone@outlook.com8768 Bayshore DriveEden PrairieMN55373GRP-2463CORE-HMO
CLMCLM-4181262026-07-22T10:21:35ZHelen—Marshall1965-06-04UHC-81480-61•••-••-5360938-486-8552——UNKNOWN—-GRP-2468CORE-HMO
TPATPA-604652026-06-24T01:56:20ZDennis—Alvarez1979-08-21UHC-79179-52•••-••-1031--·3110 Desert Sky Blvd·Planotx75063null-
CLM CLM-4057282026-04-12T20:28:26ZBRADLEY—CARROLL11-04-1978UHC-55821-47•••-••-423718897810735—9524 Palm Drive·Eden PrairieMN55384GRP-7390null
TPATPA-597412026-02-23T07:17:01ZMARTHA····REID1981-01-12N/A—UNKNOWN··UNKNOWN·1230 Camelback RoadAtlantaGAnullUNKNOWNSELECT-EPO
CLMCLM-4022712026-01-21T19:15:30ZKatherineY.··Marquez1976-01-17UHC-21181-70—(923) 639-0778null6413 Grand AvenueCOLUMBUSOH—GRP-3706NAVIGATE-HMO
CLMCLM-4165122026-04-13T10:26:12ZAnthony—Cox1949-08-20N/AUNKNOWNN/A·anthony.cox@hotmail.com7541 Maple Ave #100San AntonioTX78272GRP-7926—
TPATPA-573742026-06-19T20:50:09ZGREGORY—LAWSON07-06-1967—•••-••-7641—GREGORY.LAWSON@ICLOUD.COM3612 Palm DriveTUCSON·AZ85710—NULL
TPATPA-521202026-04-23T18:57:03ZGABRIEL—ROBINSON1952-09-09NULLnull9824779733——NULLUNKNOWN-UNKNOWNSELECT-EPO
ENRENR-1411332026-04-28T06:47:13ZRAYMONDY.CHAPMAN1975-12-27UHC-57667-96•••-••-9566202.346.7133raymond.chapman33@proton.me··739 River Road Apt 39NashvilleTN37239GRP-4601CHOICE-PLUS-PPO
ENRENR-1122352026-03-01T14:30:55ZkarenC.henry10/20/07UHC-60245-90··•••-••-74848939173519KAREN.HENRY@GMAIL.COM9161 Main Street··MiamiFL33130GRP-1872SELECT-EPO
ENRENR-106713 2026-09-27T21:28:51Z—A—25-10-1961uhc-64703-56•••-••-75104732937664··null··870 MARKET STOrlandofl32832-8301GRP-5950CORE-HMO
ENRENR-1051612026-06-23T07:59:48ZJoyceODuncan19820914UHC-07860-94•••-••-31249555856598N/A3519 Ridge RdDALLASTX-GRP-8569SELECT-EPO
CLMCLM-4182872026-09-08T07:21:31Znatalie—stewart15-01-1967—•••-••-7408801-396-8414—4853 Jefferson Avenue Apt 4MESAAZ85231GRP-3722—
ENRENR-1267842026-01-16T07:51:08ZEugene··Cole1939-11-07UHC-83421-32•••-••-717618508837504eugene.cole@proton.me·2170 HILLCREST RDLos AngelesCalifornia90081GRP-6699OPTIONS-PPO
ENRENR-1099562026-07-05T05:45:11ZYUKI—CAMPBALL·1970-04-08·UHC-79698-62•••-••-6105675.245.7915YUKI.CAMPBELL70@OUTLOOK.COM3878 Ridge RdEden PrairieMN55302-0843GRP-9208NAVIGATE-HMO
PRVPRV-223282026-07-18T13:21:37ZBrittanyQGraham1987-01-04UHC-81173-09—5376023613UNKNOWN3057 Sunset Boulevard·TampaFL——SELECT-EPO
CLMCLM-4148232026-02-22T03:17:37ZJohn··Salazar9194-07-01UHC-24125-50-554-968-0666NULLUNKNOWNN/AUNKNOWNNULLGRP-4010MEDICARE-ADV-B··
ENRENR-1341952026-04-19T16:32:37ZEmily—Cox11/28/60UHC-78445-65•••-••-9197-emily.cox90@yahoo.com3791 Washington StreetEden PrairieMinnesota55368·GRP-7101MEDICARE-ADV-B··
ENRENR-1016472026-09-10T01:55:45ZKATHERINEW···ROBERTSON02/16/77UHC-26141-96-9442618023katherine.robertson@aol.com2864 Lake View RdPlanoTX75013GRP-8752SELECT-EPO
TPA TPA-644412026-01-19T04:51:25ZRichard—Lucas1947-06-12NULL•••-••-2590·null-·6760 HILLCREST ROADLas VegasNV89143N/A—
TPATPA-609832026-06-24T22:41:36ZNICOLE—·GILBERT1951-01-25NULL-NULL———NULL—N/A—
TPATPA-563282026-06-30T01:47:52Z·LINDA—WEAVER2008-05-21—•••-••-45315002717806N/A3756 Meadow Ln Apt 40PLANOTX75057——
TPATPA-529312026-08-07T23:06:46Znicole—burke04/14/1985··—NULL(904) 985-4277UNKNOWN7663 River RdOrlandoFlorida32872—N/A
ENRENR-1095872026-01-20T00:58:12ZanaZburns19790127UHC-41549-61··•••-••-4209825-596-9663ANA.BURNS@YAHOO.COM226 OCEAN AVE #137ORLANDOFL·32861GRP-2544CORE-HMO
TPA TPA-571332026-04-02T19:34:06ZCarl··—Wang04/05/1944—N/A—carl.wang@gmail.com8827 RIVER RDOrlandoFL32800-3587N/A-
ENRENR-1281002026-07-09T02:51:52ZAnthonyNMoore02-01-1999UHC-26830-07•••-••-073918385953722—8792 Highland Ave·PlanoTX··—GRP-9753CHOICE-PLUS-PPO
ENRENR-1002312026-02-28T05:04:20ZAaronV.Bryant1946-12-06UHC-21701-55•••-••-279818282660741aaron.bryant@icloud.com7725 CHURCH STTucsonAZ85786GRP-8250MEDICARE-ADV-B
100,000 rows, page 204 of 2,000PreviousNext

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:37.722Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty