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
CLM CLM-4082132026-05-14T07:22:43ZBilly··Olson1974-06-21uhc-87272-66•••-••-2053706-446-3924null2435 Main StreetSAN DIEGOca92126····SELECT-EPO
ENRENR-1342312026-03-20T02:44:51ZHudson, KellyE.—19720187-··•••-••-4601217.755.1084—7389 Willow CtMesaaz85205GRP-6531SELECT-EPO··
CLMCLM-4214002026-09-24T20:44:39ZJeffrey—Park06/15/1938N/A··-(790) 363-8100N/A5894 Pine DriveChandlerArizona85282GRP-7681OPTIONS-PPO
ENRENR-1400982026-07-27T00:22:17ZLauren—·Ryan13-01-2006UHC-80172-58•••-••-1354-NULL4827 Hillcrest RoadMesaaz85239GRP-6702MEDICARE-ADV-A
ENRENR-1006932026-05-11T05:32:28ZJean··RDiazFeb 4, 1977UHC8069117•••-••-894313412474979jean.diaz@hotmail.com838 BASELINE RDTampa·FL33676GRP-5971CHOICE-PLUS-PPO
ENRENR-1222872026-04-28T15:12:39ZEMMA—ALVAREZ1957-02-22UHC-06682-04•••-••-0730(821) 515-2481emma.alvarez@yahoo.com7288 Union StGilbertAZ85213GRP-1997NAVIGATE-HMO
CLMCLM-4223432026-05-11T12:58:26ZMartha—Dixon12/27/1980UHC-22273-83•••-••-519117392825747MARTHA.DIXON@ICLOUD.COM6794 Park PlAtlantaGA30377——
PRVPRV-264352026-05-14T18:49:52ZSandra—Franklin·2007-06-07UNKNOWN•••-••-1607551.494.1927null8987 Palm DriveJACKSONVILLEFL·32257——
ENRENR-1090742026-04-23T22:02:54ZMateo··—Lopez1978-04-21UHC-64208-95•••-••-4414+1 739 729 7859mateo.lopez13@hotmail.com2923 Desert Sky Boulevard··DallasTX75222-6245GRP-9089CHOICE-PLUS-PPO
ENRENR-1134442026-05-01T13:11:21ZDavid—Yang2008-01-27UHC-06564-81•••-••-66892063808058david.yang20@hotmail.com7936 Park PlAtlantaGeorgia30313GRP-0989·MEDICARE-ADV-B
ENRENR-1070462026-06-18T20:40:22ZSmith, EricA—1997-09-09··UHC-59513-92•••-••-326713888402273—5502 Valley View DriveSacramentoCA95847GRP-7781NAVIGATE-HMO
ENRENR-1412052026-03-21T00:43:27ZCAROLYN··PAYNE·6/9/1978UHC-43307-68•••-••-8883(766) 633-9374null5657 Bayshore DriveOrlandoFL32824·GRP-1658CHOICE-PLUS-PPO··
TPATPA-619832026-05-23T05:16:34ZFATIMAYFISHERUNKNOWNN/AUNKNOWN5763013331fatima.fisher@aol.com8668 Oak StSan DiegoCA92121··——
CLMCLM-4315992026-07-26T23:53:45Z·Beverly—SchultzJul 9, 1981UHC-83728-87•••-••-8403null—627 Highland AveDallas·TX·75261·GRP-4646MEDICARE-ADV-A
TPATPA-568902026-06-08T06:16:48ZAUSTIN—REID6/25/1958UNKNOWN·null·623-443-9959austin.reid48@outlook.com6147 Harbor BlvdMesaaz—GRP-1410-
ENRENR-1357332026-09-26T02:53:10ZlawrenceW.flores2008-06-27UHC-58157-26•••-••-70629754369lawrence.flores84@outlook.com7822 OAK STLos AngelesCA90024··GRP-8223MEDICARE-ADV-A
CLMCLM-414465 2026-03-02T16:23:30Zwilliam—allen06/12/53UHC-46233-87•••-••-8473——430 Highland AvenueDallasTX75267GRP-4503SELECT-EPO
CLMCLM-4313322026-05-21T19:44:22ZStewart—Rebecca09/21/1941UHC-12215-27•••-••-8782—null··378 Willow CtPlanoTX75059GRP-1751N/A
PRVPRV-250892026-09-14T03:37:48ZVasquez, Janet——1945-02-20UHC-06138-79—6722671938null650 BAYSHORE DRSan DiegoCA92107—N/A
ENRENR-1188412026-06-28T18:14:19ZNancy—Daniels1969-03-01UHC-33110-86•••-••-8041+1 369 751 4988nancy.daniels@hotmail.com7100 Highland AvenuePhoenixAZNULL··GRP-0884MEDICARE-ADV-B
ENRENR-1364792026-07-08T13:08:04ZSEAN—KELLY2003-08-08UHC2415974•••-••-6571(278) 482-6768—4766 Grand AvenueEden PrairieMN55307GRP-6924NAVIGATE-HMO
PRVPRV-227192026-03-24T13:36:14ZSCOTTB.JOHNSTON06/01/91—•••-••-3274UNKNOWNscott.johnston@icloud.com8261 Pine DriveSan DiegoCA92181UNKNOWNN/A
TPATPA-565382026-07-18T12:21:34Z·henry—perkins1980-07-05NULL•••-••-1054451.906.0510NULLN/A--—GRP-8785NULL
CLMCLM-423755 2026-06-01T00:36:13ZPhilip··U.Spencer1953-12-04-—(641) 510-5709—238 Highland AveTempeAZ··85269GRP-5495OPTIONS-PPO
ENRENR-1315502026-09-24T20:35:33ZJuanTMorris10/17/08UHC-99012-31-(449) 580-1407juan.morris@hotmail.com2005 Church StLOS ANGELESCA90059GRP-4029MEDICARE-ADV-A
ENRENR-1152352026-08-08T09:26:38ZShirley—Jensen1957-03-15UHC-92914-52•••-••-7125448.926.8805N/A3189 PINE DRIVEGLENDALEAZ85375··GRP-1115CHOICE-PLUS-PPO
ENR ENR-1295342026-01-19T05:33:46ZJonathanF·Sanchez2003-11-10UHC-05896-07•••-••-0157+1 275 905 1953JONATHAN.SANCHEZ@AOL.COM·8622 Park PlLos AngelesCA90084GRP-6920MEDICARE-ADV-A
CLMCLM-4114962026-06-25T12:57:54Z·Edward—·Ward1939-08-01UHC1507161•••-••-2021(440) 360-0369null4128 Washington StreetAtlantaGA30301GRP-0328null
CLMCLM-4236172026-06-27T18:04:48ZAUSTIN—HARVEY·02/02/1988UHC-73934-26—null—————-null··
PRVPRV-293532026-09-12T06:04:23ZLauren—Miller1991-09-18—•••-••-5943——1142 RIVER ROAD·DenverColorado80281——
CLMCLM-4211312026-02-24T03:44:36ZHANNAH····HOFFMAN10/12/51UHC-41519-61null(641) 821-4518null2300 Elm StreetORLANDOFL··32879nullnull
CLMCLM-4259112026-02-16T18:00:08ZAISHA—·LUPEZ03/03/1971·NULL•••-••-7682——24 Desert Sky BoulevardChandlerAZ85260GRP-4702CORE-HMO··
ENRENR-1071682026-01-20T13:14:10ZLAURA—YOUNG1963-02-11UHC-41482-56•••-••-91192606975LAURA.YOUNG@HOTMAIL.COM6955 Cedar LaneJacksonvilleFL32261GRP-5312NAVIGATE-HMO
TPATPA-58684 2026-10-16T05:27:46ZVirginia··Black1959-02-23UNKNOWNnull(507) 412-9846N/A5876 Desert Sky BoulevardMesaAZ—GRP-0807MEDICARE-ADV-B
CLMCLM-4197252026-05-04T16:29:57ZJoshua—Walker1948-12-24UHC-45586-72•••-••-0668714-411-9642—1765 Lincoln WayOrlandoFL32806nullnull
CLMCLM-4153912026-05-23T02:11:54Z MARIAAN—VALEZ1982-11-22UHC-75813-69•••-••-6987——1961 Apache BoulevardDallasTX75267GRP-8742MEDICARE-ADV-A
PRV PRV-243822026-03-20T00:18:28Zhenry—stevens26-10-1970UHC-50709-36•••-••-1130(813) 894-2341HENRY.STEVENS80@AOL.COM9556 Sunset BoulevardEden PrairieMN55343-9561null·UNKNOWN
TPATPA-579952026-08-23T22:19:32ZVICTORIAI··PETERSON03/17/04··•••-••-2120null——UNKNOWN-UNKNOWN—NAVIGATE-HMO
TPATPA-620472026-09-14T04:14:47ZCHRISTINE—VALDEZ1960-02-08—•••-••-1477N/AN/A—UNKNOWN—NULLN/A-
CLMCLM-4325432026-08-01T03:47:21ZPaulPKelly1989-01-13UHC-35201-48•••-••-2037UNKNOWNUNKNOWN7184 Apache BlvdSeattle··WA98118NULL—
ENRENR-1134722026-07-03T13:42:22ZSharon··Bryant1996-06-03UHC-82381-52—434-649-7131sharon.bryant96@yahoo.com316 MOUNTAIN VIEW DRIVEMIAMIFL33131GRP-3091NAVIGATE-HMO
ENRENR-1394932026-02-13T20:39:05ZjonathanDparker1980-11-23UHC-32181-76•••-••-42863164609757JONATHAN.PARKER63@GMAIL.COM9061 Pine Drive··OrlandoFL32891GRP-2259·NAVIGATE-HMO
CLMCLM-4052352026-07-07T07:26:59ZJESSICCA—MONTGOMERY19-07-1977UHC-28580-22nullnull—·-—UNKNOWNnull—OPTIONS-PPO
TPATPA-603202026-10-01T07:08:49ZJUSTIN—SHAW1942-04-02—•••-••-2772896-604-0696null5769 Oak StreetLAS VEGASNevada89112GRP-9764··SELECT-EPO
ENRENR-1260542026-06-03T05:03:42ZJOYCE—SINGH1981-04-16UHC-91644-05•••-••-13159489880JOYCE.SINGH@PROTON.ME5268 Bayshore DriveAustintx78767GRP-4138MEDICARE-ADV-A
ENRENR-1160292026-08-18T14:10:46Z MARI—MATTHEWS1967-12-24UHC-24311-20•••-••-74659173203898maria.matthews46@icloud.com1610 Willow CtScottsdaleAZ85281GRP-7094MEDICARE-ADV-A
TPATPA-607592026-10-02T15:13:37ZJUSTIN—·WATKINS2/19/2004—nullUNKNOWNJUSTIN.WATKINS@ICLOUD.COM—nullUNKNOWNUNKNOWNGRP-8115MEDICARE-ADV-B
ENRENR-1412722026-01-28T00:15:34ZWAYNE··LOPEZ20011226UHC-76174-84•••-••-25826396090321WAYNE.LOPEZ@AOL.COM8070 HIGHLAND AVENUEDALLAS··TX75296GRP-8784NAVIGATE-HMO
CLMCLM-4210382026-05-18T13:51:36ZGray, Evelyn··——09/15/1968··UNKNOWN··•••-••-3378null—5902 Canyon RdDenverCO80284GRP-8921N/A
ENRENR-120930 2026-04-19T03:24:36Zalan—mills2/18/1998UHC-85719-06•••-••-96293477457703ALAN.MILLS@HOTMAIL.COM6345 Church StEden PrairieMN55347GRP-6762MEDICARE-ADV-B
100,000 rows, page 222 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.732Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty