home / fivethirtyeight

Menu
  • GraphQL API

Presidential Commencement Speeches: commencement_speeches.csv

Table actions
  • GraphQL API for presidential-commencement-speeches/commencement_speeches

This table contains data behind the story Sitting Presidents Give Way More Commencement Speeches Than They Used To

Data does not include commencement speeches by President Obama in 2016.

Header Definition
president Number of president (33 is Harry Truman, the 33rd president; 44 is Barack Obama, the 44th president)
president_name Name of president
title Description of commencement speech
date Date speech was delivered
city City where speech was delivered
state state where speech was delivered
building Name of building in which speech was delivered
room Room in which speech was delivered

Source: American Presidency Project, Gerhard Peters and John T. Woolley

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

5 rows where president = 37

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ president president_name title date city state building room
37 37 37 Richard Nixon Address at the Air Force Academy Commencement Exercises in Colorado Springs, Colorado 6/4/69 Colorado Springs CO Air Force Academy Falcon Stadium
38 38 37 Richard Nixon Remarks at the Graduation Ceremony of the Capitol Page School. 6/12/69 Washington DC White House Rose Garden
39 39 37 Richard Nixon Remarks at Commencement Exercises of Florida Technological University, Orlando, Florida. 6/8/73 Orlando FL    
40 40 37 Richard Nixon Remarks at Commencement Exercises at Oklahoma State University, Stillwater, Oklahoma. 5/11/74 Stillwater OK    
41 41 37 Richard Nixon Remarks at Commencement Ceremonies at the United States Naval Academy, Annapolis, Maryland. 6/5/74 Annapolis MD    

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "presidential-commencement-speeches/commencement_speeches" (
"president" INTEGER,
  "president_name" TEXT,
  "title" TEXT,
  "date" TEXT,
  "city" TEXT,
  "state" TEXT,
  "building" TEXT,
  "room" TEXT
);
Powered by Datasette · Queries took 9.88ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette