home / polls

Menu
  • GraphQL API

house_polls

Table actions
  • GraphQL API for house_polls

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

2 rows where election_date = "5/12/20"

✎ View and edit SQL

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
848 848 123370 66279 2020 California 1359 DCCC Targeting and Analytics Department 451 DCCC DCCC Targeting and Analytics Department 68 DCCC Targeting and Analytics Department B/C 675 lv lv IVR/Live Phone U.S. House 25 District 25 5/6/20 5/10/20 5/12/20   1 DEM   0 0 5/14/20 07:26 N per https://www.dailykos.com/stories/2020/5/14/1943699/-Daily-Kos-Elections-Live-Digest-5-14#update-1589479428000 https://www.politico.com/newsletters/playbook/2020/05/14/a-sliver-of-good-news-for-republicans-489219 general 8659 Smith 17025 Christy Smith DEM 48.0
849 849 123370 66279 2020 California 1359 DCCC Targeting and Analytics Department 451 DCCC DCCC Targeting and Analytics Department 68 DCCC Targeting and Analytics Department B/C 675 lv lv IVR/Live Phone U.S. House 25 District 25 5/6/20 5/10/20 5/12/20   1 DEM   0 0 5/14/20 07:26 N per https://www.dailykos.com/stories/2020/5/14/1943699/-Daily-Kos-Elections-Live-Digest-5-14#update-1589479428000 https://www.politico.com/newsletters/playbook/2020/05/14/a-sliver-of-good-news-for-republicans-489219 general 8659 Garcia 17026 Mike Garcia REP 46.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Queries took 2055.198ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette