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-1063402026-08-12T07:19:36ZChuck—Peterson1957-12-27UHC-60674-13•••-••-6913NULLcharles.peterson@yahoo.com6660 Palm Drive·SAN DIEGOCA92196·GRP-7537MEDICARE-ADV-B
ENRENR-1181882026-09-14T08:21:28ZKYLE—PETERSON1978-11-06UHC-43052-24•••-••-6451(844) 965-2723·kyle.peterson@proton.me·258 Valley View DriveChandlerAZ85254GRP-5093MEDICARE-ADV-B
ENRENR-1021982026-03-09T21:07:47Zterry—mitchell20020402UHC-32734-81•••-••-5314(461) 299-1367—·N/A—N/A—GRP-8790CHOICE-PLUS-PPO
ENRENR-1146552026-01-10T03:51:50Zmaia—nichols1984-12-26···UHC-63435-65—19379006222maria.nichols1@proton.me1856 WILLOW CTMinneapolisMN55464GRP-3620MEDICARE-ADV-B
ENRENR-1045112026-05-02T03:01:06Z Kathryn—Pierce19390221UHC-95401-16•••-••-87865335257449····9528 Washington StTampaFL33628GRP-8811CORE-HMO
ENRENR-1321802026-08-27T02:16:50Zlarry—dean1975-01-15UHC-49666-42•••-••-2137(311) 796-3600null2453 BASELINE ROADPlanoTX·75063GRP-3972CHOICE-PLUS-PPO
ENRENR-1308712026-08-20T18:29:53Z Nelson, Wayne——18-08-2003UHC-16289-79•••-••-5402·640.327.6604wayne.nelson38@aol.com4213 Spring Street··CharlotteNorth Carolina28293GRP-5501MEDICARE-ADV-A
ENRENR-1392312026-02-20T21:57:54ZMartha—Murphy··2004-02-02UHC7943755•••-••-63985074682456martha.murphy20@gmail.com2029 Lake View RdMiamiFL33172··GRP-6184MEDICARE-ADV-B
ENRENR-1024322026-05-09T15:16:00Zsean—ramirez·2007-05-18N/A•••-••-730215247148147SEAN.RAMIREZ32@YAHOO.COM4657 Ridge RdLas VegasNV—GRP-3971MEDICARE-ADV-A
ENRENR-1120682026-08-20T21:29:20ZSEANZWONGJan 11, 2004UHC-75717-43•••-••-0413(809) 254-9902··4667 Mountain View DrSacramentoCA95841GRP-5344MEDICARE-ADV-A
ENRENR-1334872026-02-12T00:00:42ZKIMBERLY—BRYANT19990119UHC-33003-66•••-••-94725967351509-1902 WILLOW COURTDallasTX75298GRP-9231MEDICARE-ADV-A
ENRENR-1337062026-02-10T01:41:51Z·Kyle—Gutierrez1985-06-25·UHC-54282-37•••-••-152512944903509—7358 Mesa DriveChandlerAZ85244GRP-2410MEDICARE-ADV-A
ENRENR-1082942026-01-22T02:49:56ZTerry··TBoyd2004-01-23UHC-83315-11•••-••-9037(945) 689-5672terry.boyd@yahoo.com4571 Bayshore DriveScottsdaleAZ85272-7807GRP-8291OPTIONS-PPO
ENRENR-1288072026-08-31T09:47:01ZFox, Rebecca——04/23/2000UHC-17190-79•••-••-3251N/AREBECCA.FOX48@GMAIL.COM9718 Main Street·FresnoCalifornia93789GRP-6836MEDICARE-ADV-B
ENRENR-1069962026-10-17T01:22:27ZMATEO··ARMSTRONG09/02/90UHC-08356-33•••-••-4692233-289-6184MATEO.ARMSTRONG@OUTLOOK.COM6290 GRAND AVEColumbusOH43257GRP-1140choice-plus-ppo
ENRENR-1119902026-03-27T16:30:44Z·Jensen, NicoleQ—11/22/1995UHC-78290-10•••-••-591515034682713·nicole.jensen48@proton.me7398 Indian School RdPHOENIXAZ85066GRP-5112SELECT-EPO
ENRENR-1185802026-03-15T11:00:49ZElizabethR.Howard2001-12-10UHC-92165-97•••-••-89559623847102—6188 Church StreetSan AntonioTX78214GRP-3175NAVIGATE-HMO
ENRENR-1023932026-09-20T00:49:51Z·HYROSHIIREYNOLDS1965-06-21UHC1420471•••-••-37993935296025·HIROSHI.REYNOLDS63@YAHOO.COM2054 Sunset Boulevard Apt 28SacramentoCA95897GRP-3130CORE-HMO
ENRENR-1050142026-08-14T03:06:00ZPATRICK—·SANTIAGO2000-03-24UHC-60151-68•••-••-97933728871487patrick.santiago5@outlook.com3196 Grand AvenueMinneapolisMN55411GRP-8808·CHOICE-PLUS-PPO
ENRENR-1163362026-07-27T02:41:28ZStone, Ethan——2001-09-01UHC-67874-86•••-••-8151(552) 611-1376ethan.stone@icloud.com7123 Washington StAustinTX78758GRP-5993··MEDICARE-ADV-B
ENRENR-1003452026-04-22T12:49:58ZShirleyDReynolds1973-09-12UHC-14074-32•••-••-1639·3387648N/A6472 Desert Sky BoulevardHoustonTX77024GRP-2765NAVIGATE-HMO
ENRENR-1372292026-01-03T13:30:28ZMcCoy, RoyC—·19471112UHC-81798-84··UNKNOWN589-538-1300N/A··4969 Central AveJacksonvilleFL32285GRP-8541CHOICE-PLUS-PPO
ENRENR-141356 2026-09-21T14:52:29ZALEXXIS—RICHARDSON1966-10-20UHC-21092-12•••-••-1195442-798-2849alexis.richardson87@aol.com8579 BASELINE ROADNashvilleTN37202GRP-9987CHOICE-PLUS-PPO
ENRENR-1311482026-09-05T20:48:03ZChristineZPadilla2006-02-11UHC-33734-43•••-••-87222545215146christine.padilla50@aol.com2873 Baseline RoadTucsonAZ·85796GRP-1499MEDICARE-ADV-B
ENRENR-1049172026-06-22T19:10:58ZWalter—Luna1983-12-04uhc-28452-62•••-••-70215946404747-97 HIGHLAND AVEMINNEAPOLISMN55496GRP-9423MEDICARE-ADV-A
ENRENR-1338992026-08-17T17:55:09ZRichardZHeernandez4/25/1978UHC-02619-10•••-••-9749(229) 494-6300richard.hernandez72@proton.me4938 Palm DriveGlendaleAZ85332GRP-8381MEDICARE-ADV-B
ENRENR-1059322026-09-01T21:48:49Z WELTERU·COLEMAN9158-02-24UHC-46983-59··•••-••-4041—WALTER.COLEMAN@AOL.COM4297 Canyon RdHoustonTexas77060GRP-4191SELECT-EPO
ENRENR-1200612026-01-17T11:36:08ZJerryIArmstrong1940-04-10UHC-40480-51•••-••-80989672200978—6898 Mountain View DrPhoenixAZ85058GRP-4322CHOICE-PLUS-PPO··
ENRENR-1156632026-06-26T12:07:04Zrobert—bennett2005-04-06UHC-32983-28•••-••-697314747754371UNKNOWN1054 Baseline RdTampaFL33687GRP-6071MEDICARE-ADV-A
ENRENR-1053082026-01-01T15:02:54ZCamilaC.Alvvarez1980-08-27UHC-42387-32NULL(555) 907-0822camila.alvarez34@proton.me261 Park PlSan AntonioTX78242GRP-5541SELECT-EPO
ENRENR-1269242026-08-06T12:27:36ZBOBBY··RYAN19750326UHC-70615-05•••-••-2198559-680-6656bobby.ryan@proton.me9661 BroadwayMinneapolisMN55435-1779GRP-1002OPTIONS-PPO
ENRENR-1298882026-02-24T20:00:23ZMaria—Weaver1949-11-06UHC-94898-32··•••-••-6838+1 638 499 4857maria.weaver88@yahoo.com7140 CEDAR LANEMesaAZ85247GRP-1641MEDICARE-ADV-B
ENRENR-1080882026-09-05T09:16:35ZJesseRHudsonJul 5, 1980···UHC-11447-56•••-••-11159543492522·jesse.hudson56@yahoo.com9481 Baseline RdSan AntoniotxNULLGRP-2650SELECT-EPO
ENRENR-1146972026-08-11T12:12:48ZLawrence, HelenQ.—1963-21-02UHC-80612-08··•••-••-4999·N/Ahelen.lawrence@outlook.com·6412 Grand AveMesaaz85276GRP-1734MEDICARE-ADV-B
ENRENR-1252702026-07-29T20:47:53ZBradleyH.Arnold07-06-1982UHC-81020-33•••-••-7631(511) 532-3711bradley.arnold@aol.com112 Ocean AvenueEden PrairieMN55316-9258GRP-2359core-hmo
ENRENR-1263622026-02-15T21:23:43ZEDWARDWELLIOTT·1979-05-08UHC-33180-88•••-••-87789205284936··2976 Park Pl Apt 6TempeAZ85230GRP-7937CHOICE-PLUS-PPO
ENRENR-1018162026-01-22T06:50:11ZMARIA—·JONES3/13/1986UHC-87021-76•••-••-6895436-981-0040MARIA.JONES@AOL.COM9532 Elm Street #575··CharlotteNC28268GRP-8924OPTIONS-PPO
ENRENR-1227992026-09-09T02:58:21ZGARRETT—JAMES0217-91-61UHC-83000-74····588.903.1339JAMES.GARRETT34@PROTON.ME7858 Spring StreetSacramentoCA95889GRP-6991CHOICE-PLUS-PPO
ENRENR-1340252026-02-19T06:09:55Zjack—hamilton1974-09-27·UHC-04710-99•••-••-9824+1 602 663 6230jack.hamilton72@outlook.com8425 Harbor BlvdMesaAZ85202GRP-0734MEDICARE-ADV-A
ENRENR-1224462026-01-18T02:57:21ZLaurenCMontgomery··1983-02-01UHC-75031-08··•••-••-3818(604) 400-0336UNKNOWN3614 CANYON RDFresnoCAnullGRP-5686medicare-adv-a
ENRENR-1099372026-08-10T11:37:07ZAlice I··—Murphy09/28/1967··UHC-19582-46·N/A+1 351 885 4451ALICE.MURPHY@HOTMAIL.COM6768 BASELINE ROADTAMPAfl33640GRP-0770NAVIGATE-HMO
ENRENR-1135572026-03-10T22:25:37Z ·JesseBHunt··1979-07-14UHC-22799-81—339-464-9647jesse.hunt@proton.me387 Central AvenueMiamiFL33155GRP-1890CORE-HMO
ENRENR-1020872026-10-17T05:39:16ZSchmidt, KathrynT—1956-10-09UHC-18595-46NULL6415188744kathryn.schmidt81@icloud.com·5650 Pine DrTucsonAZ85714GRP-8397·navigate-hmo
ENRENR-1099782026-08-02T18:31:17ZTYLERE·GILBERT04/17/1963UHC-87670-08•••-••-2291203.645.9684TYLER.GILBERT@GMAIL.COM3495 Mesa DriveHoustonTX77061GRP-9942OPTIONS-PPO
ENRENR-1369612026-07-07T22:27:36ZJUDITH—WEBB1948-09-19UHC-38703-93··•••-••-1120·460-346-6201UNKNOWN5335 SPRING STREETSeattleWA··nullGRP-2841CHOICE-PLUS-PPO
ENRENR-1241362026-06-10T12:34:18ZColeman, Justin——1971-12-12UHC-68642-60•••-••-1685536-994-9753justin.coleman21@aol.com3927 Valley View DrMESAaz85279-1718GRP-0383SELECT-EPO
ENRENR-1071212026-08-15T04:00:59ZCHARLOTTEG.LUNAJan 18, 1981UHC-13811-07•••-••-20914598681878UNKNOWN1930 Cedar LnCHARLOTTENC28227GRP-1201OPTIONS-PPO
ENRENR-1181812026-07-17T01:43:32ZALEXISG.AGUILAR06/28/2006UHC-01502-04•••-••-71836814128467alexis.aguilar@icloud.com5072 Ocean AvenueTUCSON·AZ85760·GRP-8694MEDICARE-ADV-B
ENRENR-1266822026-01-30T17:09:00Z·BeverlyIChen1946-04-03UHC-40588-67•••-••-3726711.239.4905BEVERLY.CHEN71@AOL.COM3317 PARK PLACELas VegasNV·89155GRP-0901MEDICARE-ADV-A
ENRENR-1268402026-04-20T01:35:58ZsandraDreynolds1954-03-23UHC-76244-66•••-••-5095758-343-6760sandra.reynolds@proton.me7653 VALLEY VIEW DRIVEAustinTX·78785GRP-6237CORE-HMO
43,101 rows, page 129 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:37.771Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty