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-1207202026-01-29T02:56:30ZHEATHER·ONELSON1940-11-28UHC-84664-95··UNKNOWN12065068086—·5571 Oak StAtlantaGA·30361GRP-4263MEDICARE-ADV-A
ENRENR-1401592026-06-15T19:29:41ZSOPHIAJPATEL2007-09-07UHC7467441····4509419466··SOPHIA.PATEL68@OUTLOOK.COM6789 Apache BlvdDenverColorado80206GRP-6010MEDICARE-ADV-A
ENRENR-1170452026-04-05T05:54:19ZCynthiaV.Bizhop1951-04-07UHC-54775-24•••-••-9509+1 551 578 9837cynthia.bishop@hotmail.com7228 Mesa DriveMesaAZ85279GRP-3835··SELECT-EPO
ENRENR-1426802026-01-02T18:30:58Z·evelyn—frnaklin·1956-10-02UHC-47615-63•••-••-5678(731) 385-2638-5532 Cedar LaneMesaArizona85268GRP-1188MEDICARE-ADV-B
ENRENR-1054722026-03-04T20:33:20ZCAROL—PERRY1987-06-27UHC-00745-17•••-••-702516725718460carol.perry@hotmail.com2551 Washington StreetPLANOTX75043GRP-8644··CHOICE-PLUS-PPO
ENRENR-1010162026-06-03T06:34:08ZKenneth—Stewart19905325UHC-42668-04··•••-••-11832322345091·kenneth.stewart26@yahoo.com2211 MESA DRIVEDenverCO80273GRP-8077CHOICE-PLUS-PPO
ENR ENR-1050862026-08-26T00:26:07Z HAROLDYFERGUSONOct 17, 1985UHC-92927-54•••-••-6145898-256-5027—6837 Jefferson AvenueDenverCO··80218GRP-4402NAVIGATE-HMO
ENRENR-1198702026-09-08T20:23:43ZMadisonNMartinez19960313UHC-94395-72•••-••-06645257693563madison.martinez@gmail.com1768 Meadow LaneMINNEAPOLISMN55444GRP-5269MEDICARE-ADV-A
ENRENR-1000982026-01-06T04:11:54ZWarren, ValentinaD—·1959-11-17UHC6424081•••-••-6931(737) 536-6901N/A9049 Maple Avenue··DALLASTX··75225GRP-1647MEDICARE-ADV-B
ENRENR-103748 2026-04-03T14:05:00ZPeter—Brooks·Sep 18, 1965UHC-56867-96•••-••-514412474697906··UNKNOWN2138 Union St Apt 6SeattleWA—GRP-5083MEDICARE-ADV-B
ENRENR-1392592026-07-14T20:05:15ZFrances—Hansen1958-11-10··UHC-28727-85null··(744) 286-4153UNKNOWN8848 Lincoln WaySan DiegoCA92179GRP-5413CHOICE-PLUS-PPO
ENRENR-1417832026-04-19T17:37:44ZMaryA··Lawrence1974-11-24UHC-37820-56•••-••-3596UNKNOWNMARY.LAWRENCE75@PROTON.ME895 Indian School RdHoustonTX77051-5030GRP-9188SELECT-EPO
ENRENR-1375222026-03-02T19:11:43ZDENNISG.OBRIEN1948-01-16·UHC-12014-13•••-••-6977910.507.4548dennis.obrien@icloud.com3718 Valley View DriveTucsonAZ85707GRP-3127MEDICARE-ADV-A
ENR ENR-1307132026-02-22T10:51:23Z·Joe—·Rose05-05-1960UHC-43042-02•••-••-9318420-519-5338joe.rose@icloud.com1086 Elm StAtlantaGA30395GRP-5606MEDICARE-ADV-B
ENRENR-1061342026-01-20T15:36:44ZDEB—HUDSON·01-07-1938UHC-17166-07•••-••-7199(463) 611-2740·DEBORAH.HUDSON@GMAIL.COM8863 Main StreetTempeAZ85227GRP-0426CHOICE-PLUS-PPO
ENRENR-112550 2026-06-30T00:20:35ZRussellFCarlson1973-60-28··UHC-77117-13•••-••-41009526754342russell.carlson67@hotmail.com1243 Main StMiamiFL33176GRP-6621MEDICARE-ADV-B
ENRENR-1364242026-07-28T03:59:09ZRONALDISTEPHENS1959-08-10UHC-60140-60•••-••-08562215353721NULL617 SUNSET BOULEVARD··MesaAZ85257GRP-5238NAVIGATE-HMO
ENRENR-1222222026-07-22T17:50:11ZCharlieL.Webb1990-08-11UHC-53654-01•••-••-2251444-407-9877—2023 Desert Sky Blvd Apt 3Las VegasNV89154GRP-6569CHOICE-PLUS-PPO
ENRENR-119491 2026-09-25T01:14:05ZBeverly·SRobinson1960-09-17UHC-62680-99•••-••-6898583.372.4030beverly.robinson@icloud.com5505 BASELINE RDSan AntonioTXNULLGRP-7004NAVIGATE-HMO
ENRENR-1335112026-04-04T23:35:18ZDEBRA—MASON1984-03-24UHC-18910-69•••-••-8478279-722-4165DEBRA.MASON41@HOTMAIL.COM8297 Spring StreetJacksonvilleFL32265GRP-9296NAVIGATE-HMO
ENRENR-1244372026-09-26T17:29:13Z·Watson, RuthV—1963-01-03··UHC1300042•••-••-6274·(446) 897-4507—2307 Sunset Boulevard··JacksonvilleFL32283GRP-3519MEDICARE-ADV-A
ENRENR-1105072026-01-13T09:43:22ZRachel—Rose1929-07-19UHC-27499-03N/A··+1 613 518 7642rachel.rose76@proton.me5491 Baseline RdMiamiFL33115GRP-5482SELECT-EPO
ENRENR-1175452026-03-04T04:00:29ZRUTH—SANDERSOct 18, 1976UHC-33824-96•••-••-9167(810) 585-2778·ruth.sanders67@gmail.com8937 OCEAN AVENUE·MesaArizona85255GRP-9734MEDICARE-ADV-B
ENR ENR-1113742026-07-05T00:27:28Zjames····nguyen1966-02-04UHC-49719-49•••-••-9812+1 771 857 4072··james.nguyen@yahoo.com9889 HILLCREST RD Apt 16COLUMBUSOH43254GRP-7936MEDICARE-ADV-B
ENRENR-1087012026-07-26T19:05:59ZJoyce P—Perry09/08/72UHC-51288-35•••-••-8261UNKNOWNjoyce.perry@proton.me—NULL-nullGRP-8864SELECT-EPO
ENRENR-114712 2026-09-18T03:24:24ZJOHNSGOMEZ03/19/58UHC-49320-75•••-••-0000+1 535 463 0642—·5201 PARK PLOrlandoFL—·GRP-1033MEDICARE-ADV-A
ENRENR-1275142026-07-11T19:52:19ZGabrielWTorres·1962-04-24UHC-05549-07•••-••-1323792.746.9559GABRIEL.TORRES@PROTON.ME2356 DESERT SKY BOULEVARD··NashvilleTN-GRP-0360medicare-adv-a
ENRENR-1383602026-03-29T03:36:01ZKEN—BARNES1982-10-20UHC-22269-87··•••-••-7315(252) 789-9354NULL737 OAK STChandler··az85240GRP-5419MEDICARE-ADV-A
ENRENR-1282752026-06-16T03:29:21ZbrianQhunt1994-05-23UHC-00949-45•••-••-6466466-472-1685brian.hunt9@gmail.com1019 Harbor BoulevardAustinTX78716GRP-8692MEDICARE-ADV-A
ENRENR-1238532026-01-29T03:18:53ZVincent—Thomas1939-06-11·UHC-72529-98•••-••-1008899-379-7926vincent.thomas4@yahoo.com1569 ELM STREET··Las VegasNV89177GRP-5745··SELECT-EPO
ENRENR-1304252026-09-06T16:01:53Z·emma—jacobs1996-10-14UHC-65539-03•••-••-1630+1 596 970 0598UNKNOWN3329 LAKE VIEW ROADDenverCO80249GRP-1021MEDICARE-ADV-A
ENRENR-1315672026-01-16T10:42:54ZLaura—·Patterson2006-10-22··UHC-50752-94•••-••-59889648179466laura.patterson64@icloud.com—nullN/A-GRP-8368NAVIGATE-HMO
ENRENR-1087462026-07-21T19:39:27Zmarianna···simmons1954-11-18UHC-37203-81—846-272-1761MARIANA.SIMMONS@HOTMAIL.COM5200 Desert Sky Blvd #406TEMPEAZ85279GRP-1792CHOICE-PLUS-PPO
ENRENR-1186132026-02-03T23:46:49ZOrtiz, Kathryn··—1976-06-15UHC-01209-57•••-••-7079802-307-2830kathryn.ortiz66@proton.me2638 INDIAN SCHOOL RD··AustinTX78777GRP-2492CORE-HMO
ENRENR-1257232026-07-17T01:38:12ZTerryYBanks1947-12-03·UHC-30407-95•••-••-0231813-939-7603terry.banks@aol.com1760 Highland AveOrlandoFL32830-4696·GRP-9680SELECT-EPO
ENRENR-1147202026-05-28T13:57:46ZCHRISTOPHERKMILLER1980-09-02UHC-58051-99—·8089600520christopher.miller@yahoo.com5483 Bayshore DriveSAN ANTONIOTX78210GRP-4712OPTIONS-PPO
ENRENR-1174422026-07-27T13:32:37ZORTEGAT.BRANDON1961-08-08UHC-07280-86•••-••-12059533484577brandon.ortega@aol.com4951 RIVER ROADSeattleWA98107GRP-9965OPTIONS-PPO
ENRENR-1198882026-08-18T08:22:26ZDYLANPCARPENTER19970904UHC-57619-60•••-••-57828777707UNKNOWN2472 Ridge Rd·MinneapolisMN55452GRP-0217CHOICE-PLUS-PPO
ENRENR-1381222026-08-18T00:00:39ZStephanieN.Ruiz1960-09-07UHC-02243-45•••-••-7341+1 524 870 0134-7665 Mesa DriveLOS ANGELES··CA90093GRP-8839SELECT-EPO
ENRENR-104080 2026-02-27T22:22:23ZFATIMAA.JONES··1965-05-13UHC-49631-46N/A9498251916fatima.jones13@aol.com8055 Harbor BlvdSeattleWashington98167GRP-7206CORE-HMO
ENRENR-135557 2026-04-25T03:20:16ZJEREMYBHOWELL1981-03-25UHC-26033-66•••-••-4291(424) 513-5375-6008 Sage CtMinneapolisMN55474GRP-1208MEDICARE-ADV-B
ENRENR-1172012026-07-06T18:07:37ZSofia—Lewis1938-03-27UHC-91831-67•••-••-5611361-586-1706—3032 Valley View DrMesaAZ85261··GRP-5963CORE-HMO
ENRENR-1298382026-01-10T18:23:33ZBetty—·Santiago1938-02-07UHC-84720-46null(976) 528-0152—6786 Elm StreetColumbusOH43213-9153GRP-7200··MEDICARE-ADV-B··
ENRENR-1083512026-10-10T08:34:33ZCamila··DMurphy19830106UHC-75358-97•••-••-3744(574) 219-1506camila.murphy@proton.me3039 Pine DriveGlendale·AZ85303-8092GRP-5926CHOICE-PLUS-PPO
ENRENR-1390712026-09-03T13:31:50ZGarza, Grace····—11/10/2002UHC-70601-88•••-••-27449006582811··-7828 Maple Ave Apt 40ChandlerAZ85281GRP-7839CHOICE-PLUS-PPO
ENRENR-1425532026-05-29T15:47:19ZMichelle·Z.Alvarez2007-03-11UHC-56884-74•••-••-57569882735027michelle.alvarez@aol.com1030 Oak StreetAustinTX78755GRP-4130MEDICARE-ADV-B
ENRENR-1329942026-04-01T03:59:19ZMARIANA—COOPER1973-01-21UHC-47049-46•••-••-1216(439) 832-7261mariana.cooper@aol.com3039 LAKE VIEW ROADAtlantaGA30302GRP-7106OPTIONS-PPO
ENRENR-1353732026-04-23T14:15:02ZHANNAH—GILBERT·May 15, 1994UHC-61909-96•••-••-0200UNKNOWNhannah.gilbert@aol.com1717 PARK PLColumbusOH··43218GRP-5686OPTIONS-PPO
ENRENR-1279472026-04-26T08:32:59ZGabriel····Shaw1975-05-15UHC-14473-31•••-••-8794(466) 757-9911gabriel.shaw54@gmail.com2479 Grand AvenuePlanoTX75003-6673GRP-2344OPTIONS-PPO
ENRENR-1430472026-09-30T12:16:55ZGLORIA—·BRYANT1963-11-03UHC-35508-46•••-••-7976—gloria.bryant@yahoo.com4831 Main StreetLas VegasNV89130GRP-0355CHOICE-PLUS-PPO
43,101 rows, page 73 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:36.706Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty