president_approval_polls

Table actions

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

3 rows where no = "45.0" and source = "538 | Huffpost"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at, yes

Link rowid ▼ question_id poll_id state politician_id politician pollster_id pollster sponsor_ids sponsors display_name pollster_rating_id pollster_rating_name fte_grade sample_size population population_full methodology start_date end_date sponsor_candidate tracking created_at notes url source yes no
9993 9993 77257 49245   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/23/17 1/25/17   1 2/6/17 17:42   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 46.0 45.0
10002 10002 77248 49236   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/22/17 1/24/17   1 2/6/17 17:40   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 46.0 45.0
10009 10009 77265 49253   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/20/17 1/22/17   1 2/6/17 17:42   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 45.0 45.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "president_approval_polls" (
"question_id" INTEGER,
  "poll_id" INTEGER,
  "state" INTEGER,
  "politician_id" INTEGER,
  "politician" 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,
  "start_date" TEXT,
  "end_date" TEXT,
  "sponsor_candidate" INTEGER,
  "tracking" TEXT,
  "created_at" TEXT,
  "notes" TEXT,
  "url" TEXT,
  "source" TEXT,
  "yes" REAL,
  "no" REAL
);