president_approval_polls

Table actions

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

10 rows where methodology = "Automated Phone"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: pollster_id, pollster, sponsor_ids, sponsors, display_name, pollster_rating_id, pollster_rating_name, sample_size, population, population_full, end_date, 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
1108 1108 125205 67012   11 Donald Trump 1589 Reconnect Research/Roanoke College     Reconnect Research/Roanoke College 587 Reconnect Research/Roanoke College   1917 a a Automated Phone 6/18/20 6/23/20     7/7/20 16:30   https://www.roanoke.edu/about/news/reconnect_research_roanoke_college_poll 538 44.0 47.0
1954 1954 119692 64723   11 Donald Trump 383 Public Policy Polling 946 Protect Our Care Public Policy Polling 263 Public Policy Polling B 866 rv rv Automated Phone 3/2/20 3/3/20     3/5/20 10:29   https://www.protectourcare.org/wp-content/uploads/2020/03/Coronavirus-Poll-Memo-And-Results-3-20.pdf 538 41.0 55.0
3856 3856 94397 58026   11 Donald Trump 383 Public Policy Polling 946 Protect Our Care Public Policy Polling 263 Public Policy Polling B 658 rv rv Automated Phone 5/1/19 5/1/19     5/8/19 11:10   https://www.protectourcare.org/wp-content/uploads/2019/05/NationalResults-1-1.pdf 538 41.0 56.0
4196 4196 93596 57689   11 Donald Trump 383 Public Policy Polling 946 Protect Our Care Public Policy Polling 263 Public Policy Polling B 661 rv rv Automated Phone 3/13/19 3/14/19     3/15/19 09:11   http://www.protectourcare.org/wp-content/uploads/2017/12/NationalResults-1-1.pdf 538 42.0 54.0
4679 4679 92657 57305   11 Donald Trump 383 Public Policy Polling 1121 Law Works Action Public Policy Polling 263 Public Policy Polling B 782 rv rv Automated Phone 1/10/19 1/11/19     1/14/19 16:49   https://lawworksaction.org/wp-content/uploads/2019/01/LWA-PPP-Poll.pdf 538 42.0 53.0
4728 4728 92503 57235   11 Donald Trump 383 Public Policy Polling 946 Protect Our Care Public Policy Polling 263 Public Policy Polling B 658 rv rv Automated Phone 1/3/19 1/4/19     1/8/19 09:04   http://www.protectourcare.org/wp-content/uploads/2019/01/POLL-PPP-National-TX-Lawsuit-Toplines-and-Tabs.pdf 538 43.0 52.0
5754 5754 86607 53855   11 Donald Trump 383 Public Policy Polling 1121 Law Works Action Public Policy Polling 263 Public Policy Polling B 572 rv rv Automated Phone 8/27/18 8/28/18     9/5/18 08:54   http://lawworksaction.org/wp-content/uploads/2018/08/Law-Works-PPP-August-Results.pdf 538 41.0 56.0
5759 5759 86616 53861   11 Donald Trump 800 Kaiser Family Foundation     Kaiser Family Foundation 419 Kaiser Family Foundation   1201 a a Automated Phone 8/23/18 8/28/18     9/5/18 10:23   http://files.kff.org/attachment/Topline-Kaiser-Health-Tracking-Poll-Late-Summer-2018 538 37.0 59.0
6036 6036 84505 53397   11 Donald Trump 383 Public Policy Polling 946 Protect Our Care Public Policy Polling 263 Public Policy Polling B 514 rv rv Automated Phone 7/18/18 7/19/18     7/23/18 13:56   http://www.protectourcare.org/wp-content/uploads/2018/07/ACA-Repeal-July-23-Memo-Results-1.pdf 538 43.0 52.0
7019 7019 99921 58767   11 Donald Trump 383 Public Policy Polling 973 314 Action Public Policy Polling 263 Public Policy Polling B 745 rv rv Automated Phone 2/15/18 2/16/18     7/30/19 12:24   https://static1.squarespace.com/static/577d34d137c58194f7d3f055/t/5a8caa4d9140b73a44ee185d/1519168077619/PPP+NationalResults+Nominals+%281%29.pdf 538 43.0 53.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
);