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-1218162026-01-02T23:26:13ZGLORIALJENKINS01/04/1969UHC-95347-85•••-••-54404923525GLORIA.JENKINS51@OUTLOOK.COM7685 Church StreetHoustonTexas—GRP-9396CORE-HMO
ENRENR-1122722026-05-19T11:45:20ZAnna—·Thompson1973-04-05UHC-22617-58•••-••-52425069772—3663 Willow CtSacramentoCA·95859GRP-6871medicare-adv-b··
ENRENR-1113572026-07-03T01:50:44ZAlvarado, DanielA.··—03-11-1966UHC-97254-55•••-••-1899(939) 930-3761daniel.alvarado@yahoo.com4108 Hillcrest RdNASHVILLETN··37234GRP-8084MEDICARE-ADV-A
ENRENR-1299462026-01-27T13:19:26ZJuliaR.Sanchez1980-10-05UHC-69601-57•••-••-6357482-595-5888julia.sanchez24@gmail.com4300 WILLOW CTJacksonvilleFlorida··32248GRP-0493NAVIGATE-HMO
ENRENR-1256082026-05-07T16:52:46Zarjun—mejia3/4/1988UHC-51233-72•••-••-0292(338) 878-8437null5346 Maple AveTucsonAZ·85761GRP-5135NAVIGATE-HMO··
ENRENR-1358602026-04-08T20:39:09ZWAYNEDBROWN1946-04-03UHC-91030-40•••-••-2126(595) 948-6877wayne.brown@yahoo.com4147 MARKET STSacramentoCA95885GRP-9642NAVIGATE-HMO
ENRENR-1409182026-02-10T06:20:52ZJose—Ellis1964-01-01UHC-56744-12•••-••-282918406938899jose.ellis18@yahoo.com3255 Elm StMiamiFlorida33145GRP-2457CHOICE-PLUS-PPO
ENR ENR-1110092026-10-07T07:55:17ZSTEPHEN—REYES1960-07-03NULL•••-••-6531(666) 772-4835STEPHEN.REYES@PROTON.ME3796 Oak StSCOTTSDALEAZ85243GRP-1868options-ppo
ENRENR-1172612026-04-12T17:45:14Z·Chapman, Michael——1960-09-01UHC-78960-31•••-••-1413(689) 809-9082-3528 BAYSHORE DRIVETampaFL33698GRP-2570MEDICARE-ADV-B
ENRENR-1202312026-09-08T10:26:08ZMargaret··OBrien·1996-11-16UHC-43459-75•••-••-96194668406287margaret.obrien95@yahoo.com4073 MARKET STREETAtlantaGA30311GRP-8513SELECT-EPO
ENRENR-1285012026-07-10T02:08:30ZEdwardCFreemanOct 16, 1953UHC-67577-68•••-••-8930(556) 736-1739··—904 Hillcrest RoadMiamiFL—GRP-1152CHOICE-PLUS-PPO
ENRENR-1406792026-02-10T04:55:22ZCHRISTIAN—COLEMAN2001-06-07UHC-66406-19NULL(637) 822-6687NULL—---GRP-0513OPTIONS-PPO
ENRENR-1427142026-05-07T11:38:59ZAHMED··MADAMS19861116UHC-27067-82•••-••-4236894-831-5889—670 Meadow LnSan AntonioTexas··78269GRP-4766··SELECT-EPO
ENRENR-1046772026-03-07T15:53:47ZMarianaTMurray5/6/1987··UHC-33310-48•••-••-2922380-370-7840MARIANA.MURRAY32@AOL.COM9246 Park PlaceLas VegasNV89199GRP-3204SELECT-EPO
ENRENR-120752 2026-06-25T21:18:31ZRayondGPierce01/27/1964UHC-38178-68•••-••-6874(782) 968-5415UNKNOWN8367 MOUNTAIN VIEW DRIVEMiamiFL33184GRP-7240SELECT-EPO
ENRENR-1238022026-05-28T20:41:57ZMELISSA—PADILLA1977-01-17UHC-97545-77•••-••-961312992239486MELISSA.PADILLA64@OUTLOOK.COM2592 OAK STREET #207MesaAZ85231GRP-0217CHOICE-PLUS-PPO
ENRENR-1160752026-08-07T10:42:22Zwayne—boyd19600501·UHC6008889•••-••-24587789820wayne.boyd@aol.com—NULLNULL—GRP-8488MEDICARE-ADV-B
ENRENR-1288642026-08-22T10:20:50Z Sara—Williams1983-11-20UHC-47146-64•••-••-0946303-425-8929··SARA.WILLIAMS44@ICLOUD.COM5208 SUNSET BOULEVARDChandlerAZ85252GRP-0953NAVIGATE-HMO
ENRENR-1042312026-02-25T06:46:57ZTYLERIPALMER··1202-15-97UHC-12717-61•••-••-7028292-668-6026TYLER.PALMER@PROTON.MEnullnullUNKNOWNN/AGRP-0247NAVIGATE-HMO
ENRENR-1408282026-07-02T07:26:07ZchristopherIhenderson1979-03-26UHC-31623-41•••-••-1697410-343-7224N/A983 Grand AvenueATLANTA··GA·30375GRP-1775··MEDICARE-ADV-B
ENR ENR-1086032026-07-17T04:56:56ZRamirez, Charles——1979-07-08UHC-36541-43•••-••-8791·3624659394charles.ramirez@aol.com4626 Sage CtSacramentoCA95816GRP-4616NAVIGATE-HMO
ENRENR-1116472026-03-27T14:02:21ZKathleenNPaarker04/06/67UHC-59896-61•••-••-1713(314) 639-1465··—5358 Cedar Ln Apt 24MIAMIFL33151GRP-4361core-hmo
ENR ENR-1075982026-06-07T15:00:25Zdaniiel··D.roberts20051226UHC-94741-83•••-••-7336(779) 707-0570daniel.roberts73@yahoo.com631 SUNSET BOULEVARD··SacramentoCA95832GRP-3825NAVIGATE-HMO
ENRENR-1411122026-02-03T16:31:23ZEmmaNFields19840112··UHC-62616-12•••-••-3581—emma.fields@proton.me5196 CENTRAL AVEChandlerAZ85254GRP-3137medicare-adv-a
ENRENR-1209632026-06-16T21:11:37ZCAMPBELLF.NATHANJan 12, 1958UHC-46707-26•••-••-8367812.345.8389NATHAN.CAMPBELL@OUTLOOK.COM6555 Palm DrCharlotteNC28231GRP-9588OPTIONS-PPO
ENR ENR-117453 2026-09-12T14:02:26ZDianaWPerryJun 7, 1986UHC-40741-22•••-••-8717(847) 270-9172diana.perry@yahoo.com·4891 VALLEY VIEW DRPlanoTX75086GRP-8805CORE-HMO
ENRENR-1359962026-04-11T00:54:44ZJacqueline—Bennett1977-07-05UHC-63718-39•••-••-5974315.962.6158jacqueline.bennett37@outlook.com5967 Washington St·TempeAZ85271GRP-6412OPTIONS-PPO
ENRENR-1060332026-04-10T08:36:38ZELIZABETHWREED1994-09-12UHC7518850•••-••-66078916442972ELIZABETH.REED80@ICLOUD.COM9403 CEDAR LN Apt 28Seattle··WA98112-4531·GRP-6595MEDICARE-ADV-A
ENRENR-1149582026-09-07T17:59:13ZPeterPEdwards1948-09-12UHC-22840-88•••-••-6179377-431-6210NULL6925 Pine DrMESAAZ85257GRP-0935CHOICE-PLUS-PPO
ENRENR-1251392026-04-23T02:31:31ZWAYNE—LOPEZ1988-09-08UHC-44726-52•••-••-5041·484-632-6261-1771 Canyon RoadJacksonvilleFL32218GRP-3383SELECT-EPO
ENR ENR-1023542026-02-03T16:23:10ZDiaz, Bobby——1991-11-03UHC0379975NULL453-480-7806bobby.diaz@yahoo.com·1619 BroadwayEDEN PRAIRIEMN55319GRP-4003CORE-HMO
ENRENR-1005132026-03-22T18:50:59ZJacobs, Camila——·1976-08-24UHC-42463-75•••-••-64247473538814N/A850 Bayshore DriveTempeArizona85286GRP-1293CORE-HMO
ENRENR-1302242026-01-11T08:00:14ZPeterIPhillips1986-09-20UHC-99427-19•••-••-351019794996306peter.phillips26@yahoo.com1578 Oak Street··Planotx75048GRP-3295OPTIONS-PPO
ENRENR-1418582026-08-16T15:04:43ZTIMOTHY—GONZALES1992-10-25UHC-54402-04··•••-••-7093246.854.1764—6157 MARKET STREETHoustonTexas77065··GRP-4541OPTIONS-PPO
ENRENR-1331742026-03-20T07:32:57ZGarza, Patricia··Z—28-07-1984UHC-22917-70•••-••-8352623-472-1707patricia.garza16@hotmail.com9752 Maple AvenueTucsonAZ85731GRP-4183··MEDICARE-ADV-B
ENRENR-1319032026-06-26T18:55:18ZAnthnoyFPerry1958-01-20UHC9508814N/A9689826875anthony.perry37@gmail.com8888 Main StreetSan AntonioTX78221GRP-7309MEDICARE-ADV-A
ENRENR-1382292026-01-21T15:18:40ZWallace, AnnaY—1940-01-14·UHC-03491-04•••-••-1438454-203-3648anna.wallace@hotmail.com2854 SAGE CTGlendaleAZ85304GRP-9920SELECT-EPO
ENRENR-1025332026-05-16T01:20:22ZMATTHEW—CARPENTER1955-06-10UHC-33751-82•••-••-6017236-370-3581matthew.carpenter@gmail.com6282 Desert Sky BoulevardOrlandoFL··32857GRP-1420CHOICE-PLUS-PPO
ENRENR-1281672026-01-16T19:28:10ZMariana—Nguyen08/06/1945UHC2169802•••-••-9372683.699.4159mariana.nguyen@gmail.com9516 Ocean Avenue Apt 18Chandleraz85250GRP-9502OPTIONS-PPO
ENR ENR-1160352026-09-02T01:35:16ZJacqueline B.—Harris04-12-1953··UHC-77985-66•••-••-0677·-JACQUELINE.HARRIS27@HOTMAIL.COM7116 SPRING STREETGilbertAZ85284GRP-8510OPTIONS-PPO
ENRENR-140657 2026-10-14T09:57:05Zsean—brown2512-00-03UHC-14347-49—(364) 405-1614SEAN.BROWN84@OUTLOOK.COM9064 Jefferson Ave·FresnoCA93735GRP-6105SELECT-EPO
ENRENR-1122002026-02-05T06:30:00ZNICOLEOGRAHAM05/22/42UHC-66344-34•••-••-4899945-991-7254—876 Pine Drive #102CharlotteNC28240GRP-8746MEDICARE-ADV-A
ENRENR-1192422026-05-16T13:12:41ZSharonYGuzman1994-07-20UHC-16998-40•••-••-6360562-607-9599sharon.guzman26@aol.com2875 Harbor BoulevardGILBERTAZ—GRP-3627NAVIGATE-HMO
ENRENR-1227132026-03-17T18:47:18ZJohnson, BrandonJ—1909-06-21UHC-92945-93•••-••-7837(770) 980-4863BRANDON.JOHNSON49@YAHOO.COM8128 Washington StDENVERCO80289GRP-3043CHOICE-PLUS-PPO
ENRENR-1012122026-09-17T13:14:19ZJustinX.Ray1999-07-07UHC-04481-51•••-••-4770(517) 424-7377—1742 Grand AvenueAtlantaGA30316GRP-4429MEDICARE-ADV-B
ENRENR-1206742026-07-27T14:44:58Z Astin··HKennedy19960524UHC-71747-72·N/A6596026380AUSTIN.KENNEDY58@AOL.COM·9136 WILLOW CT·ATLANTAGeorgia30341GRP-2327···NAVIGATE-HMO
ENRENR-1246382026-02-19T02:25:36ZWei—Schultz1995-09-03UHC-71252-57•••-••-2663614.361.8318WEI.SCHULTZ37@YAHOO.COM7300 Grand AvenueSeattleWashington··98126-8887GRP-7857NAVIGATE-HMO
ENRENR-1277972026-07-28T15:58:19ZRoyDFowller2001-09-28UHC-26321-54•••-••-8522(459) 921-7744ROY.FOWLER99@OUTLOOK.COM6743 Apache Blvd Apt 8Austin··TX78779GRP-7259··select-epo
ENRENR-1409962026-05-19T04:28:44ZamandaErice1997-05-06UHC-50579-26•••-••-6211948-678-5631amanda.rice@proton.me··453 MOUNTAIN VIEW DRIVETempeAZ85257GRP-5748OPTIONS-PPO
ENRENR-1361662026-06-28T03:18:16ZbrianEjohnson1978-07-28UHC-62806-11N/A13842414351BRIAN.JOHNSON@OUTLOOK.COM6230 Central AveMiamiFL··33142GRP-7151medicare-adv-a··
43,101 rows, page 200 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.339Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty