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-1347692026-09-28T13:34:52ZJoyce—Soto12/01/1946UHC-33573-25•••-••-08293538403056··JOYCE.SOTO29@GMAIL.COM9290 River Rd #790CHARLOTTENC·28262GRP-9952MEDICARE-ADV-B
ENRENR-1282192026-07-30T20:46:07ZBilly—Williams1950-04-07UHC0391592··•••-••-1073251-501-0182····6354 Baseline RdHoustonTexas77045GRP-9531OPTIONS-PPO
ENRENR-1052802026-02-26T17:23:39ZVIRGINIAIWATKINSJun 2, 2001UHC-37597-20··UNKNOWN641-256-0344VIRGINIA.WATKINS54@ICLOUD.COM·3141 Mesa DrMiamiFL33125GRP-8072SELECT-EPO
ENRENR-1147732026-01-18T22:33:13Z·Betty V—·Wood1950-04-12UHC6838704•••-••-4630(558) 980-6735NULL7551 Lincoln WaySeattleWA98176-0667GRP-2745··CORE-HMO
ENRENR-1098402026-02-13T19:44:08ZDANIEL—LE1973-04-26UHC-39813-91•••-••-73753270364daniel.le@icloud.com7309 OAK STTucsonAZ85782GRP-3481CHOICE-PLUS-PPO
ENRENR-1103512026-09-20T04:42:20Z Marilyn—Hunt··2000-04-25UHC-87899-87•••-••-3851(433) 404-9923—2638 Indian School RoadNASHVILLE··TN37286GRP-8387·CORE-HMO
ENRENR-1344662026-02-14T11:43:31ZJoan—Guerrero··1996-07-23UHC8298408•••-••-0174+1 467 833 5920joan.guerrero@yahoo.com6234 Hillcrest RdDenverCO80259GRP-5686NAVIGATE-HMO
ENRENR-1334902026-02-27T11:48:49ZYUKINLONG·Mar 6, 2000UHC5663357•••-••-16819542230355null··4148 Oak StSeattleWA98148GRP-5797CHOICE-PLUS-PPO
ENRENR-1303382026-05-01T23:41:09ZLong, JennniferM—19461001UHC-02743-88•••-••-7647542-372-6895-8751 Harbor BlvdMinneapolisMN55415GRP-6553CHOICE-PLUS-PPO
ENRENR-1075252026-02-24T15:48:01ZharoldNraySep 21, 1946UHC6168471•••-••-14394365981HAROLD.RAY47@ICLOUD.COM5887 Jefferson AvenuePhoenixAZ85047GRP-0158CHOICE-PLUS-PPO
ENRENR-1005212026-01-26T18:03:15ZDeborahY.Williams19671227·UHC-53086-07•••-••-9249(474) 991-4477deborah.williams@outlook.com6972 Grand AvenueMiami··FL33164GRP-0473OPTIONS-PPO
ENRENR-1387302026-06-03T14:41:19Zsofia··M.richards1997-06-09UHC-38846-21•••-••-7932(531) 889-6083SOFIA.RICHARDS@AOL.COM7080 Market StreetTampaFL33690GRP-2377NAVIGATE-HMO
ENRENR-138966 2026-06-13T20:18:00ZGloria—·Martin1989-09-15UHC-38570-43•••-••-370016596731875gloria.martin56@outlook.com6216 Canyon Road #284MiamiFL33155GRP-6616MEDICARE-ADV-B
ENRENR-1214672026-04-23T15:49:56Z Beverly—Greene··1955-12-28UHC-77622-64•••-••-1265639-970-5417··N/A2041 Forest AvenueTempeAZ85203GRP-9481CHOICE-PLUS-PPO
ENRENR-131270 2026-05-25T05:54:12ZJulie—Cunningham2/7/1995UHC-66087-50•••-••-3866+1 761 404 3718julie.cunningham18@outlook.comnull····nullnullGRP-8766CHOICE-PLUS-PPO
ENRENR-1181072026-08-02T01:52:13ZMARCUS—AGUILAR22-07-1977UHC-13029-18•••-••-68143238528253marcus.aguilar@proton.me4797 Cedar LnSacramentoCalifornia95887·GRP-4538NAVIGATE-HMO
ENRENR-1261482026-05-18T05:55:32ZKELLY—·VASQEUZ1994-11-02UHC-28576-12—836-826-8136-2110 Church StreetMesaAZ85274GRP-5196OPTIONS-PPO
ENRENR-1239962026-02-24T19:11:27ZElijah—Stephens2002-10-04UHC-28699-80—884-648-8345ELIJAH.STEPHENS@OUTLOOK.COM7755 RIDGE ROADJacksonvilleFlorida32240·GRP-9631MEDICARE-ADV-B
ENRENR-1221552026-01-06T21:36:59ZSamantha—·Tran1998-06-11UHC-34504-52•••-••-86993438300635null··null——nullGRP-5334MEDICARE-ADV-B··
ENRENR-1178072026-07-14T11:42:46ZBeverly—Elliott12/28/93UHC-59781-23•••-••-48534314943613BEVERLY.ELLIOTT@AOL.COM4808 Lincoln WayMinneapolisMN55464GRP-0848MEDICARE-ADV-B
ENRENR-1015702026-04-30T07:02:27ZMateo—Snyder1984-08-13UHC-26840-16•••-••-38467647397988mateo.snyder15@icloud.com7355 PINE DRIVE #524DallasTX75240-5842GRP-7832MEDICARE-ADV-B
ENRENR-1116352026-04-24T23:20:30ZVALENTINARNGUYEN1938-05-27UHC-21516-69•••-••-72636576986863-7640 Main StreetChandler·AZ85274GRP-6150CORE-HMO
ENRENR-1041542026-05-17T05:42:05ZANN—·SIMMONS19540913UHC-19311-66•••-••-0666(315) 437-2695ANN.SIMMONS77@OUTLOOK.COM3060 Market StreetGlendaleAZ85394-2845GRP-5520CHOICE-PLUS-PPO
ENRENR-1067562026-03-20T06:53:28ZEmmaO.Reed07-06-1991UHC-91196-41•••-••-71896332224385null5209 Desert Sky BoulevardPhoenixArizona85073GRP-2510MEDICARE-ADV-B
ENRENR-1290402026-01-30T11:03:24ZDIEGO—SINGH2008-10-21UHC-67990-40•••-••-1539767-465-0381·diego.singh2@outlook.com1486 BROADWAY Apt 39Las VegasNV89148GRP-4544MEDICARE-ADV-B
ENRENR-1266632026-06-01T04:04:53ZSTEPHANIE—LEE1958-09-17·UHC-99580-25•••-••-39755685265STEPHANIE.LEE66@ICLOUD.COM5666 Lake View RoadMinneapolisMinnesota·55423·GRP-7525select-epo
ENRENR-1290322026-04-29T16:05:42ZDOUGLAS—JENSENApr 27, 1974UHC-04832-19•••-••-201817262998344DOUGLAS.JENSEN43@AOL.COMN/A———GRP-0703·CHOICE-PLUS-PPO
ENRENR-1248342026-01-05T12:28:44ZAmy—Riley1957-03-05·UHC-09465-38•••-••-9674+1 699 559 0922····4668 Jefferson AveSeattleWA98123··GRP-8919OPTIONS-PPO
ENR ENR-1315342026-10-11T18:40:43ZWEIBSTEVENS1957-09-24UHC-61657-92•••-••-85312593872084WEI.STEVENS88@GMAIL.COM526 SAGE COURTAustinTX78788·GRP-6183OPTIONS-PPO
ENRENR-1272272026-04-11T10:28:10Z·SANDRAWOWENS1972-03-03UHC-34059-29•••-••-0203488-527-8152··SANDRA.OWENS79@HOTMAIL.COM7000 HARBOR BLVDCHANDLERAZ·-GRP-5273CORE-HMO
ENRENR-113255 2026-03-07T06:50:24ZPeterA.Myers1968-11-17·UHC-88337-04•••-••-4778905-859-2669peter.myers3@gmail.com5045 Church StreetGLENDALEAZ·85310GRP-7470OPTIONS-PPO
ENRENR-1281122026-02-09T01:00:24ZROGERF.·SLULIVAN01/21/41UHC-76081-48•••-••-69933587989838roger.sullivan18@yahoo.com9235 Hillcrest RdGlendaleArizona·85385GRP-8978CHOICE-PLUS-PPO
ENRENR-1278002026-04-08T01:25:45ZASHLEY—HOWARD1981-01-22UHC-68473-02N/A287-646-2150ashley.howard61@yahoo.com9460 WASHINGTON STREETGILBERTArizona85291GRP-6945··NAVIGATE-HMO
ENRENR-1156142026-05-27T07:54:57ZCAMILAKHUGHES19640215UHC-53890-36··•••-••-3948(986) 262-6835camila.hughes8@hotmail.com··8702 DESERT SKY BLVDAustinTX78788GRP-8620MEDICARE-ADV-B
ENR ENR-1355042026-09-06T02:10:14ZEugeneU.Martinez1977-07-22UHC-94632-57•••-••-86305557898981eugene.martinez99@outlook.com17 Pine DrivePLANOTX75043GRP-0738CHOICE-PLUS-PPO
ENRENR-1042322026-04-12T02:10:46ZJesse—Luacs1998-01-16··UHC-84275-95N/A(431) 622-6202jesse.lucas28@gmail.com1000 Mesa DrSeattleWA98146GRP-1466NAVIGATE-HMO
ENRENR-1340442026-02-15T08:54:31ZEDWARDSMARSHALL1999-06-22UHC-05611-09•••-••-3952·+1 962 259 6928EDWARD.MARSHALL@AOL.COM9599 Central AveCHARLOTTENC28247GRP-6718SELECT-EPO
ENRENR-1292562026-04-20T23:50:05ZBRIAN—HUNTER1942-01-08UHC-77779-46····276-275-9218brian.hunter42@hotmail.com9395 Ridge RdJacksonvillefl32211··GRP-1900CHOICE-PLUS-PPO
ENRENR-1375092026-04-20T23:18:37ZSaraAVega1971-11-12UHC-61662-93··•••-••-91018964138417UNKNOWN3538 Elm St Apt 19CHARLOTTENC28298GRP-0946SELECT-EPO
ENRENR-1165412026-03-18T11:21:57ZSophiaHVazquez11/26/1985UHC-13356-05•••-••-60322132198431sophia.vazquez@proton.me5272 Park PlGlendaleAZ85310GRP-5204CORE-HMO
ENRENR-1233922026-01-25T10:54:25ZValentinaQRoss1951-07-23UHC-49963-74•••-••-1816+1 436 492 8002valentina.ross34@yahoo.com2172 Hillcrest RoadCharlotteNC··28209GRP-8953NAVIGATE-HMO
ENRENR-1225082026-04-07T02:22:57ZTylerW.Boyd07/04/75UHC-60519-12•••-••-623615943139002tyler.boyd@aol.com2235 Highland AveLos AngelesCA90092GRP-6253CORE-HMO
ENRENR-1282172026-03-27T22:54:08Z DONALD—STEWART07/06/00UHC-62097-19•••-••-60242256334194—5415 Highland AvenueMinneapolisMN55498·GRP-3969choice-plus-ppo
ENRENR-1246932026-01-21T04:57:49ZStephens, Nicholas··N—1981-02-16··UHC-10068-73•••-••-2364795-402-9162··NICHOLAS.STEPHENS@HOTMAIL.COM··6724 River RdHoustonTX77097GRP-5867CHOICE-PLUS-PPO
ENRENR-1241852026-04-29T06:03:09ZpaulOadams1949-07-24UHC-57445-61•••-••-0110+1 867 640 1545paul.adams@aol.com1547 DESERT SKY BLVD·OrlandoFL32848GRP-9486CHOICE-PLUS-PPO
ENRENR-1368342026-07-07T21:39:20ZMARGARETJJORDAN21-06-1966UHC-24141-95•••-••-6034708-791-1723MARGARET.JORDAN@PROTON.ME3038 SAGE CTTempeAZ85286GRP-1378MEDICARE-ADV-B
ENRENR-1081942026-09-22T17:23:18ZIsabellaGHoward03/14/1999UHC-57509-85•••-••-3145733-898-8494isabella.howard@hotmail.com8125 MESA DRIVEEden PrairieMN·55326-5866GRP-5548CORE-HMO
ENRENR-1041862026-03-07T07:43:03ZMeganZPerkinsSep 3, 1985UHC-28097-08•••-••-31499665580892—3220 Camelback RdSeattleWA—GRP-2327MEDICARE-ADV-B
ENRENR-1342082026-04-04T04:35:49ZYukiIDaniels3/2/1971··UHC-57335-08•••-••-1091+1 466 384 4831yuki.daniels32@hotmail.com1842 Maple Avenue·CharlotteNC-GRP-1312SELECT-EPO
ENRENR-1401662026-06-11T13:28:20ZJonathan—Thompson··10-02-1997··UHC-39861-05-·567-460-3208UNKNOWN6515 Pine Drive #502JacksonvilleFL32264GRP-4778MEDICARE-ADV-A··
43,101 rows, page 99 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:37.735Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty