About this Dataset

Allegheny County Election Results

Official, certified results of primary, general, and special elections held in Allegheny County. (Note that the most recent results may not yet be certified. Please check the link at https://www.alleghenycounty.us/elections/election-results.aspx to determine whether the results have been certified.)
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:58:45.803703
Tags: _etl, election, government, politics, voter, voting

Tables

Special Election For 35th Legislative District

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.special_election_for_35th_legislative_district

10.54 kB
3 rows
13 columns

CREATE TABLE special_election_for_35th_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 37th Senatorial District

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.special_election_for_37th_senatorial_district

10.45 kB
3 rows
13 columns

CREATE TABLE special_election_for_37th_senatorial_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 The 19th And 24th Legislative District

@usgov.allegheny_county_city_of_pitts_allegheny_county_electi_e5ce3c3e.special_election_for_the_19th_and_24th_legislative_district

10.69 kB
5 rows
13 columns

CREATE TABLE special_election_for_the_19th_and_24th_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
);