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
CLMCLM-4134812026-09-28T19:25:37ZDOROTHY—GUTIERREZ1962-06-12UHC-83717-49——N/A7334 Main StNashvilletn37234UNKNOWNSELECT-EPO
ENRENR-1110242026-03-12T07:31:34ZJACQUELINE—YANG1995-11-26UHC-86549-94•••-••-05979155081646·jacqueline.yang78@yahoo.com100 Ocean AvenueAustinTX78774GRP-6312CORE-HMO
ENRENR-1144762026-02-10T08:14:21ZAdaam—Mendez26-12-1974UHC-06210-34··•••-••-667214866742353adam.mendez36@outlook.com·2377 Ridge RdOrlandoFL··—GRP-9132CORE-HMO
ENRENR-1241612026-06-03T19:57:18Z·DORISICHAVEZ09/12/1966UHC-21944-44•••-••-80696686305734doris.chavez@proton.me6224 Grand AvenuePhoenixArizona85014GRP-0452MEDICARE-ADV-A
ENRENR-1372942026-04-10T09:19:07ZBurton, Samantha——1994-07-02UHC-14642-65•••-••-4297575-322-0567samantha.burton30@aol.com·2849 Mesa DriveSACRAMENTOCA95840GRP-9825SELECT-EPO
TPATPA-623302026-02-13T12:08:16ZKEVIN··—FERNANDEZ1971-05-07NULL—UNKNOWN·NULL1111 River Road··TEMPEaz85222GRP-4469OPTIONS-PPO
ENRENR-1182682026-08-31T03:13:26ZGREGORY··L.MARQUEZ1958-06-14UHC0972702•••-••-2671724-843-5785gregory.marquez84@gmail.com5659 Ridge RoadLOS ANGELESCalifornia90054GRP-5686MEDICARE-ADV-A
PRVPRV-234132026-08-02T06:41:05ZDorothy——1945-01-19UHC0380059—5283984440null·N/A·N/A—N/A·nullCHOICE-PLUS-PPO
CLMCLM-4307892026-03-04T18:24:59ZCHRISTIAN—ANDERSON19390709N/A•••-••-1233··—2042 Washington StORLANDOFL-·UNKNOWNNAVIGATE-HMO
TPATPA-617282026-04-12T04:29:31ZRalph—Armstrong1957-02-11··N/A····N/A7059 Desert Sky BoulevardGlendaleaz··85367GRP-8168··
PRVPRV-277322026-06-10T20:33:13ZOlivia—Chapman1956-02-05UHC-95278-33•••-••-1894513-968-0812—8780 BroadwayOrlandoFL32881··CORE-HMO
TPATPA-594932026-03-02T12:03:02ZAustin—·Bishop9151-03-06N/A-·-austin.bishop@yahoo.com3168 Central AvePhoenixAZ85014——
CLMCLM-4214252026-10-12T14:26:10ZKEITH··SSCHULTZ··01/23/1940—•••-••-1611NULL——————MEDICARE-ADV-A
TPATPA-506292026-05-23T13:33:59ZMeyer, Victoria——1996-05-01—-——5344 Indian School RdLas VegasNV89195N/AMEDICARE-ADV-B
CLMCLM-4203792026-06-02T20:59:32ZGeorge—Weaver03/13/61N/A•••-••-5675——6059 Bayshore DrSAN ANTONIOTX·78243-5769GRP-6787—
ENRENR-1417412026-05-31T15:13:07ZAlexis—McCoy1984-03-02UHC-08132-83··null16277050590··alexis.mccoy20@outlook.com4642 Forest AvenueLas VegasNV89104GRP-0551CHOICE-PLUS-PPO
CLMCLM-4148042026-02-07T23:25:40ZBradley·KWeber06-10-1989NULL•••-••-5167——7366 River RdPhoenixAZ85010GRP-3822UNKNOWN··
TPATPA-641772026-06-16T01:17:11ZPatricia—Watson·19390816-•••-••-54516788158135null5752 DESERT SKY BOULEVARDEden PrairieMN55352——
CLMCLM-4256672026-09-26T13:58:23Zlisa—williamson1956-04-04·NULLnull885.553.7555—6819 PARK PLSan AntonioTX78253-8601GRP-6128null
PRVPRV-207112026-02-24T20:42:49ZedHespinoza1949-08-10NULL····—NULL·2750 Valley View DrSan Antonio··TX78297—-
ENR ENR-1131202026-03-23T16:12:35Zlori F··—gardner1955-11-11UHC-82159-44•••-••-1751(771) 588-3281lori.gardner73@aol.com·6077 WASHINGTON STDallasTX75287··GRP-5988NAVIGATE-HMO
CLMCLM-4222562026-05-07T00:02:15ZBOBBY—SANTOS1965-03-28UHC-83369-97null9554350null7250 APACHE BLVDDALLASTX75217GRP-8950SELECT-EPO
CLMCLM-4066982026-08-28T19:29:31ZDONALD—CASTILLO··1942-07-26UHC-10489-73··UNKNOWN·518-342-4288NULL2970 MARKET STPhoenixAZ85095-6857N/ACHOICE-PLUS-PPO
ENRENR-1167882026-08-08T17:38:45ZJOSHUAI.MOENO1994-08-02UHC-31320-52•••-••-1961(452) 523-6822··JOSHUA.MORENO10@PROTON.ME5782 Market StreetMesaAZ85262GRP-2966·NAVIGATE-HMO
ENRENR-1281972026-01-19T05:46:42Z·LoganF.Mills··2004-06-12UHC2198389•••-••-75435779904428LOGAN.MILLS18@GMAIL.COM3968 GRAND AVE #848Sacramento··CA95851GRP-5175NAVIGATE-HMO
TPATPA-602512026-08-21T09:25:50ZTurner, Nathan——1987-05-06N/AN/A··null—528 Market StreetGilbertAZ85275-1898nullnull
CLMCLM-4208812026-04-20T04:34:02ZHEATHER—KENNEDY2008-04-19UHC-93835-23•••-••-9770920.235.6149HEATHER.KENNEDY60@PROTON.ME9077 Maple AveTEMPE·AZ85207GRP-8361MEDICARE-ADV-B
ENRENR-1371072026-03-20T06:46:18ZAdams, AnaO.—1944-07-09UHC-91260-01•••-••-40449769096894ana.adams@outlook.com9369 OCEAN AVENUEPHOENIXazUNKNOWNGRP-9849NAVIGATE-HMO
PRVPRV-203642026-01-05T13:12:54Zbryan·Qhansen11/13/1945UHC-58991-88N/A327-698-8031UNKNOWN8525 HIGHLAND AVENUESan AntonioTX78231null—
TPATPA-591262026-08-23T03:53:24ZMASON—STEVENS2005-09-23UHC8994835··•••-••-9745null··-2997 Mountain View Drive·MinneapolisMN55418GRP-3396····
TPATPA-518372026-01-28T01:08:00ZWells—Jonathan1997-04-19·UNKNOWN•••-••-3593NULL—9341 Church StreetSeattleWA98160UNKNOWN·MEDICARE-ADV-B
CLMCLM-4254392026-04-18T06:22:36Zcharlotte—meyer1965-07-01UHC-88643-22null6923729310——NULLUNKNOWN-GRP-8997SELECT-EPO
ENRENR-1424022026-07-18T17:00:40ZDAVIDXHOWELL1978-06-19UHC-89122-31•••-••-3577+1 318 687 8158david.howell@aol.com1246 Camelback RoadColumbusoh43210-0775GRP-0847MEDICARE-ADV-A
ENRENR-1217502026-07-26T07:16:22ZLARRY—MORENO1940-07-06UHC-71808-93•••-••-5207782-999-0173larry.moreno@icloud.com572 BASELINE RD··LAS VEGASNV89101GRP-3796NAVIGATE-HMO··
ENRENR-1381882026-07-24T16:43:23ZAmyKMorrison1977-02-06UHC-29243-33•••-••-1847484-639-6784amy.morrison@icloud.com4055 Palm DriveAustinTX78794··GRP-1225options-ppo
TPATPA-529522026-03-05T11:03:51ZEMMA—SNYDER1987-01-06UHC-72226-83nullN/A-9645 WASHINGTON STREETCHANDLERAZ85242GRP-1990UNKNOWN
ENRENR-1239522026-10-02T15:42:47ZJudithG··Cunningham1986-06-05·UHC-73518-90•••-••-1094713-519-4974JUDITH.CUNNINGHAM@ICLOUD.COM··244 BroadwaySacramentoCA95828GRP-0234NAVIGATE-HMO
TPATPA-639442026-08-17T01:40:55ZHELEN—DAVIS19420226··—UNKNOWN—helen.davis@proton.me9545 APACHE BOULEVARDDALLASTexas75240null··—
ENRENR-1242722026-07-20T07:04:06ZpriyaW.henderson1942-09-26UHC-79286-86•••-••-8364(733) 398-7726priya.henderson@aol.com3004 Cedar LaneTucsonAZ85718GRP-9253CORE-HMO
CLMCLM-4268622026-06-06T05:24:47ZEUGENEMCRAWFORD1954-05-05—•••-••-6851NULL—4182 HIGHLAND AVENUENashvilleTN37248-7162-·MEDICARE-ADV-B
ENRENR-1266942026-08-16T07:12:24ZGREGORYXRIVERA1956-02-21UHC-01682-52•••-••-9102942-662-8580gregory.rivera@gmail.com40 Park PlaceOrlandoFL—GRP-2604MEDICARE-ADV-B
ENRENR-1196072026-01-11T07:09:41Z alert—james1962-11-11UHC-00467-13•••-••-9241(835) 757-2854albert.james@aol.com2638 Forest Ave #327Tempe··AZ85266GRP-3919MEDICARE-ADV-B
TPATPA-521752026-08-14T13:17:41Zjanice—tran1977-08-21·UNKNOWN•••-••-64047909389444N/A4477 BROADWAYSan AntonioTX78281—MEDICARE-ADV-B
CLMCLM-4052252026-01-23T16:57:08ZKatherine··—Soto18-09-1956UHC-31504-63•••-••-9929944-752-1887····1461 Ridge RoadMesaAZ··85235—CORE-HMO
ENRENR-1405402026-06-20T09:29:56ZDENNIS—BROWN1944-05-22UHC-22981-87•••-••-2007506-291-5317dennis.brown@proton.me5143 Cedar LnMINNEAPOLISMN55447-0725GRP-0905MEDICARE-ADV-A
ENRENR-1050692026-03-11T18:42:34ZGEORGE··—MALDONADO2003-06-28UHC-54438-55•••-••-50594502481101NULL·8555 PALM DRIVETampaFL33677GRP-4486SELECT-EPO
ENRENR-1068652026-01-21T22:19:29ZAnthony—Guerrero1993-12-01UHC-84143-49•••-••-1347(617) 772-5230anthony.guerrero@hotmail.com5499 Church StreetLos AngelesCA90034GRP-9452NAVIGATE-HMO
TPATPA-578292026-06-05T00:44:47Zgracce··—romero··1978-08-24null—6328209186NULL6656 Lincoln WayNASHVILLETN37237nullnull
TPATPA-517202026-02-21T11:18:32ZBRYAN—MORENO0721-89-78null•••-••-3696—N/A212 WASHINGTON STREETSan DiegoCalifornia··92115-NULL
ENRENR-1219702026-05-14T00:13:47ZHamilton, PaulS—1992-07-03UHC-41906-30•••-••-4493(315) 674-6589paul.hamilton84@icloud.com5227 Lake View RoadAtlantaGA30300·GRP-5394MEDICARE-ADV-A
100,000 rows, page 254 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.752Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty