house_polls

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

2 rows where methodology = "Mail"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ question_id poll_id cycle state pollster_id pollster sponsor_ids sponsors display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology office_type seat_number seat_name start_date end_date election_date sponsor_candidate internal partisan tracking nationwide_batch ranked_choice_reallocated created_at notes url stage race_id answer candidate_id candidate_name candidate_party pct
348 348 132855 70992 2020 Montana 1472 Montana State University     Montana State University Bozeman 486 Montana State University   1615 lv lv Mail U.S. House 1 District 1 9/14/20 10/2/20 11/3/20   0     0 0 10/14/20 11:32   https://helpslab.montana.edu/documents/treasure_state_2020_election_surveys/House_Overview_Final_11Oct2020.pdf general 8067 Williams 14519 Kathleen Williams DEM 46.0
349 349 132855 70992 2020 Montana 1472 Montana State University     Montana State University Bozeman 486 Montana State University   1615 lv lv Mail U.S. House 1 District 1 9/14/20 10/2/20 11/3/20   0     0 0 10/14/20 11:32   https://helpslab.montana.edu/documents/treasure_state_2020_election_surveys/House_Overview_Final_11Oct2020.pdf general 8067 Rosendale 14520 Matt Rosendale REP 48.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "house_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "cycle" INTEGER,
  "state" TEXT,
  "pollster_id" INTEGER,
  "pollster" TEXT,
  "sponsor_ids" TEXT,
  "sponsors" TEXT,
  "display_name" TEXT,
  "pollster_rating_id" INTEGER,
  "pollster_rating_name" TEXT,
  "fte_grade" TEXT,
  "sample_size" INTEGER,
  "population" TEXT,
  "population_full" TEXT,
  "methodology" TEXT,
  "office_type" TEXT,
  "seat_number" INTEGER,
  "seat_name" TEXT,
  "start_date" TEXT,
  "end_date" TEXT,
  "election_date" TEXT,
  "sponsor_candidate" TEXT,
  "internal" INTEGER,
  "partisan" TEXT,
  "tracking" INTEGER,
  "nationwide_batch" INTEGER,
  "ranked_choice_reallocated" INTEGER,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "stage" TEXT,
  "race_id" INTEGER,
  "answer" TEXT,
  "candidate_id" INTEGER,
  "candidate_name" TEXT,
  "candidate_party" TEXT,
  "pct" REAL
);