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

106 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ date location lat lng
1 1 9/1/2016 Wilmington, OH 39.4453393 -83.8285375
2 2 9/3/2016 Detroit, MI 42.331427 -83.0457538
3 3 9/6/2016 Virginia Beach, VA 36.8529263 -75.977985
4 4 9/6/2016 Greenville, NC 35.612661 -77.3663538
5 5 9/7/2016 New York, NY 40.7127837 -74.0059413
6 6 9/9/2016 NW, Washington, DC 38.9071923 -77.0368707
7 7 9/9/2016 Pensacola, FL 30.421309 -87.2169149
8 8 9/12/2016 Baltimore, MD 39.2903848 -76.6121893
9 9 9/12/2016 Asheville, NC 35.5950581 -82.5514869
10 10 9/13/2016 Des Moines, IA 41.6005448 -93.6091064
11 11 9/13/2016 Aston, PA 39.8648194 -75.4257325
12 12 9/14/2016 Canton, OH 40.7989473 -81.378447
13 13 9/15/2016 New York, NY 40.7127837 -74.0059413
14 14 9/15/2016 Laconia, NH 43.5278546 -71.4703509
15 15 9/16/2016 Washington DC 38.9071923 -77.0368707
16 16 9/16/2016 Miami, FL 25.7616798 -80.1917902
17 17 9/17/2016 Houston, TX 29.7604267 -95.3698028
18 18 9/17/2016 Colorado Springs, CO 38.8338816 -104.8213634
19 19 9/19/2016 Fort Myers, FL 26.640628 -81.8723084
20 20 9/20/2016 High Point, NC 35.9556923 -80.0053176
21 21 9/20/2016 Kenansville, NC 34.9623883 -77.9622069
22 22 9/21/2016 Toledo, OH 41.6639383 -83.555212
23 23 9/22/2016 Chester Township, PA 39.8517618 -75.4024228
24 24 9/24/2016 Roanoke, VA 37.2709704 -79.9414266
25 25 9/26/2016 Hemstead, NY 40.7062128 -73.6187397
26 26 9/27/2016 Melbourne, FL 28.0836269 -80.6081089
27 27 9/28/2016 Council Bluffs, IA 41.2619444 -95.8608333
28 28 9/28/2016 Waukesha, WI 43.0116784 -88.2314813
29 29 9/29/2016 Bedfor, NH 42.9463291 -71.5132008
30 30 9/30/2016 Novi, MI 42.48059 -83.4754913
31 31 10/1/2016 Manheim, PA 40.1634279 -76.3949614
32 32 10/3/2016 Pueblo, CO 38.2544472 -104.6091409
33 33 10/3/2016 Loveland, CO 40.3977612 -105.0749801
34 34 10/4/2016 Prescott, Valley, AZ 34.6100243 -112.315721
35 35 10/5/2016 Henderson, NV 36.0395247 -114.9817213
36 36 10/5/2016 Reno, NV 39.5296329 -119.8138027
37 37 10/6/2016 Sandown, NH 42.928698 -71.1870053
38 38 10/9/2016 St. Louis, MO 38.6105426 -90.3371889
39 39 10/10/2016 Ambridge, PA 40.5892339 -80.22506
40 40 10/10/2016 Wilkes-Barre, PA 41.2459149 -75.8813075
41 41 10/11/2016 Panama City, FL 30.1588129 -85.6602058
42 42 10/12/2016 Ocala, FL 29.1871986 -82.1400923
43 43 10/12/2016 Lakeland, FL 28.0394654 -81.9498042
44 44 10/13/2016 West Palm Beach, FL 26.7153424 -80.0533746
45 45 10/13/2016 Cincinnati, OH 39.1031182 -84.5120196
46 46 10/14/2016 Greensboro, NC 36.0726354 -79.7919754
47 47 10/14/2016 Charlotte, NC 35.2270869 -80.8431267
48 48 10/15/2016 Portsmouth, NH 43.0717552 -70.7625532
49 49 10/15/2016 Bangor, ME 44.8011821 -68.7778138
50 50 10/17/2016 Green Bay, WI 44.519159 -88.019826
51 51 10/18/2016 Colorado Springs, CO 38.8338816 -104.8213634
52 52 10/18/2016 Grand Junction, CO 39.0638705 -108.5506486
53 53 10/19/2016 Las Vegas, NV 36.1699412 -115.1398296
54 54 10/20/2016 Deleware, OH 40.2986724 -83.067965
55 55 10/20/2016 New York, NY 40.7127837 -74.0059413
56 56 10/21/2016 Fletcher, NC 35.4306712 -82.5012316
57 57 10/21/2016 Johnstown, PA 40.3267407 -78.9219698
58 58 10/21/2016 Newtown, PA 40.2283371 -74.9322596
59 59 10/22/2016 Gettysburg, PA 39.8309293 -77.2310955
60 60 10/22/2016 Virginia Beach, VA 36.8529263 -75.977985
61 61 10/22/2016 Cleveland, OH 41.49932 -81.6943605
62 62 10/23/2016 Naples, FL 26.1420358 -81.7948103
63 63 10/24/2016 St. Augustine, FL 29.9012437 -81.3124341
64 64 10/24/2016 Tampa, FL 27.950575 -82.4571776
65 65 10/25/2016 Sanford, FL 28.8028612 -81.269453
66 66 10/25/2016 Tallahassee, FL 30.4382559 -84.2807329
67 67 10/26/2016 Kinston, NC 35.2626635 -77.5816353
68 68 10/27/2016 Springfield, OH 39.9242266 -83.8088171
69 69 10/27/2016 Toledo, OH 41.6639383 -83.555212
70 70 10/27/2016 Geneva, OH 41.8050539 -80.9481489
71 71 10/28/2016 Manchester, NH 42.9956397 -71.4547891
72 72 10/28/2016 Lisbon, ME 44.0316013 -70.1043704
73 73 10/28/2016 Cedar Rapids, IA 41.9778795 -91.6656232
74 74 10/29/2016 Golden, CO 39.755543 -105.2210997
75 75 10/29/2016 Pheonix, AZ 33.4483771 -112.0740373
76 76 10/30/2016 Las Vegas, NV 36.1699412 -115.1398296
77 77 10/30/2016 Greeley, CO 40.4233142 -104.7091322
78 78 10/30/2016 Albuquerque, NM 35.0853336 -106.6055534
79 79 10/31/2016 Grand Rapids, MI 42.9633599 -85.6680863
80 80 10/31/2016 Warren, MI 42.5144566 -83.0146526
81 81 11/1/2016 Valley Forge, PA 40.0989851 -75.4690966
82 82 11/1/2016 Eau Claire, WI 44.811349 -91.4984941
83 83 11/2/2016 Miami, FL 25.7616798 -80.1917902
84 84 11/2/2016 Orlando, FL 28.5383355 -81.3792365
85 85 11/2/2016 Pensacola, FL 30.421309 -87.2169149
86 86 11/3/2016 Jacksonville, FL 30.3321838 -81.655651
87 87 11/3/2016 Concord, NC 35.4087517 -80.579511
88 88 11/3/2016 Selma, NC 35.5365485 -78.2844435
89 89 11/4/2016 Atkinson, NH 42.8384221 -71.1470037
90 90 11/4/2016 Wilmington, OH 39.4453393 -83.8285375
91 91 11/4/2016 Hershey, PA 40.2859239 -76.6502468
92 92 11/5/2016 Tampa, FL 27.950575 -82.4571776
93 93 11/5/2016 Wilmington, NC 34.2257255 -77.9447102
94 94 11/5/2016 Reno, NV 39.5296329 -119.8138027
95 95 11/5/2016 Denver, CO 39.7392358 -104.990251
96 96 11/6/2016 Sioux City, IA 42.4999942 -96.4003069
97 97 11/6/2016 Minneapolis, MN 44.977753 -93.2650108
98 98 11/6/2016 Sterling Heights, MI 42.5803122 -83.0302033
99 99 11/6/2016 Moon Township, PA 40.5169767 -80.2213477
100 100 11/6/2016 Leesburg, VA 39.1156615 -77.5636015

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