Presidential Campaign Trail: clinton.csv

Table actions

This table contains data behind the story The Last 10 Weeks Of 2016 Campaign Stops In One Handy Gif.

Header Definition
date The date of the event
location The location of the event
city The city of the event
state The state of the event
lat Latitude of the event location
lng Longitude of the event location

Sources: hillaryspeeches.com conservativedailynews.com

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

71 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state

Link rowid ▼ date location city state lat lng
1 1 9/5/2016 Cleveland, Ohio Cleveland OH 41.49932 -81.6943605
2 2 9/5/2016 Hampton, Illinois Hampton IL 41.5558667 -90.4092971
3 3 9/6/2016 Tampa, Florida Tampa FL 27.950575 -82.4571776
4 4 9/7/2016 New York City, New York New York NY 40.7127837 -74.0059413
5 5 9/8/2016 Charlotte, North Carolina Charlotte NC 35.2270869 -80.8431267
6 6 9/8/2016 Kansas City, Missouri Kansas City MO 39.0997265 -94.5785667
7 7 9/9/2016 New York City, New York New York NY 40.7127837 -74.0059413
8 8 9/12/2016 New York City, New York New York NY 40.7127837 -74.0059413
9 9 9/15/2016 Greensboro, North Carolina Greensboro NC 36.0726354 -79.7919754
10 10 9/15/2016 Washington, DC Washington DC 38.9071923 -77.0368707
11 11 9/16/2016 Washington, DC Washington DC 38.9071923 -77.0368707
12 12 9/17/2016 Washington, DC Washington DC 38.9071923 -77.0368707
13 13 9/19/2016 Philadelphia, Pennsylvania Philadelphia PA 39.9525839 -75.1652215
14 14 9/19/2016 New York City, New York New York NY 40.7127837 -74.0059413
15 15 9/21/2016 Orlando, Florida Orlando FL 28.5383355 -81.3792365
16 16 9/26/2016 Hempstead, New York Hempstead NY 40.7062128 -73.6187397
17 17 9/27/2016 Raleigh, North Carolina Raleigh NC 35.7795897 -78.6381787
18 18 9/28/2016 Durham, New Hampshire Durham NH 43.1339545 -70.9264393
19 19 9/29/2016 Des Moines, Iowa Des Moines IA 41.6005448 -93.6091064
20 20 9/30/2016 Fort Pierce, Florida Fort Pierce FL 27.4467056 -80.3256056
21 21 9/30/2016 Coral Springs, Florida Coral Springs FL 26.271192 -80.2706044
22 22 10/2/2016 Charlotte, North Carolina Charlotte NC 35.2270869 -80.8431267
23 23 10/3/2016 Toledo, Ohio Toledo OH 41.6639383 -83.555212
24 24 10/3/2016 Akron, Ohio Akron OH 41.0814447 -81.5190053
25 25 10/4/2016 Haverford, Pennsylvania Haverford PA 40.0022406 -75.3208107
26 26 10/4/2016 Harrisburg, Pennsylvania Harrisburg PA 40.2731911 -76.8867008
27 27 10/5/2016 Washington, DC Washington DC 38.9071923 -77.0368707
28 28 10/9/2016 St. Louis, Missouri St. Louis MO 38.6105426 -90.3371889
29 29 10/10/2016 Detroit, Michigan Detroit MI 42.331427 -83.0457538
30 30 10/10/2016 Columbus, Ohio Columbus OH 39.9611755 -82.9987942
31 31 10/11/2016 Miami, Florida Miami FL 25.7616798 -80.1917902
32 32 10/12/2016 Pueblo, Colorado Pueblo CO 38.2544472 -104.6091409
33 33 10/12/2016 Las Vegas, Nevada Las Vegas NV 36.1699412 -115.1398296
34 34 10/13/2016 San Francisco, California San Francisco CA 37.7749295 -122.4194155
35 35 10/14/2016 Burbank, California Burbank CA 34.1808392 -118.3089661
36 36 10/19/2016 Las Vegas, Nevada Las Vegas NV 36.1699412 -115.1398296
37 37 10/20/2016 New York City, New York New York NY 40.7127837 -74.0059413
38 38 10/21/2016 Cleveland, Ohio Cleveland OH 41.49932 -81.6943605
39 39 10/22/2016 Pittsburgh, Pennsylvania Pittsburgh PA 40.4406248 -79.9958864
40 40 10/22/2016 Philadelphia, Pennsylvania Philadelphia PA 39.9525839 -75.1652215
41 41 10/23/2016 Charlotte, North Carolina Charlotte NC 35.2270869 -80.8431267
42 42 10/23/2016 Raleigh, North Carolina Raleigh NC 35.7795897 -78.6381787
43 43 10/24/2016 Manchester, New Hampshire Manchester NH 42.9956397 -71.4547891
44 44 10/25/2016 Coconut Creek, Florida Coconut Creek FL 26.2517482 -80.1789351
45 45 10/26/2016 Lake Worth, Florida Lake Worth FL 26.6167555 -80.0684479
46 46 10/26/2016 Tampa, Florida Tampa FL 27.950575 -82.4571776
47 47 10/27/2016 Winston Salem, North Carolina Winston Salem NC 36.0998596 -80.244216
48 48 10/27/2016 New York City, New York New York NY 40.7127837 -74.0059413
49 49 10/28/2016 Cedar Rapids, Iowa Cedar Rapids IA 41.9778795 -91.6656232
50 50 10/28/2016 Des Moines, Iowa Des Moines IA 41.6005448 -93.6091064
51 51 10/29/2016 Daytona Beach, Florida Daytona Beach FL 29.2108147 -81.0228331
52 52 10/30/2016 Wilton Manors, Florida Wilton Manors FL 26.1603626 -80.138934
53 53 10/31/2016 Kent, Ohio Kent OH 41.1536674 -81.3578859
54 54 10/31/2016 Cincinnati, Ohio Cincinnati OH 39.1031182 -84.5120196
55 55 11/1/2016 Dade City, Florida Dade City FL 28.3647248 -82.1959178
56 56 11/1/2016 Sanford, Florida Sanford FL 28.8028612 -81.269453
57 57 11/1/2016 Fort Lauderdale, Florida Fort Lauderdale FL 26.1224386 -80.1373174
58 58 11/2/2016 Tempe, Arizona Tempe AZ 33.4255104 -111.9400054
59 59 11/2/2016 Las Vegas, Nevada Las Vegas NV 36.1699412 -115.1398296
60 60 11/3/2016 Greenville, North Carolina Greenville NC 35.612661 -77.3663538
61 61 11/3/2016 Raleigh, North Carolina Raleigh NC 35.7795897 -78.6381787
62 62 11/4/2016 Pittsburgh, Pennsylvania Pittsburgh PA 40.4406248 -79.9958864
63 63 11/4/2016 Detroit, Michigan Detroit MI 42.331427 -83.0457538
64 64 11/5/2016 Pembroke Pines, Florida Pembroke Pines FL 26.007765 -80.2962555
65 65 11/6/2016 Cleveland, Ohio Cleveland OH 41.49932 -81.6943605
66 66 11/6/2016 Manchester, New Hampshire Manchester NH 42.9956397 -71.4547891
67 67 11/7/2016 Oakland, Pennsylvania Oakland PA 40.4420135 -79.9625521
68 68 11/7/2016 Allendale, Michigan Allendale MI 42.9721861 -85.9540218
69 69 11/7/2016 Philadelphia, Pennsylvania Philadelphia PA 39.9525839 -75.1652215
70 70 11/7/2016 Raleigh, North Carolina Raleigh NC 35.7795897 -78.6381787
71 71 11/9/2016 New York City, New York New York NY 40.7127837 -74.0059413

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "presidential-campaign-trail/clinton" (
"date" TEXT,
  "location" TEXT,
  "city" TEXT,
  "state" TEXT,
  "lat" REAL,
  "lng" REAL
);