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

23 rows where president = 43

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: title, city, state

Link rowid ▼ president president_name title date city state building room
111 111 43 George W. Bush Commencement Address at the University of Notre Dame in Notre Dame, Indiana 5/20/01 Notre Dame IN    
112 112 43 George W. Bush Commencement Address at Yale University in New Haven, Connecticut 5/21/01 New Haven CT    
113 113 43 George W. Bush Commencement Address at the United States Naval Academy in Annapolis, Maryland 5/25/01 Annapolis MD    
114 114 43 George W. Bush Commencement Address at the United States Military Academy in West Point, New York 6/1/02 West Point NY    
115 115 43 George W. Bush Commencement Address at Ohio State University in Columbus, Ohio 6/14/02 Columbus OH    
116 116 43 George W. Bush Commencement Address at the University of South Carolina in Columbia, South Carolina 5/9/03 Columbia SC    
117 117 43 George W. Bush Commencement Address at the United States Coast Guard Academy in New London, Connecticut 5/21/03 New London CT    
118 118 43 George W. Bush Commencement Address at Concordia University Wisconsin in Mequon, Wisconsin 5/14/04 Mequon WI    
119 119 43 George W. Bush Commencement Address at Louisiana State University in Baton Rouge, Louisiana 5/21/04 Baton Rouge LA    
120 120 43 George W. Bush Commencement Address at the United States Air Force Academy in Colorado Springs, Colorado 6/2/04 Colorado Springs CO    
121 121 43 George W. Bush Commencement Address at Calvin College in Grand Rapids, Michigan 5/21/05 Grand Rapids MI    
122 122 43 George W. Bush Commencement Address at the United States Naval Academy in Annapolis, Maryland 5/27/05 Annapolis MD    
123 123 43 George W. Bush Commencement Address at Oklahoma State University in Stillwater, Oklahoma 5/6/06 Stillwater OK    
124 124 43 George W. Bush Commencement Address at Mississippi Gulf Coast Community College in Biloxi, Mississippi 5/11/06 Biloxi MS    
125 125 43 George W. Bush Commencement Address at the United States Military Academy in West Point, New York 5/27/06 West Point NY    
126 126 43 George W. Bush Commencement Address at the United States Merchant Marine Academy in Kings Point, New York 6/19/06 Kings Point NY    
127 127 43 George W. Bush Commencement Address at Miami Dade College—Kendall Campus in Miami, Florida 4/28/07 Miami FL    
128 128 43 George W. Bush Commencement Address at Saint Vincent College in Latrobe, Pennsylvania 5/11/07 Latrobe PA Saint Vincent College Robert S. Carey Student Center
129 129 43 George W. Bush Commencement Address at the United States Coast Guard Academy in New London, Connecticut 5/23/07 New London CT    
130 130 43 George W. Bush Commencement Address at Greensburg High School in Greensburg, Kansas 5/4/08 Greensburg KS Greensburg High School  
131 131 43 George W. Bush Commencement Address at the United States Air Force Academy in Colorado Springs, Colorado 5/28/08 Colorado Springs CO Air Force Academy  
132 132 43 George W. Bush Commencement Address at Furman University in Greenville, South Carolina 5/31/08 Greenville SC Furman University Paladin Stadium
133 133 43 George W. Bush Commencement Address at Texas A&M University in College Station, Texas 12/12/08 College Station TX Texas A&M University  

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