senate_polls

Table actions

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

22 rows where url = "https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: question_id, poll_id, state, sample_size, created_at, race_id, candidate_party, 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
4085 4085 83448 52804 2018 Indiana 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 952 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 102 Donnelly 11128 Joe Donnelly DEM 47.0
4086 4086 83448 52804 2018 Indiana 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 952 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 102 Braun 11129 Mike Braun REP 49.0
4097 4097 83449 52805 2018 Montana 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 974 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 110 Tester 11140 Jon Tester DEM 55.0
4098 4098 83449 52805 2018 Montana 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 974 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 110 Rosendale 11141 Matt Rosendale REP 43.0
4109 4109 83450 52806 2018 North Dakota 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 457 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 116 Heitkamp 11148 Heidi Heitkamp DEM 47.0
4110 4110 83450 52806 2018 North Dakota 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 457 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 116 Cramer 11149 Kevin Cramer REP 52.0
4121 4121 83451 52807 2018 Pennsylvania 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 990 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 118 Casey 11138 Robert P. Casey Jr. DEM 55.0
4122 4122 83451 52807 2018 Pennsylvania 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 990 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 118 Barletta 11139 Lou Barletta REP 41.0
4133 4133 83452 52808 2018 Ohio 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 951 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 117 Brown 11130 Sherrod Brown DEM 52.0
4134 4134 83452 52808 2018 Ohio 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 951 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 117 Renacci 11131 Jim Renacci REP 44.0
4145 4145 83453 52809 2018 West Virginia 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 892 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 126 Manchin 11132 Joe Manchin, III DEM 53.0
4146 4146 83453 52809 2018 West Virginia 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 892 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 126 Morrisey 11133 Patrick Morrisey REP 40.0
4157 4157 83454 52810 2018 Nevada 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1097 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 112 Rosen 11150 Jacky Rosen DEM 48.0
4158 4158 83454 52810 2018 Nevada 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1097 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 7/10/18 11:32   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 112 Heller 11151 Dean Heller REP 45.0
4169 4169 85661 53477 2018 Tennessee 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1010 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/3/18 13:05   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 120 Bredesen 11382 Phil Bredesen DEM 41.0
4170 4170 85661 53477 2018 Tennessee 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1010 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/3/18 13:05   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 120 Blackburn 11383 Marsha Blackburn REP 55.0
4181 4181 86124 53664 2018 Wisconsin 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 968 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/20/18 22:27   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 127 Baldwin 12400 Tammy Baldwin DEM 56.0
4182 4182 86124 53664 2018 Wisconsin 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 968 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/20/18 22:27   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 127 Vukmir 12401 Leah Vukmir REP 40.0
4193 4193 86131 53669 2018 Michigan 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 978 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/20/18 22:54   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 106 Stabenow 11408 Debbie Stabenow DEM 54.0
4194 4194 86131 53669 2018 Michigan 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 978 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/20/18 22:54   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 106 James 11409 John James REP 42.0
4205 4205 86141 53678 2018 Missouri 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1038 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/21/18 00:40   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 109 McCaskill 11410 Claire McCaskill DEM 49.0
4206 4206 86141 53678 2018 Missouri 1193 SurveyMonkey 788 Axios SurveyMonkey 324 SurveyMonkey C 1038 rv rv Online U.S. Senate 0 Class I 6/11/18 7/2/18 11/6/18   0     0 0 8/21/18 00:40   https://drive.google.com/file/d/1bwnfno7ZxLYIQ_B_Iyu08VXDdBJsGQlR/view general 109 Hawley 11411 Josh Hawley REP 47.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_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" TEXT,
  "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
);