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-1223342026-04-06T18:54:01ZETHAN—GREEN1966-09-18UHC-13997-72-·(328) 747-4285ETHAN.GREEN29@OUTLOOK.COM6482 Lake View RdLas VegasNV89100-5031GRP-9769·medicare-adv-b
ENRENR-111999 2026-07-16T14:42:21Zomar—·carter1940-09-08·UHC-59754-70null18698924762OMAR.CARTER@AOL.COM6152 Camelback RoadSeattleWA98188-6955GRP-7380SELECT-EPO
ENRENR-1048242026-10-10T22:27:21ZedwardIross06/16/07··UHC-62595-15•••-••-4022224-849-3785edward.ross@aol.com7706 Forest AveLas VegasNV89113··GRP-3245OPTIONS-PPO
ENRENR-1241262026-04-05T21:40:12ZmadisonPwatson·2001-01-27UHC-15705-43•••-••-8182(494) 542-9925N/A3991 Pine DrivePhoenixAZ85037·GRP-8038SELECT-EPO
ENRENR-1123272026-04-20T17:47:59ZKENNETH—WILLIS2004-05-12UHC3844423•••-••-2889834.825.4012KENNETH.WILLIS95@YAHOO.COM5161 Cedar LaneSeattleWA98174GRP-3820SELECT-EPO
ENRENR-1163582026-03-19T14:58:59ZJoshua—·Hughes03/25/1955UHC-99643-14•••-••-23452894041816JOSHUA.HUGHES44@YAHOO.COM8245 Spring StreetPhoenixAZNULL·GRP-0196MEDICARE-ADV-A
ENRENR-1193582026-03-17T16:56:50Zemily—·matthews·03/01/69UHC-29986-98•••-••-0838+1 881 475 8885emily.matthews@aol.com7506 Indian School RdHoustontx77060GRP-6885MEDICARE-ADV-A
ENRENR-124436 2026-09-19T22:40:55ZRuth—Watson1963-01-03UHC-13000-42•••-••-6274446-897-4507ruth.watson@yahoo.com··2307 Sunset BlvdJacksonvilleFL32283GRP-3519MEDICARE-ADV-A
ENRENR-1008932026-04-20T03:57:50ZJim—Sanchez1973-08-04UHC-39549-35•••-••-9741924-459-0473null4392 Union St·NashvilleTN37274GRP-6548NAVIGATE-HMO
ENRENR-1430822026-07-18T03:45:38Z Brittany—Reyes01/21/1949···UHC-87647-23•••-••-6279·501-317-1028·UNKNOWN7712 Highland AvenueEden PrairieMN55373-4405GRP-9157core-hmo
ENRENR-1406912026-03-18T22:37:37ZJerryS.Smith10/10/2007UHC-25615-56•••-••-93886989411027jerry.smith@outlook.com5095 Apache BoulevardJACKSONVILLEFL32278GRP-1112···SELECT-EPO
ENRENR-1239252026-02-23T10:23:18ZKeith—Smith1977-06-17UHC2100267•••-••-858818836321756keith.smith89@yahoo.com9690 Pine DrJacksonville··FL32293GRP-5953options-ppo
ENRENR-1179592026-10-11T15:20:59Zarthur—richards1984-05-11UHC-97857-60•••-••-92677368430arthur.richards@outlook.com··4040 Baseline RoadLos AngelesCA90045GRP-1516MEDICARE-ADV-A
ENRENR-1121232026-10-13T13:00:09ZRICHARDT.MENDEZ1960-12-03UHC-15987-92•••-••-42937587854571richard.mendez@outlook.com2643 DESERT SKY BOULEVARDGilbertAZ85235GRP-6632NAVIGATE-HMO
ENRENR-1302812026-10-08T10:09:37ZJoeT.Evans1990-04-03UHC-00526-36•••-••-99187628137425joe.evans@hotmail.com3468 Pine DrChandlerAZ85285GRP-7506CORE-HMO
ENRENR-1006562026-02-20T07:25:35ZRaymond··YThomas1948-12-06UHC0932920··•••-••-7371—null9463 Bayshore DriveTampaFL33691GRP-3532SELECT-EPO
ENRENR-1320312026-04-24T07:36:24Z·Janice····Jenkins06/24/69UHC-96552-58•••-••-01364122416069janice.jenkins2@icloud.com2385 PALM DRIVEAustinTX··78749GRP-7325CHOICE-PLUS-PPO
ENRENR-1121212026-07-09T11:40:41ZBrandonQLane·1947-09-08UHC-57423-75•••-••-6335964-924-6918BRANDON.LANE99@HOTMAIL.COM581 Lincoln Way·ChandlerAZ·85219GRP-9879CORE-HMO
ENRENR-1215452026-02-10T14:33:41ZDENISEOHAYES19910412··UHC-10849-04•••-••-7409(832) 596-7288null·3573 River RoadHoustonTX77034GRP-2855NAVIGATE-HMO
ENRENR-1125842026-05-10T13:19:51ZDanielELynchMay 17, 2001UHC5966842NULL(322) 550-7904DANIEL.LYNCH5@OUTLOOK.COM2820 Valley View DriveMesaAZ85224-4127GRP-5643OPTIONS-PPO
ENRENR-1075792026-08-05T03:58:20ZPeterVMendoza1959-08-05UHC-10519-63··•••-••-8283-··peter.mendoza9@icloud.com4978 Valley View DrAustin··TX78766GRP-3606NAVIGATE-HMO
ENRENR-1329932026-10-05T09:19:50ZSTEPHANIE·JWAGNER09/22/1966·UHC-41796-51•••-••-7820+1 365 696 3373STEPHANIE.WAGNER74@HOTMAIL.COM7721 River RoadGilbertAZ85205GRP-9630MEDICARE-ADV-A
ENRENR-1016252026-07-24T00:32:27ZRyanQLarson2/19/2008UHC-65901-95··•••-••-1355(244) 257-8923RYAN.LARSON82@PROTON.ME4894 BASELINE ROADDallasTX75238GRP-7518·MEDICARE-ADV-B
ENRENR-1418922026-01-24T10:24:03ZCruz, MichelleK.··1975-05-02UHC-29430-75•••-••-7221-michelle.cruz@hotmail.com6540 HARBOR BOULEVARDTampaFlorida33691-9107GRP-5663OPTIONS-PPO
ENRENR-1097462026-02-11T01:17:22ZCYNTHYA—WARDJul 16, 1969·UHC-59138-15•••-••-4942-—3700 Hillcrest RoadCharlotteNC28226GRP-2241CORE-HMO··
ENRENR-1086762026-05-18T19:31:38ZJEFFREYJ.JOHNSTONJan 26, 1959UHC-07848-72•••-••-849714646242219jeffrey.johnston89@outlook.com7404 Sunset BlvdAtlantaGA30336GRP-5101SELECT-EPO
ENRENR-1190982026-03-02T07:29:42ZArjun—Chavez1942-10-20·UHC-38523-83•••-••-2408963-680-3346—7988 JEFFERSON AVENUEGlendaleAZ85344GRP-4918CHOICE-PLUS-PPO
ENRENR-1261782026-08-19T10:57:01ZSanitagoV.Franklin08-12-1961UHC-54865-20•••-••-94755529835724santiago.franklin@aol.com8471 Cedar LnScottsdaleAZ85223·GRP-1892NAVIGATE-HMO
ENRENR-1081002026-01-07T02:35:51ZRussell—Snyder2008-11-25uhc-15807-16•••-••-1331221-625-5599russell.snyder87@icloud.com6299 RIDGE RDPhoenixAZ85072GRP-8988CORE-HMO
ENR ENR-1165262026-03-17T20:32:29ZANTHONY—HARRISON1983-09-08··UHC-10947-62•••-••-0821320.839.4348anthony.harrison60@outlook.com·5047 Canyon RdLas VegasNevada89172GRP-5789OPTIONS-PPO
ENRENR-1263452026-04-05T12:16:10ZCastro, Chris——2002-40-23UHC-49384-67•••-••-911212503808591christopher.castro95@aol.com5106 Ridge Road··TucsonArizona85732GRP-2010MEDICARE-ADV-A
ENRENR-127150 2026-02-08T09:10:52ZgraceFnunez1978-02-13UHC-46022-88•••-••-55953572996240grace.nunez14@yahoo.com7396 Forest AveNashvilleTN·37265GRP-9331CHOICE-PLUS-PPO
ENRENR-1046702026-07-08T13:28:07ZKEVIN—STEVENS·11/12/1947UHC-74291-02N/A(823) 790-1554··kevin.stevens@hotmail.com2398 River RoadSAN ANTONIOTX78255GRP-3092CHOICE-PLUS-PPO
ENRENR-1241282026-01-25T18:31:44ZFrankAPhillpis04/13/1966UHC-90331-76•••-••-3984··frank.phillips42@aol.com614 Valley View DrMIAMIFL·NULLGRP-9744··MEDICARE-ADV-B
ENRENR-1205422026-08-07T14:38:42ZFrank N—Bishop9/21/1987UHC-33994-11•••-••-987313086636932NULL5597 Willow Ct··Las VegasNV89124-3724GRP-2476navigate-hmo
ENRENR-1185812026-07-11T10:48:17ZJesseOSandoval2002-08-27UHC-20843-47•••-••-8369nullJESSE.SANDOVAL9@ICLOUD.COM2419 SPRING STREETAustinTX78770GRP-9036OPTIONS-PPO··
ENRENR-1092322026-03-28T16:25:24Z Brenda—Wells1997-08-04UHC-29827-19•••-••-4167+1 366 777 3249BRENDA.WELLS61@OUTLOOK.COM3625 Willow CourtScottsdaleArizona85213-1441GRP-7170SELECT-EPO
ENRENR-1096702026-09-27T23:44:34ZJackRKelly1984-08-10UHC7297102•••-••-80103582369506jack.kelly39@gmail.com8029 Willow CtSan AntonioTX78230GRP-7746choice-plus-ppo
ENRENR-1293362026-05-09T00:18:22ZJOYCEJ.GUTIERREZ05/03/1982-•••-••-5182320.744.6204UNKNOWN1976 Sunset BoulevardScottsdaleArizona85270GRP-1409CORE-HMO
ENRENR-1301862026-02-13T00:03:01ZJudyU.·Goordon01-11-1970UHC4221938•••-••-830914996647707—6485 Market StSan AntonioTX78232GRP-4887··OPTIONS-PPO
ENRENR-1324152026-03-12T19:28:28Z KAREN—PEREZ1993-01-22UHC7140838•••-••-5297+1 458 526 0815karen.perez82@yahoo.com5839 BROADWAYTucsonAZ85776GRP-1815NAVIGATE-HMO··
ENRENR-1239502026-04-23T22:59:59ZContreras, Henry—····19850316UHC-88378-45•••-••-9683(240) 362-2110henry.contreras39@proton.me7384 Cedar LnHoustonTX77096-5951GRP-8808CHOICE-PLUS-PPO
ENRENR-1006972026-01-12T14:25:57ZLisa··V.Griffin06/14/1956UHC-92306-14•••-••-0629(754) 934-4258LISA.GRIFFIN@GMAIL.COM7485 BroadwayHoustonTX77065···GRP-5259MEDICARE-ADV-A
ENRENR-1171092026-03-08T13:53:21ZParker, KathrynD.—1994-07-03UHC-47778-08•••-••-4371(734) 753-9247kathryn.parker49@hotmail.com3558 CENTRAL AVEMINNEAPOLISMN55434GRP-6870··CORE-HMO
ENRENR-136209 2026-04-10T07:11:01Z·Matthew—Walker1971-05-21UHC-70116-01•••-••-8108815-785-9880matthew.walker@outlook.com8815 HARBOR BOULEVARDMINNEAPOLISMN55477GRP-0822SELECT-EPO
ENRENR-1251452026-02-10T09:01:57ZWeiD··Dunn1939-03-08uhc-66942-45•••-••-17253679597-1020 Oak StGlendaleAZNULLGRP-5378CORE-HMO
ENRENR-1018072026-01-14T02:27:34ZMark··Gomez19601209UHC-95727-77•••-••-9505513-870-0456MARK.GOMEZ53@HOTMAIL.COM1934 MARKET STHoustonTX77044GRP-6873CHOICE-PLUS-PPO
ENRENR-1235602026-04-07T13:05:31ZALEXISQRUSSELL1993-02-09UHC-14976-82•••-••-9295827-230-0623··447 Sunset BoulevardSeattleWA98195GRP-1015··MEDICARE-ADV-B
ENRENR-1029272026-09-30T05:47:23Z·Olivia—Hart10/26/1976UHC-78547-45—8372853olivia.hart@gmail.com9622 Highland AvenueHoustonTX77017GRP-4243MEDICARE-ADV-B
ENRENR-1304962026-06-27T22:52:22ZCarol—Ross10/13/45UHC-09181-59•••-••-2752434-856-6004carol.ross@hotmail.com4820 Cedar Ln·TucsonAZ85724··GRP-5140SELECT-EPO
43,101 rows, page 221 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.599Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty