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
ENR ENR-1327302026-08-24T02:23:36ZKATHRYNXMEJIA1938-02-19UHC-64570-80•••-••-6854(853) 656-3982NULL3998 LAKE VIEW RDSeattleWA98186GRP-8068NAVIGATE-HMO
ENRENR-1089202026-10-12T06:17:50ZJean—Myers··1977-02-04UHC-89681-88•••-••-6294428-733-8255JEAN.MYERS@HOTMAIL.COM·4776 PINE DROrlandoFL32867-4715GRP-6614NAVIGATE-HMO
ENRENR-1294212026-05-26T16:18:56ZDylanZ.Carpenter2001-05-19UHC-91224-18•••-••-3364+1 594 273 4718·DYLAN.CARPENTER23@PROTON.ME1683 Desert Sky BlvdJacksonvilleFL32245GRP-3338MEDICARE-ADV-A
ENRENR-1048022026-08-09T23:03:00ZGaryVWeber1981-03-13UHC-46874-68•••-••-6162980-512-0981gary.weber77@proton.me7590 Forest AveSEATTLEWA··98100GRP-8955OPTIONS-PPO··
ENRENR-1201742026-04-05T21:05:51ZRobert—Flores1988-01-25UHC-93809-33•••-••-5173········8541 River RdLos AngelesCA90056-2400·GRP-6694·SELECT-EPO
ENRENR-1297312026-03-26T02:58:30ZARTHURWRIOS1972-11-23uhc-05334-77•••-••-212414303402335arthur.rios60@aol.com8018 Elm StGlendale··AZ85335GRP-8323NAVIGATE-HMO
ENRENR-1272402026-02-10T05:58:00ZAnnG.Russell06/08/06UHC-35547-48•••-••-5881+1 388 565 6960ANN.RUSSELL@HOTMAIL.COM4502 Hillcrest RoadSan DiegoCA92103GRP-9106NAVIGATE-HMO
ENR ENR-1348832026-04-30T19:38:58ZTheresaY.Rios2008-07-20··uhc-59751-66•••-••-40847099412606—3083 Sage CtHouston·TX77063-3786·GRP-9241SELECT-EPO
ENRENR-1301432026-08-03T12:52:15ZRuthJParker··06/02/1984·UHC-34532-34•••-••-2927561-315-2704ruth.parker@aol.com6694 Sage CourtChandlerAZ··85263GRP-3492MEDICARE-ADV-B
ENRENR-1202472026-10-17T22:52:24ZMelissa E····Deelgado1976-06-01UHC3252949•••-••-491412166353244melissa.delgado@hotmail.com2076 Camelback RdTampaFL33621-7299GRP-8603NAVIGATE-HMO
ENRENR-1085992026-08-30T20:09:33ZEvelyn·K.Green2006-05-03UHC-78882-43•••-••-7779369.599.9499UNKNOWN5420 Jefferson AveLos AngelesCA90036GRP-4795CORE-HMO
ENRENR-1141142026-03-23T12:18:27ZVincentDRodriguez1987-07-14UHC-87317-98•••-••-3798556-216-4717VINCENT.RODRIGUEZ1@OUTLOOK.COM8521 Ridge RoadGlendaleAZ85353GRP-5519SELECT-EPO
ENRENR-1203392026-07-08T03:33:27ZDay, TheresaR.—2003-04-11UHC-77631-82•••-••-8256(379) 846-9309—2021 Meadow LaneGLENDALEAZ85359GRP-9307SELECT-EPO
ENRENR-1422992026-09-16T23:06:58ZHAROLD—HART1994-04-11UHC-36348-42•••-••-7793600-232-9636—2280 Valley View DriveFresnoCA93746GRP-2353CORE-HMO
ENRENR-1331822026-04-21T23:48:53ZDaniels, BeerlyK—8/1/1994UHC-34187-75•••-••-7023+1 875 923 9526beverly.daniels89@outlook.com5218 Jefferson AvenuePHOENIXAZ85011GRP-2159SELECT-EPO
ENRENR-1086672026-06-12T13:10:50ZJACOB—COLEMAN1963-06-15UHC-92202-30··•••-••-3335363-778-7263jacob.coleman@yahoo.com1605 BroadwayFresnoCA93786-9077GRP-9116MEDICARE-ADV-B
ENR ENR-1162272026-03-11T05:46:08ZElizabeth··Hernandez1945-01-01UHC-72155-81•••-••-7157(330) 493-2376NULL4988 Baseline RdTucsonAZ—GRP-9910CORE-HMO
ENRENR-1405282026-08-16T17:38:42ZArthurTReidnullUHC-82158-14•••-••-8213449-974-2444ARTHUR.REID@PROTON.ME4854 Church StreetMiamiFlorida33163-2418GRP-6318NAVIGATE-HMO
ENRENR-1338702026-06-26T16:23:41ZDanielle·····Cruz1978-03-17UHC9420422•••-••-99726223605656UNKNOWN3140 MAIN STREETSan DiegoCA92197GRP-5801NAVIGATE-HMO
ENRENR-1418952026-06-22T01:55:02ZomarImeyer··26-04-1997UHC-76229-33•••-••-0852488.660.0187OMAR.MEYER@OUTLOOK.COM6245 Market StreetDallasTX75202GRP-7922CHOICE-PLUS-PPO
ENRENR-1146402026-08-05T05:41:22ZElijah—Sullivan1941-04-26UHC-16806-79•••-••-4480349-599-2944ELIJAH.SULLIVAN66@OUTLOOK.COM7717 LAKE VIEW RDEden PrairieMN55373GRP-8028··MEDICARE-ADV-B
ENRENR-1212462026-04-16T14:27:34ZKaylaS.Riley12-02-2004UHC-19964-66•••-••-2121(501) 221-1052kayla.riley21@hotmail.com2261 RIVER ROADDallastx75285·GRP-1792CORE-HMO
ENRENR-1364932026-03-05T23:49:42ZSantos, ArthurN.—07/02/94UHC6464318•••-••-4653(704) 342-8300arthur.santos36@yahoo.com9820 MARKET ST··FRESNOCA93776GRP-1570SELECT-EPO
ENRENR-1421742026-03-28T06:52:40ZJERRY—DAY1966-12-18·UHC-84480-65•••-••-14467677674930null4362 Church StreetDallasTX75245GRP-9749MEDICARE-ADV-B··
ENRENR-1424242026-03-09T08:11:55ZAUSTINX.MORGAN2003-05-17UHC-06303-50•••-••-64612703934223austin.morgan@hotmail.com6020 SUNSET BOULEVARDDallasTX75225GRP-0765MEDICARE-ADV-A
ENR ENR-1204162026-05-24T20:32:00ZARTHURAWHITE19880407··UHC-10188-33•••-••-8033UNKNOWN—2059 Main Street·Austintx78772GRP-0994SELECT-EPO
ENRENR-1270972026-09-22T00:16:59Zbarbara—fielsMar 7, 2004UHC-16430-39•••-••-2119(318) 319-6559null5933 Oak StGlendaleAZnullGRP-5139··OPTIONS-PPO
ENRENR-1089952026-01-31T06:43:31ZANAD.GIBSON1998-12-05UHC-12515-95N/A(581) 739-4555·null985 Highland AvenueMesaArizona85272GRP-5852MEDICARE-ADV-A
ENRENR-1224632026-08-03T09:26:19ZLauren—Simpson1998-09-17·UHC-92848-17•••-••-4752(360) 751-0966LAUREN.SIMPSON27@AOL.COM6552 Maple AveGlendale·AZ85354GRP-7197··CORE-HMO
ENRENR-1402852026-02-16T05:53:36Z·Sims, HiroshiY—Oct 22, 1972UHC-85479-92•••-••-4506835-279-8010HIROSHI.SIMS92@YAHOO.COM·393 Lincoln WayFresnoCA93766-0477GRP-5047SELECT-EPO
ENRENR-1038662026-04-22T20:36:08ZRebecca—Fuller1984-01-12UHC-74098-79•••-••-1473969-463-9040-6752 OCEAN AVENUEAustinTX78770GRP-0261··OPTIONS-PPO
ENRENR-1102792026-07-03T04:21:31Zken—austin19480916UHC-51251-30•••-••-2959531-524-2344KENNETH.AUSTIN@AOL.COM4707 PALM DRColumbusOH43278GRP-0248MEDICARE-ADV-B
ENRENR-1133342026-03-06T16:04:55ZFisher, MeiK.—·2004-09-05UHC-50798-14-15663907234mei.fisher26@outlook.com4419 Highland AveNashvilleTN37253GRP-4321NAVIGATE-HMO
ENRENR-1185402026-01-04T07:54:14ZDennis—Contreras19980827UHC-23357-72•••-••-20762344197421dennis.contreras@proton.me1344 MOUNTAIN VIEW DROrlandoFL32830GRP-0356CORE-HMO
ENRENR-1354182026-02-25T04:04:40ZADAMHMENDOZA···1956-02-27UHC-49778-06•••-••-4917823-822-5670·adam.mendoza97@gmail.com925 Oak StreetChandlerAZ85291GRP-4406MEDICARE-ADV-B
ENRENR-1227172026-07-13T13:29:11ZJoseph—Hnut03/13/06UHC-58837-70•••-••-2489(238) 633-7287JOSEPH.HUNT46@YAHOO.COM3924 Harbor BoulevardMiami··FL33165GRP-4735CHOICE-PLUS-PPO
ENRENR-1389812026-06-22T10:28:44ZsamanthaH.armstrongnullUHC4684918-4226324549—6687 ELM STDenverCO80297GRP-8963NAVIGATE-HMO
ENRENR-1231762026-08-31T09:58:13ZAngelaP··Hamilton19600908UHC-96995-64NULL—angela.hamilton@outlook.com1326 Valley View Drive Apt 31HoustonTX77096GRP-3389SELECT-EPO
ENRENR-1090252026-01-24T02:05:58ZBillyR.Snyder1978-01-13UHC-23903-96•••-••-85444394802097billy.snyder71@proton.me··6889 Church StreetSCOTTSDALE·AZ85215GRP-5655CHOICE-PLUS-PPO
ENRENR-1269832026-09-23T15:08:37ZBilly·CChapman1976-03-28UHC-39604-11UNKNOWN·+1 628 874 0578·UNKNOWN1773 WASHINGTON STREETSAN DIEGOCA92178·GRP-2615CORE-HMO
ENRENR-1275932026-01-25T02:45:33ZMargaret—Dean2000-06-07UHC-39451-79•••-••-5664514-961-1106margaret.dean@hotmail.com2873 MAPLE AVENUETampaFL··N/AGRP-7660MEDICARE-ADV-B
ENRENR-1342152026-03-25T00:49:03ZKAYLAW.··ROMERO1967-40-17UHC-78382-39•••-••-5752446-207-1248KAYLA.ROMERO40@ICLOUD.COM·6231 Baseline RdDallasTX····GRP-2428SELECT-EPO
ENR ENR-1378862026-04-24T04:48:08Z Robert—Williams1948-12-23UHC-57705-43•••-••-318316056654824UNKNOWN3766 Grand AveFresnoCA93795GRP-6956CHOICE-PLUS-PPO
ENRENR-1325382026-07-29T13:46:13ZPAUL····HUDSONOct 28, 1950UHC-04211-74··•••-••-7384790.922.1087paul.hudson@hotmail.com928 Lake View RdMesa··AZ85239·GRP-0232OPTIONS-PPO
ENRENR-1114062026-02-17T09:06:47ZLAURENVWEBERAug 19, 1976UHC-10306-09NULL·NULLLAUREN.WEBER81@YAHOO.COM4452 FOREST AVEMiamiFL33151GRP-4838MEDICARE-ADV-B
ENRENR-1021082026-07-03T00:37:36Z JOAN—HUNT04-01-1981UHC-64585-07•••-••-1524912-967-7382JOAN.HUNT21@ICLOUD.COM4579 Central AveTAMPA··FL33617GRP-0101SELECT-EPO
ENRENR-1157092026-05-07T02:08:53ZRamirez, LawrenceQ.—1998-06-26UHC-12458-11·N/A558-691-7924lawrence.ramirez3@aol.com5181 DESERT SKY BOULEVARDScottsdale··AZ··85268-0782GRP-0503NAVIGATE-HMO
ENRENR-1153642026-03-13T06:07:32ZjuliaY.··weber—UHC-09690-48•••-••-1986248.484.8500N/A8937 Palm Drive·SeattleWA98139·GRP-9036CORE-HMO
ENRENR-1213132026-03-06T03:34:31Z AndrewMYang19-03-2000UHC-45898-29•••-••-9870+1 325 656 2862andrew.yang@aol.com7246 Sage CourtSan AntonioTX78225GRP-1846·CHOICE-PLUS-PPO
ENR ENR-1353782026-06-04T15:39:45Z·LUCIAA.ROSS1995-11-07UHC9126241•••-••-7621208-819-6179··NULL1906 SPRING STCharlottenc28289GRP-1204MEDICARE-ADV-A
43,101 rows, page 219 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.596Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty