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-1282692026-06-24T07:54:51Z·TERRY·LLI1965-05-07UHC-83597-11—4623377466terry.li@gmail.com·8628 Oak StreetSan Antoniotx78245-2788GRP-5732··NAVIGATE-HMO
ENRENR-1084952026-05-21T21:58:03ZSCOTTV.MURPHY09/04/72UHC-27325-61—(392) 587-4982scott.murphy89@yahoo.com5024 Mountain View DrSeattleWA98191GRP-8217OPTIONS-PPO··
ENRENR-1019792026-04-29T18:56:32ZSophiaDHanson26-04-1969UHC-82823-46•••-••-4790323-654-0001sophia.hanson@yahoo.com975 WASHINGTON STNashvilleTN37283··GRP-9512OPTIONS-PPO
ENRENR-1100252026-06-12T02:43:42ZBETTTYK.··BUTLER1956-11-26UHC-72899-24•••-••-3003578-632-9064BETTY.BUTLER@GMAIL.COM1390 Jefferson AveDallas··TX75228GRP-5697MEDICARE-ADV-A
ENRENR-1192242026-08-22T21:24:18Z FRANCES Z.—LUNA12/16/01UHC-25455-90·null13867086336··frances.luna36@outlook.com··2882 CANYON ROADGilbert··AZ85271·GRP-5627OPTIONS-PPO
ENRENR-1228332026-05-31T01:22:28ZMarkRGibson·Apr 26, 1988—•••-••-5235550-416-6387mark.gibson@outlook.com7145 Oak StreetFresnoCA93769GRP-9815CORE-HMO
ENRENR-1159222026-02-10T07:30:09ZWALTERLALVAREZ1941-06-02UHC-32233-17•••-••-7106(375) 379-0045walter.alvarez64@proton.me··4448 SAGE CTHoustonTexas77031GRP-7948··NAVIGATE-HMO
ENRENR-1026972026-10-16T20:18:03ZSANDRA—ELLIS2003-08-04uhc-11149-53UNKNOWN8285760353—6392 WILLOW CTLas VegasNV89190GRP-5224CORE-HMO
ENRENR-137116 2026-09-02T03:22:53ZgraceFduncan1999-06-14UHC-41719-75•••-••-6317590-525-1892grace.duncan95@gmail.com6527 HARBOR BOULEVARDOrlandoFL32879GRP-7280SELECT-EPO
ENR ENR-1068772026-04-09T01:50:49ZKevinNHarper1974-04-01UHC-16539-19•••-••-81026918473856kevin.harper@hotmail.com6084 Church StreetChandlerArizona85229GRP-3334NAVIGATE-HMO
ENRENR-1176532026-05-18T05:53:00ZCARLZALLEN9/6/1998UHC-59779-26•••-••-27048453133494carl.allen84@yahoo.com6680 MEADOW LNNASHVILLETennessee37208GRP-4068MEDICARE-ADV-A
ENRENR-1031712026-08-04T13:01:39Z·KARENR··SIMSPON1987-05-91null—8737022189karen.simpson74@outlook.com7760 APACHE BOULEVARDSan AntonioTX78249GRP-1508MEDICARE-ADV-A
ENRENR-1215842026-02-21T20:12:56ZEDDIEU··PEREZ1991-12-18UHC-95876-47•••-••-4219(585) 737-3628N/A3648 Willow CtMiamiFL33124GRP-3750CHOICE-PLUS-PPO
ENRENR-1122992026-03-22T14:31:35ZCYNTHIAIDIAZ12/2/2002·UHC-72241-56—8586064607—4342 BASELINE RDDENVERColorado80274GRP-1103SELECT-EPO
ENRENR-1199522026-04-29T11:16:08ZMARCUSVCARR10/28/1942UHC-56477-42-··457-414-9849UNKNOWN2952 Jefferson AveTampaFLnullGRP-8495CHOICE-PLUS-PPO
ENRENR-1143502026-09-13T14:52:57ZDANIELLEKROBERTSON15-12-2008UHC-32774-59•••-••-2155·nulldanielle.robertson@hotmail.com6845 SUNSET BLVDSan AntonioTX78258GRP-2807··MEDICARE-ADV-B
ENRENR-1318912026-06-15T17:23:07ZGREGORYWKELLEY·19700612UHC-38186-66•••-••-51148648333370gregory.kelley68@yahoo.com4795 Maple AvenueHoustonTX77030-0475GRP-8662CHOICE-PLUS-PPO
ENRENR-1041842026-06-18T20:00:40ZSTEPHANIEMBENENTT20020507UHC-32027-03NULL374-293-4595stephanie.bennett86@yahoo.com··6817 PALM DRIVEChandlerAZ85238GRP-6145·MEDICARE-ADV-A
ENRENR-1148012026-05-12T15:47:18Z—J—19431203uhc-02814-75—UNKNOWNeugene.mejia@hotmail.com5104 Union StreetGilbertAZ85211GRP-7137MEDICARE-ADV-B
ENRENR-1041892026-03-05T08:34:40ZWelch, Gabriel——Jul 6, 1959UHC-11795-17•••-••-9589431-696-3094··9743 River RdCharlotteNC28272GRP-1256medicare-adv-b
ENRENR-1070482026-07-20T17:36:08ZDanielleM.Parker1/3/1958UHC-09719-62•••-••-8838912-618-6315danielle.parker80@yahoo.com1498 Lincoln WayAtlantaGA30340GRP-9346core-hmo
ENRENR-1352982026-02-06T06:13:17ZPATRICIA··—HICKS1966-10-27UHC3117167•••-••-9349352-352-6443patricia.hicks@yahoo.com3016 Palm DriveMinneapolisMN55461GRP-2598CHOICE-PLUS-PPO
ENRENR-136614 2026-09-07T23:36:28ZADAMHRICHARDSON06/06/2007UHC-32993-82null(260) 787-5632UNKNOWN2299 SAGE CTDenverCO80210GRP-7775CHOICE-PLUS-PPO
ENRENR-1300452026-02-22T19:58:34Z·LoganW·Simmons1959-06-11UHC-67698-28•••-••-45669247951154LOGAN.SIMMONS35@GMAIL.COM8239 Forest AveFresnoCA93786GRP-8543NAVIGATE-HMO
ENRENR-1149502026-04-16T08:10:55Zjake—welch1958-01-25UHC-92655-20•••-••-81318376106jacob.welch85@proton.me1663 Highland AvenueJacksonvilleFlorida32216GRP-4490MEDICARE-ADV-B
ENRENR-1233742026-08-11T18:35:49ZZacharyF·Rios1949-06-20UHC-47072-78··•••-••-93296982184977ZACHARY.RIOS40@OUTLOOK.COM7635 Oak StreetHoustonTX77020GRP-7232CORE-HMO
ENRENR-1098412026-04-17T06:29:51ZSandraD.··Richardson1962-02-11UHC-75842-41•••-••-1614(280) 320-2546sandra.richardson@aol.com1935 Baseline RdAtlantaGA30374GRP-4695options-ppo
ENRENR-1008342026-02-28T10:17:52ZdenseL.thomas·1973-08-10UHC-85521-23UNKNOWN646-439-6033—4469 Union StreetSeattle··Washington98191GRP-6234CHOICE-PLUS-PPO··
ENRENR-1245242026-03-24T22:13:48ZGERALDJHARRIS··08/15/1949—•••-••-0855(725) 836-7025GERALD.HARRIS11@ICLOUD.COMnull—NULL—GRP-1922·CORE-HMO
ENRENR-1419852026-10-02T05:07:43Z·Arthur—Oliver19-07-1972uhc-81066-86•••-••-1359UNKNOWNarthur.oliver14@gmail.com3820 Mountain View DriveMinneapolis··MN55472GRP-9507options-ppo
ENRENR-1159862026-10-05T10:23:49ZROGERARODRIGUEZ·03/28/56·UHC-43606-52•••-••-6292·866-740-0237roger.rodriguez67@gmail.com7531 Valley View DrFRESNOCA93740GRP-7193MEDICARE-ADV-B
ENRENR-1040372026-10-10T04:43:52ZAndrew—Little1958-05-10UHC-87409-19N/A·5946673145—·7294 Spring StreetChandlerAZNULLGRP-7751OPTIONS-PPO
ENRENR-1129072026-02-02T05:34:11ZKIMBERLY—REID28-08-1948UHC-41007-29•••-••-12285633838null3771 Lincoln WayOrlandoFL32854GRP-1350SELECT-EPO
ENRENR-1043452026-03-24T09:39:28ZAnnMDominguez12/03/59UHC8901357•••-••-6785551-205-4811····2671 GRAND AVE·Los AngelesCA···90042GRP-0198··SELECT-EPO
ENRENR-1301932026-08-25T19:20:09Z———6/17/2004UHC-98575-87•••-••-8264+1 472 307 4932KATHRYN.GREENE@ICLOUD.COM7028 River RoadSACRAMENTOCA95826GRP-5139SELECT-EPO
ENRENR-1327562026-10-18T23:17:47ZDebraNSchmidt1941-08-21UHC3918252•••-••-3056678-512-9037·debra.schmidt25@gmail.com1984 JEFFERSON AVENUETEMPEAZ··85232GRP-3282CORE-HMO
ENRENR-1300682026-10-06T18:17:27ZAnna R—Wong03/16/07UHC-73396-71•••-••-5880(722) 660-6277anna.wong71@aol.com9280 VALLEY VIEW DRIVE··JacksonvilleFlorida32203GRP-2319NAVIGATE-HMO
ENRENR-118359 2026-02-04T06:42:36ZJOE—WRIGHT1992-06-04UHC-08635-40—687-596-5982joe.wright13@icloud.com907 APACHE BLVDGilbert·AZ85291-2044GRP-9289navigate-hmo
ENRENR-102056 2026-02-24T01:06:48ZRussell—Grant1963-06-03UHC-75264-90•••-••-0180238-836-3005NULL8259 HIGHLAND AVENUE Apt 9AtlantaGA30307GRP-7196MEDICARE-ADV-B
ENRENR-1408062026-04-12T01:26:21ZBrenda—Carpenter1992-02-15UHC-00720-73•••-••-6097945-739-9328BRENDA.CARPENTER28@HOTMAIL.COM7814 Willow CtColumbusOH43217GRP-4387MEDICARE-ADV-B
ENRENR-1055932026-06-09T08:42:39ZJames—Cunningham9149-02-15UHC-68874-94•••-••-5012-james.cunningham@gmail.com7014 DESERT SKY BLVDDENVER·co80253GRP-6829CORE-HMO
ENRENR-1257122026-01-27T04:05:10ZHenderson, LindaU··—1943-03-26UHC3829771•••-••-7574828-510-7565linda.henderson11@outlook.com9100 VALLEY VIEW DRFRESNOCA93721GRP-6877SELECT-EPO
ENRENR-1025292026-04-26T19:24:28ZJOYCE—HILLDec 15, 1955UHC-71337-24•••-••-3948430.408.0892·joyce.hill@gmail.com4645 PARK PLACEScottsdaleAZ·85281GRP-4238MEDICARE-ADV-B
ENRENR-1000632026-04-20T21:54:11ZDianeI.Lee1970-01-11UHC8347291•••-••-446318387724725N/A4401 Sunset BoulevardSCOTTSDALEArizona85200GRP-5452MEDICARE-ADV-B
ENRENR-1252272026-09-15T06:02:25ZJeanW.Castro1939-07-27UHC2684981•••-••-2423675-625-4613—4619 Hillcrest RdChandler··AZ85284GRP-4754CHOICE-PLUS-PPO··
ENRENR-1080182026-10-18T05:59:19ZADAMR.COLLINS1975-06-08UHC-14438-70•••-••-0906+1 399 584 8023adam.collins35@hotmail.com2667 Canyon RoadTucsonAZ85765·GRP-6152MEDICARE-ADV-B
ENRENR-1312952026-07-29T02:40:26ZRALPH—BURKE1945-09-14UHC-17176-96null(266) 235-3641N/A7792 Lake View RdDenverCO80262GRP-1229NAVIGATE-HMO
ENRENR-1176592026-07-09T08:21:56ZTerry—Gomez1977-04-19UHC-39043-39•••-••-642919598951396N/A3153 Washington StreetSan DiegoCA92183GRP-9033OPTIONS-PPO
ENRENR-1147332026-05-17T23:59:19ZpeterI.·mccoy2000-04-02UHC-64916-39··•••-••-2588879-988-4815peter.mccoy14@yahoo.com3108 DESERT SKY BLVDColumbusOH43270GRP-9009MEDICARE-ADV-B
ENRENR-1200082026-08-25T18:22:03Z Carter·XWalter2003-10-18UHC-65203-16•••-••-7846·7006404970WALTER.CARTER@YAHOO.COM··2950 Bayshore DrAustinTX78708GRP-7894CORE-HMO
43,101 rows, page 175 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.307Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty