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-1287732026-02-07T12:36:45ZJonathan—Bowman·Feb 14, 1971UHC-89812-55•••-••-10239225693830—9437 Broadway··TUCSONAZ85743GRP-7765·MEDICARE-ADV-B
ENRENR-1104062026-03-15T09:46:30ZNtaalie—Knght1939-09-13UHC-35548-52•••-••-7072NULLnull2479 PINE DRIVEDallasTX··75203GRP-1642OPTIONS-PPO
ENRENR-1275892026-07-15T02:10:44ZCynthiaOMejia1950-12-08UHC-26270-21•••-••-6096865.839.0231····9748 Valley View DrGlendaleAZ85308GRP-5544NAVIGATE-HMO
ENRENR-1393922026-01-12T01:14:46ZCHRISTINE—MARQUEZ1940-01-03UHC-27800-79•••-••-0813972-442-9407UNKNOWN5341 Meadow LnTampa··FL33627GRP-3623·SELECT-EPO
ENRENR-1076392026-09-19T14:40:24ZMarkXValdezSep 1, 2008UHC-57968-08•••-••-9397597-787-8941MARK.VALDEZ80@PROTON.ME858 Indian School RoadGLENDALEAZ85372GRP-0843··OPTIONS-PPO
ENRENR-1197492026-03-03T13:58:54ZCharlesI.Burke1991-05-15UHC-82580-99•••-••-3947855.774.7509charles.burke@hotmail.com3100 Lake View RdAtlantaGA30302GRP-5319MEDICARE-ADV-A··
ENR ENR-1061672026-03-03T15:29:24ZMelissa—Sims23-07-1938UHC-12676-11•••-••-1527486.913.5113MELISSA.SIMS97@PROTON.ME7919 Apache BlvdFresnoCA93712-4024GRP-4423MEDICARE-ADV-A
ENRENR-1037932026-08-02T04:18:16ZBenjaminILane1991-08-02··UHC-13318-15null(443) 299-1150-284 Market StGlendaleAZ··85365GRP-2332MEDICARE-ADV-A
ENRENR-1049492026-08-19T11:36:00ZJohnson, RachelM.—·Feb 26, 1946UHC-50862-88•••-••-874413108253339rachel.johnson@yahoo.com·5094 Jefferson AveMINNEAPOLISmn55426GRP-7084NAVIGATE-HMO
ENR ENR-1074102026-08-04T22:20:07ZDavidKBurns9/17/1963UHC-28301-16•••-••-5278null··DAVID.BURNS@OUTLOOK.COM7628 Desert Sky BoulevardScottsdaleAZ··85254GRP-9925·OPTIONS-PPO
ENRENR-1403842026-07-21T01:14:13Z·SamanthaH.··Payne20010624UHC9906340•••-••-1763805-627-9614samantha.payne@yahoo.com4292 WASHINGTON STGilbertAZ85200GRP-4094··CORE-HMO
ENRENR-1136432026-02-02T05:19:25ZkimberlyT.brown1999-01-17··UHC-30623-15•••-••-1939744.905.6707—9295 Park PlaceSan AntonioTX78280GRP-8524SELECT-EPO
ENRENR-1131292026-10-05T17:47:31ZAARONF.WILLIAMS07-09-1993UHC-95901-31•••-••-7741936-430-1430aaron.williams@aol.com··7388 Mesa DrMESAAZ85237GRP-2462··MEDICARE-ADV-B
ENRENR-1175712026-01-08T09:28:06ZAlexsi··PRodriguez05/12/84UHC-34207-12•••-••-1343(648) 781-7696alexis.rodriguez9@gmail.com4731 BROADWAYAustinTX78796GRP-8397MEDICARE-ADV-A
ENRENR-1286072026-08-31T02:44:21ZKELLYS.HOLMES16-12-1975UHC-09935-47•••-••-0422(279) 344-6966—3850 Desert Sky BlvdLas VegasNV89172-8370GRP-4050·CHOICE-PLUS-PPO
ENRENR-1112352026-02-19T15:52:49ZThomas, Tyler——08/01/48UHC-19916-14•••-••-96347237238977—6416 PINE DRSan AntonioTX78264GRP-5566NAVIGATE-HMO
ENRENR-1095612026-04-29T00:13:21ZKaylaNGrahamJun 10, 1955UHC-57842-30•••-••-9727(730) 205-7082····3279 HIGHLAND AVEScottsdale··AZ85287GRP-9631CHOICE-PLUS-PPO
ENRENR-1290812026-07-16T06:54:57ZWEI·CSMITH1975-11-07UHC-62855-40•••-••-9261296-332-0783WEI.SMITH@ICLOUD.COM5845 Camelback Rd··Nashville··TN37226GRP-7262OPTIONS-PPO
ENRENR-1160802026-04-06T11:05:44ZDennisISalazar1987-01-01UHC-90264-58•••-••-6825·580-751-0726·dennis.salazar74@gmail.com1001 Mesa DrNashvilleTN37293GRP-5483NAVIGATE-HMO
ENRENR-1084082026-04-16T09:08:32ZStephen—Turner19840416··UHC0912402•••-••-14428955412142stephen.turner@proton.me3780 Grand AvenueSAN DIEGOCA92138GRP-1903medicare-adv-a
ENRENR-1231722026-05-21T10:37:44ZCarpenter—KyleApr 26, 1966UHC-00753-93•••-••-2555··KYLE.CARPENTER67@YAHOO.COM2745 VALLEY VIEW DRIVESeattleWA98193GRP-1882MEDICARE-ADV-A
ENRENR-1420582026-06-23T01:01:28ZTIMOTHY·G.·BENNETT1940-11-17UHC-58565-83•••-••-97183744460647timothy.bennett@icloud.com1538 HARBOR BLVD #855TempeAZ85234GRP-8224NAVIGATE-HMO
ENRENR-1225762026-05-24T03:07:12ZTim—Wogn1965-08-08·UHC-78337-47•••-••-0126683.410.9706TIMOTHY.WONG@YAHOO.COM3169 Camelback RoadFresnoCA93793GRP-5114core-hmo
ENRENR-1111372026-04-09T15:13:39ZJUDITH·SOWENS1944-02-28UHC3036926•••-••-21419456731363judith.owens19@aol.com·4041 MAPLE AVENUE #496FresnoCA93782GRP-4341MEDICARE-ADV-B
ENRENR-1177892026-02-15T09:34:03ZChristian—Gonzalez1979-07-21UHC-05076-98NULLUNKNOWNCHRISTIAN.GONZALEZ1@AOL.COM8471 SAGE COURTTucsonAZ85735GRP-2392MEDICARE-ADV-B
ENRENR-129447 2026-02-22T09:25:19ZDONALDE.ARMSTRONGMar 18, 1956UHC-34654-92•••-••-1235(964) 911-4494donald.armstrong@gmail.com3391 Lincoln Way Apt 31GlendaleAZ85380GRP-1511·core-hmo
ENRENR-1290552026-09-08T05:01:25ZHaroldECasillo05/28/49UHC-59339-91-N/Aharold.castillo45@proton.me1101 Church Street·DallasTexas75244GRP-1845OPTIONS-PPO
ENRENR-1340152026-06-20T08:55:23ZAlexanderN.WangJun 6, 1963UHC-08915-92•••-••-22306676364968alexander.wang31@gmail.com692 BROADWAYMinneapolisMN55443-5278GRP-0663CHOICE-PLUS-PPO
ENRENR-1140162026-01-29T12:57:29ZMELISSAYTURNER1969-05-07UHC-27635-81•••-••-70027193376210melissa.turner@proton.me1906 JEFFERSON AVENUESeattle·WA98147GRP-2033NAVIGATE-HMO
ENRENR-1181392026-06-10T17:59:06ZRoger—Perkins09-12-1990UHC-42079-03•••-••-0692UNKNOWN-·9858 Camelback RoadMiamifl33130GRP-0383MEDICARE-ADV-B
ENRENR-1130522026-03-07T21:00:43ZShirleyO.Morrison03/17/1974UHC-98455-98•••-••-5958548-753-9725··shirley.morrison64@aol.com220 Mountain View DrMinneapolisMN55433GRP-4409CORE-HMO
ENRENR-1004532026-04-22T13:36:34ZKENNETH—GRANT1953-01-10UHC-10465-94•••-••-8635(568) 814-1390kenneth.grant53@gmail.com367 INDIAN SCHOOL RDNashvilleTNN/A···GRP-5992OPTIONS-PPO··
ENRENR-1120782026-08-09T13:00:20Z·EdwardF.·OBrien1985-12-01UHC-57852-88•••-••-19324138471845·edward.obrien15@aol.com1457 Canyon RdLos AngelesCA90006GRP-7938MEDICARE-ADV-A
ENRENR-1281662026-10-06T16:45:09ZAliceDSilva19580220··UHC-48217-20•••-••-9797963.517.4695—3033 Valley View DriveTampaFL·33625GRP-9417NAVIGATE-HMO
ENRENR-1307572026-01-03T15:00:43ZOlivia—Stewart1961-04-10·UHC-16501-17•••-••-95789436146197OLIVIA.STEWART40@AOL.COM243 Market StORLANDOFL32849GRP-0907··NAVIGATE-HMO
ENRENR-1033062026-07-14T00:46:17ZNatalieXHicks19860206UHC-73470-12•••-••-9169UNKNOWN·natalie.hicks@aol.com1023 Baseline RoadTAMPA··FL33684GRP-9462NAVIGATE-HMO
ENRENR-1095012026-09-02T09:17:47ZKathherinePBanks1695-10-15UHC-70406-86•••-••-875312036048422katherine.banks75@outlook.com·914 Willow CourtTucsonAZ85759GRP-7754CORE-HMO
ENRENR-1233962026-08-15T07:33:54ZBRIAN—SILVAJan 12, 2001··UHC-75925-02•••-••-9565—brian.silva@hotmail.com5041 Market StHoustontx77025GRP-8721SELECT-EPO
ENRENR-1423412026-05-21T09:29:42ZLisa—Santiago05/22/64UHC-80978-54··•••-••-49983174045212lisa.santiago@gmail.com··9405 Ridge Road··GlendaleAZ85352GRP-8176SELECT-EPO
ENRENR-135300 2026-07-31T02:29:04ZCamilaERodriguez·18-09-1945UHC-63430-90···N/A·nullcamila.rodriguez@icloud.com4784 Baseline RoadPhoenixArizonaNULL·GRP-7196CORE-HMO
ENRENR-1175332026-08-03T10:24:09ZPAUL··O··PATEL22-11-1942UHC-67299-32•••-••-634716717233707paul.patel11@yahoo.com8622 Bayshore DriveTucsonAZ85741-7757GRP-1068CHOICE-PLUS-PPO
ENRENR-1087402026-02-22T04:32:18ZBarbara—Valdez04/05/1962NULL•••-••-14514492352839barbara.valdez@yahoo.com2787 CHURCH STREETHoustonTX77031GRP-6661SELECT-EPO
ENRENR-1155592026-01-23T03:57:20Z Samantha—Walker·1979-07-04UHC-63264-85•••-••-456717909878375samantha.walker@icloud.com1903 Baseline RdDenverCO·80237GRP-5262CHOICE-PLUS-PPO
ENRENR-1345482026-04-29T19:45:16ZNICHOLAS—WONG·03-06-1957UHC-46940-05•••-••-250117298256022—6275 Forest AvenueSacramentoCA95831GRP-2831CORE-HMO
ENRENR-1183312026-02-26T07:13:29ZNICHOLAS—JACKSON1951-02-03UHC-39004-12•••-••-1151N/ANICHOLAS.JACKSON99@HOTMAIL.COM849 Cedar LnFresnoCA93766GRP-4428medicare-adv-a
ENRENR-1310262026-08-09T04:31:19ZCAROL—CHAVEZJun 22, 1998··UHC-62928-83•••-••-00665355689186—1884 Highland AvenueGlendaleAZ85323GRP-8167MEDICARE-ADV-B
ENRENR-1272712026-07-31T08:57:49ZTyler—Hunter2004-05-23UHC-19361-64•••-••-1255+1 924 793 5489tyler.hunter@icloud.com6772 Maple AveGlendaleAZ·85379GRP-1656CORE-HMO
ENRENR-1012272026-02-15T08:44:37Z MaryG.Morris1956-03-09UHC-76266-14•••-••-11526563886700mary.morris53@hotmail.com··327 SAGE CT Apt 15··GlendaleAZ85320GRP-9818SELECT-EPO
ENRENR-1338812026-07-08T02:17:27ZPhilipK.Harper··1963-02-22UHC-80108-67•••-••-89896875732299PHILIP.HARPER40@GMAIL.COM··3956 BAYSHORE DRORLANDOFL32854GRP-7363MEDICARE-ADV-B
ENRENR-1094012026-06-06T03:45:59ZKaren—Howard1980-09-03UHC-74429-77•••-••-7871828-831-1255KAREN.HOWARD46@PROTON.ME9621 BroadwaySan AntonioTX78225GRP-3471CORE-HMO
43,101 rows, page 156 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:38.481Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty