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
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

Link rowid ▼ date location lat lng
1 9/5/2016 Cleveland, Ohio 41.49932 -81.6943605
2 9/5/2016 Hampton, Illinois 41.5558667 -90.4092971
3 9/6/2016 Tampa, Florida 27.950575 -82.4571776
4 9/7/2016 New York City, New York 40.7127837 -74.0059413
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.0059413
8 9/12/2016 New York City, New York 40.7127837 -74.0059413
9 9/15/2016 Greensboro, North Carolina 36.0726354 -79.7919754
10 9/15/2016 Washington, DC 38.9071923 -77.0368707
11 9/16/2016 Washington, DC 38.9071923 -77.0368707
12 9/17/2016 Washington, DC 38.9071923 -77.0368707
13 9/19/2016 Philadelphia, Pennsylvania 39.9525839 -75.1652215
14 9/19/2016 New York City, New York 40.7127837 -74.0059413
15 9/21/2016 Orlando, Florida 28.5383355 -81.3792365
16 9/26/2016 Hempstead, New York 40.7062128 -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.6005448 -93.6091064
20 9/30/2016 Fort Pierce, Florida 27.4467056 -80.3256056
21 9/30/2016 Coral Springs, Florida 26.271192 -80.2706044
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.0814447 -81.5190053
25 10/4/2016 Haverford, Pennsylvania 40.0022406 -75.3208107
26 10/4/2016 Harrisburg, Pennsylvania 40.2731911 -76.8867008
27 10/5/2016 Washington, DC 38.9071923 -77.0368707
28 10/9/2016 St. Louis, Missouri 38.6105426 -90.3371889
29 10/10/2016 Detroit, Michigan 42.331427 -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.6091409
33 10/12/2016 Las Vegas, Nevada 36.1699412 -115.1398296
34 10/13/2016 San Francisco, California 37.7749295 -122.4194155
35 10/14/2016 Burbank, California 34.1808392 -118.3089661
36 10/19/2016 Las Vegas, Nevada 36.1699412 -115.1398296
37 10/20/2016 New York City, New York 40.7127837 -74.0059413
38 10/21/2016 Cleveland, Ohio 41.49932 -81.6943605
39 10/22/2016 Pittsburgh, Pennsylvania 40.4406248 -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.9956397 -71.4547891
44 10/25/2016 Coconut Creek, Florida 26.2517482 -80.1789351
45 10/26/2016 Lake Worth, Florida 26.6167555 -80.0684479
46 10/26/2016 Tampa, Florida 27.950575 -82.4571776
47 10/27/2016 Winston Salem, North Carolina 36.0998596 -80.244216
48 10/27/2016 New York City, New York 40.7127837 -74.0059413
49 10/28/2016 Cedar Rapids, Iowa 41.9778795 -91.6656232
50 10/28/2016 Des Moines, Iowa 41.6005448 -93.6091064
51 10/29/2016 Daytona Beach, Florida 29.2108147 -81.0228331
52 10/30/2016 Wilton Manors, Florida 26.1603626 -80.138934
53 10/31/2016 Kent, Ohio 41.1536674 -81.3578859
54 10/31/2016 Cincinnati, Ohio 39.1031182 -84.5120196
55 11/1/2016 Dade City, Florida 28.3647248 -82.1959178
56 11/1/2016 Sanford, Florida 28.8028612 -81.269453
57 11/1/2016 Fort Lauderdale, Florida 26.1224386 -80.1373174
58 11/2/2016 Tempe, Arizona 33.4255104 -111.9400054
59 11/2/2016 Las Vegas, Nevada 36.1699412 -115.1398296
60 11/3/2016 Greenville, North Carolina 35.612661 -77.3663538
61 11/3/2016 Raleigh, North Carolina 35.7795897 -78.6381787
62 11/4/2016 Pittsburgh, Pennsylvania 40.4406248 -79.9958864
63 11/4/2016 Detroit, Michigan 42.331427 -83.0457538
64 11/5/2016 Pembroke Pines, Florida 26.007765 -80.2962555
65 11/6/2016 Cleveland, Ohio 41.49932 -81.6943605
66 11/6/2016 Manchester, New Hampshire 42.9956397 -71.4547891
67 11/7/2016 Oakland, Pennsylvania 40.4420135 -79.9625521
68 11/7/2016 Allendale, Michigan 42.9721861 -85.9540218
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.0059413

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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