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-1248482026-07-19T06:26:33Z·Victoria—PorterSep 20, 1939UHC-68081-94•••-••-3200444-925-6654·victoria.porter@hotmail.com1342 Grand AveMesaAZNULLGRP-6664·MEDICARE-ADV-B
ENRENR-1061402026-01-31T03:54:48ZCatherine—Padilla1967-06-11UHC-52750-78•••-••-29472318254845··catherine.padilla97@gmail.com8339 LINCOLN WAYColumbus·OH43266GRP-9785CHOICE-PLUS-PPO
ENRENR-1334672026-03-15T19:43:43ZAlaxis····Rojas04/25/81UHC-53980-53•••-••-3051(850) 814-7941alexis.rojas88@gmail.com6919 BroadwayLas VegasNV89166··GRP-1514NAVIGATE-HMO
ENRENR-1341062026-07-19T12:27:27ZRuiz, EvelynD.—1969-09-25UHC-60263-23•••-••-6285(950) 628-6683EVELYN.RUIZ@OUTLOOK.COM1167 Mountain View Drive··ChandlerAZ85297GRP-4565SELECT-EPO
ENRENR-1210632026-07-14T13:50:54Z·CHARLOTTE—LOPEZ·05/07/54UHC-73997-97•••-••-13442682990590charlotte.lopez34@icloud.com4337 Sage CourtHoustonTX77053GRP-9797NAVIGATE-HMO
ENRENR-1247762026-04-03T23:14:18ZAHMED—KIM8/23/2004UHC-36297-46··•••-••-8940N/AUNKNOWN4911 Forest AveNashvilleTN37298GRP-7391CORE-HMO
ENRENR-1214922026-04-22T21:17:01ZCHRISTINE—DOMINGUEZ2/20/1966UHC-00465-65•••-••-7501(854) 435-5860CHRISTINE.DOMINGUEZ@OUTLOOK.COM7719 MARKET STLas VegasNV··89140··GRP-7550CORE-HMO
ENRENR-1027972026-06-07T06:55:17ZLAWRENCEHMORRIS··2007-08-11UHC5726142•••-••-68484032866679··4893 BroadwayTampa··FL33646-7262GRP-3469NAVIGATE-HMO
ENR ENR-1312162026-10-03T20:24:01ZBRITTANYDOLIVER12/26/1996UHC-41802-34•••-••-861519774439005brittany.oliver@yahoo.com1002 Willow CourtORLANDOFL32867GRP-6462··SELECT-EPO
ENRENR-1028982026-06-09T20:47:40ZJeremy—Chen1984-02-25UHC-89276-81•••-••-70319288435242—·8578 Union StColumbusOH··43238GRP-2877CHOICE-PLUS-PPO
ENRENR-1154932026-02-09T18:04:23ZashleyU.perry02/07/1987UHC-75552-09•••-••-9792(923) 893-8230-3205 Ridge RoadAtlantaGA30359GRP-6462··OPTIONS-PPO
ENRENR-1121882026-06-20T15:18:57ZMARY—ROSS1970-03-28UHC-16737-05•••-••-90603073488670mary.ross@proton.me7635 Harbor BoulevardLas VegasNV89116GRP-5454MEDICARE-ADV-B
ENR ENR-1144892026-07-31T07:40:17ZJOSEHPP.DANIELS2007-09-11UHC-51793-73•••-••-9033724.752.1909joseph.daniels@outlook.com8856 Palm DrTempeAZ85264··GRP-5471··SELECT-EPO
ENRENR-1200662026-07-28T10:01:01ZPHILIPAGRANT1990-09-27UHC-64888-16•••-••-9332(213) 863-5170—5762 Main StreetMesaAZ85227GRP-0703MEDICARE-ADV-A
ENRENR-1237682026-08-12T09:16:28Z·KIMBERLY—VARGAS06/22/86UHC-30183-37•••-••-7288UNKNOWNUNKNOWN5236 Cedar Ln Apt 20Los AngelesCA90023GRP-1179MEDICARE-ADV-B
ENRENR-1355502026-10-10T05:04:41ZBarnes, Isabella——02-09-1995UHC-98826-91null··2236578131N/A5646 Elm StFresnoCA93724GRP-5971CHOICE-PLUS-PPO
ENRENR-1025302026-06-28T07:56:06ZnathanXcarpenter26-06-1959·UHC-33486-31•••-••-2412778-838-6260··-3681 Meadow Ln··ScottsdaleAZ85218-7725GRP-1316MEDICARE-ADV-A
ENRENR-1128632026-09-08T23:31:05ZDENNIS—RAY1965-02-21UHC-13590-78•••-••-9671+1 855 661 8303··N/A9600 BASELINE RDATLANTAGA··30360GRP-5993CHOICE-PLUS-PPO
ENRENR-1299242026-07-30T17:24:05ZRAMOSP.HANNAH1989-05-18UHC-00055-77•••-••-4998(390) 675-5329hannah.ramos72@outlook.com6381 Desert Sky BoulevardDallasTX·75207GRP-0459CORE-HMO
ENRENR-1289362026-05-20T02:51:04ZDianeHFuller4/10/1973UHC-88946-77··•••-••-6035443.853.5915diane.fuller7@hotmail.com6380 Bayshore Drive #180Gilbert·AZ85252GRP-6356MEDICARE-ADV-A
ENRENR-1054032026-03-25T12:46:52ZAmanda··Morrison2003-01-12UHC-73807-14•••-••-28552494692364amanda.morrison@yahoo.com6629 Indian School RdTampaFL33645GRP-4490··CORE-HMO
ENRENR-1266032026-08-04T13:49:12Z·EMMAHPENA2007-12-15UHC-89588-48•••-••-2294213.547.7737UNKNOWN1716 SUNSET BLVDAustinTX78701GRP-9653OPTIONS-PPO
ENRENR-1109462026-02-04T01:17:46ZGeorge—Moreno1990-12-12UHC-81999-54•••-••-22474154713515··george.moreno27@proton.me5556 CAMELBACK ROADSAN DIEGOCA92194GRP-2211CORE-HMO
ENRENR-1177112026-01-13T05:45:54ZParker, JulieB.—1969-01-20UHC4409704•••-••-91846027967580—·5927 Camelback RdMINNEAPOLISMN55402GRP-5174MEDICARE-ADV-A
ENRENR-1317202026-08-26T10:42:55ZPATRICIALGIBSON1952-10-13UHC-08082-86•••-••-75057217943477patricia.gibson69@proton.me8177 Ocean AvenueDallasTexas75248GRP-7751core-hmo
ENRENR-1387772026-07-08T19:57:57ZPorter, Ronald——2005-09-09UHC-07489-34•••-••-1012(873) 625-2727RONALD.PORTER94@PROTON.ME786 Mesa Dr·Eden PrairieMN55339GRP-5530·SELECT-EPO
ENRENR-1004472026-03-25T15:46:50ZEddieJWilson2006-07-10UHC-81351-96··NULL7217311026NULL··8344 Bayshore DrDenverCO80215GRP-9673MEDICARE-ADV-A
ENRENR-1120322026-02-22T09:27:32ZSEANYPHILLIPS1946-11-03UHC-68068-92•••-••-1595(247) 616-5218SEAN.PHILLIPS70@AOL.COM5157 Apache BoulevardMesaAZ85269GRP-3232CORE-HMO
ENRENR-1336322026-10-08T02:38:41ZRICHARD—MONTGOMERYFeb 3, 1971UHC-26592-48•••-••-82388363666639richard.montgomery41@yahoo.com1231 MARKET STNashvilleTN37293GRP-6006··choice-plus-ppo
ENRENR-1132872026-06-22T23:08:02ZCARLOSG.PARKERDec 17, 2002UHC-78228-80•••-••-1889411-622-0215NULL2308 Union StJACKSONVILLEFlorida32207GRP-4540MEDICARE-ADV-A
ENR ENR-1132752026-01-05T08:51:48ZNataliePMcCoy10/2/2001UHC2656474··•••-••-2027(249) 615-0304natalie.mccoy28@yahoo.com7730 Hillcrest RoadCharlotteNC28237··GRP-7528NAVIGATE-HMO
ENRENR-1332242026-06-25T19:47:52ZRobertILee02/15/1999UHC-03033-16•••-••-2267912-330-0302ROBERT.LEE44@ICLOUD.COM8775 Spring StreetCHANDLERAZ85204GRP-0574CHOICE-PLUS-PPO
ENRENR-1299032026-05-02T23:30:32ZALAND.FORD1952-08-28UHC-52538-51•••-••-3726607-503-6930alan.ford24@hotmail.com6670 Baseline RoadGilbertAZ85280GRP-2784navigate-hmo
ENRENR-1209742026-03-29T19:36:42Ztyler—·padilla25-03-1974UHC-67281-64•••-••-5130+1 926 998 0496tyler.padilla39@hotmail.com7057 MESA DRTempeAZ85297-1062GRP-4846··MEDICARE-ADV-A
ENRENR-1109882026-10-16T10:46:55ZCarol—Vazquez19490112UHC-72645-15•••-••-2717(926) 838-7556—·7952 INDIAN SCHOOL RDTempeAZ85251GRP-2344CORE-HMO
ENRENR-1256572026-05-22T12:48:54Z·Valentina·YDiaz1972-01-15UHC-16438-71•••-••-56789699644654valentina.diaz40@aol.com6428 Canyon RdDenverCO80256GRP-8385MEDICARE-ADV-A
ENRENR-1044032026-08-14T18:42:57ZPETERH.·GARCIA·2007-10-13UHC-67677-72•••-••-88397043510997··peter.garcia@outlook.com7951 Camelback RoadLas VegasNV89167GRP-7625CHOICE-PLUS-PPO
ENR ENR-122469 2026-05-12T03:56:25ZSarahUJenkins1939-04-18UHC-83541-22•••-••-1751(982) 696-7743SARAH.JENKINS@AOL.COM4815 RIDGE RDOrlando·FL32889GRP-1360NAVIGATE-HMO
ENRENR-1053442026-03-25T10:12:17Zsusan—hunter1985-02-18UHC-60558-30•••-••-00215532740818susan.hunter87@yahoo.com7514 INDIAN SCHOOL ROAD·SCOTTSDALEAZ85214GRP-8764MEDICARE-ADV-B
ENRENR-1145332026-03-19T07:20:07ZBrendaZReed12/09/98UHC-48758-61•••-••-60695087030370brenda.reed32@icloud.com4270 Valley View Drive Apt 33San AntonioTX78221GRP-9014CHOICE-PLUS-PPO
ENRENR-1006732026-03-31T06:27:51ZEvelyn·LNguyen·1967-08-18UHC-91671-60•••-••-97393925464089evelyn.nguyen@gmail.com8788 MAIN STATLANTAGeorgia30342GRP-4783NAVIGATE-HMO
ENR ENR-106051 2026-07-01T09:10:43ZPriyaO·Warrne06/19/1958UHC-43262-29•••-••-4169933-386-8605PRIYA.WARREN@YAHOO.COM7010 Bayshore DriveTAMPAFL33653GRP-2297CHOICE-PLUS-PPO
ENRENR-1362772026-02-14T01:32:09ZBrittany—Tuucker1944-07-24UHC-93288-08•••-••-0936629.329.3433brittany.tucker@outlook.com3284 Maple Avenue #599ScottsdaleAZ85236GRP-3948MEDICARE-ADV-B
ENRENR-1081872026-03-16T02:13:39ZTimothy—Berry1976-03-12uhc-17139-84•••-••-7498(757) 203-5779TIMOTHY.BERRY@HOTMAIL.COM422 Meadow LnMinneapolisMN55414GRP-9771CORE-HMO
ENRENR-1049192026-04-08T16:15:52ZMateo—Wallace1968-04-26UHC-02296-86•••-••-6061831-823-3647null··5689 SAGE CTMINNEAPOLISMN··55498··GRP-6383CHOICE-PLUS-PPO
ENRENR-1378522026-09-26T19:55:41Z RogerE.Fernnadez1963-11-20UHC-76572-53•••-••-0396-roger.fernandez54@aol.com7593 MAIN STREET Apt 20SACRAMENTOCA95802GRP-5640CHOICE-PLUS-PPO
ENRENR-1118372026-06-13T20:51:12ZWalterO.Peterson1965-10-07UHC-30055-98•••-••-6877(739) 566-1763WALTER.PETERSON18@ICLOUD.COM·4110 Spring StreetSEATTLEWashington98144GRP-2726MEDICARE-ADV-A
ENRENR-129352 2026-10-03T12:07:34ZReynolds, Michael··M.—2006-01-17UHC-88165-10•••-••-3275442-721-6562—6996 Cedar LaneDallasTX75289GRP-5608CORE-HMO
ENRENR-1422542026-04-18T10:13:12ZRachelN.Holmes1982-08-28uhc-72535-35•••-••-25335398323—9194 Desert Sky BoulevardLos AngelesCA90001GRP-4346CORE-HMO
ENRENR-1115572026-08-30T13:40:28Z Janice—Hicks·2003-12-05UHC-96026-01•••-••-7166555-306-7619janice.hicks@gmail.com5392 OCEAN AVENUEAustinTX78754GRP-6611CORE-HMO
43,101 rows, page 147 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:38.471Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty