select a.*, b.last_color from leg_dist_pop_regist_and_pct a join districts_info b on a.ld = substr(b.ld, 5, 2) where `year_month` not like '2018%' order by a.ld, `year_month` Blue Compass - Electoral Data Home NJ Congress

Voter Registrations By NJ Legislative District

DistrictPop 18yo and olderDem Reg Marg

Source: NJ State Voter Registrations By Legislative District

Export to Excel