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

All sources, ordered by line number

AllENRCLMTPAPRV
SourceRecordReceivedFirstMiddleLastDOBMember IDSSNPhoneEmailAddressCityStateZIPGroupPlan
ENRENR-1145992026-02-01T03:30:59ZKimberlyE··Duncan1999-07-10UHC-38947-74—6392871607kimberly.duncan@gmail.com5867 Forest AvenueColumbusOH43229GRP-8153CHOICE-PLUS-PPO
ENRENR-1429272026-08-01T02:37:47ZAustinO··Lopez·1977-09-24UHC-10967-15•••-••-888316377194829AUSTIN.LOPEZ@HOTMAIL.COM5139 Ocean Avenue Apt 30CharlotteNorth Carolina28215GRP-8238NAVIGATE-HMO··
ENR ENR-1252062026-05-11T12:55:20Z DorisDMunoz1997-04-16UHC-02192-57•••-••-74526333091902DORIS.MUNOZ@PROTON.ME·7162 Pine Drive·PhoenixAZ85059-6566GRP-5192MEDICARE-ADV-A··
ENRENR-1055082026-01-31T22:08:56ZJoseph—Gray1954-08-06UHC4256449•••-••-1355(344) 425-9461—907 Cedar LanePhoenix·AZ85044GRP-4566MEDICARE-ADV-A
PRVPRV-237702026-09-18T12:21:21ZAna—Rose1948-12-04UNKNOWN·NULL(987) 572-4445ana.rose@hotmail.com21 Cedar Ln #835ColumbusOH43286—-
PRVPRV-282862026-01-14T17:30:05ZJasonRMorgan2006-04-10UHC-31457-91•••-••-5109(504) 271-8566··null2752 Hillcrest RoadTampaFL33699null-··
ENRENR-1423052026-06-04T20:31:06ZCarolyn—Peters05/22/74UHC-78937-82nullN/Acarolyn.peters@yahoo.com8643 Harbor BoulevardOrlandoFL32808GRP-0569MEDICARE-ADV-B
CLM CLM-4084792026-10-04T19:36:24ZMaldonado, Sharon——1972-08-13UHC-56381-23N/AN/Asharon.maldonado@hotmail.com3759 Maple AvenueMESAAZ85281GRP-4100—
CLMCLM-4151872026-08-02T23:00:15ZGabrielH··Taylor1973-05-24UHC-69788-78-(207) 286-1977null916 APACHE BOULEVARDEDEN PRAIRIEMN·55345GRP-0292N/A
CLM CLM-4153862026-06-15T18:02:10Zsara—wlech1959-09-27UHC-01909-90null961.336.3370—8470 Pine DrMiamiFLN/A-medicare-adv-b
ENRENR-1215512026-06-20T04:27:16ZJeremy·OBishop21-03-1971·UHC-33995-12•••-••-3552396-804-2203··jeremy.bishop41@yahoo.com7906 LAKE VIEW RDMinneapolisMN55450GRP-3837CHOICE-PLUS-PPO
ENRENR-1133522026-03-31T15:46:38Z·Little, AndrewP··1972-07-06UHC-11547-97—(390) 353-1535andrew.little67@outlook.com3646 Sunset BoulevardTempeAZ85217GRP-8461MEDICARE-ADV-A
ENRENR-1380782026-01-09T18:22:35ZMarcXWalsh1997-07-05··UHC-37839-21•••-••-3687987-841-5044marcus.walsh4@yahoo.comUNKNOWN··NULL——GRP-8411medicare-adv-a
PRVPRV-248492026-01-20T21:21:37ZCHRISTIAN—WHEELER05-12-1961UHC-52926-58•••-••-1132(317) 927-4242CHRISTIAN.WHEELER@PROTON.ME1245 CEDAR LANESeattleWA98100N/ANULL
ENRENR-1281192026-02-22T10:31:59ZJACK—PETERSON1948-07-06UHC-88562-34··•••-••-2769811.439.4732··JACK.PETERSON@HOTMAIL.COM1460 Elm Street #339GilbertAZ85208GRP-1242MEDICARE-ADV-A··
CLMCLM-4090362026-06-01T23:05:35ZJoyceH··Patterson1973-07-17—•••-••-7517-—4507 HIGHLAND AVENUE·San AntonioTX78278null-
PRVPRV-205082026-07-14T02:20:27ZChristina—Sandoval19831228··UHC-51663-15—(671) 380-7910NULL—-N/A··—N/A—
ENRENR-1413842026-07-25T02:42:30Zedward—ryan1992-04-10UHC-83967-47•••-••-740417876292718—5825 Bayshore DrJacksonvilleFL-·GRP-9745OPTIONS-PPO
ENRENR-1255452026-05-12T00:59:54ZJerryFLane1949-10-23UHC-21466-99•••-••-7653276-581-6804jerry.lane@yahoo.com2060 Ocean AveOrlando·FL·32820GRP-7532NAVIGATE-HMO
CLMCLM-407184 2026-09-19T22:00:41ZhelenN·kelley1996-05-12UHC-08411-81•••-••-9739—NULL9444 VALLEY VIEW DR·COLUMBUSOH43248GRP-8653-
CLMCLM-4000932026-01-19T00:36:05ZChristian—Contreras26-07-1983null—961.251.6939christian.contreras84@hotmail.com5376 DESERT SKY BOULEVARDMiamiFL33172·GRP-8330UNKNOWN
ENRENR-1347692026-09-28T13:34:52ZJoyce—Soto12/01/1946UHC-33573-25•••-••-08293538403056··JOYCE.SOTO29@GMAIL.COM9290 River Rd #790CHARLOTTENC·28262GRP-9952MEDICARE-ADV-B
CLMCLM-411635 2026-04-24T12:27:50ZOLIVIA····VASQUEZ···1942-03-27-N/A-N/A1875 MAPLE AVEJacksonvilleFL32297GRP-9330-
ENRENR-1282192026-07-30T20:46:07ZBilly—Williams1950-04-07UHC0391592··•••-••-1073251-501-0182····6354 Baseline RdHoustonTexas77045GRP-9531OPTIONS-PPO
CLMCLM-4287272026-04-28T01:47:01ZJulie—Simmons1983-02-16·-NULL15817213191··null1667 Canyon RoadMiamiFL33192GRP-4334null
CLMCLM-4104252026-06-11T13:24:35ZDianaGOBrien1971-09-07UHC-82105-09•••-••-3674N/AN/A5504 Indian School RdFresnoCA93792GRP-9836SELECT-EPO
TPATPA-564432026-01-23T15:23:33Z Kevin—George1941-01-17—•••-••-5836N/Akevin.george8@gmail.com1143 Jefferson AveHoustonTX·77030UNKNOWNUNKNOWN
CLMCLM-4061542026-01-20T00:55:00ZAustin—RobertsonApr 21, 1968null•••-••-4901nullaustin.robertson@proton.me8721 Palm DriveLas VegasNV89127GRP-3089—
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
CLMCLM-4081722026-10-17T15:12:20ZVirginia—Hanson12-08-1953—•••-••-5165UNKNOWNUNKNOWN2261 WILLOW COURTJacksonvilleFL—N/A-
CLMCLM-4094152026-08-10T06:16:07ZKENNNETHFSTEWATR2003-04-08··—UNKNOWN253.924.7268null333 Jefferson AvenueATLANTAGA30389N/A-··
CLMCLM-4175362026-04-03T09:47:34ZALEXIS—TRAN1938-01-26—null6349166724nullnullNULL·NULLNULLNULL··—
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
CLMCLM-4327882026-06-17T05:44:46ZbenjaminS··lane1985-01-05UHC-09486-02——null6981 CEDAR LANEMiamiFL·33114-2614·--
CLMCLM-417887 2026-07-23T20:35:09ZLucas, Paul——06/15/1946——(779) 659-7606N/A3616 CAMELBACK RDJacksonville·FL32262GRP-1550NAVIGATE-HMO
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
TPATPA-576662026-03-24T20:40:14ZBailey, Eric——1988-04-01NULLUNKNOWNUNKNOWNnull2012 MOUNTAIN VIEW DRAtlantaga30315-6292UNKNOWN-
ENRENR-1387302026-06-03T14:41:19Zsofia··M.richards1997-06-09UHC-38846-21•••-••-7932(531) 889-6083SOFIA.RICHARDS@AOL.COM7080 Market StreetTampaFL33690GRP-2377NAVIGATE-HMO
PRVPRV-244422026-04-19T20:32:13ZGrce··—Jenkins1998-10-08UNKNOWN•••-••-13886244733419N/A4259 Sage CourtTampaFL33608N/A—
ENRENR-138966 2026-06-13T20:18:00ZGloria—·Martin1989-09-15UHC-38570-43•••-••-370016596731875gloria.martin56@outlook.com6216 Canyon Road #284MiamiFL33155GRP-6616MEDICARE-ADV-B
CLMCLM-4076672026-02-15T08:26:22ZKEVINR.SOTT19770905—-—UNKNOWN4444 WILLOW COURT Apt 33NashvilleTN37251nullnull
CLMCLM-4098582026-05-28T23:58:36ZGrace—Harper12-06-1981UHC-75926-22··(798) 978-4285-6965 Sunset BoulevardMESAAZ85251··null-
CLMCLM-429403 2026-08-27T04:29:20ZJean—·Cole1968-08-07··UHC-91000-09•••-••-82504124694708—UNKNOWNN/A—NULLGRP-9987—
CLMCLM-4017272026-01-25T18:28:19Zdavid····elliott1994-06-10UHC-64957-16UNKNOWN(888) 770-4819NULL8120 SPRING STMesaArizona85201-NAVIGATE-HMO
100,000 rows, page 226 of 2,000PreviousNext

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.734Z.
··Leading or trailing whitespace, shown as middle dots
N/APlaceholder token that silver treats as empty