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-1232972026-08-03T11:39:11ZGEORGEKFERNANDEZ··Sep 21, 1972UHC-36073-65•••-••-7609519-460-3935N/A7541 Park PlaceColumbusOH43244GRP-6396SELECT-EPO
ENRENR-1276202026-09-29T02:19:52ZLori—Ruz2004-02-12UHC9645994•••-••-2439(816) 684-4985—5235 FOREST AVENUEMiamiFL33117GRP-9936MEDICARE-ADV-A
ENRENR-1112372026-09-21T11:03:59Z GaryVDay07/20/77UHC-44898-69•••-••-8317(429) 677-5374N/A5985 Jefferson AveDallasTexas75298GRP-0565CHOICE-PLUS-PPO
ENRENR-1075862026-06-25T00:27:37ZHENRYAMENDEZ1981-08-06·uhc-27527-73•••-••-3891·null—·7683 Meadow LnJacksonvilleFL··—GRP-8516···SELECT-EPO
ENRENR-1279662026-09-15T20:37:42ZBILLY—NUNEZ1963-06-06UHC-87066-40•••-••-1974—billy.nunez@icloud.com7160 Sunset BlvdTucsonAZ85731·GRP-6429MEDICARE-ADV-A
ENRENR-1262672026-05-25T14:30:14Z—X.—1994-02-07UHC7210405•••-••-4588860-351-9447roy.ruiz@icloud.com8276 Spring StreetLas VegasNVNULLGRP-8359NAVIGATE-HMO
ENRENR-108896 2026-04-14T15:53:56ZGLORIAC.··VASQUEZ1970-07-18··UHC-13633-38•••-••-1643·(739) 426-3633·gloria.vasquez@proton.me7394 Meadow Ln #747San AntonioTX78203GRP-4787MEDICARE-ADV-B
ENRENR-1090282026-07-10T07:21:56ZGREGORY—WILLIS1955-05-27·UHC-33667-24•••-••-8854(874) 272-0651GREGORY.WILLIS84@AOL.COM6304 PALM DRSeattleWA98104GRP-9188OPTIONS-PPO
ENRENR-1270542026-02-26T08:39:50ZNancy—Ferguson4/10/1971UHC-02890-41•••-••-0209(989) 481-3491NANCY.FERGUSON@HOTMAIL.COM664 Grand AvenueAtlantaGA30319GRP-6375CHOICE-PLUS-PPO
ENRENR-1409672026-10-07T04:48:32ZRALPHS.NGUYEN1959-03-10UHC-34004-03•••-••-2511758-236-8243ralph.nguyen@hotmail.com3418 APACHE BOULEVARDTampa··FL33632GRP-0548MEDICARE-ADV-B··
ENRENR-1364892026-04-11T06:56:59ZWAYNEZCRUZ09/07/1964UHC-31174-70•••-••-3355·4311718wayne.cruz@icloud.com5670 INDIAN SCHOOL ROADSeattleWAN/AGRP-9701··SELECT-EPO
ENRENR-1094052026-09-17T17:33:25ZAnaIPrice1949-12-07UHC6490114•••-••-7138551-203-1933—605 BroadwayJacksonvilleFL32257GRP-1942SELECT-EPO
ENRENR-1341672026-09-16T03:43:00ZMorgan, AnthonyY—2001-09-05UHC-23469-62•••-••-97612662700298—5791 Indian School RdScottsdaleArizonaN/AGRP-1140MEDICARE-ADV-A
ENR ENR-1091832026-09-26T03:28:26ZJOYCEY.SANTOSOct 19, 1955UHC-15519-28•••-••-03958255946871NULL6973 MESA DRDenverCO80237GRP-2910··CHOICE-PLUS-PPO
ENRENR-1231592026-08-27T17:04:28ZBeverly··Hicks1601-89-58UHC-10140-65•••-••-7134····BEVERLY.HICKS30@AOL.COM3610 Bayshore DrHouston·TX77040GRP-0832NAVIGATE-HMO
ENRENR-1072232026-06-30T10:20:00ZEmily··Martinez···Aug 11, 2004UHC-84850-46•••-••-7704(678) 673-6831emily.martinez@icloud.com9266 SAGE COURTORLANDOFL32811GRP-2526OPTIONS-PPO
ENRENR-1316732026-03-24T11:38:19Z·KellyV.Mendez1964-01-17UHC-91623-04•••-••-6008284-552-0296kelly.mendez77@outlook.com7328 Union StreetEden PrairieMinnesota55374GRP-6306NAVIGATE-HMO
ENRENR-1303092026-09-22T11:15:09ZCAROLYN—BUTLER1996-09-24UHC-60274-91•••-••-0816(312) 536-1293CAROLYN.BUTLER@OUTLOOK.COM116 MEADOW LANE Apt 3DenverCO80250-2055GRP-5560CHOICE-PLUS-PPO
ENRENR-1391822026-05-27T03:05:58ZAbigail—Cunningham1940-07-17UHC-38115-43•••-••-9293502-817-7506ABIGAIL.CUNNINGHAM@HOTMAIL.COM3547 Ridge RdGilbertAZ85298··GRP-6615CORE-HMO
ENRENR-1107252026-05-05T19:35:28ZElizabeth··—Edwards2004-12-03UHC-73277-83•••-••-26136913411644elizabeth.edwards52@outlook.com2881 Bayshore Dr·PhoenixAZ85007GRP-2758select-epo
ENRENR-1334542026-06-29T03:31:23ZPeterUCunningham··04/19/49··UHC-72694-61•••-••-6332nullpeter.cunningham@gmail.com331 Church Street·NashvilleTN37293GRP-5915··CHOICE-PLUS-PPO
ENRENR-1341412026-09-17T04:36:24Zhannah····vega1981-07-15UHC-67004-11•••-••-8109·2776576095·hannah.vega@hotmail.com3709 SAGE COURTPLANOTX75062GRP-4496OPTIONS-PPO
ENRENR-1050982026-06-19T09:38:08ZDonnaPGriffin10/13/1944··UHC-70525-73•••-••-02154248572041··DONNA.GRIFFIN71@HOTMAIL.COM9479 PINE DRIVECHANDLERAZ85257GRP-4582SELECT-EPO
ENRENR-1251302026-02-19T16:47:22ZSam—Johnstton··1951-06-13UHC-73743-62•••-••-7637936-422-9242null3367 DESERT SKY BLVD··SeattleWashington98113GRP-3473SELECT-EPO
ENRENR-1118882026-08-05T11:04:15ZBrittanyZWheeler··9/5/1971UHC-55556-45•••-••-6414961-704-3830—1233 Forest AvenueMiamiFlorida33162GRP-7140SELECT-EPO
ENRENR-1328362026-07-06T16:14:31ZGeraldRWatson1599-09-14UHC-18562-31•••-••-8048(367) 531-4555NULL9473 Palm DriveChandlerAZ85276GRP-8564NAVIGATE-HMO
ENRENR-1060432026-02-26T19:30:19ZValentinaK.Roberts26-06-2004UHC-42409-18•••-••-4158910.439.5806-8848 BASELINE RD Apt 20CharlotteNC28222GRP-2669··MEDICARE-ADV-B
ENRENR-1402402026-08-22T03:33:42Z·SHARON—DAVIS·1996-09-05uhc-22421-51•••-••-9602(367) 570-3349sharon.davis17@outlook.com8337 CANYON RDPlano·TX75066GRP-5391MEDICARE-ADV-A
ENRENR-1072032026-04-18T20:15:43ZemilyR·lopez19431214UHC-00216-34•••-••-9192646-835-3919EMILY.LOPEZ@ICLOUD.COM6843 Camelback Rd Apt 4Chandler·AZN/AGRP-3410CORE-HMO
ENRENR-1119162026-07-20T12:26:20ZSARA—SCHMIDT1983-10-15UHC-29342-37•••-••-8709252-486-4766··sara.schmidt76@yahoo.com6820 Willow CourtNashvilleTN37275GRP-9290CORE-HMO
ENRENR-1216832026-01-13T06:41:25ZJoshuaEYoung2003-09-05UHC-79976-16•••-••-93807109692931joshua.young88@outlook.com··8264 Bayshore DrHoustonTX77068GRP-5408MEDICARE-ADV-A
ENRENR-1066632026-09-18T03:21:01ZEDWARDVLAWRENCE·1997-02-10UHC-75221-98UNKNOWN5408405914EDWARD.LAWRENCE@YAHOO.COM8760 Jefferson AveNashville··TN37288GRP-6609··MEDICARE-ADV-A
ENRENR-1390252026-07-17T06:58:43Zjames—mills16-10-1982UHC-21607-68•••-••-8930-james.mills@yahoo.com9312 BroadwayLos Angeles··ca90068GRP-0224CHOICE-PLUS-PPO
ENRENR-1137112026-08-17T16:35:30ZDanielle—Wright4/6/1976UHC-97894-31•••-••-8417(886) 677-8019DANIELLE.WRIGHT22@AOL.COM4837 MESA DRDallasTX75281GRP-1055CORE-HMO
ENRENR-1351822026-01-10T06:52:45ZCHARLOTTE··—MORENO12/24/1998··UHC-12520-87•••-••-0358(373) 636-6572··charlotte.moreno@yahoo.com2579 Sage CourtSeattleWA··98107GRP-4504CORE-HMO
ENRENR-1024582026-09-08T06:39:05Z Virginia··Ellis1954-12-02UHC-03401-62•••-••-7103+1 511 509 6230virginia.ellis@hotmail.com5174 Forest AvenuePhoenixAZ85032-5106GRP-9742OPTIONS-PPO
ENRENR-1056612026-06-04T11:24:43ZAna U—Espinoza1996-11-19UHC-35329-82•••-••-9741909-335-5723ana.espinoza@icloud.com9821 Ridge RdPhoenix·AZ85045GRP-2413NAVIGATE-HMO
ENRENR-1370522026-02-11T14:24:01ZNCIOLE I—VEGA1965-06-28UHC-90651-35•••-••-2028317-229-9941nicole.vega78@outlook.com7571 Palm DrMesaArizona85244GRP-4015MEDICARE-ADV-A
ENRENR-1395802026-10-01T02:14:54ZEthanE.··Gardner1961-03-01·UHC-07381-68•••-••-3849758-381-1982N/A8361 INDIAN SCHOOL RDNASHVILLETN37248··GRP-6155··MEDICARE-ADV-B
ENRENR-1069192026-05-28T16:45:41Z Nicholas··DLane1996-05-19UHC-57583-18•••-••-656312276288685nicholas.lane@yahoo.com7226 CAMELBACK RDTucsonArizona85765GRP-6116NAVIGATE-HMO
ENRENR-1134412026-02-20T18:31:13ZTeresaJ.Hanson1951-09-17UHC-21907-74•••-••-5591355-873-1205teresa.hanson@aol.com2999 Pine DriveJacksonvilleflUNKNOWNGRP-2734NAVIGATE-HMO
ENRENR-1049242026-09-02T10:05:48Z William—Ward·1984-05-17·UHC-96074-07•••-••-9851—N/A5716 Mountain View DriveHoustonTX77051GRP-7332CHOICE-PLUS-PPO
ENR ENR-1023282026-09-30T22:57:33Z Bobby—Kelly1975-04-25··UHC-98988-55•••-••-4939·387-583-2552bobby.kelly@proton.me5505 WASHINGTON STColumbusOH43298GRP-0854NAVIGATE-HMO
ENRENR-1424852026-07-21T07:05:56ZLINDAVPAYNE12/06/93UHC-07120-79•••-••-92618087800471linda.payne16@outlook.com321 MOUNTAIN VIEW DRIVEAtlantaGA30334-2743·GRP-5646MEDICARE-ADV-B
ENRENR-1398582026-04-30T15:05:38Z·ANDREA—·ORTIZ1980-09-18UHC-56559-86•••-••-49933729069609·andrea.ortiz@hotmail.com662 UNION STREETTUCSONAZ85792GRP-9784CORE-HMO
ENRENR-134180 2026-06-03T11:40:25ZMadisonOAndrews1950-08-12UHC-68811-47•••-••-8761(769) 481-3712madison.andrews@icloud.com8118 Cedar Ln··OrlandoFL32878·GRP-0252·CHOICE-PLUS-PPO
ENR ENR-1233812026-01-18T19:21:44ZSusanX.Burns0200-04-10UHC-68235-49NULLUNKNOWNsusan.burns@hotmail.com4393 Ridge RoadDenverCO80253GRP-3225NAVIGATE-HMO
ENRENR-1185092026-01-24T12:17:55ZPhilipFMarquezMar 26, 1948UHC-49407-03•••-••-8818·14186488416philip.marquez@yahoo.com7585 CEDAR LN··ColumbusOH43216GRP-7232MEDICARE-ADV-B
ENRENR-1366772026-04-01T19:37:17ZRuth—JonesMar 16, 1983UHC-19292-41•••-••-3429(437) 992-1122ruth.jones60@aol.com5065 Sage CtFresnocaN/AGRP-1689CORE-HMO··
ENRENR-1310652026-04-22T02:02:33ZMartha··—BradleySep 3, 1969UHC6604335•••-••-4647·+1 808 476 5256N/A385 Market StHouston·TX77051GRP-2526MEDICARE-ADV-B
43,101 rows, page 34 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:34.794Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty