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-1265792026-09-25T01:50:56ZBENJAMINKBOYD2/6/1939UHC4374798•••-••-7150452-777-0904benjamin.boyd3@gmail.com8631 SAGE CTJacksonvilleFL32269GRP-0481MEDICARE-ADV-A
ENRENR-1101252026-08-17T17:19:29ZWAGNERNNATALIE1965-07-26UHC-26872-91•••-••-53147903788518natalie.wagner@yahoo.com·9743 Sunset BlvdOrlandoFL·32818GRP-6760·NAVIGATE-HMO
ENRENR-1086522026-02-01T03:55:31ZCarrollZSophia02/23/79UHC-64413-52•••-••-3293+1 581 638 8412sophia.carroll@icloud.com5642 DESERT SKY BOULEVARDAtlantaGA30394-5152GRP-7932··MEDICARE-ADV-B
ENRENR-1263852026-10-04T14:57:05ZDanielFMorrison1967-01-20UHC-57254-08•••-••-5287617-970-0274daniel.morrison@icloud.com2317 Baseline RoadPHOENIXArizona85098GRP-1119CORE-HMO
ENRENR-1177542026-01-13T13:41:33ZRoyH.Wright2005-01-27UHC-76478-99•••-••-4680924-409-8673·ROY.WRIGHT95@OUTLOOK.COM4062 Baseline RdLas VegasNV89129·GRP-1669·MEDICARE-ADV-B
ENRENR-1155282026-07-02T23:54:24ZGaryVEspynoza1948-04-18UHC-84150-57—960-642-5868null7730 Lincoln WayGilbertAZ-GRP-4013MEDICARE-ADV-A
ENRENR-1238862026-01-17T01:21:40ZSaraYContreras1966-12-20UHC-07711-65··•••-••-029819369798944-3573 Indian School RdSAN ANTONIOTX·78274GRP-8136medicare-adv-a
ENRENR-1087552026-01-21T19:13:18ZDavidILucasJun 17, 2001UHC-04029-94•••-••-4004575-334-6610DAVID.LUCAS@YAHOO.COM5469 PALM DRIVELas VegasNV89178GRP-7768OPTIONS-PPO
ENRENR-1088912026-05-19T04:41:33ZCHRISTIANN.·POWELL1984-09-05UHC8070475•••-••-11154419011919CHRISTIAN.POWELL@HOTMAIL.COM2322 Union StreetPlanoTexasN/AGRP-1395NAVIGATE-HMO
ENRENR-142453 2026-03-30T04:34:31ZBRITTANYHTORRES19691215UHC-61986-06•••-••-85098079437606N/A6448 Sunset BlvdMesaAZ85285GRP-8109SELECT-EPO
ENRENR-1114632026-09-26T18:19:35ZHANNAH—FERNANDEZ06/07/48UHC-91041-43•••-••-0383657.690.8162··hannah.fernandez@gmail.com2300 Park PlDenverCO··80270GRP-8746medicare-adv-a
ENRENR-1079132026-03-29T21:59:01ZDONNACMOORE1983-06-07UHC-26588-38•••-••-9675220-965-5848·DONNA.MOORE@ICLOUD.COM5727 Lake View RdPlanoTX75090GRP-1173CORE-HMO
ENRENR-1412472026-08-03T16:35:20ZChristine··—Nguyen1967-05-25UHC-59659-36N/A+1 674 576 7987christine.nguyen41@hotmail.com7769 Park PlHoustonTX77078·GRP-7913NAVIGATE-HMO
ENRENR-1208772026-10-10T01:11:06ZchristopherOfreeman1977-06-08UHC-34571-07··•••-••-3829(370) 693-3421··NULL8397 OAK STREETChandlerAZ85260-2981GRP-5426OPTIONS-PPO
ENRENR-1018832026-09-04T03:19:33ZBrradleyUEdwards2004-12-06··UHC-73227-09•••-••-6771—bradley.edwards50@icloud.com6517 Sage CtSeattleWA98185-5876GRP-9788··CHOICE-PLUS-PPO
ENRENR-1404662026-05-18T09:03:49ZmariaD.soto19570124UHC-72498-95•••-••-33874738869095maria.soto57@proton.me9798 Main StreetGilbertAZ85239GRP-6308MEDICARE-ADV-A
ENRENR-1320702026-04-18T04:48:09ZRoyFRobertson1964-02-07UHC-28255-88•••-••-33327098785995roy.robertson54@aol.com6584 Park PlJacksonvilleFL32250GRP-7283OPTIONS-PPO
ENRENR-1182042026-02-04T14:59:16ZMarthaR.Boyd·1982-10-10UHC-31143-91•••-••-9119+1 701 658 2700martha.boyd@yahoo.com1811 Spring StLas VegasNV89108··GRP-1368NAVIGATE-HMO
ENRENR-1039292026-08-31T00:47:50ZKeithDMorales1973-08-27UHC-51608-34•••-••-48855556704672·keith.morales@yahoo.com9255 WASHINGTON STPLANOtx75009GRP-8759NAVIGATE-HMO
ENRENR-1364372026-05-05T08:33:01ZchristinaXestrada·02/07/69uhc-05394-63•••-••-02902575743192christina.estrada@hotmail.com5680 Canyon RdNashvilleTN·37201GRP-9863CORE-HMO
ENRENR-1334172026-09-14T07:43:04ZPAUL—RAMIREZ11-07-1961UHC5752613•••-••-2945692-938-4437paul.ramirez@outlook.com3676 Bayshore DrSan DiegoCalifornia92119·GRP-5859OPTIONS-PPO
ENRENR-1146242026-05-07T18:39:13ZAnnZ.Gaarrett8/12/1995UHC-09859-50•••-••-75138698980737N/A1339 VALLEY VIEW DRScottsdale·AZ85219GRP-5913NAVIGATE-HMO
ENRENR-1084542026-06-10T07:40:04ZPriyaV.Stone1946-06-10-•••-••-29739712230293priya.stone@outlook.com8768 Bayshore DriveEden PrairieMN55373GRP-2463CORE-HMO
ENRENR-1411332026-04-28T06:47:13ZRAYMONDY.CHAPMAN1975-12-27UHC-57667-96•••-••-9566202.346.7133raymond.chapman33@proton.me··739 River Road Apt 39NashvilleTN37239GRP-4601CHOICE-PLUS-PPO
ENRENR-1122352026-03-01T14:30:55ZkarenC.henry10/20/07UHC-60245-90··•••-••-74848939173519KAREN.HENRY@GMAIL.COM9161 Main Street··MiamiFL33130GRP-1872SELECT-EPO
ENRENR-106713 2026-09-27T21:28:51Z—A—25-10-1961uhc-64703-56•••-••-75104732937664··null··870 MARKET STOrlandofl32832-8301GRP-5950CORE-HMO
ENRENR-1051612026-06-23T07:59:48ZJoyceODuncan19820914UHC-07860-94•••-••-31249555856598N/A3519 Ridge RdDALLASTX-GRP-8569SELECT-EPO
ENRENR-1267842026-01-16T07:51:08ZEugene··Cole1939-11-07UHC-83421-32•••-••-717618508837504eugene.cole@proton.me·2170 HILLCREST RDLos AngelesCalifornia90081GRP-6699OPTIONS-PPO
ENRENR-1099562026-07-05T05:45:11ZYUKI—CAMPBALL·1970-04-08·UHC-79698-62•••-••-6105675.245.7915YUKI.CAMPBELL70@OUTLOOK.COM3878 Ridge RdEden PrairieMN55302-0843GRP-9208NAVIGATE-HMO
ENRENR-1341952026-04-19T16:32:37ZEmily—Cox11/28/60UHC-78445-65•••-••-9197-emily.cox90@yahoo.com3791 Washington StreetEden PrairieMinnesota55368·GRP-7101MEDICARE-ADV-B··
ENRENR-1016472026-09-10T01:55:45ZKATHERINEW···ROBERTSON02/16/77UHC-26141-96-9442618023katherine.robertson@aol.com2864 Lake View RdPlanoTX75013GRP-8752SELECT-EPO
ENRENR-1095872026-01-20T00:58:12ZanaZburns19790127UHC-41549-61··•••-••-4209825-596-9663ANA.BURNS@YAHOO.COM226 OCEAN AVE #137ORLANDOFL·32861GRP-2544CORE-HMO
ENRENR-1281002026-07-09T02:51:52ZAnthonyNMoore02-01-1999UHC-26830-07•••-••-073918385953722—8792 Highland Ave·PlanoTX··—GRP-9753CHOICE-PLUS-PPO
ENRENR-1002312026-02-28T05:04:20ZAaronV.Bryant1946-12-06UHC-21701-55•••-••-279818282660741aaron.bryant@icloud.com7725 CHURCH STTucsonAZ85786GRP-8250MEDICARE-ADV-B
ENRENR-1222912026-01-06T15:24:31ZMei—Kelly04/03/2007UHC-06073-29•••-••-9081(365) 373-3135mei.kelly24@proton.me5712 Pine Dr Apt 16Los Angeles·CA90069GRP-4620CHOICE-PLUS-PPO
ENRENR-1070292026-05-09T21:33:42ZRonaldY.James2006-09-11UHC-93023-09•••-••-89092271480ronald.james72@aol.com7332 Spring StreetPlano··TX75019GRP-9708SELECT-EPO
ENRENR-1122272026-06-25T22:35:12Zkyle—weebb1991-06-22UHC-73310-75•••-••-5439·809-696-7715kyle.webb7@icloud.com3288 LAKE VIEW ROADMesaAZ85270GRP-8844MEDICARE-ADV-A
ENRENR-1107332026-03-12T05:37:59ZPaulRKelley01/07/70UHC-52485-37•••-••-2032860.671.6045·paul.kelley@outlook.com3925 Hillcrest Rd #518JacksonvilleFLNULLGRP-0946SELECT-EPO
ENRENR-1096622026-02-14T03:29:56ZAlvarez, Bruce——20090625··UHC-37901-97•••-••-99235866137515bruce.alvarez87@hotmail.com1038 Union StMesaAZ85205GRP-5555CORE-HMO
ENRENR-1248382026-06-05T23:57:37Z·JOEYPWEBB2008-01-15UHC-44238-24•••-••-8242902-250-5861joseph.webb@outlook.com838 Washington Street #194MinneapolisMN55477GRP-0298NAVIGATE-HMO
ENRENR-1107692026-03-26T08:17:18ZBillyIWelch2/8/2008uhc-84428-82•••-••-3023588-807-9051null1255 Spring StTucsonAZ·85721GRP-3552SELECT-EPO
ENRENR-1405472026-10-04T17:14:30Zstephen—padilla1952-08-02UHC-99631-53•••-••-9108+1 553 567 3589stephen.padilla@proton.me2032 Lincoln WayLas VegasNV89164GRP-1359CORE-HMO
ENRENR-1076442026-09-08T17:25:43ZCarolyn—Lunna1947-05-20UHC-73667-01•••-••-53604088207898carolyn.luna@yahoo.com—-null—GRP-1217CORE-HMO
ENRENR-1241722026-07-31T12:18:58Z Robisnon, Bobby——NULLUHC3641787•••-••-4556+1 275 821 6491BOBBY.ROBINSON65@PROTON.ME7600 Bayshore DriveEDEN PRAIRIE··MN55399GRP-7564MEDICARE-ADV-B
ENRENR-1209582026-09-20T15:29:38ZJORDANY.YOUNG12/19/06UHC1124309•••-••-013212956700581jordan.young@icloud.com4637 Highland AveFresnoCA93791GRP-8513NAVIGATE-HMO
ENRENR-1226552026-06-04T07:37:00ZHannah—Lucas1986-12-09UHC-54951-70•••-••-779717145655361HANNAH.LUCAS@GMAIL.COM9358 Mountain View DrPlanoTX75067··GRP-3393MEDICARE-ADV-B
ENRENR-1352152026-03-17T22:35:48ZWood, Ethan··——07-02-1996UHC-49596-34•••-••-7606(504) 577-5803—7948 Main Street·CHARLOTTENC28249GRP-9695NAVIGATE-HMO
ENRENR-1085582026-05-31T02:57:27ZMyers, Greg——·1963-03-11UHC-56955-74•••-••-0574(416) 516-8613gregory.myers48@outlook.com·5794 Lincoln WayFresnoCA93777GRP-5121SELECT-EPO
ENRENR-1294112026-09-02T14:32:23Z·Kayyla—Carroll2000-10-24UHC-38077-37-—-·8138 Canyon RoadTempeAZ85298GRP-5031NAVIGATE-HMO
ENRENR-1312562026-04-14T02:32:31Z·CAROLIRIELY1995-12-18UHC-60140-26•••-••-3580270.686.5980carol.riley72@outlook.com6128 Main StreetTampaFL33627GRP-7443CORE-HMO
43,101 rows, page 89 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:37.721Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty