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-1410592026-04-18T18:08:16ZAlice—Ortiz1971-04-13UHC-15710-14•••-••-8516·6908508979alice.ortiz24@hotmail.com152 Maple AveSeattleWA98195GRP-4059MEDICARE-ADV-A
ENRENR-1067982026-07-11T20:11:25ZBenjaminKHunt1993-07-05UHC-46402-70•••-••-8039492-327-1607benjamin.hunt19@outlook.com8179 INDIAN SCHOOL RDAtlantaGA30372GRP-4474·MEDICARE-ADV-B
ENRENR-119565 2026-01-10T03:04:50ZNicole—Padilla1402-70-03UHC-62109-38•••-••-2891659-416-7735nicole.padilla47@aol.com6464 Highland Avenue #838·EDEN PRAIRIEMN55304GRP-6902CHOICE-PLUS-PPO
ENRENR-1355922026-10-12T18:44:22ZMARIA—WANG1953-08-01UHC-42599-86null8606226625maria.wang@aol.com2575 SUNSET BLVDLos AngelesCA90074GRP-1874NAVIGATE-HMO
ENRENR-1357972026-03-25T19:30:03Z·KatherineDRomero1996-09-09UHC-13083-03null329-305-9455N/A284 Spring StreetLAS VEGASNV89188GRP-7510NAVIGATE-HMO
ENRENR-1185652026-08-20T17:27:28ZDiego··Ellis···1986-10-03UHC-94212-77•••-••-00434234890689diego.ellis@proton.me7247 BROADWAY #286Plano·TX·75037GRP-0477OPTIONS-PPO
ENRENR-1203632026-06-30T10:23:17ZGebrielFPatel20-03-1995·UHC-43384-72•••-••-0780(375) 584-3495GABRIEL.PATEL@GMAIL.COM2367 Valley View DriveHoustonTX·77012GRP-8097MEDICARE-ADV-B
ENRENR-109811 2026-02-07T16:54:31ZHicks, AbigailN—04/05/01UHC-46842-79null—ABIGAIL.HICKS@YAHOO.COM251 Hillcrest RdSeattleWashington98176GRP-2410NAVIGATE-HMO
ENRENR-1128872026-01-18T09:08:58ZMarianaQ.Stevens1967-07-19·UHC-13667-19UNKNOWN8007454249null2593 MAIN STMinneapolisMN·55471GRP-6304CORE-HMO
ENRENR-1009762026-02-24T16:01:59ZROYQSIMMONS··1979-06-20UHC-85490-20•••-••-3129906-668-0814roy.simmons@yahoo.com5729 MARKET STREETTampa··FL33648GRP-5512OPTIONS-PPO
ENRENR-1013272026-08-26T17:51:56ZJANET—GIBSON8/4/1966UHC-41992-20—18566838272—8053 Mesa DrJACKSONVILLEFL32262GRP-2761core-hmo
ENRENR-1116122026-03-31T11:48:42ZCarlos—Jenkins1959-08-07UHC-61665-17•••-••-32524939410694carlos.jenkins@hotmail.com1581 Valley View DrChandlerAZ85291GRP-5648NAVIGATE-HMO
ENRENR-1335472026-09-22T15:27:09ZHeather—Meyer1985-05-19UHC-17486-97•••-••-87516239850085HEATHER.MEYER@PROTON.ME9200 Harbor BlvdCharlotteNC28252GRP-1221··CHOICE-PLUS-PPO
ENRENR-105276 2026-03-03T23:11:08ZSharon—·Wang1998-10-05UHC-92159-70•••-••-0982501-960-0064SHARON.WANG@PROTON.ME7860 Lake View RdAustinTX78718GRP-3635MEDICARE-ADV-A
ENRENR-1064442026-01-18T17:59:32ZKAYLAA.WILLIAMSON07/14/2008UHC-28782-70•••-••-1974(443) 244-6373NULL9478 Jefferson AveColumbusOH43221GRP-0637··CHOICE-PLUS-PPO
ENRENR-1327332026-03-17T10:47:31Z Frances—Weaver1999-12-23UHC6498959•••-••-96408169184825·frances.weaver@aol.com9050 Camelback RoadSeattleWA98143GRP-8966CHOICE-PLUS-PPO
ENRENR-1089792026-05-21T02:32:12ZAmanda—Hicks09-10-1972UHC-66518-56•••-••-2126(595) 886-4136AMANDA.HICKS60@ICLOUD.COM·5918 Forest AveMinneapolisMN55439GRP-2110CORE-HMO
ENRENR-1176102026-09-08T01:55:14ZRussell··SBailey1987-04-01UHC-87909-52•••-••-5798422-424-0293russell.bailey43@outlook.com4758 Maple AveChandlerAZ·85276-1843GRP-9058SELECT-EPO··
ENRENR-110892 2026-07-31T06:52:04ZSeanFHoffman1973-09-11UHC-22263-86•••-••-3612730-277-6931-6889 Park Pl··TempeAZ85208GRP-8138CHOICE-PLUS-PPO
ENR ENR-1194762026-01-14T10:00:31ZJohnny—Henry1944-01-19UHC-67530-07•••-••-8813(853) 261-4998john.henry@gmail.com9524 Desert Sky Blvd Apt 10AtlantaGA30391-9380GRP-3561·SELECT-EPO
ENRENR-1028282026-01-20T22:46:36ZAguilar, Santiago W——1/13/1946uhc-56097-85——santiago.aguilar@icloud.com7366 SUNSET BOULEVARDCharlotteNorth Carolina28219GRP-7794MEDICARE-ADV-A
ENRENR-1225972026-05-10T04:53:01ZKimberly—Gilbert1966-09-27UHC-95289-73—7165795307kimberly.gilbert60@aol.com5501 Baseline Road·PHOENIX·AZ85013GRP-1327NAVIGATE-HMO
ENRENR-1366232026-05-02T04:23:40ZVALENTINA—PAYNE1/26/1974UHC-22618-46•••-••-6118(884) 657-9959··VALENTINA.PAYNE@PROTON.ME4929 Church StreetJacksonvilleFL··32288GRP-3572CHOICE-PLUS-PPO
ENRENR-1117742026-07-06T09:21:35ZMARCUST.·GUTIERREZ16-04-1962UHC-08418-08•••-••-9730295-624-2373marcus.gutierrez33@outlook.com7640 Harbor BlvdGlendaleAZ·85361GRP-5302CHOICE-PLUS-PPO
ENRENR-1211852026-04-28T17:02:32ZYUKIAMARQUEZ11/13/1975UHC-38069-86•••-••-1961+1 714 234 9949yuki.marquez42@outlook.com5165 Mountain View DrHoustonTX77077GRP-5470NAVIGATE-HMO
ENRENR-1289432026-01-10T06:39:01ZHiroshi—Nunez1967-05-09UHC-58279-98•••-••-9181(240) 693-2640hiroshi.nunez62@yahoo.com1799 Palm DriveNashvilleTennessee37219GRP-7540SELECT-EPO
ENRENR-1351002026-06-23T10:56:07ZBRADLEY—BISHOP2001-09-22UHC-02311-67•••-••-8079350-362-5688NULL·3761 Oak StCHANDLERAZ85221GRP-0534medicare-adv-b
ENRENR-1354922026-06-02T18:40:29ZSantiagoHCollins06/10/2001UHC-73279-07•••-••-835019174053500santiago.collins@aol.com850 Bayshore DriveFresnoCA93706GRP-6369OPTIONS-PPO
ENRENR-1234602026-03-27T18:24:57Z CHRISTIANWWEBB09-05-1994UHC-47362-27•••-••-6411(478) 908-4066-3877 Willow CtDenverCO80274-4981GRP-1486NAVIGATE-HMO
ENRENR-1138122026-03-02T00:26:37ZANNW··HUDSON1944-06-11UHC-45319-60•••-••-7337(487) 269-0160ANN.HUDSON@YAHOO.COM1546 HIGHLAND AVE··NashvilleTN37278GRP-8326CORE-HMO
ENRENR-1327132026-09-16T15:34:51ZSophiaN·Herrera1942-03-20UHC-53191-48•••-••-5600NULLnull5734 Lincoln WayScottsdale··AZ85220GRP-1053MEDICARE-ADV-A
ENR ENR-1172722026-07-29T08:55:54ZMARILYNGNGUYEN11/23/1988UHC-42780-06•••-••-33362712659876marilyn.nguyen@yahoo.com7033 Palm DrDallas·Texas75277GRP-3634SELECT-EPO
ENRENR-1005672026-08-21T22:06:51ZJanet··—Robinson14-05-1949·UHC-84144-35•••-••-9750510.884.6379N/A4133 SPRING STREETTampaFlorida33628·GRP-7572CHOICE-PLUS-PPO··
ENRENR-1168162026-07-30T20:37:08ZKeith—Burns1988-09-16UHC-28763-39··•••-••-983813388309775KEITH.BURNS1@HOTMAIL.COM9209 Lake View RoadPhoenix··Arizona85010GRP-3119CORE-HMO
ENRENR-1030332026-07-20T08:09:48Z·Helen—Vargas2001-07-13UHC-89939-84•••-••-4928222-703-5465··helen.vargas@outlook.com9609 Hillcrest RoadSacramentoCA95860GRP-8720MEDICARE-ADV-A
ENRENR-1228892026-06-14T23:49:47ZMedina, Joyce——09/18/43··UHC-17090-46•••-••-5710+1 767 683 3062JOYCE.MEDINA28@PROTON.ME1257 Central AveSAN DIEGOca92137GRP-5286·CORE-HMO
ENRENR-1020362026-06-22T22:16:48ZJohn—Graham1982-06-14UHC-03219-23•••-••-22383267854971john.graham79@gmail.com719 Central AveTampaFL33657··GRP-2838CHOICE-PLUS-PPO
ENRENR-140172 2026-04-01T16:28:12ZCARLLOS··V—1951-40-14UHC-94418-35•••-••-5825(571) 246-1345carlos.armstrong70@hotmail.com5865 Mountain View DrEDEN PRAIRIEMN55376GRP-5475SELECT-EPO
ENRENR-1273532026-02-05T04:01:51ZJordanFRose1980-10-09UHC-57654-16•••-••-20068165713463jordan.rose@hotmail.com4464 Lincoln WayGilbertArizona85241GRP-1230SELECT-EPO
ENRENR-1255732026-07-07T17:18:36ZJohnnySWarren19440513UHC-88283-73•••-••-2040368.315.4755—3903 SAGE COURTTampaFL—GRP-6946OPTIONS-PPO
ENRENR-1208292026-02-01T17:57:55ZARJUNX.··ROBINSON2004-09-19uhc-13026-76•••-••-1356209.542.4717—7011 Forest Avenue #397TucsonAZ··85718GRP-3922OPTIONS-PPO
ENRENR-1317062026-06-10T07:49:18ZJamesWFowler1961-09-11UHC-97018-67•••-••-7714(623) 325-7956—2069 PALM DRDenverCO80294-1774GRP-2128NAVIGATE-HMO
ENRENR-1059332026-07-12T00:18:00ZJDYI.COOK20020411UHC-73916-71•••-••-7698860-278-0291····2126 Union StHoustonTX77080GRP-3054NAVIGATE-HMO
ENRENR-127566 2026-04-17T13:16:30ZRacel····Cox1944-11-10UHC-51360-95•••-••-5197(537) 215-5980RACHEL.COX13@YAHOO.COM9799 Harbor BlvdSeattleWA98113··GRP-2519NAVIGATE-HMO
ENRENR-1412222026-01-20T12:29:18ZJacqueline—Simmons1940-12-23UHC-56685-38•••-••-8870(502) 207-3797null8184 Spring StGlendaleAZ85339GRP-2595NAVIGATE-HMO
ENRENR-1275492026-05-26T17:25:29ZSTEPHANIE—HARPER1964-06-15UHC-74220-77•••-••-6857443-403-3199STEPHANIE.HARPER@PROTON.ME2829 Cedar LnOrlandoFlorida32850-7659GRP-1110CHOICE-PLUS-PPO
ENR ENR-1339772026-06-27T00:30:02ZBryanIScott··19510517··UHC4256719•••-••-010216626974982BRYAN.SCOTT@PROTON.ME··8868 Hillcrest RoadAustinTX78736··GRP-2470MEDICARE-ADV-A
ENRENR-116517 2026-09-20T12:45:17ZAlexis—Bradley1945-04-08UHC-60210-22•••-••-9570691-558-5185··alexis.bradley@hotmail.com7086 SPRING STREETJacksonvilleFL32281··GRP-8448SELECT-EPO
ENRENR-1393452026-02-13T21:27:53ZTIMOTHY—GILBERT1986-03-10UHC-29472-90•••-••-5709(369) 501-2841timothy.gilbert@hotmail.com7975 Camelback RdNashville··TN37228··GRP-1079CORE-HMO
ENRENR-1322742026-07-22T09:36:52ZDiane—Morales05/02/58UHC-58169-52null(327) 632-0176DIANE.MORALES@PROTON.ME6994 Jefferson AvenueSEATTLEWA98122GRP-6548OPTIONS-PPO
43,101 rows, page 145 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.469Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty