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

73 rows where source = "Gallup"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: sample_size, url, 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
557 557 129411 69481   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1019 a a Live Phone 8/31/20 9/13/20     9/16/20 09:45   https://news.gallup.com/poll/320303/trump-stuck-42-job-approval.aspx Gallup 42.0 56.0
772 772 127524 68071   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1031 a a Live Phone 7/30/20 8/12/20     8/17/20 08:34   https://news.gallup.com/poll/317477/trump-job-approval-below-seven-key-issues.aspx Gallup 42.0 55.0
902 902 126993 67845   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1007 a a Live Phone 7/1/20 7/23/20     7/30/20 09:02   https://news.gallup.com/poll/316448/congress-approval-drops-trump-steady.aspx Gallup 41.0 56.0
1057 1057 125131 66995   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1016 a a Live Phone 6/8/20 6/30/20     7/6/20 08:38   https://news.gallup.com/poll/313454/trump-job-approval-rating-steady-lower-level.aspx Gallup 38.0 57.0
1418 1418 123401 66293   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1028 a a Live Phone 5/1/20 5/13/20     5/15/20 14:40   https://news.gallup.com/poll/311129/congress-job-approval-highest-2009.aspx Gallup 49.0 48.0
1536 1536 122194 65954   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1016 a a Live Phone 4/14/20 4/28/20     4/30/20 12:36   https://news.gallup.com/poll/309593/americans-divided-trump-handling-covid-situation.aspx Gallup 49.0 47.0
1651 1651 121573 65765   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1017 a a Live Phone 4/1/20 4/14/20     4/16/20 13:18   https://news.gallup.com/poll/308675/trump-job-rating-slides-satisfaction-tumbles.aspx Gallup 43.0 54.0
1895 1895 120127 64869   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1019 a a Live Phone 3/2/20 3/13/20     3/17/20 17:21   https://news.gallup.com/poll/296060/trump-job-approval-rating-slips.aspx Gallup 44.0 52.0
1984 1984 119607 64704   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1020 a a Live Phone 2/17/20 2/28/20     3/3/20 17:07   https://news.gallup.com/poll/287264/trump-job-approval-rating.aspx Gallup 47.0 51.0
2172 2172 116554 63441   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1033 a a Live Phone 1/16/20 1/29/20     2/4/20 09:03   https://news.gallup.com/poll/284156/trump-job-approval-personal-best.aspx Gallup 49.0 50.0
2612 2612 113341 62671   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1015 a a Live Phone 11/1/19 11/14/19     11/20/19 09:27   https://news.gallup.com/poll/268493/trump-approval-holds-steady-face-impeachment-probe.aspx Gallup 43.0 54.0
2815 2815 104539 60097   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1526 a a Live Phone 10/1/19 10/13/19     10/16/19 07:48   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 39.0 57.0
2910 2910 103747 59794   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 2431 a a Live Phone 9/16/19 9/30/19     10/3/19 09:03   https://news.gallup.com/poll/267182/trump-job-approval-higher-approval-person.aspx Gallup 40.0 56.0
3022 3022 102976 59613   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1525 a a Live Phone 9/3/19 9/15/19     9/19/19 09:16   https://news.gallup.com/poll/266906/trump-job-approval-ties-party-polarization-record.aspx Gallup 43.0 54.0
3129 3129 102264 59497   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 2291 a a Live Phone 8/15/19 8/30/19     9/6/19 09:06   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 39.0 57.0
3243 3243 100682 58916   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1522 a a Live Phone 8/1/19 8/14/19     8/16/19 12:56   https://news.gallup.com/poll/265487/trump-latest-approval-rating-stable.aspx Gallup 41.0 54.0
3330 3330 100131 58811   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 3038 a a Live Phone 7/15/19 7/31/19     8/5/19 09:20   https://news.gallup.com/poll/262694/latest-trump-job-approval-rating.aspx Gallup 42.0 54.0
3445 3445 99465 58684   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1525 a a Live Phone 7/1/19 7/12/19     7/18/19 09:10   https://news.gallup.com/poll/260780/trump-averages-job-approval-10th-quarter.aspx Gallup 44.0 51.0
3515 3515 98940 58605   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1018 a a Live Phone 6/19/19 6/30/19     7/3/19 09:10   https://news.gallup.com/poll/259871/trump-approval-remains-low-40s.aspx Gallup 41.0 54.0
3804 3804 94518 58092   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1009 a a Live Phone 5/1/19 5/12/19     5/17/19 09:56   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 52.0
3874 3874 94346 57996   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1024 a a Live Phone 4/17/19 4/30/19     5/3/19 09:37   https://news.gallup.com/poll/249344/trump-approval-remains-high.aspx Gallup 46.0 50.0
4000 4000 94086 57876   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1012 a a Live Phone 4/1/19 4/9/19     4/12/19 09:12   https://news.gallup.com/poll/248633/post-mueller-report-trump-approval-back-high.aspx Gallup 45.0 51.0
4232 4232 93592 57686   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1039 a a Live Phone 3/1/19 3/10/19     3/14/19 12:10   https://news.gallup.com/poll/247718/trump-job-approval-falters-month-higher-ratings.aspx Gallup 39.0 57.0
4442 4442 93103 57504   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1016 a a Live Phone 2/1/19 2/10/19     2/13/19 08:39   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 44.0 52.0
4548 4548 92940 57432   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1017 a a Live Phone 1/21/19 1/27/19     1/30/19 10:37   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 37.0 59.0
4693 4693 92665 57308   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1017 a a Live Phone 1/2/19 1/10/19     1/15/19 07:53   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 37.0 59.0
4805 4805 92350 57169   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 12/17/18 12/22/18     12/25/18 13:02   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 39.0 55.0
4852 4852 92243 57130   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 12/10/18 12/16/18     12/17/18 13:07   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 38.0 57.0
4908 4908 92098 57036   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 12/3/18 12/9/18     12/10/18 13:04   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 56.0
4957 4957 92030 57006   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 11/26/18 12/2/18     12/3/18 13:05   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 56.0
5008 5008 91851 56922   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 11/18/18 11/25/18     11/26/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 38.0 60.0
5054 5054 91801 56901   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 11/12/18 11/18/18     11/19/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 43.0 53.0
5113 5113 91672 56852   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 11/5/18 11/11/18     11/12/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 38.0 56.0
5171 5171 91501 56784   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 10/29/18 11/4/18     11/5/18 13:05   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 54.0
5239 5239 90916 56514   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 10/22/18 10/28/18     10/29/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 54.0
5298 5298 90593 56357   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 10/15/18 10/21/18     10/22/18 13:20   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 44.0 50.0
5368 5368 90278 56211   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 10/8/18 10/14/18     10/15/18 13:02   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 44.0 51.0
5421 5421 89948 56086   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 10/1/18 10/7/18     10/8/18 13:04   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 43.0 53.0
5487 5487 89660 55952   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 9/24/18 9/30/18     10/1/18 13:03   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 53.0
5545 5545 89400 55837   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 9/17/18 9/23/18     9/24/18 13:02   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 56.0
5603 5603 87211 54062   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 9/10/18 9/16/18     9/17/18 13:08   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 38.0 56.0
5662 5662 86737 53926   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 9/3/18 9/9/18     9/10/18 13:34   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 54.0
5717 5717 86543 53835   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 8/27/18 9/2/18     9/3/18 19:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 53.0
5772 5772 86421 53781   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 8/20/18 8/26/18     8/27/18 13:46   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 54.0
5832 5832 86106 53654   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 8/13/18 8/19/18     8/20/18 13:31   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 52.0
5882 5882 86002 53591   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 8/6/18 8/12/18     8/13/18 13:02   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 39.0 56.0
5927 5927 85874 53526   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 7/30/18 8/5/18     8/6/18 13:17   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 54.0
5971 5971 84602 53443   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 7/23/18 7/29/18     7/30/18 14:33   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 55.0
6021 6021 84502 53395   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 7/16/18 7/22/18     7/23/18 13:11   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 54.0
6073 6073 83510 52836   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 7/9/18 7/15/18     7/16/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 43.0 52.0
6122 6122 83441 52799   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 7/1/18 7/8/18     7/9/18 13:11   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 56.0
6162 6162 83377 52769   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 6/25/18 7/1/18     7/2/18 13:09   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 53.0
6206 6206 83214 52669   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 6/18/18 6/24/18     6/25/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 55.0
6253 6253 83062 52567   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 6/11/18 6/17/18     6/18/18 13:09   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 45.0 50.0
6295 6295 83004 52540   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 6/4/18 6/10/18     6/11/18 13:08   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 54.0
6336 6336 82921 52490   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 5/28/18 6/3/18     6/4/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 55.0
6377 6377 82871 52465   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 5/21/18 5/27/18     5/28/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 40.0 55.0
6416 6416 82808 52435   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 5/14/18 5/20/18     5/21/18 18:38   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 54.0
6454 6454 82737 52396   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 5/7/18 5/13/18     5/14/18 13:08   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 43.0 52.0
6489 6489 82646 52350   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 4/30/18 5/6/18     5/7/18 13:07   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 52.0
6535 6535 82591 52323   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 4/23/18 4/29/18     4/30/18 13:10   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 42.0 53.0
6576 6576 82539 52300   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 4/16/18 4/22/18     4/23/18 13:08   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 38.0 57.0
6625 6625 81663 51637   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 4/9/18 4/15/18     4/16/18 13:04   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 39.0 55.0
6672 6672 81605 51613   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 4/2/18 4/8/18     4/9/18 13:08   http://news.gallup.com/poll/203207/trump-job-approval-weekly.aspx Gallup 41.0 54.0
9206 9206 78032 49699   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 5/2/17 5/5/17   1 5/6/17 13:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 40.0 54.0
9586 9586 77725 49507   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/17/17 3/19/17   1 3/20/17 13:05   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 39.0 55.0
9594 9594 77723 49505   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/16/17 3/18/17   1 3/19/17 15:09   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 37.0 58.0
9601 9601 77721 49503   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/15/17 3/17/17   1 3/18/17 14:01   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 40.0 55.0
9608 9608 77720 49502   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/14/17 3/16/17   1 3/17/17 13:36   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 41.0 54.0
9619 9619 77705 49494   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/13/17 3/15/17   1 3/16/17 13:54   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 42.0 53.0
9628 9628 77702 49491   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/12/17 3/14/17   1 3/15/17 13:16   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 40.0 54.0
9633 9633 77695 49485   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/11/17 3/13/17   1 3/14/17 13:24   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 39.0 55.0
9641 9641 77681 49479   11 Donald Trump 169 Gallup     Gallup 112 Gallup B 1500 a a Live Phone 3/10/17 3/12/17   1 3/13/17 13:16   http://www.gallup.com/poll/201617/gallup-daily-trump-job-approval.aspx Gallup 42.0 51.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 5307.875ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette