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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1107182026-09-20T20:12:46ZKateQBurns1964-03-26·UHC-65348-53•••-••-02054707659424—6722 Grand AveSeattleWA98103GRP-7709SELECT-EPO
TPATPA-541762026-10-16T13:59:17Zryan—evans2/7/1974N/A•••-••-9491—-null-——GRP-2487UNKNOWN
ENRENR-142210 2026-10-13T01:34:14ZWarren, Alan——1946-09-10UHC-64777-94•••-••-9001321.340.3999—7316 Valley View DrCHANDLERAZ85285GRP-0694MEDICARE-ADV-B
ENRENR-1424462026-04-20T20:40:23ZAllen, Ruth——1988-12-07UHC2295087—N/Aruth.allen@hotmail.com4663 Oak StHoustonTX77017GRP-7968CORE-HMO
ENRENR-1070082026-07-04T07:50:43ZVICTORIA····LAWSON1999-08-01··UHC-84803-60•••-••-0536+1 487 656 2336··UNKNOWN7779 CENTRAL AVENUE··AustinTX··78723GRP-8678CHOICE-PLUS-PPO
ENRENR-1157592026-04-30T09:18:05ZMariaAWoods1969-06-16UHC-43006-38··•••-••-1461nullmaria.woods12@aol.com1048 Forest AveDENVERco80204GRP-2906MEDICARE-ADV-B
ENRENR-1009792026-05-13T04:56:03ZwayneUduncan1946-04-15UHC-81346-56•••-••-4895+1 366 358 9837·WAYNE.DUNCAN@AOL.COM7593 Market StreetMesaaz85293GRP-0967MEDICARE-ADV-B
CLMCLM-4299662026-05-25T08:42:25ZJulia L—Boyd1948-03-02UHC-64928-95•••-••-5479·19887337836—4048 Union StDallasTX75264GRP-0555CORE-HMO
PRVPRV-230202026-05-10T08:25:55Z·OliviaLRuiz08-03-1979··———·olivia.ruiz@icloud.com4821 Market StAustinTX78765—-
TPA TPA-524442026-05-06T23:38:23ZMaria—Nguyen02-04-2003—•••-••-2381·N/Amaria.nguyen@gmail.com4081 Willow CtPhoenixAZ85030—NULL
ENRENR-1143032026-02-04T19:32:23Zjoseph—watkins—UHC-68165-43•••-••-4783483-980-7908joseph.watkins@yahoo.com8272 SUNSET BLVDCharlotte·NC28277GRP-2378MEDICARE-ADV-A
ENRENR-1044072026-03-23T07:54:36ZJudith—·Pena7/1/1942UHC-33351-65•••-••-09063577501573JUDITH.PENA58@YAHOO.COM495 Willow CtGLENDALE·AZ·85335GRP-2281MEDICARE-ADV-A··
CLMCLM-4157412026-08-28T15:35:19ZJNATHAN···LI1953-03-23-———5572 Mesa DriveCharlotteNC28206··GRP-5090OPTIONS-PPO
ENRENR-1225982026-05-06T07:42:16ZSantiagoM.Ferguson1970-12-15··UHC-71174-76•••-••-3066+1 646 683 3057··SANTIAGO.FERGUSON36@AOL.COM2728 HILLCREST RDFRESNOCAUNKNOWNGRP-5539·SELECT-EPO
CLMCLM-4062252026-10-10T17:08:59ZArthurMThompson09/20/41·UHC-87768-94—7646388935UNKNOWN4865 Elm StreetAtlantaGA·30373-9670NULL····
CLMCLM-4192892026-03-29T18:16:42ZTheresa—Carroll2008-02-25UHC-53618-98•••-••-0228(630) 326-9239NULL-UNKNOWN—NULLGRP-6398null
ENRENR-1240222026-09-10T09:12:55ZJeffrey—Garrett01/04/1938UHC-19175-98•••-••-8693—jeffrey.garrett76@proton.me1295 SAGE CTChandlerAZ85250GRP-3536SELECT-EPO
TPATPA-575292026-06-20T17:40:54ZBrian····Gutierrez1995-03-11—··15662238308brian.gutierrez@aol.com2323 River RdPhoenixAZ85080GRP-5123—
PRVPRV-237002026-09-14T20:42:45ZSantiago—Wong1969-01-19UNKNOWNnull6855242033santiago.wong@yahoo.com·-null···UNKNOWNUNKNOWNUNKNOWN·N/A
CLMCLM-4096432026-04-25T22:24:13ZGERALD—NICHOLS·1956-12-02—•••-••-0336(225) 272-2408··N/A592 BroadwayLos AngelesCA90092-5227——
PRVPRV-280732026-08-29T16:04:34Z Owens, Mariana——1998-06-24N/Anull519-898-1877mariana.owens@aol.com6172 Ocean AveOrlandoFL32836—N/A
CLMCLM-4251912026-04-24T10:22:19ZWells, Bradley··——1980-12-02··UHC-44434-27··•••-••-9784N/A··UNKNOWN1813 Elm StJacksonvilleFL32280—·NAVIGATE-HMO
ENRENR-1044002026-09-23T13:24:14ZVazquez, Heather——1997-06-06·UHC-76189-52•••-••-7352—HEATHER.VAZQUEZ66@AOL.COM2802 PARK PLSan AntonioTX78238GRP-2992MEDICARE-ADV-A
PRV PRV-264462026-04-25T12:58:38ZMARIA—DELGADO3/2/1987UHC-94171-32•••-••-4918336-818-1307·NULL5393 Grand AvenueLos AngelesCA90026—NULL
ENRENR-1352952026-05-26T10:08:10ZChristopher—Carpenter1969-05-10UHC-61694-01•••-••-772818997561401CHRISTOPHER.CARPENTER62@PROTON.ME1372 Grand AvenueMinneapolisMN·55475·GRP-9161NAVIGATE-HMO
CLMCLM-4270842026-07-23T18:40:24ZSarah—Garcia1948-11-24null•••-••-3313NULL—4211 Market St·Eden PrairiemnNULLnullCHOICE-PLUS-PPO
CLMCLM-4250612026-10-02T04:30:23Z Ashley—Carr1959-05-18UHC-40523-42—911.871.7429—1946 Meadow LnJacksonvillefl32253GRP-7402SELECT-EPO
ENRENR-1169362026-04-19T10:37:34ZTYLERJBARNES02-09-1950UHC-07520-05N/A18109063689tyler.barnes54@outlook.com2150 INDIAN SCHOOL ROADSeattleWA98177GRP-3205CHOICE-PLUS-PPO
PRVPRV-270662026-06-19T05:26:40ZCHRIS—PHILLIPS2005-12-25·UHC-57380-52null——5907 Ridge RoadPhoenixAZ85060NULL·-
CLMCLM-4110602026-07-26T19:38:54ZFatima—Collins19991224··UHC-63611-25•••-••-4377——9073 Lincoln WayDenverCO—GRP-2026NAVIGATE-HMO
CLMCLM-4083032026-05-18T02:47:59ZWebb, KaylaG—1975-12-06-•••-••-1196NULLkayla.webb@icloud.com8894 BROADWAYGILBERTAZ85280—MEDICARE-ADV-B
ENRENR-1235162026-01-12T15:28:47ZDouglas··Jenkins1981-12-13UHC-58420-34•••-••-4035(939) 746-1990DOUGLAS.JENKINS94@HOTMAIL.COM7972 Camelback Road·ColumbusOH43250GRP-3382MEDICARE-ADV-A··
ENRENR-1023102026-06-19T19:36:21ZKennethRMarshall2003-03-20UHC-85421-07•••-••-543116645396274kenneth.marshall77@icloud.com··7655 Camelback Rd·Las VegasNV-GRP-5332SELECT-EPO··
TPATPA-558832026-01-02T20:28:05ZPatrick····Jordan1964-07-10—N/A5423530470N/A9666 BROADWAYGlendaleAZ85340null—
ENRENR-1021912026-01-23T11:05:11ZAlexis····Little07/16/84UHC-97948-59•••-••-2132700.519.1828··—3461 Baseline Road #710ChandlerAZ85260GRP-9549SELECT-EPO
ENRENR-1362452026-09-05T02:41:42ZRaymondL.Phillips1/28/1995UHC-34319-11•••-••-6557(403) 734-1297NULL1479 Baseline Rd··GlendaleAZ85314GRP-7940·CHOICE-PLUS-PPO
TPATPA-583132026-03-02T20:02:12ZSean—Reynolds·1989-10-25UNKNOWN····578.288.1671—7232 Broadway Apt 17··CharlotteNorth Carolina28298GRP-2540—
ENRENR-1040712026-06-14T13:04:51ZSamantha—Vazquez19720108UHC-23134-85•••-••-9908(934) 893-0838—9424 Highland AvenueGlendaleAZ85312GRP-9749CORE-HMO
CLMCLM-4295032026-04-24T11:15:26ZSue—Boyd1977-11-01UHC-70334-03UNKNOWN8508805075-————-—
ENRENR-1178142026-08-19T09:48:48ZNatalieQBell2005-03-27UHC-15700-52•••-••-5995—natalie.bell87@yahoo.com2327 Highland AvenueSacramentoca··—GRP-2900··CHOICE-PLUS-PPO
ENRENR-1046242026-06-18T04:19:50ZShaw, Kelly··N··19941210UHC-70062-36•••-••-54086076675610KELLY.SHAW91@OUTLOOK.COM7662 Lake View RdChandlerAZ85265GRP-1623CORE-HMO
TPATPA-572292026-02-02T06:06:31ZSantos, Raymond——02/12/1959—-(894) 610-0025NULL1830 Spring Street·AtlantaGA30311——
ENRENR-1110812026-01-18T10:30:38ZHenderson, AnthonyE—1989-01-09UHC9293547UNKNOWN(226) 227-0341ANTHONY.HENDERSON14@GMAIL.COM3140 Central AvenueTucsonAZ85701GRP-2465NAVIGATE-HMO
ENRENR-1180012026-04-13T19:29:17ZMark—Butler11/12/81UHC-21957-53•••-••-2218UNKNOWNmark.butler@yahoo.com·6042 River RdColumbusOH43275GRP-8401MEDICARE-ADV-A
CLMCLM-4107452026-07-18T18:07:00ZJoan, VegaP—1975-02-05—•••-••-8963745-997-1291NULL2744 Market StreetGlendale·AZ85331-8059-—
ENRENR-1029422026-02-01T01:46:14ZEspinoza, AmberP—1948-01-22UHC-65231-24•••-••-09467003070359amber.espinoza@icloud.com·1009 Mountain View DriveLOS ANGELESCA90062GRP-2881NAVIGATE-HMO
ENRENR-1390682026-03-17T02:02:06ZSandraGHart···1957-12-16UHC-88610-44•••-••-00818397903·sandra.hart@hotmail.com9810 JEFFERSON AVESAN DIEGOCA92119GRP-6806SELECT-EPO
ENRENR-1009002026-06-20T08:39:24ZWalker, Sean——1942-01-28UHC-66374-17•••-••-356519216832371SEAN.WALKER68@HOTMAIL.COM329 Jefferson AveTucsonAZ85784GRP-9607OPTIONS-PPO
ENRENR-1100052026-06-18T12:18:48ZGregory—Wagner1987-12-28UHC-51627-22•••-••-7771(941) 838-3423gregory.wagner82@icloud.com6925 BroadwayMIAMIFlorida33105GRP-0528OPTIONS-PPO
ENRENR-1267992026-04-12T01:49:43ZPatrickL.Chavez09/23/1957UHC-06289-61NULL414-681-3859PATRICK.CHAVEZ@HOTMAIL.COM6009 BASELINE ROADDenverCO80283GRP-7985CORE-HMO
100,000 rows, page 253 of 2,000PreviousNext

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.751Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty