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-1056602026-06-12T04:02:28ZIsabella—Stewart·1957-11-11·UHC-40724-39•••-••-94777969917918isabella.stewart@icloud.com1508 Ridge RoadScottsdaleAZ85293-4876GRP-4639CHOICE-PLUS-PPO
ENRENR-1046782026-05-14T08:21:27ZmaryK.rogers1943-04-11UHC-81130-66•••-••-4160(476) 819-4588—3310 Washington StreetScottsdaleAZ85202GRP-0359MEDICARE-ADV-A
ENRENR-1280942026-06-21T19:05:44ZCYNTHIA—ROBERTSON1942-08-08UHC-13289-88•••-••-8648556.487.5639cynthia.robertson40@icloud.com7433 Sunset BoulevardPhoenixAZ85029GRP-7591MEDICARE-ADV-A
ENRENR-1030192026-05-03T06:41:09ZEthanXBlack2006-05-10UHC-93207-47-nullethan.black91@icloud.com4513 Washington StColumbusOH43285GRP-7474··CHOICE-PLUS-PPO
ENRENR-1006352026-09-25T17:53:40ZJoanYBryantDec 1, 1958UHC-19390-36•••-••-70025253887592joan.bryant@gmail.com6477 Spring StMesa··AZ·85287·GRP-6020NAVIGATE-HMO
ENRENR-1171342026-09-04T09:33:20Z·RogerJ··Johnston1999-02-21UHC7776347•••-••-3840+1 845 831 0381NULL6521 Meadow Ln #216TUCSONAZ-GRP-4258SELECT-EPO
ENRENR-1357772026-06-11T11:44:37ZKELLY··FGUZZMAN1953-06-04UHC-32090-31•••-••-8574(483) 370-4606kelly.guzman31@aol.com337 Church Street #300FresnoCA93721··GRP-3742OPTIONS-PPO
ENRENR-1049782026-06-26T04:31:20ZMegan—Fields1972-03-26uhc-47863-82•••-••-2896(439) 645-5390····3135 Mesa DriveSan AntonioTX-GRP-6453NAVIGATE-HMO
ENRENR-1267022026-04-06T11:52:28ZSophiaE.Kennedy12/02/1978UHC-74147-24N/A(955) 609-3104sophia.kennedy47@icloud.com2158 Main Street·TucsonAZ·85742GRP-7698·CHOICE-PLUS-PPO
ENRENR-1005742026-01-31T15:51:29Z VirginiaZ·Ferguson03-05-1967UHC3461751•••-••-9404531.866.3438··null8481 Desert Sky BlvdJacksonvilleFL32217GRP-0378SELECT-EPO
ENRENR-1187902026-03-25T06:55:42ZEvelynSHoward1942-09-07UHC-72686-13—8574039044—8523 Hillcrest RdLas VegasNV89123GRP-8733CORE-HMO
ENRENR-1267862026-09-02T06:42:22ZLORIVNICHOLS1941-10-03UHC-19429-29•••-••-95569289674486null8962 Union StGilbertAZ85264GRP-5429SELECT-EPO
ENRENR-1102192026-03-17T07:37:19Zjason—grant19460106UHC-51451-91•••-••-3183589-598-1545jason.grant@gmail.com7783 INDIAN SCHOOL ROAD #964DENVERColorado80293GRP-9830MEDICARE-ADV-B
ENRENR-1254362026-04-19T20:56:58ZGaryCPoowell02-02-1946UHC-27498-35—249-731-8290null7930 Indian School RdPlanoTX75079GRP-9572MEDICARE-ADV-B
ENR ENR-1221022026-05-24T17:44:15ZDiegoAMyers2004-06-25UHC5510695•••-••-8656—diego.myers2@hotmail.com1697 HILLCREST ROADTampa··FL·33678GRP-7284choice-plus-ppo
ENRENR-1048892026-07-06T08:55:44Zkim·C.lee04/24/1977UHC-43670-05•••-••-79617344561855kimberly.lee@yahoo.com1722 Meadow LnSeattleWA98101GRP-1250CHOICE-PLUS-PPO
ENRENR-1421912026-06-07T18:39:11Zgeorge··Awright1990-07-07UHC-50766-06•••-••-6102(334) 202-9082UNKNOWN7932 CAMELBACK RD #949MiamiFlorida33178-3141GRP-8440MEDICARE-ADV-A
ENR ENR-1326402026-10-12T17:42:21ZHenry, MedisonD—1991-08-08·UHC-35104-91•••-••-8335(244) 384-1196null7269 Highland AveLos AngelesCA90083GRP-3238MEDICARE-ADV-B
ENRENR-1062752026-07-21T22:57:31ZJULIE····PAYNE19850308UHC-29124-63•••-••-2596973-374-8706JULIE.PAYNE93@AOL.COM·6265 Market StreetLas VegasNV89115GRP-9007CHOICE-PLUS-PPO
ENRENR-1271232026-02-17T06:15:34Z·NathanLTran2003-06-21UHC-26240-33•••-••-4745null—4071 River RdLos AngelesCA90061GRP-2535MEDICARE-ADV-B··
ENRENR-1007092026-04-12T04:11:29ZJOSEPHP.JORDAN27-10-1959UHC-90858-11—N/AJOSEPH.JORDAN@GMAIL.COM8423 Palm DrLas VegasNV89143GRP-4478MEDICARE-ADV-A
ENRENR-1202002026-02-04T02:01:00ZMICHELLE—RILEY·1941-10-16UHC-24426-58•••-••-227815607074668MICHELLE.RILEY55@PROTON.ME3847 Highland AvenuePlano··TX75009GRP-0437MEDICARE-ADV-B
ENRENR-1401452026-02-16T05:22:35ZThoams—Bailey1999-01-27uhc-40552-57•••-••-49959098875112-5198 JEFFERSON AVENUE Apt 18Dallastx75255GRP-2443MEDICARE-ADV-A
ENRENR-1421942026-10-06T11:16:06ZJeffreyBHill4/4/1960UHC-46715-47•••-••-7343(580) 904-4336jeffrey.hill@icloud.com·6875 Park PlaceTucsonAZ85772GRP-5469CHOICE-PLUS-PPO
ENRENR-1145942026-02-08T03:32:33ZChhen, CarlS—1997-08-15UHC-16221-28—null—8246 Canyon RoadCHARLOTTENorth Carolina··28269GRP-1681CORE-HMO
ENRENR-1281922026-02-13T13:46:07ZMARIUMONTGOMERY1949-04-12UHC-23118-53•••-••-5547·632.374.6359maria.montgomery11@outlook.com9106 MAIN STREETAustinTX78788GRP-3394MEDICARE-ADV-B
ENRENR-1196712026-02-20T16:59:35ZJOSEP.PADILLA1955-01-14uhc-81594-89•••-••-55915785331507jose.padilla55@proton.me2576 ELM STREETSeattleWA98141GRP-9896MEDICARE-ADV-A
ENRENR-1259362026-06-08T06:01:19ZDorothy—Hayes··05/04/1964UHC-00792-65··N/A613-932-5782N/A7367 HILLCREST RDGlendaleAZ85377GRP-3731CHOICE-PLUS-PPO
ENRENR-1295022026-07-02T00:48:43ZAlice··—Bishop—UHC-10447-33•••-••-5414+1 675 350 9647ALICE.BISHOP@HOTMAIL.COM3124 Main StreetNASHVILLETN37225GRP-0592MEDICARE-ADV-B
ENRENR-1270792026-05-26T13:38:20ZAustinA.MatthewsApr 17, 1998UHC-12915-66•••-••-50847909741513austin.matthews32@icloud.com85 Union StTampaFL33615GRP-7562MEDICARE-ADV-B
ENRENR-1161232026-09-19T17:04:05ZFRANCES—FRANKLIN1938-06-05UHC-89412-68•••-••-5988—FRANCES.FRANKLIN29@YAHOO.COM9513 Sage CourtDallasTX75243GRP-8569SELECT-EPO
ENRENR-1151522026-05-18T21:52:53ZJUAN—WLLIS19890706UHC-40838-85•••-••-0035803.717.7315·juan.willis59@outlook.com5963 MAPLE AVENUEPHOENIXAZ85001·GRP-2864CORE-HMO
ENRENR-1184202026-04-25T02:49:27Z mdaisonPlopez1945-02-18UHC-54424-31•••-••-83782767735983madison.lopez@gmail.com673 Grand AvenueLAS VEGASNV89177GRP-1656MEDICARE-ADV-B
ENRENR-1244142026-09-25T00:22:45ZASHLEYETHOMPSON1999-11-22UHC-62776-77•••-••-6321+1 407 843 5113ashley.thompson@icloud.com8765 Central AveEden PrairieMN55320GRP-2381CORE-HMO
ENRENR-1046632026-10-01T17:02:58ZScott, JeffreyM—1991-03-07UHC-08770-76•••-••-07146013009jeffrey.scott45@aol.com8428 WASHINGTON STFresnoCA93788·GRP-4929NAVIGATE-HMO
ENRENR-1216752026-09-12T08:08:29ZGaryW·Vazquez1/17/1974UHC-43078-98•••-••-12299332571941gary.vazquez56@yahoo.com9390 Bayshore DrAUSTINTXN/AGRP-9294OPTIONS-PPO
ENRENR-1149462026-08-14T08:46:03ZKelley, JeffreyB—1955-02-15·UHC-64044-88•••-••-0439556-557-4146jeffrey.kelley@yahoo.com5232 Canyon RdNashvilleTN37207-0560GRP-6552·NAVIGATE-HMO
ENRENR-1340942026-08-02T04:21:13ZRoy—Ortega1952-09-11UHC-49200-73•••-••-6914827-569-8113ROY.ORTEGA@PROTON.ME5579 Baseline RdPHOENIXAZ85054···GRP-5810MEDICARE-ADV-B
ENR ENR-1092952026-03-27T07:00:48Z·MARGARETBBROWN·6/19/1948UHC-88357-09•••-••-8202371-645-3111UNKNOWN5224 Central AvenueHoustonTXN/AGRP-6215NAVIGATE-HMO··
ENRENR-1387342026-02-05T15:09:19ZJuliaD.Luna02/15/1971UHC-80595-34•••-••-0988403.471.5948julia.luna@icloud.com8584 Main StTampaFLUNKNOWNGRP-9371CHOICE-PLUS-PPO
ENRENR-1422372026-10-16T21:15:08ZVictoria—Morales09/13/1984UHC-54406-64•••-••-11778744576348victoria.morales@icloud.com3969 Church StreetGlendale··AZ85375GRP-5170MEDICARE-ADV-B
ENRENR-1329132026-09-13T06:37:09ZKeithA.Perez1944-10-15·UHC-42466-08•••-••-2626UNKNOWNKEITH.PEREZ2@YAHOO.COM-··UNKNOWN—GRP-7799CHOICE-PLUS-PPO
ENRENR-1112532026-02-24T01:27:02ZLinda··VStevens20061005UHC-86754-83•••-••-9009+1 923 315 4263linda.stevens@aol.com6800 Maple AvenueNashvilleTN37260GRP-2409SELECT-EPO
ENRENR-1168092026-01-15T02:16:59Zamanda—aguilar1999-07-14UHC-57660-55-656-489-0302AMANDA.AGUILAR@AOL.COM4164 Broadway·TampaFL33658··GRP-2095SELECT-EPO
ENRENR-1117442026-05-25T23:58:26ZTYLERY··NGUYNE11/10/1992UHC0800213•••-••-453112512665547tyler.nguyen68@aol.com·857 Cedar LnScottsdaleAZ85266-6843GRP-4689·options-ppo
ENRENR-1179752026-05-30T22:56:55ZDOUGLASXWELCH1980-07-10UHC-34288-43•••-••-5412723-537-5636douglas.welch@yahoo.com3626 Hillcrest RdDALLASTX··—GRP-6552MEDICARE-ADV-A
ENRENR-1261902026-02-10T04:43:01ZMaryX.Williams06/08/60UHC-91552-92•••-••-8278467-968-2584mary.williams10@gmail.com975 Mesa DriveDenverColorado80254GRP-6155SELECT-EPO
ENRENR-1243682026-07-11T06:29:08Zcheryl—park19871012UHC-30174-71•••-••-4964+1 748 406 4542—3087 Park PlaceDallasTexas·75228GRP-9625CHOICE-PLUS-PPO
ENRENR-1366442026-08-05T18:26:33Zbryan—crafword1960-02-13UHC-44902-53•••-••-3369(378) 655-8179—4858 Sage CtMesaAZ85222GRP-5254OPTIONS-PPO
ENRENR-1324382026-08-07T17:59:47Z·elijahEstewart1979-05-06UHC-98332-21•••-••-8946817.982.3271ELIJAH.STEWART1@OUTLOOK.COM··2199 OAK STLAS VEGAS··NV89188GRP-3938MEDICARE-ADV-B
43,101 rows, page 240 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.621Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty