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-1319892026-04-19T20:21:33ZWagner, TylerB—1977-08-17UHC-29723-33•••-••-9390-tyler.wagner75@aol.com8116 Willow CtSAN ANTONIOTXN/AGRP-4611SELECT-EPO
ENRENR-1057222026-04-23T05:56:20ZJUDYBROSE1960-02-14UHC-80661-85•••-••-19156613165160JUDY.ROSE36@AOL.COM1226 HIGHLAND AVENUESacramentoCA95865GRP-0944SELECT-EPO
ENRENR-106526 2026-04-29T08:52:44ZLugan····Tucker1958-03-25UHC-57723-01•••-••-6647670-931-3269N/A3731 BASELINE ROADScottsdaleAZ85204GRP-1873CHOICE-PLUS-PPO
ENRENR-1007102026-06-01T04:20:42Z·CherylXSanchez1974-11-14UHC-46229-99UNKNOWN(811) 665-9842cheryl.sanchez@icloud.com3765 UNION STREETAustinTX78773GRP-9003SELECT-EPO
ENRENR-1278952026-08-06T21:55:40ZSAM—BURTON19721211UHC-10215-25null8786846900samantha.burton59@aol.com363 Hillcrest RoadScottsdaleAZ85248GRP-9196CHOICE-PLUS-PPO
ENRENR-1099182026-04-03T03:48:09ZThomasDMendoza1964-11-16UHC-87035-55•••-••-2031910-390-1758THOMAS.MENDOZA@YAHOO.COM1647 Canyon Rd··Scottsdale·AZ85289-8619GRP-0616NAVIGATE-HMO
ENRENR-1329522026-09-14T23:33:25Z·StephanieKRamos···1977-02-18UHC-12597-01•••-••-7731(865) 438-6594STEPHANIE.RAMOS81@AOL.COM282 Highland AvenueTampaFL33605GRP-4145NAVIGATE-HMO
ENRENR-1376292026-06-23T16:43:45ZVincent·OOwens1940-03-06UHC-82525-96··•••-••-42983325679622vincent.owens40@icloud.com7679 Church StJacksonvilleFL32222-2878GRP-6301CHOICE-PLUS-PPO
ENRENR-1199532026-05-10T07:13:02ZANTHONYUHAYES·1946-09-03UHC-47136-42•••-••-51739296420529·anthony.hayes84@yahoo.com1648 Baseline RdHOUSTONTexas77003GRP-9232NAVIGATE-HMO
ENRENR-1329892026-01-29T12:27:32ZDEBRA····MCDONALD1944-07-04UHC-72600-80•••-••-4437(785) 890-2135debra.mcdonald@yahoo.com7805 BroadwaySeattle·WA98131GRP-6484SELECT-EPO
ENRENR-1171432026-04-13T11:30:23ZJanet····Nguyen2003-05-08UHC-71088-80•••-••-7227N/Ajanet.nguyen31@proton.me6797 RIVER ROADMesaAZ85240GRP-0356CORE-HMO
ENRENR-1315682026-10-15T11:20:37Z fatima E—fisherJul 19, 1971UHC-13643-76•••-••-1881—fatima.fisher90@icloud.com6660 SPRING STREET·TucsonAZ85733GRP-0542MEDICARE-ADV-B
ENRENR-1201022026-07-21T20:37:28ZRALPHMPNA05/10/1993UHC-16904-99UNKNOWN470.359.8893ralph.pena@gmail.com154 CENTRAL AVEJACKSONVILLEFL32215GRP-6150CORE-HMO
ENRENR-1163152026-07-06T04:33:25ZBryanO·Reed2001-02-22UHC-60152-12•••-••-1823+1 740 359 3971BRYAN.REED@PROTON.ME4229 Pine DrTempe··AZ85218GRP-8438OPTIONS-PPO
ENRENR-1160072026-08-15T17:02:44ZNicholasE.Carter12/16/2006UHC-96506-93•••-••-7702·640-693-7648·nicholas.carter81@gmail.com2576 SUNSET BOULEVARDGlendaleAZ85359GRP-8466··MEDICARE-ADV-A
ENRENR-1271142026-01-26T01:19:56ZALEXISRGILBERT1999-09-26UHC-90693-78•••-••-2394957-597-2892NULL103 Park PlNashvilleTennessee37265GRP-2810MEDICARE-ADV-A
ENRENR-1211132026-04-21T22:46:33ZCHRISTIAN—EDWARDS03/19/1977UHC-82513-35•••-••-8878445-857-7107christian.edwards@gmail.com5119 MAPLE AVEPLANOTX—GRP-9815CORE-HMO
ENRENR-1377082026-02-17T09:56:54ZAustin—Jimenez1950-01-04UHC-70071-49•••-••-2938—N/A1333 Broadway #133··CharlotteNC·28230GRP-1737··CORE-HMO
ENRENR-1009282026-09-01T09:50:16ZCHARLOTTE—BRYANT1993-09-22··UHC-51096-97•••-••-5259·8588200512—4266 Union StreetDenverColorado80230GRP-6908·MEDICARE-ADV-B
ENRENR-1336372026-08-30T23:25:07Z·KIMBERLY—BELL02/18/38UHC-35960-58•••-••-2678578-701-9905kimberly.bell85@icloud.com9241 Elm StMESAArizona85270GRP-7106CHOICE-PLUS-PPO
ENRENR-1376492026-01-30T04:58:51Zkathryn—carlson1939-12-07·UHC-76593-95•••-••-0884·554-808-3216kathryn.carlson@aol.com3619 Highland AveMesaAZ85231GRP-9965CORE-HMO
ENRENR-1157662026-04-24T05:51:57Z Jesse—Contreras12/20/1998UHC2660440•••-••-3357(416) 375-0386JESSE.CONTRERAS@OUTLOOK.COM1322 Mountain View DrColumbusOhio—GRP-3770MEDICARE-ADV-B
ENRENR-1159132026-10-10T14:54:20ZGregTMoreno19910206UHC-44248-84-+1 210 369 2644—·2887 Apache BlvdFresnoCalifornia93727GRP-3351SELECT-EPO
ENRENR-1054312026-03-20T03:30:53ZPAUL—CRAWFORD1973-04-11UHC-49265-38•••-••-00975445585990PAUL.CRAWFORD52@HOTMAIL.COM··6341 GRAND AVETampaFL33672-8649GRP-4452SELECT-EPO
ENRENR-1402942026-09-18T22:36:56ZSharon··VBll20060720UHC-77136-29•••-••-20472289194915sharon.bell@icloud.com6511 Sage CourtHoustonTX77018GRP-3613CORE-HMO
ENRENR-1062622026-01-12T08:13:09ZPAMELAURYCHARDSON1941-03-21UHC-65975-52•••-••-5108763.379.1900PAMELA.RICHARDSON@AOL.COM7954 SPRING STREETLas VegasNV·89173-0780GRP-9517··CHOICE-PLUS-PPO
ENRENR-1277172026-08-02T02:23:52ZMichelleL.·Powell11/26/66··UHC-01700-56··•••-••-6771884-679-1047MICHELLE.POWELL@GMAIL.COM7546 Ocean AveChandlerAZ85269GRP-2088NAVIGATE-HMO
ENRENR-1043752026-06-15T23:42:01ZJULIEM.STEPHENS1945-12-10uhc-77192-02•••-••-3697619.458.1058julie.stephens50@gmail.com9198 Camelback RdAtlantaGA30331-2935GRP-2160CORE-HMO
ENRENR-1008952026-09-03T08:48:51ZCamilaS.McCoy1944-02-20·UHC-14938-40•••-••-5855(567) 678-9989··camila.mccoy71@outlook.com5624 Ridge RdCharlotteNCN/AGRP-2715··OPTIONS-PPO
ENR ENR-1360932026-07-07T21:49:45ZASHLEY—PIERCE19560323UHC-16682-09•••-••-4554355-511-1179ASHLEY.PIERCE@OUTLOOK.COM4004 Jefferson AvenueDenverCO80204-5468GRP-3235NAVIGATE-HMO
ENRENR-1015532026-01-16T10:27:17Z BILLY—ESPINOZA1974-07-07UHC2018424··•••-••-1692nullbilly.espinoza@proton.me7555 River RdSan DiegoCAN/AGRP-4888OPTIONS-PPO
ENRENR-1118662026-07-01T23:44:02Z BOBBYJ·GRAY19981227UHC-31950-26•••-••-2472+1 591 783 6723BOBBY.GRAY@GMAIL.COM··5084 MARKET STTampaFL33607GRP-5988OPTIONS-PPO
ENRENR-1001912026-02-21T22:54:25ZKayla—Rodriguez11/15/1983UHC-42876-24•••-••-7099689-798-0668—5184 Valley View DrTucsonAZ85780GRP-1577·SELECT-EPO
ENRENR-1197622026-02-10T21:31:37ZARTHURW··HARVEY1977-03-14UHC-78370-21•••-••-55509046983922·ARTHUR.HARVEY20@GMAIL.COM5334 Elm StSeattleWA·98104GRP-1623NAVIGATE-HMO
ENRENR-1075462026-08-09T18:04:17ZMargaret—Bryant1965-09-06UHC-79598-73•••-••-64202794077712NULL1180 Union StHoustonTX77099GRP-7998CHOICE-PLUS-PPO
ENRENR-1399202026-07-29T21:10:30ZAlexander E—Johnston-UHC-11573-97•••-••-5919556-608-3016ALEXANDER.JOHNSTON29@GMAIL.COM4124 Sunset BlvdEden PrairieMN55367GRP-9302MEDICARE-ADV-A
ENRENR-1231842026-03-24T20:50:57ZDylan···N.MeyerMay 5, 1984NULL··null9836406382dylan.meyer@outlook.com6395 PARK PL Apt 2SCOTTSDALEAZ85238GRP-6795·NAVIGATE-HMO
ENRENR-1247782026-06-19T03:21:07Z·ROBERTCDEAN1949-03-03UHC-93553-41•••-••-7792819-563-8371ROBERT.DEAN46@OUTLOOK.COM8653 Elm StreetChandlerAZ85280GRP-7525options-ppo
ENRENR-100042 2026-08-23T20:22:43Z·omarFwilliams1994-03-17UHC-48669-35NULL757-783-8343·OMAR.WILLIAMS@GMAIL.COM·6733 Grand AveMiamiFlorida··33178GRP-1554NAVIGATE-HMO
ENRENR-1154042026-06-25T18:29:20ZMATEOAKING02/19/1951UHC-58436-86-612.318.8216mateo.king50@gmail.com4459 HILLCREST ROADTempeAZ85203GRP-6521CHOICE-PLUS-PPO
ENRENR-1302742026-07-04T22:09:38ZChristinaG.·Mills1988-03-10UHC-90641-03•••-••-2163+1 697 907 2831christina.mills@aol.com8171 Ridge RoadPlanotx75059-2175GRP-5385CHOICE-PLUS-PPO
ENRENR-1001042026-06-05T03:26:08ZParker, DorisN—1951-01-12UHC-94546-30•••-••-0374748-869-6262·DORIS.PARKER@GMAIL.COM722 CHURCH STSan DiegoCA92110GRP-5489OPTIONS-PPO
ENR ENR-1218692026-03-22T15:38:47ZLarry—Garza06/15/1975UHC-05817-30•••-••-8583294-822-8165larry.garza@gmail.com3322 LINCOLN WAY·Las VegasNV89127GRP-6832NAVIGATE-HMO
ENRENR-1019412026-06-30T20:34:24ZSOFFIA J—CHEN1996-09-25UHC-18452-22•••-••-6150455-741-9514sofia.chen@outlook.com7943 WASHINGTON STPHOENIXAZ85006GRP-9444SELECT-EPO
ENRENR-1051742026-03-28T14:23:13ZJUSTINTHENDERSON1951-02-02UHC-59329-67•••-••-5196(925) 934-6998·JUSTIN.HENDERSON@AOL.COM1674 Ocean AveScottsdale·AZ85225GRP-3008OPTIONS-PPO
ENRENR-1404762026-07-06T00:33:13ZKyle—Hunt7/3/1959UHC-14233-10•••-••-2322+1 203 357 4048—9635 HIGHLAND AVENUEDenverCO80254··GRP-4954SELECT-EPO
ENRENR-1037872026-06-19T00:25:27Z·Fatima—Burke2001-06-21UHC-77085-97•••-••-89524777882967fatima.burke98@yahoo.com419 HILLCREST RDFresnoCA93799GRP-5961NAVIGATE-HMO
ENRENR-1076322026-02-08T19:41:30ZStevenKRoss19830415UHC-35235-48•••-••-6185741-486-4168UNKNOWN2627 Bayshore Dr·AtlantaGeorgia30390GRP-3842SELECT-EPO
ENRENR-1398332026-04-22T00:23:13ZMargaret—Fowler12/03/59UHC-04517-23•••-••-3412(543) 555-1132margaret.fowler7@icloud.com3661 Main StAustinTX78721GRP-4051OPTIONS-PPO
ENRENR-1352002026-06-05T10:25:32Z·deborah—martin1956-07-01UHC-52139-04•••-••-002715992625532deborah.martin68@outlook.com8438 Ridge RoadHOUSTON··TX77077GRP-5129SELECT-EPO
43,101 rows, page 210 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.351Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty