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-1232682026-07-01T04:34:03ZDONNNAUCOOPER1946-12-20UHC-62956-09•••-••-8643521.371.0972donna.cooper3@yahoo.com3861 Lake View RoadCOLUMBUSOH··43294GRP-1982SELECT-EPO
ENRENR-1423492026-03-28T21:26:42ZCheryl—Munoz28-09-1981UHC-70464-34•••-••-0044(222) 275-8239N/A6939 MESA DRCharlotteNC28232GRP-7630NAVIGATE-HMO
ENRENR-1196402026-06-29T18:41:20ZAnn··EAdams·1983-01-10UHC-99901-62•••-••-1002(561) 506-2737ann.adams@aol.com5537 Camelback RoadSacramentoCA95832GRP-1281MEDICARE-ADV-A
ENRENR-1032852026-08-07T09:44:35ZJacobA.Wilson1965-02-09UHC-87096-71—4539048478·-·1598 LINCOLN WAYATLANTAGA30322GRP-9167NAVIGATE-HMO
ENRENR-1033352026-08-30T11:27:05ZMARIAUSMITH1953-10-16UHC-01303-13•••-••-3785··MARIA.SMITH13@PROTON.ME9547 CEDAR LNNashvilleTN37202GRP-7145OPTIONS-PPO
ENRENR-1169092026-09-14T17:48:12Z·JUDY—WARD1976-07-26UHC-72375-15•••-••-37625331442judy.ward@proton.me398 Main StreetATLANTAGA30320GRP-2470NAVIGATE-HMO··
ENRENR-1296202026-06-26T23:03:09ZCastro, Patrick——2008-08-26UHC-51479-94•••-••-226916542298143patrick.castro@yahoo.com1268 Washington Street #711FRESNOca··93735GRP-9371OPTIONS-PPO
ENRENR-1094422026-04-29T15:09:02ZLauren—Howard2002-10-01UHC-36100-80•••-••-8912918-679-6560UNKNOWN·5084 River RoadGilbertAZ85251GRP-6031·OPTIONS-PPO
ENRENR-1325532026-06-01T18:03:17ZCarlosFGrant1974-07-13UHC-23187-98··•••-••-25455607120723—4876 WASHINGTON STREETChandlerAZ85288GRP-4962MEDICARE-ADV-A
ENRENR-1397182026-04-30T04:50:10ZWalker, Terry——15-11-2005UHC-13254-77··•••-••-4594N/ATERRY.WALKER@HOTMAIL.COM6348 Palm DrPhoenixAZ85070GRP-5567·SELECT-EPO
ENR ENR-1062342026-09-19T06:14:28ZTriciaS.Simmons1936-12-19UHC-34156-49•••-••-2151·684-293-5793PATRICIA.SIMMONS@OUTLOOK.COM··320 Sage CtLos AngelesCA90029GRP-4344medicare-adv-b
ENRENR-1255712026-04-19T02:21:49ZBRANDON—PATTERSON1949-02-27UHC-78874-42NULL+1 336 439 9188··brandon.patterson@outlook.com1273 Apache Boulevard·TempeAZ85208GRP-4865CORE-HMO
ENRENR-1354652026-02-19T10:35:56ZJamas, Carol·S—01-09-1962UHC-43610-58•••-••-80708942674287carol.james31@proton.me444 PARK PLACEEden Prairie··MN—GRP-4385NAVIGATE-HMO
ENRENR-1142542026-06-29T05:24:42ZAmy··Soto05/18/85UHC2338151•••-••-7066831-664-8487N/A4411 SUNSET BOULEVARDMinneapolisMN55473GRP-4306CHOICE-PLUS-PPO
ENRENR-1002592026-04-06T23:13:51ZGarza, MarilynT—19-06-1938uhc-96077-99•••-••-73794496353634UNKNOWN2481 Sage Ct #371NASHVILLETN37232GRP-4626CHOICE-PLUS-PPO
ENRENR-1399212026-07-29T02:52:03ZLori—Cruz0602-19-14UHC-84305-35•••-••-0809+1 430 506 0278-1354 Harbor BlvdAtlantaGA·30388GRP-1161SELECT-EPO
ENRENR-1327522026-03-20T01:32:54ZNicholas—Arnold1980-06-27UHC-28133-87•••-••-7441653-957-0181NICHOLAS.ARNOLD@OUTLOOK.COM··9623 FOREST AVEChandlerAZ·85259GRP-1906MEDICARE-ADV-A
ENRENR-1269492026-01-25T07:00:17ZCarl—Garrett19741004UHC-17347-36•••-••-6678373-799-3357—3468 MEADOW LANEAUSTINTX—GRP-9755MEDICARE-ADV-B
ENRENR-1226762026-09-26T12:05:11ZgeorgeE.porter02/20/59UHC-03769-51•••-••-1827(727) 628-6905george.porter76@yahoo.com··1997 Elm StreetEden PrairieMN55328-6154GRP-2753SELECT-EPO
ENRENR-1273812026-10-10T18:14:15ZKyleMSilva7/18/1968UHC-98556-49•••-••-8018819.702.7654kyle.silva35@aol.com4890 Bayshore DrPHOENIXAZ85019GRP-8160OPTIONS-PPO
ENRENR-1054152026-01-04T22:57:21Zjulie—contreras1939-10-28UHC-05984-76•••-••-7667278-872-4238julie.contreras78@gmail.com7644 HILLCREST ROADPHOENIX··Arizona85039GRP-8690SELECT-EPO
ENRENR-1314332026-10-07T03:12:37ZAHMEDCCRUZ22-04-1986UHC-49614-51UNKNOWN9524266477AHMED.CRUZ@OUTLOOK.COM5396 Hillcrest RdFresnoCA93708GRP-2740SELECT-EPO··
ENRENR-1200922026-02-13T14:18:50ZKeithB··Hughes2000-02-18UHC-88110-41UNKNOWN(310) 411-5647KEITH.HUGHES3@OUTLOOK.COM5498 Market StTempeAZ85273GRP-2998CORE-HMO
ENRENR-1129912026-09-25T04:42:00ZLoganIMorris··19621012UHC-14413-18•••-••-7254UNKNOWNNULL1436 Spring StreetLAS VEGASNVUNKNOWNGRP-7709CHOICE-PLUS-PPO
ENRENR-1007502026-08-10T03:15:41ZbrianK.patterson·09-10-1947UHC-20415-81·NULL-brian.patterson@outlook.com7803 Meadow LnHoustonTX77099GRP-0503SELECT-EPO
ENRENR-1285342026-04-18T09:00:45ZHlen—Watson1971-09-09UHC-53009-43•••-••-91126445964399HELEN.WATSON@AOL.COM4667 River RoadMINNEAPOLISMN55423GRP-6653NAVIGATE-HMO
ENRENR-1150462026-09-08T17:56:39ZANDREW—EDWARDS06/19/1957UHC-43496-82•••-••-7497UNKNOWNandrew.edwards@aol.com6231 BAYSHORE DRGLENDALEAZ85339GRP-6323OPTIONS-PPO
ENRENR-1421812026-07-16T14:37:30ZJesse—Vasquez9173-08-05··UHC-78649-54•••-••-80105498968259jesse.vasquez@icloud.com6969 INDIAN SCHOOL RDAtlantaGA30331GRP-3438SELECT-EPO
ENRENR-1266202026-02-15T01:37:28ZWells, AmberT—1939-12-20UHC-53150-30N/A+1 612 263 3391AMBER.WELLS40@PROTON.ME7373 Jefferson AveChandlerAZ··85215GRP-7339OPTIONS-PPO
ENRENR-1169732026-03-03T03:29:56ZLUCIAG.LITTLE2008-01-04·UHC-70129-25•••-••-6234954.218.5645lucia.little47@outlook.com5507 MESA DRIVEMiami·FL·33115GRP-8504OPTIONS-PPO
ENRENR-1109362026-07-16T03:13:11Z Amber·RBurton1949-09-08UHC6288017•••-••-4007(622) 947-3047amber.burton@aol.com9798 Canyon RdMinneapolisMN55419GRP-6820··OPTIONS-PPO
ENRENR-1018052026-04-14T09:24:33ZYuki—Rios1994-07-06UHC-33064-03•••-••-15047645390781YUKI.RIOS76@ICLOUD.COM2455 MAIN STREETEden PrairieMN55369GRP-1824SELECT-EPO
ENRENR-1058942026-06-29T08:05:37ZJesse··—SantosJun 19, 1981UHC-21978-49•••-••-1808337.773.9768UNKNOWN8431 PALM DRPhoenixAZ85086GRP-0474CORE-HMO
ENRENR-1283642026-07-25T23:55:10ZKimberly—Wright··1983-10-10UHC5934592•••-••-5015(389) 867-3929··kimberly.wright73@hotmail.com6957 Bayshore DriveLos AngelesCA90063GRP-5402SELECT-EPO
ENRENR-1303342026-03-24T15:42:33ZSTEPHENNHENRY1987-04-03UHC-31765-74·UNKNOWN(734) 344-1575stephen.henry@gmail.com··5848 Forest AvePlanoTX75003GRP-9281NAVIGATE-HMO
ENRENR-1123842026-07-08T00:31:19Zkathleen—watson27-07-1959UHC-89150-20—+1 584 734 2751KATHLEEN.WATSON87@ICLOUD.COM2694 Maple AveDallasTX75204GRP-7768MEDICARE-ADV-A
ENRENR-1388632026-03-07T22:55:59ZCarolynYGonzalez··26-03-1939··UHC-17410-90•••-••-4860218-981-1835NULL4727 Highland AveLas Vegas·NVNULL··GRP-2931medicare-adv-a
ENRENR-1123752026-05-03T05:53:54ZIsabella—Berry01-04-1945UHC-10949-47•••-••-1932N/Aisabella.berry@outlook.com8659 SAGE COURTTucsonAZ·85722GRP-0979MEDICARE-ADV-A
ENRENR-1358672026-01-05T17:33:17Zdeborah—coopar1949-12-16UHC-71020-52•••-••-7147(584) 606-5710DEBORAH.COOPER@AOL.COM675 OAK STREETSan DiegoCA92112··GRP-3448MEDICARE-ADV-B
ENRENR-1340142026-01-22T15:14:35ZBeverly—Wheeler1947-10-05UHC-77445-20•••-••-7786(943) 795-4809BEVERLY.WHEELER@OUTLOOK.COM7151 CENTRAL AVESan DiegoCalifornia92180GRP-3534CHOICE-PLUS-PPO
ENRENR-1049842026-10-07T14:41:20ZJOESPHZSIMMONS1/14/1942UHC-82187-94•••-••-1266950-445-4872joseph.simmons@yahoo.com6762 Valley View DriveCHARLOTTENC28248-2959GRP-1553CORE-HMO
ENRENR-1295532026-02-16T18:16:42Zandrew—burton05-08-1970UHC-88406-12•••-••-8518474.214.5016andrew.burton@proton.me4315 CAMELBACK RDTampaFL33642·GRP-5141medicare-adv-a
ENRENR-1318522026-08-28T12:52:05ZAUSTINICASTILLO1948-09-07·UHC1507419•••-••-292919242459053austin.castillo94@aol.com2209 Maple AvenueTampaFL33652··GRP-1925MEDICARE-ADV-B
ENRENR-1233572026-02-15T11:12:25ZTheresaL··Garza28-10-1942UHC-29869-56•••-••-02046682471738···theresa.garza30@outlook.com877 Cedar LnAtlantaGA30319GRP-2195··OPTIONS-PPO
ENRENR-1038152026-06-12T19:25:26ZWeaver, Chistine——19860405··UHC-97085-20•••-••-7849237-452-6083christine.weaver@hotmail.com9496 Lincoln WayChandler··AZUNKNOWNGRP-5625OPTIONS-PPO
ENRENR-1168492026-03-12T08:24:58ZPriya—Marquez7/8/1979UHC-15525-70•••-••-64504506653889priya.marquez41@aol.com5769 Church Street··ScottsdaleAZ85250GRP-5015CHOICE-PLUS-PPO
ENR ENR-1406502026-01-24T08:52:10ZRANDY—VALDEZ15-02-1956UHC-86863-81•••-••-939414683533078randy.valdez29@outlook.com1385 Ocean AvenueColumbusOhio43289GRP-5785MEDICARE-ADV-A
ENRENR-1303532026-09-03T03:37:29ZJESSICAFBAKER1977-11-26UHC-47501-58··•••-••-09394324965121JESSICA.BAKER81@AOL.COM9664 Willow CourtNashvilleTN37259GRP-7187CHOICE-PLUS-PPO
ENRENR-1266952026-06-23T02:06:58ZSANDRA—JACKSON01/25/1964UHC-78773-38··•••-••-778516288326945sandra.jackson@outlook.com2200 HILLCREST ROADDenverColorado80269GRP-5599SELECT-EPO
ENRENR-1087272026-03-22T11:16:06ZARJUNR.HUNT20020213UHC-96687-79•••-••-2071+1 707 788 7410arjun.hunt@gmail.com3349 SPRING STEDEN PRAIRIEMN55309··GRP-7774SELECT-EPO
43,101 rows, page 162 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.490Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty