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-1316362026-03-26T22:52:45ZBenjaminUMiller1945-10-25UHC-39246-17•••-••-0645(824) 586-4651BENJAMIN.MILLER92@AOL.COM2990 Sage CtSacramentoCA95849GRP-5782CHOICE-PLUS-PPO
ENRENR-1338452026-01-10T22:12:05ZHaroldQLittle1988-09-28UHC-98462-25•••-••-0112734-619-3867·HAROLD.LITTLE@AOL.COM9630 UNION STREETCharlotteNC28286GRP-4853MEDICARE-ADV-B
ENRENR-1343952026-02-02T17:37:26Z·KEVINI.BROOKS1995-12-17UHC-23257-02•••-••-0137(700) 401-9902—7454 Valley View Dr··ColumbusOH43205GRP-6148OPTIONS-PPO
ENRENR-1114642026-09-28T20:36:17ZGARYKSTONE1958-03-14UHC-84473-40··•••-••-3295NULLGARY.STONE42@HOTMAIL.COM9048 Church StSAN ANTONIOTX78241GRP-1030SELECT-EPO
ENRENR-1306642026-07-17T12:06:58ZDEGOZCUNNINGHAMJan 24, 1995UHC-87978-96•••-••-034918898050217DIEGO.CUNNINGHAM38@ICLOUD.COM·2574 BroadwaySan DiegoCA92134GRP-2622NAVIGATE-HMO
ENRENR-1271652026-06-20T02:24:00Z·melissaFhansenMar 18, 1996UHC-30457-37•••-••-1199·-MELISSA.HANSEN71@OUTLOOK.COM5176 Lincoln WayLas VegasNV89109GRP-0912NAVIGATE-HMO
ENRENR-1235022026-01-27T11:24:52ZHeetherMSanchez1996-06-03UHC-14155-80•••-••-7781386-731-4497—3323 Park PlChandlerAZ85293GRP-4514OPTIONS-PPO
ENR ENR-1268562026-08-31T10:55:25ZJessica—Miller08-02-1952UHC-28040-04•••-••-2097NULLjessica.miller@proton.me8223 Jefferson AvenueJACKSONVILLEFL32252GRP-1288MEDICARE-ADV-B
ENRENR-1288092026-09-02T08:05:49ZPriya—Ortiz1943-10-11UHC-82529-11•••-••-0960(622) 835-8243PRIYA.ORTIZ35@YAHOO.COM9244 Mesa DrPhoenixaz85012GRP-1507OPTIONS-PPO
ENRENR-1216362026-03-10T18:52:07ZDonnaFBurton1941-04-09UHC-76175-26•••-••-6248564-618-1356donna.burton@outlook.com4192 Forest AveTucsonArizona85793GRP-8997OPTIONS-PPO··
ENRENR-1109562026-05-09T11:36:08ZNguyen, DiegoD.—1985-12-09···UHC-13195-60-306-849-2793diego.nguyen@outlook.com7290 Hillcrest RdTempeArizona85278GRP-5205SELECT-EPO
ENRENR-1047172026-09-19T14:44:07ZAARON—SNIGH··1967-11-06UHC-35905-29—-aaron.singh@icloud.com8060 BroadwaySeattle·WA98153GRP-3721··CORE-HMO
ENRENR-1328212026-04-20T22:07:47ZcynthiaVmcdonaldN/AUHC3332797•••-••-51736929645537cynthia.mcdonald@icloud.com1243 Bayshore Drive Apt 14DenverCO80265GRP-4230NAVIGATE-HMO
ENR ENR-1176042026-09-07T02:23:46ZhamiltonUdoris···1949-03-21UHC-29716-43•••-••-02638755174672··-8807 INDIAN SCHOOL RD Apt 14Los AngelesCA··90063-1184GRP-4303CORE-HMO
ENRENR-1281312026-05-31T19:35:23Zahmed·Ecunningham1967-12-02UHC-90142-41-5813223773·ahmed.cunningham1@proton.me9547 Baseline RdDALLASTX75238-7046GRP-0991·select-epo
ENRENR-1263332026-06-27T21:48:11ZBrittanyO.Adams2005-06-11UHC-46200-50•••-••-52465989978463—7123 Lincoln WayCOLUMBUSOH43226GRP-5373NAVIGATE-HMO
ENRENR-1429092026-02-27T23:02:04ZHELENPNGUYEN1992-11-19uhc-32465-91•••-••-3356+1 419 847 6611helen.nguyen66@aol.com9835 MEADOW LANE #392··NashvilleTN37205GRP-3434MEDICARE-ADV-B
ENRENR-1397672026-08-19T03:42:50Z HELENXELLIS2008-02-12UHC-73490-52··-638-970-3302helen.ellis21@aol.com2899 BroadwayDenverCO80259-2437GRP-2592NAVIGATE-HMO
ENRENR-1126492026-10-18T02:30:55Zcatherine—mendez20060323UHC-12032-61•••-••-7500(448) 675-7724—2046 Lake View RoadHOUSTONTX77047GRP-5672OPTIONS-PPO
ENRENR-1037792026-09-25T15:35:15ZSofiia—·Pena1939-02-19UHC9467399•••-••-0370(324) 303-0405sofia.pena92@hotmail.com2640 Ocean AveAustin··TX78733GRP-8722CORE-HMO
ENRENR-1268062026-07-27T14:10:08ZEspinoza, RonaldP.—1971-03-13UHC-53546-06•••-••-9465N/Aronald.espinoza@hotmail.com1715 HIGHLAND AVENUEGilbertAZ85270GRP-4402CHOICE-PLUS-PPO
ENR ENR-1209762026-02-02T21:00:47ZWeber, Donna——1951-08-05UHC-68630-22•••-••-8266UNKNOWNdonna.weber19@hotmail.com3086 Sunset BoulevardScottsdale·AZ85243GRP-6276SELECT-EPO
ENRENR-1305442026-07-21T07:36:40ZTeresaG.Park1963-11-24UHC-72389-20UNKNOWNNULLTERESA.PARK@GMAIL.COM6714 Highland AvenueFresnoca93739GRP-6345CORE-HMO
ENRENR-1115292026-01-10T05:49:51ZDeniseKSullivan1956-06-18UHC-15075-42•••-••-4959(421) 529-4171DENISE.SULLIVAN@PROTON.ME393 Market StPlanoTX··75003GRP-4023SELECT-EPO
ENRENR-1146682026-03-14T07:23:25Z·Kenneth—Fuller10/21/68UHC-48254-48•••-••-5722512-756-2363—7076 Lake View RdSEATTLEWA98176GRP-4541MEDICARE-ADV-A
ENRENR-1002532026-01-14T07:34:53ZCHRISTOPHER—STEVENS1949-06-27UHC-34040-26•••-••-30187467742832christopher.stevens80@yahoo.com1811 LINCOLN WAYLAS VEGASNevada89118GRP-7446CHOICE-PLUS-PPO
ENRENR-1115772026-04-15T08:43:12Zkaren·F.jackson22-05-1947UHC-05379-68•••-••-9519(854) 337-9329karen.jackson71@hotmail.com1428 JEFFERSON AVELOS ANGELESCalifornia90023-3544GRP-7146SELECT-EPO
ENRENR-1012792026-10-14T01:02:54ZSEAN—HUNTER01/18/44UHC-33259-01-6185124174sean.hunter52@icloud.com5604 PINE DRIVEAustinTexas78795GRP-0900··OPTIONS-PPO
ENRENR-1370042026-03-11T20:41:20ZJACQUELINEMJACKSON1952-07-07··UHC-10320-15•••-••-9318655-337-3931jacqueline.jackson18@yahoo.com593 SUNSET BLVD Apt 34JacksonvilleFlorida32219GRP-2867OPTIONS-PPO
ENRENR-1224272026-07-24T12:56:37ZWallace, EmilyE—05/22/97UHC-54030-64•••-••-04095119659260EMILY.WALLACE@HOTMAIL.COM189 Palm DriveScottsdaleAZ85283GRP-2251MEDICARE-ADV-B
ENRENR-1173162026-01-13T23:28:04ZLarry—Young·07/10/1982UHC-19073-60•••-••-0513(216) 902-9696LARRY.YOUNG@GMAIL.COM2510 HIGHLAND AVE··Nashville··TN37270··GRP-9479CORE-HMO··
ENRENR-1390532026-10-13T12:05:18ZDavid··—Webb05/23/1962UHC-26994-62•••-••-68777983502david.webb@yahoo.com602 Hillcrest Road·TempeAZ·85213GRP-4143CORE-HMO
ENRENR-1363982026-03-08T08:47:16ZSharonEBanks1948-11-10··UHC-10080-74•••-••-27745275171570—1075 Indian School RoadCharlotteNorth Carolina28208··GRP-6009OPTIONS-PPO
ENRENR-1215642026-04-27T16:45:58ZNancy··Sandoval19831103UHC9593967•••-••-9737955-826-0487NANCY.SANDOVAL83@YAHOO.COM·2398 Desert Sky BlvdSCOTTSDALEAZ85284-4445GRP-7658SELECT-EPO
ENRENR-1277652026-02-24T18:15:06ZRANDY—ALVARADO2000-02-01UHC-90506-58•••-••-7318·(693) 392-1305NULL5022 Sunset BlvdOrlandoFL32830GRP-6414medicare-adv-a
ENRENR-1429862026-07-07T16:59:39ZJeremyWFuller9143-08-22UHC-03594-99•••-••-59429746892458—1341 MARKET STREET··MiamiFL33176GRP-1161CHOICE-PLUS-PPO
ENRENR-1195242026-01-19T20:17:19ZELIJAHYFERGUSON19650827UHC-23904-16•••-••-5029(828) 815-9443ELIJAH.FERGUSON@PROTON.ME1718 River RdFresnoCA93792GRP-4025NAVIGATE-HMO
ENRENR-1033132026-01-31T06:40:42ZNicholasCDominguez1943-05-08UHC-92617-68•••-••-4696972-733-3142nicholas.dominguez12@proton.me6743 BASELINE RD Apt 12HoustonTX77071GRP-9394CORE-HMO··
ENRENR-1235352026-08-07T07:59:52ZJustinPTran19410307UHC-17587-12•••-••-7555499.459.2312justin.tran@gmail.com3195 MARKET STREET #222··MesaAZ85232··GRP-4984SELECT-EPO··
ENRENR-1062312026-07-04T20:24:03ZMADISONXFREEMAN1960-11-28UHC-37196-07null(544) 933-1530N/A9182 Willow Court Apt 18SeattleWA98191GRP-3228SELECT-EPO
ENRENR-1340932026-05-14T03:28:35ZBilly—Roberts12/26/1987UHC-41667-60null444.343.5571billy.roberts27@yahoo.com8297 Willow CourtLos Angelesca90022·GRP-3206MEDICARE-ADV-A
ENRENR-1072952026-10-17T16:42:03ZMASON D—RYAN1990-04-02····-(506) 524-8906MASON.RYAN10@ICLOUD.COM5688 PINE DRChandlerAZ85297GRP-1923SELECT-EPO
ENRENR-1230512026-04-05T22:34:50ZRomero, Zachary——1992-04-13UHC-18836-74N/A7353258273—283 Camelback RoadEden PrairieMN55327-4371GRP-4277MEDICARE-ADV-B
ENRENR-1178842026-08-26T15:20:26ZCOOPERP.WEI1981-10-26UHC-59412-04•••-••-72469248358912·wei.cooper81@gmail.com9846 Washington StColumbusOH43211GRP-9787MEDICARE-ADV-B
ENRENR-1373202026-03-14T19:43:08Zdaniel—simmons03/21/1983UHC-22539-64•••-••-75016042485851—3758 HARBOR BLVDChandlerAZ85264GRP-5173navigate-hmo··
ENRENR-1112182026-09-14T12:38:34ZEVELYN Z—VALDEZ1959-09-19UHC-12756-19•••-••-7339(298) 754-7342EVELYN.VALDEZ32@HOTMAIL.COM607 Highland Ave #498San AntonioTX78255GRP-8435··NAVIGATE-HMO··
ENRENR-104517 2026-06-06T05:20:10ZSharon·SBoyd1957-07-20UHC-93216-37•••-••-5720230-729-9847·sharon.boyd@outlook.com4822 Camelback RoadMINNEAPOLISMN55471GRP-4135··select-epo
ENRENR-1393782026-02-11T11:39:36ZDiaz, SharonB—1957-07-25UHC-05198-84•••-••-1471·16089609342sharon.diaz80@outlook.com4651 SAGE COURTNashville·TN37266GRP-7295CHOICE-PLUS-PPO
ENRENR-1313552026-09-06T09:21:57ZFox, Roger——07/18/90UHC-96985-70•••-••-5715640-414-8100roger.fox@icloud.com5466 MAPLE AVETAMPAFL33680GRP-8956MEDICARE-ADV-A
ENR ENR-1240592026-03-02T18:23:21ZALBERTNFREEMAN·04/15/80UHC-90198-79—5023696716··N/A8360 CENTRAL AVECharlotteNC28241GRP-6167NAVIGATE-HMO
43,101 rows, page 21 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.776Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty