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-1292332026-08-25T19:05:17ZJENNIFER—WILLIAMS8/6/2007UHC-55516-58•••-••-60464933821410JENNIFER.WILLIAMS10@HOTMAIL.COM6679 Maple AveEden PrairieMNnullGRP-5001SELECT-EPO
ENRENR-1336672026-07-16T15:35:41Zcarl—pierce7/24/1981UHC1397318•••-••-1232(540) 239-1218carl.pierce46@proton.me7608 BASELINE RD #234OrlandoFL·32873GRP-9828OPTIONS-PPO
ENRENR-1341522026-06-15T02:55:05ZDouglasRWoods1940-01-07UHC-42719-19—(372) 323-3546NULL2430 ELM STREETColumbusOH····GRP-8958SELECT-EPO
ENRENR-1079072026-01-09T13:08:19ZCHERYL—SNYDER09/06/88UHC-01160-94—(977) 272-3844N/A6293 PALM DRHoustonTX77097GRP-1404CORE-HMO
ENRENR-1260632026-07-21T00:49:05ZKveinKJordan·2/4/1973UHC-50265-96•••-••-6511+1 879 665 9103kevin.jordan75@gmail.com4956 Spring StScottsdaleAZnullGRP-1939SELECT-EPO
ENRENR-1000732026-09-30T07:50:49Z·JeemyGFranklin1974-09-25UHC-69691-36•••-••-39467618885265jeremy.franklin@outlook.com·3588 Jefferson Ave Apt 16HoustonTX77063GRP-4068·SELECT-EPO
ENRENR-1120382026-01-07T07:46:17ZJOEZ··FREEMAN2007-11-17UHC-44075-78•••-••-3345N/AJOE.FREEMAN99@ICLOUD.COM7788 Meadow LnMiami·FL33128GRP-2533OPTIONS-PPO··
ENRENR-1326422026-10-08T23:54:25ZDebraU.White1948-06-26UHC-18789-34•••-••-0961500-402-5449debra.white@hotmail.com4234 Desert Sky BlvdFresnoCA93744GRP-2791MEDICARE-ADV-A
ENRENR-1420662026-03-14T19:00:10ZJesseRMoreno19711212UHC-74726-93•••-••-33517743848274jesse.moreno28@proton.me383 GRAND AVENUESeattleWA98153GRP-5048medicare-adv-a
ENRENR-1223492026-05-31T00:11:18ZKENNETH—HENRY··2001-05-17UHC-27427-73•••-••-3303524-554-2623N/A··4427 Forest AveDallasTexas75208GRP-1486··CHOICE-PLUS-PPO
ENRENR-1429122026-05-04T15:05:49ZNatalie—Lane1981-11-12UHC-16159-95•••-••-86806955752499NATALIE.LANE65@HOTMAIL.COM8085 Meadow LnNashvilleTN37241GRP-3798CHOICE-PLUS-PPO
ENRENR-1197032026-03-13T22:08:16ZHrioshi··HParker·1979-07-03UHC-03341-19-··UNKNOWNhiroshi.parker@icloud.com8871 OCEAN AVEHoustonTX—GRP-2015MEDICARE-ADV-B
ENRENR-1070802026-06-25T12:14:36ZTIMDRICE1984-10-08UHC-04382-44•••-••-0937—NULL3691 Grand AvenueEden PrairieMN55384GRP-2574MEDICARE-ADV-B
ENRENR-1061492026-08-10T13:59:57ZBradley—NunezOct 4, 1981UHC-94009-88•••-••-9542(693) 702-3124BRADLEY.NUNEZ95@HOTMAIL.COM4970 Union StSan AntonioTX78237-4200GRP-7195medicare-adv-b
ENRENR-1413242026-04-09T09:19:02ZJanice—Ryan1973-11-17UHC0387994•••-••-1981+1 862 521 5064JANICE.RYAN82@GMAIL.COM143 Palm DriveAustinTX78799GRP-3785MEDICARE-ADV-B
ENRENR-1215542026-06-08T19:56:38ZHAROLD····ROJAS1996-10-25UHC-16881-88null(749) 723-6364harold.rojas@gmail.com4310 Ridge RoadFRESNOCA93794GRP-4368MEDICARE-ADV-B
ENRENR-1387532026-08-03T13:35:06ZBettyBMurray··1968-04-20UHC-79482-59•••-••-11755942915107betty.murray@aol.com6683 MARKET STREETColumbus·OH43273-0220GRP-3211MEDICARE-ADV-B
ENRENR-1157102026-06-02T14:27:02ZGLORIAL.ROSS1949-07-24UHC-79135-71··•••-••-5114971.487.2688GLORIA.ROSS7@PROTON.ME1393 BroadwaySan DiegoCA92115GRP-8551NAVIGATE-HMO
ENRENR-1060862026-07-10T21:52:21ZLinda E.—Burton1988-11-06UHC-38270-36··•••-••-9791+1 212 968 2476linda.burton@aol.com3172 Baseline RoadPhoenixAZ85002GRP-2506MEDICARE-ADV-B
ENRENR-1374682026-01-11T10:42:20ZBEVERLYHBEELL11/16/1947uhc-87800-37•••-••-3116(858) 280-7332BEVERLY.BELL@PROTON.ME·4101 Mesa DrAtlantaGA30341GRP-1979OPTIONS-PPO
ENRENR-1043922026-10-07T22:00:31ZDOROTHYW.ROGERS1976-08-24UHC-06003-66•••-••-6095(340) 719-9887dorothy.rogers78@outlook.com··5012 Elm Street··DallasTX75238GRP-2523CHOICE-PLUS-PPO
ENRENR-1337522026-07-09T21:41:55ZDonaaldC.Ramirez1983-09-22UHC-32962-76•••-••-4511—donald.ramirez@aol.com6127 Park Place··Jacksonvillefl·32225GRP-2850MEDICARE-ADV-B
ENRENR-1124922026-08-04T16:51:02ZSCOTT··—LAWSON1995-05-11UHC-44563-73—(905) 244-1511null8458 Baseline Road Apt 12Denver··CO·80255GRP-9359CHOICE-PLUS-PPO
ENRENR-129974 2026-04-05T04:21:56ZalexisWparker11/26/1988UHC-53530-87•••-••-18004048602689ALEXIS.PARKER@OUTLOOK.COM2479 Harbor BlvdAustinTXN/AGRP-9974CHOICE-PLUS-PPO
ENRENR-1188462026-04-17T23:07:26ZJordan—·Stone1989-11-22UHC-29838-90•••-••-0758453-401-9809JORDAN.STONE2@OUTLOOK.COM·2253 Sage CourtFresnoCA93795GRP-3266medicare-adv-b
ENRENR-1389462026-02-02T09:36:41ZChales—McDonald··24-08-1943UHC-75613-83•••-••-9736696.248.9850charles.mcdonald76@proton.me841 Spring StreetOrlandoFlorida32851GRP-1087MEDICARE-ADV-A
ENR ENR-1249832026-02-10T15:18:17ZGeraldW.Garrett1112-91-76··UHC-05394-15•••-••-1882665-368-7668gerald.garrett12@icloud.com·1125 Lincoln WayLos AngelesCA90036GRP-4081··medicare-adv-a
ENR ENR-1374662026-10-13T16:51:13ZSamuelT.Walker1981-02-24UHC-88404-81-18844769800samuel.walker72@outlook.com3673 Bayshore DrSan AntonioTX78243GRP-8668NAVIGATE-HMO
ENRENR-143053 2026-01-28T06:01:35ZANNA—EVANS01/20/1986UHC-64955-96•••-••-8422(602) 688-7793NULL2315 River RdTucsonAZ··85796GRP-2180CORE-HMO
ENRENR-1042662026-04-21T21:14:21ZTimothyAGarrett20030512UHC-19940-02•••-••-23359477430331timothy.garrett@hotmail.com4412 WILLOW CTPlanoTX75090GRP-7227SELECT-EPO
ENRENR-1048482026-03-27T13:56:26Zjessica—berry1982-06-25UHC-02004-26NULL··219.362.2562jessica.berry@gmail.com8958 Bayshore DriveOrlandoFL32826GRP-8117·MEDICARE-ADV-A
ENRENR-1357762026-10-03T23:20:16ZChristine··SWright—UHC-27440-91—3292341066··UNKNOWN5140 Ridge RoadGlendale·AZ85395GRP-4938NAVIGATE-HMO
ENRENR-1218562026-04-03T15:28:23ZMarcus—Nguyen1981-01-17··UHC-61216-08•••-••-3109604-421-1221marcus.nguyen@hotmail.com8499 Forest AvenueHoustonTX77037GRP-3581OPTIONS-PPO
ENRENR-1421432026-05-31T00:32:44ZAlan—Hart1370-19-48UHC-90707-57··•••-••-8749420-280-8058ALAN.HART@ICLOUD.COM5735 Elm StreetDenverCO—GRP-3146MEDICARE-ADV-A
ENRENR-1393552026-05-12T21:53:41ZMason—Santiago06-12-1989UHC-44962-59•••-••-6002654-521-4348mason.santiago@aol.com3907 Sage Ct #608DenverCO80231GRP-4856MEDICARE-ADV-A
ENRENR-1177722026-05-15T00:33:29ZLUISX.GRAY2007-11-21UHC1252266··•••-••-99562559086145luis.gray@aol.com8034 Park PlaceFresnoCA93719GRP-0335OPTIONS-PPO
ENR ENR-1205072026-02-21T22:51:54ZTHERESA··GGORDON1944-01-11UHC-51004-21•••-••-26616323329—5855 Grand Avenue·CHANDLERAZ85295GRP-7398MEDICARE-ADV-A
ENRENR-1118132026-01-17T17:47:41ZDEBRA—BROOKS1988-11-28UHC-12059-12•••-••-9248·(881) 794-2527DEBRA.BROOKS62@HOTMAIL.COM··3518 HARBOR BLVDCharlotteNC28294GRP-7533choice-plus-ppo
ENRENR-1179082026-03-19T06:30:59ZEVANS—VIGINIA7028-19-57UHC-47098-36•••-••-9633(496) 940-4567····6614 Elm StreetScottsdaleArizona85284GRP-2393SELECT-EPO
ENRENR-1293542026-04-08T18:34:25Z Burtoon, Angela··—····1988-07-08UHC-28844-31•••-••-7277UNKNOWNangela.burton@hotmail.com6571 River RoadORLANDOFL32886GRP-2316NAVIGATE-HMO
ENRENR-1105122026-08-21T00:55:08Z JoshuaRHayes·13-04-1956UHC-85275-22•••-••-4870(591) 858-4128joshua.hayes2@icloud.com3922 Hillcrest RoadEden PrairieMN55303GRP-1321OPTIONS-PPO
ENRENR-1182472026-06-16T09:45:36Z AHMED··—SANDOVAL2/10/1942UHC-43337-02NULL··528-472-1276ahmed.sandoval@aol.com84 Church StreetGilbertAZ85238GRP-2635MEDICARE-ADV-A
ENRENR-1303502026-10-05T23:07:01ZBrenda—·Tucker1977-08-28UHC-97550-61•••-••-5628(598) 359-8422NULL7764 Central AvenueChandlerAZ85228-8103GRP-9844··OPTIONS-PPO
ENRENR-1395262026-07-16T06:42:11Z Patrick·D.Torres0721-09-77UHC-30389-16•••-••-4123302-983-9746patrick.torres19@outlook.com·9888 Sunset BoulevardLos AngelesCA90000GRP-0115select-epo
ENRENR-1407172026-07-27T03:50:06Zcamila—schmidt1963-11-21··UHC-25491-14•••-••-2859764-542-3283·camila.schmidt83@yahoo.com7202 Market StreetLAS VEGASNV89115-3653GRP-7912MEDICARE-ADV-A
ENRENR-1152222026-08-22T19:39:05ZelijahL.matthews1953-03-16UHC-77956-45NULL··(410) 843-4974··ELIJAH.MATTHEWS@HOTMAIL.COM8477 PINE DRIVE··SacramentoCA95859GRP-0167OPTIONS-PPO
ENR ENR-1309582026-02-15T10:27:01Z·Julia—Walker1973-07-13UHC-38007-53•••-••-2665nulljulia.walker@yahoo.com8617 Apache BlvdPlanoTXNULLGRP-2284SELECT-EPO
ENRENR-1022072026-03-04T21:50:09Zvictoria—phillips1938-03-11uhc-89176-51—(509) 853-6150victoria.phillips63@aol.com4375 SUNSET BLVDMiamiFL··33102GRP-8817CHOICE-PLUS-PPO
ENRENR-1332522026-02-21T13:26:41ZJERRYG··SANCHEZ1988-09-27UHC-29270-33•••-••-35403656995693jerry.sanchez@outlook.com322 Meadow LaneDenverColorado80240GRP-5451select-epo
ENRENR-1392832026-06-02T01:23:51ZGREGORYCSALAZAR1952-03-17UHC5776677•••-••-148018995304982gregory.salazar89@aol.com5541 Highland AvenueLos Angeles··CA-GRP-6784MEDICARE-ADV-B
43,101 rows, page 241 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.623Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty