president_approval_polls
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1 row where source = "538 | Huffpost | Huffpost | Huffpost | Huffpost | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9714 | 9714 | 77628 | 49446 | 11 | Donald Trump | 100 | CNN/Opinion Research Corp. | 143 | CNN | CNN/Opinion Research Corp. | 37 | CNN/Opinion Research Corp. | B+ | 1025 | a | a | Live Phone | 3/1/17 | 3/4/17 | 3/6/17 10:30 | http://i2.cdn.turner.com/cnn/2017/images/03/05/rel4a.-.trump,.russia.pdf | 538 | Huffpost | Huffpost | Huffpost | Huffpost | RCP | 45.0 | 52.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 );