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_name = "Jimmy Carter"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ president president_name title date city state building room
48 48 39 Jimmy Carter UNIVERSITY OF NOTRE DAME - Address at Commencement Exercises at the University 5/22/77 Notre Dame IN    
49 49 39 Jimmy Carter United States Naval Academy Address at the Commencement Exercises. 6/7/78 Annapolis MD    
50 50 39 Jimmy Carter Capitol Page School Remarks to Members of the Graduating Class. 6/12/78 Washington DC White House Rose Garden
51 51 39 Jimmy Carter Cheyney State College Address at the Commencement Exercises 5/20/79 Cheyney PA Cheyney State College quadrangle

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