polls/pres_primary_avgs_1980-2016

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

301,695 rows

View and edit SQL

Suggested facets: modeldate (date)

These facets timed out: contestdate

Link rowid ▼ race state modeldate candidate_name candidate_id pct_estimate pct_trend_adjusted timestamp comment contestdate
1 1980D California 1979-10-23 Jimmy Carter 467 21.80135 22.59785 12/10/19 16:26 one day test 1980-06-03
2 1980D Connecticut 1979-10-23 Jimmy Carter 467 24.0 29.396659999999997 12/10/19 16:26 one day test 1980-03-25
3 1980D Florida 1979-10-23 Jimmy Carter 467 46.82137 46.18658 12/10/19 16:26 one day test 1980-03-11
4 1980D Georgia 1979-10-23 Jimmy Carter 467 57.22388 57.0298 12/10/19 16:26 one day test 1980-03-11
5 1980D Iowa 1979-10-23 Jimmy Carter 467 21.835820000000002 23.07114 12/10/19 16:26 one day test 1980-01-21
6 1980D Michigan 1979-10-23 Jimmy Carter 467 20.4 23.00465 12/10/19 16:26 one day test 1980-04-26
7 1980D National 1979-10-23 Jimmy Carter 467 29.84089   12/10/19 16:26 one day test  
8 1980D New Hampshire 1979-10-23 Jimmy Carter 467 21.965220000000002 22.72064 12/10/19 16:26 one day test 1980-02-26
9 1980D Pennsylvania 1979-10-23 Jimmy Carter 467 49.0 51.5665 12/10/19 16:26 one day test 1980-04-22
10 1980D Wisconsin 1979-10-23 Jimmy Carter 467 22.0 26.24264 12/10/19 16:26 one day test 1980-04-01
11 1980D California 1979-10-23 Jerry Brown 453 12.855960000000001 12.34195 12/10/19 16:26 one day test 1980-06-03
12 1980D Connecticut 1979-10-23 Jerry Brown 453 12.0 9.039301 12/10/19 16:26 one day test 1980-03-25
13 1980D Florida 1979-10-23 Jerry Brown 453 8.999999 9.179684 12/10/19 16:26 one day test 1980-03-11
14 1980D Iowa 1979-10-23 Jerry Brown 453 12.0 9.682269 12/10/19 16:26 one day test 1980-01-21
15 1980D Michigan 1979-10-23 Jerry Brown 453 7.3 3.709829 12/10/19 16:26 one day test 1980-04-26
16 1980D National 1979-10-23 Jerry Brown 453 8.247665   12/10/19 16:26 one day test  
17 1980D New Hampshire 1979-10-23 Jerry Brown 453 8.370479 7.038924000000001 12/10/19 16:26 one day test 1980-02-26
18 1980D California 1979-10-23 Edward M. Kennedy 450 56.64485 56.66896 12/10/19 16:26 one day test 1980-06-03
19 1980D Connecticut 1979-10-23 Edward M. Kennedy 450 61.0 62.65942 12/10/19 16:26 one day test 1980-03-25
20 1980D Florida 1979-10-23 Edward M. Kennedy 450 39.22907 39.5066 12/10/19 16:26 one day test 1980-03-11
21 1980D Georgia 1979-10-23 Edward M. Kennedy 450 29.31343 36.98903 12/10/19 16:26 one day test 1980-03-11
22 1980D Iowa 1979-10-23 Edward M. Kennedy 450 44.83582 52.660740000000004 12/10/19 16:26 one day test 1980-01-21
23 1980D Michigan 1979-10-23 Edward M. Kennedy 450 59.5 62.82995 12/10/19 16:26 one day test 1980-04-26
24 1980D National 1979-10-23 Edward M. Kennedy 450 52.51421   12/10/19 16:26 one day test  
25 1980D New Hampshire 1979-10-23 Edward M. Kennedy 450 57.72452 61.16385 12/10/19 16:26 one day test 1980-02-26
26 1980D Pennsylvania 1979-10-23 Edward M. Kennedy 450 34.0 33.77906 12/10/19 16:26 one day test 1980-04-22
27 1980D Wisconsin 1979-10-23 Edward M. Kennedy 450 50.0 51.74767 12/10/19 16:26 one day test 1980-04-01
28 1980D California 1979-10-24 Jimmy Carter 467 21.80135 22.59785 12/10/19 16:26 one day test 1980-06-03
29 1980D Connecticut 1979-10-24 Jimmy Carter 467 24.0 29.396659999999997 12/10/19 16:26 one day test 1980-03-25
30 1980D Florida 1979-10-24 Jimmy Carter 467 46.82137 46.18658 12/10/19 16:26 one day test 1980-03-11
31 1980D Georgia 1979-10-24 Jimmy Carter 467 57.22388 57.0298 12/10/19 16:26 one day test 1980-03-11
32 1980D Iowa 1979-10-24 Jimmy Carter 467 21.835820000000002 23.07114 12/10/19 16:26 one day test 1980-01-21
33 1980D Michigan 1979-10-24 Jimmy Carter 467 20.4 23.00465 12/10/19 16:26 one day test 1980-04-26
34 1980D National 1979-10-24 Jimmy Carter 467 29.84089   12/10/19 16:26 one day test  
35 1980D New Hampshire 1979-10-24 Jimmy Carter 467 21.965220000000002 22.72064 12/10/19 16:26 one day test 1980-02-26
36 1980D Pennsylvania 1979-10-24 Jimmy Carter 467 49.0 51.5665 12/10/19 16:26 one day test 1980-04-22
37 1980D Wisconsin 1979-10-24 Jimmy Carter 467 22.0 26.24264 12/10/19 16:26 one day test 1980-04-01
38 1980D California 1979-10-24 Jerry Brown 453 12.855960000000001 12.34195 12/10/19 16:26 one day test 1980-06-03
39 1980D Connecticut 1979-10-24 Jerry Brown 453 12.0 9.039301 12/10/19 16:26 one day test 1980-03-25
40 1980D Florida 1979-10-24 Jerry Brown 453 8.999999 9.179684 12/10/19 16:26 one day test 1980-03-11
41 1980D Iowa 1979-10-24 Jerry Brown 453 12.0 9.682269 12/10/19 16:26 one day test 1980-01-21
42 1980D Michigan 1979-10-24 Jerry Brown 453 7.3 3.709829 12/10/19 16:26 one day test 1980-04-26
43 1980D National 1979-10-24 Jerry Brown 453 8.247665   12/10/19 16:26 one day test  
44 1980D New Hampshire 1979-10-24 Jerry Brown 453 8.370479 7.038924000000001 12/10/19 16:26 one day test 1980-02-26
45 1980D California 1979-10-24 Edward M. Kennedy 450 56.64485 56.66896 12/10/19 16:25 one day test 1980-06-03
46 1980D Connecticut 1979-10-24 Edward M. Kennedy 450 61.0 62.65942 12/10/19 16:25 one day test 1980-03-25
47 1980D Florida 1979-10-24 Edward M. Kennedy 450 39.22907 39.5066 12/10/19 16:25 one day test 1980-03-11
48 1980D Georgia 1979-10-24 Edward M. Kennedy 450 29.31343 36.98903 12/10/19 16:25 one day test 1980-03-11
49 1980D Iowa 1979-10-24 Edward M. Kennedy 450 44.83582 52.660740000000004 12/10/19 16:25 one day test 1980-01-21
50 1980D Michigan 1979-10-24 Edward M. Kennedy 450 59.5 62.82995 12/10/19 16:25 one day test 1980-04-26
51 1980D National 1979-10-24 Edward M. Kennedy 450 52.51421   12/10/19 16:25 one day test  
52 1980D New Hampshire 1979-10-24 Edward M. Kennedy 450 57.72452 61.16385 12/10/19 16:25 one day test 1980-02-26
53 1980D Pennsylvania 1979-10-24 Edward M. Kennedy 450 34.0 33.77906 12/10/19 16:25 one day test 1980-04-22
54 1980D Wisconsin 1979-10-24 Edward M. Kennedy 450 50.0 51.74767 12/10/19 16:25 one day test 1980-04-01
55 1980D California 1979-10-25 Jimmy Carter 467 21.80135 22.59785 12/10/19 16:25 one day test 1980-06-03
56 1980D Connecticut 1979-10-25 Jimmy Carter 467 24.0 29.396659999999997 12/10/19 16:25 one day test 1980-03-25
57 1980D Florida 1979-10-25 Jimmy Carter 467 46.82137 46.18658 12/10/19 16:25 one day test 1980-03-11
58 1980D Georgia 1979-10-25 Jimmy Carter 467 57.22388 57.0298 12/10/19 16:25 one day test 1980-03-11
59 1980D Iowa 1979-10-25 Jimmy Carter 467 21.835820000000002 23.07114 12/10/19 16:25 one day test 1980-01-21
60 1980D Michigan 1979-10-25 Jimmy Carter 467 20.4 23.00465 12/10/19 16:25 one day test 1980-04-26
61 1980D National 1979-10-25 Jimmy Carter 467 29.84089   12/10/19 16:25 one day test  
62 1980D New Hampshire 1979-10-25 Jimmy Carter 467 21.965220000000002 22.72064 12/10/19 16:25 one day test 1980-02-26
63 1980D Pennsylvania 1979-10-25 Jimmy Carter 467 49.0 51.5665 12/10/19 16:25 one day test 1980-04-22
64 1980D Wisconsin 1979-10-25 Jimmy Carter 467 22.0 26.24264 12/10/19 16:25 one day test 1980-04-01
65 1980D California 1979-10-25 Jerry Brown 453 12.855960000000001 12.34195 12/10/19 16:25 one day test 1980-06-03
66 1980D Connecticut 1979-10-25 Jerry Brown 453 12.0 9.039301 12/10/19 16:25 one day test 1980-03-25
67 1980D Florida 1979-10-25 Jerry Brown 453 8.999999 9.179684 12/10/19 16:25 one day test 1980-03-11
68 1980D Iowa 1979-10-25 Jerry Brown 453 12.0 9.682269 12/10/19 16:25 one day test 1980-01-21
69 1980D Michigan 1979-10-25 Jerry Brown 453 7.3 3.709829 12/10/19 16:25 one day test 1980-04-26
70 1980D National 1979-10-25 Jerry Brown 453 8.247665   12/10/19 16:25 one day test  
71 1980D New Hampshire 1979-10-25 Jerry Brown 453 8.370479 7.038924000000001 12/10/19 16:25 one day test 1980-02-26
72 1980D California 1979-10-25 Edward M. Kennedy 450 56.64485 56.66896 12/10/19 16:25 one day test 1980-06-03
73 1980D Connecticut 1979-10-25 Edward M. Kennedy 450 61.0 62.65942 12/10/19 16:25 one day test 1980-03-25
74 1980D Florida 1979-10-25 Edward M. Kennedy 450 39.22907 39.5066 12/10/19 16:25 one day test 1980-03-11
75 1980D Georgia 1979-10-25 Edward M. Kennedy 450 29.31343 36.98903 12/10/19 16:25 one day test 1980-03-11
76 1980D Iowa 1979-10-25 Edward M. Kennedy 450 44.83582 52.660740000000004 12/10/19 16:25 one day test 1980-01-21
77 1980D Michigan 1979-10-25 Edward M. Kennedy 450 59.5 62.82995 12/10/19 16:25 one day test 1980-04-26
78 1980D National 1979-10-25 Edward M. Kennedy 450 52.51421   12/10/19 16:25 one day test  
79 1980D New Hampshire 1979-10-25 Edward M. Kennedy 450 57.72452 61.16385 12/10/19 16:25 one day test 1980-02-26
80 1980D Pennsylvania 1979-10-25 Edward M. Kennedy 450 34.0 33.77906 12/10/19 16:25 one day test 1980-04-22
81 1980D Wisconsin 1979-10-25 Edward M. Kennedy 450 50.0 51.74767 12/10/19 16:25 one day test 1980-04-01
82 1980D California 1979-10-26 Jimmy Carter 467 21.8638 23.70305 12/10/19 16:25 one day test 1980-06-03
83 1980D Connecticut 1979-10-26 Jimmy Carter 467 24.0 32.03644 12/10/19 16:25 one day test 1980-03-25
84 1980D Florida 1979-10-26 Jimmy Carter 467 47.01125 48.08423 12/10/19 16:25 one day test 1980-03-11
85 1980D Georgia 1979-10-26 Jimmy Carter 467 57.22388 58.659180000000006 12/10/19 16:25 one day test 1980-03-11
86 1980D Iowa 1979-10-26 Jimmy Carter 467 21.835820000000002 25.448079999999997 12/10/19 16:25 one day test 1980-01-21
87 1980D Michigan 1979-10-26 Jimmy Carter 467 20.4 25.415689999999998 12/10/19 16:25 one day test 1980-04-26
88 1980D National 1979-10-26 Jimmy Carter 467 32.242129999999996   12/10/19 16:25 one day test  
89 1980D New Hampshire 1979-10-26 Jimmy Carter 467 22.39641 25.88765 12/10/19 16:25 one day test 1980-02-26
90 1980D Pennsylvania 1979-10-26 Jimmy Carter 467 49.0 54.49576999999999 12/10/19 16:25 one day test 1980-04-22
91 1980D Wisconsin 1979-10-26 Jimmy Carter 467 22.0 28.778779999999998 12/10/19 16:25 one day test 1980-04-01
92 1980D California 1979-10-26 Jerry Brown 453 12.855960000000001 12.34195 12/10/19 16:25 one day test 1980-06-03
93 1980D Connecticut 1979-10-26 Jerry Brown 453 12.0 9.039301 12/10/19 16:25 one day test 1980-03-25
94 1980D Florida 1979-10-26 Jerry Brown 453 8.999999 9.179684 12/10/19 16:25 one day test 1980-03-11
95 1980D Iowa 1979-10-26 Jerry Brown 453 12.0 9.682269 12/10/19 16:25 one day test 1980-01-21
96 1980D Michigan 1979-10-26 Jerry Brown 453 7.3 3.709829 12/10/19 16:25 one day test 1980-04-26
97 1980D National 1979-10-26 Jerry Brown 453 8.247665   12/10/19 16:25 one day test  
98 1980D New Hampshire 1979-10-26 Jerry Brown 453 8.370479 7.038924000000001 12/10/19 16:25 one day test 1980-02-26
99 1980D California 1979-10-26 Edward M. Kennedy 450 56.63704 55.86852 12/10/19 16:25 one day test 1980-06-03
100 1980D Connecticut 1979-10-26 Edward M. Kennedy 450 61.0 61.18945 12/10/19 16:25 one day test 1980-03-25

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "polls/pres_primary_avgs_1980-2016" (
"race" TEXT,
  "state" TEXT,
  "modeldate" TEXT,
  "candidate_name" TEXT,
  "candidate_id" INTEGER,
  "pct_estimate" REAL,
  "pct_trend_adjusted" REAL,
  "timestamp" TEXT,
  "comment" TEXT,
  "contestdate" TEXT
);
Powered by Datasette · Query took 1832.34ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub