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-1027742026-02-10T20:36:57ZAhmed—Gutierrez1930-85-12UHC-99150-74•••-••-1105(233) 672-1836ahmed.gutierrez@icloud.com6178 FOREST AVEColumbusOH43204GRP-7378CORE-HMO
ENRENR-1249642026-03-02T13:03:47Z SHIRLEY—·GILBERT11/20/1977UHC-22793-21•••-••-68923607114shirley.gilbert97@proton.me2554 Union StScottsdaleAZ85201GRP-2834MEDICARE-ADV-A
CLMCLM-4141482026-02-09T12:03:33ZTyler—Alvarado1993-03-01UHC-30206-42•••-••-5713692-337-2460—NULL-UNKNOWNN/AGRP-9744UNKNOWN
ENRENR-120590 2026-01-30T23:48:21ZDONNANWEAEVR1955-03-14UHC-45899-75•••-••-9029+1 648 878 5248donna.weaver@hotmail.com9791 Park PlaceAUSTIN·tx78756··GRP-5792NAVIGATE-HMO
ENRENR-1326142026-07-25T23:04:18ZJanetAHicks1953-06-15UHC-36211-77•••-••-4330·+1 381 293 5463janet.hicks3@yahoo.com40 Main StreetCOLUMBUSOhio43241GRP-0803SELECT-EPO
ENRENR-1409682026-04-09T09:14:12ZTIMOTHYJLONG2003-10-01··UHC-46380-98null2673602144timothy.long86@yahoo.com994 BroadwayGlendaleArizona85304GRP-0541OPTIONS-PPO
PRVPRV-277182026-08-25T09:38:31ZMARKMMARQUEZ1953-02-28N/A•••-••-16597106427661-3821 Ridge RdLAS VEGASNevada89133-CHOICE-PLUS-PPO
CLMCLM-4308012026-01-03T19:41:09ZMarilyn—Castillo1980-01-24UHC-80095-34—(559) 386-4702-7402 HIGHLAND AVE··ChandlerAZ85284—CORE-HMO
TPATPA-545982026-03-22T06:33:03ZNathan—Hall··1939-08-26nullNULL—NULL7748 BAYSHORE DRIVEAustinTX78735nullnull
TPATPA-640282026-09-21T08:59:18ZCHRISTINE—COOPER1963-04-27UNKNOWN-836-676-7236UNKNOWN4649 CAMELBACK ROADTAMPAFL33646GRP-5756SELECT-EPO
ENR ENR-1120862026-06-21T14:33:43ZEVELYN—AUSTIN04/15/1953UHC-82037-47•••-••-8995—UNKNOWN6261 Church StreetGilbertAZ85299·GRP-6566CORE-HMO
CLM CLM-4203882026-04-09T23:43:16ZMARYMGARRETTDec 22, 2007—•••-••-4657NULL-2645 LAKE VIEW RD #668PhoenixAZ··85018··GRP-9788·N/A
CLMCLM-4170942026-06-30T22:24:49ZAshley—Olson1984-01-07UHC-61639-29··NULL—-·--—NULLGRP-2214····
CLMCLM-4032992026-05-06T04:05:00ZDaniel—SantigoJul 24, 1998UNKNOWNNULL··—5968 PARK PLACEPhoenixAZ85028——
ENRENR-1303732026-06-25T21:08:57ZJOSED.COOK1954-04-10UHC-70225-01•••-••-89913235025275jose.cook@yahoo.com7755 Union StreetLas VegasNV89104-5967··GRP-1231··MEDICARE-ADV-A
ENRENR-1059552026-02-11T22:58:19ZTORRES—JANET1984-02-13uhc-48740-56····5929955683null4107 Bayshore DrivePhoenixAZ·85014GRP-8818OPTIONS-PPO
CLMCLM-4204622026-01-07T14:40:31ZPatrick—Valdez1950-04-27-NULL(638) 374-3885—5078 CANYON RDMinneapolisMN—GRP-8637CORE-HMO
ENRENR-1124932026-06-06T13:32:40ZOmarF.Bell5/17/1998UHC-60474-16N/A(926) 891-2558UNKNOWN9649 Camelback RdSeattleWashington·98107GRP-5227OPTIONS-PPO
CLMCLM-431878 2026-08-12T03:03:44ZJeremy—Dunncan··1977-04-20N/A•••-••-4548——3976 MOUNTAIN VIEW DRFresno··California93709GRP-5024CHOICE-PLUS-PPO
TPATPA-510622026-03-03T15:18:22ZEvelynPFisher2005-10-08UHC-52353-84-NULL—489 Highland AveSacramentoCA··95826——
TPATPA-63964 2026-03-29T08:11:26ZLAUREN—MEDINA1962-06-02NULLNULL7458414713—2179 BAYSHORE DRPhoenixAZ85086GRP-8740MEDICARE-ADV-B
ENRENR-1164182026-08-30T22:56:06ZGraceGWelch··19390417UHC-28155-26•••-••-1080·5277738860·UNKNOWN1665 Desert Sky BoulevardAtlantaGA30390GRP-8626MEDICARE-ADV-B
ENRENR-1323822026-04-09T22:44:08ZTylerT.Weber1967-02-10UHC-32985-45•••-••-9263210-569-0851tyler.weber6@hotmail.com··5659 Main StreetLas VegasNV89166GRP-6169select-epo
CLMCLM-4168272026-01-05T10:52:27ZMelissa—Daniels19980101UHC-79454-55N/AN/AUNKNOWN7050 Lincoln Way #530Los AngelesCalifornia90070GRP-6040MEDICARE-ADV-B
ENRENR-1003922026-02-03T02:53:57ZSalazar, Lori——Aug 20, 1942UHC-58817-75•••-••-3021280-919-8463··lori.salazar@aol.com9236 APACHE BLVDDallasTX75233··GRP-1577CORE-HMO··
CLMCLM-4258632026-10-07T15:11:39ZMATTHEWJSILVA07/09/61UHC-88687-40—null···9834 Indian School RdPlanoTX75013GRP-9957—
TPATPA-628352026-08-01T21:13:34ZJOE—·RICCE12-06-1994N/ANULLNULLNULL1843 Bayshore DriveTucsonAZUNKNOWN—OPTIONS-PPO··
ENRENR-1199762026-02-16T16:00:50ZAmy—Ryan2004-12-02UHC-44975-74•••-••-4994409.766.9036···6868 Harbor BlvdSCOTTSDALEAZ85294GRP-2039CORE-HMO
ENRENR-1009852026-10-07T11:04:44ZDAVID—SULLIVAN1938-12-13··UHC-18996-19•••-••-9638753.355.7924UNKNOWN7502 Union StNashvilleTN37244GRP-9693OPTIONS-PPO
ENRENR-1297352026-05-11T16:29:38ZCarter, ArjunJ—20080204UHC-69028-60•••-••-90408855956045arjun.carter@proton.me2008 Market StreetCharlotteNC28246GRP-4070··MEDICARE-ADV-B
CLM CLM-4122342026-06-13T11:06:31ZSophiaYVazquez09/24/1992UHC-24298-39•••-••-0078930-843-8446·UNKNOWN4625 INDIAN SCHOOL RDScottsdaleArizona85205GRP-2858CHOICE-PLUS-PPO
ENRENR-1131352026-05-07T16:47:23ZPhilip—Montgomery1947-11-16UHC-95197-13-19724550747philip.montgomery@outlook.com2672 Spring St·San Antoniotx78211·GRP-4618MEDICARE-ADV-B
CLMCLM-4323472026-04-17T21:37:41ZJeremy····Scott26-01-1980N/A•••-••-9730(542) 561-4232UNKNOWN·9678 Forest AvenueDallasTX·75225——
ENRENR-1338172026-09-20T05:33:49ZAlbert—Fisher·1981-06-04N/Anull(305) 976-0699albert.fisher56@outlook.com9784 Harbor Boulevard #537GilbertAZ85212GRP-9049CORE-HMO
ENRENR-1027782026-05-23T08:45:55ZMARIAJPERKINS04/22/79UHC-18060-30•••-••-10029602218858maria.perkins33@yahoo.com5752 Central AvenueAtlanta··GA30396GRP-5428CORE-HMO
PRVPRV-253692026-05-11T05:04:24ZBRIANM.MCCOY1958-07-15UHC-72352-98NULL220-492-3173brian.mccoy12@aol.com8242 Union StreetTempeAZ85238-4313NULL—
CLMCLM-426334 2026-08-16T00:42:27ZAlexisT·Crawford1962-10-07nullNULLN/AN/A9305 Central AveMiamiFL33151GRP-7348—
ENRENR-1292002026-03-21T15:13:16ZJanetH··Morgan··1968-04-24UHC-17766-52•••-••-3601+1 533 615 3995janet.morgan@aol.com2596 Sunset BlvdChandlerAZ85228GRP-6584MEDICARE-ADV-B
CLMCLM-4083342026-06-06T05:34:13ZSHIRLEY—HAMILTON1967-04-03·UHC-08692-04•••-••-6407-NULLUNKNOWNN/A··—nullMEDICARE-ADV-A
ENRENR-1344402026-02-25T16:00:37ZWEIZGREENE1997-03-09··uhc-56726-05•••-••-9166501-263-9404—8481 Mesa Drive···MinneapolisMN55409GRP-8323MEDICARE-ADV-B··
CLMCLM-4267692026-04-22T02:41:16ZMEGAN—SANDOVAL05-12-2004—null·UNKNOWN··8968 Highland AvenueAtlanta·GA30327··nullN/A
ENRENR-1290672026-09-05T04:45:59ZMelissaS.Kelly02/23/1967UHC-12381-10•••-••-3659(932) 329-2201melissa.kelly@outlook.com7347 Church StFresnoCA·93707GRP-6879navigate-hmo
ENRENR-1070912026-01-03T06:38:53Z SantiagoP.Robinson1957-07-26UHC-06217-27•••-••-3065661-481-8431null1268 Desert Sky BoulevardColumbusOH43274GRP-9296NAVIGATE-HMO
ENRENR-1231002026-04-11T05:13:37ZJOSEPHXORTEGA1997-09-26UHC-18784-87•••-••-1425NULLJOSEPH.ORTEGA89@ICLOUD.COM4871 Maple AveSacramentoCA95879GRP-3490NAVIGATE-HMO
ENRENR-1229822026-09-29T03:47:12Z·ABIGAIL—ROBERTS1963-06-08UHC-14496-11•••-••-3005(333) 830-4448abigail.roberts93@proton.me3460 MARKET STREETNashvilleTN37298GRP-6275SELECT-EPO
ENR ENR-1281682026-07-03T07:41:57ZJoeG·Stewart·Feb 11, 1953-—5262346068··JOE.STEWART37@YAHOO.COM286 Sage CtLOS ANGELESCAUNKNOWNGRP-4592CORE-HMO
CLMCLM-4219172026-08-05T02:18:33ZVINCENTQHART19590715UHC-21987-76—4755130697—·2540 Meadow LnNashvilleTN37236GRP-9030MEDICARE-ADV-B
ENRENR-1189892026-04-17T11:13:02Z THERESAE.HUDSON24-01-1960UHC-74120-88•••-••-8027214.318.1438theresa.hudson@icloud.com8022 Lincoln WaySacramentoCA95852GRP-0280MEDICARE-ADV-B
CLMCLM-4048122026-06-27T23:02:03ZDavis—Denise1990-08-20UHC-10523-05··•••-••-6458864-606-3712-··5468 Bayshore DrAtlantaGA30340--
CLMCLM-4077152026-07-15T09:08:16Zamy··—elliott1950-07-18NULLNULL—UNKNOWN--——-CORE-HMO
100,000 rows, page 158 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:36.703Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty