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-1184952026-06-20T06:06:36ZDEBORAH—MATTHEWSMar 18, 2000UHC-61134-65•••-••-57428887918875deborah.matthews@gmail.com4182 Desert Sky BlvdGilbertAZ85236GRP-3850MEDICARE-ADV-A
ENRENR-1380022026-09-16T02:53:58ZJudy—Bryant1997-07-04UHC-19209-50•••-••-9976392.997.5513—3537 LINCOLN WAYSeattleWA98117GRP-2518choice-plus-ppo
ENRENR-1076152026-08-20T01:00:17Z WalterGMejia1953-04-24UHC-68970-84•••-••-51632133755482—·2777 INDIAN SCHOOL RD·HoustonTX77013··GRP-7201SELECT-EPO
ENRENR-1041622026-06-19T09:57:19ZPhillpis, RebeccaG—11/25/1966UHC-96782-86—504-705-7126-2503 Lincoln WayMiamiFL33141GRP-8847CHOICE-PLUS-PPO
ENRENR-1131932026-04-26T21:30:00ZHelen—Davis·2007-05-21UHC-01265-21NULL903-967-4370—4057 Park Place·MiamiFL33164GRP-9646CHOICE-PLUS-PPO
ENRENR-1285792026-02-02T12:50:46ZDIEGOCROBERTSONJan 12, 1998uhc-11231-23•••-••-6608851-808-5815DIEGO.ROBERTSON49@GMAIL.COM4317 Desert Sky BlvdEden PrairieMN55320GRP-6805MEDICARE-ADV-A
ENRENR-1179692026-05-31T06:20:16ZBRYAN—FERGUSON1977-11-06··UHC-51134-40•••-••-5297268-594-0852bryan.ferguson43@outlook.com323 LINCOLN WAYTampaFL··33643GRP-2075CHOICE-PLUS-PPO
ENRENR-1350162026-07-02T13:22:46ZAnthony—Jordan03/14/1979UHC-38827-56•••-••-3578709-697-4630··anthony.jordan55@icloud.com·6601 Willow CourtMesaAZ85284GRP-1264·MEDICARE-ADV-B
ENRENR-1101272026-05-30T13:26:59ZAMYO.ELLIOTT1950-07-18UHC-43246-58•••-••-7331—N/A9846 Harbor Boulevard Apt 28Eden PrairieMN55309GRP-1944CORE-HMO
ENRENR-1026572026-01-09T14:04:25ZCatherineQRussell··08/17/1976UHC-22701-22··•••-••-1557(692) 779-6891CATHERINE.RUSSELL57@OUTLOOK.COM5555 Apache BlvdTempeArizona85261GRP-1128CORE-HMO
ENRENR-1256912026-10-02T06:05:18ZLARRY·K·BANKS1947-05-21UHC-47014-15•••-••-63095708945326LARRY.BANKS75@YAHOO.COM7288 Mesa DrSacramentoCA··95840GRP-5849MEDICARE-ADV-B
ENRENR-1350532026-05-14T08:49:55ZthomasMalexander1977-06-25UHC-06171-62•••-••-88145323175285thomas.alexander@yahoo.com178 BROADWAYSAN ANTONIOTX78206GRP-2237NAVIGATE-HMO
ENRENR-1382322026-02-26T03:09:45ZTYLEROFOWLER06/22/93UHC-66179-73•••-••-0004+1 715 588 4751null1887 Cedar LaneJacksonvilleFL32233GRP-2302MEDICARE-ADV-A
ENRENR-1248632026-06-19T04:42:23ZRussell—Valdez4/9/1968UHC-94337-10-6368216455··RUSSELL.VALDEZ24@GMAIL.COM5367 Pine DriveMiamiFL33107-9171GRP-6172MEDICARE-ADV-B··
ENRENR-1009692026-09-07T18:56:59Z———19481210UHC-23557-50•••-••-76129636611272—5148 Broadway·AustinTX78724GRP-7685SELECT-EPO
ENRENR-1406332026-05-29T16:11:58ZDeborahB.Hughes·01/10/1956uhc-56499-04•••-••-06458689929527DEBORAH.HUGHES@YAHOO.COM7923 Lake View RoadSan AntonioTX78224GRP-5846OPTIONS-PPO
ENRENR-1372392026-04-24T04:05:20ZBobbyT·Santos1953-01-24··UHC-56205-62—(695) 968-0235—1155 Jefferson AvenueChandlerArizona85214GRP-7217SELECT-EPO
ENRENR-1372842026-05-13T17:26:08ZJereym—Rios12/24/1938UHC-43577-47··•••-••-0245(473) 848-5439—1519 Market StreetPhoenixAZ85030GRP-4802SELECT-EPO
ENRENR-1002582026-06-17T16:28:28ZSEANV·COOK1984-03-16·UHC-89407-02—-—9409 Valley View DrJacksonvilleFL32210GRP-4499CORE-HMO
ENRENR-1421792026-09-21T20:04:47ZDEBRAD.OLSONJun 16, 2004UHC-60589-01•••-••-6069(522) 543-9715debra.olson6@yahoo.com2966 Park PlCOLUMBUSOH··43236··GRP-0831SELECT-EPO
ENRENR-128963 2026-01-12T23:48:20ZOLIVIA—DAVIS1995-11-18UHC-46336-83•••-••-2010·2384802672OLIVIA.DAVIS9@GMAIL.COM5346 ELM STREETCOLUMBUSOH43281GRP-5439CHOICE-PLUS-PPO
ENRENR-1272382026-01-13T08:18:25ZBRANDON··—HERRERA1964-08-28UHC-70155-85-616-822-4671BRANDON.HERRERA34@YAHOO.COM7494 Meadow LnHoustonTX77047GRP-7458MEDICARE-ADV-A
ENRENR-1094592026-03-19T21:16:21Z·Grace·UPattersonMay 26, 1983UHC-32210-74—14177646397grace.patterson@proton.me—null—N/AGRP-1011MEDICARE-ADV-B
ENRENR-1324422026-10-10T01:39:29ZJeremy·V.McDonald1940-06-12UHC-67446-94•••-••-2688(248) 562-6165—5567 Willow Court·FresnoCA93729·GRP-6445SELECT-EPO
ENRENR-1345082026-08-12T09:42:57Z·JanetJ.Evans1955-07-18UHC-24100-32··•••-••-02919832490350NULL101 HIGHLAND AVENUESacramentoCA95801GRP-8040CORE-HMO
ENR ENR-1353912026-03-04T06:23:35ZLisa·D·Day5/26/1967UHC-41010-93•••-••-4963384.279.0938LISA.DAY@HOTMAIL.COM263 LAKE VIEW RDLas VegasNV89182GRP-1423··MEDICARE-ADV-B
ENRENR-1324872026-05-26T18:06:12ZBenjamin—Rose2007-04-19UHC-01453-15N/A17459147095benjamin.rose@aol.com·1339 WILLOW CTPhoenixAZ85073GRP-6932OPTIONS-PPO
ENRENR-1295702026-06-05T13:06:23ZJackP.Pierce2002-11-21UHC-03253-72—17886800420·jack.pierce43@hotmail.com9823 Apache BlvdSeattleWA98164GRP-0219NAVIGATE-HMO
ENRENR-1144042026-01-05T23:58:39ZCHARLOTTEQLEE07-01-1938UHC-55912-53•••-••-6693(682) 675-4700charlotte.lee48@aol.com1687 Maple AvenueColumbusOH43216GRP-1114MEDICARE-ADV-A
ENRENR-1210162026-08-11T09:57:34ZCarlos W—Jordan2003-08-05UHC-31520-77•••-••-2293781.555.0835carlos.jordan42@yahoo.com7485 Camelback RdScottsdaleAZ85260GRP-9845SELECT-EPO
ENRENR-1005122026-10-12T10:31:46ZRichards, Alan··N—1940-71-20UHC8524022•••-••-0203—UNKNOWN7100 Spring StreetHoustonTX77031-9883GRP-7027·CHOICE-PLUS-PPO
ENRENR-124316 2026-05-03T00:19:03ZBetty—Lcas·1995-06-06UHC-18275-98NULL3466294565betty.lucas40@aol.com9708 Palm DrSan Antoniotx78206GRP-1568MEDICARE-ADV-A
ENRENR-1014622026-07-02T20:36:06ZBrian—Vargas1983-06-28UHC-54744-79•••-••-7140+1 826 850 0864brian.vargas13@icloud.com5006 DESERT SKY BLVDSAN DIEGOCA92125GRP-5622MEDICARE-ADV-B
ENRENR-1368462026-05-22T09:19:04ZstevenKcole1982-09-07UHC-97690-65•••-••-3756(819) 804-0252-5310 Sunset BlvdGlendaleAZ85378GRP-7243···CHOICE-PLUS-PPO
ENRENR-1356892026-07-30T19:32:24ZMARIAGSTONE19530223UHC-66345-90··•••-••-3996697-979-7447MARIA.STONE@GMAIL.COM3800 SAGE COURT #456SACRAMENTOCA95814GRP-4940SELECT-EPO
ENRENR-1043142026-07-20T12:06:52ZARJUNEARMSTRONG1985-10-09UHC-08542-71•••-••-5966978-803-1626ARJUN.ARMSTRONG@HOTMAIL.COM8948 OAK STSEATTLEWA98134GRP-1094CHOICE-PLUS-PPO
ENRENR-1193652026-03-19T23:55:37Znancy—elliott2/3/1990UHC-42872-84•••-••-2857(717) 244-5407nancy.elliott@yahoo.com9279 Oak StreetTampaFL33607GRP-2433MEDICARE-ADV-A
ENRENR-1304042026-04-10T15:22:49ZLarry—Campbell28-10-1950UHC-12054-79•••-••-2656466-569-9102larry.campbell@yahoo.com5628 Ridge Rd Apt 7NashvilleTN37223GRP-6432SELECT-EPO
ENRENR-1115982026-07-14T06:32:09ZLarryU.··Shaw1964-12-18UHC-20579-77•••-••-4436·NULLlarry.shaw47@yahoo.com5306 DESERT SKY BOULEVARDSacramentoCalifornia95801GRP-6431MEDICARE-ADV-B
ENRENR-1100172026-08-01T14:02:47ZEdwardMBrooks1938-02-01UHC-00554-30—7958975348EDWARD.BROOKS96@ICLOUD.COM3916 Apache BoulevardEden PrairieMN55377GRP-9713CHOICE-PLUS-PPO
ENRENR-1070322026-07-15T12:50:59ZHanson, Nicole··——2006-01-09UHC-87068-62NULL(576) 852-6252NICOLE.HANSON59@HOTMAIL.COM3984 River Road·JacksonvilleFL32217GRP-5006CHOICE-PLUS-PPO
ENRENR-1270492026-07-29T10:43:02ZOmar····GuerreroUNKNOWNUHC-60254-91•••-••-2185276-733-8359omar.guerrero@proton.me6655 Church StreetAtlantaGA30399GRP-6441CHOICE-PLUS-PPO
ENRENR-1412192026-09-27T20:05:46ZJoshua—Crawford1966-05-13UHC-85570-06•••-••-61095014135null7519 Elm StreetDenverCO·80253GRP-2079NAVIGATE-HMO
ENR ENR-1044712026-04-24T18:30:04Zwilliam—cruz1964-02-18UHC-60410-04•••-••-3630850.410.5099william.cruz@hotmail.com8853 Baseline Road···ChandlerAZ85209GRP-6097OPTIONS-PPO
ENRENR-1369832026-07-15T23:37:07Z·ANTHONY—ELLIS10/7/2008UHC-61228-42•••-••-582712084612053anthony.ellis1@yahoo.com3764 Mountain View DrLas VegasNV89138GRP-6037OPTIONS-PPO
ENRENR-136236 2026-05-06T05:12:43ZPatricia·HCle1969-11-13UHC-32392-57•••-••-7247+1 650 266 6358patricia.cole65@outlook.com6828 Meadow LnMinneapolisMN55426GRP-9455MEDICARE-ADV-B
ENRENR-1309442026-04-03T06:50:48ZDENNISV·MORRIS1956-08-01UHC-52301-44NULLN/A-1163 Willow CourtMinneapolisMN55485··GRP-5944MEDICARE-ADV-B
ENRENR-1083892026-01-12T13:50:13ZAMBERX.BISHOP11/4/1982··UHC-24337-50•••-••-160415697082860··—1127 Meadow LaneFRESNOCA93719-6940GRP-5191CORE-HMO
ENRENR-1309082026-01-26T13:47:06ZBbby—Cole1989-06-10UHC-51664-05NULL+1 807 624 9165bobby.cole48@aol.com231 DESERT SKY BLVDColumbusOH43261GRP-1845MEDICARE-ADV-A
ENRENR-1060732026-08-15T15:00:43ZSamuel··—Woods1977-03-28UHC-92607-15•••-••-4240860-316-9630NULL5084 Oak StAustinTX78735GRP-0870MEDICARE-ADV-B
43,101 rows, page 160 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:38.488Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty