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

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