This table contains the data behind the story How Much Trouble Is Ted Cruz Really In?

august_senate_polls.csv contains every senate poll in our database from 1990 to 2016 that was conducted in the month of August along with the results of the election corresponding to each poll and the average error of each poll.

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

594 rows

View and edit SQL

Suggested facets: cycle, senate_class, start_date (date), end_date (date)

Link rowid ▼ cycle state senate_class start_date end_date DEM_poll REP_poll DEM_result REP_result error absolute_error
1 2016 IA 3 2016-08-30 2016-08-31 43.0 49.0 35.66 60.09 -18.430000000000007 18.430000000000007
2 2016 PA 3 2016-08-30 2016-08-31 44.0 41.0 47.34 48.77 -4.43 4.43
3 2016 NH 3 2016-08-30 2016-08-31 47.0 44.0 47.98 47.84 -2.8600000000000065 2.8600000000000065
4 2016 CO 3 2016-08-29 2016-08-31 48.0 38.0 49.97 44.31 -4.340000000000003 4.340000000000003
5 2016 NY 3 2016-08-28 2016-08-30 60.0 23.0 70.6 27.17 6.429999999999993 6.429999999999993
6 2016 NC 3 2016-08-27 2016-08-29 41.3 45.2 45.37 51.06 -1.7899999999999991 1.7899999999999991
7 2016 AK 3 2016-08-27 2016-08-29 12.0 56.0 11.62 44.36 11.259999999999998 11.259999999999998
8 2016 WI 3 2016-08-27 2016-08-30 54.0 41.0 46.81 50.17 -16.36 16.36
9 2016 PA 3 2016-08-26 2016-08-27 46.0 40.0 47.34 48.77 -7.43 7.43
10 2016 OH 3 2016-08-26 2016-08-27 39.0 48.0 37.16 58.03 -11.870000000000005 11.870000000000005
11 2016 MO 3 2016-08-26 2016-08-27 43.0 47.0 46.39 49.18 1.2100000000000009 1.2100000000000009
12 2016 WI 3 2016-08-26 2016-08-27 49.0 42.0 46.81 50.17 -10.36 10.36
13 2016 NC 3 2016-08-26 2016-08-27 43.0 46.0 45.37 51.06 -2.690000000000005 2.690000000000005
14 2016 NH 3 2016-08-26 2016-08-28 47.0 45.0 47.98 47.84 -1.8600000000000063 1.8600000000000063
15 2016 AZ 3 2016-08-26 2016-08-28 43.0 43.0 40.75 53.71 -12.96 12.96
16 2016 PA 3 2016-08-26 2016-08-29 45.0 41.0 47.34 48.77 -5.43 5.43
17 2016 WI 3 2016-08-25 2016-08-25 55.0 37.0 46.81 50.17 -21.36 21.36
18 2016 WI 3 2016-08-25 2016-08-28 48.0 45.0 46.81 50.17 -6.359999999999999 6.359999999999999
19 2016 PA 3 2016-08-25 2016-08-29 43.0 38.0 47.34 48.77 -6.43 6.43
20 2016 PA 3 2016-08-25 2016-08-28 39.0 46.0 47.34 48.77 5.57 5.57
21 2016 OH 3 2016-08-25 2016-08-27 25.0 40.0 37.16 58.03 -5.8700000000000045 5.8700000000000045
22 2016 FL 3 2016-08-22 2016-08-24 43.0 46.0 44.31 51.98 -4.669999999999995 4.669999999999995
23 2016 PA 3 2016-08-21 2016-08-28 48.0 45.0 47.34 48.77 -4.43 4.43
24 2016 WI 3 2016-08-21 2016-08-22 49.6 46.6 46.81 50.17 -6.359999999999999 6.359999999999999
25 2016 PA 3 2016-08-21 2016-08-28 47.0 42.0 47.34 48.77 -6.43 6.43
26 2016 NC 3 2016-08-20 2016-08-23 43.0 45.0 45.37 51.06 -3.690000000000005 3.690000000000005
27 2016 NH 3 2016-08-20 2016-08-28 51.0 27.0 47.98 47.84 -23.860000000000007 23.860000000000007
28 2016 NH 3 2016-08-20 2016-08-28 44.0 42.0 47.98 47.84 -1.8600000000000063 1.8600000000000063
29 2016 FL 3 2016-08-19 2016-08-22 39.0 44.0 44.31 51.98 -2.6699999999999946 2.6699999999999946
30 2016 UT 3 2016-08-19 2016-08-21 21.0 51.0 27.06 68.15 -11.090000000000003 11.090000000000003
31 2016 MO 3 2016-08-19 2016-08-22 43.0 48.0 46.39 49.18 2.210000000000001 2.210000000000001
32 2016 AZ 3 2016-08-18 2016-08-23 39.0 52.0 40.75 53.71 0.0399999999999991 0.0399999999999991
33 2016 NC 3 2016-08-18 2016-08-23 45.0 50.0 45.37 51.06 -0.6900000000000048 0.6900000000000048
34 2016 MD 3 2016-08-18 2016-08-30 55.0 26.0 60.89 35.67 -3.780000000000001 3.780000000000001
35 2016 ID 3 2016-08-18 2016-08-31 20.0 57.0 27.73 66.13 -1.3999999999999917 1.3999999999999917
36 2016 OH 3 2016-08-18 2016-08-21 40.0 48.0 37.16 58.03 -12.870000000000005 12.870000000000005
37 2016 FL 3 2016-08-18 2016-08-24 42.0 43.0 44.31 51.98 -6.669999999999995 6.669999999999995
38 2016 OH 3 2016-08-17 2016-08-19 39.0 46.0 37.16 58.03 -13.870000000000005 13.870000000000005
39 2016 IA 3 2016-08-17 2016-08-19 38.0 45.0 35.66 60.09 -17.430000000000007 17.430000000000007
40 2016 IN 3 2016-08-15 2016-08-18 55.0 39.0 42.41 52.11 -25.700000000000003 25.700000000000003
41 2016 NV 3 2016-08-15 2016-08-17 37.0 37.0 47.1 44.67 2.43 2.43
42 2016 FL 3 2016-08-14 2016-08-18 38.0 46.0 44.31 51.98 0.3300000000000054 0.3300000000000054
43 2016 IN 3 2016-08-13 2016-08-16 48.0 41.0 42.41 52.11 -16.700000000000003 16.700000000000003
44 2016 FL 3 2016-08-12 2016-08-15 43.0 48.0 44.31 51.98 -2.6699999999999946 2.6699999999999946
45 2016 NH 3 2016-08-10 2016-08-12 42.0 41.0 47.98 47.84 -0.8600000000000065 0.8600000000000065
46 2016 FL 3 2016-08-10 2016-08-10 43.4 44.7 44.31 51.98 -6.36999999999999 6.36999999999999
47 2016 IN 3 2016-08-10 2016-08-14 54.0 36.0 42.41 52.11 -27.700000000000003 27.700000000000003
48 2016 FL 3 2016-08-09 2016-08-15 45.0 44.0 44.31 51.98 -8.669999999999995 8.669999999999995
49 2016 WA 3 2016-08-09 2016-08-13 52.0 34.0 58.83 40.86 -0.0300000000000011 0.0300000000000011
50 2016 SC 3 2016-08-09 2016-08-10 28.0 45.0 36.93 60.57 -6.640000000000001 6.640000000000001
51 2016 CO 3 2016-08-09 2016-08-16 54.0 38.0 49.97 44.31 -10.340000000000003 10.340000000000003
52 2016 IA 3 2016-08-09 2016-08-16 42.0 51.0 35.66 60.09 -15.430000000000009 15.430000000000009
53 2016 IA 3 2016-08-08 2016-08-10 42.0 52.0 35.66 60.09 -14.430000000000009 14.430000000000009
54 2016 NY 3 2016-08-07 2016-08-10 63.0 24.0 70.6 27.17 4.429999999999993 4.429999999999993
55 2016 NH 3 2016-08-07 2016-08-08 46.0 43.0 47.98 47.84 -2.8600000000000065 2.8600000000000065
56 2016 GA 3 2016-08-06 2016-08-07 30.0 39.0 41.03 54.78 -4.75 4.75
57 2016 NH 3 2016-08-05 2016-08-07 47.0 42.0 47.98 47.84 -4.860000000000007 4.860000000000007
58 2016 NC 3 2016-08-05 2016-08-07 37.0 41.0 45.37 51.06 -1.6900000000000048 1.6900000000000048
59 2016 FL 3 2016-08-05 2016-08-07 40.0 42.0 44.31 51.98 -5.669999999999995 5.669999999999995
60 2016 MO 3 2016-08-05 2016-08-06 40.0 47.0 46.39 49.18 4.210000000000001 4.210000000000001
61 2016 WI 3 2016-08-04 2016-08-07 50.0 39.0 46.81 50.17 -14.36 14.36
62 2016 NC 3 2016-08-04 2016-08-10 46.0 44.0 45.37 51.06 -7.690000000000005 7.690000000000005
63 2016 FL 3 2016-08-04 2016-08-10 43.0 49.0 44.31 51.98 -1.6699999999999946 1.6699999999999946
64 2016 CO 3 2016-08-04 2016-08-10 53.0 38.0 49.97 44.31 -9.340000000000003 9.340000000000003
65 2016 WI 3 2016-08-04 2016-08-07 49.0 43.0 46.81 50.17 -9.36 9.36
66 2016 WI 3 2016-08-04 2016-08-07 53.0 42.0 46.81 50.17 -14.36 14.36
67 2016 WI 3 2016-08-04 2016-08-07 47.0 38.0 46.81 50.17 -12.36 12.36
68 2016 IA 3 2016-08-03 2016-08-07 42.0 52.0 35.66 60.09 -14.430000000000009 14.430000000000009
69 2016 OH 3 2016-08-03 2016-08-07 43.0 48.0 37.16 58.03 -15.870000000000005 15.870000000000005
70 2016 PA 3 2016-08-03 2016-08-07 48.0 44.0 47.34 48.77 -5.43 5.43
71 2016 KS 3 2016-08-03 2016-08-07 32.0 52.0 32.24 62.18 -9.939999999999998 9.939999999999998
72 2016 KY 3 2016-08-02 2016-08-04 40.7 59.3 42.72 57.27 4.04999999999999 4.04999999999999
73 2016 NV 3 2016-08-02 2016-08-05 35.0 38.0 47.1 44.67 5.43 5.43
74 2016 GA 3 2016-08-01 2016-08-04 42.0 48.0 41.03 54.78 -7.75 7.75
75 2016 IL 3 2016-08-01 2016-08-04 44.0 37.0 54.86 39.78 8.079999999999998 8.079999999999998
76 2016 FL 3 2016-08-01 2016-08-03 31.0 45.0 44.31 51.98 6.330000000000005 6.330000000000005
77 2016 FL 3 2016-08-01 2016-08-03 33.0 46.0 44.31 51.98 5.330000000000005 5.330000000000005
78 2016 IN 3 2016-08-01 2016-08-03 58.0 32.0 42.41 52.11 -35.7 35.7
79 2016 KY 3 2016-07-31 2016-08-01 38.0 50.0 42.72 57.27 -2.5500000000000043 2.5500000000000043
80 2016 PA 3 2016-07-31 2016-08-04 42.0 40.0 47.34 48.77 -3.43 3.43
81 2016 PA 3 2016-07-30 2016-08-07 47.0 44.0 47.34 48.77 -4.43 4.43
82 2016 FL 3 2016-07-30 2016-08-07 45.0 48.0 44.31 51.98 -4.669999999999995 4.669999999999995
83 2016 FL 3 2016-07-30 2016-08-07 48.0 34.0 44.31 51.98 -21.669999999999995 21.669999999999995
84 2016 OH 3 2016-07-30 2016-08-07 40.0 49.0 37.16 58.03 -11.870000000000005 11.870000000000005
85 2016 WI 3 2016-07-30 2016-08-01 49.7 44.2 46.81 50.17 -8.86 8.86
86 2016 NH 3 2016-07-29 2016-08-01 48.0 37.0 47.98 47.84 -10.860000000000008 10.860000000000008
87 2016 PA 3 2016-07-29 2016-08-01 39.0 38.0 47.34 48.77 -2.43 2.43
88 2016 UT 3 2016-07-18 2016-08-04 22.0 57.0 27.06 68.15 -6.090000000000003 6.090000000000003
89 2014 IA 2 2014-08-28 2014-08-30 43.0 45.0 43.76 52.1 -6.340000000000003 6.340000000000003
90 2014 OK 2 2014-08-28 2014-08-30 27.6 59.1 28.55 68.01 -7.960000000000008 7.960000000000008
91 2014 OK 3 2014-08-28 2014-08-30 27.9 58.4 28.98 67.85 -8.36999999999999 8.36999999999999
92 2014 NH 2 2014-08-27 2014-08-28 50.0 44.0 51.46 48.21 -2.75 2.75
93 2014 OK 3 2014-08-27 2014-08-28 34.0 57.0 28.98 67.85 -15.86999999999999 15.86999999999999
94 2014 IL 2 2014-08-27 2014-08-27 47.78 40.5 53.55 42.69 3.5799999999999983 3.5799999999999983
95 2014 MI 2 2014-08-27 2014-08-27 46.0 44.0 54.61 41.33 11.28 11.28
96 2014 SD 2 2014-08-27 2014-08-28 37.5 42.0 29.51 50.37 -16.359999999999996 16.359999999999996
97 2014 IL 2 2014-08-25 2014-08-27 44.0 38.0 53.55 42.69 4.859999999999999 4.859999999999999
98 2014 AR 2 2014-08-25 2014-08-26 44.0 43.0 39.43 56.5 -18.07 18.07
99 2014 KY 2 2014-08-25 2014-08-27 42.0 46.0 40.72 56.19 -11.47 11.47
100 2014 GA 2 2014-08-24 2014-08-25 44.74 43.09 45.21 52.89 -9.329999999999998 9.329999999999998

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "august-senate-polls/august_senate_polls" (
"cycle" INTEGER,
  "state" TEXT,
  "senate_class" INTEGER,
  "start_date" TEXT,
  "end_date" TEXT,
  "DEM_poll" REAL,
  "REP_poll" REAL,
  "DEM_result" REAL,
  "REP_result" REAL,
  "error" REAL,
  "absolute_error" REAL
);