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
101 11/7/2016 Sarasota, FL 27.3364347 -82.5306527
102 11/7/2016 Raleigh, NC 35.7795897 -78.6381787
103 11/7/2016 Scaranton, PA 41.408969 -75.66241219999999
104 11/7/2016 Manchester, NH 42.995639700000005 -71.4547891
105 11/7/2016 Grand Rapids, MI 42.9633599 -85.6680863
106 11/8/2016 New York, NY 40.7127837 -74.00594129999999

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 8.473ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub