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-1130052026-07-06T06:24:17ZHarper, Catherine——2000-10-15UHC-66620-68NULL(777) 212-8887catherine.harper3@aol.com···5487 RIDGE ROADCharlotte··NC28223GRP-7109SELECT-EPO
ENRENR-1065202026-08-13T09:56:42ZHAROOLDS.BURNS07/19/1990-•••-••-0156208-237-1630harold.burns44@outlook.com··7558 LINCOLN WAYSeattle·WA98135GRP-7769OPTIONS-PPO··
ENRENR-1330222026-01-13T07:21:50ZDonS·ReidJul 1, 1944UHC-92124-07•••-••-10169357649967DONALD.REID44@YAHOO.COMUNKNOWNnull-—GRP-7179navigate-hmo
ENRENR-1047562026-06-22T01:37:47ZOlivia—Cox1964-01-06UHC-84543-81•••-••-0102930-525-5737-4346 Washington St #668JacksonvilleFL32201-4022GRP-1731OPTIONS-PPO
ENRENR-115196 2026-09-27T19:17:16ZMARTHAB·WASHINGTON1951-06-12UHC-94243-99•••-••-12322173951112martha.washington59@hotmail.com8382 Palm DrGLENDALEAZ85394GRP-3076MEDICARE-ADV-B
ENRENR-1164982026-04-21T13:36:24Znoah—riley07/13/91UHC-66572-58•••-••-298613923017100NULL5978 Mountain View DrPLANOtx75073GRP-9179CHOICE-PLUS-PPO
ENRENR-1046672026-04-29T23:32:06Zbradley·Hwallace1970-04-28UHC-69793-41•••-••-201717449822214N/A2777 MARKET STMinneapolisMN55419-8718GRP-2063MEDICARE-ADV-B
ENRENR-1340732026-05-28T17:39:07ZcheryylD.evans1952-07-22UHC-85677-77•••-••-0008(791) 399-8857··cheryl.evans1@outlook.com2276 CANYON RD···ChandlerAZ85266-8382·GRP-2626CORE-HMO
ENRENR-1277162026-01-13T20:25:04ZAmber··ReedMar 5, 1938·UHC-77622-29•••-••-097718459438609····4076 Canyon Road #248OrlandoFL32825GRP-6815CORE-HMO
ENRENR-1396902026-02-08T04:43:27Z AUSTIN····ROBINSONApr 5, 1955UHC-83901-95•••-••-6809—austin.robinson99@proton.me1519 RIDGE RDTampaFL33661GRP-6693CORE-HMO
ENRENR-1100832026-06-28T06:17:46ZSAMUEL··RUSSELL03-08-1995·UHC-51354-12•••-••-6244UNKNOWNsamuel.russell51@icloud.com··5399 FOREST AVENUEOrlandoFL32863GRP-4094NAVIGATE-HMO
ENRENR-1012712026-01-20T05:09:55ZMary—Wlilis··1939-06-26UHC-39266-51•••-••-5389(336) 358-9981—7077 Sunset Boulevard·HoustonTX77091GRP-1982··CORE-HMO
ENRENR-1041422026-08-02T04:41:40ZJerry—Washington·2001-08-01UHC-80565-05•••-••-98198667946715—4832 MARKET STCharlotteNorth Carolina28284·GRP-5772NAVIGATE-HMO
ENRENR-1192342026-08-30T21:22:41Z KaylaN.·Mendez1963-06-14UHC-45096-59•••-••-9499+1 560 889 4991··kayla.mendez@hotmail.com3449 Forest AvePlanoTX75017GRP-1683OPTIONS-PPO
ENRENR-1103642026-07-17T19:19:25ZMills, JudyR.—08/26/40UHC-25520-89•••-••-773013664549843judy.mills@proton.me1260 Mountain View DrDallasTX75211·GRP-7080OPTIONS-PPO
ENRENR-1178922026-01-13T00:11:00ZDANIELEMYERS2000-04-01UHC-98359-04•••-••-13835156094310daniel.myers@yahoo.com·3748 Canyon RoadTempeAZ··—·GRP-9933OPTIONS-PPO··
ENRENR-1351092026-01-29T08:56:05ZAngelaOMartinez19-10-1999UHC-65881-79•••-••-91746313887471angela.martinez@hotmail.com8789 INDIAN SCHOOL ROADTEMPEAZ85294GRP-5784CORE-HMO
ENRENR-1406152026-01-30T09:33:39Z DorisJCarlson1955-11-08UHC-77177-25•••-••-567214104881839doris.carlson@hotmail.com4649 MEADOW LANENASHVILLETN37216·GRP-7320MEDICARE-ADV-A
ENRENR-1061742026-06-09T16:43:56ZAHMED—VEGA2002-10-16UHC-10206-05•••-••-94863932206753ahmed.vega29@icloud.com3061 Maple AvenueTucsonAZ85739GRP-0548NAVIGATE-HMO
ENRENR-1058322026-01-23T20:51:04ZMatthewYWhiteFeb 19, 1973UHC-78331-45•••-••-02174784644206—8059 Valley View DriveGILBERTArizona85224GRP-6302MEDICARE-ADV-A
ENRENR-1129022026-04-04T14:17:55ZJACQUELINEZWEBB1940-04-10UHC-60029-17•••-••-936712482686027jacqueline.webb@proton.me9796 WASHINGTON STREETColumbusOH·43259GRP-4506SELECT-EPO
ENRENR-1257422026-07-28T17:43:39ZCAMILAOCASTRO2003-05-15UHC-14882-38NULL··+1 652 859 4318CAMILA.CASTRO@YAHOO.COM··5948 Pine DriveLos AngelesCA—GRP-2209MEDICARE-ADV-A
ENRENR-1191182026-06-04T05:29:31ZMariana—Evans1997-10-27UHC-97361-74•••-••-7967+1 269 940 3408MARIANA.EVANS15@HOTMAIL.COM9718 River RdNashvilleTN37251GRP-8533OPTIONS-PPO
ENRENR-1145672026-06-11T10:30:35ZLUIS—GARCIA1978-11-12UHC-82957-73•••-••-6483(295) 621-6787——--UNKNOWNGRP-5956NAVIGATE-HMO
ENRENR-1103282026-10-15T08:14:25ZGardner, Michael····—1960-06-10UHC-58642-84null(827) 402-5053michael.gardner32@yahoo.com·4736 MEADOW LNCharlotteNorth Carolina28272-5667GRP-4879MEDICARE-ADV-B
ENRENR-1153522026-06-17T14:49:48ZWilliamZBailey··1967-01-23UHC-20733-89null772-462-3314·william.bailey@aol.com5117 Park PlaceHoustonTexas77055GRP-0573CHOICE-PLUS-PPO
ENRENR-1265592026-09-16T05:03:22ZSAMT.PADILLA1949-07-02UHC-28452-86-3768694380samantha.padilla78@hotmail.com8504 HILLCREST RDLos AngelesCA90071GRP-0178CHOICE-PLUS-PPO
ENRENR-1090332026-07-12T12:01:35ZPamela—·Perry19481124UHC-99271-74—(847) 317-1023·pamela.perry84@proton.me5465 Maple Ave··NashvilleTN37232-0434GRP-9913choice-plus-ppo
ENRENR-1401902026-06-14T23:57:19ZkimberlyPvega1961-03-18UHC-98431-63•••-••-72358122507026KIMBERLY.VEGA@GMAIL.COM9577 SPRING STREETNashvilletn37217GRP-8874·SELECT-EPO
ENRENR-1423572026-01-23T13:45:06ZGeorge·T.Larson1973-07-18UHC-59484-44•••-••-4743373-992-7367GEORGE.LARSON@PROTON.ME3904 Sage CourtORLANDOFL·32858GRP-3994SELECT-EPO
ENRENR-1053562026-03-30T18:27:20ZAlexanderFBerry1967-05-21UHC-08426-20•••-••-2776381-650-4355·alexander.berry@proton.me806 Apache BlvdLos AngelesCA··90048-5331GRP-7065NAVIGATE-HMO
ENRENR-1299792026-01-31T00:21:58ZJENNIFER—BURTON02-06-1969·UHC-57790-33•••-••-0284(901) 397-4607UNKNOWN7210 Ocean AvenueGILBERTAZ85230GRP-1434MEDICARE-ADV-A
ENRENR-1298262026-01-18T23:51:54ZKYLE—BURTON08/22/75UHC-26348-50•••-••-9265+1 783 989 6157kyle.burton@gmail.com5561 OCEAN AVENUESan AntonioTX78216GRP-0697CHOICE-PLUS-PPO
ENRENR-1039442026-04-17T21:59:38ZELIZABETHNMARTIN1973-10-05UHC6312578•••-••-6160523-387-2747elizabeth.martin89@aol.com1405 CANYON ROADJacksonvilleFL··32268GRP-6116CORE-HMO
ENRENR-1316712026-08-02T13:06:36ZLuciaL·Baker2008-04-25·UHC0079082—(911) 616-3899LUCIA.BAKER@PROTON.ME6471 CEDAR LNDALLASTX75216··GRP-6986CHOICE-PLUS-PPO
ENRENR-1046582026-02-03T21:15:49ZFRANK—THOMPSONApr 6, 1992·UHC-37893-53•••-••-38334469309182-7457 SPRING STTucsonAZ85710GRP-0825NAVIGATE-HMO
ENRENR-1321402026-06-14T11:12:30ZANN O··—SIMS2003-11-13UHC-16272-69•••-••-4661(672) 665-7957null4580 Lincoln WayScottsdaleAZ85243GRP-2512MEDICARE-ADV-B
ENRENR-1028222026-09-03T16:53:41ZGLORIA—HAMILTON01/22/08UHC-19298-24··•••-••-6025(911) 704-7508gloria.hamilton23@icloud.com4463 Lake View RdTAMPAFL33696GRP-7053MEDICARE-ADV-A
ENRENR-1259252026-04-14T11:34:24ZStephens—Megan1951-06-10UHC-97615-38•••-••-7050(935) 261-1817MEGAN.STEPHENS4@OUTLOOK.COM8961 Desert Sky BlvdSEATTLEWA98192GRP-6102CHOICE-PLUS-PPO
ENRENR-1341972026-05-01T20:08:26ZDianaV.Walker··Mar 20, 1938UHC-90580-27•••-••-7481(261) 415-2543diana.walker@aol.com2920 Park PlDallasTX75236GRP-1622CORE-HMO
ENRENR-1388792026-05-29T00:18:36ZSephanieJMcCoy1965-09-19UHC-04671-13-+1 283 329 1756—23 Sage CourtMiamiFL33123-9130GRP-4449MEDICARE-ADV-B
ENRENR-106104 2026-03-04T06:14:35ZJosh—Martinez1944-08-14UHC-37146-04•••-••-51706326915939—4272 LINCOLN WAYNASHVILLETennessee37235GRP-6802MEDICARE-ADV-B
ENRENR-1216992026-04-07T19:48:42ZLAURAIHERRERA1959-06-27UHC-79427-43•••-••-5294+1 211 278 1293—8443 Willow CtPhoenixArizona—GRP-3813MEDICARE-ADV-A
ENRENR-1120622026-05-15T07:08:57ZmarianaQ.wheeler1959-10-23UHC-50246-49•••-••-0016nullnull9891 Washington StreetCOLUMBUS··OH43204GRP-4382·CHOICE-PLUS-PPO
ENRENR-1060162026-10-14T01:21:24ZsandraJjimenez03/07/72UHC-84347-38—421-517-4284sandra.jimenez58@proton.me5372 Sunset BlvdColumbus··OH43263GRP-2118NAVIGATE-HMO
ENRENR-1031142026-02-10T22:28:37ZKATHRYNO.LEWIS1968-07-26UHC-49032-95•••-••-3868395.572.0807—6494 Park PlacePhoenixaz85026GRP-4746NAVIGATE-HMO
ENRENR-129015 2026-08-28T18:32:19ZJENNIFERXALVAREZ2004-01-23UHC-80421-38•••-••-2646555-221-9998—8706 Desert Sky BlvdLos AngelesCA90056GRP-2126CORE-HMO
ENRENR-1358272026-05-04T07:06:13ZDANIEL····NUNEZ1954-01-09·UHC-37947-01•••-••-27462176217578—580 CHURCH STGlendaleArizona85333GRP-1819···OPTIONS-PPO
ENRENR-103281 2026-07-02T17:53:24ZYukki—Woods2004-07-15UHC6798555•••-••-26349675191979yuki.woods@aol.com4369 HIGHLAND AVENUESACRAMENTOCA95814-1316GRP-3894CORE-HMO··
ENRENR-1193422026-05-13T06:51:55ZVincentNAstin·Oct 28, 1943UHC2296232•••-••-98052824338277vincent.austin75@proton.me··9755 Sage CtDallasTX75217···GRP-4217CHOICE-PLUS-PPO
43,101 rows, page 306 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:43.598Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty