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-1231262026-01-15T03:15:25ZGeraldBDixon1986-01-13UHC-04299-88•••-••-8361(342) 312-2740gerald.dixon27@hotmail.com2943 Central AvenueLas VegasNevada89158GRP-1258choice-plus-ppo
ENRENR-1409942026-07-25T16:25:34ZSusan—·Contreras19630401UHC-06057-20•••-••-61783228934susan.contreras22@proton.me7437 SAGE COURTColumbusOH43295-6505GRP-5769medicare-adv-a
ENRENR-1039272026-03-30T04:25:00ZAUSTIN—WARREN7/28/2008UHC-54396-70—369-814-8462austin.warren@yahoo.com5121 Mesa Drive Apt 30TampaFlorida33625GRP-9465MEDICARE-ADV-A
ENRENR-103279 2026-05-02T17:16:12ZJamesJRios—UHC-97343-03•••-••-6006239-732-6867james.rios61@hotmail.com4070 WILLOW CT··PHOENIXAZ85043GRP-3865NAVIGATE-HMO
ENRENR-1085942026-06-14T09:37:19ZCARLS.PENA·1939-07-24UHC-49648-62•••-••-873614377911630CARL.PENA75@GMAIL.COM2430 Jefferson AvenueMesaAZ85240GRP-2551MEDICARE-ADV-A
ENR ENR-1066502026-02-19T16:19:17ZGabrielTSandoval1948-01-09UHC-73342-13•••-••-619016976934152··GABRIEL.SANDOVAL49@OUTLOOK.COM464 SUNSET BLVDPlanoTX75063GRP-0996MEDICARE-ADV-A
ENRENR-1124552026-04-26T09:13:20ZVALENTINA—ROSS1971-09-17UHC-77756-13··•••-••-4273277-490-7868valentina.ross67@aol.com3317 Mountain View DrSan Diego··CA92126GRP-9784··SELECT-EPO
ENRENR-1321072026-06-06T23:10:36ZJoyce··RBradley1952-04-01UHC-64440-61•••-••-2290·9035654587joyce.bradley@outlook.com6419 Mesa DriveDENVERCO80298GRP-5748MEDICARE-ADV-A
ENRENR-1166112026-06-15T00:43:54ZCarolynCOlivre1997-01-20UHC-77061-53•••-••-9745NULLcarolyn.oliver2@yahoo.com6638 Mountain View DriveCharlotteNC28259GRP-2354CORE-HMO
ENRENR-1312942026-10-03T02:08:28ZAARONFNGUYEN1980-01-03UHC-97529-09··•••-••-02782644934696aaron.nguyen@yahoo.com7123 BASELINE ROADMinneapolisMN55418GRP-6889OPTIONS-PPO
ENRENR-1343772026-02-08T14:52:04ZJames, Wei——1987-05-16UHC-53568-22•••-••-8989892-808-0751wei.james@proton.me7550 Sage Ct Apt 7OrlandoFL32822GRP-6004CORE-HMO
ENRENR-1247702026-08-18T13:20:10ZGarrett, MarylynP.—1941-06-07UHC-31011-55•••-••-0914239.561.1866marilyn.garrett95@proton.me2901 Cedar LnSan Diegoca92177GRP-4622MEDICARE-ADV-B
ENRENR-1047252026-03-11T14:12:20ZChristopherRJordan01-12-2008UHC0469398•••-••-7852673.264.7571—7179 SPRING STREETAustin··TX78796GRP-2540CORE-HMO
ENRENR-1112222026-06-20T07:53:28ZShirley··Evans··1970-10-24uhc-22690-85•••-••-4132(650) 673-4147N/A286 APACHE BOULEVARDSan DiegoCA92167GRP-6754MEDICARE-ADV-A
ENRENR-1381352026-07-22T17:44:17ZSamantha—Olson1984-12-04UHC-51312-28··•••-••-938218247528999samantha.olson62@icloud.com2488 ELM STJacksonvilleFlorida32227·GRP-9246OPTIONS-PPO
ENRENR-1014312026-03-28T03:59:01ZJANICEZLUNA1976-10-02UHC-02636-28NULL12433521738JANICE.LUNA@HOTMAIL.COM6923 PALM DRIVETUCSONAZ85763GRP-4273NAVIGATE-HMO
ENRENR-1201222026-09-17T11:12:18ZSean····Guzman2002-12-28UHC-71216-47N/A3514030326sean.guzman@hotmail.com3295 Church StreetGLENDALEArizona85352GRP-7193··CHOICE-PLUS-PPO··
ENRENR-1377432026-04-18T10:29:18ZMARK—HARPER1948-01-14·UHC-36602-12-(860) 765-3113MARK.HARPER@GMAIL.COM2277 Lincoln Way Apt 20SeattleWA98189GRP-0948SELECT-EPO
ENRENR-1008072026-09-03T08:16:05ZHEATHERJ.MORRISON1956-06-01UHC4974686•••-••-9505·(967) 690-7561heather.morrison17@icloud.com6229 River RdNashvilleTN37250··GRP-6332MEDICARE-ADV-A
ENRENR-1271242026-04-07T08:26:03ZDanielle—Vazquez··1948-10-27UHC-84606-92•••-••-3697+1 400 382 7761danielle.vazquez70@outlook.com8681 GRAND AVENUEATLANTA··GA30386GRP-7573SELECT-EPO
ENRENR-1279452026-08-28T23:54:29ZJenniferIWeber05-07-1946UHC-83139-76•••-••-616619197241137JENNIFER.WEBER33@PROTON.ME4569 Jefferson AvenueEden PrairieMinnesota55389GRP-4223··MEDICARE-ADV-B
ENRENR-1175222026-01-06T06:01:43ZBRUCEHMURRAY1993-10-11UHC-95825-79•••-••-5310(289) 307-2986BRUCE.MURRAY70@AOL.COM2873 Highland AveMinneapolisMN55438GRP-4936OPTIONS-PPO
ENRENR-1075622026-02-02T02:54:40ZBrittany—PerkinsJun 1, 2007··UHC-89671-08•••-••-3679753-392-8119BRITTANY.PERKINS53@YAHOO.COM··4631 BroadwaySan DiegoCA92106GRP-5976CHOICE-PLUS-PPO
ENRENR-1156322026-06-29T06:35:40ZNATHAN—FOX26-01-1968UHC-69999-99•••-••-2968·+1 679 775 9415NATHAN.FOX@AOL.COM4909 Mountain View DriveFresno··California93763GRP-4301SELECT-EPO
ENRENR-1085792026-06-20T12:32:37ZStevensIKatherine1952-12-20UHC-93932-26•••-••-9971(428) 875-5375-7115 Apache BlvdJacksonvilleFL32255GRP-9231NAVIGATE-HMO
ENRENR-1130252026-02-03T13:41:14Z·CHRISTYNASSTONE1929-04-11UHC-37469-45•••-••-9145+1 325 957 7841christina.stone@outlook.com100 Lake View RoadColumbus··OH43289GRP-2832MEDICARE-ADV-A
ENRENR-1096792026-02-11T23:12:18ZDinaa—Griffin·0632-19-64UHC-20806-76•••-••-3542—UNKNOWN8389 Valley View DriveFRESNO·CA93727GRP-9431NAVIGATE-HMO
ENRENR-1088172026-02-04T09:43:29ZDOT—BURTON16-04-1977UHC-38127-12•••-••-6674·591-961-4445DOROTHY.BURTON@HOTMAIL.COM4833 Maple AvenueSeattleWA98168GRP-2342CHOICE-PLUS-PPO
ENRENR-1157582026-08-10T04:03:34ZBrianJHoffmanJun 22, 1965UHC-35000-43··•••-••-5276582-811-4541brian.hoffman@aol.com3389 Baseline RdGilbertAZ·85245GRP-5665MEDICARE-ADV-B··
ENRENR-1359672026-03-27T01:35:06ZERIC—LI··12/19/44UHC-57535-49•••-••-8112706.361.9511eric.li@hotmail.com7760 Union StreetJacksonvillefl··32249GRP-7904CORE-HMO
ENRENR-1331182026-09-12T14:30:00ZJeffrey··—Pena19410126null•••-••-54175476372732jeffrey.pena@gmail.com9350 Grand AveAustinTX78771GRP-4908CORE-HMO
ENRENR-1336702026-10-09T00:00:25ZLi—James2003-12-03UHC-11038-16•••-••-7505·594.942.0539UNKNOWN823 BAYSHORE DRHoustonTX77063GRP-7745MEDICARE-ADV-B
ENRENR-1238812026-04-10T18:45:05ZDorothy—Bailey04/04/64UHC-42273-50N/A—DOROTHY.BAILEY@AOL.COM9406 Church StPLANOTX75011GRP-4667SELECT-EPO
ENRENR-1264612026-06-15T07:42:07ZJanet····Harris10/06/98UHC-03351-82•••-••-2795—JANET.HARRIS@YAHOO.COM1529 Highland Avenue Apt 31TEMPEArizona85248GRP-0841·SELECT-EPO
ENRENR-1271222026-05-29T03:22:42ZMARCUSPSIMS2001-04-04UHC5425006•••-••-912719367211415··-·9274 Canyon RdMiamiFL33180GRP-9313MEDICARE-ADV-A
ENRENR-1231472026-05-31T22:44:14Z·JoyceC.Jenkins1994-12-27UHC-89318-82•••-••-0266+1 498 539 6573JOYCE.JENKINS@AOL.COM5673 Lincoln WayCharlotte·NC28235GRP-3433CORE-HMO
ENRENR-1007152026-07-21T05:34:57ZGeorgeINichols1992-08-10UHC-59529-24•••-••-1319559.596.0203··——-UNKNOWN—GRP-8811SELECT-EPO
ENR ENR-1425142026-02-13T12:18:02ZOrtega, NicoleK··—2003-03-20UHC-23371-21•••-••-1956830.503.7171nicole.ortega@aol.com2244 Maple Ave Apt 38FresnoCA93756GRP-9415SELECT-EPO
ENRENR-1004812026-08-02T10:27:33ZBRUCE—HENRY02/18/2001UHC5968425•••-••-3731·9738491510N/A5877 Indian School RoadPlanoTX—GRP-9329MEDICARE-ADV-B
ENRENR-1427842026-06-29T14:59:13ZJonathanL.Palmer1939-08-17UHC-36084-68•••-••-5392(693) 636-2100JONATHAN.PALMER34@AOL.COM7226 Market St Apt 24San DiegoCA··92160GRP-0651options-ppo
ENRENR-1260332026-06-15T23:02:11ZHannah—Chapman1953-05-01UHC-60650-87•••-••-6864683-961-3751HANNAH.CHAPMAN@GMAIL.COM6342 DESERT SKY BLVDPhoenixAZ85020GRP-3511MEDICARE-ADV-A
ENRENR-1208652026-10-10T05:27:00Z Camila—Beell5/5/1985UHC-78947-90•••-••-2603555-932-9342camila.bell62@aol.com4514 River RoadDallasTX75296GRP-6822·MEDICARE-ADV-B
ENRENR-1428722026-09-12T20:38:08ZMEIWMCCOY··1950-51-23UHC-65566-67•••-••-6195·+1 736 922 6577MEI.MCCOY69@ICLOUD.COM599 LINCOLN WAYGILBERTAZ85262GRP-4216SELECT-EPO
ENRENR-1152472026-02-20T15:31:51ZNCOLE—·ORTIZ2004-08-17UHC-89420-73-(652) 570-7373nicole.ortiz23@proton.me8000 Harbor BlvdGlendaleAZ85328GRP-2170MEDICARE-ADV-A··
ENRENR-1008092026-01-10T13:15:38ZED—WILLIAMSON1960-06-18UHC-60200-80•••-••-7432(905) 750-5634EDWARD.WILLIAMSON@GMAIL.COM4053 Church StreetChandlerAZ·-GRP-2773··MEDICARE-ADV-B
ENRENR-1177882026-06-02T13:04:27ZJacquelineAPadilla19840725UHC-58059-62•••-••-49816917465292jacqueline.padilla@outlook.com8450 Cedar LaneFresnoCA··93782GRP-7679··NAVIGATE-HMO
ENRENR-1279752026-07-05T21:36:46Z JonM.Mason1979-10-23UHC-65716-57•••-••-63177702168246jonathan.mason16@gmail.com7737 Desert Sky BlvdEden Prairie··Minnesota55384GRP-9173CORE-HMO
ENRENR-1071242026-08-11T04:00:58ZRoy—Sanders5/13/1990UHC-70646-62•••-••-4507N/Aroy.sanders@gmail.com4371 Oak StSAN DIEGOCA92164GRP-5837MEDICARE-ADV-A
ENRENR-1126542026-02-19T17:09:40ZDYLAN—JORDAN1949-05-05UHC4166788•••-••-8904(727) 880-6401dylan.jordan89@yahoo.com7294 Harbor BlvdSACRAMENTOCA95880-5625GRP-5205CHOICE-PLUS-PPO
ENRENR-1227582026-09-25T02:25:37ZChavez, RebeccaX.—1986-12-03UHC-60022-24•••-••-48543557102982—6705 Cedar LnMiamiFlorida33175GRP-9984SELECT-EPO
43,101 rows, page 54 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.686Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty