The two census results tables have state_legislative_district_upper_chamber and state_legislative_district_lower_chamber fields that can be used to join with the districts.name field, along with the year and state fields.
We should probably extract the district number from the name to be easier to join tables.
The two census results tables have
state_legislative_district_upper_chamberandstate_legislative_district_lower_chamberfields that can be used to join with thedistricts.namefield, along with the year and state fields.We should probably extract the district number from the name to be easier to join tables.