Election Results Data Dictionary For 2017

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.election_results_data_dictionary_for_2017

7 kB
12 rows
5 columns

CREATE TABLE election_results_data_dictionary_for_2017 (
  "field_name" VARCHAR,
  "field_description" VARCHAR,
  "example_1" VARCHAR,
  "example_2" VARCHAR,
  "additional_information" VARCHAR
);

2012 Primary Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2012_primary_election_results_by_precinct

275.7 kB
100,393 rows
11 columns

CREATE TABLE n_2012_primary_election_results_by_precinct (
  "reg_voters" BIGINT,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2012 Special Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2012_special_election_results_by_precinct

10.92 kB
900 rows
11 columns

CREATE TABLE n_2012_special_election_results_by_precinct (
  "reg_voters" BIGINT,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2012 Special Election Summary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2012_special_election_summary

7.49 kB
6 rows
10 columns

CREATE TABLE n_2012_special_election_summary (
  "votes" BIGINT,
  "prec_count" BIGINT  -- Prec. Count,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_name" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2015 General Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2015_general_election_results_by_precinct

214.22 kB
83,521 rows
11 columns

CREATE TABLE n_2015_general_election_results_by_precinct (
  "reg_voters" BIGINT,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" VARCHAR  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2015 General Election Summary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2015_general_election_summary

37.69 kB
1,047 rows
10 columns

CREATE TABLE n_2015_general_election_summary (
  "votes" BIGINT,
  "prec_count" BIGINT  -- Prec. Count,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" VARCHAR  -- Dist. Code,
  "contest_name" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2015 Primary Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2015_primary_election_results_by_precinct

333.21 kB
120,230 rows
11 columns

CREATE TABLE n_2015_primary_election_results_by_precinct (
  "reg_voters" BIGINT  -- Reg. Voters,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2015 Primary Election Summary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2015_primary_election_summary

44.89 kB
2,784 rows
10 columns

CREATE TABLE n_2015_primary_election_summary (
  "votes" BIGINT,
  "prec_count" BIGINT  -- Prec. Count,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_name" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2016 General Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2016_general_election_results_by_precinct

124.01 kB
50,820 rows
11 columns

CREATE TABLE n_2016_general_election_results_by_precinct (
  "reg_voters" BIGINT,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2016 General Election Summary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2016_general_election_summary

10.01 kB
100 rows
10 columns

CREATE TABLE n_2016_general_election_summary (
  "votes" BIGINT,
  "prec_count" BIGINT  -- Prec. Count,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" DOUBLE  -- Dist. Code,
  "contest_name" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2016 Primary Election Results By Precinct

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2016_primary_election_results_by_precinct

269.62 kB
113,528 rows
11 columns

CREATE TABLE n_2016_primary_election_results_by_precinct (
  "reg_voters" BIGINT,
  "votes" BIGINT,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" VARCHAR  -- Dist. Code,
  "contest_title" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "precinct_name" VARCHAR,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2016 Primary Election Summary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2016_primary_election_summary

21.37 kB
779 rows
10 columns

CREATE TABLE n_2016_primary_election_summary (
  "votes" BIGINT,
  "prec_count" BIGINT  -- Prec. Count,
  "party" VARCHAR,
  "dist_type" VARCHAR  -- Dist. Type,
  "dist_code" VARCHAR  -- Dist. Code,
  "contest_name" VARCHAR,
  "cand_num" BIGINT  -- Cand. Num,
  "cand_name" VARCHAR  -- Cand. Name,
  "vote_for" BIGINT,
  "ref" VARCHAR
);

2017 General Election Results

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2017_general_election_results

124.52 kB
3,110 rows
13 columns

CREATE TABLE n_2017_general_election_results (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2018 General

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2018_general

14.94 kB
104 rows
13 columns

CREATE TABLE n_2018_general (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2018 Primary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2018_primary

130.56 kB
3,923 rows
13 columns

CREATE TABLE n_2018_primary (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2019 General

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2019_general

62.73 kB
1,291 rows
13 columns

CREATE TABLE n_2019_general (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2019 Primary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2019_primary

76.34 kB
1,991 rows
13 columns

CREATE TABLE n_2019_primary (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2020 General

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2020_general

14.61 kB
96 rows
13 columns

CREATE TABLE n_2020_general (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2020 Primary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2020_primary

91.61 kB
3,139 rows
13 columns

CREATE TABLE n_2020_primary (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2021 General

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2021_general

160.41 kB
5,195 rows
13 columns

CREATE TABLE n_2021_general (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2021 Primary

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2021_primary

244.39 kB
8,945 rows
13 columns

CREATE TABLE n_2021_primary (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2022 General Election

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2022_general_election

15.09 kB
98 rows
13 columns

CREATE TABLE n_2022_general_election (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

2022 Primary Election

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.n_2022_primary_election

208.59 kB
7,353 rows
13 columns

CREATE TABLE n_2022_primary_election (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

Special Election - 32nd Legislative District

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.special_election_32nd_legislative_district

10.56 kB
3 rows
13 columns

CREATE TABLE special_election_32nd_legislative_district (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

Special Election For 18th Congressional District

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.special_election_for_18th_congressional_district

10.48 kB
4 rows
13 columns

CREATE TABLE special_election_for_18th_congressional_district (
  "n__id" BIGINT  -- Id,
  "line_number" BIGINT,
  "contest_name" VARCHAR,
  "choice_name" VARCHAR,
  "party_name" VARCHAR,
  "total_votes" BIGINT,
  "percent_of_votes" DOUBLE,
  "registered_voters" BIGINT,
  "ballots_cast" BIGINT,
  "total_number_of_precincts" BIGINT,
  "number_of_precincts_reporting" BIGINT,
  "over_votes" BIGINT,
  "under_votes" BIGINT
);

Allegheny County Election Results

About this Dataset