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
|
|---|
| District | Pop 18yo and older | Dem Reg Marg |
|---|
| Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00% | |
Source: NJ State Voter Registrations By Legislative District
Export to Excel