house_polls
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2 rows where methodology = "Live Phone/Online/Text"
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | question_id | poll_id | cycle | state | pollster_id | pollster | sponsor_ids | sponsors | display_name | pollster_rating_id | pollster_rating_name | fte_grade | sample_size | population | population_full | methodology | office_type | seat_number | seat_name | start_date | end_date | election_date | sponsor_candidate | internal | partisan | tracking | nationwide_batch | ranked_choice_reallocated | created_at | notes | url | stage | race_id | answer | candidate_id | candidate_name | candidate_party | pct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 292 | 292 | 132157 | 70667 | 2020 | California | 1628 | Breakthrough Campaigns | Breakthrough Campaigns | 623 | Breakthrough Campaigns | 644 | lv | lv | Live Phone/Online/Text | U.S. House | 25 | District 25 | 10/3/20 | 10/6/20 | 11/3/20 | Christy Smith | 1 | DEM | 0 | 0 | 10/8/20 09:10 | https://perma.cc/6CAV-FUEB | general | 7874 | Smith | 13791 | Christy Smith | DEM | 49.0 | |||||
| 293 | 293 | 132157 | 70667 | 2020 | California | 1628 | Breakthrough Campaigns | Breakthrough Campaigns | 623 | Breakthrough Campaigns | 644 | lv | lv | Live Phone/Online/Text | U.S. House | 25 | District 25 | 10/3/20 | 10/6/20 | 11/3/20 | Christy Smith | 1 | DEM | 0 | 0 | 10/8/20 09:10 | https://perma.cc/6CAV-FUEB | general | 7874 | Garcia | 13793 | Mike Garcia | REP | 47.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_polls" ( "question_id" INTEGER, "poll_id" INTEGER, "cycle" INTEGER, "state" 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, "office_type" TEXT, "seat_number" INTEGER, "seat_name" TEXT, "start_date" TEXT, "end_date" TEXT, "election_date" TEXT, "sponsor_candidate" TEXT, "internal" INTEGER, "partisan" TEXT, "tracking" INTEGER, "nationwide_batch" INTEGER, "ranked_choice_reallocated" INTEGER, "created_at" TEXT, "notes" TEXT, "url" TEXT, "stage" TEXT, "race_id" INTEGER, "answer" TEXT, "candidate_id" INTEGER, "candidate_name" TEXT, "candidate_party" TEXT, "pct" REAL );