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

4 rows where president = 33

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ president president_name title date city state building room
1 1 33 Harry Truman Commencement Address at Princeton University. 6/17/47 Princeton NJ Princeton University Nassau Hall
2 2 33 Harry Truman Commencement Address at the University of California. 6/12/48 Berkeley CA    
3 3 33 Harry Truman Commencement Address at the University of Missouri. 6/9/50 Columbia MO    
4 4 33 Harry Truman Commencement Address at Howard University. 6/13/52 Washington DC Howard University unknown

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