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-1363682026-10-17T03:22:49ZEmilyX.OBrien06/06/1941UHC-64936-31•••-••-81946845830935emily.obrien16@hotmail.com1389 Lincoln WayATLANTAGA30392-1755GRP-1981MEDICARE-ADV-B
ENRENR-1315052026-04-18T04:46:05ZBrenda—LopezFeb 18, 1990UHC-93886-29•••-••-9719(975) 235-5447BRENDA.LOPEZ@ICLOUD.COM8704 Lincoln WayMESAAZ85233·GRP-9244MEDICARE-ADV-B
ENRENR-1133142026-03-13T20:25:57ZTHERESA··—ROBERTS1951-02-05UHC-10775-37•••-••-75083672731143UNKNOWN432 Ocean Avenue Apt 29GilbertAZ85226GRP-6355MEDICARE-ADV-B
ENRENR-1417042026-06-22T00:02:09ZPAUL B—SPENCER7/1/1995UHC-67711-94•••-••-3271+1 465 285 3630UNKNOWN2559 Desert Sky Blvd··TEMPEAZ85244GRP-2416MEDICARE-ADV-B
ENRENR-1331962026-02-01T06:51:59ZDebraRPatel21-07-1989UHC4376242•••-••-26017363350476debra.patel98@yahoo.com3284 Camelback RdMesaAZ85207GRP-5658NAVIGATE-HMO
ENRENR-1249142026-04-02T12:44:19ZROGER—MCCOY28-03-1956UHC-70811-25•••-••-8669723-298-4610roger.mccoy@icloud.com8213 Ocean AveSan Antoniotx-GRP-3670NAVIGATE-HMO
ENRENR-1372092026-05-29T20:06:23ZWaltr···Wang02-05-1979UHC-11747-41•••-••-322016956390188—2283 Meadow Lane Apt 25JacksonvilleFL32220GRP-9933··OPTIONS-PPO
ENRENR-1139152026-03-23T17:00:31ZPATRICK—·LUNAOct 3, 1983UHC-87231-07-(959) 918-8887patrick.luna67@hotmail.com2497 Baseline RdJacksonvilleFL32287GRP-0453SELECT-EPO
ENRENR-1254472026-09-04T19:33:07ZKeithN.Cole1950-11-04UHC-98804-07•••-••-6861(349) 853-0422keith.cole@proton.me4613 Grand AveSan AntonioTexas78255GRP-5474·SELECT-EPO
ENRENR-1378492026-07-07T20:46:05ZAdam·LBarnes1951-06-08·UHC4307368•••-••-1349(811) 365-3084N/A7258 Union StSEATTLE··wa98140GRP-7241NAVIGATE-HMO
ENRENR-1231482026-10-09T18:36:16ZSARA J—ALLEN2001-11-27·UHC-39389-95•••-••-6103—·sara.allen36@icloud.com5893 Indian School RoadTucsonAZN/AGRP-3021CORE-HMO
ENRENR-1411922026-03-14T09:47:28ZMICHAEL··JOHNSON1991-03-07UHC-54027-41•••-••-6408·785.445.8153MICHAEL.JOHNSON6@HOTMAIL.COM56 CHURCH STPlanoTXNULLGRP-9320OPTIONS-PPO
ENRENR-1008912026-01-02T15:14:41ZMargaretH.Foster1947-04-01UHC-49481-03•••-••-6652(802) 671-7844margaret.foster@gmail.com6182 Meadow LnDenverCO··—GRP-8881SELECT-EPO
ENRENR-1143342026-07-24T10:20:11Z JESSED.·WARRENNov 17, 2008UHC-51170-46-(463) 830-1687··jesse.warren@aol.com7100 HILLCREST RDGilbertAZ85243GRP-6903OPTIONS-PPO
ENRENR-1340862026-03-02T19:45:29ZHarrisonT.Lisa1953-06-05UHC-11790-15•••-••-7354511.687.8355lisa.harrison@gmail.com-—nullN/AGRP-6109OPTIONS-PPO
ENRENR-1170422026-10-08T18:07:45ZFernandezI.Jeremy4/21/1986UHC-50658-84—19418675142N/A3364 Valley View DriveSan DiegoCA92128GRP-1803medicare-adv-b
ENRENR-1380662026-09-30T12:37:34ZAnn—Henry11/28/1950UHC-47061-95•••-••-3683(349) 319-9676ann.henry@hotmail.com··4023 Main StSACRAMENTOCalifornianullGRP-9371CHOICE-PLUS-PPO
ENRENR-1396052026-04-04T11:18:59ZJulia—Carroll1966-01-08UHC-78156-75•••-••-45029294873228julia.carroll93@icloud.com5514 Palm DrMINNEAPOLISMN55414GRP-3754CHOICE-PLUS-PPO
ENR ENR-1320102026-01-21T20:37:51ZDouglas—Stephens1969-06-24UHC-59681-63•••-••-3351null··douglas.stephens@aol.com2790 Desert Sky BoulevardHoustontx77022GRP-2570SELECT-EPO
ENRENR-1075842026-01-16T06:38:14ZheatherTweaverOct 18, 2004UHC-86273-12•••-••-9331(268) 387-2564—1990 HIGHLAND AVENUEPHOENIX··AZnull·GRP-1736CHOICE-PLUS-PPO
ENRENR-1230362026-09-26T01:26:36ZDominguez, Jennifer——12/24/1988UHC-64982-19•••-••-59473275226904—18 Meadow Lane Apt 16COLUMBUSOH43263GRP-9118··MEDICARE-ADV-B
ENRENR-1285662026-08-26T01:34:12ZSantosF.Carl3/4/1988UHC-14190-34··•••-••-5807(309) 274-7997UNKNOWN967 Valley View DrTEMPEAZ85227GRP-9623MEDICARE-ADV-B
ENRENR-1173862026-07-28T09:18:58ZMeganC.···Wood·10/23/84UHC-68078-33•••-••-7191215-466-0580megan.wood5@outlook.com7693 RIVER RDJACKSONVILLEFL32262GRP-1578OPTIONS-PPO
ENRENR-1340382026-01-31T05:29:22ZLarryVDean91450125UHC1754016•••-••-5909(527) 887-7114larry.dean@proton.me2474 Grand Ave·ChandlerAZUNKNOWNGRP-5679CORE-HMO
ENRENR-1216092026-10-17T15:30:28ZNATHAN—SETWARTJan 3, 1956UHC-78928-01•••-••-1204(453) 385-8395—3415 Camelback RoadSacramentoCA95864GRP-9839NAVIGATE-HMO
ENRENR-137674 2026-02-24T06:40:25ZJonathan—Harrison1979-05-07UHC-92177-58•••-••-8374(855) 279-6314JONATHAN.HARRISON@PROTON.ME4160 Sage CtAtlantaGA··30320GRP-9656OPTIONS-PPO
ENRENR-1223372026-04-06T11:00:08ZJaniceCGriffin1968-02-27UHC-07301-78—4403500362JANICE.GRIFFIN@PROTON.ME7508 MESA DROrlandoFL32844GRP-4047SELECT-EPO
ENRENR-1200942026-03-27T03:50:24Zfrank—rommero1972-06-16UHC-14499-44•••-••-04355428787390null3613 Mesa DrSacramentoCA95840GRP-7728MEDICARE-ADV-B
ENR ENR-1266792026-04-20T06:18:56Zsusan—jackson··1985-02-10UHC-17734-66•••-••-7588(574) 899-3895susan.jackson@hotmail.com1342 MOUNTAIN VIEW DRMesaAZ85280GRP-4996choice-plus-ppo
ENRENR-1351772026-09-21T12:36:58ZJerryZLane3/10/1952UHC-66444-97•••-••-7856(680) 627-1274—549 Forest AvenueMinneapolisMN55469GRP-8943MEDICARE-ADV-A
ENRENR-1288392026-04-12T11:18:22ZNANCY··MEJIA1955-12-04UHC-96159-26•••-••-9041886.429.0962NANCY.MEJIA@GMAIL.COM1300 Maple Avenue Apt 11PhoenixAZ85067GRP-4349navigate-hmo
ENRENR-1359132026-05-22T15:50:02ZAnderwX.Young1955-04-06UHC-82178-32•••-••-0786705-262-0263andrew.young@proton.me··2283 INDIAN SCHOOL RDGILBERTAZ85214GRP-7627MEDICARE-ADV-A
ENRENR-1161032026-02-05T00:50:56Z Scott—Wilson1954-03-26UHC-00397-82•••-••-60053785725892scott.wilson53@hotmail.com9053 LINCOLN WAY Apt 28SACRAMENTOCA95879GRP-2957·MEDICARE-ADV-A
ENRENR-1325732026-06-19T05:26:00ZJON·Q.DOMINGUEZ02/16/65UHC-49789-89•••-••-54448805625569jonathan.dominguez@yahoo.com1946 VALLEY VIEW DRIVELas VegasNV·89181GRP-1980select-epo
ENRENR-1154722026-05-26T14:35:31Zlucia—ryan19870506uhc-61623-91—nulllucia.ryan@proton.me5920 Elm StColumbusOH43294GRP-5820MEDICARE-ADV-B
ENRENR-1348382026-10-08T17:59:21ZScott—Robertson06/03/2002UHC-77048-48•••-••-1581(208) 628-7340null862 River RdAtlantaGeorgia-GRP-6449CORE-HMO··
ENRENR-1133102026-07-11T09:42:25ZGaryU.··Rodriguez1952-11-10UHC-65603-12•••-••-2785—gary.rodriguez44@icloud.com1707 Mesa Dr···ChandlerAZ85288GRP-6473CORE-HMO
ENRENR-1267452026-03-27T11:57:00ZGrace····Torrse1968-07-01··UHC-51384-95•••-••-250612812223534null·109 Baseline RdGlendale··AZ85303GRP-8679CORE-HMO··
ENR ENR-1009832026-03-17T02:13:08ZHenry, EmmaF—1980-04-13UHC-50050-99•••-••-4553(882) 947-6056emma.henry@aol.com9496 Cedar LnPlanoTX75032GRP-7668CORE-HMO
ENRENR-1317782026-04-03T17:36:26Zlucia—castro1956-03-02UHC-20377-50•••-••-9327(567) 659-1519lucia.castro11@icloud.com7981 BroadwaySCOTTSDALEAZ85251GRP-1431CHOICE-PLUS-PPO
ENRENR-1399562026-04-04T00:40:44ZJean··—Smith10/14/1938··UHC-00848-61•••-••-54513943785337JEAN.SMITH39@HOTMAIL.COM·4181 Lake View RdGilbertAZ85200···GRP-6826MEDICARE-ADV-A
ENRENR-1142502026-10-06T23:36:21ZChristian—Lopez1986-05-17UHC-99195-40•••-••-1526(680) 900-2567null6459 Jefferson AveSeattleWashington98150GRP-9059CORE-HMO
ENRENR-1174862026-05-13T15:36:36ZMARTHAB.CAMPBELL1939-01-15UHC-30282-20•••-••-37034762731071MARTHA.CAMPBELL85@GMAIL.COM4725 Highland AvePLANOTX··75075·GRP-7734MEDICARE-ADV-B··
ENRENR-1285092026-02-27T02:34:21ZRachelU.·Anderson1940-09-13·UHC-68512-24•••-••-3945N/A-8708 Union StreetLas VegasNV89130GRP-3654NAVIGATE-HMO
ENRENR-1106082026-08-02T13:31:49ZHEATHERA.HERNANDEZMar 19, 1977UHC-75070-81•••-••-0693(402) 627-9970—9822 Park PlSeattlewa98183·GRP-5898SELECT-EPO
ENRENR-1052922026-05-01T23:51:02ZLINDA—REYNOLDS1985-02-26UHC-23832-33•••-••-27929184405972·linda.reynolds@aol.com8419 CENTRAL AVE··Eden PrairieMN55322-2527GRP-9013CORE-HMO
ENRENR-1240272026-01-30T06:58:51Zarjun—lee··2002-06-15UHC-39082-75•••-••-9367985-318-7786UNKNOWN2981 BroadwaySeattleWA98142GRP-3731CORE-HMO
ENRENR-1081922026-07-11T04:06:09ZWilliam—Contreras05/25/1984UHC-31788-54UNKNOWN774-611-9428·N/A1811 Valley View DrMiamiFL33166GRP-8820MEDICARE-ADV-B
ENRENR-1139952026-09-05T14:12:27ZWAYNEF.HARPER1947-08-10UHC-60257-75•••-••-2048(338) 940-2227wayne.harper@proton.me6090 Church StreetColumbusOH43284GRP-4749SELECT-EPO
ENRENR-1316912026-07-20T05:32:16ZNicholas··Thompson05/12/1985null•••-••-9796715-364-1284··nicholas.thompson@outlook.com8063 PARK PLACEMINNEAPOLIS··MN··55465GRP-7398NAVIGATE-HMO
43,101 rows, page 334 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.630Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty