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-1162722026-05-17T10:40:44ZTimWOlson1/7/1938UHC-91075-61•••-••-9134UNKNOWNtimothy.olson@yahoo.com6827 Mountain View DrPhoenixArizonaN/AGRP-5268core-hmo
ENR ENR-1236582026-05-15T05:20:32ZKEN—FOWLER·1989-05-09UHC-79833-73•••-••-7022630-231-7839·N/A821 BAYSHORE DR··SeattleWashington·N/AGRP-5559MEDICARE-ADV-B
ENRENR-1015282026-06-24T05:36:14ZAMBER—JIMENEZ·8003-20-04UHC-80329-77•••-••-0141+1 787 852 4581·AMBER.JIMENEZ@ICLOUD.COM9003 CAMELBACK ROADGlendaleAZ—GRP-5191NAVIGATE-HMO
ENRENR-1073632026-04-08T01:04:07ZEugeneNJimenez2/4/1984UHC-93297-60•••-••-5793(925) 438-5844eugene.jimenez29@gmail.com1999 Willow CourtEDEN PRAIRIEMinnesota55397GRP-0542OPTIONS-PPO··
ENRENR-1276562026-01-15T19:01:11Zbrandon—gilbert—UHC-47987-53•••-••-4923+1 639 388 7358—5070 Highland AvePhoenixAZ85093GRP-1675CORE-HMO
ENRENR-1211392026-09-07T23:17:41ZDEBRAHT.MORALES·1968-08-17UHC-91939-51•••-••-9150(581) 536-9177·deborah.morales@proton.meUNKNOWNNULL——GRP-9505MEDICARE-ADV-B
ENRENR-1418842026-03-06T04:03:41ZMELISSABHUDSON09/06/07UHC-49229-90•••-••-3272(513) 836-7797melissa.hudson13@aol.com1746 Grand AveGilbertAZ85210GRP-7518·CORE-HMO
ENRENR-1155222026-09-01T19:46:42ZDavidYArmstrong1946-07-26UHC-93636-05•••-••-5222379-691-3570DAVID.ARMSTRONG88@OUTLOOK.COM1887 Ridge RoadGilbertAZ85232GRP-1861SELECT-EPO··
ENRENR-1198802026-05-25T13:02:30ZChristinaJDaiz11/25/1998UHC-22718-61•••-••-1084885-550-4775—9396 MEADOW LANEDallasTX75272GRP-8630MEDICARE-ADV-B
ENRENR-1137482026-02-19T04:42:47ZNICOLELMUNOZ2006-06-19uhc-35202-88•••-••-04854447610655-9023 Church St·NashvilleTN37248GRP-5002MEDICARE-ADV-B
ENRENR-1382372026-03-26T03:19:19ZJoeL.Armstrong1965-12-08UHC-91183-10-UNKNOWNjoe.armstrong63@icloud.com2153 MEADOW LANEAustinTX78721-4253GRP-1032OPTIONS-PPO
ENRENR-1221942026-01-20T09:27:16Z·SophiaILuna01-06-1969·UHC-98285-99•••-••-4078338-961-2157—4119 River RoadScottsdaleAZ-·GRP-5866MEDICARE-ADV-A
ENRENR-1277232026-01-25T18:58:15Z RobertZPerez·1995-06-13UHC7461205•••-••-0487922-463-7523robert.perez72@hotmail.com309 CHURCH STPhoenixAZ85067-3720GRP-5638OPTIONS-PPO
ENRENR-1347782026-07-26T06:17:44ZKEVIN—FREEMAN0901-15-93UHC-75530-98•••-••-2907NULL··kevin.freeman@hotmail.com7508 Oak StreetMesaArizona85247GRP-8594CORE-HMO
ENRENR-1358162026-04-22T19:32:07ZAlexander—OBrien1970-05-20UHC-27163-89null4972713147alexander.obrien@outlook.com618 Sage CourtColumbusOhio43236-3692GRP-4217CHOICE-PLUS-PPO
ENRENR-1411522026-04-11T00:27:30ZJustinV.Munoz07/23/1996UHC6556174•••-••-5206808-560-9710JUSTIN.MUNOZ@GMAIL.COM2020 Main Street #453··FresnoCA93784GRP-7964NAVIGATE-HMO
ENRENR-1278322026-06-21T07:08:14ZMarc—Barnes1993-03-02·UHC-22185-74•••-••-17654989452279NULL7942 Pine DriveMesaAZ85232GRP-5897CHOICE-PLUS-PPO
ENRENR-1136802026-08-01T15:04:34ZSARAHXAUSTIN10-03-1975UHC-05589-30•••-••-0536272-955-3883SARAH.AUSTIN@PROTON.ME8925 Hillcrest RoadEden PrairieMN55335GRP-4624·OPTIONS-PPO
ENRENR-1219362026-07-24T08:31:28ZLisaI.Yang18-12-1963UHC-78240-55•••-••-0063272-256-7161lisa.yang71@outlook.com6761 Oak StScottsdaleAZ85229GRP-3934NAVIGATE-HMO
ENRENR-1349992026-08-24T20:16:34ZERIC—FOSTER1953-07-26UHC-04955-08•••-••-67813585718910eric.foster87@gmail.com4997 ELM STREET·TempeAZ85241GRP-9005NAVIGATE-HMO··
ENRENR-1363092026-10-12T20:37:05ZSarahNWashington2/2/1975UHC-90115-28•••-••-9998313.639.6837SARAH.WASHINGTON@HOTMAIL.COM7915 Meadow LaneFresnoCalifornia93757GRP-2870CHOICE-PLUS-PPO
ENRENR-1314182026-02-19T08:23:49Z·susan—salazar1966-12-23·UHC-80684-62•••-••-985217436860152null1616 SUNSET BLVD Apt 30GLENDALEAZ85383GRP-4139SELECT-EPO
ENRENR-1129332026-03-23T00:37:02Zjustin—warren19700202UHC-50704-53—(690) 258-8402UNKNOWN6843 Mountain View Drive Apt 30Glendaleaz85350-9592GRP-1904MEDICARE-ADV-B
ENRENR-1151832026-08-02T14:47:20ZHarrison, Alice··——1996-04-08UHC-75394-78-402-889-5035alice.harrison@proton.me9089 Sunset Blvd #699SEATTLE·WA98147GRP-0248OPTIONS-PPO
ENRENR-1296362026-08-28T04:44:37ZCarlosCWilliamson1977-07-01UHC-61358-72•••-••-1943+1 707 510 7974carlos.williamson@proton.me5335 Highland AvenueTempeAZ85242GRP-9366MEDICARE-ADV-B
ENRENR-1190282026-08-13T06:15:28ZGraceN.Tucker1939-06-04UHC-08828-54•••-••-9396607.604.6052null5194 DESERT SKY BOULEVARDDallasTX75211GRP-2059options-ppo
ENRENR-1075642026-07-15T03:19:27ZGregoryCHayes1945-01-13UHC0967334•••-••-3066(906) 762-8422gregory.hayes@hotmail.com··380 SUNSET BLVDSeattleWA98122GRP-9948OPTIONS-PPO
ENRENR-1101352026-05-04T09:02:01ZRachelPOlson1989-10-28UHC-49761-37•••-••-69448207945995RACHEL.OLSON1@ICLOUD.COM··3469 Canyon RdScottsdaleAZ85258GRP-4462·CORE-HMO
ENRENR-1272882026-03-10T11:10:20ZJacob—Maldonado1996-07-26null•••-••-0354+1 912 634 6690JACOB.MALDONADO@ICLOUD.COM4546 Ridge RdSan DiegoCA92121-2840GRP-3576SELECT-EPO
ENRENR-1423442026-03-21T05:15:27Z Catherine··Romero··1952-02-09·UHC-95527-11•••-••-0467944.537.9019null9615 Camelback RdTempeArizona85263-1657GRP-0840MEDICARE-ADV-B
ENRENR-1398132026-09-20T00:58:35ZAMBERPMCDONALDJan 6, 1956UHC-75817-92•••-••-8433774-668-7557amber.mcdonald@gmail.com3030 Spring StreetTucsonAZ85763GRP-8579MEDICARE-ADV-A
ENRENR-1306372026-01-24T15:17:23ZRalph····Knight1998-02-15UHC-26304-24•••-••-399317549406476ralph.knight32@icloud.com3878 Jefferson AvenueSeattleWA98155GRP-2665CORE-HMO
ENRENR-1118742026-01-10T09:10:59ZRuth—Fox1951-11-15UHC-22333-94•••-••-84543809674427N/A578 Baseline RoadTempeAZ·85235GRP-9979NAVIGATE-HMO
ENRENR-1251562026-08-03T17:42:03ZMARGARETV.PARKER1970-03-03UHC-49124-60N/A18119125673margaret.parker32@aol.com2902 Willow CtFresnoCA93748GRP-3799CORE-HMO
ENRENR-1318242026-04-23T08:32:01ZHARVEYVCAMILAApr 12, 1982UHC-55326-27•••-••-2108989-613-3611camila.harvey74@aol.com1247 Mesa DrEden PrairieMN55399GRP-5700MEDICARE-ADV-A
ENRENR-1274252026-06-24T00:32:36ZCook, Donna——1978-02-12UHC-07640-06•••-••-34338798708298N/A6772 Desert Sky Boulevard··NashvilleTN·37276-8665GRP-4591CORE-HMO··
ENRENR-1040022026-08-29T20:10:06Zranyd··ward1980-01-25··UHC2443639•••-••-9162(797) 554-4450-1813 UNION STREET #905PlanoTX75009GRP-4762··CHOICE-PLUS-PPO
ENRENR-1284432026-01-22T03:27:01ZCAMILA—LAWRENCEJan 24, 2001UHC-72280-23•••-••-1684264.978.4959CAMILA.LAWRENCE36@OUTLOOK.COM1070 Camelback RdOrlandoFLN/AGRP-5065OPTIONS-PPO
ENRENR-1253142026-02-15T10:08:59ZBruce··JSantos02/23/96UHC-10163-44··•••-••-5419+1 360 236 2372··bruce.santos80@gmail.com4163 Ocean AvenueMIAMI··FL33122GRP-9078CORE-HMO
ENRENR-1171612026-10-16T22:02:31ZSofiaAWong03/15/1978UHC-38789-39··UNKNOWN420-781-5854sofia.wong@hotmail.com2750 Spring StreetMiami··FL··-GRP-0832CHOICE-PLUS-PPO
ENRENR-1419362026-04-30T23:27:37ZMariaL.Davis0407-18-90UHC-91962-84•••-••-3129325-838-6557—7357 APACHE BLVD·MesaAZ··85275GRP-2134NAVIGATE-HMO
ENRENR-1004852026-08-19T06:54:50Zmunoz—elizabeth1982-02-13UHC4021661··•••-••-8954—ELIZABETH.MUNOZ@HOTMAIL.COM4165 WILLOW COURTCOLUMBUSOH43235GRP-4908MEDICARE-ADV-B
ENRENR-1105542026-09-20T04:47:21Z GARYZSANDOVAL1987-07-20UHC-91237-16—14432608822gary.sandoval@outlook.com2024 Valley View DrLos AngelesCalifornia90081GRP-7856MEDICARE-ADV-A
ENRENR-1149492026-09-05T03:02:07ZAdmaZWebb6/28/1995UHC-45470-12—N/Aadam.webb30@gmail.comnull-—-GRP-1746CHOICE-PLUS-PPO
ENRENR-1388232026-06-09T21:45:36ZARJUNHWEBER1964-02-13UHC-19405-15•••-••-4200(229) 955-1082-3172 Mesa DrEDEN PRAIRIEMN55363GRP-4462·CHOICE-PLUS-PPO
ENRENR-1181262026-07-21T07:28:22Z·Gloria·····Tran12/15/99UHC6080643•••-••-9695NULLGLORIA.TRAN83@PROTON.ME5239 RIVER RDSACRAMENTOCA95844GRP-6034MEDICARE-ADV-B
ENRENR-1315352026-08-18T11:05:57ZweiBstevens1957-09-24UHC-61657-92•••-••-8531+1 259 387 2084wei.stevens88@gmail.com526 Sage CtAustinTX78788-0067GRP-6183options-ppo
ENRENR-1427262026-01-06T12:13:03ZSantiagoW.McDonald1959-02-03UHC-59608-33•••-••-2540(689) 667-3729—6607 Jefferson AveMiamiFL33176GRP-6639CORE-HMO
ENRENR-127405 2026-06-20T09:40:56ZMateoSBurton10/03/97UHC-08742-63•••-••-48867139639463··NULL3588 MAIN STREETPLANOTX75035GRP-1826MEDICARE-ADV-A
ENRENR-1212642026-03-10T18:11:21ZPriya—Welch20-08-1991UHC-03974-15•••-••-2186899-593-6937priya.welch80@yahoo.com8413 Ocean AvenueNASHVILLE··tn··37244GRP-4390··CHOICE-PLUS-PPO
43,101 rows, page 118 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:37.758Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty