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-1091762026-08-04T06:24:06ZoliviaZguzman·01-01-1982UHC-53622-56•••-••-8744null··NULL5757 Ocean AvenuePhoenixAZ85080GRP-6213CORE-HMO
ENRENR-1430932026-07-21T06:13:36ZRYANJGEORGE2005-10-22UHC-02210-50··•••-••-8512(259) 707-0773ryan.george7@gmail.com7634 HILLCREST RDColumbusOH43289GRP-6888CHOICE-PLUS-PPO
ENRENR-1421122026-01-02T10:58:01ZNICHOLASM.MENDOZA19940504UHC-42778-02•••-••-1088·NULLNULL3558 WASHINGTON STEDEN PRAIRIEMN55317GRP-1256MEDICARE-ADV-A
ENRENR-1343312026-05-23T10:08:04ZStewart, JacquelineF—1963-11-10UHC-38204-13•••-••-11832274808705·jacqueline.stewart85@icloud.com7018 Meadow Lane··GlendaleArizona85361GRP-2039CHOICE-PLUS-PPO
ENRENR-1368402026-03-06T19:31:24ZBAKER—DOROTHY1947-11-27UHC-63667-39—5425975122DOROTHY.BAKER31@YAHOO.COM8973 Apache BoulevardMinneapolisMN55424GRP-5907CORE-HMO
ENRENR-1413412026-06-24T14:45:12ZbradleyPvea1994-10-23UHC-37376-17N/A951-700-0340—nullNULL——GRP-6408CORE-HMO··
ENRENR-1048142026-06-22T08:29:52ZRaymondKYoung19650513uhc-75134-62•••-••-2481(459) 898-7820—·1448 Grand AvenuePhoenixArizona85015GRP-9403CORE-HMO
ENRENR-1112172026-07-17T14:10:13ZJANET·UELLIOTT3/11/1991UHC-79307-30•••-••-5339(771) 312-8070···janet.elliott@proton.me7895 Pine DriveJacksonvilleFlorida32292GRP-2015CORE-HMO
ENRENR-1205632026-10-09T16:27:43ZBradleyHBurton1975-04-28uhc-71453-79•••-••-7248(599) 324-1731···BRADLEY.BURTON7@HOTMAIL.COM4574 BroadwayHoustonTX····GRP-2433MEDICARE-ADV-B
ENRENR-1242262026-07-19T21:05:38Z VALENTINA—HALL1971-03-17UHC-23664-98•••-••-2307474-542-9966valentina.hall87@yahoo.com1587 Maple AveColumbusOhio43225GRP-7257CHOICE-PLUS-PPO
ENRENR-1114112026-05-30T18:20:26ZANA—RAY10-03-2008UHC-26901-32•••-••-65867314391317ana.ray9@outlook.com467 Harbor Blvd·AtlantaGAUNKNOWNGRP-2889·NAVIGATE-HMO
ENR ENR-1270042026-08-31T17:52:37Z FRANCESQBROWN2004-12-05UHC-25113-79··•••-••-0272·4687767432frances.brown@gmail.com3236 Washington St #549ATLANTAGA30318GRP-1502CHOICE-PLUS-PPO
ENRENR-1419082026-02-24T08:41:39ZIsabella—White1963-09-10UHC-04180-39····4752829551N/A9080 Canyon RdTampa··FL33636GRP-6986··MEDICARE-ADV-A··
ENRENR-1353692026-06-05T01:10:11ZSophia····Rojas1998-05-10UHC-55388-52•••-••-6251(372) 251-8134UNKNOWN·7059 MESA DRIVETempeAZ85239··GRP-9359MEDICARE-ADV-A
ENRENR-1279882026-07-10T11:29:37ZJuy—Spencer1971-11-06UHC5921216•••-••-9502+1 494 815 7411—4397 MESA DRNashvilletn37239GRP-7767SELECT-EPO
ENRENR-1375842026-02-21T18:03:11ZMARGARET··BRADLEY1966-09-13UHC-01772-13•••-••-9323673-975-0394MARGARET.BRADLEY@GMAIL.COM2445 Spring StreetGlendaleAZ85314-5136··GRP-0483SELECT-EPO
ENRENR-1340762026-07-31T16:34:49ZDANIELLEK·PALMER2001-07-22UHC-01567-87•••-••-6394286.870.9037UNKNOWN9568 MAPLE AVESan DiegoCA92162GRP-3083MEDICARE-ADV-A
ENRENR-1018182026-03-28T15:00:37ZJOSESWARREN1969-01-19UHC-42110-96N/A480-618-5878—·2902 Oak StreetPhoenixAZ85095GRP-4051SELECT-EPO
ENRENR-1237822026-05-30T01:52:00Zpatrick—·vazquez91430612UHC-66591-57··•••-••-8251613-816-5464patrick.vazquez35@yahoo.com5639 Lake View RdTampa··FL33677GRP-4963··CHOICE-PLUS-PPO
ENRENR-1067202026-04-15T01:20:15ZBRADLEYPVEGA1977-02-07UHC-28014-02UNKNOWN14557013187BRADLEY.VEGA@ICLOUD.COM1956 HIGHLAND AVEDenver·CO80297GRP-0565·MEDICARE-ADV-A
ENRENR-1149952026-04-18T09:59:02ZkevinV.duncan1977-02-24UHC-31337-83•••-••-7008437-413-0170kevin.duncan@outlook.com—-—N/AGRP-7456MEDICARE-ADV-A
ENRENR-1322672026-07-27T04:31:59ZHannah—Cooper20-03-1945UHC-05330-12•••-••-4249854.764.9675hannah.cooper@yahoo.com6186 OCEAN AVEDenver··CO80205GRP-4043CHOICE-PLUS-PPO
ENRENR-1212382026-03-18T21:46:41ZJONATHAN—·BURKE10/2/1984UHC-30312-35•••-••-5613(633) 245-0599jonathan.burke69@proton.me4277 WASHINGTON STDenverCO80209·GRP-2560CORE-HMO
ENRENR-1057982026-02-24T04:58:20ZDENNYW.SIMMONS19830407UHC-42851-62•••-••-136218409043209dennis.simmons64@aol.com·2133 Apache BlvdAustinTX78720GRP-2144MEDICARE-ADV-A
ENRENR-1426062026-07-07T17:06:39ZPalmer, NathanA—2006-09-05UHC-74591-49•••-••-4625N/Anathan.palmer@proton.me··4351 Elm StreetScottsdaleAZUNKNOWN··GRP-6641··SELECT-EPO
ENRENR-1099052026-04-22T05:38:15Z·Cheryl—Reed1952-09-07UHC-42325-33•••-••-54462686135598cheryl.reed@outlook.com4160 Oak StreetDallasTX—GRP-2337SELECT-EPO··
ENR ENR-1053372026-08-30T05:21:22ZRoy—Hill08/12/1977UHC-26981-69•••-••-5644612.503.0383roy.hill23@icloud.com5091 MAPLE AVENUEOrlandoFL32863GRP-6951SELECT-EPO
ENRENR-1244932026-01-27T10:19:13ZJACKN.SANTIAGO10/20/58UHC-32263-16•••-••-2672932-960-6619JOHN.SANTIAGO@PROTON.ME4038 Sage CtMINNEAPOLISMN55489GRP-4609SELECT-EPO
ENRENR-1334122026-05-08T04:10:47Z Hansen, JaniceQ··—1970-06-13UHC-17796-50•••-••-14517636570096janice.hansen@outlook.com930 Camelback Road #989FRESNOCalifornia93729GRP-4722MEDICARE-ADV-B
ENRENR-1086542026-09-28T17:24:44ZBrenda—Bradley10/17/54UHC0626452—6167524312brenda.bradley33@yahoo.com5192 MEADOW LANEJACKSONVILLEFL32242GRP-3321CHOICE-PLUS-PPO
ENRENR-1260552026-02-21T18:58:31Zalexander—payne2007-04-03UHC-40615-86•••-••-00742942080306alexander.payne78@aol.com241 Ridge RoadTempeAZ·85223GRP-6992select-epo
ENRENR-1401172026-05-10T20:04:45ZKathlaenPSpencer1986-11-25UHC-15103-98null8153013447kathleen.spencer@icloud.com8175 BroadwayCharlotteNC··28201GRP-0480··MEDICARE-ADV-A
ENRENR-1228152026-03-23T09:58:37Z·AlexisE.Walker1962-07-15UHC-81179-53•••-••-5550371-567-9556··alexis.walker29@yahoo.com2604 HIGHLAND AVEPhoenixAZ85013GRP-2072CORE-HMO
ENRENR-1279672026-10-15T17:39:25ZRUTHF.MORENOJul 27, 1997UHC8506305•••-••-8512UNKNOWNRUTH.MORENO@ICLOUD.COM8785 RIVER RDAustinTX78727GRP-9762CORE-HMO
ENRENR-1237342026-05-23T04:30:26ZMadisonA.Salazar1984-11-24UHC-03727-81•••-••-8225·+1 714 650 5589UNKNOWN1081 Pine Drive Apt 37TempeAZ85220GRP-8965MEDICARE-ADV-A
ENRENR-1139832026-02-27T03:08:25ZLawrenceY·Jordan01/13/1975UHC-10337-96•••-••-0541203-690-5374lawrence.jordan73@aol.com··3813 Desert Sky BlvdGilbertAZ85295GRP-8924CORE-HMO
ENRENR-1205302026-02-15T20:54:15Z BARBARACFISHER06/16/38UHC-18628-86—572-881-9269—4226 CHURCH STREETOrlandoFlorida32822GRP-6715MEDICARE-ADV-B
ENRENR-1352222026-03-12T07:24:22ZCarlL··Dominguez10-05-1967UHC-67933-51—+1 527 249 0817··carl.dominguez72@aol.com1514 Baseline RoadGilbertAZ85224GRP-7245SELECT-EPO
ENRENR-1073682026-04-01T10:37:46ZADAM—VASQUEZDec 15, 1978UHC-91157-09•••-••-4951397-428-7745adam.vasquez@aol.com9625 HILLCREST ROADCharlotteNC··28263GRP-0117MEDICARE-ADV-A
ENRENR-1236132026-07-24T08:58:14ZMelissaBSilva1977-02-05UHC-20938-95•••-••-1859(723) 505-9391melissa.silva59@hotmail.com7746 MAIN STGilbertAZ85253GRP-7825CHOICE-PLUS-PPO
ENRENR-1203862026-04-18T17:12:43ZARJUN—CHAVEZ1979-07-17UHC-26292-82•••-••-9219982-616-1875ARJUN.CHAVEZ@OUTLOOK.COM3090 Apache BoulevardTucsonAZ85770-7973GRP-6503SELECT-EPO··
ENR ENR-1048902026-03-29T03:10:26ZScotttLKnight2003-11-23UHC-06418-36•••-••-74533528726111scott.knight31@proton.me··6123 Harbor BoulevardMesaAZ85225GRP-1587CORE-HMO
ENRENR-1352712026-04-02T08:52:19ZSanchez, Nathan——5/19/1961UHC9903018N/A869-820-3607NATHAN.SANCHEZ@OUTLOOK.COM9173 Cedar LnLas VegasNV89194GRP-1330OPTIONS-PPO
ENRENR-1092132026-09-18T13:26:56ZKayla·U.Lewis1973-12-17UHC-26683-74•••-••-250312443804761·KAYLA.LEWIS@AOL.COM5612 Oak StreetCharlotteNC28219GRP-4690MEDICARE-ADV-B
ENRENR-1105452026-08-06T11:23:15ZCamilaW.·Sims25-08-1950UHC-37140-99····4819660351UNKNOWN6419 Cedar Ln·DenverCO80222GRP-2984SELECT-EPO
ENRENR-1164082026-09-16T19:45:28Z NoahDEstrada1946-11-14UHC-13233-49•••-••-8682(415) 766-3333noah.estrada@gmail.com1290 MESA DRAUSTINTX78719GRP-2859MEDICARE-ADV-B
ENRENR-1218702026-02-25T13:15:18ZJESSICA—ORTIZ01-08-1951UHC-13407-93•••-••-0008+1 228 470 1149···JESSICA.ORTIZ32@YAHOO.COM7197 MAIN STREETAtlantaGA30398GRP-0467MEDICARE-ADV-A
ENRENR-1305682026-04-29T05:40:43ZEugene—Padilla2007-06-27UHC-02340-28N/A5378633073UNKNOWN1804 Ridge RdChandlerAZ····GRP-1341MEDICARE-ADV-B
ENRENR-1136242026-05-29T07:36:56ZPamela·YRichards1991-07-24UHC-61406-34•••-••-2734357-293-8053PAMELA.RICHARDS@PROTON.ME4676 Mountain View DrSan DiegoCA92173GRP-8866CORE-HMO
ENRENR-1323922026-03-16T05:47:41ZMarcusJVasquez1947-11-18UHC-82800-28•••-••-2768230-269-1195marcus.vasquez@hotmail.com5679 Grand AveMesaAZ85242GRP-8826MEDICARE-ADV-A
43,101 rows, page 216 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:40.359Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty