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-1422602026-08-23T14:11:01ZJOAN·ZPARKER1960-01-22UHC-42430-01N/A723-269-3417joan.parker@aol.com··6988 LAKE VIEW ROADLos AngelesCA90038GRP-0849·OPTIONS-PPO
ENRENR-1083352026-09-12T09:54:33ZWhite, Michael——02-01-2003UHC-58953-75-567-922-9266michael.white@outlook.com6143 Union St Apt 16DenverCO80267GRP-5369CHOICE-PLUS-PPO
ENRENR-1406042026-07-23T16:46:22ZEric—Padilla1974-08-07UHC-33676-04•••-••-98023236727547··ERIC.PADILLA76@YAHOO.COM8843 Jefferson AveSan DiegoCA92130··GRP-1014··CHOICE-PLUS-PPO
ENRENR-1248152026-01-20T07:57:40ZAMANDA—KING07/04/1986UHC-82173-56•••-••-8244329-923-0443amanda.king@outlook.com829 Willow CourtTempeAZ·85288GRP-5659·SELECT-EPO
ENRENR-1137872026-08-10T10:08:17ZJulieXCox1948-06-25UHC-21280-53•••-••-7573341-838-6041julie.cox67@icloud.com4661 Market Street··AUSTINTX78737GRP-7764SELECT-EPO
ENRENR-1209862026-02-03T05:37:07ZLuciaQHawkins2008-01-14UHC-18251-37•••-••-5658+1 434 537 3950LUCIA.HAWKINS@OUTLOOK.COM6889 OCEAN AVENUETempeAZ85218GRP-2486MEDICARE-ADV-B··
ENRENR-1146882026-10-09T13:30:05ZMarilyn—Aguilar19810701·UHC9881807•••-••-6258(338) 750-2877·marilyn.aguilar68@aol.com1980 Ocean AvenueMIAMIFL33119GRP-4257NAVIGATE-HMO
ENRENR-1253452026-03-04T07:35:05ZHannahKLane1981-02-02UHC-85848-94•••-••-5445(984) 549-7613HANNAH.LANE2@PROTON.ME4374 Grand AvenueJacksonvilleFL32203GRP-3205NAVIGATE-HMO
ENRENR-1293352026-05-09T00:18:22ZJOYCEJ.GUTIERREZ05/03/1982-•••-••-5182320.744.6204UNKNOWN1976 Sunset BoulevardScottsdaleArizona85270GRP-1409CORE-HMO
ENRENR-1257252026-03-28T07:38:55ZVINCENTMGUERRERO9/1/1965··UHC7975763•••-••-20362012751580—-nullNULL—GRP-5970MEDICARE-ADV-B
ENRENR-108146 2026-02-08T00:38:46ZBrown, Gabriel—··1995-05-27UHC-12037-69•••-••-00639387919979gabriel.brown18@aol.com3573 Forest Ave·TampaFL33681GRP-8902OPTIONS-PPO
ENRENR-1253692026-01-23T08:09:21ZVictoria··—Jacobs1963-02-02UHC-60426-14··•••-••-2729623-893-8906victoria.jacobs@proton.me1494 Bayshore DrSacramentoCalifornia95826GRP-4508NAVIGATE-HMO··
ENRENR-1177242026-08-27T14:30:02ZKellyRHart1972-01-16UHC-41768-52•••-••-51857784809-1560 CANYON RDMiami··FL33199GRP-0998NAVIGATE-HMO
ENRENR-1054852026-05-27T03:29:58Zbilly—ryan·19390315UHC-95013-71NULL5232687886billy.ryan@outlook.com7645 Washington StreetTampaFL33672GRP-6361CORE-HMO
ENRENR-1367532026-09-25T01:38:41ZDeborah—Carlson1957-11-22UHC-44867-77•••-••-1777(410) 904-8126deborah.carlson@aol.com3493 MOUNTAIN VIEW DRSacramentoCA95894··GRP-1915OPTIONS-PPO
ENRENR-1024192026-09-10T01:48:25ZMarcus—Grifffin1220-19-82UHC-10120-08•••-••-5192——4569 Grand Ave··San DiegoCA92129GRP-5000NAVIGATE-HMO
ENR ENR-1214492026-07-13T03:06:53ZLUIS·BSIMMONS2003-04-13UHC-91105-47•••-••-4666+1 916 715 3948luis.simmons68@proton.me87 BAYSHORE DRSacramentoCA95863GRP-3140CORE-HMO
ENRENR-1108872026-07-06T10:58:41ZHolmes, RaymondN—1972-02-10UHC-55460-17•••-••-1111896-442-9771UNKNOWN1455 Sunset BoulevardLas VegasNV89124GRP-5641CORE-HMO
ENRENR-1176852026-01-25T03:02:38ZWright, Joshua——1965-03-19UHC-71174-31•••-••-1610+1 380 221 5070JOSHUA.WRIGHT33@HOTMAIL.COM7265 Desert Sky BlvdChandlerAZ85273·GRP-4976NAVIGATE-HMO
ENRENR-1310932026-03-31T13:43:38Zkevin—burns1941-10-06UHC-64254-55•••-••-2333(669) 368-7213—8615 Washington StreetOrlandoFL32815GRP-9676CORE-HMO
ENRENR-1417332026-07-24T00:35:41ZARTUHRVKNIGHTJan 25, 1986UHC-47920-07•••-••-0908UNKNOWNNULL9401 Camelback RdMesaAZ85263GRP-3787MEDICARE-ADV-B
ENRENR-1315632026-07-17T19:23:32Zmicahel—ferguson1991-08-02UHC-81936-57•••-••-1285708-483-6813MICHAEL.FERGUSON89@OUTLOOK.COM6568 HIGHLAND AVEAtlanta·GA30341GRP-8129MEDICARE-ADV-B
ENRENR-115316 2026-03-06T15:56:56ZterryK.coleman1939-09-10··UHC-28889-03•••-••-3837(755) 353-3818terry.coleman88@proton.me9252 LAKE VIEW RDGilbertAZ—GRP-8526MEDICARE-ADV-A
ENRENR-1308642026-03-15T03:52:08ZDaniels, JoyceC—3/12/1999uhc-17507-69•••-••-9977820-715-6604joyce.daniels63@outlook.com6364 BroadwaySeattleWAN/AGRP-8970OPTIONS-PPO
ENRENR-1072082026-10-07T14:02:09ZNathan—OBrien1939-09-27UHC-35857-33•••-••-01079205194785nathan.obrien@aol.com9887 APACHE BOULEVARDTempeAZ85200GRP-5221navigate-hmo
ENRENR-1423312026-01-06T07:00:44ZVirginia··Stevens·13-07-1954UHC-41703-79•••-••-3486307-634-4555virginia.stevens12@proton.me1551 Ocean AveAustinTX78728·GRP-4294OPTIONS-PPO
ENRENR-1348512026-04-27T03:54:02ZNatalie—Woods1940-09-01UHC-23619-40—8567426616NATALIE.WOODS49@OUTLOOK.COM8158 Oak StColumbusOH43281GRP-9151CHOICE-PLUS-PPO
ENRENR-1250052026-06-22T22:41:21Z·douglas—scott11/23/1972UHC-87164-66•••-••-5514574-764-5660douglas.scott92@hotmail.com··4134 Jefferson AvenueLas VegasNV89168-6326GRP-8502SELECT-EPO
ENRENR-1044682026-05-18T20:55:45ZRyan—Armstrong12/15/1961UHC-91572-43•••-••-9788658.270.8039··ryan.armstrong@outlook.com608 Spring Street··TampaFlorida33687GRP-0754NAVIGATE-HMO
ENRENR-1363252026-07-15T11:19:21ZIsabella—West1941-02-13··UHC-40107-10•••-••-5467+1 209 653 7952isabella.west@yahoo.com6180 Highland AvePlanoTX75021GRP-0619CHOICE-PLUS-PPO
ENRENR-1172902026-04-24T12:03:34ZDIANARJACOBS1955-07-17··NULLUNKNOWN+1 287 425 4739··——UNKNOWN—N/AGRP-9226CHOICE-PLUS-PPO
ENRENR-1404872026-01-16T15:09:20ZDaavidN.Phillips1938-01-10UHC-54059-78•••-••-7841221-325-8949david.phillips77@icloud.com7151 Spring StreetChandlerAZ··85299GRP-7050OPTIONS-PPO
ENRENR-1145142026-07-12T01:09:19ZMateoM.BennettFeb 20, 2001UHC-24608-69··N/A(428) 343-9032—6588 Sunset Blvd·DALLASTX75271GRP-9170CHOICE-PLUS-PPO
ENRENR-1374242026-01-08T15:11:48ZANDREWDMALDONADO1967-12-04UHC-72932-59•••-••-5409—-7983 Union StTempeAZ85272GRP-6951NAVIGATE-HMO
ENRENR-1057422026-05-23T04:27:45ZCARLAHOFFMAN12/11/41·UHC-12474-99•••-••-4002+1 901 217 2683carl.hoffman@proton.me7522 Indian School RoadMiamiFlorida33185GRP-1310·CORE-HMO
ENRENR-1102402026-05-28T00:22:40ZLOGAN—PENA1939-08-08UHC5577656•••-••-2660402-927-5385··logan.pena62@hotmail.comNULL—·NULL-GRP-1096NAVIGATE-HMO
ENRENR-1081592026-04-26T19:25:21ZDanielle—McCoy1989-01-25UHC-02509-48•••-••-2053(551) 396-0722-3451 Cedar LaneGLENDALEArizona85304GRP-0651OPTIONS-PPO
ENRENR-1370242026-09-09T15:48:40ZJERRY—DUN·1993-02-22UHC-45079-43··UNKNOWN(678) 992-1657JERRY.DUNN54@YAHOO.COM5397 RIVER ROADCharlotteNorth Carolina··28296GRP-6795CHOICE-PLUS-PPO··
ENRENR-1280142026-09-26T03:00:26ZDYLAN·LBOWMAN1984-06-22UHC-70202-76•••-••-6879UNKNOWNDYLAN.BOWMAN@GMAIL.COM·2383 CEDAR LANEJacksonvilleFL32237GRP-9635CHOICE-PLUS-PPO
ENRENR-1397712026-10-08T02:59:44ZOwens, Juan——1990-04-23UHC8030115•••-••-0844(966) 531-4257JUAN.OWENS@HOTMAIL.COM9414 Hillcrest Road #736OrlandoFL32819GRP-2053MEDICARE-ADV-A
ENRENR-1188062026-05-24T16:55:35ZMarilyn—Hicks1943-02-26UHC-38790-56•••-••-4656·202-989-0959marilyn.hicks16@outlook.com4833 MOUNTAIN VIEW DRIVEAustinTX78799GRP-3907CHOICE-PLUS-PPO
ENRENR-1100312026-09-11T16:24:59ZAbigail—Herrera·08/01/2007UHC-30685-36—5625269774ABIGAIL.HERRERA@YAHOO.COM6743 Central AveLas VegasNV89114GRP-5323OPTIONS-PPO
ENRENR-1158422026-07-08T20:18:35Z Daniel··GrayDec 1, 1980UHC-40750-73··•••-••-303619077702615DANIEL.GRAY@YAHOO.COM8185 SPRING STTampaFL·33657GRP-7373CHOICE-PLUS-PPO
ENRENR-141360 2026-04-29T08:21:33ZLUCIAVMENDOZA1965-02-03UHC-92600-02•••-••-06663794803350lucia.mendoza@outlook.com3079 SUNSET BOULEVARDTucson·AZ85764-8061GRP-1732CHOICE-PLUS-PPO
ENRENR-1198252026-05-20T12:05:44ZKatherine—Jacobs0085-19-96UHC-26509-84•••-••-1782+1 399 886 5637katherine.jacobs15@gmail.com··9842 Indian School RoadPhoenixAZ85091GRP-2991CHOICE-PLUS-PPO
ENRENR-142940 2026-07-28T18:11:07Z·Katherine—Silva1967-06-26UHC-61789-52•••-••-8438·(240) 267-2357katherine.silva@gmail.com1917 Palm DriveHoustonTX77040GRP-1684·MEDICARE-ADV-B
ENRENR-1174902026-04-12T13:13:40ZMaria—Edwards2000-02-04·UHC-28038-32NULLnull-5499 Ridge RoadJacksonville··FL32285GRP-5370CHOICE-PLUS-PPO
ENRENR-1222562026-06-12T18:44:07ZSandraZFlores11-12-2003UHC-55057-99•••-••-3103(723) 765-5518-··6442 CHURCH STGlendaleAZ85344··GRP-6015OPTIONS-PPO
ENRENR-1009712026-10-14T08:53:21Z·Perez, Ronald——01/07/80UHC1219435•••-••-8287(469) 822-7013ronald.perez21@icloud.com3180 Elm StreetCharlotteNC28284GRP-6446CHOICE-PLUS-PPO
ENRENR-1289832026-08-16T12:17:41ZSteveUEvansOct 12, 1969UHC-53770-89•••-••-0734933-282-0762NULL9061 Meadow LaneSacramentoCalifornia95854GRP-7511NAVIGATE-HMO
43,101 rows, page 75 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:36.709Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty