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-1255012026-04-05T13:09:11ZMarilyn—Ray1980-11-13·UHC-54757-66•••-••-132819055771398UNKNOWN6694 SAGE CTCHARLOTTENC28294-0198GRP-5388MEDICARE-ADV-B
ENRENR-1178512026-09-15T20:13:46ZAngela—Mills1960-06-23UHC-64930-03•••-••-59173153350659-·293 Indian School RoadAtlantaGA30392GRP-2683MEDICARE-ADV-B
ENRENR-1349282026-01-21T22:08:38ZAbigail—Kelly4/18/1976UHC-81706-77•••-••-2008788.366.0688·abigail.kelly9@proton.me9621 Park PlMESAAZ85242GRP-6164CORE-HMO
ENRENR-1288272026-02-05T15:53:27ZSanchez, Edward—····Sep 13, 1951UHC-11141-16•••-••-5900—EDWARD.SANCHEZ@YAHOO.COM9732 Market StNashvilleTN37268GRP-1466CORE-HMO
ENRENR-1063682026-04-27T04:03:31ZDonna—Crawford1976-04-07UHC-15832-60—+1 595 231 7804donna.crawford@gmail.com1081 Canyon RoadTampaFL33679GRP-8891SELECT-EPO
ENRENR-1411482026-06-02T06:39:40ZRACHELONICHOLS1970-07-06UHC-39062-02•••-••-8690+1 619 439 6351—4830 Sunset BoulevardTucsonAZ85725GRP-6514CORE-HMO
ENR ENR-1242102026-04-13T20:54:48ZMaria—Reid·6/2/1943UHC-95329-63•••-••-9070(925) 652-9682maria.reid47@icloud.com9497 Lincoln Way··MesaAZ85245GRP-1247CHOICE-PLUS-PPO
ENRENR-1346542026-03-19T03:03:12ZWILLIAMT.CRUZ02-06-1968UHC-40984-50•••-••-2342UNKNOWNwilliam.cruz47@outlook.com8463 Central AveSan DiegoCA92135GRP-1971MEDICARE-ADV-B
ENR ENR-1173412026-01-05T14:08:39ZMatthewSMedina09/14/61UHC-54702-19•••-••-3126·(644) 275-2167NULL9132 Spring StreetHOUSTONTX77061·GRP-7252OPTIONS-PPO
ENRENR-1398152026-03-03T13:34:50ZBillyD.Owens·19611109UHC-98562-61··•••-••-39683963899560N/A235 Ridge RdEden PrairieMN55369GRP-3450MEDICARE-ADV-B
ENRENR-1288062026-09-16T05:39:14ZNicoleFPayne1948-09-08UHC5327873•••-••-6910921-911-0370NICOLE.PAYNE15@PROTON.ME6830 CHURCH STREETFRESNOCA·93739GRP-6801MEDICARE-ADV-B
ENRENR-1053722026-01-02T22:55:14ZZACHARYR.CARPENTER1946-09-12UHC-74272-06•••-••-072613255728760zachary.carpenter14@hotmail.com4234 CENTRAL AVEPhoenixAZ85025-8228GRP-7191OPTIONS-PPO
ENRENR-1405122026-08-16T15:00:32ZPETEREORTEGA·1964-09-18UHC-22118-94•••-••-2998719.851.4707PETER.ORTEGA43@OUTLOOK.COM8810 MEADOW LNEden PrairieMN55380GRP-3102SELECT-EPO
ENRENR-1382792026-10-12T23:57:19ZMateoJ.ReedJul 21, 1987UHC-56867-30•••-••-8097356-688-5085—2232 JEFFERSON AVENUEGilbertAZ85222GRP-7543NAVIGATE-HMO
ENRENR-111130 2026-05-23T13:22:01ZTran, Marcus····—07/01/46··UHC8333380•••-••-586917742091466UNKNOWN7237 Baseline RdPhoenixAZ85049GRP-2844navigate-hmo
ENRENR-1293342026-04-09T17:00:24ZKyleF.Little2003-01-01UHC-12654-85•••-••-589813873078683-3158 Willow CtMinneapolisMN55464GRP-2466medicare-adv-b
ENRENR-1365122026-09-15T13:21:16ZSANTIAGOKFORD1979-10-19UHC-63013-92··•••-••-79017295491469SANTIAGO.FORD@ICLOUD.COM7019 Camelback Rd #887·TempeAZ85250-5280GRP-1372NAVIGATE-HMO
ENRENR-1109672026-01-14T13:18:59ZCHRISDBROWN1988-06-21UHC-92954-99•••-••-3230856-692-2578—7413 Camelback RoadChandler··AZ85209-8813GRP-1064MEDICARE-ADV-A
ENRENR-1195312026-03-16T17:07:56ZBETTYAPETERS10-01-1990UHC-55125-01•••-••-3372738-643-2456betty.peters@hotmail.com143 Desert Sky BlvdChandlerAZ85232GRP-4735MEDICARE-ADV-A
ENRENR-1419212026-10-09T13:02:06ZNatalie—Nguyen1999-08-14UHC-95171-02•••-••-8721—natalie.nguyen@proton.me391 Willow CtNashvilleTN37267··GRP-8333CHOICE-PLUS-PPO
ENRENR-1251932026-02-25T13:26:34ZMARCUSOGRANT12/18/64UHC-43438-26•••-••-8643+1 846 467 8413marcus.grant@gmail.com——UNKNOWN—GRP-8931SELECT-EPO
ENRENR-1081882026-10-09T07:55:32ZnicholasO·armstrong1947-12-11UHC-83109-91•••-••-9516+1 258 335 5901-3741 CANYON RDTucson··AZ85719GRP-6160CORE-HMO
ENRENR-1333132026-08-22T03:25:18ZEric·ERodriguez1994-03-24UHC-21498-87•••-••-36237565973011—5422 JEFFERSON AVEJACKSONVILLEFLN/AGRP-6460SELECT-EPO
ENRENR-1115332026-05-09T12:31:30ZmichelleE.sullivan19501026UHC-09307-18•••-••-47266344746191MICHELLE.SULLIVAN20@AOL.COM2442 Market StDallasTX75255GRP-7666··CORE-HMO
ENRENR-1225702026-10-09T05:58:24Z Lucia—White1991-07-18uhc-66434-91•••-••-73578294112742LUCIA.WHITE@YAHOO.COM4563 LINCOLN WAYSacramento·CA95853GRP-9515CORE-HMO
ENRENR-1100302026-04-11T01:14:47ZSamanthaL.··Nelson1968-06-05UHC-28044-26•••-••-8307389-413-7288samantha.nelson74@hotmail.com5634 Bayshore DrSacramentoCA95855GRP-4686NAVIGATE-HMO
ENRENR-108488 2026-06-29T01:19:26ZEUGENE····BRYANTNov 28, 1969UHC-75291-21··•••-••-0884424-252-5480NULL4957 RIDGE RDNashvilleTN37285GRP-0474OPTIONS-PPO
ENRENR-1065572026-08-07T04:18:58ZJosephNTurner19851221UHC-44618-28•••-••-9172246.543.3922JOSEPH.TURNER19@AOL.COM·3857 Highland AveDenverCO80204·GRP-7608OPTIONS-PPO
ENRENR-1078122026-03-25T09:38:37ZJacob—·Bailey1949-02-19UHC-04349-64•••-••-6967871-751-0371JACOB.BAILEY@AOL.COM4884 Ocean AvenueMiamiFlorida33133GRP-6559NAVIGATE-HMO
ENRENR-1174332026-02-27T00:16:40ZMendez, Benjamin——09-12-1939UHC-12746-66-+1 256 774 6169BENJAMIN.MENDEZ11@OUTLOOK.COM·5835 Oak StreetGilbertAZ85248GRP-8163CORE-HMO
ENRENR-1017272026-09-23T01:23:43ZVincent O.—Roberts5/22/1986··UHC-46711-68—(414) 629-8403UNKNOWN4910 Mountain View DriveSacramentoCA95852GRP-6478·CORE-HMO
ENRENR-1392242026-02-22T23:25:40Z JOHUAUCASTRO01/11/77N/A•••-••-22357054916373joshua.castro39@gmail.com7336 Sunset BlvdCharlotteNC28243GRP-8502··NAVIGATE-HMO
ENRENR-1285332026-01-27T07:38:34ZNatalieOMason1992-08-24UHC-07376-13•••-••-9072·+1 687 409 2317natalie.mason@icloud.com3166 Market StLas Vegas·NV89179GRP-7254CHOICE-PLUS-PPO
ENRENR-1248452026-02-24T08:18:36ZSofia—Garrett1987-05-08··UHC-60736-86•••-••-59706707143325null256 OCEAN AVENUE Apt 15SEATTLEWA98197GRP-7522CHOICE-PLUS-PPO
ENR ENR-1213162026-03-24T08:30:44ZJulia—VargasNov 20, 1987UHC-03596-95•••-••-1086(393) 587-9131JULIA.VARGAS@OUTLOOK.COM3291 Hillcrest RdGilbert··Arizona85283-2087GRP-2918OPTIONS-PPO
ENRENR-1386212026-02-11T19:03:19ZScottM·Colilns05/19/83N/A•••-••-6880282-575-7427null6546 Market StLas VegasNV89179GRP-4700NAVIGATE-HMO
ENRENR-1281402026-08-16T15:06:04ZJOHNXFOX1942-08-28UHC-40679-15•••-••-7759·7197997533JOHN.FOX39@AOL.COM9468 Palm Dr·DallasTX75204-0434GRP-6313MEDICARE-ADV-A
ENRENR-1262912026-06-15T05:10:31ZABIGAILOELLIS2007-08-21UHC-11203-18•••-••-3586908-697-1154abigail.ellis2@yahoo.com2869 Palm DrivePHOENIXAZ85047GRP-0289OPTIONS-PPO
ENRENR-1369982026-03-03T20:23:31ZRUSSELLBFOWLER06/10/68UHC-69971-22•••-••-1736723-701-7922russell.fowler@proton.me8038 Elm StSacramentoCA·95898GRP-8218MEDICARE-ADV-A
ENRENR-1057212026-01-09T17:37:21ZJudyBRose··1960-02-14·UHC-80661-85•••-••-19156613165160judy.rose36@aol.com1226 Highland Ave #942SACRAMENTOCA95865GRP-0944··SELECT-EPO
ENRENR-1288832026-05-24T11:18:46ZERICV.DAVIS1981-02-16UHC-06409-80•••-••-5779(206) 416-3928eric.davis19@gmail.com9238 Market StPlanoTXUNKNOWNGRP-4665SELECT-EPO
ENRENR-1160262026-09-23T19:25:48ZBruce—Hill1994-02-07uhc-34686-55•••-••-8656404-801-8473bruce.hill@aol.com3680 SAGE CTFresnoCA93770GRP-2208·MEDICARE-ADV-B
ENRENR-1194492026-07-29T02:47:02Zolivia—ruiz1961-01-18UHC-84232-34•••-••-7921719-443-9614olivia.ruiz7@hotmail.com9419 Apache BlvdAustinTX78793GRP-8947NAVIGATE-HMO
ENRENR-1154492026-06-15T18:44:55ZEugeneURomero1997-08-21UHC4111517•••-••-7477+1 240 782 1079-8828 Mountain View DrGlendale··AZ85355GRP-1958OPTIONS-PPO
ENRENR-1025092026-03-26T08:24:48ZJANICE—BRADLEY2008-04-14··UHC-98079-31•••-••-509413248564541janice.bradley@aol.com4907 Desert Sky BlvdNASHVILLE·TN37239-0229GRP-1521NAVIGATE-HMO
ENRENR-1401312026-02-06T16:20:39ZKEITHNORTIZ1984-04-10UHC3719420•••-••-5884(760) 750-7428keith.ortiz84@proton.me··4229 PALM DRMiamiFL33121GRP-7901CHOICE-PLUS-PPO
ENRENR-1199322026-07-30T18:41:17ZSAMUELFBAKER1985-10-08UHC-92641-95•••-••-330318027236891samuel.baker98@outlook.com2871 OCEAN AVENUEFresno·CA93758-7745GRP-2560··OPTIONS-PPO
ENRENR-1382202026-05-20T14:29:41ZHannah—·Burns1965-07-13UHC-22094-17•••-••-834913755812646HANNAH.BURNS@HOTMAIL.COM4611 Forest AveSCOTTSDALEAZ85277··GRP-7073CORE-HMO
ENRENR-1346582026-01-13T11:50:19ZCarolDKing1980-12-06UHC-51452-61•••-••-4039622.656.3870CAROL.KING43@PROTON.ME4013 Union StreetNashvilleTN37285GRP-2171··OPTIONS-PPO
ENRENR-1426072026-07-27T02:21:35ZSpencer, JasonD—19430508UHC0308348•••-••-6396——447 WASHINGTON ST··MinneapolisMN55409GRP-3895CORE-HMO
43,101 rows, page 168 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.497Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty