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-1047702026-05-04T19:02:57Zsantiago—santosJan 22, 1948UHC-47459-35··—(950) 769-5298santiago.santos43@proton.me5772 GRAND AVENUESan AntonioTexas78282GRP-9139NAVIGATE-HMO
ENRENR-1109932026-02-21T19:33:53ZJessica—Vega··1967-09-05·uhc-52643-31•••-••-2412-—1661 INDIAN SCHOOL ROAD·AtlantaGA30390GRP-1473NAVIGATE-HMO
ENRENR-1040952026-01-01T08:50:53ZDIANAFREID··20000201UHC-48058-63•••-••-5365(855) 866-9315UNKNOWN9358 Desert Sky BlvdSACRAMENTOCA95844GRP-4525CHOICE-PLUS-PPO
ENRENR-1056382026-10-18T08:36:41ZloriT.vega2002-09-02·UHC-08440-55•••-••-4402574.422.1658lori.vega@proton.me1434 MAIN STREETPlanoTX75035GRP-1270OPTIONS-PPO
ENRENR-1400522026-01-06T01:29:26ZSara—HicksDec 23, 2001UHC-24394-15•••-••-7820474-579-5639sara.hicks54@aol.com2890 Mountain View DriveSacramentoCA95867··GRP-4697SELECT-EPO
ENRENR-1326902026-01-04T15:22:19Z Aisha—Medina2/6/1999UHC-78384-87•••-••-7406388-889-1822·AISHA.MEDINA83@ICLOUD.COM7802 OCEAN AVESan AntonioTX78270GRP-1930MEDICARE-ADV-A
ENRENR-1077502026-08-08T01:26:35ZRYAN··UFOX1980-04-19UHC-40849-31•••-••-6361594-200-4167ryan.fox92@gmail.com6203 HIGHLAND AVENUEHoustonTX77095GRP-6603MEDICARE-ADV-A
ENRENR-1137292026-10-16T19:35:56Z Hoffman, MarianaY—5/16/1965UHC-96797-91—(684) 307-2189mariana.hoffman@hotmail.com7221 Desert Sky BlvdSACRAMENTOCalifornia-GRP-0572CORE-HMO
ENRENR-1176072026-02-01T21:38:24ZAbigailOWalker8/21/1944UHC-24452-04•••-••-5331+1 868 331 7783abigail.walker39@aol.com9062 RIDGE ROAD Apt 36SACRAMENTOCANULLGRP-8031NAVIGATE-HMO
ENRENR-1150112026-09-03T21:30:02ZRichardHLynch2005-03-03UHC-50805-92•••-••-0460564-767-2549··RICHARD.LYNCH@PROTON.ME8700 Maple AveTempeAZ·85297GRP-5884SELECT-EPO
ENRENR-1366392026-03-06T07:16:11ZGregory—Nelson1958-10-28UHC-18210-17•••-••-62252075677525gregory.nelson50@gmail.com5556 DESERT SKY BOULEVARDGLENDALEAZ85382-2551GRP-0508··MEDICARE-ADV-A
ENR ENR-1005472026-02-23T01:59:16ZKYLEH··ESPINOZA1944-08-05UHC-87566-17•••-••-6111290-241-0663kyle.espinoza9@hotmail.com6088 Valley View DriveLos AngelesCA90054GRP-6481MEDICARE-ADV-A
ENRENR-1071652026-09-23T11:56:49ZCynthia··ETuucker11/04/1999UHC-62111-71•••-••-1893988.959.0428cynthia.tucker22@outlook.com8513 Baseline RdPlanoTX75065GRP-6695MEDICARE-ADV-B
ENRENR-1003842026-07-20T16:31:21ZDANIELLE—HANSEN2003-02-28UHC-51848-76•••-••-2710292-859-5414danielle.hansen@proton.me829 CENTRAL AVELOS ANGELESCA90070GRP-1561MEDICARE-ADV-A
ENRENR-1113802026-07-05T23:53:22ZCatherineH.Morgan2006-04-10UHC3015988UNKNOWN15718480669catherine.morgan@gmail.com6975 HILLCREST ROAD Apt 36TEMPEAZ85237GRP-5636medicare-adv-a
ENRENR-1186742026-02-12T14:38:11ZPatriciaE.Silva01/22/53UHC-60266-54•••-••-3473(282) 367-7128PATRICIA.SILVA@YAHOO.COM9668 Harbor BlvdSan AntonioTX78218GRP-1924SELECT-EPO
ENRENR-1297602026-01-22T03:30:00ZJohn—Morales02/26/66UHC-19687-64-—JOHN.MORALES48@OUTLOOK.COM·7673 Camelback RdPlanoTexas75012GRP-0163CORE-HMO
ENRENR-1429462026-08-26T00:37:09ZRalph—Bradley2004-11-14··UHC-82868-74•••-••-55938398464330RALPH.BRADLEY@OUTLOOK.COM2300 Indian School RoadLas VegasNV89102GRP-1406OPTIONS-PPO
ENRENR-1356312026-09-04T06:00:46ZJennifer·ULeeMay 11, 1984UHC-11698-23•••-••-2067241.689.2642jennifer.lee85@gmail.com2678 PALM DRIVENashvilleTennessee37256GRP-3365CHOICE-PLUS-PPO
ENRENR-1260622026-09-30T11:29:58Zbradley—adams1948-04-05UHC-67595-71•••-••-6013617.264.8283bradley.adams@icloud.com4413 Spring StDenverCO80226GRP-8521OPTIONS-PPO
ENRENR-1362562026-01-12T07:54:24ZBennett, Alexis——06/04/1968UHC-65598-14•••-••-6548—ALEXIS.BENNETT@GMAIL.COM··nullUNKNOWN—GRP-3914OPTIONS-PPO
ENRENR-1104442026-05-18T08:38:43ZJeremy····Reyes02/03/1973UHC-87372-54•••-••-4378930-513-1662JEREMY.REYES55@YAHOO.COM5668 CHURCH STTempeAZ85276GRP-2281MEDICARE-ADV-A
ENRENR-1252562026-04-16T23:02:22ZLAURAB.HUNT19541201UHC-31779-73•••-••-7199(505) 874-1492laura.hunt4@yahoo.com2200 Canyon RdTucsonAZ85759GRP-8175CORE-HMO
ENRENR-1010062026-03-28T04:26:55ZCHARLESM.BRADLEY1951-07-19UHC-01729-01N/A—-7702 Willow CtJACKSONVILLEFL32263GRP-4520SELECT-EPO
ENRENR-1315252026-08-23T21:36:56ZPHILIPDGUZAMN01/05/1996UHC-22868-86N/A779-537-3319philip.guzman73@outlook.com8571 MAIN STREETOrlandoFL32886GRP-8180OPTIONS-PPO··
ENRENR-1072992026-08-18T10:00:00ZOlivia··—Mason2005-01-07UHC-90490-25•••-••-573017237419526OLIVIA.MASON@ICLOUD.COM9078 Sunset BoulevardTucsonaz85770GRP-5526NAVIGATE-HMO
ENRENR-1009932026-05-27T05:18:11ZcarolynD.anderson1946-03-07UHC-16813-73•••-••-86805865068640carolyn.anderson@gmail.com2764 Market StPLANOtx—GRP-5698NAVIGATE-HMO
ENRENR-1119082026-02-02T06:33:44Z·Alan—Ortiz2008-07-18UHC-87483-95•••-••-8237(378) 602-4767alan.ortiz19@gmail.com·8517 Highland AvenueColumbusOH43203·GRP-1874MEDICARE-ADV-B
ENRENR-1394432026-09-13T21:58:50Z·Samuel—Greene1986-09-25UHC-20128-89•••-••-1747····—2210 MAIN STREET··CharlotteNC··28213GRP-9282MEDICARE-ADV-A
ENRENR-1166152026-06-05T05:03:23ZKELLYG·EVANS8/13/1992UHC-66766-13•••-••-3694928-668-2347kelly.evans9@gmail.com5463 Lake View RdDallas··TX75281GRP-2410CORE-HMO
ENRENR-1081452026-06-03T14:58:57ZAlanV.Sims1991-08-01UHC-89095-04•••-••-2840(204) 438-2142N/A2292 MARKET ST Apt 8PhoenixAZ85019GRP-6452OPTIONS-PPO
ENRENR-1235292026-01-07T05:58:33ZWells, ElizabethO.—1985-09-11uhc-74329-89•••-••-68954477961760ELIZABETH.WELLS67@HOTMAIL.COM8340 BASELINE ROADDALLASTX75282·GRP-4266CHOICE-PLUS-PPO
ENRENR-1091292026-06-03T09:43:20ZBRENDAXHARRISON05/28/2004UHC-33869-52•••-••-31604884832239—7514 WILLOW CTTEMPEAZ85284GRP-5598·CHOICE-PLUS-PPO
ENRENR-1039132026-09-01T16:35:53ZPaul—Fisheer10/26/1946UHC-29098-94•••-••-50086037062710PAUL.FISHER@ICLOUD.COM4494 Lake View Rd··MinneapolisMN55458GRP-5977··MEDICARE-ADV-B
ENRENR-1215072026-06-06T22:22:18ZDOROTHYOCOLLINS··1941-07-13UHC-60675-74•••-••-4867(227) 938-2681dorothy.collins@icloud.com976 Palm Dr·ChandlerArizona85217GRP-9046··MEDICARE-ADV-A
ENRENR-1384932026-09-15T00:10:34ZBradley—Dean1982-08-19UHC-57976-31•••-••-3938930-309-0691—2578 Washington St·CHARLOTTENC28222·GRP-9495MEDICARE-ADV-B
ENRENR-1345402026-07-12T19:41:20ZKyle·KFuller19600912UHC-61514-91-·+1 297 411 3366kyle.fuller45@icloud.com5677 Highland AvenueSacramento··CA95844GRP-3392CHOICE-PLUS-PPO
ENRENR-1235452026-09-22T11:37:31ZbrittanyJ.fernandez03/08/90UHC-81322-64•••-••-4036350.223.9003—6864 Willow CtSacramentoCA95898GRP-1513CORE-HMO
ENRENR-1227732026-09-29T06:02:32ZKennethZPeters1991-09-06UHC-72342-94•••-••-2128(846) 405-5697KENNETH.PETERS5@YAHOO.COM2744 Hillcrest RoadHOUSTONTexas··77004·GRP-5943MEDICARE-ADV-B
ENRENR-1246922026-02-25T15:57:30ZTYLER—VARGAS1980-01-13-•••-••-0166434-631-5874-6278 Highland AveAtlantaGA30340GRP-2525MEDICARE-ADV-A
ENRENR-1417402026-06-27T21:21:23ZAngela—Lane12/23/1993UHC-64370-63•••-••-9334276.880.3670··ANGELA.LANE79@ICLOUD.COM6857 Palm DriveJacksonvilleFL32243GRP-3774CHOICE-PLUS-PPO
ENRENR-1319512026-09-24T14:25:20ZKENNETH—·DANIELSnullUHC4703079•••-••-21873872567309null3524 Central AveOrlandoFL32837GRP-5959medicare-adv-b
ENRENR-1241792026-06-20T07:41:39Z ADAMZSCHULTZ···10/21/1953UHC-48480-59•••-••-6674-adam.schultz28@proton.me1080 Ocean AvenueGilbertAZ85225·GRP-9175CHOICE-PLUS-PPO
ENRENR-1080582026-07-20T01:57:15ZBEVERLYHCASTRO1979-07-15UHC-58154-60null334-395-0262beverly.castro@aol.com7982 Willow Ct··NASHVILLETN37256GRP-8817MEDICARE-ADV-B
ENRENR-1279922026-04-13T08:05:49ZWalter—Cook1962-06-25UHC-07206-18•••-••-3814835.367.6991walter.cook@hotmail.com4996 MEADOW LANETAMPAFL33611GRP-6295MEDICARE-ADV-B
ENRENR-1421132026-01-23T02:12:52ZWLILIAM·JJORDANFeb 22, 1990UHC-70177-71····801-368-0090william.jordan99@icloud.com1244 RIVER ROADGLENDALEArizona85329GRP-2143SELECT-EPO
ENRENR-1030252026-02-24T17:10:58ZMICHELLE—HART01/18/1968UHC2315940··•••-••-9874(295) 916-1993michelle.hart31@outlook.com96 WILLOW COURTOrlandoFL32899GRP-1843CHOICE-PLUS-PPO
ENRENR-1243842026-08-04T15:57:50ZMENDOZA—JANICE1971-10-20UHC-83314-54•••-••-5602906-290-7377N/A5387 BroadwayGlendale···AZ85350GRP-8758MEDICARE-ADV-A
ENRENR-1401972026-02-28T20:36:55ZANGELAM.BROWN19460527UHC-61297-62———5531 Grand AvenueGLENDALEArizona85321GRP-7245MEDICARE-ADV-A
ENRENR-1409062026-06-05T15:18:27ZJORDANV.MUNOZ2007-05-27UHC-45378-23•••-••-3647850-762-4030null4852 Mountain View DrMesaAZ85211GRP-5134CORE-HMO
43,101 rows, page 209 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.350Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty