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-1399312026-06-04T03:35:45ZKyleZLe20801024UHC-49171-75•••-••-1986UNKNOWN-3289 Church StreetEDEN PRAIRIE·MN55370-4112GRP-2950CHOICE-PLUS-PPO
ENRENR-1387172026-03-10T15:35:21ZALEXANDERT.BELL··1997-08-11UHC-79353-51•••-••-6384·6796961131alexander.bell@gmail.com5591 LAKE VIEW ROADAUSTINTX78745GRP-1286CHOICE-PLUS-PPO
ENRENR-1403262026-05-17T09:05:08ZAhmedACooper3/8/1942UHC-91936-31•••-••-24497284113ahmed.cooper62@icloud.com8482 Valley View DrLos AngelesCA90028GRP-3768SELECT-EPO··
ENRENR-101295 2026-02-27T07:53:35ZAMBERN.GREENEMay 19, 1942UHC-79174-43··•••-••-9909248-463-1948amber.greene53@aol.com7738 Market StreetDenverCO80286GRP-9719MEDICARE-ADV-B
ENRENR-1094272026-04-27T00:47:10ZLuisGGrant25-08-1973··UHC-16519-27—(798) 785-7678—192 Forest AvenueEDEN PRAIRIE·MN55358-4447GRP-7747CORE-HMO
ENRENR-1354292026-05-11T13:48:07ZSARAPBOYD1973-05-27UHC-43557-07•••-••-0126602-643-2000SARA.BOYD20@PROTON.ME5882 Apache Blvd··ChandlerAZ85257GRP-4881CORE-HMO
ENRENR-1134982026-02-06T18:15:23ZOMARV.ESTRADA19560713UHC-36670-64•••-••-4209(368) 810-3781··omar.estrada22@gmail.com5347 Sunset BlvdMinneapolisMN55405GRP-3803NAVIGATE-HMO
ENRENR-1277902026-07-21T18:57:34Zkaren—spencer19510918UHC-15553-53•••-••-6793596.902.4780KAREN.SPENCER@OUTLOOK.COM5445 OAK STREETDallasTX75205GRP-8721MEDICARE-ADV-B
ENRENR-1165052026-01-08T15:03:53ZMARCUS—DEAN1975-08-02UHC-62627-71•••-••-8808976-619-4722·marcus.dean@gmail.com8043 MOUNTAIN VIEW DRIVEDenverCO80238GRP-0827SELECT-EPO
ENRENR-1053272026-03-13T22:11:59ZKimberly··Ryan1985-08-02UHC-27971-98•••-••-6721(419) 348-5247kimberly.ryan@gmail.com··1172 Elm StreetCHARLOTTENC28207GRP-9635CHOICE-PLUS-PPO
ENRENR-136561 2026-03-25T01:41:38ZCHARLOTTE B—RILEY2007-01-23UHC9262492N/A6864994338·CHARLOTTE.RILEY74@YAHOO.COM355 VALLEY VIEW DRTucsonAZ85782-5897GRP-9621NAVIGATE-HMO
ENRENR-1079352026-03-05T00:10:21ZStephanieO·Ramirez1958-04-20UHC-11118-07··•••-••-3495988.591.3226stephanie.ramirez@proton.me8849 Lincoln WayGilbert··AZ85277GRP-7643MEDICARE-ADV-A··
ENRENR-1235932026-02-23T07:31:37ZLarry—Rogers1970-02-10UHC-32272-09•••-••-06314189493983LARRY.ROGERS@PROTON.ME··7957 Highland Ave·Eden PrairieMinnesota55349·GRP-2171MEDICARE-ADV-A
ENRENR-1113272026-08-10T08:58:11ZMasonEHarris05/11/1972UHC2193672•••-••-97344846329063··9568 Canyon RoadAtlantaGA30392GRP-4899OPTIONS-PPO
ENRENR-1388872026-04-07T19:42:58ZScott—Mason1974-04-01UHC-40347-24•••-••-9396468-318-4879····6312 Grand AvenueColumbusOH43228GRP-4747CORE-HMO
ENRENR-1296092026-04-27T14:11:25ZBOBBYHFREEMAN1945-03-23UHC-82432-95··+1 315 325 3407—8006 Indian School Rd··Eden PrairieMinnesota55361GRP-5686·SELECT-EPO
ENRENR-1420332026-04-17T01:53:24ZSARA—SPENCERAug 11, 1992UHC-86653-96•••-••-36628749584··sara.spencer66@yahoo.com4028 Oak St #476NashvilleTN37290GRP-9034CORE-HMO
ENRENR-1299812026-01-24T06:15:02ZDeniseBStone1945-03-04UHC-23922-86•••-••-4736(852) 233-9517denise.stone@yahoo.com4799 WASHINGTON STNASHVILLETN37223GRP-2953CORE-HMO
ENRENR-1016942026-08-07T10:43:31ZAguilar, JudithZ—1940-03-28UHC-01588-51•••-••-1117208-290-0874JUDITH.AGUILAR@AOL.COM4131 Mesa DriveScottsdaleAZ85272GRP-4448··MEDICARE-ADV-B
ENRENR-1111012026-10-13T03:00:19Zzachary··Eweber01/21/1945UHC-61312-95•••-••-85474636411510N/A1671 Elm StreetMiamiFL33142GRP-9617·MEDICARE-ADV-A
ENRENR-1404932026-05-14T13:09:56ZETHAN—GILBERT16-06-1974UHC4371556•••-••-8928(459) 399-9877ETHAN.GILBERT75@GMAIL.COM5664 WASHINGTON STHOUSTONTX77078GRP-6741SELECT-EPO
ENRENR-1125742026-06-29T04:45:14ZStephanie—Henderson1999-04-19·UHC7144786•••-••-5392477-656-3789STEPHANIE.HENDERSON@ICLOUD.COM2267 SAGE CTSACRAMENTOCA95811··GRP-9686MEDICARE-ADV-B
ENRENR-1353472026-04-15T19:02:51Z JoanC.SandersNov 7, 2008···UHC-18445-56•••-••-793618307096442joan.sanders56@icloud.com3502 Forest AvenueChandler·az85239GRP-0873NAVIGATE-HMO
ENRENR-1154432026-07-01T21:35:11ZLaura·J·Jensne2003-06-19UHC-27362-06•••-••-0589762-388-9708LAURA.JENSEN54@ICLOUD.COM6137 Indian School Rd··SACRAMENTOCA95876GRP-7730SELECT-EPO
ENRENR-1174032026-10-07T22:21:34ZDENNIS—BROOKS1956-10-04uhc-34952-16··•••-••-13862699782765dennis.brooks@hotmail.com4878 Camelback RoadAustinTX78767GRP-9124OPTIONS-PPO
ENRENR-1224832026-02-02T12:32:22ZHANNAHOWILLIAMS1972-04-05UHC-24476-29•••-••-92136812021493·hannah.williams@proton.me7890 Oak StSan DiegoCA92121GRP-8891SELECT-EPO
ENRENR-1026882026-03-27T05:35:52ZTheresaX.Harper1943-02-25UHC-74940-37•••-••-018616358134116theresa.harper93@icloud.com4015 Highland AveFresnoCA93718GRP-8428OPTIONS-PPO
ENRENR-1309832026-02-05T00:25:50ZDEBORAHDHENDERSON2008-03-10UHC-53868-27—828-251-6961deborah.henderson41@aol.com2283 Grand AvenueScottsdale··AZ85238GRP-2141MEDICARE-ADV-B
ENRENR-1190312026-01-30T11:42:40ZMatthewXKelly1941-12-05UHC-89605-89NULL367-569-1046matthew.kelly89@proton.me8350 Lincoln WayGilbertAZ85281··GRP-8514··CHOICE-PLUS-PPO
ENRENR-1306762026-04-23T05:15:51ZJAMES G—SMITH··1942-08-18UHC-49345-21•••-••-12617345710297james.smith70@outlook.com3221 OAK ST·CHANDLERAZ85242GRP-7928CHOICE-PLUS-PPO
ENRENR-1128102026-02-04T20:01:49ZDianeIPerry1972-06-28UHC-44965-89•••-••-87282063760734diane.perry@proton.me5899 UNION STREETPhoenixAZ85095GRP-6166core-hmo
ENRENR-1141922026-10-14T00:03:51Zkevin—·hill19841128UHC-54389-99•••-••-5892—KEVIN.HILL14@HOTMAIL.COM5466 LINCOLN WAY··NashvilleTennessee37215GRP-0480OPTIONS-PPO
ENR ENR-1129092026-01-19T01:55:15ZFerguson, Jeremy——04/14/1959UHC-63513-38•••-••-4431412-871-2018null4716 Indian School Rd·DALLASTX75299GRP-2599CORE-HMO
ENRENR-1228402026-08-20T15:27:10Zelizabeth—gibson··1501-59-55UHC-53210-52•••-••-3301+1 333 833 1944ELIZABETH.GIBSON13@HOTMAIL.COM833 Sage CtTampaFL·33661-8992GRP-1940SELECT-EPO
ENRENR-1046172026-06-21T11:30:46ZGregoryT.Elliott16-08-1961UHC-34661-18•••-••-2129316.876.2135GREGORY.ELLIOTT57@GMAIL.COM·1131 Central AvenueAtlantaGA30332·GRP-3310OPTIONS-PPO
ENRENR-1218132026-07-28T06:24:55ZLAWRENCEJ·WILLIAMS1987-07-11UHC-68040-19•••-••-5602898.880.4967lawrence.williams@icloud.com7519 Highland AvenueMinneapolisMN55461GRP-7995MEDICARE-ADV-B
ENRENR-1096592026-03-08T10:13:36ZMelissaW.Hayes··2006-10-23UHC-64851-11•••-••-015313796977814melissa.hayes54@proton.me5383 BroadwayDallasTX75269··GRP-8159medicare-adv-b
ENRENR-1175612026-05-25T08:42:25ZKyle··Rogers1963-06-16UHC5821307NULL329.936.1596kyle.rogers12@aol.com-—UNKNOWN—GRP-3532NAVIGATE-HMO
ENRENR-1192692026-09-23T00:33:25ZKellyHKim1957-09-20UHC-11790-26•••-••-6292(942) 756-6630—7517 Main StSEATTLEWA98168GRP-0887CORE-HMO
ENR ENR-1232472026-06-25T02:35:56ZReynolds, WillieZ.—5/24/1995UHC-16629-32•••-••-2128280-361-2670willie.reynolds27@yahoo.com5688 Ridge RdCHARLOTTENC28293-8781GRP-3993OPTIONS-PPO
ENRENR-1038642026-10-07T17:49:07Z CarolynSWard2004-03-16UHC5902532•••-••-5069516-229-7629carolyn.ward6@outlook.com9472 Desert Sky BlvdChandlerAZN/AGRP-0864MEDICARE-ADV-B
ENRENR-1114802026-10-08T11:35:30ZCARLOSPLI07/08/1979uhc-60268-18•••-••-48329654796057CARLOS.LI40@HOTMAIL.COM8294 Grand AvenueJacksonvilleFL32266GRP-7399CHOICE-PLUS-PPO
ENRENR-1194252026-08-07T03:51:55Z AHMEDE.OLSON06/22/64UHC-42356-94•••-••-27318796669696ahmed.olson@hotmail.com2114 BAYSHORE DRIVESan DiegoCA—GRP-7064CHOICE-PLUS-PPO
ENRENR-1428682026-01-01T06:36:44ZRICHARDHPERRY1963-03-20·UHC-85723-78•••-••-1568(689) 505-6331richard.perry@icloud.com1196 PARK PL·AtlantaGA30302GRP-2940SELECT-EPO
ENRENR-1322272026-02-03T22:06:57ZValentina—Kennedy1943-08-06UHC-03137-73•••-••-96183525145253·N/A5500 Ocean AvenueGlendaleAZ··85369GRP-3682SELECT-EPO
ENRENR-1226752026-10-08T16:33:12ZOmarHAdams1972-10-03UHC-62737-71•••-••-09666619210110N/A8093 Canyon RoadSAN ANTONIOTX78234··GRP-2864SELECT-EPO
ENRENR-121835 2026-04-30T12:58:07ZLOGANOALVARADO07/02/97UHC-87265-64•••-••-0880828-813-9378logan.alvarado53@proton.me8314 Bayshore DrLos AngelesCA90058GRP-3493SELECT-EPO
ENRENR-1133852026-08-25T22:19:05ZLAUREN—GUTIERREZ1989-01-04UHC-74527-12•••-••-8769·854-588-2955·lauren.gutierrez@gmail.com9548 BroadwayORLANDOFL·32831GRP-1733NAVIGATE-HMO
ENRENR-1306162026-08-15T03:53:03ZBrown, HannahO.····1943-07-08UHC-97609-23•••-••-5094·(294) 811-0191—8925 Church StNashvilleTN37299GRP-2481MEDICARE-ADV-B
ENRENR-1310122026-09-11T12:12:03ZDIANE··SCHULTZ1997-10-25UHC-82582-51•••-••-2109·(866) 617-5518UNKNOWN4295 Mesa DrTAMPAFL33680GRP-2653·MEDICARE-ADV-A
43,101 rows, page 60 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:36.692Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty