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-1178162026-09-12T12:44:34ZGREGORYYMEYER9/7/1959UHC-65973-12•••-••-7664(266) 233-8342gregory.meyer@icloud.com6208 Lake View RdColumbus·Ohio43210GRP-8817select-epo
ENRENR-1058162026-03-22T21:10:03ZDaniel—Dixon1989-10-18UHC-67601-44•••-••-0049638-541-1705daniel.dixon@outlook.com7318 Camelback RoadSAN ANTONIOTX78245GRP-9277MEDICARE-ADV-B
ENRENR-1160312026-08-21T16:24:52ZJUANSREYES1996-09-28UHC-34305-07•••-••-7227nulljuan.reyes36@icloud.com5876 Camelback RdTucsonAZ85759GRP-5340MEDICARE-ADV-B
ENRENR-1212212026-08-13T16:02:02Z EmmaNPark1952-09-22UHC-67936-93•••-••-8943·(292) 778-7786emma.park81@aol.com2157 Ridge RdFresnoCA93791GRP-1894MEDICARE-ADV-A
ENRENR-1360482026-06-13T21:58:50ZOrtiz, Logan———·UHC-98629-39•••-••-0952+1 781 845 0255—2251 Grand AveLas VegasNV89141GRP-1592··CORE-HMO
ENRENR-112688 2026-08-24T04:32:08ZMarianaYSanchez·1946-01-14UHC-13522-61—18197343540MARIANA.SANCHEZ60@OUTLOOK.COM4672 MOUNTAIN VIEW DRIVECharlotteNC28284GRP-4715OPTIONS-PPO
ENRENR-1386792026-07-16T12:36:36ZNatalie—Weber0608-91-66UHC-23318-25•••-••-765515154446143natalie.weber@icloud.com3991 Hillcrest RoadFresnoCA93768·GRP-5086MEDICARE-ADV-A
ENR ENR-1082862026-02-15T03:00:14ZCharles—Knight1990-09-25UHC-80231-78UNKNOWN16042698139··charles.knight79@aol.com4527 UNION STNashvilleTN37209GRP-4989··NAVIGATE-HMO
ENRENR-1117162026-06-15T05:03:12ZWALTERDCLARK··1980-03-06uhc-73064-35•••-••-5684257-733-6460walter.clark28@proton.me··3926 LINCOLN WAY··JacksonvilleFL32298GRP-1798CORE-HMO
ENRENR-1082572026-01-20T05:19:15Z·FrankE.·Padilla1983-04-08UHC-29865-63•••-••-12658739218602frank.padilla1@aol.com8895 PARK PLACE Apt 36GlendaleAZ85395·GRP-6527OPTIONS-PPO
ENRENR-1051802026-09-07T16:53:28ZMeyer, AlbertV.—10/17/1986UHC-06373-47•••-••-2582263-359-0486albert.meyer@proton.me7078 CEDAR LANE·ORLANDOFL32856GRP-9948MEDICARE-ADV-A
ENRENR-1290822026-07-13T00:20:10ZHarris, Timothy——08-08-1960UHC-02413-69•••-••-4461363.327.4985timothy.harris76@gmail.com1631 LINCOLN WAYLos AngelesCA90003GRP-8358NAVIGATE-HMO
ENRENR-1027182026-08-07T21:54:44ZGRACETPETERSON07/11/1987UHC-80834-29•••-••-8122(282) 551-3637grace.peterson@gmail.com116 HIGHLAND AVENUEGLENDALEAZ—·GRP-2704MEDICARE-ADV-A
ENR ENR-1283772026-03-17T23:45:30ZJanice—Fox1953-01-27UHC-33647-05•••-••-7994498.281.5092null3828 MEADOW LANENASHVILLETN37207-1843GRP-6149CHOICE-PLUS-PPO
ENRENR-1338572026-03-22T01:40:25ZJordan—Lawrence20020913UNKNOWN•••-••-4859+1 835 753 9084·JORDAN.LAWRENCE@PROTON.ME7239 Ocean AvenueLos AngelesCA90071-8062GRP-8530··MEDICARE-ADV-A
ENRENR-1185622026-01-07T04:54:56ZWoodRKyle2004-12-11UHC-68037-24•••-••-9651·337.694.1410KYLE.WOOD80@ICLOUD.COM··4086 UNION STREETSan AntonioTX78243GRP-4324CORE-HMO
ENRENR-1105512026-06-25T11:05:31ZchrisX.chenJan 2, 1943UHC-61903-40····9012937786christine.chen@aol.com7525 Apache Blvd··AtlantaGA30397-3826GRP-7958NAVIGATE-HMO
ENRENR-1117452026-02-28T02:55:23ZKathryn—Schultz2001-01-21UHC-26229-11•••-••-4529952-311-0889kathryn.schultz98@icloud.com2869 CENTRAL AVEPhoenixArizona85021·GRP-2162OPTIONS-PPO
ENR ENR-1112832026-05-22T10:42:07ZEthanVPadilla06/16/1943UHC-99991-81•••-••-3550(353) 300-9557N/A8110 Pine DrSeattleWA98137GRP-7418·CHOICE-PLUS-PPO
ENRENR-1397592026-04-10T05:31:31ZALXISX.MORRISON1981-10-24UHC-67872-19•••-••-5829·528-254-5437UNKNOWN9552 Forest AvenueAustinTX78712GRP-3014MEDICARE-ADV-B
ENRENR-1411702026-02-14T03:24:29ZDanielAFowler1974-12-04··UHC-99397-30•••-••-734513517585193null9441 BROADWAYAtlantaga30300GRP-9372SELECT-EPO
ENRENR-1228252026-08-04T16:41:40ZDiaz, Alan——1958-03-13UHC-47621-31•••-••-6883(660) 367-3488alan.diaz30@proton.me2159 MESA DRIVEAustinTX78732GRP-7327MEDICARE-ADV-A
ENRENR-1392102026-06-10T11:05:43ZJULIEKHART1980-10-02UHC-43925-27•••-••-8243474-908-1856—7447 HIGHLAND AVENUEFresnoCA93718GRP-3716NAVIGATE-HMO
ENRENR-1425382026-05-15T11:39:40ZJORDAN—MEYER··1959-06-15UHC-38596-17•••-••-73697706468782null1046 Indian School RoadGLENDALEAZ·85390GRP-4004MEDICARE-ADV-A
ENRENR-1092772026-01-31T23:53:40ZHENRY—RODRIGUEZ9138-05-03UHC-62145-72•••-••-8928(699) 387-4714henry.rodriguez@hotmail.com5598 JEFFERSON AVENUEJacksonvilleFL32243GRP-1717··CHOICE-PLUS-PPO
ENRENR-1185072026-04-09T10:18:33Z JONATHAN—PETERSON09/22/1939UHC-80951-24•••-••-8696(866) 849-2621N/A9875 Canyon RoadChandlerAZ85279··GRP-0241MEDICARE-ADV-B
ENRENR-1132132026-03-14T01:46:02Zbrian—sanchez1941-03-04··UHC-26481-46•••-••-1049(304) 994-2326brian.sanchez@yahoo.com6832 Forest AvenuePhoenixAZN/AGRP-7124OPTIONS-PPO
ENRENR-1043532026-08-07T17:56:55ZAnaOSantos1940-10-17UHC-93279-73•••-••-0070590-997-3736ana.santos@outlook.com7064 INDIAN SCHOOL RDTucsonAZ85779GRP-7915··SELECT-EPO
ENR ENR-101452 2026-06-22T20:21:46ZPATRICIAEHAMILTON02-09-1979UHC-61712-73•••-••-56422556081288—2061 Pine DrNASHVILLETN37286GRP-1511···NAVIGATE-HMO
ENRENR-120345 2026-04-29T17:23:49ZBrittanyFMoore1987-02-64UHC-56786-04•••-••-37034563141279brittany.moore@aol.com8616 Union StCharlotteNCNULLGRP-0904OPTIONS-PPO··
ENRENR-1240952026-02-12T21:57:23ZJULIAQ.··COLLINS1945-11-09UHC-49715-81null(665) 466-7793·julia.collins40@hotmail.com3643 Sunset BlvdMESAAZ85267GRP-4998··MEDICARE-ADV-A
ENR ENR-1109132026-06-14T10:22:34ZMatthew——1992-09-05UHC-62583-91•••-••-9490552.756.2708—6539 HIGHLAND AVEPlano·TX75036GRP-6318NAVIGATE-HMO
ENRENR-1426522026-08-29T19:53:30ZJulieK.Romero··1998-50-13UHC-01895-18•••-••-4914212.563.7377julie.romero@icloud.com·5688 Highland AveSan AntonioTX78229GRP-8933CORE-HMO
ENRENR-1289262026-04-27T05:55:20ZJOYCEIDUNCAN1994-06-08UHC-27486-99•••-••-2303-null1676 BASELINE ROADSeattleWA98139GRP-0928MEDICARE-ADV-A
ENRENR-1311762026-01-23T22:46:06ZMEGANK.··MENDOZA1973-10-04UHC-11350-97•••-••-27143755144219-1249 Main StSeattle··WA98120GRP-7250NAVIGATE-HMO
ENRENR-1391902026-10-08T13:58:23ZAlan—Olson1953-01-19UHC-34288-51•••-••-730814032249395-9036 Ridge RoadSan AntonioTX78201GRP-4577OPTIONS-PPO
ENRENR-1413932026-02-16T18:09:43ZKEIITHJKNIGHT1801-19-64UHC-58061-10•••-••-7543+1 927 652 2199keith.knight@proton.me2265 Camelback RoadTucsonAZ—GRP-1275CORE-HMO
ENRENR-1378842026-01-04T18:06:55Z·JackCEspinoza2001-01-19UHC-29115-37··•••-••-8463(937) 292-2043··N/A8268 Meadow Ln Apt 14LAS VEGASNV89109GRP-4527SELECT-EPO
ENRENR-1016532026-02-20T11:29:47ZAUSTINVRICE8/9/1961··UHC-01782-05•••-••-753816339088309N/A3657 ELM STTempeAZ85217GRP-4563medicare-adv-a
ENRENR-1425342026-05-19T08:57:09ZValdez, Stephen——1975-03-18UHC3083140•••-••-27247747303736STEPHEN.VALDEZ11@PROTON.ME3115 Park PlaceDenverCO80251GRP-2478CORE-HMO
ENRENR-1339202026-01-15T08:01:22Zmegan—allen1946-09-15UHC9442104•••-••-2826N/A—·3172 Central AvenueSan DiegoCA92182GRP-9282MEDICARE-ADV-A
ENRENR-1048842026-08-20T16:32:04Zamber··Gnichols·03-03-1993UHC-10935-86•••-••-8265462-509-3460··amber.nichols@proton.me1003 Sage CourtScottsdaleAZ85225GRP-3496CHOICE-PLUS-PPO
ENRENR-1310032026-02-04T09:04:46ZElijah—Grant1940-05-21UHC-75378-87•••-••-57387711714ELIJAH.GRANT@ICLOUD.COM587 Church StreetEden PrairieMN55377GRP-6172NAVIGATE-HMO
ENRENR-1107702026-03-26T08:17:18ZBillyIWelch2/8/2008uhc-84428-82•••-••-3023588-807-9051null1255 Spring StTucsonAZ·85721GRP-3552SELECT-EPO
ENRENR-1168532026-02-13T12:04:04ZScottQ.Thompson··1938-01-06UHC-89479-43•••-••-46767098563195scott.thompson@yahoo.com·4430 VALLEY VIEW DRIVEDallasTX75253GRP-3934SELECT-EPO
ENRENR-1284462026-05-05T00:04:05ZJESSE—RIOS7/2/1950UHC-38231-18—(800) 406-2529JESSE.RIOS@PROTON.ME8321 Apache BoulevardMIAMIFL33193GRP-1640MEDICARE-ADV-A
ENRENR-1386072026-02-10T08:01:16ZMason—Lewis1992-07-20UHC-15830-99•••-••-5514N/AMASON.LEWIS@OUTLOOK.COM·2392 Lake View RdTampaFL-GRP-7509NAVIGATE-HMO
ENRENR-1093272026-05-01T04:04:04ZCamila G.—Olson1949-01-07UHC-44269-20•••-••-5169NULLUNKNOWN3970 Sage CourtAtlantaGA30342GRP-6770·NAVIGATE-HMO
ENRENR-1373012026-07-27T23:24:47Z·HANNAAH—TAYLOR··1956-09-14UHC-49582-39•••-••-5993474.853.8894·hannah.taylor@icloud.com6227 Palm DriveSacramentoCA95872-6687GRP-5565OPTIONS-PPO
ENRENR-1076072026-08-17T00:49:13ZWashington, Christina——Mar 2, 1957UHC-46069-27•••-••-56014935563798christina.washington18@yahoo.com6381 PALM DRIVE·LAS VEGASNV89126GRP-9655SELECT-EPO
43,101 rows, page 251 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.636Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty