Voter Analysis 2008-2018 by US Government | Finance and Economics

About this Dataset

Voter Analysis 2008-2018

This dataset was used to conduct the NYC Campaign Finance Board's voter participation research, published in the 2019-2020 Voter Analysis Report. Each row contains information about an active voter in 2018 and their voting history dating back to 2008, along with geographical information from their place of residence for each year they were registered voters.
Because this dataset contains only active voters in the year 2018, this dataset cannot be used to calculate election turnout.
Organization: City of New York
Last updated: 2020-11-10T17:04:37.811182
Tags: campaign-finance-board, cfb, elections, nyccfb, politics, voting

Tables

Table 1

@usgov.city_of_new_york_voter_analysis_2008_2018.table_1

452.89 MB
4663752 rows
175 columns


CREATE TABLE table_1 (
  "random_id" BIGINT,
  "age" DOUBLE,
  "registrationyear" DOUBLE,
  "politicalparty_08" VARCHAR,
  "electiondistrict_08" DOUBLE,
  "assemblydistrict_08" DOUBLE,
  "congressdistrict_08" DOUBLE,
  "councildistrict_08" DOUBLE,
  "senatedistrict_08" DOUBLE,
  "civilcourtdistrict_08" DOUBLE,
  "borocode_08" DOUBLE,
  "communitydistrict_08" DOUBLE,
  "ct2000_08" DOUBLE,
  "nta_08" VARCHAR,
  "politicalparty_09" VARCHAR,
  "electiondistrict_09" DOUBLE,
  "assemblydistrict_09" DOUBLE,
  "congressdistrict_09" DOUBLE,
  "councildistrict_09" DOUBLE,
  "senatedistrict_09" DOUBLE,
  "civilcourtdistrict_09" DOUBLE,
  "borocode_09" DOUBLE,
  "communitydistrict_09" DOUBLE,
  "ct2000_09" DOUBLE,
  "nta_09" VARCHAR,
  "politicalparty_10" VARCHAR,
  "electiondistrict_10" DOUBLE,
  "assemblydistrict_10" DOUBLE,
  "congressdistrict_10" DOUBLE,
  "councildistrict_10" DOUBLE,
  "senatedistrict_10" DOUBLE,
  "civilcourtdistrict_10" DOUBLE,
  "borocode_10" DOUBLE,
  "communitydistrict_10" DOUBLE,
  "ct2010_10" DOUBLE,
  "nta_10" VARCHAR,
  "politicalparty_11" VARCHAR,
  "electiondistrict_11" DOUBLE,
  "assemblydistrict_11" DOUBLE,
  "congressdistrict_11" DOUBLE,
  "councildistrict_11" DOUBLE,
  "senatedistrict_11" DOUBLE,
  "civilcourtdistrict_11" DOUBLE,
  "borocode_11" DOUBLE,
  "communitydistrict_11" DOUBLE,
  "ct2010_11" DOUBLE,
  "nta_11" VARCHAR,
  "politicalparty_12" VARCHAR,
  "electiondistrict_12" DOUBLE,
  "assemblydistrict_12" DOUBLE,
  "congressdistrict_12" DOUBLE,
  "councildistrict_12" DOUBLE,
  "senatedistrict_12" DOUBLE,
  "civilcourtdistrict_12" DOUBLE,
  "borocode_12" DOUBLE,
  "communitydistrict_12" DOUBLE,
  "ct2010_12" DOUBLE,
  "nta_12" VARCHAR,
  "politicalparty_13" VARCHAR,
  "electiondistrict_13" DOUBLE,
  "assemblydistrict_13" DOUBLE,
  "congressdistrict_13" DOUBLE,
  "councildistrict_13" DOUBLE,
  "senatedistrict_13" DOUBLE,
  "civilcourtdistrict_13" DOUBLE,
  "borocode_13" DOUBLE,
  "communitydistrict_13" DOUBLE,
  "ct2010_13" DOUBLE,
  "nta_13" VARCHAR,
  "politicalparty_14" VARCHAR,
  "electiondistrict_14" DOUBLE,
  "assemblydistrict_14" DOUBLE,
  "congressdistrict_14" DOUBLE,
  "councildistrict_14" DOUBLE,
  "senatedistrict_14" DOUBLE,
  "civilcourtdistrict_14" DOUBLE,
  "borocode_14" DOUBLE,
  "communitydistrict_14" DOUBLE,
  "ct2010_14" DOUBLE,
  "nta_14" VARCHAR,
  "politicalparty_15" VARCHAR,
  "electiondistrict_15" DOUBLE,
  "assemblydistrict_15" DOUBLE,
  "congressdistrict_15" DOUBLE,
  "councildistrict_15" DOUBLE,
  "senatedistrict_15" DOUBLE,
  "civilcourtdistrict_15" DOUBLE,
  "borocode_15" DOUBLE,
  "communitydistrict_15" DOUBLE,
  "ct2010_15" DOUBLE,
  "nta_15" VARCHAR,
  "politicalparty_16" VARCHAR,
  "electiondistrict_16" DOUBLE,
  "assemblydistrict_16" DOUBLE,
  "congressdistrict_16" DOUBLE,
  "councildistrict_16" DOUBLE,
  "senatedistrict_16" DOUBLE,
  "civilcourtdistrict_16" DOUBLE,
  "borocode_16" DOUBLE,
  "communitydistrict_16" DOUBLE
);