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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1071812026-04-27T17:31:49ZTERRYQ.··WONG··1942-08-17UHC-43194-92··•••-••-67538886964622—4830 Hillcrest RdFRESNOCA93700GRP-2446··SELECT-EPO
ENRENR-1004202026-06-30T10:27:41ZHarris, RobertB—10/27/83UHC-42531-34····8783630618ROBERT.HARRIS@PROTON.ME7190 MAIN STCharlotteNC28290GRP-3849MEDICARE-ADV-B
ENRENR-1086082026-03-16T06:50:10Z AnthonyURos·1984-09-02UHC-38512-88•••-••-7746+1 430 907 3514anthony.rios5@gmail.com5354 CAMELBACK ROADGilbertAZ85246GRP-2495MEDICARE-ADV-B
ENRENR-1228062026-01-17T11:37:45ZCharlesTWilliamson07/12/75UHC-92484-92—421-880-2017null2922 River RoadFresnoCA93765GRP-2558MEDICARE-ADV-B
ENRENR-1126332026-08-19T11:35:49ZOlivia—Thomas1966-01-14UHC-31622-35•••-••-3562+1 349 297 0755olivia.thomas@aol.com9328 Sage CourtPlanoTX75006GRP-1775OPTIONS-PPO
ENRENR-1227392026-09-10T21:41:23ZNOAHU.PRYCE1969-11-08UHC-27165-52•••-••-27275552532220noah.price@icloud.com4559 MARKET STREETPLANOtx75026GRP-2833CHOICE-PLUS-PPO
ENRENR-1316552026-07-28T17:27:13ZRALPH····GUZMAN1988-08-10UHC-55739-78•••-••-89097912715247—7461 Lincoln WayCharlotteNC28237GRP-2886CORE-HMO
ENRENR-1096392026-03-05T05:57:03ZVazquez, BrianG.—·07/16/70uhc-12630-18•••-••-4884(364) 661-5998N/A4314 WASHINGTON STREET·SacramentoCA95831··GRP-8130··CORE-HMO
ENRENR-1235912026-06-27T23:59:28ZChristopher—Marshall··08/27/1959UHC-31218-31•••-••-2839(240) 355-5494christopher.marshall62@outlook.com6291 HARBOR BOULEVARDTampaFL··33667-0229GRP-3781CORE-HMO
ENRENR-1151032026-07-18T12:06:50ZMaggie—Cruz01/09/01UHC-61807-71•••-••-2616nullMARGARET.CRUZ@GMAIL.COM9104 JEFFERSON AVEGlendaleAZ85353GRP-7146SELECT-EPO
ENRENR-1121112026-03-18T09:46:11ZLOGAN··—COX·1967-07-18UHC-60227-35•••-••-4768296-776-7447logan.cox13@hotmail.com5449 BAYSHORE DRHoustonTXUNKNOWNGRP-9754OPTIONS-PPO
ENRENR-1274152026-02-01T22:14:40ZMariaRNichols·1954-07-02UHC-45780-65··•••-••-7414+1 660 751 4682maria.nichols81@aol.com·9570 HARBOR BLVD·AtlantaGA30356GRP-3227··SELECT-EPO
ENR ENR-1177982026-08-19T01:24:16Z Ramirez, Heather——1985-09-07UHC-96401-94•••-••-4282+1 675 669 5687heather.ramirez@yahoo.com3843 MAIN STREETPLANOTX75050GRP-7768MEDICARE-ADV-A
ENRENR-1245492026-08-09T17:33:42ZBrian—Watson1975-03-19UHC0161426•••-••-16675452026N/A3215 Sage CourtLAS VEGASNV89184GRP-8817CHOICE-PLUS-PPO
ENRENR-1255592026-06-26T02:30:28ZEdwardEGreen1963-11-19UHC-68492-66-·3788755118edward.green@outlook.com7570 HIGHLAND AVE··Miami··FL33193GRP-3775MEDICARE-ADV-B
ENR ENR-1062992026-04-29T20:44:11Z·Arthur—Alexander19560820UHC-11557-51•••-••-14246064968151arthur.alexander60@aol.com4818 MARKET STREETNashvilleTN37273GRP-8607SELECT-EPO
ENRENR-1139002026-04-15T10:31:14ZHeatherG.Pricce·1957-11-07UHC-36993-92•••-••-8853974-888-7320HEATHER.PRICE@OUTLOOK.COM7101 Palm DriveDALLASTX75220GRP-7627·MEDICARE-ADV-A
ENRENR-1292592026-08-21T16:57:37ZHiroshiW.Morgan1994-04-16UHC-20795-47··•••-••-0452(913) 556-4881HIROSHI.MORGAN82@AOL.COM1282 Sunset Boulevard #577AtlantaGA30361GRP-9173OPTIONS-PPO··
ENRENR-1131732026-02-01T09:24:09ZGreen, MarianaT.··—1989-08-17UHC-41515-80null+1 354 715 9929—9052 Grand AvenueDenverCO80222GRP-4848NAVIGATE-HMO
ENRENR-1346492026-10-09T21:57:47ZHiroshi··N.Greene1997-09-26UHC-56048-27null(716) 296-6600HIROSHI.GREENE@ICLOUD.COM7106 MARKET STREETSacramentoCA95896GRP-0686SELECT-EPO
ENRENR-1133992026-08-01T12:06:11ZCox, RonaldA—19800809UHC-19931-06•••-••-1809(715) 717-3069ronald.cox@aol.com6564 CAMELBACK ROAD···Charlottenc28270GRP-8715OPTIONS-PPO
ENRENR-1189472026-04-15T12:13:12ZChristinaDArmstrong1997-01-04UHC-21735-06•••-••-2435425-634-4023christina.armstrong@yahoo.com8489 Pine DriveSeattleWA··98188GRP-3889OPTIONS-PPO
ENRENR-1377682026-01-15T12:06:48ZIsabella—·Halll1947-03-05UHC-55281-38null219-557-0261isabella.hall@aol.com9712 WASHINGTON STHoustonTX77040GRP-2445MEDICARE-ADV-A
ENRENR-1206322026-04-02T06:56:59ZJonathan—Bares1997-01-27UHC-03469-09•••-••-75342526437738JONATHAN.BARNES53@AOL.COM8367 ELM STREET··Charlottenc28252GRP-6542NAVIGATE-HMO
ENRENR-1344702026-01-25T04:58:54ZGLORIAF.ALVAREZ04-09-1956UHC-31983-88•••-••-3717+1 484 215 4398GLORIA.ALVAREZ@PROTON.ME··6186 Ocean Ave·DenverCO80241··GRP-0102·OPTIONS-PPO
ENRENR-1105772026-06-01T18:45:38ZJoeGColeman1952-07-16UHC-89912-98•••-••-6527(213) 613-2067joe.coleman55@yahoo.com5241 Cedar LnMesaAZ85208GRP-8337OPTIONS-PPO
ENRENR-1396022026-03-05T04:04:13ZDanielRLuna2/6/1967UHC-54159-78•••-••-4168(841) 908-7542—2620 Apache BoulevardHouston·TX77017GRP-0532CHOICE-PLUS-PPO
ENRENR-1074222026-07-07T05:28:10Z JudithFMartin1992-01-20UHC-58715-49-——3511 SUNSET BOULEVARD·Minneapolis·Minnesota55413GRP-6748OPTIONS-PPO
ENRENR-1262762026-09-18T11:42:16ZMATEO—GUZMAN1969-11-18UHC-81858-58•••-••-3458(698) 524-8265MATEO.GUZMAN16@AOL.COM341 Church StreetDallasTX75228GRP-2243CHOICE-PLUS-PPO
ENRENR-1002052026-01-08T09:16:07ZVincent Y—Ruiz20050928UHC-75913-18•••-••-51107193792334vincent.ruiz48@aol.com3625 Church StORLANDOFL32803GRP-9465NAVIGATE-HMO··
ENRENR-1114542026-03-09T14:38:33ZAllen, AishaA—1979-02-22UHC-59734-47•••-••-2010(748) 601-1768AISHA.ALLEN@OUTLOOK.COM6345 MEADOW LNScottsdale·AZ85262GRP-9141CHOICE-PLUS-PPO
ENRENR-1380512026-07-16T07:53:17ZSharon····Ruiz1996-02-26UHC-05868-02•••-••-095216668856260··sharon.ruiz@outlook.com2788 Washington StreetTampafl33609GRP-2076navigate-hmo
ENRENR-1427042026-04-24T14:34:43ZHiiroshiK.Willams1950-01-04UHC-95783-27•••-••-6585820-222-2304hiroshi.williams@proton.me232 MOUNTAIN VIEW DRIVEDENVERCO80275GRP-7302MEDICARE-ADV-B
ENRENR-1001672026-03-08T10:20:37Z·Bobby—Silva06/25/1966UHC-38822-20null5197957190bobby.silva@outlook.com2830 Main St··GlendaleAZ—GRP-8051NAVIGATE-HMO
ENRENR-1050842026-07-24T10:19:04Z·Clark, DotT—1989-03-13UHC-97273-05—851-880-3134dorothy.clark57@icloud.com9671 SUNSET BLVDSan AntonioTX78258GRP-8700OPTIONS-PPO
ENRENR-113203 2026-08-10T16:31:04Zlisa—·henderson12-05-1978UHC-46971-43•••-••-0055+1 754 794 4763·LISA.HENDERSON73@HOTMAIL.COM3644 SPRING STGlendaleAZ85300GRP-8726select-epo
ENRENR-1399472026-05-08T10:55:44ZDanielJ.Robertson1966-08-04UHC-84921-42•••-••-4849307-597-4977daniel.robertson@icloud.com2584 Sunset BlvdChandlerAZ·85259GRP-5902·OPTIONS-PPO
ENRENR-1052542026-08-25T09:18:02ZASHLEY—HAYES1993-03-18·UHC-32375-64•••-••-7916(406) 772-9967ASHLEY.HAYES@GMAIL.COM3942 Highland Avenue··PlanoTX75009-1410GRP-5292OPTIONS-PPO
ENRENR-1162212026-09-10T22:08:00Zcarolyn··garrett1989-07-02UHC-02947-44•••-••-75552928452722carolyn.garrett7@hotmail.com··1944 Main StAtlantaGAN/AGRP-9344NAVIGATE-HMO
ENRENR-1276692026-08-23T10:41:57ZDebra·····Gradner1997-08-09UHC-16971-47•••-••-6657(804) 982-8400debra.gardner70@icloud.com1300 CANYON ROADPlanoTX75055GRP-1296NAVIGATE-HMO
ENR ENR-1285952026-06-09T02:59:21ZZACHAARY S—SCHMIDT3/3/1956·UHC-39649-87•••-••-4082538-972-4331zachary.schmidt@proton.me9274 CANYON ROADHoustonTX77067··GRP-4206choice-plus-ppo
ENRENR-1267132026-03-04T05:00:22Z MichelleY.Spencer2002-07-28UHC-58399-69•••-••-7842UNKNOWNMICHELLE.SPENCER@GMAIL.COM4328 PINE DR #939PlanoTX75094-3252GRP-3742CORE-HMO
ENRENR-142244 2026-09-13T15:15:53ZMICHAELB.WEBER27-12-1950UHC-63996-85··•••-••-8946(939) 833-7186—2445 Baseline RdTUCSONAZ··85705GRP-0730CHOICE-PLUS-PPO
ENRENR-1226442026-04-02T03:02:02ZAllen, Debra·······1938-06-15UHC4923369•••-••-5584(979) 724-1815debra.allen91@hotmail.com4355 Baseline RdTempeAZ85271GRP-1299··OPTIONS-PPO
ENRENR-1277442026-06-22T04:42:08ZCAROLYN··AWALLACE1997-07-24UHC-71193-56•••-••-2239(399) 791-4383carolyn.wallace35@yahoo.com6953 Ridge RoadTEMPEAZ85237GRP-5966··NAVIGATE-HMO
ENRENR-1171332026-01-09T15:01:52ZJeremyLDean19521202UHC-08912-03•••-••-22846474030656JEREMY.DEAN@AOL.COM6029 CENTRAL AVENUE·Eden Prairie·MN-GRP-9453·NAVIGATE-HMO
ENRENR-1356432026-07-29T11:27:22ZalbertUjohnston09-05-1961UHC-58242-57•••-••-27655548778504albert.johnston@icloud.com5512 HIGHLAND AVETucsonAZ85750GRP-3804·SELECT-EPO
ENRENR-1409392026-06-28T10:08:23Zpriya—matthews08-05-1962UHC-39612-05•••-••-885217805368504priya.matthews@yahoo.com1255 Grand AveGilbertaz85244GRP-3575CORE-HMO
ENRENR-1021002026-09-30T09:22:22ZAlbert·D·Montgomery01/07/1991UHC-04094-79•••-••-4113823-432-3889—6612 Washington St··Los AngelesCA90063GRP-7717NAVIGATE-HMO
ENRENR-1427312026-03-01T18:50:17ZBetty·UWang1985-06-11UHC3116220•••-••-8545211.977.1209betty.wang38@hotmail.com8453 Washington St·MinneapolisMN—GRP-3900NAVIGATE-HMO
43,101 rows, page 2 of 863PreviousNext

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