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-1262322026-07-28T13:50:14ZAnthonyGHansen05/16/63uhc-17160-06•••-••-2041717.767.2181anthony.hansen93@icloud.com8380 Elm StreetOrlandoFLNULLGRP-3430MEDICARE-ADV-B
ENRENR-1254922026-05-24T16:13:33ZKevin—Nichols1968-11-21··UHC-94153-38•••-••-06893873782218kevin.nichols98@outlook.com4859 Union StAustinTX78742GRP-3057MEDICARE-ADV-B
ENRENR-1083442026-06-25T03:22:17ZMATT—NICHOLS··1947-10-03UHC-90051-49•••-••-7337318-563-9127N/A3063 CENTRAL AVEATLANTAGA30337GRP-3976MEDICARE-ADV-B
ENRENR-1020162026-10-03T15:09:58Zwayne····mitchell03/13/69UHC-39406-06•••-••-9677932-255-0645wayne.mitchell@outlook.com6633 Central AveFRESNOCA93789GRP-8346CHOICE-PLUS-PPO
ENRENR-1277012026-03-21T05:28:30ZArthur—Gray1996-05-02UHC-88638-18•••-••-2152361-824-2906··arthur.gray30@outlook.com4343 Spring StreetNashvilleTennessee37213-1307GRP-5762NAVIGATE-HMO
ENR ENR-1076922026-09-24T04:01:56ZValentina—·Powell03-11-1975UHC-86719-99··637.404.6100—7935 CHURCH STREETSacramentoCA95854GRP-4887SELECT-EPO
ENRENR-1262882026-02-27T15:58:00Z·donnaD.foster1945-02-81UHC-43301-73—259-761-1730··null8255 Apache Blvd Apt 37DallasTX75279GRP-3952NAVIGATE-HMO
ENRENR-1020432026-05-11T01:12:55ZSantiago, JohnO····2005-10-04UHC-76387-44•••-••-1752N/Ajohn.santiago88@icloud.com··9707 RIDGE ROADDallasTX75202·GRP-1548CORE-HMO
ENRENR-1285372026-09-30T05:51:26ZBrendaWEdwards·1966-12-10UHC-73573-09•••-••-5257863-479-4468BRENDA.EDWARDS@ICLOUD.COM5077 HILLCREST ROADCharlotteNC28204GRP-4770·NAVIGATE-HMO
ENRENR-1069612026-01-25T09:17:59Z samuel—diaz1954-09-13UHC-54213-52-849-284-6427samuel.diaz@proton.me1684 Oak StreetAtlantaGA30393GRP-4987OPTIONS-PPO
ENRENR-1269222026-03-04T15:54:22ZJENINFERKWATKINS1993-04-21UHC-27706-65UNKNOWN+1 314 672 0042jennifer.watkins@yahoo.com2746 Lincoln WaySacramentoCA·95892GRP-3525MEDICARE-ADV-B
ENRENR-1338142026-02-07T16:22:25ZRoger—Gordon04/10/45UHC-28110-84•••-••-7102(606) 803-2271roger.gordon70@yahoo.com3536 Grand AveDENVERCO80260GRP-4863MEDICARE-ADV-B
ENRENR-123954 2026-08-05T19:30:47ZNANCYZ.·WELLS2002-01-07UHC-97054-52—935.364.8040-7149 Sage CtSAN ANTONIOTX78264GRP-7059CHOICE-PLUS-PPO
ENRENR-1423152026-03-16T20:11:24ZWayne—ContrerasAug 3, 1939UHC-45743-43•••-••-696719265272504wayne.contreras@proton.me8608 HILLCREST ROADCharlotteNC28217GRP-2367SELECT-EPO
ENRENR-1084192026-07-08T09:34:17Zpriya—long1963-10-20UHC-81049-33•••-••-62276912119338··priya.long24@gmail.com8124 Lincoln WayDallasTX75239GRP-7224·SELECT-EPO
ENR ENR-1130792026-03-03T23:45:49ZKATHERINEBLARSON9/17/1972UHC-24304-50·NULL+1 491 240 7045—4444 Main StreetLOS ANGELESCANULLGRP-5157MEDICARE-ADV-A
ENRENR-1418152026-02-20T06:59:02ZRandyZRoss1940-01-07UHC-62190-94•••-••-3866+1 317 448 7162··728 Spring StOrlandoFL32893··GRP-3033MEDICARE-ADV-A
ENRENR-1191302026-06-28T07:19:29ZMARIA··—FLORES1998-02-23UHC-15319-51NULL6906292295maria.flores@icloud.com7307 Oak StreetTempeAZ—GRP-7374MEDICARE-ADV-B
ENRENR-1015012026-04-17T01:37:31ZBRENDAT.BRADLEY··05/19/1946·UHC-93672-78•••-••-57714523025··BRENDA.BRADLEY52@OUTLOOK.COM7376 Bayshore DriveChandlerAZ85281GRP-8746CHOICE-PLUS-PPO
ENRENR-1318962026-07-14T13:32:09ZCATHERINEUBOWMAN1993-08-01UHC-34034-90•••-••-74166525253943CATHERINE.BOWMAN@AOL.COM2325 LAKE VIEW RDCOLUMBUSOH43299GRP-8966MEDICARE-ADV-B
ENRENR-1207852026-03-28T15:56:38ZJeffreyP·CruzFeb 10, 1971UHC7745514•••-••-73337045959291—·452 ELM STNashvilleTN37285GRP-5188·MEDICARE-ADV-B
ENRENR-1305412026-04-27T16:25:05ZJAMES··—SINGH1950-09-18UHC-27464-66•••-••-1575+1 395 981 0434··null8565 Sunset BlvdGilbertAZ85215GRP-3196OPTIONS-PPO
ENRENR-1317222026-03-27T00:55:02Zlawrence—carpenter1948-04-25··UHC0264289•••-••-2945662.221.5798lawrence.carpenter20@outlook.com132 VALLEY VIEW DRCOLUMBUSOH43281GRP-0862CHOICE-PLUS-PPO
ENRENR-1182132026-06-26T03:46:06ZAustinY.Patel22-10-1972UHC-18926-01•••-••-0143+1 756 297 3581—1655 Baseline RdAtlantaGA··30387GRP-0892CORE-HMO
ENRENR-1040432026-08-10T09:13:08ZARJUN····MCDONALD08/26/41UHC-38130-42•••-••-2335(925) 670-5968··ARJUN.MCDONALD67@AOL.COM2118 Meadow LnORLANDOFL32868GRP-8323··CHOICE-PLUS-PPO
ENRENR-1128452026-01-21T01:59:08ZAlbert—Ellis15-02-2004UHC-92774-12•••-••-9758+1 308 461 7762N/A2575 Desert Sky BlvdSeattleWA98186GRP-3905CHOICE-PLUS-PPO··
ENRENR-1094282026-07-01T14:13:47ZCHRISYMUNOZ1994-03-17·UHC-65054-33•••-••-0479221-530-3664christine.munoz@outlook.com··8848 Ocean Ave···ChandlerAZ85219GRP-5240SELECT-EPO··
ENRENR-1150222026-09-19T05:52:42ZVirrginia·T—1950-01-25UHC-50653-70•••-••-1285748-272-6254··VIRGINIA.WRIGHT86@YAHOO.COM4695 MARKET STLos AngelesCA90035GRP-7828MEDICARE-ADV-B
ENRENR-1161612026-05-30T16:24:37ZKATHLEENABRYANT1993-08-19UHC-97131-90•••-••-3937+1 548 237 8126—5236 Mesa DriveScottsdaleAZ85288GRP-1342MEDICARE-ADV-B
ENRENR-1052012026-09-19T11:39:33Z·ANNP.STEPHENS1940-06-06UHC8952257•••-••-8370(810) 301-5570ANN.STEPHENS@YAHOO.COM2592 GRAND AVE··AtlantaGA30307GRP-6323SELECT-EPO
ENRENR-1195702026-09-22T08:17:24ZJacquelineLAlvarado19460210UHC-56970-49—956-715-6934null9838 Lake View RoadSan DiegoCA92157GRP-7172SELECT-EPO
ENRENR-1024402026-03-12T09:09:01ZvalentinaNobrien·1965-06-13UHC-50153-59•••-••-9746857-841-2143UNKNOWN5035 Oak StLOS ANGELESCalifornia90086GRP-0280CHOICE-PLUS-PPO
ENRENR-1398102026-02-18T09:13:39ZBaker, TylerF—1984-10-82UHC-11302-82•••-••-1713(381) 880-0188-4303 Elm StreetGlendaleAZ85368GRP-8357CORE-HMO
ENRENR-1163492026-07-12T13:25:27ZTorres, Ethan——1965-03-17UHC-32591-84•••-••-9787516-378-9367ethan.torres65@hotmail.com7779 Maple AvenueCOLUMBUSOH43224GRP-3850CHOICE-PLUS-PPO
ENRENR-1274282026-10-14T09:53:05ZMarilynLGuerrero··1961-03-04UHC-39266-24•••-••-954714427188502MARILYN.GUERRERO@ICLOUD.COM5766 Market StreetFresnoCAUNKNOWNGRP-6983MEDICARE-ADV-B
ENRENR-1071182026-10-09T05:35:36ZDiegoJBradley1981-06-15UHC-63626-44•••-••-2068940-594-8889DIEGO.BRADLEY@ICLOUD.COM4128 SUNSET BOULEVARDSacramentoCA95838GRP-1894NAVIGATE-HMO
ENRENR-1157402026-07-20T16:12:31ZHenry, Alvarez——Sep 16, 1956UHC-27814-80•••-••-7832904.238.8403henry.alvarez79@proton.me2832 Meadow Ln··TampaFL··UNKNOWNGRP-9458SELECT-EPO
ENRENR-1293742026-09-19T23:19:11ZABBYLSOTO27-03-1953UHC-46807-97•••-••-52286174447910abigail.soto@aol.com3268 Lake View Rd Apt 39MesaAZ85252GRP-3634··CORE-HMO··
ENR ENR-1178562026-02-14T11:44:15ZEmilyPWallace0510-20-04·UHC-48730-84—(855) 821-9814·emily.wallace@outlook.com4775 Camelback RdDenverCO80211·GRP-9508CORE-HMO
ENRENR-1200782026-04-09T17:09:20ZJOSEPH—FLORES1963-12-05UHC-55754-19•••-••-7720448-203-2667JOSEPH.FLORES1@GMAIL.COM6339 Lincoln Way··PhoenixAZ·85027·GRP-6520·NAVIGATE-HMO
ENRENR-1031552026-03-14T10:51:52Zhlen—rios1964-12-02UHC-06308-99•••-••-0767471-854-4729····4173 OCEAN AVENUECOLUMBUSOH43219GRP-9229MEDICARE-ADV-B
ENRENR-1021612026-02-13T03:42:57ZEMMAM··SIMPSON11/24/1980UHC-76767-30•••-••-4664424-368-5159emma.simpson@yahoo.com2840 Lake View Road··DENVERCO80298GRP-2345CORE-HMO
ENRENR-1111362026-03-28T10:52:28ZChristian··J.Marshall04-01-1994UHC-58093-69•••-••-54068485091616N/A5719 SUNSET BOULEVARDMinneapolisMN55478GRP-3414MEDICARE-ADV-B
ENRENR-1122932026-06-29T14:20:18ZMikeP.Chapman1940-01-19UHC-39235-47•••-••-85054339349727michael.chapman90@hotmail.com2022 Market StPHOENIXAZ85001GRP-3561NAVIGATE-HMO
ENRENR-1301552026-09-24T16:07:47ZRANDYB.REID25-10-1997UHC-02401-36•••-••-2895(446) 791-6031randy.reid22@hotmail.com6483 Highland AvenueAustinTX78720·GRP-2193CHOICE-PLUS-PPO··
ENRENR-1313482026-01-13T00:00:21ZCharles—Cook—UHC6873507•••-••-5097UNKNOWNCHARLES.COOK@PROTON.ME7669 Hillcrest RoadOrlandoFL32812GRP-6878OPTIONS-PPO
ENRENR-1041512026-03-26T02:43:09ZSteveen—PatelSep 21, 1985—•••-••-98092462632700steven.patel@icloud.com··1866 Baseline RoadATLANTAgaN/AGRP-9935MEDICARE-ADV-A
ENRENR-1427022026-09-12T14:31:46ZAmberZSalazar1995-06-04UHC-48415-05•••-••-6820(210) 535-7373NULL5289 Jefferson AvenueAtlanta··Georgia30368GRP-7401NAVIGATE-HMO
ENRENR-1410622026-08-24T17:02:39ZRussellFSchultz9181-01-04UHC-35071-02•••-••-8639+1 649 891 0779russell.schultz24@aol.com4539 MARKET STREETScottsdale··AZ85227-0148GRP-2023MEDICARE-ADV-B
ENRENR-1040582026-03-25T02:07:17ZDebLOrtega1968-01-13UHC-28296-54NULL746.213.6419deborah.ortega@outlook.com4916 MARKET STREET #596DallasTexas··75219GRP-5147MEDICARE-ADV-A
43,101 rows, page 295 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.456Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty