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-1250392026-03-29T20:04:56ZWei··—Reynolds1973-07-01UHC-28141-19•••-••-9980(390) 245-9383wei.reynolds72@proton.me2782 Apache BoulevardScottsdaleAZ85297··GRP-8841MEDICARE-ADV-A
ENRENR-1177562026-04-27T21:55:28ZwalterKhoward1989-11-06UHC-62014-90•••-••-642914646130211walter.howard90@proton.me9868 Cedar LaneDallasTX75216GRP-9402CORE-HMO
ENRENR-1380902026-08-09T07:56:45Z JoeBWelch2003-03-10UHC-01942-36•••-••-5676(447) 340-1088JOE.WELCH49@GMAIL.COM8568 OCEAN AVENUEPhoenixAZ··85071-7976GRP-2440··medicare-adv-b
ENRENR-1127882026-03-17T10:44:32ZHelen—Ward19981021uhc-75310-08•••-••-2219UNKNOWNUNKNOWN1861 Jefferson AvenueCHARLOTTE·nc28240-4873GRP-4018CHOICE-PLUS-PPO
ENRENR-1041562026-07-03T17:58:42ZAngela—·Matthews1982-03-13UHC-45285-88-——5824 CEDAR LANE·Sacramentoca95835GRP-9511MEDICARE-ADV-B
ENRENR-1355352026-10-08T17:35:43ZTimothy··Q.Wang1948-06-10UHC-63226-44•••-••-8882+1 642 887 7182timothy.wang74@gmail.com9121 Willow CourtHoustonTX77031GRP-2796MEDICARE-ADV-B
ENRENR-1312212026-07-23T16:19:16ZJERRY—HUNTER1998-11-13UHC-02293-76•••-••-67902276623767jerry.hunter@hotmail.com3193 Park PlaceCOLUMBUSOH43280GRP-0904CHOICE-PLUS-PPO
ENRENR-1301222026-05-10T04:08:12ZNatalie—Payne1972-03-19UHC-54535-12•••-••-1004(588) 336-0794·NULL3159 MAPLE AVENUEColumbusOhio43268GRP-7951CORE-HMO
ENRENR-1066832026-06-18T11:45:59ZSeanFSoto··19570128UHC-24426-72•••-••-9273(852) 430-3535sean.soto@yahoo.com6854 Canyon RdPlanoTX·75020GRP-8490··NAVIGATE-HMO
ENRENR-102755 2026-06-27T04:35:41ZAnaTFox09/13/54··UHC-70153-80··•••-••-15106986402423ana.fox@gmail.com9363 Lake View RdMinneapolisMN55496GRP-9545·MEDICARE-ADV-B
ENR ENR-1254092026-01-21T18:37:12ZJesse····Valdez1980-02-13UHC-62374-36null8658959878·JESSE.VALDEZ94@GMAIL.COM8047 Sage CtSan Diego·CAN/AGRP-1506CHOICE-PLUS-PPO
ENRENR-1277752026-10-11T01:55:54ZJOYCEYJOHNSON·1998-12-12UHC-61674-63•••-••-10602422470655joyce.johnson61@yahoo.com5954 Central AvenueSan DiegoCA92120GRP-4431MEDICARE-ADV-A
ENRENR-1210132026-02-01T04:05:28ZJUDY—BENNETT1968-05-22UHC-60721-43··•••-••-8820+1 693 429 7827UNKNOWN2494 Apache BoulevardPlanotx75095GRP-6257NAVIGATE-HMO
ENRENR-1211642026-01-23T08:02:16ZJENNIFER—KELLYE16-01-1977UHC4498276•••-••-46239185076305JENNIFER.KELLEY13@GMAIL.COM·250 Desert Sky BlvdPlanoTX75064GRP-7715CORE-HMO
ENRENR-1357692026-03-21T04:09:43ZVincentS.Graham26-05-1998N/A··•••-••-76219733688954vincent.graham80@gmail.com2048 Hillcrest RdJacksonvilleFlorida32208GRP-4216MEDICARE-ADV-A
ENRENR-1340902026-10-10T06:46:49ZBEVERLY—KNIGHT2005-10-11··UHC-98679-81•••-••-59113316395406N/A2069 Camelback RoadOrlandoFL32827GRP-7702OPTIONS-PPO
ENRENR-1346622026-10-11T13:27:10ZJoan—Morales1945-05-09UHC-00278-12•••-••-8768352-422-9122joan.morales@aol.com2787 Union StreetJacksonvilleFL32218GRP-4011MEDICARE-ADV-A
ENRENR-1242782026-02-16T02:48:50ZTimothy—Tran1992-05-05UHC-72026-20··•••-••-3806496-622-0535timothy.tran36@aol.com619 BASELINE ROADLos AngelesCAN/AGRP-1151core-hmo
ENR ENR-1294842026-10-05T05:57:08ZJYOCE—REID11/17/1994UHC-47204-79•••-••-4382(565) 905-7261--—UNKNOWN—GRP-6054CHOICE-PLUS-PPO
ENRENR-1368872026-09-19T03:04:31ZChristian—·Ford06/12/1959UHC-71264-08··N/A··—NULL746 Spring StreetSeattleWAnullGRP-2440MEDICARE-ADV-A··
ENRENR-1396382026-07-08T08:15:03ZLarry—Moreno1959-04-27UHC7451627•••-••-294213194491091larry.moreno82@icloud.com6676 Oak Street Apt 5··TempeAZ85271GRP-7637MEDICARE-ADV-B
ENRENR-1121662026-01-23T12:17:54ZLinda—Torres1958-03-14UHC-64815-53•••-••-6306(720) 638-0745LINDA.TORRES@GMAIL.COM2494 Apache BlvdColumbusOHN/AGRP-8412NAVIGATE-HMO
ENRENR-1429642026-04-12T03:39:06ZWAGNERXJACOB19870808UHC-37199-53•••-••-14083434966818-3449 Grand AvenueGilbertArizona85258GRP-7316··OPTIONS-PPO
ENR ENR-1070862026-09-20T14:41:46Zdouglas····sims1955-11-20UHC-18514-72•••-••-5928(853) 594-2098douglas.sims68@icloud.com9415 Baseline RdChandlerAZ—GRP-1359CORE-HMO
ENR ENR-1425092026-05-25T14:12:09ZDebra—Stevens··1953-05-19UHC-75420-71•••-••-79236884376812debra.stevens72@aol.com··1289 LINCOLN WAYDenver·CO80211GRP-1516OPTIONS-PPO··
ENRENR-1205402026-10-13T08:06:32ZLuis··—Ruiz··10-01-1979UHC-50265-15•••-••-42829706176774N/A240 BROADWAYSan Antonio··TX78299GRP-2968MEDICARE-ADV-A
ENRENR-1088412026-06-06T03:24:57ZMARCUS Q—ROMERO··1990-03-08UHC-49692-40•••-••-4084·390.210.3346marcus.romero43@aol.com7791 Indian School RdDenverCO·80232GRP-2559OPTIONS-PPO
ENRENR-1128172026-01-06T11:39:08ZIsabellaHWelch1970-11-20UHC-84376-98null(330) 980-7018isabella.welch@icloud.com9512 Maple AvenuePlanoTX75092··GRP-8646MEDICARE-ADV-A
ENRENR-1133952026-08-24T22:44:13Z CHERYLKMURRAY—UHC-17856-63•••-••-8733(262) 712-0325cheryl.murray42@icloud.com8800 Union StNASHVILLETN37293GRP-3145CHOICE-PLUS-PPO
ENR ENR-1381242026-05-17T00:51:11Z Joye—Baker3/28/1946UHC-28092-57•••-••-7401(603) 711-1101·JOYCE.BAKER@AOL.COM9688 MESA DRSan AntonioTX78286GRP-4337MEDICARE-ADV-A
ENRENR-1104702026-01-06T23:36:19ZJULIAX·SOTO17-12-1986UHC-52203-01•••-••-7536569.669.1671JULIA.SOTO@HOTMAIL.COM9040 Mountain View DriveMinneapolisMinnesota55486GRP-9462SELECT-EPO
ENRENR-1132782026-06-30T05:20:50ZDEBORAH—LITTLE1941-08-12UHC-68216-91•••-••-92494875858566—4242 LINCOLN WAYMiamiFL33182GRP-5149MEDICARE-ADV-B
ENRENR-1129752026-06-23T07:52:09ZChavez, Jessica····—2008-08-08UHC-93346-83•••-••-4855219-813-1810jessica.chavez@icloud.com3793 Washington StPhoenixAZ85091GRP-6148MEDICARE-ADV-B
ENRENR-1015742026-09-06T05:43:30ZBrittanyK.Hawkins—UHC-72035-60•••-••-8605-UNKNOWN4053 Pine Drive·CharlotteNC28241GRP-2517NAVIGATE-HMO
ENRENR-1266012026-03-15T16:26:45ZCynthia—Santiago2001-03-01UHC-79695-95•••-••-0139(254) 792-9815···cynthia.santiago29@gmail.com234 Park PlaceAUSTINTX·78779·GRP-1850CHOICE-PLUS-PPO
ENRENR-1269152026-09-25T02:50:20ZKenneth—Munoz1972-10-21UHC-58681-80•••-••-39239067019kenneth.munoz@proton.me7035 Union StreetJacksonvilleFL32254GRP-7371choice-plus-ppo
ENRENR-1160762026-06-17T10:07:47Ztommy··Hboyd1996-11-05UHC-69763-81•••-••-5425810-438-8722·thomas.boyd@icloud.com204 Indian School RdGLENDALEAZ85368··GRP-6663SELECT-EPO
ENRENR-1367262026-06-19T08:16:16ZJustin—Perkins1938-11-26UHC-33199-49NULLNULLNULL4991 Valley View DriveORLANDO··FL32832-6458GRP-6095MEDICARE-ADV-B
ENRENR-1376082026-08-20T12:52:15ZERICCRYAN1942-11-12UHC-58529-87•••-••-1004+1 501 223 5874··eric.ryan23@proton.me726 Spring StFresnoCA93761GRP-8687··SELECT-EPO
ENRENR-1093422026-01-19T14:14:11ZVega, AnnaT.—10/11/1992UHC-92950-24•••-••-2016·720-646-9415anna.vega@gmail.com1640 Forest AvenueEden Prairie··MN55388GRP-0876SELECT-EPO
ENR ENR-1119422026-05-17T09:24:46ZAARONJBELL19400315UHC-97382-48--aaron.bell@aol.com6456 Baseline Road Apt 20HOUSTONTX·77085·GRP-4977MEDICARE-ADV-A
ENRENR-1187752026-04-07T15:46:13ZBRITTANYK.AGUILAR1974-03-25UHC-02244-47•••-••-174215194080814·brittany.aguilar62@aol.com·6429 CANYON ROADTempeAZ85201GRP-7319··NAVIGATE-HMO
ENRENR-1215282026-03-22T00:15:11ZTIMOTHYY.AGUILAR19961108UHC-28975-92•••-••-1219(500) 271-3314UNKNOWN1629 RIVER ROADLas Vegas··NV89123GRP-7859CHOICE-PLUS-PPO
ENRENR-1308552026-05-28T21:49:28ZHaroldZFranlkin02/23/80UHC-93681-23•••-••-8308(870) 553-9675harold.franklin98@yahoo.com8586 Sage CourtScottsdaleAZ85291GRP-3415CORE-HMO
ENRENR-1207612026-02-06T15:02:37ZJerry—Brooks11/13/06UHC-31314-44•••-••-7792(930) 429-1308null9445 Market StreetGLENDALEAZNULLGRP-4227OPTIONS-PPO
ENRENR-1172912026-07-15T13:21:39ZJesse—Watson20001002UHC-89198-62•••-••-4072(986) 446-6869jesse.watson32@icloud.com1977 JEFFERSON AVENUE #570SacramentoCA95816GRP-5823OPTIONS-PPO
ENRENR-1249932026-09-21T08:38:34ZOrtega, SharonM.—1972-05-08UHC-75713-53•••-••-9676936-639-0348sharon.ortega@proton.me9011 Willow CtAtlantaGA30306GRP-5646SELECT-EPO··
ENRENR-1075552026-09-18T22:39:23ZnathanDyang1987-01-17UHC-14113-01•••-••-182714376206718null7782 Oak StreetMinneapolisMN··GRP-1500SELECT-EPO
ENRENR-1118082026-09-12T23:13:05ZThomas—Mtathews2002-01-14UHC-82481-42•••-••-3181·+1 815 331 4166THOMAS.MATTHEWS39@AOL.COM9134 Oak StreetDALLAS··tx75287GRP-2869CORE-HMO
ENRENR-1381922026-05-02T21:45:53Zracheel····white7/15/2005UHC-55755-99-(958) 955-0749rachel.white@proton.me·4247 BROADWAYTAMPAFL33688GRP-5541MEDICARE-ADV-A
43,101 rows, page 269 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.425Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty