home / fivethirtyeight

Presidential Campaign Trail: clinton.csv

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

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

CSV options:

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