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

6 rows where president = 35

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ president president_name title date city state building room
14 14 35 John Kennedy Remarks at Annapolis to the Graduating Class of the United States Naval Academy. 6/7/61 Annapolis MD    
15 15 35 John Kennedy Remarks at West Point to the Graduating Class of the U.S. Military Academy. 6/6/62 West Point NY    
16 16 35 John Kennedy Commencement Address at Yale University. 6/11/62 New Haven CT    
17 17 35 John Kennedy Remarks at Colorado Springs to the Graduating Class of the U.S. Air Force Academy. 6/5/63 Colorado Springs CO    
18 18 35 John Kennedy Commencement Address at San Diego State College. 6/6/63 San Diego CA    
19 19 35 John Kennedy Commencement Address at American University in Washington 6/10/63 Washington DC American University John M. Reeves Athletic Field

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