generic_ballot_polls

Table actions

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

3 rows where fte_grade = "C"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: poll_id, population, population_full, start_date, end_date, url, dem, rep

Link rowid ▼ question_id poll_id race_id cycle state pollster_id pollster sponsor_ids sponsors partisan display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology office_type seat_number start_date end_date sponsor_candidate tracking nationwide_batch created_at notes url stage dem rep ind
37 37 135329 72160 8274 2020   1361 SSRS 143 CNN   CNN/SSRS 297 SSRS C 917 rv rv Live Phone U.S. House   10/23/20 10/26/20     0 10/28/20 16:21   http://cdn.cnn.com/cnn/2020/images/10/28/rel15.pdf general 54.0 42.0  
38 38 135330 72160 8274 2020   1361 SSRS 143 CNN   CNN/SSRS 297 SSRS C 886 lv lv Live Phone U.S. House   10/23/20 10/26/20     0 10/28/20 16:22   http://cdn.cnn.com/cnn/2020/images/10/28/rel15.pdf general 54.0 42.0  
463 463 119752 64751 8274 2020   1361 SSRS 143 CNN   CNN/SSRS 297 SSRS C 1084 rv rv Live Phone U.S. House   3/4/20 3/7/20     0 3/9/20 07:15   https://cdn.cnn.com/cnn/2020/images/03/09/rel2a.-.2020.pdf general 53.0 44.0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "generic_ballot_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "race_id" INTEGER,
  "cycle" INTEGER,
  "state" INTEGER,
  "pollster_id" INTEGER,
  "pollster" TEXT,
  "sponsor_ids" TEXT,
  "sponsors" TEXT,
  "partisan" 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,
  "start_date" TEXT,
  "end_date" TEXT,
  "sponsor_candidate" INTEGER,
  "tracking" TEXT,
  "nationwide_batch" INTEGER,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "stage" TEXT,
  "dem" REAL,
  "rep" REAL,
  "ind" INTEGER
);