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-1343282026-08-12T01:09:44ZDianaVHarvey12/25/64UHC-03967-35•••-••-76107127268372diana.harvey@hotmail.com7095 BAYSHORE DR·PhoenixAZ85041GRP-0474··MEDICARE-ADV-A
ENRENR-1076792026-09-10T20:55:34ZFatimaBAndrews·1965-10-25UHC-06226-03•••-••-9077nullFATIMA.ANDREWS73@OUTLOOK.COM7295 Lincoln WayTUCSONAZ85733GRP-9691CHOICE-PLUS-PPO
ENRENR-1275162026-07-07T13:07:38Z PamelaUArnold19731119UHC-18704-10null(239) 935-5420-1082 Maple AvenueSan DiegoCA92184GRP-3853MEDICARE-ADV-A
ENRENR-1080942026-09-25T17:47:50ZNOAHT.BRYANT1967-08-07·UHC-17519-92UNKNOWN366.931.8406··noah.bryant@outlook.com5278 MOUNTAIN VIEW DRIVE Apt 18ColumbusOH43256GRP-3113SELECT-EPO
ENRENR-1290442026-08-29T19:23:30Z MATTHEW—ANDERSON1991-06-22UHC-25095-70•••-••-4010+1 955 368 1219MATTHEW.ANDERSON45@AOL.COM1620 BroadwayTAMPAFL33697GRP-3901·MEDICARE-ADV-B
ENR ENR-1113142026-05-15T19:38:14ZHolmes, Joshua——1977-04-20UHC-28099-06•••-••-4569·719-708-6582joshua.holmes@outlook.com·2964 Bayshore DriveMesaArizona85270-8441GRP-9480NAVIGATE-HMO
ENRENR-1307922026-02-07T20:59:35Z·AndrewWRogersJun 25, 1961UHC-42345-38•••-••-1123798-885-7752ANDREW.ROGERS3@AOL.COM2616 Bayshore DrAustinTX78789···GRP-4299CHOICE-PLUS-PPO
ENRENR-1276552026-02-03T17:04:05ZNANCYJ.PENA06/05/43UHC-30500-96•••-••-2731651-852-2736-4385 Grand AveSan DiegoCA92108GRP-3829SELECT-EPO··
ENRENR-1047142026-10-11T14:34:30ZSophia··—Cooper·1987-04-23UHC-07790-61•••-••-9995+1 831 306 1045sophia.cooper@yahoo.com5173 Valley View DrSeattleWA98183·GRP-9326CORE-HMO
ENRENR-1149552026-07-14T10:10:31Zhenry—murray1946-02-20UHC-84477-27NULL·354-987-4866HENRY.MURRAY41@AOL.COM3057 Forest AveColumbusOH43262GRP-7700··options-ppo
ENRENR-1351112026-10-11T17:26:13ZKARNYHERRERA06/10/97UHC-95414-09··•••-••-3462214.789.7640—6511 Church St··PlanoTX75009GRP-0554MEDICARE-ADV-A
ENRENR-1139632026-03-28T05:56:15Z ralphS.fields1980-02-01UHC-27481-13•••-••-9729(533) 871-5128NULL7885 Washington StColumbusOH43225·GRP-8789MEDICARE-ADV-B
ENRENR-1240192026-06-15T18:21:31ZVincent—Gutierrez·19410303UHC-14218-79•••-••-9469352-898-5204VINCENT.GUTIERREZ@ICLOUD.COM6401 Desert Sky Blvd··ORLANDO·FL32812GRP-0784MEDICARE-ADV-B
ENRENR-1427932026-04-28T18:43:32ZHarvey, Ethan——1960-10-24UHC-44646-94····(717) 821-8219ethan.harvey66@yahoo.com3014 Forest AvenueDENVERCO80284GRP-2366OPTIONS-PPO
ENRENR-1065252026-04-22T18:46:47ZNicoleXRice1995-03-17UHC-22461-47•••-••-8770278-963-1747nicole.rice7@outlook.com8696 CANYON RD Apt 39FresnoCalifornia93785GRP-0719MEDICARE-ADV-B
ENRENR-1198422026-09-25T08:11:55ZElizabethNRay8/26/1992UHC-71909-01•••-••-1901540-358-7821elizabeth.ray25@icloud.com3693 MAIN STScottsdaleAZ85288GRP-8501··CORE-HMO
ENRENR-1323512026-06-19T16:36:11Z·kathleenBwagner1938-03-25UHC-70036-48•••-••-9288500-728-8582kathleen.wagner@proton.me5539 Lincoln Way·EDEN PRAIRIEMN55351GRP-6914MEDICARE-ADV-A
ENRENR-1058362026-09-24T20:03:21ZJanet—Willis·1697-10-05UHC-24401-43•••-••-8845N/Ajanet.willis@proton.me1913 Mountain View DriveORLANDOFL32874GRP-9835MEDICARE-ADV-A
ENRENR-1032412026-07-03T18:49:57ZBRUCE—MYERS07/10/1997UHC-71481-08•••-••-4356+1 623 978 7690BRUCE.MYERS@YAHOO.COM162 Ridge RoadSan AntonioTXnullGRP-7981MEDICARE-ADV-B
ENRENR-1087232026-06-17T21:34:08ZSofia—Greene20-05-1976UHC-16642-19N/Anull—6125 Apache Blvd··DenverColorado—GRP-3608SELECT-EPO
ENRENR-1133872026-07-24T03:31:40Zdouglas—cole1958-09-18UHC-11333-58•••-••-58205235426565DOUGLAS.COLE@AOL.COM9589 Maple AvenueFresnoCalifornia93716GRP-4712SELECT-EPO
ENRENR-1084342026-07-12T19:21:00ZMateo—·Scott09/20/91UHC1938480•••-••-8916+1 405 433 8735mateo.scott@outlook.com4314 Elm StGlendaleAZ85313-6883··GRP-7476NAVIGATE-HMO
ENRENR-1079022026-08-01T11:55:35ZCynthia—Watson19780221UHC-09063-66•••-••-5155782-278-1156CYNTHIA.WATSON66@PROTON.ME3505 Grand Avenue Apt 14Orlando··FL32888GRP-6662NAVIGATE-HMO
ENRENR-1430612026-08-11T12:47:32ZAlbert—Perry2007-01-07UHC-04979-01•••-••-9991·406.607.1744ALBERT.PERRY@GMAIL.COM80 Jefferson AvenueChandlerAZ85236GRP-7730MEDICARE-ADV-B
ENRENR-1317542026-08-17T05:05:19ZDanielG.Coleman1490-03-09UHC-12741-89•••-••-9122nulldaniel.coleman@gmail.com2517 Bayshore DrEden PrairieMN55320GRP-4237·CORE-HMO
ENRENR-1229952026-01-15T13:04:21ZDanielle—Mejia··12/12/1972UHC6492450•••-••-1657(393) 423-2667danielle.mejia@icloud.com5814 Indian School RoadCHARLOTTENC·28287GRP-2568MEDICARE-ADV-A
ENRENR-1311022026-04-19T09:11:35ZBrandon—Andrews24-12-1983UHC-27555-41NULL5424054905BRANDON.ANDREWS@GMAIL.COM7064 BroadwayTempeaz85266GRP-3034CORE-HMO
ENRENR-1103452026-05-30T20:42:12Z·LARRY—WALKER1993-05-24UHC-68003-04•••-••-1938—larry.walker38@icloud.com7933 INDIAN SCHOOL RDScottsdale··az85201GRP-3308OPTIONS-PPO
ENRENR-1231372026-08-03T18:38:57ZMeiL.James-uhc-58231-15•••-••-2025+1 276 200 7389··—911 Oak St Apt 1ORLANDOFL32883GRP-5171SELECT-EPO
ENRENR-137097 2026-04-28T21:50:42Z·Rebecca—Luna1949-06-01UHC-65111-39null680.406.6795—1388 CHURCH STREETJACKSONVILLEFL··32290GRP-5067CORE-HMO
ENRENR-101034 2026-03-19T02:36:20ZJUDITHABRADLEYSep 25, 1951UHC-02771-26•••-••-1342(418) 422-2161—6045 Lake View RoadLas VegasNevada89145GRP-1543OPTIONS-PPO
ENRENR-1156842026-05-06T14:01:34ZEthanB.ArmstrongDec 8, 1970uhc-37037-49—·562-496-5576—8528 Cedar LnSeattleWA98182GRP-3488NAVIGATE-HMO
ENRENR-1017922026-07-10T16:53:44ZAmberU.Yang·1959-09-10UHC-12963-20•••-••-13263556570858amber.yang@yahoo.com1998 Jefferson AvenueGlendaleAZ85384··GRP-9169MEDICARE-ADV-A
ENRENR-1075662026-06-05T17:42:51ZMelissaDCampbell1984-05-03UHC-88606-56•••-••-230714079319079··-9465 Sage CtTucsonAZ85739GRP-0967··SELECT-EPO
ENR ENR-100607 2026-08-30T16:25:07Zlinda—wong1947-02-11UHC-59924-42•••-••-3455816-505-9028·LINDA.WONG72@OUTLOOK.COM6511 CANYON RDDenverCO80243GRP-9386OPTIONS-PPO
ENRENR-1353922026-07-02T03:14:58Z·ANN—MARQUEZ2002-12-27UHC-61611-49··•••-••-9086(260) 854-8739ann.marquez92@yahoo.com9841 Central AveGilbertAZ85252GRP-2069NAVIGATE-HMO
ENRENR-1032972026-07-27T03:48:30ZJohn—Berry1590-04-11UHC-41668-73null(395) 481-2675john.berry@aol.com3364 FOREST AVEGlendaleAZ85322GRP-6740OPTIONS-PPO
ENRENR-1025672026-09-17T04:54:48ZANNAUSHAW··1956-08-26UHC-44369-31•••-••-6801+1 507 441 5820anna.shaw21@hotmail.com8585 Desert Sky Boulevard #393··San AntonioTX78276GRP-1713OPTIONS-PPO
ENRENR-1331052026-02-22T16:11:40ZKayla—Martin1981-02-09UHC-86306-82•••-••-0937730-388-2240N/A2860 Spring StNashvilleTN37218GRP-9910NAVIGATE-HMO
ENRENR-1102892026-07-17T19:48:26ZAARRON—RICHARDSON2005-03-08UHC1720117null·6953255626aaron.richardson@icloud.com7110 Indian School RdHOUSTONTX77077-9550GRP-9557CHOICE-PLUS-PPO
ENRENR-1063642026-09-10T02:26:09ZJANETOBISHOP1999-07-02UHC-26356-02•••-••-1000(706) 425-0397janet.bishop1@aol.com2909 Highland AvenueATLANTAGA30359GRP-6279MEDICARE-ADV-A
ENRENR-1336232026-03-04T18:14:07ZEmilyS.Knight1304-91-85UHC-61707-51•••-••-43304877676188EMILY.KNIGHT@ICLOUD.COM7278 Harbor BlvdJACKSONVILLEfl32251GRP-8661CHOICE-PLUS-PPO
ENRENR-1039862026-01-27T19:59:34ZLawrence—Lawson··1947-11-27UHC-89452-36•••-••-657615579213346····3465 Park PlPhoenixAZ85011-8384GRP-9926OPTIONS-PPO
ENRENR-1126822026-05-03T06:19:04ZmadisonZbutler·2008-01-28UHC-99173-26—665-730-7530madison.butler75@icloud.com9668 Bayshore DriveSan Antonio·TX78240GRP-6453OPTIONS-PPO
ENRENR-1280042026-08-15T12:44:14Z·VIRGINIA—CLARK1956-11-05UHC-07844-60•••-••-6493(383) 229-7394VIRGINIA.CLARK67@GMAIL.COM8280 Forest AvePhoenix··Arizona85031GRP-1620CHOICE-PLUS-PPO
ENRENR-1262802026-08-17T01:22:03ZdorisX.contreras01/10/1957UHC-49095-61•••-••-3226(287) 421-6237doris.contreras@proton.me236 Willow CtMinneapolisMN55405GRP-0831·SELECT-EPO
ENRENR-1360732026-06-25T15:33:42ZArthur—Ray2005-05-23UHC-79109-70•••-••-51413693613269arthur.ray22@aol.com1716 Canyon RoadTampaFL33617··GRP-7642CORE-HMO
ENRENR-1209952026-03-02T18:33:44ZNICHOLAS—GRANT1998-11-06UHC-26220-94•••-••-1090786-726-7946nicholas.grant@outlook.com7769 Lake View RoadFresnoCA93715GRP-1063options-ppo
ENRENR-1231742026-05-08T13:36:56ZGregoryHHayes1950-09-22UHC5391573—497-248-5996GREGORY.HAYES89@YAHOO.COM8021 Lincoln WaySan AntonioTX78262·GRP-7299OPTIONS-PPO
ENRENR-1336222026-06-20T07:22:51ZKnight, EmilyS—·1985-04-13UHC-61707-51•••-••-4330487-767-6188emily.knight@icloud.com7278 Harbor BoulevardJACKSONVILLEfl32251GRP-8661CHOICE-PLUS-PPO
43,101 rows, page 117 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:37.757Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty