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
PRVPRV-283682026-09-16T00:22:33Z·paulYross1893-09-13UHC-15295-38··UNKNOWN—UNKNOWN3208 LINCOLN WAYPlanoTX75029-0248—UNKNOWN
CLMCLM-4129302026-03-24T02:04:45ZPrice, Nicholas——19420903UHC-89676-44null··826.686.8530NICHOLAS.PRICE44@ICLOUD.COM5158 BASELINE RDFresnoCA93794NULLSELECT-EPO
TPATPA-637002026-06-12T21:53:16ZFatima—Price1945-11-18-·null··—3822 Lincoln WaySan DiegoCalifornia92174-5025UNKNOWN—
CLMCLM-4268032026-03-09T19:52:47ZHannah—Chavez1968-07-28UHC-39743-86null691.367.4694hannah.chavez@hotmail.com2210 PARK PLGlendaleAZnullN/AMEDICARE-ADV-A··
CLMCLM-4230732026-03-08T19:18:06ZShirleyE.OBrien1969-06-05—•••-••-7881·4902453616-5922 Maple AvenueSacramentoCA95838GRP-4111—
ENRENR-1030012026-08-25T13:47:18ZSoto, FrankD—Nov 14, 2007UHC-53783-50•••-••-5786(806) 552-7556frank.soto@gmail.com4673 Bayshore DrMIAMIFL33121-5295GRP-7495NAVIGATE-HMO
TPATPA-619952026-09-22T23:02:50ZAustin, Heather——1994-10-27UHC-79946-28—nullN/A4774 Harbor Boulevard·GilbertAZ85244GRP-1430-
CLMCLM-4219492026-07-08T07:05:39Z PhilipOTucker1951-04-02uhc-10045-77nullNULL··-8795 Spring StGLENDALEAZ85359GRP-0141—
PRVPRV-272152026-08-24T06:40:07ZJAMESY.DELGDO··1967-08-17—•••-••-5852(508) 263-5398—3875 Mountain View DriveOrlandoFL32838——
PRVPRV-223872026-04-18T04:37:31ZKimberly——1993-05-03UHC-01765-28N/A··17988648692NULL4122 MARKET STREETDallasTX75257-·N/A
ENRENR-1306112026-04-10T02:17:24Zalexander—warren20020427UHC-79134-14•••-••-93095516451719NULL8072 DESERT SKY BOULEVARDColumbus··OH43265GRP-6667MEDICARE-ADV-B
TPATPA-537292026-06-19T16:56:59ZMargaret··OBrien1966-02-24·N/AUNKNOWN-··N/A——nullN/AUNKNOWN··
CLMCLM-4193982026-04-12T08:26:46Zdoris—fernandez·2003-02-04UNKNOWN-2485091224—5596 BAYSHORE DRJacksonvilleFL32268GRP-9789SELECT-EPO
ENRENR-1176402026-09-09T03:43:19ZAMBERPWEAVER1948-04-09UHC-51563-55•••-••-2629969-256-5825NULL9210 Mountain View DriveGLENDALEAZ85340GRP-8608·NAVIGATE-HMO
ENRENR-1083142026-04-14T23:39:35ZGonzales, AngelaX—2007-10-14UHC-43571-53•••-••-76216109320115angela.gonzales8@aol.com7833 Sage CtTampaFL33670···GRP-2627CHOICE-PLUS-PPO
CLMCLM-4305322026-09-22T05:10:40ZPhilip—Stephens1940-02-17UHC-52177-38•••-••-8619(521) 826-1425—145 Cedar LnDallasTX·75271GRP-8564CORE-HMO
CLMCLM-403959 2026-09-02T05:04:24ZDonald—BishopJan 26, 1944UHC-63974-50•••-••-754714717731791-9402 Maple AveCharlotte·NC28262-2108UNKNOWN·NAVIGATE-HMO
ENRENR-1189522026-06-12T22:04:56ZVincentHChen1963-03-09UHC-42867-23•••-••-1551nullUNKNOWN9867 Ridge RdEden PrairieMN55343GRP-5062·MEDICARE-ADV-B
CLMCLM-4176712026-02-28T08:15:54ZARJUN—GRAHAM1969-03-08UHC-79356-55•••-••-5884—NULL5507 Maple AveLas VegasNV89194GRP-3458null
PRVPRV-236462026-06-04T07:34:56ZStephen—Hoffman2007-05-08——+1 958 633 6505null—-UNKNOWNN/A—MEDICARE-ADV-B
ENRENR-1193302026-10-14T21:56:59ZeugeneXbaker1971-09-16UHC-10971-56•••-••-1726(692) 490-3266EUGENE.BAKER@AOL.COM1833 Meadow LnMesaArizona85291GRP-6153OPTIONS-PPO
PRVPRV-292972026-09-10T16:44:12ZSamuel—Richards1984-02-14—null264-545-3770UNKNOWN2173 Mountain View DrivePhoenixAZ85006——
CLMCLM-4286822026-05-02T09:30:27ZGaryKPerkins·01/03/1960UHC-08811-48•••-••-9408-UNKNOWNNULLnullUNKNOWN··N/AGRP-1277SELECT-EPO
CLMCLM-4101422026-03-17T04:49:03ZWilliam—Contreras·04/08/2002null··-—N/A··3013 Grand AvenueSeattleWA98116GRP-8277····
CLMCLM-4280902026-08-24T02:07:19ZJohn—Santiago19761227UHC-15864-97UNKNOWN(779) 606-7011··—535 Canyon RdGlendaleAZ85361—CORE-HMO
CLMCLM-427139 2026-04-23T13:26:13ZJuliaEBrown1989-05-17UHC-01468-21•••-••-6352950-230-3813UNKNOWN··8084 MAIN STREETSacramentoCalifornia95885null—
CLMCLM-4008672026-04-03T02:06:23ZZachary—Geoge·1999-07-23UHC9969566null938.999.9112-6658 CENTRAL AVENUEFRESNO·CA93763GRP-1841—
ENRENR-1236642026-04-11T03:15:54ZchristineC.delgado8/20/1941UHC-74487-51UNKNOWN420-912-5213NULL6732 ELM STREETJacksonvilleFL32237GRP-6176OPTIONS-PPO
ENRENR-1167612026-02-06T09:18:57ZWayne—Bell1972-01-26UHC-89231-52—8789631639wayne.bell@hotmail.com8916 Main StHoustonTexas·77089GRP-9582CORE-HMO
TPA TPA-513722026-07-20T02:36:16ZSarahUCrawford1996-06-24UNKNOWN•••-••-7441--8210 Cedar LnColumbusOH43297GRP-8412UNKNOWN
ENRENR-116682 2026-03-10T01:09:58ZDylan—Hunt09/25/41UHC-06624-53•••-••-54218346267586dylan.hunt96@aol.com2655 UNION STChandlerAZ85247GRP-4312··SELECT-EPO
PRVPRV-213022026-09-12T23:11:58Z PATRICIA·T.GONZALES2002-07-18UHC-73800-42····-NULL5925 Cedar LaneMinneapolisMinnesotaNULLUNKNOWN—
ENRENR-1401232026-09-16T10:48:43ZKathleenUArnold1967-02-03UHC-42875-96•••-••-5525—kathleen.arnold70@yahoo.com5324 Willow CtMinneapolisMN55496GRP-1295OPTIONS-PPO
ENRENR-1106152026-06-23T12:36:03ZKathleenW·CarterOct 28, 2004UHC-09188-64•••-••-1834(832) 688-2961kathleen.carter@aol.com2278 Pine DriveMiami··FL33160GRP-3907CHOICE-PLUS-PPO
CLMCLM-4316392026-08-05T14:45:43Z·sufiaHscott1969-07-19UHC-21371-17N/A··4706346089N/A—UNKNOWNN/ANULLUNKNOWNNULL
PRVPRV-237932026-07-15T04:17:14ZJoyce··KFisher01-05-1974UHC7128023•••-••-4755642-482-9456·NULL6729 Washington StChandlerAZ85205N/AUNKNOWN
ENRENR-1374652026-06-22T01:44:49ZEugene—Mendez11/24/1942·UHC-68273-18•••-••-8210911-630-4699eugene.mendez52@icloud.com1937 Meadow LnChandlerAZ85244GRP-8210SELECT-EPO
CLMCLM-4079752026-08-04T15:12:43ZAlexander—Welch1966-08-18UHC-73387-38•••-••-2686223-626-2604····5665 Lake View RoadFRESNOCA93759GRP-2344MEDICARE-ADV-A··
ENRENR-1290342026-07-09T17:38:05ZDanielle—Gutierrez1939-05-01uhc-79211-66-16052483731··danielle.gutierrez75@outlook.com·487 FOREST AVETampaFLUNKNOWNGRP-6419MEDICARE-ADV-B
ENRENR-1015682026-09-24T10:51:17ZETHAN—MALDONADO1970-10-25·UHC-81823-63•••-••-0416(567) 737-8172null2378 Sunset Blvd··Phoenix··Arizona85028GRP-6721MEDICARE-ADV-B
ENRENR-1304452026-03-23T21:45:25Z Nicholas··—Jordan1977-09-21UHC-29419-58N/A4803346486nicholas.jordan28@icloud.com1304 HILLCREST ROADPHOENIXAZ85082GRP-9675navigate-hmo
CLMCLM-4237822026-09-02T13:08:24ZSAM—ANDREWS2009-11-08—··UNKNOWNN/A7446 WASHINGTON STLas VegasNevada89129GRP-9393—
ENRENR-1105152026-06-13T22:24:49ZSandraD.Cunningham·02/24/60UHC4310881•••-••-9632(248) 374-8310·sandra.cunningham@outlook.com6712 Pine Drive··CharlotteNC··28226GRP-8166MEDICARE-ADV-B
CLM CLM-414616 2026-06-11T02:01:52ZAlexander—Vasquez1951-09-23UHC-55510-39•••-••-6028(797) 362-5493null9766 CENTRAL AVENUEGilbertAZ85284GRP-4398OPTIONS-PPO
ENRENR-1370092026-02-20T19:23:48ZRachel··Murphy1950-12-22UHC-95286-42•••-••-9907(531) 565-0119RACHEL.MURPHY2@AOL.COM9310 Mesa DrAustin··TX78706GRP-8840SELECT-EPO
TPATPA-509292026-02-12T13:05:42ZCharlesVWongFeb 1, 1963NULL•••-••-1611+1 545 468 4159null2646 BroadwayMiamiFL33116——
CLMCLM-4160342026-03-11T14:43:52ZMATEOACHEN1988-05-15null•••-••-10393164790384NULL—-—-GRP-2012MEDICARE-ADV-B
ENRENR-1160842026-09-19T06:10:29Z Katherine—Howell2006-04-08UHC-24751-04•••-••-98927366408835KATHERINE.HOWELL@AOL.COM6115 Indian School RoadLos Angelesca90004GRP-7537···CORE-HMO
CLMCLM-4253452026-03-04T16:12:01ZLawrence····Gutierrez1960-06-19UNKNOWN··•••-••-3926—lawrence.gutierrez58@gmail.com7369 FOREST AVENUE·DallasTX75248GRP-3372-
CLMCLM-4005982026-03-13T20:04:11Z·danielUcox1941-11-23UHC7617544•••-••-9378NULLN/A7426 River RdDallasTX75215NULL-
100,000 rows, page 107 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.679Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty