president_approval_polls

Table actions

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

4 rows where pollster = "Pew Research Center" and source = "538 | Huffpost"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: sample_size, methodology, no

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
7250 7250 80266 50812   11 Donald Trump 370 Pew Research Center     Pew Research Center 253 Pew Research Center B/C 1503 a a Live Phone 1/10/18 1/15/18     1/18/18 15:59   http://assets.pewresearch.org/wp-content/uploads/sites/5/2018/01/18151440/1-18-2018-Political-report-topline-for-release-FOR-STITCH.pdf 538 | Huffpost 37.0 56.0
7542 7542 79926 50643   11 Donald Trump 370 Pew Research Center     Pew Research Center 253 Pew Research Center B/C 1503 a a Live Phone 11/29/17 12/4/17     12/7/17 16:19   http://www.people-press.org/2017/12/07/stark-partisan-divisions-over-russia-probe-including-its-importance-to-the-nation/ 538 | Huffpost 32.0 63.0
8853 8853 78361 49871   11 Donald Trump 370 Pew Research Center     Pew Research Center 253 Pew Research Center B/C 2504 a a   6/8/17 6/18/17     6/20/17 12:20   http://www.people-press.org/2017/06/20/presidential-approval-detailed-tables-june-2017/?utm_source=adaptivemailer&utm_medium=email&utm_campaign=17-06-20%20political%20parties&org=982&lvl=100&ite=1304&lea=280118&ctr=0&par=1&trk= 538 | Huffpost 39.0 55.0
9650 9650 77810 49560   11 Donald Trump 370 Pew Research Center     Pew Research Center 253 Pew Research Center B/C 3844 a a Live Phone / Online 2/28/17 3/12/17     3/31/17 12:28   http://assets.pewresearch.org/wp-content/uploads/sites/12/2017/03/30145922/Mode-Study-3-31-2017-TOPLINE.pdf 538 | Huffpost 43.0 55.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
);