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_name = "Gerald Ford"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ president president_name title date city state building room
42 42 38 Gerald Ford Commencement Address at the University of Pennsylvania. 5/18/75 Philadelphia PA University of Pennsylvania  
43 43 38 Gerald Ford Commencement Address at the United States Military Academy. 6/4/75 West Point NY U.S. Military Academy Michie Stadium
44 44 38 Gerald Ford Remarks at Graduation Ceremonies at Holton-Arms School, Bethesda, Maryland. 6/5/75 Bethesda MD Holton-Arms School grounds
45 45 38 Gerald Ford Commencement Address at Chicago State University. 7/12/75 Chicago IL McCormick Place Arie Crown Theatre
46 46 38 Gerald Ford Commencement Address at the University of Nebraska in Lincoln. 5/8/76 Lincoln NE University of Nebraska Sports Center
47 47 38 Gerald Ford Commencement Address at Warner Pacific College in Portland. 5/23/76 Portland OR Warner Pacific College Center for Christian Ministers Auditorum

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