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-1148642026-03-08T01:19:55ZJAMES—CONTRERAS01/04/86··UHC-81579-21•••-••-2788+1 553 768 4103JAMES.CONTRERAS20@AOL.COM8536 Grand AvenueDenverCO80283GRP-9754CORE-HMO
ENRENR-1085312026-07-26T23:40:52ZCynthia—Price1941-10-01UHC-76329-93UNKNOWN··8698868327CYNTHIA.PRICE99@YAHOO.COM2275 MOUNTAIN VIEW DRLos Angelesca90063GRP-1129OPTIONS-PPO
ENRENR-1390842026-09-17T05:11:30ZWILLIEKHOLMES2001-10-19UHC-46139-28•••-••-9913778-749-6469WILLIE.HOLMES@AOL.COM8106 Lincoln WayHOUSTONTexas77083GRP-6475MEDICARE-ADV-B
ENRENR-115498 2026-09-29T22:26:55ZkimYvazquez1959-02-18UHC-98212-72•••-••-0377—NULL7007 Church StMesaArizona85246GRP-7233MEDICARE-ADV-B
ENRENR-1287962026-07-02T07:58:08ZKatherineP.Hamilton—UHC-73729-70•••-••-90173095174131katherine.hamilton@hotmail.com10 Mountain View DrColumbusOH43237GRP-1113SELECT-EPO
ENRENR-1012102026-04-26T10:57:28ZAndrew—Morgan12/08/1987UHC-78457-24N/Anullandrew.morgan@outlook.com9598 MESA DRIVEFresnoCA93762-2829GRP-0730SELECT-EPO
ENRENR-1022412026-05-13T06:07:56ZJOEH.STEWART1958-03-25UHC-96025-72•••-••-2650252-862-2042—4585 MOUNTAIN VIEW DRIVEDallasTX75282GRP-6378MEDICARE-ADV-B
ENRENR-1285742026-07-24T17:01:10ZMartha·CEdwards1953-05-24UHC-24689-69•••-••-4368—-2213 SUNSET BLVDLOS ANGELESCA·90056GRP-1002SELECT-EPO··
ENRENR-1117632026-02-08T13:36:14ZKevinA.Rice1999-08-06·UHC-54331-49•••-••-4873233-218-7197KEVIN.RICE20@ICLOUD.COMN/ANULL-—GRP-0267CORE-HMO
ENRENR-1066122026-05-31T04:19:52ZALAN—WAGNER··1970-03-01UHC-75092-90•••-••-119015055128445UNKNOWN··6466 BroadwayLos AngelesCA90063-0148GRP-2573MEDICARE-ADV-A
ENRENR-1125292026-05-05T11:36:53ZHiroshiFFreeman1977-05-09UHC-18692-03··•••-••-1256(456) 348-5461N/A·5685 LAKE VIEW RDMesaAZ85282GRP-9620MEDICARE-ADV-B
ENRENR-1059922026-09-02T03:59:46ZGilbert, Douglas——10/23/1994UHC-79322-76•••-••-5447—douglas.gilbert@gmail.com··7249 Market St #872SAN ANTONIOTX78216GRP-8631OPTIONS-PPO
ENRENR-1165242026-04-17T12:37:15Z emily—elliott1961-09-18UHC-77462-24•••-••-75228569701423EMILY.ELLIOTT@OUTLOOK.COM8875 Lake View RdNASHVILLEtn37214GRP-0929MEDICARE-ADV-B
ENRENR-1196922026-01-08T07:12:46Zlucia—soto2000-02-03UHC-71796-85•••-••-2944·(988) 706-9069LUCIA.SOTO@ICLOUD.COM7714 Pine Dr··TucsonAZ85702GRP-9925MEDICARE-ADV-B
ENRENR-1384242026-03-01T06:04:07ZVincent··URamirez1944-02-21··UHC-41583-48•••-••-513715686812784—8003 SUNSET BLVDCharlotteNC28266GRP-7774MEDICARE-ADV-A
ENRENR-1197972026-05-30T12:32:25Z JosephP.Dean1992-07-20UHC-80361-49•••-••-29012773097253joseph.dean@proton.me·5930 River RoadHoustonTX77059·GRP-8245MEDICARE-ADV-A
ENRENR-1263882026-03-06T01:07:51ZelizabethOgraham12/27/97·UHC-13821-54•••-••-1364(703) 884-8580elizabeth.graham@icloud.com342 RIVER ROADPlanoTexas75035··GRP-4348MEDICARE-ADV-B
ENRENR-1426012026-07-29T01:52:39ZGABRIEL—DAY1991-11-24UHC-98270-33—397-946-4340—5620 Mesa DriveDenverCO80236GRP-7036SELECT-EPO
ENRENR-1099082026-01-27T12:18:21ZMADISONV.CHAVEZ1938-03-15UHC-14327-76—564.631.2264N/A1650 CENTRAL AVENUEMinneapolisMN55499GRP-8555MEDICARE-ADV-A
ENRENR-1166552026-06-12T09:17:02ZTERESA····TAYLOR08/11/2007·UHC-76093-82•••-••-904514685133749teresa.taylor@hotmail.com3498 BAYSHORE DRIVETampaFLN/AGRP-1583MEDICARE-ADV-B
ENRENR-1091062026-08-26T23:10:55ZRojas, ChristineC—09/05/1958UHC-29975-38•••-••-2326(821) 226-9940·christine.rojas46@gmail.com9123 Spring StNashvilleTNUNKNOWNGRP-5709MEDICARE-ADV-B
ENRENR-1277352026-03-02T10:30:43ZJessUSchmidtNov 7, 1999UHC-33321-26•••-••-9045(751) 386-9572jessica.schmidt43@aol.com1851 River RoadHouston··TX77083GRP-7314MEDICARE-ADV-B
ENRENR-1329362026-05-06T12:26:00ZDENISE—YANG-UHC-29623-83•••-••-6539357-429-1332DENISE.YANG@GMAIL.COM1201 River RoadTucsonAZ··85732GRP-2361OPTIONS-PPO
ENRENR-1260462026-10-16T07:39:43ZMARCUSH.STONE1945-07-21—•••-••-9385(964) 476-4570marcus.stone70@proton.me7056 Pine DriveTucson··AZ85709GRP-1158NAVIGATE-HMO
ENRENR-1258722026-08-20T15:11:16ZLuciaV.Graham19500407UHC-22262-48•••-••-7104463-903-6935lucia.graham86@hotmail.com9737 Harbor BoulevardTempeAZ85250GRP-4524medicare-adv-b
ENRENR-1276402026-09-14T13:28:52ZRUTH—WHEELER02-10-1972UHC-22832-36•••-••-3499597.429.9157RUTH.WHEELER51@ICLOUD.COM1019 Valley View DrLAS VEGASNV··89114GRP-0378MEDICARE-ADV-A
ENRENR-1017662026-03-27T10:32:51Z CarolPPowell1948-10-05UHC1380206•••-••-4022(933) 393-4679carol.powell@outlook.com··6617 Highland AveTucsonAZ85764GRP-0966OPTIONS-PPO
ENRENR-1030702026-06-24T06:41:37ZhannahLryan12/26/1983UHC-29381-35•••-••-6089·3205161hannah.ryan28@proton.me406 Palm DrMesaAZ85212GRP-1662SELECT-EPO
ENRENR-1104292026-10-11T02:05:43ZMegan······Cook·1945-09-09UHC-29364-77··UNKNOWN305-463-5008null4062 Sage CtGlendaleAZ-GRP-5770·MEDICARE-ADV-B
ENRENR-1022752026-09-26T01:11:08ZARJNUPPALMER1989-03-27UHC1346870•••-••-629819487823154N/A8775 Elm StMesaAZnull··GRP-7661SELECT-EPO
ENRENR-1061422026-02-07T09:06:57ZRonaldL.Dean1982-08-11UHC-43191-80•••-••-2864UNKNOWNRONALD.DEAN@GMAIL.COM7414 Meadow LaneJacksonvilleFL32213-9023GRP-6309SELECT-EPO
ENRENR-1046662026-07-04T03:22:45ZBRADLEYHWALLACE1970-04-28uhc-69793-41•••-••-20177449822214-2777 Market StreetMinneapolisMN55419GRP-2063MEDICARE-ADV-B··
ENRENR-1038082026-05-04T02:19:56Z·Joshua—Diaz04/04/1988UHC-17950-82•••-••-4858838-502-8773joshua.diaz@hotmail.com693 Central AveFresnoCA93780·GRP-2926SELECT-EPO··
ENRENR-1286452026-06-19T10:44:27ZJaniceYOwens2001-03-19UHC-35715-39•••-••-6636(802) 721-1123janice.owens@proton.me·2484 CAMELBACK ROADLos AngelesCA90008··GRP-4157CHOICE-PLUS-PPO
ENRENR-1106732026-02-02T01:00:33ZJOANDMORRIS··21-12-2007UHC-13242-98•••-••-33796462704805·joan.morris@yahoo.com7097 Pine DriveSan DiegoCA92140GRP-4316MEDICARE-ADV-A
ENRENR-1010602026-07-01T02:27:36ZRoyG··Fisher·1967-07-02UHC-91505-50•••-••-6868627-745-6138ROY.FISHER19@AOL.COM323 BASELINE ROADTAMPAFL33699GRP-4084CORE-HMO
ENRENR-1419642026-08-02T00:54:21ZRonald····Tucker09/15/1956UHC-02202-71•••-••-4359638-871-6847—122 RIDGE RDAustinTX78792GRP-6049CORE-HMO
ENRENR-1378362026-04-20T07:58:50ZGraceE.Rios1940-12-04UHC-55558-64··•••-••-9135(964) 707-1813··GRACE.RIOS46@YAHOO.COM2070 Ridge RoadSeattleWA98122GRP-7138MEDICARE-ADV-A
ENRENR-1053682026-01-07T02:31:59ZdorothyMgriffin2003-01-10UHC-42358-35-3283818154dorothy.griffin18@icloud.com1772 Pine DrSan DiegoCA92157·GRP-6939MEDICARE-ADV-A
ENRENR-1146322026-01-17T10:34:02ZRileyLMary1961-03-13·UHC-59201-69•••-••-5588—mary.riley90@gmail.com—N/AN/A—GRP-2214CHOICE-PLUS-PPO
ENRENR-1160872026-01-01T17:26:32ZvincentX.vazquez12/02/70UHC-50969-35•••-••-41016068241208VINCENT.VAZQUEZ67@PROTON.ME532 CHURCH STREET·MinneapolisMN55426GRP-6227OPTIONS-PPO
ENR ENR-1090422026-10-13T00:29:10ZColeman, Brenda——1993-09-06UHC-19276-60•••-••-8808517-780-0747brenda.coleman84@hotmail.com8164 Oak StreetTucson·AZ85751GRP-4631CHOICE-PLUS-PPO
ENR ENR-1430732026-05-23T08:02:52ZcharlesMgordon1943-09-21UHC-54101-17•••-••-2814—UNKNOWN·2811 Desert Sky Blvd #641·SacramentoCA··95830GRP-6919MEDICARE-ADV-B
ENRENR-1103582026-07-15T09:01:17ZHELENRPENA2001-03-27UHC-35565-59•••-••-22257725058446HELEN.PENA64@HOTMAIL.COM6548 Palm Dr·Los AngelesCA90027GRP-9556MEDICARE-ADV-B··
ENRENR-1117072026-02-20T22:03:28ZgregoryHwebb28-05-1990··UHC-44136-24•••-••-5951815.234.1384gregory.webb44@hotmail.com3507 CAMELBACK ROADSACRAMENTOCA95859GRP-3110CORE-HMO··
ENRENR-1219862026-03-03T14:58:51ZAHMED—GIBSON13-03-1976UHC-32423-18•••-••-9263—ahmed.gibson@proton.me8166 Desert Sky Boulevard··OrlandoFL32817GRP-1551MEDICARE-ADV-B
ENRENR-1342512026-04-19T05:03:18Z·Richard····EspinozaMay 16, 1957UHC-68182-02•••-••-2977516-339-6241richard.espinoza96@outlook.com2683 Mesa DriveSeattle··WA98161GRP-4493MEDICARE-ADV-A
ENRENR-1109742026-06-16T16:00:32ZAbigail—Simmons1944-10-04UHC-94316-67•••-••-2231(256) 484-7168·abigail.simmons84@proton.me5286 CEDAR LNEden Prairie··MN55328GRP-8138NAVIGATE-HMO
ENRENR-1403572026-07-24T12:26:31ZDiegoL.Weaver1970-08-19UHC-97229-55•••-••-2452——6826 LINCOLN WAYJacksonvilleFL32241GRP-9612core-hmo
ENRENR-106114 2026-01-12T22:54:53ZlindaL.gomez··Apr 14, 1994uhc-48209-83•••-••-2046526-950-4569UNKNOWN8638 RIVER RDJacksonvilleFL32251GRP-6378OPTIONS-PPO
43,101 rows, page 80 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:36.714Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty