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

Enrollment only, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1104942026-07-16T07:43:16ZGABRIELRWARD1964-07-07UHC-85142-45•••-••-4231466-621-9873UNKNOWN550 Sage CtGilbertAZ85213GRP-6768MEDICARE-ADV-B
ENRENR-1430602026-05-18T22:34:53ZMaryTMejia··1954-04-14UHC-11103-64•••-••-5987-mary.mejia57@aol.com685 Apache BoulevardFRESNOCA93757GRP-0341CHOICE-PLUS-PPO
ENRENR-1395862026-10-13T14:30:03Zmatthew—richardson1948-04-15UHC5474213•••-••-10276325338211·matthew.richardson@icloud.com3988 Lincoln WayLAS VEGASNV89121GRP-5744SELECT-EPO
ENRENR-1101382026-08-10T05:05:42ZMurray, AnnG—1986-04-18UHC0422865•••-••-5335(243) 448-2550-847 MAPLE AVESacramentoCA95852-5321GRP-8385CHOICE-PLUS-PPO
ENR ENR-1234842026-09-15T02:24:14ZKevinV.Walker1985-12-27UHC-67304-99•••-••-1201(262) 676-8000kevin.walker@proton.me3600 LAKE VIEW ROAD··GlendaleAZ85358GRP-0609CORE-HMO
ENRENR-1181472026-07-29T16:49:30Z MarcusTWest09/26/99UHC-07676-75•••-••-9830·230-674-7644marcus.west@outlook.com7751 UNION STREETMESAAZ85222GRP-0947NAVIGATE-HMO
ENRENR-1359542026-10-13T09:52:28ZMariaW.Munoz03/01/66··UHC-87575-98•••-••-2161—maria.munoz@proton.me8893 Sage CourtMinneapolisMN55424GRP-5135CORE-HMO
ENRENR-1291542026-07-01T23:50:41ZJOSEPHMDANIIELS19950713·UHC-26322-25null··+1 816 799 0088-9477 BAYSHORE DRPhoenixazUNKNOWNGRP-2575CHOICE-PLUS-PPO
ENRENR-1272352026-01-29T18:56:56ZZacharyAWest1998-08-13uhc-45406-01•••-••-118914054356982zachary.west@gmail.com953 Central AvePhoenixAZ85000GRP-5122CORE-HMO
ENRENR-1399072026-07-20T04:18:29ZDANIELKDAVIS2004-12-08UHC-43463-17•••-••-2587707-573-0277daniel.davis@yahoo.com8632 Camelback RdDallasTXN/AGRP-0782CHOICE-PLUS-PPO
ENRENR-1012522026-03-20T09:56:51ZEmily······Mejia1976-04-16UHC-14207-80N/A284.286.1564emily.mejia@hotmail.com9063 HILLCREST RDDALLASTX75252GRP-6851choice-plus-ppo
ENRENR-1147042026-10-09T20:03:53ZVictoriaKPadilla10/26/1952UHC-84331-08-nullNULL5959 Canyon RoadLAS VEGASNV89122GRP-8284CHOICE-PLUS-PPO
ENRENR-1321992026-07-20T14:37:30ZEmmaVCarterSep 24, 1944uhc-03566-32•••-••-1450(822) 441-6865emma.carter@proton.me2297 ELM STREETSan DiegoCA·92117GRP-1492OPTIONS-PPO··
ENRENR-1310552026-01-19T11:25:49Z Couper—Andrew9/24/2001UHC-10821-69•••-••-04456129578425andrew.cooper@proton.me8838 Jefferson Ave Apt 22NashvilleTN37263GRP-8440MEDICARE-ADV-B
ENRENR-1389262026-09-14T05:37:08Z·WAYNE—ORTIZMar 1, 2005UHC-34770-98•••-••-8038744.484.6709··8399 Grand AvenueAtlantaGA30390GRP-6650NAVIGATE-HMO
ENRENR-1197372026-07-16T08:42:57Z ARJUNPKNIGHT1947-05-20UHC-49813-17•••-••-8638(945) 984-0769—5006 Palm DrEden PrairieMNnullGRP-2188MEDICARE-ADV-B
ENRENR-1404452026-02-03T07:47:42Z Sarah—Gutierrez1949-07-17UHC-64798-86•••-••-8630UNKNOWNsarah.gutierrez62@outlook.com3899 Meadow LnGILBERTAZ85225GRP-2887OPTIONS-PPO
ENRENR-1012632026-08-17T11:55:20ZHarper, Andrew——1978-03-24UHC-15603-56•••-••-672919438400787andrew.harper@aol.com340 LAKE VIEW RDLOS ANGELESca··90001GRP-2251OPTIONS-PPO
ENRENR-1393372026-09-16T19:28:54ZMATTTHEW—ROBINSON·1997-03-27UHC-18292-40•••-••-9456—MATTHEW.ROBINSON30@ICLOUD.COM2529 Harbor BlvdAUSTINTX78720GRP-2244OPTIONS-PPO
ENRENR-1417142026-04-19T15:34:55ZCatherine··Carroll19720927UHC-22691-20•••-••-5124429-308-7050catherine.carroll70@outlook.com1286 BroadwayChandlerAZ85236GRP-2385CORE-HMO
ENRENR-1310392026-02-21T19:23:12ZLuis—Alexander1951-04-27UHC-27605-62•••-••-3725(976) 633-7493luis.alexander69@outlook.com2773 Hillcrest RoadLas VegasNV89178GRP-4569CHOICE-PLUS-PPO
ENRENR-1146172026-10-15T16:51:39ZJacobVPhillips11/10/96··UHC-62923-91•••-••-1882(539) 645-5044-629 CAMELBACK ROADSacramentoCA95887GRP-4038OPTIONS-PPO
ENRENR-1113372026-04-26T06:03:52Z WayneVFerguson1969-06-12UHC-81497-60•••-••-8335+1 739 778 1136null8019 Broadway Apt 28MesaAZ··85235·GRP-6852OPTIONS-PPO
ENRENR-1239072026-07-25T03:49:13Z·Saamantha—Gordon11/22/05UHC-25459-19•••-••-47753507238164-·8170 Central AvenueSeattleWA98194···GRP-5328CHOICE-PLUS-PPO
ENRENR-1012302026-08-14T21:23:41ZPriyaFChen1999-03-03UHC-87411-86•••-••-47097486117223priya.chen@hotmail.com6678 Ridge RdNASHVILLETN37262-1106GRP-5959MEDICARE-ADV-A
ENRENR-1202222026-07-07T22:10:14ZBEVERLY—LITTLE1945-10-25·UHC-75057-46•••-••-3880·824-735-7362beverly.little@proton.me6663 MOUNTAIN VIEW DRFresnoCalifornia93769GRP-9826MEDICARE-ADV-B
ENRENR-1151982026-09-17T19:48:08Z·Gabriel—Nguyen1949-04-25N/A•••-••-484014199368046gabriel.nguyen47@aol.com5009 Jefferson AvenueCHANDLERAZ85212GRP-7818CHOICE-PLUS-PPO
ENRENR-1049442026-05-08T04:12:27ZDorothy—Tucker2001-06-19UHC0211259··•••-••-6102+1 523 509 6849dorothy.tucker84@yahoo.com15 ELM STREETSCOTTSDALEAZ85206GRP-3941MEDICARE-ADV-B
ENRENR-1313172026-01-23T16:15:09ZsandraUreed1985-04-05UHC4985221•••-••-6740421-761-0275sandra.reed@proton.me4807 CENTRAL AVECOLUMBUSOH43264GRP-9576SELECT-EPO
ENRENR-1410542026-02-08T06:26:01Z·ROGERO.STEWART11/20/89UHC-61291-66•••-••-34724998935193··roger.stewart@aol.com—NULL—nullGRP-6855MEDICARE-ADV-B
ENRENR-1160652026-09-26T05:45:27ZRALPHERIOS1940-09-12UHC-98578-71•••-••-21633529736896RALPH.RIOS@PROTON.ME·7140 BroadwayPlanoTX75082GRP-0219·NAVIGATE-HMO
ENRENR-1210412026-06-06T18:20:57ZJennifer··—Hayes·09-01-2004UHC-67865-24•••-••-8186·+1 681 898 2160—314 Maple AvePhoenixAZ85021GRP-4374OPTIONS-PPO
ENRENR-1385462026-04-19T13:18:11ZCARLF··HANSEN1950-04-01UHC-71557-13—·(829) 397-8046carl.hansen@hotmail.com1656 Canyon RoadEden PrairieMN55372GRP-9471choice-plus-ppo
ENRENR-1358182026-01-21T15:31:45ZSaraLFrreeman1986-06-22UHC-04806-77N/A18309973647—2306 CEDAR LANE·DallasTX75256-3110GRP-9906CHOICE-PLUS-PPO
ENRENR-1223632026-02-18T20:35:35ZJenniferA.Little··1954-06-06UHC-31231-20•••-••-6827639-554-4928jennifer.little@yahoo.com6996 Lincoln WayJacksonvilleFL32230GRP-8212·NAVIGATE-HMO
ENRENR-1408562026-04-07T13:27:32ZHerrera, AndrewM.—2004-01-23··UHC7865568•••-••-2312UNKNOWN-3253 Palm DrMINNEAPOLISMinnesota55487·GRP-1472NAVIGATE-HMO
ENRENR-1333682026-06-12T19:58:47ZBobby—Wang1956-11-16·UHC-68489-94—9377526731bobby.wang@hotmail.com6420 Camelback RoadAUSTINTX78778GRP-1194CHOICE-PLUS-PPO
ENRENR-1364482026-01-15T16:28:15ZLaura—·Meyer1939-01-25UHC-68984-17•••-••-82857593630673NULL4994 SAGE COURTSan AntonioTexas78235GRP-5497CORE-HMO
ENRENR-1074522026-01-08T12:18:11ZSharon—Lynch1977-12-04UHC-62183-25•••-••-370514857003847·SHARON.LYNCH@AOL.COM8452 DESERT SKY BLVD··MiamiFlorida33157GRP-4071MEDICARE-ADV-A
ENRENR-1126462026-10-08T05:07:26ZAllen, Christina——19570222UHC1214068•••-••-963613233474932christina.allen88@icloud.com5023 Apache BoulevardCharlotteNC28205GRP-0738CORE-HMO
ENRENR-1239762026-03-31T14:02:34ZEdwardC··Petrson1965-05-18UHC-86064-90•••-••-7703(254) 788-0228—2594 Ridge RdDallasTX75232·GRP-3699OPTIONS-PPO
ENR ENR-1106452026-09-22T01:50:13ZRANDY—WOOD19810519UHC-10379-19UNKNOWN(735) 752-0739N/A4592 Desert Sky BoulevardGlendaleAZ·UNKNOWNGRP-4453MEDICARE-ADV-B
ENRENR-1102572026-02-15T19:02:52ZEricZ.Lane5/20/1952UHC-48704-64—(535) 668-4609eric.lane39@hotmail.com9899 Central AvenueTampaFL33630··GRP-0640OPTIONS-PPO
ENRENR-1250302026-08-29T05:13:21ZMARI—SCHMIDT08/21/1984UHC-33033-18•••-••-011018036778112null4552 Canyon RdDALLASTX75272·GRP-5141MEDICARE-ADV-A
ENRENR-1043882026-02-13T09:36:04ZCherylQHenry8/19/1955UHC9779344•••-••-5028·598-732-4108cheryl.henry48@yahoo.com4304 CANYON ROADTucson·AZ85764GRP-0870CORE-HMO
ENRENR-1020172026-03-22T14:26:23ZEMMA—ESPINOZA1984-03-17UHC-28014-04•••-••-8719—emma.espinoza55@hotmail.com5393 Union StreetMesaAZ85224GRP-0799CORE-HMO
ENRENR-1045022026-05-23T03:52:03ZHamilton, Timothy——1/26/1952UHC-90711-45•••-••-5299820-460-8804timothy.hamilton@outlook.com6114 CHURCH STREETEden PrairieMN55359GRP-8075··MEDICARE-ADV-B
ENRENR-1424512026-07-24T03:45:54ZAustinCMarshall1990-12-19UHC-66555-53•••-••-92748664714051—7141 WILLOW CTHOUSTONTX77086GRP-6447SELECT-EPO··
ENRENR-1413112026-08-02T16:56:53Z LARRY—·HUNT2006-04-09UHC-16807-44•••-••-15735292811209LARRY.HUNT@AOL.COM7696 Desert Sky BoulevardSAN ANTONIOTX78273GRP-3341MEDICARE-ADV-A
ENRENR-123941 2026-02-19T07:16:38ZKim, GraceP.—19520402uhc-89018-09-(476) 459-0477grace.kim23@yahoo.com2766 SAGE CTDENVERCOnullGRP-6009·SELECT-EPO
43,101 rows, page 193 of 863PreviousNext

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