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-1166932026-04-17T01:31:47ZBrittanyQHoward1971-12-11UHC-13531-12•••-••-2334270-317-0367··UNKNOWN5011 Lincoln WayTampaFL33625GRP-9702SELECT-EPO
ENRENR-1027452026-04-05T22:29:19ZGREGORYOESTRADA1957-04-09UHC-62694-94•••-••-1236769-341-5761GREGORY.ESTRADA34@YAHOO.COM3921 CEDAR LANE··SAN ANTONIOTexas78259GRP-6455NAVIGATE-HMO
ENRENR-1228842026-06-18T09:58:17ZShirley····Griffin··9/22/2008··UHC-80810-02•••-••-9072-··shirley.griffin@icloud.com3836 OAK STREETDenverco80262GRP-9229MEDICARE-ADV-B
ENRENR-1057472026-09-04T02:14:30ZZACHARY—GIBSON1951-08-11uhc-37202-19•••-••-6989248-281-2743zachary.gibson18@proton.me4400 Church StreetAtlantaGA··30373GRP-7782MEDICARE-ADV-A
ENRENR-1120432026-07-18T12:27:06ZTerry——1967-05-21·UHC-10965-56UNKNOWN··(294) 209-9762·terry.owens22@hotmail.com2368 Camelback Road·MESA·AZ85231GRP-1315OPTIONS-PPO
ENRENR-1276032026-09-12T21:05:55ZAliceDWebb1998-06-27UHC-71391-15•••-••-4100558-692-9010-2190 Oak StCharlotte··NC28256GRP-3189OPTIONS-PPO
ENRENR-1362922026-03-05T06:14:00ZAnnDLynch1940-08-02UHC-25951-49null964-361-9420ann.lynch24@proton.me4782 CAMELBACK ROADAustinTX78741GRP-6200medicare-adv-a
ENRENR-1417912026-03-14T23:17:10ZJenniferR.Gordon2002-07-06··UHC-37220-36•••-••-765012845846813-4519 Bayshore DrivePlanotx75068GRP-4029SELECT-EPO
ENRENR-1187952026-06-25T06:44:44ZmarcusJlewis1945-02-07uhc-54523-19•••-••-5010(754) 918-5266marcus.lewis27@aol.com4802 JEFFERSON AVETampaFL33648GRP-8436CORE-HMO
ENRENR-1073402026-08-01T22:24:28ZGeorgePSanchez··1978-02-18UHC-41321-44•••-••-29759833465UNKNOWN2945 Elm StMiamiFL33182GRP-3875MEDICARE-ADV-B
ENRENR-1322552026-07-26T20:26:27Zkevin—moralesJun 13, 2005UHC-41017-23•••-••-8395(906) 953-9933kevin.morales@hotmail.com8345 PARK PLACESACRAMENTOCA95808GRP-0951CORE-HMO
ENRENR-1120302026-09-16T02:34:40ZAlbert—Wilson09/04/1948UHC-98937-02•••-••-378212526421147—143 Meadow LaneFRESNOCA·93764·GRP-6056MEDICARE-ADV-A
ENRENR-1409892026-08-26T23:22:03ZDIEGOU.COLLINS2006-12-06UHC-59837-42•••-••-0091(706) 579-4686—1389 Lincoln Way··PlanoTexas75034GRP-4517MEDICARE-ADV-B··
ENRENR-1267882026-01-23T11:35:00ZHeather—Fernandez··1958-05-14UHC-87094-80•••-••-3780NULLheather.fernandez16@aol.com9753 OCEAN AVENUE·TucsonAZ85727GRP-2592MEDICARE-ADV-A
ENRENR-1233182026-05-20T10:03:08ZAUSTIN—COLLINS05-05-1991UHC5338399•••-••-901117468522077—8323 Willow CtTempeAZ85223GRP-5235·MEDICARE-ADV-A
ENRENR-1262172026-01-11T21:45:50ZkathrynYrobinson1968-05-13·UHC-69124-67•••-••-2121(747) 341-4516kathryn.robinson@yahoo.com8157 RIDGE RDCharlotteNC28201GRP-7620CORE-HMO
ENRENR-1032582026-04-27T14:24:25ZLucia—Hansen1985-01-22UHC-40817-20··•••-••-8322nulllucia.hansen@outlook.com671 Maple AvenueMesaAZ85293GRP-9331CORE-HMO
ENRENR-1403122026-02-26T14:40:01Z·RachelORojas2007-08-26UHC-21426-68•••-••-7213505-350-6039··—3025 PINE DRIVEPhoenixAZ85077GRP-1330NAVIGATE-HMO
ENRENR-1365622026-05-20T12:33:01Zdouglas—rios1965-06-02UHC-76638-39—4699126999douglas.rios@aol.com8626 Valley View DrAtlantaGA30303GRP-2647MEDICARE-ADV-A··
ENRENR-1056372026-01-02T20:42:25ZAlexander—Morrison·1945-12-23UHC-72453-69•••-••-75257628921689null7056 Cedar LnChandlerAZ85200GRP-0488··SELECT-EPO
ENRENR-1229392026-09-10T14:25:41ZNICHOLASI.MONTGOMERY·1976-12-24UHC-07349-58•••-••-9889(274) 721-7289nicholas.montgomery@proton.me8660 Baseline Road #774San AntonioTX78250GRP-3974SELECT-EPO
ENRENR-1426582026-04-21T04:54:01ZLAURA—TORRES·1972-04-11UHC-50103-28NULL——3253 WILLOW CTCOLUMBUSOH43286GRP-4752SELECT-EPO
ENRENR-1319522026-01-30T19:47:46ZlawrenceW.·ortiz03/25/1977UHC5447749•••-••-6763(370) 853-5280lawrence.ortiz19@hotmail.com3355 HIGHLAND AVENUE·DallasTX·75249GRP-2510MEDICARE-ADV-B
ENRENR-1038512026-01-05T15:15:13ZRANDY—NUNEZ··1979-06-01UHC-77425-69•••-••-6683337-939-4445RANDY.NUNEZ@HOTMAIL.COM5412 Ocean AveMesaAZ85248-4914GRP-5719OPTIONS-PPO
ENRENR-1119092026-04-08T10:36:16Z Yuki—Morgan08/20/54·UHC-00518-72•••-••-5164(707) 859-2438-8337 Desert Sky BoulevardLAS VEGASNV89187GRP-4513MEDICARE-ADV-A··
ENRENR-1092792026-04-04T09:49:19ZEmmaITucker1955-10-18UHC6704513•••-••-47083596116766UNKNOWN4116 MARKET STREETMesaAZ85245GRP-3780SELECT-EPO
ENRENR-1069262026-01-24T16:40:13ZRoySHart··17-12-2003UHC-01817-60•••-••-9402(954) 955-8889ROY.HART1@HOTMAIL.COM9755 Lincoln WayLas VegasNV89171GRP-5462NAVIGATE-HMO
ENRENR-1361912026-03-15T12:06:25ZFrancesV.Campbell9/16/1992UHC-98486-22•••-••-8032(456) 699-2135FRANCES.CAMPBELL61@AOL.COM94 Washington StreetAustinTX78717GRP-0138CORE-HMO
ENRENR-133040 2026-03-25T19:56:47ZMADISON—RUSSELL1985-20-24UHC-55697-51NULL2472185779madison.russell@proton.me7334 Mountain View DriveTucsonArizona85706GRP-2791MEDICARE-ADV-B
ENRENR-1191932026-09-02T21:20:05Zsantiago·Mwoods1999-07-20UHC-32440-04•••-••-1829657-893-5566santiago.woods46@aol.com8090 LAKE VIEW RDChandlerArizona85278-8547GRP-3762CHOICE-PLUS-PPO
ENRENR-1242252026-01-20T15:17:50ZmarthaT.castro4/1/1983UHC-41311-30•••-••-6573+1 220 706 5826martha.castro@proton.me5565 HILLCREST ROADNashville··TN37234GRP-3688SELECT-EPO
ENRENR-1215672026-07-22T15:33:18ZCHRISTIAN—REID1972-02-24UHC-73377-60•••-••-0573(621) 412-5299christian.reid@icloud.com1703 Broadway··MiamiFlorida33157-3637··GRP-8740MEDICARE-ADV-B
ENRENR-1423752026-03-30T02:11:30ZValentina····Mitchell··Mar 3, 1974UHC-16459-16•••-••-640719333637871valentina.mitchell@hotmail.com7778 JEFFERSON AVEGLENDALEAZ85337GRP-4367CORE-HMO
ENRENR-1015322026-01-14T12:53:44ZValentina····LunaAug 21, 1960UHC-30298-37··•••-••-6280663.552.0959VALENTINA.LUNA8@ICLOUD.COM3039 CAMELBACK RDTUCSONAZ85774GRP-5152choice-plus-ppo
ENRENR-1183042026-08-29T20:55:48ZKAYLA····WATKINS1977-02-06UHC-05998-73—2799958588N/A···5154 Harbor BlvdMesaaz85267GRP-4197MEDICARE-ADV-B
ENRENR-1070692026-06-21T17:21:57ZLarson, Natalie··——01/13/1999UHC-29101-12•••-••-592317118741072NULL199 Grand AvenuePlanoTX75040GRP-5586SELECT-EPO
ENRENR-1208862026-07-10T06:34:57ZCHRISTOPHER—SELAZAR1939-11-19UHC-82640-62•••-••-5883—·christopher.salazar@proton.me9187 Ocean AvenueMesaaz85210GRP-3395MEDICARE-ADV-B
ENR ENR-1204292026-01-11T17:42:57ZAna—Gordon1963-10-01UHC-86380-25•••-••-7108·6409673282—1672 Bayshore DrAtlantaGA30369GRP-3675OPTIONS-PPO
ENR ENR-1409202026-01-16T01:37:02ZtimothyHpayneJul 1, 1958UHC-91578-40•••-••-113317537131376N/A4969 Harbor BoulevardScottsdaleaz85275GRP-0398··choice-plus-ppo
ENRENR-1152452026-02-26T16:21:03ZHELENFCHAVEZ2002-04-19UHC-70047-85•••-••-34873097594128helen.chavez@yahoo.com8547 SPRING STREETEden PrairieMNNULLGRP-3467CHOICE-PLUS-PPO
ENRENR-1240522026-05-07T18:44:42ZLaura—Chavez2006-02-02UHC-80393-56•••-••-4664(832) 590-5377··laura.chavez@yahoo.com··1179 LAKE VIEW ROADDenverCO·80251-1088GRP-3854options-ppo
ENRENR-1011902026-06-26T04:17:30ZDENNISK.KELLEY09-11-1952UHC-12201-17•••-••-3457557-523-4001dennis.kelley57@outlook.com9006 MAIN STSan Diego·CA92112GRP-9425MEDICARE-ADV-B
ENRENR-1228712026-10-03T20:24:28ZDianeUKim22-07-1961UHC-20211-16•••-••-2907—null7258 Spring StLos AngelesCA90069GRP-6316MEDICARE-ADV-A
ENRENR-123033 2026-07-06T23:09:26Z·judithKmills1958-12-16UHC-88403-43•••-••-7132871-294-2022judith.mills62@outlook.com2350 Mountain View DriveFresnoCA93714·GRP-3330MEDICARE-ADV-A
ENRENR-1075502026-08-01T13:34:30ZOBrien, JacobM—07/03/1949UHC-92455-51•••-••-70136794331722··9669 Mountain View DrJacksonvilleFL32281GRP-4965MEDICARE-ADV-A
ENRENR-1204222026-02-08T14:21:07Z hannahG.arnold6/17/1963UHC-27042-68•••-••-8648888-529-4994hannah.arnold@icloud.com·9533 Indian School RdChandlerArizona85278GRP-3929NAVIGATE-HMO
ENRENR-111204 2026-04-21T17:00:22ZGREGORY—MARTINEZ1950-05-21UHC-78137-30•••-••-3530(803) 337-7345null4284 JEFFERSON AVELAS VEGASNV89172-9976GRP-3124CORE-HMO
ENRENR-1028902026-01-15T08:51:06Zcamila—snyder1953-12-15UHC-87849-68—341.991.9078camila.snyder97@outlook.com5462 UNION STREETAustinTX78776-6354GRP-0995MEDICARE-ADV-A
ENRENR-1030692026-10-06T07:17:58ZRYAN—·BOYD1998-11-04UHC-38023-85•••-••-3975—ryan.boyd62@yahoo.com3945 SAGE COURTMesaAZ85265GRP-8661SELECT-EPO
ENRENR-1049932026-07-15T08:21:05ZFatimaTGreen··Jan 19, 1971UHC-56858-96•••-••-8403(897) 585-5235fatima.green@aol.com764 RIVER ROADMinneapolisMN55442GRP-5477MEDICARE-ADV-B
43,101 rows, page 187 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.324Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty