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-1386342026-06-23T22:22:16Z·MeganW··LunaSep 26, 1962UHC-51148-57•••-••-9949—megan.luna47@gmail.com·5143 Hillcrest RdScottsdaleAZ·85259·GRP-1367MEDICARE-ADV-B
ENRENR-1150082026-09-09T07:00:30ZVincent—Stewart1939-04-05UHC-09246-17•••-••-0932(421) 608-9838—8497 Valley View DriveJacksonville·FL32290GRP-5189CHOICE-PLUS-PPO
ENRENR-1199292026-03-23T22:11:57ZMEI—JORDAN1974-06-14UHC-25372-81—7322813810-8501 Canyon RoadTampaFL·33632GRP-1306CORE-HMO
ENRENR-1112162026-07-29T01:48:01ZJanet··U.Elliott1991-03-11UHC-79307-30•••-••-5339-NULL7895 PINE DRIVEJacksonvilleFL32292··GRP-2015CORE-HMO
ENRENR-1403022026-07-29T21:18:08ZHANNAHF.·SANTOS1981-05-07UHC-02117-08•••-••-6729742.334.9242····6923 Maple AveSan AntonioTX78249-8284GRP-8049CORE-HMO
ENRENR-1392182026-07-21T17:10:59ZJUANC·WELLS1949-05-20UHC-47970-48null(535) 703-1051juan.wells@proton.me1653 GRAND AVELos AngelesCA90087GRP-7156MEDICARE-ADV-B
ENRENR-1106362026-08-05T04:53:09ZPATRICIAX.HART1960-82-27UHC2584423•••-••-1322(520) 798-6372UNKNOWN4869 Valley View DrFRESNOca93764GRP-1326MEDICARE-ADV-A
ENRENR-1124942026-05-10T06:48:16Zabigail····peterson23-01-1999UHC-63835-69•••-••-4000(391) 302-1561abigail.peterson@icloud.com2967 Highland AvenueMiamiFL—GRP-6252navigate-hmo
ENRENR-1044092026-01-26T18:19:34ZSAMANTHAK.RYAN0073-19-95UHC-28334-48•••-••-3687·(668) 523-7823SAMANTHA.RYAN@HOTMAIL.COM4238 Pine DriveSan Antonio·TX78298GRP-3842NAVIGATE-HMO
ENRENR-1296852026-04-20T12:40:37ZJames—Sandoval2003-01-26UHC-22538-54null8529295995james.sandoval@aol.com3485 Desert Sky BlvdATLANTAGA30388GRP-6454SELECT-EPO
ENRENR-1039062026-07-16T15:12:25ZNANCY—VAZQUEZ1967-08-27UHC-61543-39•••-••-81736555146171nancy.vazquez27@hotmail.com4030 Maple AveScottsdaleAZ85207GRP-4602CORE-HMO
ENRENR-1420922026-04-05T03:32:33ZWEILROGERS19910925UHC-97411-91•••-••-1006+1 774 237 8258null9562 ELM STREETOrlandoFL32889GRP-2242MEDICARE-ADV-A
ENRENR-1330122026-03-26T02:04:30ZGriffin, ScottR—02/21/1945··UHC-41956-45NULLNULLscott.griffin@outlook.com7211 Main StreetTEMPEAZnullGRP-6046CORE-HMO
ENRENR-1205512026-09-07T15:22:07ZCarolyn—Stevens16-09-2005UHC-02703-98UNKNOWN553.991.5428CAROLYN.STEVENS@AOL.COM5431 FOREST AVENUESeattleWA98176GRP-9391··MEDICARE-ADV-A··
ENRENR-1151222026-05-14T01:18:55ZTERESA—LEWIS2000-06-26UHC-48359-03··724-532-1142NULL7045 Meadow LaneDALLASTX·75282GRP-8942CORE-HMO
ENRENR-1062402026-07-13T11:55:37ZClark, Olivia——1975-04-28UHC-23263-97•••-••-57009652917613olivia.clark@icloud.com3673 OAK ST··Orlando·FL32812GRP-9816CORE-HMO
ENRENR-1041192026-08-31T23:05:44Z·CAROLYNFROBERTS··1974-02-03UHC-06363-32•••-••-462516006767200CAROLYN.ROBERTS23@ICLOUD.COM707 MESA DRIVEPlanoTX75027GRP-3111OPTIONS-PPO
ENRENR-1230972026-03-06T09:00:34ZKing, MarilynS—1970-10-14UHC-52925-80•••-••-2715—··7092 Pine DriveHOUSTONTX77078GRP-8950NAVIGATE-HMO
ENRENR-1415362026-10-16T14:00:49ZLauren—AndersonJul 27, 1940UHC-79643-33•••-••-68126960994—533 Main StreetNashvilleTN37296GRP-1153MEDICARE-ADV-A
ENRENR-1041092026-03-25T02:57:19ZStephanieLOliver1978-02-19UHC-40061-23•••-••-05398315591211stephanie.oliver@yahoo.com2679 Elm StJacksonvilleFL···32215GRP-9162SELECT-EPO
ENRENR-1153932026-03-15T11:59:10ZFrankPCook1975-10-03UHC-59565-50•••-••-2619791-880-1915frank.cook15@icloud.com3893 CANYON RDSCOTTSDALEAZ85234GRP-1807navigate-hmo
ENRENR-1158712026-04-08T02:56:26ZJohnston, Kevin——1959-08-24UHC1273025•••-••-9925520-892-2698kevin.johnston@icloud.com6104 CAMELBACK ROADMinneapolis·MN55492GRP-5931SELECT-EPO
ENRENR-1250832026-06-03T11:25:32ZBarb····Espinoza1953-03-07·UHC-74131-02•••-••-4751(927) 429-7274··-1702 Lincoln WayJACKSONVILLEFL32214GRP-6708SELECT-EPO
ENRENR-1346262026-01-31T20:28:00ZSOPHIA—GREENE1999-10-04UHC-49435-56—14365680637sophia.greene@yahoo.com··6045 Highland AvenueGlendaleAZ85315GRP-8372OPTIONS-PPO
ENRENR-1026382026-09-28T07:59:19ZKIMBERLY—VAZQUEZ1971-03-08UHC-88315-80•••-••-5216256.942.7753··null866 Maple AvenueNASHVILLETN37263-3015GRP-8583OPTIONS-PPO
ENRENR-1221782026-04-03T01:29:03ZJULIAXPOWELL·2005-04-04UHC-59905-63•••-••-8862767-427-6461julia.powell12@yahoo.com6540 SUNSET BOULEVARDGlendaleArizona85355GRP-5749CHOICE-PLUS-PPO
ENRENR-1060772026-01-22T05:36:14ZSUSANZ.KENNEDY19550628UHC-76091-41—(906) 540-9347N/A9397 CANYON RD Apt 7··ATLANTAGeorgia30329·GRP-8427MEDICARE-ADV-A
ENRENR-1031822026-03-11T11:56:48ZJACQUELINEPREYES19920622UHC-41908-29null··(460) 394-6250jacqueline.reyes@hotmail.com736 Grand AvenueOrlandoFL32848GRP-3874CHOICE-PLUS-PPO
ENRENR-1415382026-04-06T18:44:07ZDouglasDCruz04/01/61UHC-70015-67•••-••-4280281.793.9656—9571 BASELINE RD···ColumbusOH43278··GRP-4487·navigate-hmo
ENRENR-1401912026-05-07T19:14:17ZJessica—Smith1991-08-28UHC-10378-37-··794-487-4284JESSICA.SMITH@GMAIL.COM25 Lincoln WayLas Vegasnv89107-1269GRP-3580MEDICARE-ADV-B
ENRENR-1333062026-09-27T22:15:07Z TERESATPOWELL19810923UHC-08732-87•••-••-4306825-367-5625TERESA.POWELL21@ICLOUD.COM6134 Cedar Lane #753OrlandoFL32863GRP-2875CHOICE-PLUS-PPO
ENRENR-1156532026-07-26T10:26:45ZJORDANZ.TUCKER2007-11-17UHC-04978-28•••-••-9180N/AJORDAN.TUCKER17@HOTMAIL.COM7544 RIDGE ROADPhoenixArizona85063GRP-3808SELECT-EPO··
ENRENR-1208442026-04-19T00:53:23ZANGELA—COOK2008-11-05UHC-30513-36•••-••-3864239-859-3746ANGELA.COOK60@YAHOO.COM8553 Valley View DrLOS ANGELESCA90032GRP-2115MEDICARE-ADV-B
ENR ENR-1024782026-03-04T13:53:28ZCharlesJ.Reed1966-03-22UHC-48406-15•••-••-1046·(915) 343-0053charles.reed@outlook.com1924 Meadow LaneLos AngelesCA90097-1337GRP-6580SELECT-EPO
ENRENR-1407242026-06-16T06:12:43ZROYJ.MEJIA1976-09-15UHC-51314-74•••-••-9265215.322.2112ROY.MEJIA@GMAIL.COM3909 INDIAN SCHOOL ROADSan DiegoCA92167··GRP-1518MEDICARE-ADV-A
ENRENR-1285772026-07-25T06:16:31ZWilliamOGriffin19630404UHC-50393-25•••-••-7375(298) 412-1629william.griffin@outlook.com4415 UNION ST··Las VegasNevada89120GRP-1522··CORE-HMO
ENRENR-1201102026-07-12T17:32:56ZWilllie—Fisher··2/27/1958·UHC-91303-28•••-••-5643813-760-3904—2755 Park PlaceChandlerAZ85273·GRP-9413CHOICE-PLUS-PPO
ENRENR-1112122026-05-06T01:30:29ZDiegoVHernandez19490726·UHC-13282-38•••-••-5621351-693-5004N/A8049 Jefferson AvenueAustinTX78784GRP-8886MEDICARE-ADV-B
ENRENR-1118802026-05-30T01:09:05Z·joan—mills·12/16/1957UHC-84014-04•••-••-5950(884) 511-5773joan.mills@hotmail.com1972 Hillcrest RoadSCOTTSDALEAZ85214GRP-5408MEDICARE-ADV-A
ENRENR-1407692026-08-03T10:03:49ZANTHONY—GIBSON19636008UHC-83521-36•••-••-7890570-464-3442anthony.gibson@outlook.com2139 FOREST AVEMinneapolisMN55428GRP-8061NAVIGATE-HMO
ENRENR-1132182026-07-01T12:22:12ZaishaV.hall1994-06-07·UHC-40160-66—(927) 429-7352aisha.hall7@hotmail.com2418 Canyon RoadLas VegasNV89139GRP-4824NAVIGATE-HMO
ENRENR-135361 2026-05-25T02:39:13ZKevinBGriffin19610219UHC-12460-87•••-••-050614044870561—4476 Central AveMESAAZ85204GRP-7774MEDICARE-ADV-A
ENRENR-1335432026-05-26T00:44:17Z Hill—Timothy1975-08-24UHC-97371-71•••-••-5150·9467932254TIMOTHY.HILL@PROTON.ME1255 Mountain View DrScottsdaleAZ85209GRP-6388CORE-HMO
ENRENR-1414212026-09-16T15:30:52ZWILLIAMF.WEBB1986-01-20UHC-85317-53—393.844.3846william.webb7@outlook.com2004 Willow Ct··San DiegoCA92121GRP-5128MEDICARE-ADV-B
ENRENR-1069512026-08-07T15:24:01ZSophia—Schultz28-05-1979UHC-23034-25•••-••-2111(233) 875-0924-2062 JEFFERSON AVENUEPhoenixArizona85019·GRP-7341OPTIONS-PPO
ENRENR-1167382026-07-13T01:41:55ZJUANNSPENCER13-01-1975UHC-44450-92•••-••-4663N/A—8430 HIGHLAND AVEMIAMIFL33136GRP-7201MEDICARE-ADV-A
ENRENR-1113902026-03-14T15:12:40ZLawrence—ShawDec 18, 2000UHC4316869null7942377091lawrence.shaw61@proton.me·7738 Maple AvenueSAN ANTONIO··TX78211·GRP-9938choice-plus-ppo
ENRENR-1064982026-03-05T06:14:57ZCATHERINEX.GARCIA1965-03-14UHC-49707-14•••-••-1064673.609.3324CATHERINE.GARCIA@PROTON.ME95 Baseline RoadCHANDLERAZ—GRP-8019SELECT-EPO
ENRENR-1209702026-05-23T03:48:54Z OLIVIAD·HUNTER1948-05-23UHC-36158-75•••-••-8974nullolivia.hunter@hotmail.com9412 HARBOR BLVD·ScottsdaleAZ85200GRP-8680SELECT-EPO
ENRENR-1316922026-01-29T16:30:15ZBARBARAVPARKER11/19/1957UHC-31913-58•••-••-4482(370) 442-0740barbara.parker86@gmail.com5518 Sunset BlvdMINNEAPOLISMN—GRP-7428select-epo
43,101 rows, page 254 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.640Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty