house_polls

Table actions

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

2 rows where candidate_party = "REF" and partisan = "DEM"

✎ 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
1212 1212 90918 56516 2018 New York 495 Tulchin Research     Tulchin Research 340 Tulchin Research B/C 400 lv lv Live Phone U.S. House 27 District 27 10/25/18 10/28/18 11/6/18 Nate McMurray 1 DEM   0 0 10/29/18 14:51   https://votemcmurray.com/wp-content/uploads/2018/10/Tulchin-Research-Memo-NY-27-Poll-Findings-10-29-18.pdf general 464 Piegza 13192 Larry Piegza REF 4.0
1633 1633 90144 56156 2018 New York 495 Tulchin Research     Tulchin Research 340 Tulchin Research B/C 400 lv lv Live Phone U.S. House 27 District 27 10/6/18 10/8/18 11/6/18 Nate McMurray 1 DEM   0 0 10/11/18 11:01   https://drive.google.com/file/d/1ukNQQfRg7u0YMq8eQ6ZVug250DmqHrKs/view general 464 Piegza 13192 Larry Piegza REF 6.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
);