president_approval_polls

Table actions

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

18 rows where fte_grade = "D+"

✎ 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
7276 7276 80214 50789   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1398 a a   1/9/18 1/10/18     1/12/18 13:19   https://luc.id/public-opinion-weekly/ 538 37.81 50.95
7323 7323 80148 50756   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 929 a a Online 1/3/18 1/3/18     1/5/18 11:29   https://docs.google.com/spreadsheets/d/159GtT-_6m8fbZdMXLauwCXUgQH4DB9r0EtZQDn4rJ3w/edit#gid=0 538 36.99 50.17
7369 7369 80147 50755   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 698 a a Online 12/26/17 12/26/17     1/5/18 11:29   https://docs.google.com/spreadsheets/d/1lnqa9miGW7FS9aBuQqHLXCFis8WDn6qNpJ6pjEMgDes/edit#gid=0 538 36.11 53.61
7405 7405 80068 50720   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 771 a a Online 12/19/17 12/20/17     12/20/17 14:24   https://docs.google.com/spreadsheets/d/1IRVfp_SvRQdjtRpYjEiuNmcLAgh9WgphLNPDW5q_wS8/edit 538 31.52 54.58
7458 7458 80010 50692   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 866 a a Online 12/12/17 12/13/17     12/15/17 11:55   https://docs.google.com/spreadsheets/d/1wAsg4TpnnNPUVcoVwYiL-hoOyTC-6-xDxhKs3yYgZDY/edit#gid=0 538 33.57 51.98
7524 7524 79922 50639   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 859 a a Online 12/5/17 12/5/17     12/6/17 16:00   https://docs.google.com/spreadsheets/d/1hopgHDTvUYJhSlc7s5cp2tLRhz7U74Jj3Rz3Ab32hYI/edit#gid=486397006 538 34.82 50.18
7570 7570 79855 50605   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 923 a a   11/28/17 11/29/17     11/30/17 17:06   https://docs.google.com/spreadsheets/d/1m4UAIlB5AL1ahJl5LVNG9tYk-cMoOlmG_vbXxTNLMZw/edit#gid=316725040 538 35.32 52.25
7624 7624 79707 50502   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 985 a a   11/21/17 11/21/17     11/22/17 12:05   https://docs.google.com/spreadsheets/d/1clCXnZwV2QsCfxo5oAOrP2s5ahcydPwfmWCwwcSLA38/edit#gid=2018165107 538 37.57 49.66
7665 7665 79647 50472   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1208 a a   11/14/17 11/15/17     11/17/17 11:12   https://docs.google.com/spreadsheets/d/1JXfA9Mt1no6nQhbeI3QnRANxz_AJ2RMnkXAe0HWysOI/edit#gid=391041400 538 35.24 50.85
7721 7721 79588 50441   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1274 a a   11/7/17 11/8/17     11/10/17 17:33   https://docs.google.com/spreadsheets/d/1UxvHHdflg9W61kPAiGXGMCsDFiFh-lquT_uycLf7u40/edit#gid=472997518 538 38.32 46.91
7774 7774 79530 50416   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1315 a a   10/31/17 11/1/17     11/3/17 17:17   https://docs.google.com/spreadsheets/d/1U7wyMjIKtNizDM3YR0wtsR4sL_1NQAqW75h_1d8vEJE/edit#gid=729662399 538 36.99 52.43
7831 7831 79166 50388   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1300 a a   10/24/17 10/25/17     10/27/17 15:51   https://docs.google.com/spreadsheets/d/1dmnTsTBGYVG03dP1RsIR2Ld4aUBBfU7BX5ep943JY50/edit#gid=1910159597 538 37.02 50.98
7883 7883 79131 50365   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1232 a a   10/17/17 10/18/17     10/23/17 12:17   https://docs.google.com/spreadsheets/d/1nQbcqysRqh-Pmbi5_newSvHOQvKB_6B-WLgbB7SEhNE/edit#gid=934482207 538 33.74 53.38
7940 7940 79074 50328   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1323 a a Online 10/10/17 10/11/17     10/14/17 07:41   https://docs.google.com/spreadsheets/d/1jIE78qBx4vwoSlThRsP7vuIlMgyMPGfWqypzuzG9g9Q/edit#gid=2111118379 538 33.53 51.57
7994 7994 79040 50305   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1105 a a Online 10/3/17 10/4/17     10/10/17 11:55   https://docs.google.com/spreadsheets/d/1DoH34Bf2DM5lYLVE6dpoXXgUz_ww2ZpfI6Ff9BQmYuI/edit#gid=46686678 538 36.2 51.62
8050 8050 79041 50306   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1221 a a Online 9/26/17 9/27/17     10/10/17 11:55   https://docs.google.com/spreadsheets/d/14_slK2mca2KhZLhFUVeQeVtfOq6HgBdiFcB1bbDfFS4/edit?usp=sharing 538 34.57 52.77
8109 8109 79042 50307   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1301 a a Online 9/19/17 9/20/17     10/10/17 11:55   https://docs.google.com/spreadsheets/d/17Hc0loE6wXtGEWShWsC7X2xG1adogmfzYpb21KkPkV0/edit#gid=652311423 538 38.21 48.66
8177 8177 79043 50308   11 Donald Trump 1328 Lucid     Lucid 175 Lucid D+ 1592 a a Online 9/11/17 9/12/17     10/10/17 11:55   https://luc.id/wp-content/uploads/2017/09/Lucid-Political-Tracker-Cross-Tabs-92F11-2.pdf 538 34.5 50.65

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
);