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

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array

CSV options:

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