home / polls

Menu
  • GraphQL API

president_approval_polls

Table actions
  • GraphQL API for president_approval_polls

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

33 rows where pollster = "Gallup" and source = "538 | Huffpost"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at, yes, 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
9771 9771 77347 49331   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/22/17 2/24/17   1 2/26/17 19:35   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 41.0 53.0
9778 9778 77335 49319   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/21/17 2/23/17   1 2/26/17 19:21   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9785 9785 77336 49320   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/20/17 2/22/17   1 2/26/17 19:21   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9796 9796 77344 49328   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/19/17 2/21/17   1 2/26/17 19:35   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 52.0
9802 9802 77328 49312   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/18/17 2/20/17   1 2/21/17 13:54   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 41.0 53.0
9811 9811 77326 49310   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/17/17 2/19/17   1 2/21/17 13:54   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 53.0
9824 9824 77315 49299   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/16/17 2/18/17   1 2/20/17 12:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 41.0 55.0
9830 9830 77317 49301   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/15/17 2/17/17   1 2/20/17 12:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 55.0
9838 9838 77313 49297   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/14/17 2/16/17   1 2/20/17 12:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 38.0 56.0
9846 9846 77319 49303   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/13/17 2/15/17   1 2/20/17 12:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 54.0
9855 9855 77314 49298   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/12/17 2/14/17   1 2/20/17 12:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 53.0
9861 9861 77297 49282   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/11/17 2/13/17   1 2/14/17 14:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 54.0
9870 9870 77294 49279   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/10/17 2/12/17   1 2/14/17 14:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 54.0
9881 9881 77300 49285   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/9/17 2/11/17   1 2/14/17 14:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 40.0 55.0
9886 9886 77298 49283   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/8/17 2/10/17   1 2/14/17 14:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 41.0 53.0
9891 9891 77304 49289   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/7/17 2/9/17   1 2/14/17 14:03   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 52.0
9898 9898 77301 49286   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/6/17 2/8/17   1 2/14/17 14:00   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9908 9908 77306 49291   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/5/17 2/7/17   1 2/14/17 14:04   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9915 9915 77288 49274   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/4/17 2/6/17   1 2/8/17 11:06   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 54.0
9924 9924 77273 49261   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/3/17 2/5/17   1 2/6/17 17:48   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 52.0
9933 9933 77277 49265   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 2/2/17 2/4/17   1 2/6/17 17:50   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 53.0
9947 9947 77245 49233   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/31/17 2/2/17   1 2/6/17 17:40   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9954 9954 77244 49232   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/30/17 2/1/17   1 2/6/17 17:40   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9960 9960 77256 49244   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/29/17 1/31/17   1 2/6/17 17:42   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 52.0
9967 9967 77279 49267   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/28/17 1/30/17   1 2/6/17 17:50   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 51.0
9974 9974 77247 49235   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/27/17 1/29/17   1 2/6/17 17:40   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 43.0 50.0
9980 9980 77263 49251   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/26/17 1/28/17   1 2/6/17 17:42   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 51.0
9984 9984 77269 49257   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/25/17 1/27/17   1 2/6/17 17:44   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 42.0 50.0
9989 9989 77254 49242   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/24/17 1/26/17   1 2/6/17 17:42   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 45.0 48.0
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
10007 10007 77274 49262   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 1/21/17 1/23/17   1 2/6/17 17:48   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx 538 | Huffpost 45.0 46.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
);
Powered by Datasette · Queries took 4760.392ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette