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-1049552026-02-16T19:20:15ZLuis—Hughes03/13/87UHC-16328-06•••-••-78226547174157··LUIS.HUGHES15@YAHOO.COM·8374 SUNSET BLVDSeattleWA98119GRP-6642CORE-HMO
ENRENR-1344972026-09-14T02:15:29ZEMILY—KELLY1951-05-02UHC-20322-38•••-••-1521491-297-2433··-1708 Bayshore DrNashvilleTN··37260GRP-1690SELECT-EPO
ENRENR-1245452026-03-26T11:38:08ZGARYATUCKER2000-06-04UHC-38611-50•••-••-6890418-696-4420gary.tucker@outlook.com5434 DESERT SKY BLVD Apt 32OrlandoFL32853GRP-8197OPTIONS-PPO
ENRENR-130241 2026-08-12T15:25:14ZJUDYG.WELCHJun 8, 1968··UHC-74292-52•••-••-8948+1 700 726 1911JUDY.WELCH@YAHOO.COM4253 Lake View Rd·GilbertAZnull·GRP-3087CHOICE-PLUS-PPO
ENRENR-1336562026-06-25T07:15:20ZjacobGdelgado··1947-07-20UHC-31161-34•••-••-3396612.596.8561NULL2978 BroadwayEDEN PRAIRIEMN55373GRP-5412MEDICARE-ADV-B
ENRENR-1007002026-06-24T09:36:52ZBobbyT.RiosUNKNOWNUHC-87914-49•••-••-8764(862) 548-4940null3864 Mountain View DriveMINNEAPOLIS··MN55471GRP-8880CORE-HMO
ENRENR-1392922026-04-14T18:35:27ZJudy—Jensen05/27/1983UHC-28149-36N/A+1 483 623 0360·judy.jensen@outlook.com6027 Desert Sky BlvdAtlanta·Georgia·30373GRP-5029MEDICARE-ADV-B
ENRENR-1156582026-05-08T22:00:05ZJerryZSmith1960-02-22UHC-94989-34•••-••-2054(532) 675-0204JERRY.SMITH79@OUTLOOK.COM3768 UNION STTEMPEaz85240-0773··GRP-4413·CHOICE-PLUS-PPO
ENRENR-1129112026-08-13T04:49:15Zjulei··P.soto19880423UHC1242303··•••-••-3080(331) 449-4120julie.soto@hotmail.com8093 Jefferson AveSan DiegoCA92188GRP-9522NAVIGATE-HMO
ENRENR-1410822026-04-10T13:30:41ZMEGANWCARLSON1987-09-17··UHC-52900-15•••-••-3330(804) 944-2516··megan.carlson@outlook.com6904 Elm StreetPlanoTexas75072GRP-3868NAVIGATE-HMO
ENRENR-1233782026-04-04T13:46:08ZSTEPHENPSALAZAR1991-08-14UHC-65375-07•••-••-2406UNKNOWNNULL···723 Baseline RdAtlantaGA30397GRP-0839MEDICARE-ADV-A
ENRENR-1391722026-04-23T04:42:39ZJASONVORTEGA1996-12-07UHC-48110-72•••-••-606615958328200··JASON.ORTEGA8@PROTON.ME7545 Apache BlvdSAN ANTONIO··TX—GRP-5974options-ppo
ENRENR-1262972026-01-26T20:45:29ZDorisW.Gilbert1969-12-25·UHC-87880-23•••-••-3359(744) 317-0146—5809 Forest Ave·ColumbusOH43263GRP-8621OPTIONS-PPO
ENRENR-1142882026-03-30T07:03:42ZRaymondH··Duncan19981222UHC-54666-50•••-••-9469null—5942 Church StreetLas VegasNV89151GRP-7465MEDICARE-ADV-B
ENRENR-1330602026-09-19T00:04:33Zhowell—michael17-10-1990UHC6100406•••-••-5219339-223-5079michael.howell@proton.me7155 Palm DriveTempeAZ85207-0503GRP-7218SELECT-EPO
ENRENR-1003132026-05-31T17:09:11ZSarrah—Sanders1961-05-12UHC-10031-33•••-••-9091227-458-0840sarah.sanders57@hotmail.com·9257 Willow CtPhoenixAZ85097GRP-7280OPTIONS-PPO
ENRENR-1029982026-08-24T07:39:19ZRuthK.Valdez1967-03-10UHC-84907-63•••-••-9700(664) 294-6196-7268 Jefferson AveSeattleWA··98159··GRP-5180CORE-HMO
ENRENR-1268012026-03-18T02:20:41ZDiego····Dean1990-08-08UHC-15193-16•••-••-00527456293363-5012 MEADOW LNAtlantaGA30393GRP-1181NAVIGATE-HMO
ENRENR-1106402026-04-29T04:34:32ZMelissaRGardner1949-02-05UHC-81275-40··•••-••-0698·(638) 376-9295melissa.gardner@hotmail.com778 Apache Boulevard··AUSTIN··TXNULLGRP-6713SELECT-EPO
ENRENR-1054902026-03-31T02:04:38ZGrant, AustinX—Apr 20, 1947UHC5165367•••-••-4323209-763-0263AUSTIN.GRANT12@ICLOUD.COM3805 CENTRAL AVENUEAtlantaGA—GRP-0535··medicare-adv-a
ENRENR-1087562026-03-02T17:04:39Zkatherine—contreras08/11/2008UHC-56653-97•••-••-8148null·KATHERINE.CONTRERAS39@ICLOUD.COM5484 Mountain View DriveSan Diego··CA92100GRP-0544NAVIGATE-HMO
ENRENR-1211052026-06-28T22:11:42Zmei—estrada1984-09-01UHC-89514-53•••-••-69814512331902mei.estrada54@gmail.com9821 Market StreetChandlerArizona··85287GRP-8704CHOICE-PLUS-PPO
ENRENR-114396 2026-01-17T22:31:48ZJANICEO.HOLMES1981-12-11UHC-67731-09-893.885.4425null638 Elm StreetSAN ANTONIOTX—GRP-9727MEDICARE-ADV-B
ENRENR-1063502026-02-15T01:44:12ZMarilynJBoyd19401111UHC-09243-10•••-••-9102740.595.6960MARILYN.BOYD@OUTLOOK.COM919 Canyon RdMesaAZ·85215GRP-6182MEDICARE-ADV-A
ENRENR-1130062026-03-21T23:08:46ZGarza, Sntiago——19940726UHC-94718-70•••-••-15063157505502santiago.garza@hotmail.com4439 Highland AvenueAtlantaGeorgia30315GRP-6499CORE-HMO
ENRENR-1330282026-09-07T09:43:36ZHiroshiEHerrera1971-09-28·UHC-98794-47•••-••-4523456.513.8965UNKNOWN5254 Palm DrCOLUMBUSOH43228GRP-3580CHOICE-PLUS-PPO
ENRENR-1004712026-07-29T16:24:47ZDANIELLE—TURNERMar 28, 2001UHC-41679-22•••-••-9065421-649-1332danielle.turner@hotmail.com9206 Pine DrColumbusoh43226GRP-7691SELECT-EPO
ENRENR-1423202026-03-14T00:59:34ZCynthiaBWright2003-06-28UHC-54615-41•••-••-7602·(765) 929-5480UNKNOWN6050 Spring StTampa··FL33636GRP-2247CHOICE-PLUS-PPO
ENRENR-1193942026-05-29T18:40:21ZEmmaK.Brooks05/01/72UHC-09562-95•••-••-131612039757599EMMA.BROOKS68@HOTMAIL.COM453 Canyon RoadSacramentoCANULL··GRP-3458CORE-HMO
ENRENR-1168612026-03-17T22:46:55ZAbby··MJohnson11/17/69UHC-27991-80•••-••-8156(716) 791-9653··abigail.johnson@aol.com658 Elm StCharlotte··NC28209GRP-3971CORE-HMO
ENRENR-1412322026-09-07T15:18:46ZSeanS.Payne2004-10-01UHC-34145-90•••-••-1389360.446.5474—7739 Mesa DrAustinTX78710GRP-7367SELECT-EPO
ENRENR-1041042026-06-19T14:34:24ZDyln—Morris1947-09-14UHC1095650•••-••-4462UNKNOWNnull3933 Camelback RoadSeattleWA98154·GRP-7458MEDICARE-ADV-B
ENRENR-1273052026-01-20T22:18:57ZJOYCE—·CARTER·2006-11-01UHC-28186-60•••-••-6795225-464-6045joyce.carter1@gmail.com8256 BROADWAYHoustonTX—GRP-6007MEDICARE-ADV-B
ENR ENR-1371592026-01-21T15:45:21Z CHERYLRREYNOLDS12/05/1947UHC-05597-29•••-••-8763544-339-8066cheryl.reynolds69@outlook.com2655 Market StreetMinneapolisMN55482GRP-6976NAVIGATE-HMO
ENRENR-121994 2026-10-03T16:04:18ZJordanGFisher1949-10-12UHC-55830-11•••-••-3163(649) 472-2996jordan.fisher51@aol.com7641 Mesa DrDenverCO—GRP-2622NAVIGATE-HMO··
ENRENR-1005432026-08-09T18:53:28ZDOUGLAS··EREYES09-09-1968UHC-89598-42•••-••-0849296-210-6401—7814 CENTRAL AVESCOTTSDALEArizona85284-1537GRP-6162CORE-HMO
ENRENR-1006612026-09-01T17:25:29ZJessicaFYang1998-10-26UHC-15571-89null(495) 354-2647jessica.yang62@yahoo.com··6280 Lake View RoadLos AngelesCA90024-2512GRP-5357SELECT-EPO
ENRENR-1346892026-06-16T02:57:17ZRoyALawrence06/09/93UHC-96696-03•••-••-0098(374) 964-3075—1251 Main StreetDallasTX75274GRP-4857SELECT-EPO
ENRENR-131188 2026-05-04T14:58:18ZMoore, Jerry—··1945-05-22UHC-78611-44•••-••-8651232-830-2156jerry.moore22@gmail.com200 Hillcrest RoadMesaAZNULLGRP-0382OPTIONS-PPO
ENR ENR-1141202026-07-23T05:40:43ZMEDISON····WALKER1946-10-05UHC-10718-47—UNKNOWNmadison.walker@proton.me6685 BroadwayTempeArizona85249GRP-5049NAVIGATE-HMO
ENRENR-1087112026-09-25T10:12:43ZMarthaS.·Young2000-69-17·UHC-71458-40•••-••-102012252211821martha.young75@icloud.com5367 Grand AveTUCSONArizona··—GRP-5966CHOICE-PLUS-PPO
ENRENR-1026592026-05-21T13:19:07ZLarry—Butler··19530419uhc-35192-72··NULL582-451-9472larry.butler60@icloud.com3941 Palm DrSan AntonioTexas78201GRP-1666NAVIGATE-HMO
ENRENR-1195392026-06-12T11:21:12ZKATHERINE—TUCKER1949-10-27UHC-50556-18—·468-282-0604katherine.tucker36@gmail.com7176 MAPLE AVE Apt 7CHANDLERAZ··85272GRP-6099NAVIGATE-HMO
ENRENR-127069 2026-06-09T17:31:44ZTucker, AliceY—1974-09-01UHC-17436-51•••-••-81197338388622—6349 River Road··CHARLOTTEnc28248GRP-4519MEDICARE-ADV-B
ENR ENR-1385632026-07-12T13:51:45ZDIANE····LONG1979-08-25UHC-32715-79N/A2753249001diane.long@hotmail.com4779 SAGE CTMiamiFL33130GRP-2574CORE-HMO
ENRENR-1189772026-04-08T03:33:51ZCHERYL—PATTERSON1989-05-27UHC2760867—+1 452 380 8551CHERYL.PATTERSON@AOL.COM6322 Valley View Drive··OrlandoFL32825GRP-5577SELECT-EPO
ENRENR-1143112026-04-09T19:22:59ZDon—Silva19740708uhc-22389-52•••-••-9596825-563-7206—7501 CAMELBACK RDSeattleWashington98164GRP-2542CORE-HMO
ENRENR-1381302026-05-06T10:21:34ZMaggie—Vasquez1946-06-20·UHC-54000-11•••-••-6163——····—-····GRP-4207CHOICE-PLUS-PPO
ENRENR-1378292026-03-11T18:52:42ZFuller, Lori——09/22/1985UHC-99756-56•••-••-6526(781) 920-4849lori.fuller17@icloud.com2591 CAMELBACK RDTampaFL33624-5767GRP-4348CHOICE-PLUS-PPO
ENRENR-1311162026-05-19T18:16:35ZPat—Ferguson1970-05-01UHC-00688-98•••-••-9607569-548-9503·PATRICK.FERGUSON95@HOTMAIL.COM3806 Valley View Dr Apt 37OrlandoFL32810-3150GRP-1828CORE-HMO
43,101 rows, page 290 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.450Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty