home / fivethirtyeight

Presidential Campaign Trail: trump.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

106 rows sorted by lat

View and edit SQL

Link rowid date location lat ▼ lng
16 9/16/2016 Miami, FL 25.7616798 -80.1917902
83 11/2/2016 Miami, FL 25.7616798 -80.1917902
62 10/23/2016 Naples, FL 26.142035800000002 -81.7948103
19 9/19/2016 Fort Myers, FL 26.640628000000003 -81.87230840000001
44 10/13/2016 West Palm Beach, FL 26.7153424 -80.0533746
101 11/7/2016 Sarasota, FL 27.3364347 -82.5306527
64 10/24/2016 Tampa, FL 27.950575 -82.4571776
92 11/5/2016 Tampa, FL 27.950575 -82.4571776
43 10/12/2016 Lakeland, FL 28.039465399999997 -81.9498042
26 9/27/2016 Melbourne, FL 28.0836269 -80.6081089
84 11/2/2016 Orlando, FL 28.5383355 -81.3792365
65 10/25/2016 Sanford, FL 28.802861199999995 -81.269453
42 10/12/2016 Ocala, FL 29.187198600000002 -82.14009229999999
17 9/17/2016 Houston, TX 29.7604267 -95.36980279999999
63 10/24/2016 St. Augustine, FL 29.9012437 -81.31243409999999
41 10/11/2016 Panama City, FL 30.158812899999997 -85.6602058
86 11/3/2016 Jacksonville, FL 30.3321838 -81.655651
7 9/9/2016 Pensacola, FL 30.421309 -87.2169149
85 11/2/2016 Pensacola, FL 30.421309 -87.2169149
66 10/25/2016 Tallahassee, FL 30.4382559 -84.2807329
75 10/29/2016 Pheonix, AZ 33.4483771 -112.07403729999999
93 11/5/2016 Wilmington, NC 34.2257255 -77.9447102
34 10/4/2016 Prescott, Valley, AZ 34.6100243 -112.315721
21 9/20/2016 Kenansville, NC 34.9623883 -77.9622069
78 10/30/2016 Albuquerque, NM 35.0853336 -106.6055534
47 10/14/2016 Charlotte, NC 35.2270869 -80.8431267
67 10/26/2016 Kinston, NC 35.2626635 -77.5816353
87 11/3/2016 Concord, NC 35.4087517 -80.579511
56 10/21/2016 Fletcher, NC 35.430671200000006 -82.5012316
88 11/3/2016 Selma, NC 35.5365485 -78.28444350000001
9 9/12/2016 Asheville, NC 35.5950581 -82.5514869
4 9/6/2016 Greenville, NC 35.612660999999996 -77.3663538
102 11/7/2016 Raleigh, NC 35.7795897 -78.6381787
20 9/20/2016 High Point, NC 35.955692299999995 -80.0053176
35 10/5/2016 Henderson, NV 36.0395247 -114.9817213
46 10/14/2016 Greensboro, NC 36.072635399999996 -79.79197540000001
53 10/19/2016 Las Vegas, NV 36.169941200000004 -115.13982959999998
76 10/30/2016 Las Vegas, NV 36.169941200000004 -115.13982959999998
3 9/6/2016 Virginia Beach, VA 36.8529263 -75.977985
60 10/22/2016 Virginia Beach, VA 36.8529263 -75.977985
24 9/24/2016 Roanoke, VA 37.270970399999996 -79.9414266
32 10/3/2016 Pueblo, CO 38.2544472 -104.60914090000001
38 10/9/2016 St. Louis, MO 38.6105426 -90.33718890000002
18 9/17/2016 Colorado Springs, CO 38.8338816 -104.82136340000001
51 10/18/2016 Colorado Springs, CO 38.8338816 -104.82136340000001
6 9/9/2016 NW, Washington, DC 38.9071923 -77.03687070000001
15 9/16/2016 Washington DC 38.9071923 -77.03687070000001
52 10/18/2016 Grand Junction, CO 39.0638705 -108.5506486
45 10/13/2016 Cincinnati, OH 39.103118200000004 -84.5120196
100 11/6/2016 Leesburg, VA 39.1156615 -77.5636015
8 9/12/2016 Baltimore, MD 39.2903848 -76.6121893
1 9/1/2016 Wilmington, OH 39.4453393 -83.8285375
90 11/4/2016 Wilmington, OH 39.4453393 -83.8285375
36 10/5/2016 Reno, NV 39.529632899999996 -119.8138027
94 11/5/2016 Reno, NV 39.529632899999996 -119.8138027
95 11/5/2016 Denver, CO 39.739235799999996 -104.990251
74 10/29/2016 Golden, CO 39.755542999999996 -105.2210997
59 10/22/2016 Gettysburg, PA 39.830929299999994 -77.2310955
23 9/22/2016 Chester Township, PA 39.8517618 -75.4024228
11 9/13/2016 Aston, PA 39.864819399999995 -75.4257325
68 10/27/2016 Springfield, OH 39.9242266 -83.8088171
81 11/1/2016 Valley Forge, PA 40.0989851 -75.46909659999999
31 10/1/2016 Manheim, PA 40.163427899999995 -76.3949614
58 10/21/2016 Newtown, PA 40.228337100000005 -74.9322596
91 11/4/2016 Hershey, PA 40.2859239 -76.6502468
54 10/20/2016 Deleware, OH 40.2986724 -83.067965
57 10/21/2016 Johnstown, PA 40.3267407 -78.9219698
33 10/3/2016 Loveland, CO 40.397761200000005 -105.0749801
77 10/30/2016 Greeley, CO 40.42331420000001 -104.7091322
99 11/6/2016 Moon Township, PA 40.51697670000001 -80.22134770000001
39 10/10/2016 Ambridge, PA 40.589233899999996 -80.22506
25 9/26/2016 Hemstead, NY 40.706212799999996 -73.6187397
5 9/7/2016 New York, NY 40.7127837 -74.00594129999999
13 9/15/2016 New York, NY 40.7127837 -74.00594129999999
55 10/20/2016 New York, NY 40.7127837 -74.00594129999999
106 11/8/2016 New York, NY 40.7127837 -74.00594129999999
12 9/14/2016 Canton, OH 40.7989473 -81.378447
40 10/10/2016 Wilkes-Barre, PA 41.245914899999995 -75.88130749999999
27 9/28/2016 Council Bluffs, IA 41.2619444 -95.8608333
103 11/7/2016 Scaranton, PA 41.408969 -75.66241219999999
61 10/22/2016 Cleveland, OH 41.499320000000004 -81.6943605
10 9/13/2016 Des Moines, IA 41.600544799999994 -93.6091064
22 9/21/2016 Toledo, OH 41.6639383 -83.555212
69 10/27/2016 Toledo, OH 41.6639383 -83.555212
70 10/27/2016 Geneva, OH 41.8050539 -80.9481489
73 10/28/2016 Cedar Rapids, IA 41.9778795 -91.66562320000001
2 9/3/2016 Detroit, MI 42.331427000000005 -83.0457538
30 9/30/2016 Novi, MI 42.48059 -83.47549129999999
96 11/6/2016 Sioux City, IA 42.4999942 -96.4003069
80 10/31/2016 Warren, MI 42.5144566 -83.01465259999999
98 11/6/2016 Sterling Heights, MI 42.5803122 -83.0302033
89 11/4/2016 Atkinson, NH 42.8384221 -71.1470037
37 10/6/2016 Sandown, NH 42.928698 -71.1870053
29 9/29/2016 Bedfor, NH 42.9463291 -71.51320079999999
79 10/31/2016 Grand Rapids, MI 42.9633599 -85.6680863
105 11/7/2016 Grand Rapids, MI 42.9633599 -85.6680863
71 10/28/2016 Manchester, NH 42.995639700000005 -71.4547891
104 11/7/2016 Manchester, NH 42.995639700000005 -71.4547891
28 9/28/2016 Waukesha, WI 43.0116784 -88.2314813
48 10/15/2016 Portsmouth, NH 43.071755200000005 -70.7625532

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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