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-1414752026-09-15T12:39:13ZAshleyN.Carpenter1967-01-15UHC-08657-94—·9056009029ashley.carpenter@hotmail.com3832 Ocean AveDenverCO80255GRP-1888CORE-HMO··
ENRENR-1269082026-07-29T02:15:48ZAaronQAndrews1995-07-06UHC-11785-20··•••-••-2013(532) 260-9100-4074 CENTRAL AVENUECharlotteNC28269GRP-8567CHOICE-PLUS-PPO
ENR ENR-1117292026-05-23T04:17:48Z MarianaD.Reynolds1962-01-23UHC-70487-07•••-••-1410296-561-6287mariana.reynolds@yahoo.com5259 Palm DrivePhoenixAZ85038GRP-2613CORE-HMO
ENRENR-1066842026-04-19T10:00:45ZJacobs, Nathan··—19460704UHC-34860-04··•••-••-5357939-504-9935··nathan.jacobs@aol.com3405 Pine Dr #130··SeattleWA98114GRP-4570SELECT-EPO··
ENRENR-1179092026-02-21T12:24:13ZVIRGINIA··—EVANS1957-07-28uhc-47098-36———6614 ELM STScottsdaleAZ85284GRP-2393SELECT-EPO
ENRENR-1033152026-06-11T11:38:12ZJennifer··COliver6/16/1972UHC-34799-44•••-••-4926(660) 692-0658jennifer.oliver9@outlook.com9553 HIGHLAND AVENUESeattle···WA98153··GRP-8813OPTIONS-PPO
ENRENR-1150842026-02-09T16:19:51Zsteven—crawford1991-02-06UHC-53196-63•••-••-14454945908668steven.crawford@outlook.com8433 Market StreetLOS ANGELESCA90029GRP-6764OPTIONS-PPO
ENRENR-1331252026-01-02T18:34:18ZGeraldR.·Russell1951-07-01UHC9563260•••-••-6106(925) 203-0479gerald.russell23@outlook.com6855 MAPLE AVETUCSONAZ-GRP-3387CORE-HMO
ENRENR-1359212026-04-23T17:30:42ZDiane—Cole1946-01-26UHC-54127-33•••-••-0986502-510-4781DIANE.COLE23@OUTLOOK.COM5258 Church StCharlotteNC28291GRP-9983OPTIONS-PPO
ENR ENR-1378242026-05-15T17:40:49Zjanice—garrett1959-02-15UHC9314289•••-••-7800+1 352 450 7434JANICE.GARRETT79@YAHOO.COM2391 RIVER RDPLANOTX75045GRP-7483MEDICARE-ADV-B
ENRENR-1265582026-09-14T23:15:42ZWEIK··GRIFFIN07/13/83UHC-18705-80•••-••-08996694114690wei.griffin@hotmail.com·6937 Union StreetHoustonTX77001-3411GRP-9904CHOICE-PLUS-PPO
ENRENR-1363382026-08-03T22:11:38ZGrace, Johnston··—·2008-02-41UHC-06724-33•••-••-9280308-456-2016GRACE.JOHNSTON@AOL.COM5768 Jefferson Ave #562FresnoCA-GRP-4537OPTIONS-PPO
ENRENR-1074672026-04-29T14:52:51Z·TIMOTHYZ.HALL1972-01-09UHC-51089-52•••-••-9296892.399.8932TIMOTHY.HALL@OUTLOOK.COM8662 Cedar LnAustinTX78767GRP-8842MEDICARE-ADV-A··
ENRENR-1358792026-01-29T01:58:51Z JUAANYHUGHES1994-10-24UHC8670992•••-••-7976(320) 640-4193—9070 Bayshore DrMinneapolismn·55486GRP-4055MEDICARE-ADV-A
ENRENR-1076812026-10-08T02:32:38Z—F—1992-05-19··UHC-36150-61•••-••-5096460-458-3191gary.lee45@hotmail.com3691 Lincoln WayMINNEAPOLISMN··55469-3350GRP-2061CORE-HMO
ENRENR-1027202026-09-01T11:47:38ZKAYLAAWONG1966-10-13UHC-67528-30•••-••-6788(612) 492-9138kayla.wong@hotmail.com5312 Apache BoulevardMesaAZ85242GRP-3588MEDICARE-ADV-B
ENRENR-1247482026-04-23T08:41:57ZTIMJ··DEAN·1973-10-26UHC-25505-58•••-••-7712(498) 279-0568TIMOTHY.DEAN2@GMAIL.COM5080 Camelback RoadMinneapolisMN55418GRP-0565MEDICARE-ADV-A··
ENRENR-1123112026-07-13T06:40:18ZGloria—Rodriguez·1985-06-07UHC-88209-75•••-••-10114569949432gloria.rodriguez73@proton.me1796 Canyon RoadFresnoCA93769GRP-7945SELECT-EPO
ENRENR-1094612026-06-02T04:03:56ZLORIQWOODS1959-12-07UHC-11203-61•••-••-4330UNKNOWNlori.woods@proton.me6879 Cedar LnCharlotteNC28227GRP-9921options-ppo
ENR ENR-1344692026-05-04T19:33:30ZisabellaPle04/04/64UHC-19469-80•••-••-7824nullisabella.le@outlook.com670 MOUNTAIN VIEW DRIVETampaFL33606-7654GRP-0626SELECT-EPO
ENRENR-1347062026-01-23T06:56:56ZIsabella—DavisDec 7, 1970UHC-58116-53•••-••-9105N/Aisabella.davis64@hotmail.com1670 Sunset BoulevardCharlotteNorth Carolina28253GRP-0205MEDICARE-ADV-A
ENR ENR-1074742026-09-02T23:02:29ZChavez, OliviaU—19730115UHC-71126-91null6156628928olivia.chavez21@outlook.com5964 Meadow Lane Apt 17AtlantaGA30371GRP-8530MEDICARE-ADV-B
ENRENR-1045482026-06-28T01:08:54Zvincent—bell·05/27/1981UHC7647857•••-••-0839953.205.1986··VINCENT.BELL98@OUTLOOK.COM6419 Lake View RoadSeattleWA98163-4949GRP-5292MEDICARE-ADV-B
ENRENR-1038072026-05-22T20:05:33ZWashington, Ruth——01/01/2000UHC-31281-40—249-493-4431NULL5227 CHURCH ST··ChandlerAZ85270GRP-1624OPTIONS-PPO
ENRENR-1002392026-03-24T10:17:54ZYUKISJENKINS19731025UHC-89458-27UNKNOWNUNKNOWNyuki.jenkins23@yahoo.com2132 RIVER RD·MesaAZ··85282-7324GRP-6215CORE-HMO
ENRENR-1075232026-03-29T06:49:09Z·edward—boyd12/17/1954UHC-10168-63•••-••-8328(778) 309-9804—4823 Pine Dr··MiamiFL33190GRP-7422CORE-HMO
ENRENR-1096252026-07-09T21:36:35ZKathyrnLCarpenter11/22/74UHC-20471-72•••-••-336712479061184kathryn.carpenter13@proton.me7653 Canyon RdLAS VEGAS··NV89153GRP-0610SELECT-EPO
ENRENR-1191872026-02-25T03:55:18ZlauraKross09/14/2006UHC-61400-78null974-887-3171N/A6409 Camelback Road·ScottsdaleAZ85292GRP-7662select-epo
ENRENR-1021032026-01-31T08:26:10ZSCOTTU·PETERS19591204UHC-54729-14•••-••-164418049583186scott.peters72@aol.com4995 Meadow LaneMinneapolisMN55428GRP-5155MEDICARE-ADV-A
ENRENR-1313302026-10-01T12:31:19ZMartin, NicholasD—·1999-10-26·UHC3755662•••-••-282213462622258NICHOLAS.MARTIN50@OUTLOOK.COM8440 BroadwayTucsonAZ85783GRP-9953SELECT-EPO
ENRENR-1412582026-05-15T04:18:54ZkathrynF.dominguez1939-12-18—•••-••-8154557-401-6040kathryn.dominguez53@gmail.com6195 APACHE BLVDSacramentoCA95854GRP-9268NAVIGATE-HMO
ENRENR-1217412026-07-09T21:11:54ZPatrick—Pena2005-10-25UHC-91383-46•••-••-55455034340464—364 Oak StreetSacramentoCA95867GRP-7883CORE-HMO
ENRENR-1228562026-09-05T16:45:17ZAMBERS.CRZU1960-06-24UHC-94738-75•••-••-4732272.606.1229amber.cruz83@yahoo.com7725 Market StMiamiFL33141·GRP-9204CHOICE-PLUS-PPO
ENRENR-1224472026-09-29T22:37:43ZANDREAEBEELL1940-01-26UHC-37247-96NULL(517) 999-1466andrea.bell@gmail.com9349 Lake View RdGILBERTArizona85250-8627GRP-7249MEDICARE-ADV-A
ENRENR-1077022026-01-21T00:40:53ZDylanI.··Gibson·1946-01-45UHC-91430-31—233-840-2203dylan.gibson@proton.me3146 Forest AvenuePhoenixAZ85098GRP-2797··MEDICARE-ADV-A
ENRENR-1391852026-07-12T14:07:14ZAnn—Garrett18-12-1938··UHC-63615-33•••-••-33332218085199NULL5563 Lincoln WayHOUSTONTX77073GRP-9592CORE-HMO
ENRENR-1057532026-01-23T00:50:53ZWilliam—Howard·19650106UHC-75421-08NULL(661) 528-0200WILLIAM.HOWARD96@OUTLOOK.COM759 Indian School Rd·SacramentoCA95824GRP-6122MEDICARE-ADV-B
ENRENR-1237432026-07-08T03:31:26ZBRITTANYWNUNEZ06/06/06UHC1368689•••-••-5418574-807-9358BRITTANY.NUNEZ9@GMAIL.COM2966 Cedar LnSeattleWA98195GRP-8023medicare-adv-a
ENRENR-1430632026-07-25T23:19:23ZalanGrodriguez1964-02-25UHC-92100-32•••-••-724112528182291null9052 Elm StreetPlanoTX··75068GRP-1605options-ppo
ENRENR-1121892026-04-10T15:31:57Z·ALBERT—RIKE···1957-07-16UHC-95181-81•••-••-9380(794) 414-3535albert.rice@gmail.com1926 Pine DriveOrlandofl··32812GRP-4928MEDICARE-ADV-B
ENRENR-1046842026-04-21T19:06:15ZJenny—Stone19670928UHC-35688-48•••-••-6020330-241-6855UNKNOWN2372 Meadow LnMinneapolisMN55489GRP-7521OPTIONS-PPO
ENRENR-1378312026-05-10T11:46:56ZAlanZNelson1978-07-11uhc-35440-27•••-••-7509736-515-2908alan.nelson@yahoo.com1155 Lincoln Way #321CharlotteNC28209GRP-5968OPTIONS-PPO
ENRENR-1066422026-02-01T21:45:14ZRachelSEdwardsDec 15, 1988·UHC-16184-77•••-••-6938827.702.3194rachel.edwards@icloud.com9657 UNION STREETMinneapolismn55431GRP-5132NAVIGATE-HMO
ENRENR-140991 2026-05-14T00:17:06ZMatthew M.—Ford02/01/1990UHC-10639-59•••-••-472515498932696-4359 Oak StPLANOTX75087GRP-7405SELECT-EPO
ENRENR-1019502026-07-13T00:44:04ZBOBBY—GONZALES1975-08-07UHC-06949-29··•••-••-34698695564134BOBBY.GONZALES89@YAHOO.COM6370 Mesa Drive·NashvilleTN37235GRP-4841CORE-HMO
ENRENR-1054512026-01-26T14:13:55ZJoseph—·Wright4/20/1976UHC-09052-51•••-••-2685·7436136113JOSEPH.WRIGHT27@ICLOUD.COM2096 Willow CourtTampaFloridaNULLGRP-0372CHOICE-PLUS-PPO··
ENRENR-1172652026-10-08T18:22:21ZRONALDD·DANIELS1943-03-18··UHC9552906•••-••-1177——2498 Oak St Apt 33Plano··TX75033-7895GRP-1676SELECT-EPO
ENRENR-1365112026-03-19T01:41:01ZSantiagoKFord10/19/1979UHC-63013-92•••-••-7901729-549-1469santiago.ford@icloud.com7019 Camelback RdTEMPEAZ85250··GRP-1372NAVIGATE-HMO
ENRENR-1334112026-08-31T13:37:37ZBARBARAS.PARK1985-10-03N/A•••-••-6657(789) 276-5182barbara.park83@icloud.com796 Market StreetGilbertAZ85286GRP-5646CHOICE-PLUS-PPO
ENRENR-1093112026-05-18T10:26:05ZEvans, Doris—··05-06-1949uhc-49358-35•••-••-07226204624184doris.evans73@aol.com3326 Forest AveORLANDO··FL32805GRP-6905SELECT-EPO
43,101 rows, page 63 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.696Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty