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-1212472026-09-28T23:43:18ZOMARIWILLIAMSON1954-08-11UHC-55168-93•••-••-4694375-334-2692—3803 WILLOW CTSCOTTSDALEAZ··85267GRP-4825NAVIGATE-HMO
ENRENR-1123672026-09-14T15:03:17ZBETTYCMENDOZA1951-07-26·UHC-65583-73•••-••-3801--9797 VALLEY VIEW DRIVEMesa··AZ··85231GRP-5938MEDICARE-ADV-B
ENRENR-1171572026-05-26T20:43:07ZRANDYP.MILLS·1957-01-02UHC-06038-24•••-••-8766(206) 603-5968··randy.mills87@yahoo.com6343 Indian School RoadTucsonAZN/AGRP-1998CORE-HMO
ENRENR-1132742026-09-18T21:36:36ZMARTHAV.WALKER1956-04-23UHC-20345-09•••-••-8062—MARTHA.WALKER21@PROTON.ME5551 Highland AvenuePHOENIXAZ85011GRP-3910MEDICARE-ADV-B
ENRENR-1273992026-07-20T23:05:31ZJoseph····Ortiz1947-03-02UHC-93470-79•••-••-8721(556) 483-2055joseph.ortiz@icloud.com9438 OAK STREETAUSTINTX78729GRP-7028MEDICARE-ADV-B
ENRENR-1267542026-01-13T08:37:01ZMateo—Vega1939-06-18UHC-55251-71—(833) 471-7898NULL1666 Desert Sky BlvdScottsdaleArizona—GRP-1397CORE-HMO
ENRENR-1233402026-05-03T11:40:17ZethanNgibson05/01/1948UHC-53902-33•••-••-4608UNKNOWNethan.gibson36@aol.com6002 Market StDenverCO80237GRP-7553MEDICARE-ADV-A
ENRENR-1177442026-08-25T13:02:08ZArnold, AshleyA.—1960-12-17UHC-00958-18•••-••-64998609693955NULL5208 Baseline RdSACRAMENTO·CA95816GRP-7183OPTIONS-PPO
ENRENR-1229792026-06-21T13:36:11ZDianeL.Armstrong04/20/2004UHC-42308-24•••-••-42692015399999diane.armstrong2@hotmail.com3013 Forest Avenue #864··CharlotteNC··28246GRP-1027CHOICE-PLUS-PPO
ENRENR-1190162026-05-23T13:14:55ZJULIE—CHAPMAN1993-03-18UHC-38151-22•••-••-2602(706) 911-1311-6037 Meadow LnGilbertAZ85245GRP-5228CHOICE-PLUS-PPO
ENRENR-1395182026-09-28T00:49:52ZNOAH—BOWMAN1996-09-01UHC7764577•••-••-08367328301945··noah.bowman@icloud.com7524 Market StreetChandlerAZ85256GRP-3204CORE-HMO··
ENRENR-1124382026-10-08T17:45:55ZSandra—Spencer·03/07/81UHC-91154-11•••-••-89636327231292·sandra.spencer@yahoo.com2833 Willow Court Apt 16ChandlerAZ·85292GRP-2035MEDICARE-ADV-B
ENRENR-1386062026-04-13T01:11:12ZLUCIA—GREENE1952-04-08UHC6746124•••-••-4544—lucia.greene10@gmail.com7328 Sage Ct #692AtlantaGA30374GRP-7227medicare-adv-a
ENRENR-1059232026-02-26T20:46:01ZJUDITHUGEORGE02/12/01··UHC-69025-07•••-••-2718(913) 463-5923judith.george82@proton.me4346 BAYSHORE DRHOUSTONTX—GRP-6443SELECT-EPO
ENRENR-1144972026-07-22T10:50:01ZROGER—NUNEZMar 26, 1974UHC-36065-06•••-••-9830871-984-6154roger.nunez67@hotmail.com·7888 Market StreetGlendale··AZ···N/AGRP-2479MEDICARE-ADV-B
ENRENR-1378212026-06-30T05:26:29Z·Bell, SamanthaH.··—1970-12-02··—•••-••-21096409890536N/A5505 Church St #994TampaFL·33695GRP-0921·MEDICARE-ADV-B
ENR ENR-1022892026-06-23T06:00:23ZDonnaPFox1965-02-08UHC-55581-05·N/A337.218.5277—5945 Mountain View DrNASHVILLETN37288GRP-5494SELECT-EPO
ENRENR-1405432026-08-12T14:37:02ZCheryl—·Chavez05-01-1952UHC-41463-71•••-••-13885309571321cheryl.chavez63@gmail.com988 CAMELBACK RDSacramentoCA·95889GRP-0531CORE-HMO
ENRENR-1258782026-05-14T14:47:18ZCHARLOTTE—WEBB1999-05-26UHC-89136-86•••-••-53245939521360··charlotte.webb20@icloud.com7084 CENTRAL AVESan AntonioTX78258GRP-2954CORE-HMO
ENRENR-1065372026-10-07T18:59:54Z SCOTT—ALVAREZMay 8, 1953UHC-73594-80•••-••-1513(390) 209-0365—1011 Ocean Ave·DENVERCO80221GRP-5167··CHOICE-PLUS-PPO
ENRENR-1342112026-04-20T23:18:47ZCunningham, AlexanderT—1961-02-02UHC-18955-29•••-••-844217624349080—4091 MARKET STREETSan DiegoCA92153GRP-9071CHOICE-PLUS-PPO
ENRENR-1371772026-05-12T17:22:59ZJERRY—WILLIS1987-02-05UHC-50882-93•••-••-551613374446135—2637 River RoadPlanoTX75053GRP-3624NAVIGATE-HMO
ENRENR-1235842026-10-15T07:33:05ZKEVINF··MEDINA1956-06-26UHC-95181-03•••-••-967714146825677N/A9682 Bayshore DriveLas VegasNV89131GRP-8259CHOICE-PLUS-PPO
ENRENR-1162382026-01-05T17:44:04ZSAMUELUFORD·11/10/60UHC-70147-78N/A+1 780 300 6762samuel.ford@yahoo.com6444 Washington StSacramento·CA95820GRP-6827CORE-HMO
ENRENR-1285892026-03-03T18:09:09ZPhilipDOwens19-08-2004UHC-79864-92NULL843-781-9909PHILIP.OWENS79@OUTLOOK.COM391 SUNSET BOULEVARDFresnoCA93797GRP-4590NAVIGATE-HMO
ENRENR-1155572026-02-01T15:46:52ZMcDonaald, Edward——19770123UHC-73216-61•••-••-92427214435202UNKNOWN9633 Cedar LnScottsdaleaz85251GRP-4166CORE-HMO
ENRENR-1385212026-09-10T23:49:46ZAlexander····Holmes1945-06-18UHC-09899-68•••-••-26832454749970··alexander.holmes@gmail.com8770 Lincoln WayORLANDOFL32849GRP-2550CORE-HMO
ENRENR-1407882026-02-09T18:49:00ZPeterHBanks12/21/1991—•••-••-338615422779550peter.banks@proton.me7123 Ridge Rd #128Orlando·fl·32892GRP-2555select-epo
ENRENR-1171142026-09-18T07:17:48ZJeremyFSnyder1988-04-05UHC-65942-65•••-••-43954686701391jeremy.snyder51@outlook.com106 Washington StDenver·CO80272··GRP-0905CORE-HMO
ENRENR-1235742026-03-10T00:09:03ZCarlosF··Gordon20050611UHC-05769-17•••-••-9173·2534841045carlos.gordon@gmail.com6599 Ridge RoadLas VegasNV89193GRP-1444MEDICARE-ADV-B
ENRENR-1219922026-08-15T18:32:48ZRiley, Lauren——1952-01-08UHC-01311-77UNKNOWN699-280-3224lauren.riley71@aol.com1156 Hillcrest RoadMinneapolisMN55446GRP-6480MEDICARE-ADV-B
ENRENR-1208632026-06-01T11:56:35Zeric—andrews1996-10-25UHC-54643-62•••-••-6225—ERIC.ANDREWS2@HOTMAIL.COM9487 APACHE BLVDGlendaleAZ85348GRP-8833options-ppo
ENRENR-1064122026-10-10T04:46:12ZBobbyD.Romero02/09/2001UHC-25052-40•••-••-3310923-528-9119bobby.romero13@proton.me8742 PARK PLACESEATTLEWA98154GRP-0273CHOICE-PLUS-PPO
ENRENR-1173052026-08-29T18:10:08ZSusanDDavisJul 14, 1975UHC-82579-78—(937) 493-9571susan.davis@icloud.com5938 Spring StSacramentoCA95836-2855GRP-7792·NAVIGATE-HMO
ENRENR-1342162026-09-12T03:16:56ZJANET—DOMINGUEZ1996-03-24uhc-70191-82•••-••-3145(888) 622-9148janet.dominguez@yahoo.com1555 Sunset BoulevardNashvilleTennessee37244GRP-4318OPTIONS-PPO··
ENRENR-1237742026-07-16T15:30:36ZWalter, Fields··O.—1938-08-18·UHC-01743-64•••-••-08446036930264WALTER.FIELDS68@HOTMAIL.COM9344 Camelback RoadFresno··CAnullGRP-6844MEDICARE-ADV-B
ENRENR-1208152026-08-30T20:44:59ZBradleyJSchultz07/05/1947UHC-33435-24•••-••-0683N/Abradley.schultz4@icloud.com8268 Mountain View DriveMesaaz·85206GRP-1029MEDICARE-ADV-A
ENR ENR-1334952026-08-23T20:11:47ZBarbaraTJohnston20-12-1990UHC-77608-21··•••-••-2538257.393.1456barbara.johnston6@aol.com6135 Ridge Road #254·GlendaleAZ85389··GRP-1103··CHOICE-PLUS-PPO
ENRENR-1169382026-07-23T17:10:47ZRussellGSmith2002-07-05·UHC-62805-28NULL-·russell.smith93@proton.me1830 Jefferson AveTEMPEAZ85202·GRP-2964NAVIGATE-HMO
ENRENR-1205762026-05-11T06:26:15ZSAMANTHAYBOYD19761127·UHC-62289-20•••-••-4768(393) 444-0946··samantha.boyd@gmail.com9801 Jefferson AvenueTucsonAZ··85791·GRP-8914MEDICARE-ADV-B
ENRENR-1191172026-03-11T01:37:37Z MARIANA—EVANS1997-10-27UHC-97361-74•••-••-7967(269) 940-3408··—9718 RIVER ROADNashvilleTN37251GRP-8533OPTIONS-PPO
ENRENR-1195882026-10-09T19:52:50ZWilliam—Daniesl1969-09-18UHC-94662-39•••-••-9477565-254-5974—9324 Bayshore DriveMinneapolisMN55452GRP-6232MEDICARE-ADV-A
ENRENR-1263502026-05-10T13:13:03Zkeith—meyerJul 2, 1964UHC-67314-03•••-••-208613083837927keith.meyer61@outlook.com3607 Desert Sky BoulevardMesaAZ85222-4136GRP-9977CHOICE-PLUS-PPO
ENRENR-1208162026-01-28T09:32:54ZCYNTHIAW.LAWSON1943-07-11UHC-98246-10•••-••-5220301-959-8469cynthia.lawson94@proton.me·5399 Indian School RoadTucsonAZ85712GRP-5321OPTIONS-PPO
ENRENR-1108902026-04-28T18:34:36ZANDREAV.WATSON1950-09-10UHC-73165-75•••-••-138017375795304andrea.watson@proton.me8190 APACHE BLVDPlano·Texas75029GRP-8425MEDICARE-ADV-B
ENR ENR-1361702026-03-12T20:06:34ZDebraKFelds1958-08-07UHC-35495-28N/A5296397368debra.fields44@gmail.com5118 HIGHLAND AVELas VegasNV89174GRP-8941CHOICE-PLUS-PPO
ENRENR-1122902026-10-08T23:53:53Z·BRENDAA.BROWN1962-12-12UHC-10819-23•••-••-5234249-388-5403N/A379 JEFFERSON AVEPlanoTX75024GRP-2195SELECT-EPO
ENRENR-1002022026-10-18T16:59:13ZTHOMAS—LEE10/01/1992UHC-71574-96•••-••-6109——7162 Camelback RoadScottsdaleAZ··N/A·GRP-1472NAVIGATE-HMO
ENRENR-137251 2026-03-01T20:29:09ZAARON—GONZALEZ11/03/62UHC-18772-45N/A··12538912028aaron.gonzalez@outlook.com9680 MOUNTAIN VIEW DRIVE··SeattleWA98103GRP-5576navigate-hmo
ENRENR-1340342026-02-24T22:12:29ZCynthia—Edwards2001-04-15UHC-03383-39•••-••-87147894854736cynthia.edwards@yahoo.com9713 Highland Avenue #916SAN ANTONIOTexas-GRP-8945·MEDICARE-ADV-B
43,101 rows, page 318 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:43.612Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty