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-1099352026-03-04T00:56:57Z McDonald, Steven——2/17/1967UHC-91479-96•••-••-4304—steven.mcdonald@icloud.com2152 Baseline RdLos AngelesCA90003GRP-3715OPTIONS-PPO
ENRENR-1327452026-09-08T07:52:11ZCharlesNOrtiz1938-04-02uhc-92395-20•••-••-9223—N/A·6243 Hillcrest RdGLENDALEAZ85395GRP-8629SELECT-EPO
ENRENR-1263872026-08-29T07:38:04ZDonaldKWells1959-12-16UHC-76669-77•••-••-04975245484-96 HILLCREST RDJacksonvilleFL-GRP-3397·CORE-HMO
ENRENR-1061222026-07-11T03:52:25ZHANNAH·AWOOD1982-10-02·UHC-77455-70•••-••-07473356137914HANNAH.WOOD40@GMAIL.COM8882 HARBOR BOULEVARD··HOUSTONTX77005GRP-2372MEDICARE-ADV-B
ENRENR-1038132026-09-30T06:25:53ZfrancesO.bailey1996-09-28UHC9180104•••-••-1756373-299-9548frances.bailey20@hotmail.com·8364 Park PlNashvilleTN37226GRP-6289NAVIGATE-HMO··
ENRENR-1117952026-08-05T08:38:41ZChristopher—Hakwins·1961-01-06UHC-49024-83•••-••-0503493-374-1481CHRISTOPHER.HAWKINS58@GMAIL.COM3215 Meadow LaneOrlandoFL32889GRP-2728CORE-HMO
ENRENR-1048372026-02-23T05:13:58ZDONALDTYOUNG1967-05-24UHC-33322-36•••-••-3572(722) 888-1214DONALD.YOUNG@AOL.COM5271 Lake View RoadDenverCO80288GRP-7732select-epo
ENR ENR-1315182026-01-08T06:33:47ZHowell, Eric——1979-04-28··UHC-71912-02•••-••-01896736422254—3344 Maple Ave··ScottsdaleAZ85259-1783GRP-4250CHOICE-PLUS-PPO
ENRENR-1257562026-03-15T06:23:51ZSharon—Li1966-06-17—•••-••-0217367-543-9420sharon.li54@yahoo.com183 PALM DRIVEHoustonTX77038·GRP-3096SELECT-EPO
ENRENR-1050542026-05-04T20:25:23ZAaron—Guzman1981-05-22UHC-47230-13··•••-••-4561(451) 917-0178—7203 LINCOLN WAYSacramentoCA95870GRP-8821·MEDICARE-ADV-B
ENRENR-1091992026-05-20T05:15:56ZDANIELLEPELLIOTT1987-11-06UHC-10138-47•••-••-133114158089417danielle.elliott@yahoo.com5017 Indian School Rd #665MIAMI·FL33123GRP-3687NAVIGATE-HMO
ENRENR-1340802026-07-30T11:58:52ZKayla—Cole2008-02-27UHC-60226-22•••-••-0377650-613-0209kayla.cole@outlook.com--null—GRP-3371SELECT-EPO
ENRENR-1010292026-08-26T20:24:25ZPrice, Sam——1987-11-25UHC0762281—6732372079-3203 Central AvenueAtlantaGA30365·GRP-7510CORE-HMO
ENRENR-1130212026-02-22T09:18:51ZHeatherYEvans·2003-03-02UHC-76499-62null+1 691 754 9471heather.evans43@hotmail.com7148 Maple AvenueChandlerAZ85286GRP-5821·MEDICARE-ADV-A
ENRENR-1155832026-01-15T06:59:20ZJordan—PerkinsMar 3, 1951·UHC8450472•••-••-1307947-482-2634jordan.perkins22@icloud.com9661 Mesa DriveCharlotteNC28231GRP-4234MEDICARE-ADV-B
ENR ENR-1124692026-06-08T10:22:17Z·KYLE—LI05/20/46·UHC2522710•••-••-43164228794927··null1871 Ocean AveCharlotte·NC·28217GRP-1937OPTIONS-PPO
ENRENR-1224352026-02-04T09:33:34ZStevens, JosephV—1941-06-23UHC-00310-60•••-••-42059864173783—7994 Sage CourtDenverCO80234GRP-2278OPTIONS-PPO
ENRENR-1195362026-04-18T14:27:25ZPETER·T.GILBERT12/23/1961UHC-05029-61•••-••-8587318.253.0104peter.gilbert@gmail.com·4458 Canyon RdTUCSONAZ85775GRP-0516MEDICARE-ADV-B
ENRENR-1001172026-04-27T16:12:24ZNicole—Andrews1968-04-17UHC-39588-61•••-••-9290810-884-0508nicole.andrews@aol.com5611 RIDGE ROADLos AngelesCalifornia90089GRP-5330SELECT-EPO
ENRENR-1297282026-05-26T22:38:15ZLuis·SHoffman1975-12-13UHC0846137•••-••-2445UNKNOWNnull1769 Main StNashvilleTN37258-6973GRP-1266CORE-HMO
ENRENR-1076732026-03-08T17:35:46ZGERALD—HICKS1961-08-17·UHC-08421-76•••-••-5291·-gerald.hicks@gmail.com1346 Spring StSacramentoCA95874GRP-4980NAVIGATE-HMO
ENRENR-1261332026-08-30T14:57:31ZDORIS—CHAVEZ1945-06-01UHC-61116-89•••-••-9460+1 621 916 2496—3286 Bayshore DriveGilbertAZ85234·GRP-3071SELECT-EPO
ENRENR-1378452026-08-10T16:15:56ZWALTERO·CARLSON1955-10-26UHC-39159-19•••-••-5579·4295406549WALTER.CARLSON91@OUTLOOK.COM2773 MOUNTAIN VIEW DRIVEPhoenixAZ··85067-3634GRP-9668MEDICARE-ADV-A
ENR ENR-1197892026-01-23T16:31:27Z ERICLMASON04/10/2003UHC-55877-55•••-••-87299637238088eric.mason@icloud.com8964 BroadwayMiami··FL··33176GRP-5172SELECT-EPO
ENRENR-1200122026-06-16T08:30:39ZJUSTINVRAMIREZ11/23/86UHC7927351•••-••-556015684645075justin.ramirez92@gmail.com6629 Lincoln Way·Fresno·CA93707GRP-5555OPTIONS-PPO
ENRENR-1083722026-03-06T09:04:05ZMargaretR··Lawrence1965-05-19UHC-37511-76•••-••-9964····margaret.lawrence@outlook.com9453 Mountain View DrHouston·TX77054GRP-2523·MEDICARE-ADV-A
ENRENR-1397752026-01-04T02:13:31ZBailey, KarenS····1977-07-25UHC-82830-37•••-••-408415964284904karen.bailey@gmail.com1731 Main StreetPhoenixAZ85086GRP-3099OPTIONS-PPO
ENRENR-1097782026-05-16T18:41:16ZNatalieBAguilar04/01/52UHC-36549-46•••-••-2896464-283-3272NULL91 Mesa DriveJacksonvilleFL32297GRP-1496OPTIONS-PPO
ENRENR-1409082026-08-16T07:06:52ZSTEPHANIEQESTRADA19640214UHC-43451-45null··3057550529—4064 Baseline Road··San DiegoCA92141GRP-9096SELECT-EPO
ENRENR-1243552026-08-15T12:49:57Zbrittany—estrada09/22/47UHC-93844-26•••-••-3633·333-786-3966—2434 DESERT SKY BOULEVARDFresnoCA93733··GRP-6631MEDICARE-ADV-B
ENRENR-1374582026-09-27T06:22:48ZSalazar, JacquelineF—1945-04-25UHC-37624-77NULL514-765-5952jacqueline.salazar@hotmail.com·7958 Bayshore Drive #730San AntonioTX78239·GRP-2399CHOICE-PLUS-PPO
ENRENR-1024162026-06-17T18:42:36ZCATHERINE···J.BISHOP1967-10-17··UHC-74567-41•••-••-16332628916417catherine.bishop@icloud.com513 Ocean AvenueTempeAZnullGRP-8273MEDICARE-ADV-A
ENRENR-1232172026-10-11T23:24:33ZJoyce—Bryant20-12-1964UHC2897437•••-••-411312048651733JOYCE.BRYANT@GMAIL.COM8094 Central AvenueAustinTX78739GRP-9524CHOICE-PLUS-PPO
ENRENR-1123102026-05-31T22:30:05ZTERESA—WILLIAMSON··01/26/81··UHC-54512-54—·+1 414 216 2987teresa.williamson6@aol.com2913 LINCOLN WAYDALLASTX75257GRP-6578SELECT-EPO
ENRENR-1140822026-02-05T05:43:03ZdeniseG·castro1977-02-14UHC8285546•••-••-0141(261) 575-0378denise.castro@outlook.com7730 Highland AveDenverCO80294··GRP-0446SELECT-EPO
ENRENR-1114602026-01-04T11:32:29ZLoriSButler1981-02-20UHC-75436-96•••-••-24874306655702lori.butler58@icloud.com405 INDIAN SCHOOL ROADNashvilleTN37270GRP-8337SELECT-EPO
ENRENR-1220252026-10-01T02:13:54Z CHARLES·R.RILEY1955-10-23UHC0474728•••-••-8014240-706-8417CHARLES.RILEY25@ICLOUD.COM9365 VALLEY VIEW DRIVEDenverCO80237··GRP-2602MEDICARE-ADV-A
ENRENR-1254292026-04-12T13:52:05ZAustinR.Cunningham2004-12-11·UHC7126256•••-••-45382836784austin.cunningham@aol.com4366 Forest AvePHOENIXAZ·85002GRP-8055CORE-HMO
ENRENR-1176732026-04-01T09:18:08ZMelissaG··Palmer6/18/1959UHC-34264-24•••-••-33177266902587UNKNOWN1888 Cedar LaneDenverCO·80267GRP-1418NAVIGATE-HMO
ENRENR-1021672026-07-11T22:10:26ZNicholasX.Stevens01/19/1966UHC-17491-69•••-••-500714163756819··nicholas.stevens65@yahoo.com7772 Washington StreetTampaFL33653GRP-8743·NAVIGATE-HMO
ENRENR-1354132026-05-14T08:06:22ZTerryVLe3/25/1984UHC-38720-12•••-••-1247··N/A··825 UNION STREETDenverCO···80279GRP-4896navigate-hmo
ENRENR-1283162026-08-04T16:59:09ZMorris, Arjun——1999-02-21UHC-36733-02N/A8436328177arjun.morris@yahoo.com·3815 Cedar LaneScottsdaleAZ85290GRP-7771CHOICE-PLUS-PPO
ENRENR-1425162026-03-02T06:30:04ZWillieK.Stone08/28/02UHC-76277-46-——2135 Willow CourtAustinTexas78763GRP-2668MEDICARE-ADV-B
ENRENR-1272412026-03-07T22:05:25ZRUSSELL—FERNANDEZ1977-05-25UHC-14589-20•••-••-5909593-556-5458russell.fernandez17@hotmail.com1840 Camelback RdDallasTX75281GRP-4027CHOICE-PLUS-PPO
ENRENR-1099442026-02-16T15:25:27ZHannah—Clark1981-05-15·UHC-95602-29•••-••-41856819926218HANNAH.CLARK4@OUTLOOK.COM2713 Jefferson AvenueFresnoCA93737GRP-5671NAVIGATE-HMO
ENRENR-1279982026-04-01T03:43:48ZAlan—Lynch1993-06-03UHC-34481-19•••-••-3315(846) 260-9334··alan.lynch20@proton.me8507 Bayshore DriveTampa··FL33662·GRP-0704select-epo
ENRENR-1356482026-03-01T20:12:15Z isabella··shaw1941-12-25UHC-39807-38•••-••-1077236.275.9428isabella.shaw@hotmail.com9248 PARK PLLas VegasNV89139GRP-8573MEDICARE-ADV-B
ENRENR-1125802026-01-11T14:24:44ZNICOLE L—HAYES19811201UHC3788845•••-••-3157·(382) 402-4491NICOLE.HAYES84@PROTON.ME8810 Cedar LaneColumbusOH43209GRP-8572NAVIGATE-HMO
ENRENR-1162752026-05-05T20:11:32ZBRITTANY—MAALDONADO1971-09-18UHC-59228-39•••-••-21965598101932brittany.maldonado60@proton.me147 LAKE VIEW RDMiamiFL33133GRP-7137OPTIONS-PPO
ENR ENR-1201392026-08-03T05:53:54ZRogerRAguilar0706-17-99UHC-34944-90UNKNOWN7769273954ROGER.AGUILAR4@GMAIL.COM6818 BASELINE ROAD·MINNEAPOLISMN55482GRP-6684CHOICE-PLUS-PPO
43,101 rows, page 226 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.605Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty