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-1192872026-05-22T13:57:50ZEmily··Alvarado1961-09-28UHC-66506-48•••-••-7237(830) 485-1618N/A7977 RIVER RDGlendale·AZ85328GRP-0347·MEDICARE-ADV-B
ENRENR-1283982026-07-29T00:03:23Z JoseAMcCoy07/07/91UHC-05379-73•••-••-2616N/AJOSE.MCCOY@GMAIL.COM2234 OCEAN AVEColumbusOH43233GRP-0519CHOICE-PLUS-PPO
TPATPA-517482026-04-20T10:39:10ZJEREMY—SNYDER1997-11-27UHC-72167-18NULLnullnull4178 Park PlJacksonvilleFL·32209-4768—medicare-adv-b
ENRENR-1374192026-09-26T15:35:09Zgabriel L—snyder··01/16/01··UHC-62600-65•••-••-7376457-581-3162gabriel.snyder@aol.com8354 River RoadScottsdaleAZ85238GRP-3638MEDICARE-ADV-B
TPATPA-506582026-08-17T11:32:23ZCheryl—Cunningham1949-09-03UHC-44238-01—-····1762 Cedar LaneChandlerAZ85280UNKNOWN—
TPATPA-500592026-08-16T19:30:43ZAMBERO.SCHULTZFeb 21, 2006—NULL(846) 964-8188··1979 Washington St Apt 2Miamifl·33176—OPTIONS-PPO
TPATPA-509522026-07-29T03:57:13ZBenjamin—OBrienAug 21, 1938UNKNOWNnull501-934-8070—3925 CENTRAL AVEGLENDALE·AZ85387GRP-4912OPTIONS-PPO
ENRENR-1422042026-05-24T11:16:53ZDianeN··Austin04/23/1964UHC-24235-08•••-••-7866701-671-6236DIANE.AUSTIN35@OUTLOOK.COM4487 Mountain View DrMesaAZ85227GRP-6356MEDICARE-ADV-B··
TPATPA-625622026-03-16T08:02:43Zolivia—gilbert1972-07-07null•••-••-88652306390465—UNKNOWN—-··UNKNOWN—
TPATPA-511602026-08-05T14:13:59ZANTHONY—MERTINOct 23, 1982null•••-••-0160——2343 OAK STREETPhoenixAZ85045-2771—·MEDICARE-ADV-A
CLMCLM-4114512026-01-21T03:31:10ZMarcus—Armstrong1950-08-07UNKNOWN-383-952-5702marcus.armstrong@aol.com8701 Meadow Ln·San DiegoCA92132GRP-7991-
ENRENR-1226612026-02-24T03:22:45ZCarlosGTorres1970-09-14UHC-33962-64•••-••-1175971-370-8636—1314 Hillcrest RdMesaAZ85220GRP-9904··NAVIGATE-HMO
ENRENR-1300142026-05-16T09:33:34ZSUSAN—WEBB··1952-10-06UHC-58050-50•••-••-00804289285824SUSAN.WEBB74@PROTON.ME2347 LINCOLN WAYEden Prairie··MN55390GRP-2301NAVIGATE-HMO··
CLMCLM-4165992026-03-21T07:14:00ZLawrence···Williams1987-07-11UHC-68040-19-—lawrence.williams@icloud.com7519 Highland AveMinneapolisMN55461GRP-7995MEDICARE-ADV-B
CLM CLM-4014452026-07-29T16:55:42ZAndrea—Soto2004-11-26UHC-05668-40N/A319-237-3196null——NULLN/AGRP-7006MEDICARE-ADV-B
TPATPA-619172026-02-23T19:49:55ZCATHERINE····WHEELER1952-10-07NULL•••-••-5827(803) 319-4021UNKNOWNUNKNOWN——UNKNOWNGRP-0257MEDICARE-ADV-A
ENRENR-1158492026-01-30T05:27:25ZYukiEHunter08-10-1998UHC4333698•••-••-5040889-605-7324yuki.hunter85@aol.com730 Forest AvenueFresnoCA93780-5053GRP-2913CORE-HMO
PRVPRV-237992026-06-30T08:50:46ZfrankAhoward07/01/71UHC-33748-51•••-••-49812546683803frank.howard85@icloud.com··5872 JEFFERSON AVENUENashvilleTN37253-6395—OPTIONS-PPO
ENRENR-1382262026-07-03T00:40:09ZBrittany—Robertson·1986-03-12UHC-25847-13•••-••-75278106877112brittany.robertson47@yahoo.com8443 Camelback RoadOrlandoFL32814GRP-1522MEDICARE-ADV-B
ENRENR-1163652026-09-24T06:17:38ZdorothyOphillipsApr 4, 1950UHC-59853-62•••-••-02138883289358dorothy.phillips@outlook.com4321 Jefferson AveDENVERCO80200GRP-9797CHOICE-PLUS-PPO
CLMCLM-4066292026-10-17T16:06:09ZHoward, William——1946-05-27··-(632) 215-7771—9694 Bayshore DriveNashvilleTN37277nullCHOICE-PLUS-PPO
ENRENR-1381902026-06-27T08:21:46ZJohn—FergusonNov 22, 1972UHC-54117-64•••-••-9563984-711-0020N/A9103 Apache BoulevardSan AntonioTX78235GRP-2427MEDICARE-ADV-A
CLMCLM-4217202026-03-26T07:00:02ZMATEO—SILVAJan 2, 2008—NULL633.352.3061N/A4577 Camelback RoadCOLUMBUS·OH43210GRP-8433NULL
TPATPA-574472026-02-17T14:59:05ZJERRY—HUGHES1983-05-26N/A——-1707 Hillcrest RdSeattleWA98147·GRP-5996-
TPATPA-585712026-09-27T00:05:22ZDoris—Fernandez04-02-2003·UHC-98369-55null····null5596 Bayshore Drive Apt 40JacksonvilleFL··32268—NULL
ENRENR-1403782026-02-12T23:36:53ZBrendaPGrant1974-07-20UHC-59470-91•••-••-80813353922803·brenda.grant@outlook.com6156 Washington StChandlerAZ85211GRP-1925SELECT-EPO
ENRENR-1339172026-04-25T10:05:29ZBETSYLJORDAN1979-02-15UHC-64254-45•••-••-8160(281) 261-6714ELIZABETH.JORDAN@ICLOUD.COM7409 Apache Blvd #439Las VegasNV89180GRP-1483OPTIONS-PPO
ENRENR-1276782026-08-01T16:49:41ZRay, BrendaM—19800509UHC-99155-76•••-••-2438(257) 214-2905brenda.ray@hotmail.com9660 ELM STMesaArizona85232GRP-3612OPTIONS-PPO
ENRENR-1077862026-09-03T19:28:11ZREBECCAQROBINSON09/09/1980UHC-71751-18•••-••-150312422418592—3146 Lincoln WayOrlandoFL32873GRP-5079NAVIGATE-HMO
ENRENR-1083122026-04-01T08:56:49ZkaylaP.dunn1977-12-24UHC-36255-45•••-••-50928398823725NULL4401 RIDGE RDLos AngelesCA·90082-4912GRP-9743OPTIONS-PPO
CLMCLM-4132382026-06-21T14:42:11ZCYNTHIA—·ROBINSON1980-09-09UHC-24600-14———····—NULLGRP-8442choice-plus-ppo
PRVPRV-254872026-06-26T08:32:26ZRUTH—BELL1991-06-20—-6492200725N/A5894 Central AveSCOTTSDALEAZ85240——
CLMCLM-4028852026-01-01T22:50:40ZChapman, Noah——20020415—•••-••-47299046434—397 Palm DrPHOENIXAZ-GRP-7778OPTIONS-PPO
CLMCLM-4215292026-07-05T23:49:47ZOMAR—WEBB05/23/39UNKNOWN—UNKNOWN·-127 CHURCH ST Apt 11San AntonioTX78272-4898—null··
TPATPA-52654 2026-04-30T22:19:32ZLARRY—BOWMAN22-10-1973NULL•••-••-3001—larry.bowman45@icloud.comUNKNOWN—null—NULL—
ENRENR-1422082026-05-28T08:32:09Z OWENSP··ELIZABETH1949-09-17UHC8134030•••-••-6419854.871.1123··163 Oak StHOUSTONTX··77026GRP-8882OPTIONS-PPO
ENRENR-1405742026-10-05T17:54:22ZOwens, Sofia—····19720815··UHC-02113-98•••-••-9135NULLsofia.owens@proton.me3376 CENTRAL AVEDenverCO80219GRP-1788CHOICE-PLUS-PPO
PRVPRV-200082026-04-26T09:27:56ZDonaldR.Cole6/28/2002UHC-90325-35N/A··2237524319——null·-N/A——
CLMCLM-4127832026-08-26T19:07:25ZCHRISTINAM.HERRERASep 19, 1954··UHC-81624-09null····—6995 Pine Drive·PlanoTX——OPTIONS-PPO
CLMCLM-4197612026-02-05T18:18:55ZCYNTHIA—CARLSON1994-02-25UHC-58426-35nullUNKNOWNN/A7120 OAK STREET··Las VegasNV89110GRP-0115medicare-adv-a
ENRENR-1406872026-08-23T11:24:49ZKARENITHOMAS2005-11-05UHC-47494-97null6962268··UNKNOWN··6718 Mesa DriveHoustonTX77082GRP-7804CHOICE-PLUS-PPO
TPATPA-545112026-03-06T23:25:02ZMorrison, DebbieZ—18-03-1975····•••-••-6501—N/A8651 Central AveTempeAZ85298nullMEDICARE-ADV-A
ENRENR-1038262026-06-18T23:05:51ZAlexanderQ.Hanson08/25/1958···UHC-67625-60•••-••-81136708760966··5407 JEFFERSON AVETampaFL33682GRP-8358core-hmo
PRVPRV-214302026-04-02T13:19:53ZZACHARY—ORTEGA1947-11-11UHC-23727-64•••-••-1649—N/A7811 WASHINGTON STFresnoCAN/AnullUNKNOWN
CLMCLM-4080502026-02-18T00:32:40ZKathleen—CarterOct 28, 2004—•••-••-1834(832) 688-2961kathleen.carter@aol.com2278 PINE DRMiamiFL33160UNKNOWNNULL
CLMCLM-4115902026-06-11T13:41:49ZTeresa—Nguyen··1975-04-20UHC-74299-44N/A(839) 254-9670-5453 Lincoln WayHOUSTONTX77059-0218GRP-4174—
CLMCLM-4166352026-05-17T11:31:54Z·Rayymond—Stone1944-04-18UHC-79612-67•••-••-6115NULL-8000 Park PlaceTampa··FL33670—N/A
ENRENR-1029612026-02-05T02:38:32ZDIANA T—BENNETT08/21/02UHC-57282-50UNKNOWN734-537-1973DIANA.BENNETT91@AOL.COM7975 Church StMinneapolisMN55435GRP-8371CORE-HMO
ENRENR-1128862026-01-13T18:15:22ZJulieG··Dixon1995-10-04UHC-86616-94-5232900144—5575 CAMELBACK ROADHoustonTX77001-7680GRP-4747CHOICE-PLUS-PPO
ENRENR-1176482026-02-15T12:28:31ZEdwards, BarbaraC.—1951-10-01uhc-91524-18•••-••-5287(869) 966-4205barbara.edwards84@proton.me4467 OCEAN AVE·SeattleWA98174GRP-7778·NAVIGATE-HMO
100,000 rows, page 161 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.704Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty