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-1423882026-08-16T13:44:40ZTucker, Joyce B.——1950-08-04UHC-62211-22•••-••-1116—JOYCE.TUCKER@AOL.COM3464 VALLEY VIEW DRLos AngelesCA90058GRP-6365OPTIONS-PPO
ENRENR-1281782026-02-28T04:03:38ZSusanEMaldoando·1997-06-14UHC-18643-63——SUSAN.MALDONADO42@AOL.COM1448 CAMELBACK RDMiami··FL33129GRP-3267CHOICE-PLUS-PPO
ENRENR-1087202026-06-02T05:29:48ZSchmidt, GaryU—19661222UHC-93699-20•••-••-28849088961016gary.schmidt@aol.com5966 PALM DRIVE Apt 15TucsonAZ85794GRP-3264CORE-HMO
ENRENR-1046322026-07-13T13:36:50ZpaulPwood1978-05-20·UHC-52440-42•••-••-5761·+1 390 827 3666PAUL.WOOD63@AOL.COM3803 MEADOW LANE··Las VegasNV89135GRP-3279CHOICE-PLUS-PPO
ENRENR-1142292026-06-15T20:31:49Z Megan—Alvaarez13-03-1971UHC-43589-86•••-••-7122985-399-7516N/A2579 Central AveNashvilleTennessee37245GRP-7985options-ppo
ENRENR-116000 2026-01-26T10:47:48ZHiroshiS.Martinez1940-68-27UHC-93735-65•••-••-6880374-214-9810N/A5606 MEADOW LNMinneapolisMN55435GRP-9256MEDICARE-ADV-A
ENRENR-1077322026-04-29T13:20:25ZAnna····Gonzlez1985-04-25UHC-97937-83•••-••-8087666.220.6891N/A425 Elm StDENVER··co80241-4108GRP-4171OPTIONS-PPO
ENRENR-1308912026-08-25T03:39:34ZMcCoy, ChristianL····1971-21-15UHC-69126-94—414-254-0815christian.mccoy4@hotmail.com3749 Park PlaceLOS ANGELESCalifornia90076GRP-4682choice-plus-ppo
ENRENR-1388402026-06-04T02:01:32ZGRACE Q··—FISHERSep 17, 1943UHC7206967•••-••-1832·271.526.0580—6276 River Road #470LAS VEGASNV89102-3901GRP-4858·OPTIONS-PPO
ENRENR-1173342026-10-05T17:48:31Zjeffrey··X.black1992-05-01UHC-17754-36•••-••-2575null—4422 Palm DriveEDEN PRAIRIE·MN55307GRP-0447SELECT-EPO
ENRENR-1411722026-09-27T05:36:38Z·Doris—Tucker1951-04-18UHC-44970-38•••-••-8951745.336.8473DORIS.TUCKER@GMAIL.COM8068 BroadwayMiamiFL33128GRP-1062MEDICARE-ADV-A
ENRENR-1279772026-05-02T22:24:52ZPatricia—Perry··04-08-1975UHC-59294-16•••-••-5862+1 332 556 1529PATRICIA.PERRY@AOL.COM6200 Grand AvenueLas VegasNV89114-3735GRP-5003MEDICARE-ADV-A
ENRENR-1006062026-08-10T04:54:46Z HaroldNSullivan··21-06-1988UHC-57858-73•••-••-3696—N/A7597 PINE DR··San Antonio··TX78205GRP-4431OPTIONS-PPO
ENRENR-1204472026-05-16T12:36:50ZAustin·UAnderson1993-01-25UHC-07476-49•••-••-6587(402) 699-8540austin.anderson@proton.me8521 Canyon RdGlendaleAZ85340GRP-7209CORE-HMO
ENRENR-1099422026-05-25T19:55:03ZLORI··I.DUNCAN·07/06/51UHC-68266-89•••-••-2610927-452-7067LORI.DUNCAN79@PROTON.ME7113 HARBOR BLVD Apt 4Eden PrairieMN-GRP-6220CORE-HMO
ENRENR-1214892026-09-02T18:35:57ZnaancyM.pierce1952-06-26NULL•••-••-27726417254685N/A6321 Willow CtNashville··tn37226GRP-1845MEDICARE-ADV-B
ENRENR-1058132026-03-25T23:08:51ZIsabellaSSoto2005-08-09UHC-90755-39•••-••-4109(240) 737-8770ISABELLA.SOTO25@AOL.COM6725 Indian School RoadDenverCO80272-3298GRP-1829OPTIONS-PPO
ENRENR-1021962026-09-01T10:37:07ZHenry—Johnson5/16/1964UHC-14151-09•••-••-6216(813) 662-1793henry.johnson@yahoo.com781 Camelback RdHOUSTONTX77030··GRP-3462OPTIONS-PPO
ENRENR-1343932026-01-12T20:01:43ZAndrea—Chavez8/10/1962UHC-71772-06•••-••-6147289-779-2417andrea.chavez@aol.com·2030 MOUNTAIN VIEW DRTempeArizona85276GRP-4562·CHOICE-PLUS-PPO
ENRENR-1264522026-08-19T14:10:57ZLINDAM·STONE1398-10-05UHC-41475-82•••-••-3290(647) 482-8574LINDA.STONE84@AOL.COM1551 Market StNashvilleTN37248GRP-8306NAVIGATE-HMO
ENRENR-1124142026-01-21T15:42:05ZGEORGE··—LAWSON1998-11-03UHC-33442-55•••-••-1727377-774-3624—4710 Palm Dr·MesaAZ85293GRP-0466SELECT-EPO
ENRENR-116813 2026-01-03T09:20:31ZCHRISTINA—LARSON1990-12-21UHC-21863-98•••-••-1250502-938-1430—3967 Sage CtNashvilleTN·37276-8771GRP-0198MEDICARE-ADV-A··
ENRENR-1088832026-02-01T00:40:13ZteresaOhunt1976-08-13UHC-72508-09•••-••-3422+1 809 807 7514—·6343 Lake View RoadChandlerAZ85206··GRP-6907MEDICARE-ADV-A
ENRENR-1008362026-02-23T12:05:30ZHaroldEMartin1989-10-04UHC2202009•••-••-3518890-267-1945HAROLD.MARTIN79@HOTMAIL.COM1613 Highland AveSeattlewa98125GRP-0217MEDICARE-ADV-B
ENR ENR-1057772026-08-31T06:53:22ZJoeSKing1995-08-07UHC-65740-09—+1 671 227 6812·joe.king91@yahoo.com265 Palm DrMiamiFL33154GRP-0456MEDICARE-ADV-B
ENRENR-1271592026-01-13T21:12:47ZRalph—Nichols1962-06-14UHC-69144-34··•••-••-2636N/Anull5689 Lincoln Way··ChandlerAZ85269GRP-0944CHOICE-PLUS-PPO
ENRENR-1372342026-07-26T09:41:18ZEric—Simmons1978-05-13UHC-98882-06•••-••-5695+1 353 401 4020ERIC.SIMMONS51@AOL.COM4431 LAKE VIEW ROADTampaFL33635-3698GRP-9293OPTIONS-PPO
ENRENR-1068582026-03-08T23:37:09ZVictoria—Hawkins·1973-05-10UHC-52836-55null7752165799··VICTORIA.HAWKINS42@YAHOO.COM3400 Baseline RdHoustonTX77040GRP-2849select-epo
ENRENR-1407262026-02-06T07:27:49ZMADISONDSPENCERJan 18, 1973UHC-73285-94•••-••-4027·-—8387 RIVER ROADDenverCO80217GRP-3454OPTIONS-PPO
ENRENR-1394282026-07-31T13:20:27ZdianeCwheeler1977-09-26UHC-84562-69•••-••-8996711-349-2270DIANE.WHEELER@PROTON.ME7864 Valley View DrLos AngelesCA90018GRP-7379OPTIONS-PPO
ENRENR-1416692026-07-18T05:31:34ZHirshiB.Day02-11-1998·UHC5015263•••-••-241312143366818NULL··9870 Apache BlvdMESAAZ85278GRP-7800·CHOICE-PLUS-PPO
ENRENR-1188732026-05-31T09:47:31ZKevinP—15-12-1961UHC-11236-73•••-••-5731667.685.9604-2062 Camelback RdLOS ANGELESCA90030GRP-7097OPTIONS-PPO
ENRENR-1130152026-08-19T07:01:51Z RonaldSHunt02/09/1965UHC8517859··•••-••-1407UNKNOWNRONALD.HUNT@OUTLOOK.COM2077 Ridge RoadScottsdaleAZ85276-6795GRP-6547MEDICARE-ADV-A
ENRENR-1024982026-04-22T00:55:02ZJONATHAN—CARPENTER10/11/1954UHC-03451-44—6283875477JONATHAN.CARPENTER19@PROTON.ME5852 River RoadMINNEAPOLISMN55429-2934GRP-7000NAVIGATE-HMO
ENRENR-1220402026-08-15T14:57:34ZVincentPSantiago19451020UHC-71651-40•••-••-41945918694351vincent.santiago@yahoo.com··7380 OCEAN AVENUEAtlantaga—GRP-5553OPTIONS-PPO
ENRENR-1078542026-07-19T16:15:35ZJudy—Wells1/11/1938UHC-84471-03•••-••-6438287-200-5196-9036 VALLEY VIEW DRTempeAZ85211GRP-7168NAVIGATE-HMO
ENRENR-1194202026-05-27T02:17:08ZamberHbrown·1983-07-08UHC3154262•••-••-5696nullamber.brown41@yahoo.com2625 Bayshore DrCharlotteNC28214GRP-4120··NAVIGATE-HMO
ENRENR-1302062026-01-10T16:51:24ZMARYCFERGUSON1953-05-16UHC-59478-04•••-••-74175309659null9096 Park PlATLANTAGeorgia30358-0919GRP-1420MEDICARE-ADV-A
ENRENR-1063052026-06-22T21:31:47Z Justin·DEvansJun 1, 1968UHC2575507•••-••-7799NULLUNKNOWN4255 Apache Boulevard·DENVERCO80200GRP-2847NAVIGATE-HMO
ENRENR-1139032026-02-15T04:11:08ZNathanMWilson10/13/2007··UHC-55606-82•••-••-5463882-588-9225null8326 River Road #910MIAMIFL—GRP-1084CORE-HMO
ENRENR-1354522026-03-05T18:59:32ZGrace—Kelly2002-08-01UHC-84253-82•••-••-0705NULL·grace.kelly54@hotmail.com5491 Lake View Road·NashvilleTN37271GRP-8504CHOICE-PLUS-PPO
ENRENR-1125852026-06-05T10:22:22Zroy—crawfordJul 27, 1991UHC8479441•••-••-42173048425311ROY.CRAWFORD@YAHOO.COM6673 Oak StreetSEATTLE···WA98175GRP-7045OPTIONS-PPO
ENRENR-1063822026-04-28T19:37:10ZDiane—Banks1988-03-16·UHC-73559-24•••-••-86635945701698diane.banks82@icloud.com··8353 OCEAN AVEOrlandoFL32873-4553GRP-2045medicare-adv-a
ENRENR-1002702026-04-19T04:52:24ZLarrySChapman··12/11/72uhc-59123-12•••-••-61876886345636larry.chapman@outlook.com1882 Baseline Road·JacksonvilleFL32200GRP-0775NAVIGATE-HMO
ENRENR-1062572026-07-28T01:58:46ZKATHERINE··KNIGHT03/26/01UHC-38850-15•••-••-06498915077707·-4472 Highland AveLas VegasNV89186GRP-5539SELECT-EPO
ENRENR-1349542026-03-03T06:55:05Zdenise—carroll1969-10-11UHC-30539-11•••-••-9871(552) 733-0564DENISE.CARROLL@PROTON.ME518 Oak StTampaFL··33603GRP-7434NAVIGATE-HMO
ENRENR-1035462026-04-18T17:03:24ZSantiago, GeraldL—1972-10-13UHC-21748-46•••-••-5677345-476-5761gerald.santiago@gmail.com743 Oak StreetHoustonTX77077GRP-3827CORE-HMO
ENRENR-1273122026-03-09T22:39:05ZTeresa—Delgado02/04/1950UHC-40854-32•••-••-4979540.565.0622teresa.delgado74@hotmail.com325 RIDGE ROADGLENDALEAZ··85386GRP-5086SELECT-EPO
ENRENR-1257742026-10-09T23:54:23ZMaryP.Franklin1942-09-17UHC-63571-51•••-••-6455nullMARY.FRANKLIN78@GMAIL.COM728 Washington StreetAustinTXN/AGRP-1552SELECT-EPO
ENRENR-1045222026-03-29T11:46:43Z·WillieRTorres1979-07-09UHC-44435-18•••-••-9280·530.385.8684willie.torres67@outlook.com3439 VALLEY VIEW DRIVETampaFL·33603-5533GRP-3022CORE-HMO
43,101 rows, page 164 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.493Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty