house_polls

Table actions

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

8 rows where election_date = "3/20/21"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: question_id, poll_id, pollster_id, pollster, display_name, pollster_rating_id, pollster_rating_name, sample_size, methodology, start_date, end_date, internal, created_at, url, answer, candidate_id, candidate_name, pct

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
17 17 140138 74472 2021 Louisiana 1518 Edgewater Research/My People Vote     Edgewater Research/My People Vote 530 Edgewater Research/My People Vote B/C 651 lv lv IVR/Live Phone U.S. House 2 District 2 3/2/21 3/7/21 3/20/21   0     0 0 3/10/21 21:22   https://htv-prod-media.s3.amazonaws.com/files/2nd-congressional-district-report-1615416394.pdf jungle primary 9433 Carter 18939 Troy A. Carter DEM 35.0
18 18 140138 74472 2021 Louisiana 1518 Edgewater Research/My People Vote     Edgewater Research/My People Vote 530 Edgewater Research/My People Vote B/C 651 lv lv IVR/Live Phone U.S. House 2 District 2 3/2/21 3/7/21 3/20/21   0     0 0 3/10/21 21:22   https://htv-prod-media.s3.amazonaws.com/files/2nd-congressional-district-report-1615416394.pdf jungle primary 9433 Peterson 18940 Karen Carter Peterson DEM 24.0
19 19 140138 74472 2021 Louisiana 1518 Edgewater Research/My People Vote     Edgewater Research/My People Vote 530 Edgewater Research/My People Vote B/C 651 lv lv IVR/Live Phone U.S. House 2 District 2 3/2/21 3/7/21 3/20/21   0     0 0 3/10/21 21:22   https://htv-prod-media.s3.amazonaws.com/files/2nd-congressional-district-report-1615416394.pdf jungle primary 9433 Chambers 18941 Gary Chambers DEM 11.0
20 20 139993 74439 2021 Louisiana 1670 Silas Lee     Silas Lee 668 Silas Lee   650 lv lv Live Phone U.S. House 2 District 2 2/12/21 2/14/21 3/20/21 Troy A. Carter 1 DEM   0 0 3/2/21 20:31   https://midcitymessenger.com/2021/03/02/troy-carter-leads-congressional-field-pollster-silas-lee-finds/ jungle primary 9433 Peterson 18940 Karen Carter Peterson DEM 19.0
21 21 139993 74439 2021 Louisiana 1670 Silas Lee     Silas Lee 668 Silas Lee   650 lv lv Live Phone U.S. House 2 District 2 2/12/21 2/14/21 3/20/21 Troy A. Carter 1 DEM   0 0 3/2/21 20:31   https://midcitymessenger.com/2021/03/02/troy-carter-leads-congressional-field-pollster-silas-lee-finds/ jungle primary 9433 Carter 18939 Troy A. Carter DEM 28.0
22 22 139993 74439 2021 Louisiana 1670 Silas Lee     Silas Lee 668 Silas Lee   650 lv lv Live Phone U.S. House 2 District 2 2/12/21 2/14/21 3/20/21 Troy A. Carter 1 DEM   0 0 3/2/21 20:31   https://midcitymessenger.com/2021/03/02/troy-carter-leads-congressional-field-pollster-silas-lee-finds/ jungle primary 9433 Chambers 18941 Gary Chambers DEM 6.0
23 23 139993 74439 2021 Louisiana 1670 Silas Lee     Silas Lee 668 Silas Lee   650 lv lv Live Phone U.S. House 2 District 2 2/12/21 2/14/21 3/20/21 Troy A. Carter 1 DEM   0 0 3/2/21 20:31   https://midcitymessenger.com/2021/03/02/troy-carter-leads-congressional-field-pollster-silas-lee-finds/ jungle primary 9433 Ontiveros 18942 Desiree Ontiveros DEM 2.0
24 24 139993 74439 2021 Louisiana 1670 Silas Lee     Silas Lee 668 Silas Lee   650 lv lv Live Phone U.S. House 2 District 2 2/12/21 2/14/21 3/20/21 Troy A. Carter 1 DEM   0 0 3/2/21 20:31   https://midcitymessenger.com/2021/03/02/troy-carter-leads-congressional-field-pollster-silas-lee-finds/ jungle primary 9433 Bernard 18943 Claston Bernard REP 2.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
);