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-120762 2026-06-03T11:50:54ZSARA—·ESTRADA1989-09-41UHC-50584-31•••-••-01948857278051sara.estrada75@hotmail.com785 Palm DrJacksonvilleFL32220GRP-9948··MEDICARE-ADV-B
ENRENR-1413232026-01-21T09:49:00ZMARY··EMUNZ19560224UHC-13183-92•••-••-72084552197483mary.munoz1@yahoo.com6326 HILLCREST ROADFresnoCA93704GRP-4303MEDICARE-ADV-A
ENRENR-1217272026-06-10T13:43:00ZAishaO.Rogers1957-09-18UHC-32190-46··•••-••-4836948-776-4138AISHA.ROGERS@AOL.COM3115 MOUNTAIN VIEW DRIVE·SacramentoCA95801GRP-0539navigate-hmo
ENRENR-1168002026-06-01T14:08:54Z·Donna—Rice·1999-10-24UHC-80966-78•••-••-5597N/Adonna.rice@yahoo.com3631 Main StHoustonTX77002GRP-2230CHOICE-PLUS-PPO
ENRENR-1185752026-03-22T09:58:23ZCollins, GraceR—1988-09-08—•••-••-3170454-507-0571·NULL681 FOREST AVEMiamiFL33125GRP-9869MEDICARE-ADV-B
ENRENR-1384962026-09-17T05:53:18ZHernandez, CarolynS—12/07/1939UHC-64823-02•••-••-7396+1 363 225 4257carolyn.hernandez77@outlook.com2739 Pine Drive Apt 27AustinTX78739GRP-8777SELECT-EPO
ENRENR-1136892026-08-15T09:18:03ZTheresaNFoster19650906UHC-25697-06•••-••-61114606631243—8878 Lincoln WaySan AntonioTX··78209GRP-3916MEDICARE-ADV-B
ENRENR-1156312026-06-06T16:50:13ZKimberly—·Parker3/23/1947UHC-58767-15•••-••-7746359-649-1594KIMBERLY.PARKER@PROTON.ME5456 Church StAtlantaGA30384GRP-0247·CORE-HMO
ENRENR-1138182026-07-10T18:51:11ZDiegoBBowman23-12-1990UHC-32682-08•••-••-84239158017164·diego.bowman@gmail.com4924 Sage CtNashville··TN37206GRP-0345CHOICE-PLUS-PPO
ENRENR-1276092026-08-28T00:45:43ZHENRYLESTRADA1981-06-09UHC-01815-45•••-••-1077(240) 421-2267HENRY.ESTRADA5@ICLOUD.COM7816 Willow CtPHOENIXAZ85099GRP-4243CHOICE-PLUS-PPO
ENRENR-1391062026-05-24T09:40:27ZLewis, Lucia——11-06-1969UHC-36306-59•••-••-4085(905) 381-0469LUCIA.LEWIS@GMAIL.COM4823 FOREST AVEGilbertAZ85277··GRP-3180MEDICARE-ADV-B
ENRENR-1114492026-01-05T07:08:15ZEvelyn··—Ramos12/2/1970UHC-77500-44•••-••-1472·(937) 424-7729evelyn.ramos@icloud.com330 Baseline RoadOrlandoFL32832GRP-7522MEDICARE-ADV-B
ENRENR-1211122026-03-30T11:09:18Z kathrynAhayes1971-09-11UHC-11060-89··UNKNOWN5584057733KATHRYN.HAYES@YAHOO.COM9284 Cedar LaneJacksonvilleFL32261GRP-3991NAVIGATE-HMO
ENRENR-1315852026-08-05T19:31:14ZCatherineP.·Ford1979-06-12UHC-30007-90•••-••-0334506.304.0716catherine.ford@yahoo.com1178 GRAND AVENUEAustinTX78712GRP-5108MEDICARE-ADV-B
ENRENR-1017852026-06-17T23:17:27ZAnnS.Harrison1979-09-24uhc-02311-94•••-••-4100299.681.7307ann.harrison@aol.com4916 Central AveChandler··AZ85206GRP-5756MEDICARE-ADV-A
ENRENR-1252792026-09-04T08:30:13ZGARZA—·FRANCES2000-08-16—•••-••-4305324-217-3350frances.garza@icloud.com3974 Valley View DriveFRESNOCA93731GRP-6927··CHOICE-PLUS-PPO··
ENRENR-1376142026-08-21T17:06:38Zbeverly—rose1983-07-12UHC-30839-28•••-••-82985637182899beverly.rose94@proton.me5475 Grand AvenueSan Antoniotx78262-2446GRP-8891OPTIONS-PPO
ENRENR-1329572026-03-17T07:28:51ZAndreaQHudson22-02-1960UHC-74064-92•••-••-7856—andrea.hudson@yahoo.com2166 Lake View RoadLos AngelesCA90067GRP-9769CHOICE-PLUS-PPO
ENRENR-1267902026-01-13T23:13:24ZPatricia—Hawkins19921117UHC7437601•••-••-41008093577719NULL9003 Highland AveSan AntonioTX·78236GRP-2532SELECT-EPO
ENRENR-1352542026-06-23T07:09:15Z Berry, JosephD—1999-08-25UHC-73065-25NULL519-839-3357JOSEPH.BERRY@AOL.COM3868 MAIN STREET·AtlantaGA30372GRP-7464MEDICARE-ADV-A
ENRENR-1349182026-06-20T10:12:15Z·Diana—·Hunt28-07-1949··UHC-91212-74•••-••-1696869-868-0247-5404 Hillcrest RoadJacksonvilleFL32207GRP-3707CHOICE-PLUS-PPO
ENRENR-1282642026-03-08T02:25:51Z maria—salazar12/13/73UHC-61139-77•••-••-4483NULL··2905 Harbor Boulevard·LAS VEGASNV89192-0935GRP-4521··SELECT-EPO
ENRENR-1375752026-04-15T02:45:18ZChristinaPMitchell10/28/1960UHC-77759-59•••-••-1677·5852691353christina.mitchell4@hotmail.com228 Union StreetJACKSONVILLEFLnull·GRP-8763CORE-HMO
ENRENR-1352302026-01-15T07:18:12ZRAYX.EVANS1980-07-04UHC-28669-14•••-••-0105617-863-7100RAYMOND.EVANS86@OUTLOOK.COM8545 Pine DrMesaAZ85299GRP-4233SELECT-EPO
ENRENR-1430002026-09-18T00:49:43ZBurton, Sara····—·2/21/1983UHC0881259UNKNOWN888-662-5097sara.burton43@outlook.com5709 Sage CourtSAN DIEGOCA92157GRP-0730··MEDICARE-ADV-B
ENRENR-1117212026-03-05T03:58:44ZSTEPHANIEWWOODS··1995-10-19·UHC-93610-29•••-••-2494—stephanie.woods@hotmail.com129 BroadwayMiamiFL33163GRP-4818OPTIONS-PPO
ENRENR-1387562026-01-25T13:22:55ZChristian—Sandoval1953-07-09UHC-34963-43•••-••-7400537-268-4975christian.sandoval2@gmail.com6829 OAK STREET #977·TampaFL33660GRP-0386MEDICARE-ADV-A
ENRENR-1127762026-04-17T20:19:14Zaisha··bkaer03/19/1944UHC-54571-05•••-••-4540+1 225 803 1079aisha.baker@outlook.com5994 INDIAN SCHOOL ROAD Apt 8Charlotte·NC28210GRP-2005CORE-HMO
ENRENR-1305642026-10-06T11:40:13ZEricF.Taylor3/16/1965UHC-85425-75NULL—eric.taylor@hotmail.com3143 Mesa Drive·Eden PrairieMN55328-0203GRP-8777MEDICARE-ADV-B
ENRENR-1408432026-05-04T19:45:45ZSandra—Richerdson2008-03-12UHC-00981-78•••-••-33919109637712—3793 Canyon RdScottsdaleAZ85254-0999GRP-0600OPTIONS-PPO
ENRENR-1308802026-03-18T00:39:53ZPamela—Johnston1979-07-12UHC-19171-30·-943-699-6818null4813 OAK STOrlandoFLnullGRP-4999CHOICE-PLUS-PPO
ENRENR-1249482026-09-25T19:32:31ZEugenePFullerAug 22, 1947·UHC-17261-98•••-••-58104076674723··UNKNOWN738 Market StreetMinneapolisMinnesota·55473GRP-0811CORE-HMO
ENRENR-1106542026-02-06T17:52:55ZHIROSHI·PBURNS1958-03-23UHC1194728—4192530938NULL1047 Lake View RdDALLAS··TX75232GRP-5518CORE-HMO
ENRENR-1302792026-01-30T03:58:34ZBaker, Anna··——1960-11-24UHC-40076-30•••-••-88883776591620·anna.baker26@aol.com6503 Spring StDenverCO80248GRP-6190NAVIGATE-HMO
ENRENR-1020582026-05-09T21:59:35Z Coleman, Hannah—····1957-12-14·UHC-98061-34—·(881) 734-6540hannah.coleman59@outlook.com295 Desert Sky BlvdMinneapolisMN—GRP-7057MEDICARE-ADV-A
ENRENR-1223802026-08-04T21:48:36ZGloriaHRobertson1971-03-16UHC-12991-54•••-••-0066311-766-5701GLORIA.ROBERTSON@PROTON.ME5042 SPRING STSan DiegoCA92129GRP-7689CORE-HMO
ENRENR-1071592026-10-06T15:45:19ZCharlotte··H·Berry02/28/1943UHC-94531-76•••-••-3833——2548 MOUNTAIN VIEW DRIVESan Diego·CA92153GRP-7104CHOICE-PLUS-PPO
ENRENR-1192652026-05-28T07:05:39ZHunter, Evelyn——2000-05-17UHC-44106-24-853.867.4372evelyn.hunter@hotmail.com5600 Mountain View DrNashville··TN37210··GRP-7892CORE-HMO
ENRENR-1269942026-06-04T12:22:45ZMichelle D.····Murphy·1/17/1951UHC-22881-19•••-••-33944138767839·MICHELLE.MURPHY@OUTLOOK.COM2070 VALLEY VIEW DRScottsdaleAZ85209-9552GRP-9882MEDICARE-ADV-B
ENRENR-1097552026-04-19T11:30:40Zchristopher·X.adams26-06-1956UHC-88794-67•••-••-39373212790christopher.adams@aol.com4764 SPRING STREET·AtlantaGA30333GRP-5259MEDICARE-ADV-B
ENRENR-1053302026-02-26T08:48:30ZSEANBMARTINEZ··1592-11-26UHC-99852-73•••-••-98165774385369sean.martinez69@hotmail.com8877 Canyon RoadPhoenixAZ85052GRP-9386OPTIONS-PPO
ENRENR-1200552026-04-15T22:28:58ZGeraldCBennett·1957-03-26UHC-99151-13NULL9669953210··gerald.bennett@icloud.com9437 Washington St #446JacksonvilleFLN/AGRP-2674navigate-hmo
ENRENR-1313992026-05-08T13:58:45ZMarcusMRamirez1978-04-23UHC9718504•••-••-974318822519158marcus.ramirez86@proton.me8995 Sage CtMESAAZ85298·GRP-1041SELECT-EPO
ENRENR-1119442026-03-29T19:43:50Z·LoganZVega1999-02-16UHC-11562-55•••-••-20275514263—2873 Cedar Ln·AUSTINTX··78767-1687GRP-5668CORE-HMO
ENRENR-1287952026-03-21T00:33:26ZKatherine P.—·Hamilton1995-12-12UHC-73729-70•••-••-9017·309-517-4131katherine.hamilton@hotmail.com10 Mountain View DriveColumbusOH—GRP-1113SELECT-EPO
ENRENR-1119042026-02-23T15:25:29ZMarthaFNunez19720807UHC-26130-11•••-••-47593703245482MARTHA.NUNEZ@PROTON.ME3308 Maple AveNASHVILLETN·37246GRP-3541MEDICARE-ADV-B
ENRENR-1429932026-07-13T16:03:47ZBarbara—Marquez02-02-2002UHC-40992-91—4175518662·-9446 Hillcrest RdSan DiegoCA92193GRP-3713··MEDICARE-ADV-B
ENRENR-1365012026-08-06T08:28:37ZJenkins, SamuelK—1969-12-10UHC-51229-75•••-••-32362569759612samuel.jenkins34@outlook.com7360 Jefferson AveMinneapolisMinnesota55418-9570GRP-2772SELECT-EPO
ENRENR-1421602026-04-14T18:54:07ZANAPFORD2007-02-13UHC-54888-77•••-••-5294754-234-2591ANA.FORD68@PROTON.ME8252 DESERT SKY BLVD #487PlanoTX75038GRP-6273SELECT-EPO
ENRENR-1024682026-03-12T08:54:08ZJAQUELINE—·SIMPSON6/1/1951UHC2123896•••-••-8351858.295.1486jacqueline.simpson@icloud.com1304 Mountain View DrGILBERTAZ·85294GRP-4231MEDICARE-ADV-A
43,101 rows, page 292 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-22T12:42:43.453Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty