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-1258992026-09-02T15:00:30Z·Scott—Moreno1982-06-28UHC-06606-92•••-••-4951(563) 254-9383scott.moreno@outlook.com6152 BROADWAYSan AntonioTX78212GRP-3662CORE-HMO
ENRENR-1164532026-07-21T12:23:23ZjessicaY··carlson··4/7/1955UHC-75644-24•••-••-873012265861308jessica.carlson89@gmail.com6064 MARKET STREETTampaFL·33675GRP-1087NAVIGATE-HMO
ENRENR-1344872026-04-30T19:16:42Z MARKNDEAN2008-02-14UHC-46621-13•••-••-9353·14139936129mark.dean89@outlook.com·1239 Jefferson AveGilbertAZ85236GRP-8136NAVIGATE-HMO
ENRENR-1259242026-08-15T01:20:40ZGeorgeEPadilla10/19/1946··UHC-72130-12•••-••-8169961.746.3014george.padilla@icloud.com6800 Central AvenueTampaFLUNKNOWNGRP-8456MEDICARE-ADV-B
ENRENR-1191802026-09-15T17:21:51ZTONY W··MORENO1984-10-27UHC-98306-16•••-••-33168075901776anthony.moreno3@proton.me8852 MOUNTAIN VIEW DRIVEGlendaleAZ85305··GRP-8411core-hmo
ENRENR-1133322026-07-14T08:36:41ZCHERYLEVAZQUEZ1985-11-15UHC-23636-43•••-••-9903(672) 413-0143-8857 Mountain View DrGilbertaz85239GRP-1459NAVIGATE-HMO
ENRENR-1130452026-07-05T02:27:52ZEmilyECollins··1974-09-15UHC-47167-69—NULLnull4983 Church StreetDallas··TX75292GRP-5985MEDICARE-ADV-A
ENRENR-1299862026-05-20T07:22:24ZKellyELawrence23-05-1982UHC-94852-65•••-••-7325337-973-1518—NULL·N/A—N/AGRP-0992CORE-HMO
ENRENR-1103632026-07-20T12:40:01ZchristianIgonzales··1969-01-63UHC-04668-80•••-••-30555396447971—2643 Maple AvenueORLANDO··Florida32879GRP-2085SELECT-EPO
ENRENR-110586 2026-10-15T20:24:15ZAngela—Salazar1979-06-05UHC-63436-64—699-641-2968ANGELA.SALAZAR@GMAIL.COM5809 MOUNTAIN VIEW DRIVEMinneapolisMN55406GRP-7348SELECT-EPO
ENRENR-127217 2026-05-19T12:20:28Zlauuren—gutierrez1942-10-10UHC7204997•••-••-2031+1 440 908 3769lauren.gutierrez@yahoo.com5474 Indian School RoadChandlerAZ85220-2018··GRP-2922MEDICARE-ADV-A
ENRENR-1043232026-04-22T13:13:04ZSean—Fowler1974-02-26UHC-27565-34•••-••-2216(454) 769-1828NULL706 LINCOLN WAYEden PrairieMinnesota55353GRP-5228···CHOICE-PLUS-PPO
ENRENR-1165442026-07-30T15:46:39Zdanil—flores1980-08-09··uhc-20989-27•••-••-9548N/Adaniel.flores@gmail.com1785 Apache BlvdFresnoCA93727GRP-1432MEDICARE-ADV-A
ENRENR-1318502026-07-01T06:04:40ZHELENSFERNANDEZ1942-06-16UHC-17523-60·········helen.fernandez57@gmail.com5023 Grand AveATLANTAGA—GRP-8865··CORE-HMO
ENRENR-1179722026-06-28T20:10:28ZChristian—Burton3/16/1976UHC-48813-22•••-••-3346(227) 217-6943christian.burton@hotmail.com3628 Lake View RdMiamiFL33136GRP-7965SELECT-EPO
ENRENR-108364 2026-09-17T20:26:22ZvirginiaGgrahamDec 5, 1943UHC-43956-72•••-••-5982·274-620-9937VIRGINIA.GRAHAM15@AOL.COM4639 Palm DrSan DiegoCA92193GRP-0145MEDICARE-ADV-A
ENRENR-1145002026-09-19T01:06:06ZHudson, Mei——1961-05-03UHC-21510-91•••-••-6456254-680-9363—6252 Ocean AveTampaFlorida33610GRP-7868MEDICARE-ADV-A
ENRENR-1335282026-04-21T01:58:58Zterry—·soto06/24/03UHC-32340-64—408-221-3934N/A5079 Valley View DriveTucson·AZ85758GRP-5903··CORE-HMO
ENRENR-1217112026-02-10T23:20:13Z ANGELAGFRANKLIN1977-10-14UHC-52034-94•••-••-47534588998048angela.franklin15@outlook.com2488 MOUNTAIN VIEW DREden PrairieMN55362GRP-7552OPTIONS-PPO
ENRENR-1302132026-10-05T11:30:20Ztimothy—fields1970-08-17UHC-81911-86•••-••-3509476-336-9254·N/A5534 Sunset BlvdHoustonTexas77042-2325GRP-0621MEDICARE-ADV-B
ENRENR-1228622026-01-17T08:23:06Z SeanFPrice1952-05-18N/A•••-••-9972·643.359.0619SEAN.PRICE10@OUTLOOK.COM469 APACHE BLVD··ChandlerArizona85296-5570GRP-0978CHOICE-PLUS-PPO
ENRENR-1098582026-05-21T07:18:26Z MELISSA—WALSH13-08-1987UHC-81070-15•••-••-3802+1 658 592 8689MELISSA.WALSH93@OUTLOOK.COM9218 Bayshore DrivePhoenixAZ85051GRP-6988CHOICE-PLUS-PPO
ENRENR-121434 2026-06-29T19:28:02ZSantiago—Jeensen1992-05-26UHC-40660-07•••-••-6249UNKNOWNnull8713 Meadow LnSeattleWA98137-0023GRP-6666CORE-HMO
ENRENR-1057802026-04-11T00:22:48ZElijah—Hall9/24/1996UHC-02806-77•••-••-1417(492) 572-6487—5172 WILLOW CTCOLUMBUSOhio43284GRP-9289CORE-HMO
ENRENR-1196862026-08-11T12:26:52ZBarbFTorres·1974-12-21null•••-••-1989-———UNKNOWN—GRP-6524CORE-HMO
ENR ENR-114713 2026-04-11T15:02:55ZDOROTHY·T.RICHARDSON1948-07-07·UHC5454612•••-••-3796(928) 633-7116dorothy.richardson@icloud.com9509 INDIAN SCHOOL ROADCharlotteNC28278GRP-6886·CHOICE-PLUS-PPO
ENRENR-1303262026-02-02T01:47:45ZWALTERYMITCHELL1982-10-27UHC-96664-98•••-••-0990·279.324.7145walter.mitchell@hotmail.com9681 Elm StFresnoCA93786GRP-4700OPTIONS-PPO
ENRENR-1330482026-02-13T21:31:19ZJoshua—Ellis1998-09-02UHC-44602-44•••-••-1479492-379-2846joshua.ellis@hotmail.com·1169 Grand AvenueLos AngelesCA90070GRP-1058MEDICARE-ADV-A
ENRENR-1347502026-04-15T14:00:44ZSamanthaXReynolds1955-08-26UHC-48745-56•••-••-9425262-701-5654—9042 Canyon RoadSCOTTSDALEAZ—GRP-9270CHOICE-PLUS-PPO
ENRENR-1014122026-04-25T22:23:16Zanthony·Z.rose1996-09-22UHC3231801•••-••-4485881-714-2549anthony.rose29@proton.me7414 Desert Sky BoulevardScottsdaleAZ85229GRP-4369choice-plus-ppo
ENRENR-1096482026-03-25T13:01:45ZWAYE—JENSEN0901-79-46··UHC-95377-97•••-••-260615025069613··WAYNE.JENSEN@OUTLOOK.COM7350 Bayshore DriveTAMPAFL33600GRP-8804OPTIONS-PPO
ENRENR-1407702026-06-25T10:47:28ZDorisT.Mendez1997-11-25UHC8912989•••-••-5726(370) 981-7702-4014 Harbor BlvdMiami·FL33178GRP-7243NAVIGATE-HMO
ENRENR-1072062026-02-12T03:04:13ZamberZbailey11/06/99UHC-62902-39•••-••-8229(684) 537-6629amber.bailey@yahoo.com630 UNION ST Apt 7JacksonvilleFL32208-3274GRP-1615CHOICE-PLUS-PPO
ENRENR-136282 2026-02-14T14:36:18Z·LISASRYAN1967-02-22·UHC-00454-84•••-••-557918385383270LISA.RYAN46@AOL.COM7544 Jefferson AvenueTempeAZ85279GRP-9416MEDICARE-ADV-A
ENRENR-1208512026-10-01T16:31:02ZNATALIE··—JACOBS02/13/05UHC-20927-65•••-••-1869-natalie.jacobs6@yahoo.com··3207 Market StGLENDALEAZ85315GRP-2262MEDICARE-ADV-B
ENRENR-1193222026-06-11T14:23:22ZEdward—Chapman1987-07-17UHC-78624-36•••-••-61035007530056edward.chapman32@outlook.com5480 Mountain View Drive··TempeAZ85223GRP-2874OPTIONS-PPO
ENRENR-1319142026-10-10T11:18:03ZisabellaVadams0840-19-84N/A·-567.871.4566isabella.adams@gmail.com··5521 Church StreetJacksonvilleFL··32276GRP-1144CHOICE-PLUS-PPO
ENRENR-1340912026-01-07T10:05:41ZBEVERLY—KNIGHT20051011UHC-98679-81—3316395406beverly.knight@yahoo.com2069 CAMELBACK RDOrlandoFL32827···GRP-7702OPTIONS-PPO
ENR ENR-1320382026-08-21T01:02:58ZJOE··—OWENS··26-05-1949UHC-88512-73•••-••-23338519951077joseph.owens27@proton.me5646 Sage CtMiamiFL33132GRP-8369OPTIONS-PPO
ENRENR-1236832026-01-30T11:00:16ZLinda—Lucas1951-03-06UHC-20791-83NULL400-271-1136null592 Jefferson Avenue Apt 17Tucson··AZ85761·GRP-5847NAVIGATE-HMO
ENRENR-1257242026-08-10T03:21:52Z TERRYYBANKS1947-12-03UHC-30407-95•••-••-0231813.939.7603terry.banks@aol.com1760 HIGHLAND AVENUEOrlandoFL··32830GRP-9680SELECT-EPO
ENRENR-1308902026-03-12T20:20:04Z BOBBY—ESPINOZA05/21/58UHC-87850-13····744.704.8211bobby.espinoza23@gmail.com852 CANYON RD Apt 4PHOENIXArizona·85046GRP-5402CORE-HMO
ENRENR-1151932026-06-27T12:52:43Z MARIA—PATTERSON1991-03-23UHC-79144-41•••-••-9229NULLmaria.patterson@aol.com··8319 Bayshore DriveLas VegasNVNULLGRP-3646CHOICE-PLUS-PPO
ENRENR-1295482026-01-03T13:36:03ZdiegoT.richardsFeb 6, 1963UHC-38262-45•••-••-8405226-357-0196····2956 Mountain View DrColumbusOH43265-8911GRP-3548OPTIONS-PPO
ENRENR-1140722026-03-07T08:05:06ZRalph—Burns1962-07-13UHC-48557-35•••-••-71452276157714ralph.burns27@proton.me1506 Maple AveJacksonvilleFL32254·GRP-1368SELECT-EPO
ENRENR-1287042026-06-22T17:54:33ZjoanLsanchez1975-05-08UHC-91458-47null786-591-9001JOAN.SANCHEZ97@PROTON.ME·179 Highland AvenueLos AngelesCalifornia90083-9294GRP-5696CORE-HMO··
ENRENR-1259472026-06-27T22:29:23ZJESZEVPENA1982-07-12··UHC-77062-43•••-••-2620(701) 975-0620jesse.pena@yahoo.com9522 OAK STREETLas VegasNV89171GRP-5220SELECT-EPO
ENRENR-1041292026-09-23T05:05:35ZJames, Natalie··L.··—1972-03-18UHC-44696-09-9467689NATALIE.JAMES12@GMAIL.COM5951 Desert Sky Blvd Apt 18SCOTTSDALEArizona85237GRP-2994OPTIONS-PPO
ENRENR-1071792026-09-01T22:25:49Z KEITHUSANCHEZ1959-08-17UHC-11613-47—6013369400NULL4800 Ocean Ave Apt 14HoustonTX77077GRP-0880··OPTIONS-PPO
ENRENR-1343042026-02-25T23:13:43ZELIZABETHXADAMSMay 23, 2008uhc-26479-98•••-••-976015267908827elizabeth.adams@gmail.com6965 Pine DriveOrlando·FL32814GRP-4418NAVIGATE-HMO
43,101 rows, page 248 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:40.633Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty