presidential-campaign-trail/clinton

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

71 rows

View and edit SQL

Link rowid ▼ date location lat lng
1 9/5/2016 Cleveland, Ohio 41.499320000000004 -81.6943605
2 9/5/2016 Hampton, Illinois 41.5558667 -90.40929709999999
3 9/6/2016 Tampa, Florida 27.950575 -82.4571776
4 9/7/2016 New York City, New York 40.7127837 -74.00594129999999
5 9/8/2016 Charlotte, North Carolina 35.2270869 -80.8431267
6 9/8/2016 Kansas City, Missouri 39.0997265 -94.5785667
7 9/9/2016 New York City, New York 40.7127837 -74.00594129999999
8 9/12/2016 New York City, New York 40.7127837 -74.00594129999999
9 9/15/2016 Greensboro, North Carolina 36.072635399999996 -79.79197540000001
10 9/15/2016 Washington, DC 38.9071923 -77.03687070000001
11 9/16/2016 Washington, DC 38.9071923 -77.03687070000001
12 9/17/2016 Washington, DC 38.9071923 -77.03687070000001
13 9/19/2016 Philadelphia, Pennsylvania 39.9525839 -75.1652215
14 9/19/2016 New York City, New York 40.7127837 -74.00594129999999
15 9/21/2016 Orlando, Florida 28.5383355 -81.3792365
16 9/26/2016 Hempstead, New York 40.706212799999996 -73.6187397
17 9/27/2016 Raleigh, North Carolina 35.7795897 -78.6381787
18 9/28/2016 Durham, New Hampshire 43.1339545 -70.9264393
19 9/29/2016 Des Moines, Iowa 41.600544799999994 -93.6091064
20 9/30/2016 Fort Pierce, Florida 27.446705600000005 -80.3256056
21 9/30/2016 Coral Springs, Florida 26.271192 -80.27060440000001
22 10/2/2016 Charlotte, North Carolina 35.2270869 -80.8431267
23 10/3/2016 Toledo, Ohio 41.6639383 -83.555212
24 10/3/2016 Akron, Ohio 41.081444700000006 -81.51900529999999
25 10/4/2016 Haverford, Pennsylvania 40.0022406 -75.32081070000001
26 10/4/2016 Harrisburg, Pennsylvania 40.273191100000005 -76.88670079999999
27 10/5/2016 Washington, DC 38.9071923 -77.03687070000001
28 10/9/2016 St. Louis, Missouri 38.6105426 -90.33718890000002
29 10/10/2016 Detroit, Michigan 42.331427000000005 -83.0457538
30 10/10/2016 Columbus, Ohio 39.9611755 -82.9987942
31 10/11/2016 Miami, Florida 25.7616798 -80.1917902
32 10/12/2016 Pueblo, Colorado 38.2544472 -104.60914090000001
33 10/12/2016 Las Vegas, Nevada 36.169941200000004 -115.13982959999998
34 10/13/2016 San Francisco, California 37.7749295 -122.4194155
35 10/14/2016 Burbank, California 34.18083920000001 -118.30896609999998
36 10/19/2016 Las Vegas, Nevada 36.169941200000004 -115.13982959999998
37 10/20/2016 New York City, New York 40.7127837 -74.00594129999999
38 10/21/2016 Cleveland, Ohio 41.499320000000004 -81.6943605
39 10/22/2016 Pittsburgh, Pennsylvania 40.440624799999995 -79.9958864
40 10/22/2016 Philadelphia, Pennsylvania 39.9525839 -75.1652215
41 10/23/2016 Charlotte, North Carolina 35.2270869 -80.8431267
42 10/23/2016 Raleigh, North Carolina 35.7795897 -78.6381787
43 10/24/2016 Manchester, New Hampshire 42.995639700000005 -71.4547891
44 10/25/2016 Coconut Creek, Florida 26.2517482 -80.17893509999999
45 10/26/2016 Lake Worth, Florida 26.6167555 -80.06844790000001
46 10/26/2016 Tampa, Florida 27.950575 -82.4571776
47 10/27/2016 Winston Salem, North Carolina 36.0998596 -80.24421600000001
48 10/27/2016 New York City, New York 40.7127837 -74.00594129999999
49 10/28/2016 Cedar Rapids, Iowa 41.9778795 -91.66562320000001
50 10/28/2016 Des Moines, Iowa 41.600544799999994 -93.6091064
51 10/29/2016 Daytona Beach, Florida 29.2108147 -81.02283309999999
52 10/30/2016 Wilton Manors, Florida 26.160362600000003 -80.13893399999999
53 10/31/2016 Kent, Ohio 41.1536674 -81.3578859
54 10/31/2016 Cincinnati, Ohio 39.103118200000004 -84.5120196
55 11/1/2016 Dade City, Florida 28.3647248 -82.19591779999999
56 11/1/2016 Sanford, Florida 28.802861199999995 -81.269453
57 11/1/2016 Fort Lauderdale, Florida 26.122438600000002 -80.13731740000001
58 11/2/2016 Tempe, Arizona 33.4255104 -111.9400054
59 11/2/2016 Las Vegas, Nevada 36.169941200000004 -115.13982959999998
60 11/3/2016 Greenville, North Carolina 35.612660999999996 -77.3663538
61 11/3/2016 Raleigh, North Carolina 35.7795897 -78.6381787
62 11/4/2016 Pittsburgh, Pennsylvania 40.440624799999995 -79.9958864
63 11/4/2016 Detroit, Michigan 42.331427000000005 -83.0457538
64 11/5/2016 Pembroke Pines, Florida 26.007765 -80.2962555
65 11/6/2016 Cleveland, Ohio 41.499320000000004 -81.6943605
66 11/6/2016 Manchester, New Hampshire 42.995639700000005 -71.4547891
67 11/7/2016 Oakland, Pennsylvania 40.4420135 -79.9625521
68 11/7/2016 Allendale, Michigan 42.9721861 -85.95402179999999
69 11/7/2016 Philadelphia, Pennsylvania 39.9525839 -75.1652215
70 11/7/2016 Raleigh, North Carolina 35.7795897 -78.6381787
71 11/9/2016 New York City, New York 40.7127837 -74.00594129999999

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "presidential-campaign-trail/clinton" (
"date" TEXT,
  "location" TEXT,
  "lat" REAL,
  "lng" REAL
);
Powered by Datasette · Query took 16.181ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub