fivethirtyeight

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

Custom SQL query returning 101 rows (hide)

rowidracestatemodeldatecandidate_namecandidate_idpct_estimatepct_trend_adjustedtimestampcommentcontestdate
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
101 1980D Florida 1979-10-26 Edward M. Kennedy 450 39.19293 38.4701 12/10/19 16:25 one day test 1980-03-11