president_approval_polls
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1 row where pollster_rating_name = "Public Policy Polling" and source = "RCP"
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9642 | 9642 | 77698 | 49488 | 11 | Donald Trump | 383 | Public Policy Polling | Public Policy Polling | 263 | Public Policy Polling | B | 808 | rv | rv | 3/10/17 | 3/12/17 | 3/15/17 11:48 | http://www.publicpolicypolling.com/pdf/2017/PPP_Release_National_31517.pdf | RCP | 43.0 | 50.0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );