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

25 rows where president = 42

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, city, state, building

Link rowid ▼ president president_name title date city state building room
86 86 42 Bill Clinton Remarks at the New Hampshire Technical College Commencement Ceremony in Stratham, New Hampshire 5/22/93 Stratham NH    
87 87 42 Bill Clinton Remarks at the United States Military Academy Commencement Ceremony in West Point, New York 5/29/93 West Point NY    
88 88 42 Bill Clinton Remarks at the Northeastern University Commencement Ceremony in Boston, Massachusetts 6/19/93 Boston MA    
89 89 42 Bill Clinton Remarks at the Gallaudet University Commencement Ceremony 5/13/94 Washington DC Gallaudet University unknown
90 90 42 Bill Clinton Remarks at the United States Naval Academy Commencement Ceremony in Annapolis, Maryland 5/25/94 Annapolis MD    
91 91 42 Bill Clinton Remarks at the Michigan State University Commencement Ceremony in East Lansing, Michigan 5/5/95 East Lansing MI    
92 92 42 Bill Clinton Remarks at the United States Air Force Academy Commencement Ceremony in Colorado Springs, Colorado 5/31/95 Colorado Springs CO    
93 93 42 Bill Clinton Remarks at the Dartmouth College Commencement Ceremony in Hanover, New Hampshire 6/11/95 Hanover NH    
94 94 42 Bill Clinton Remarks at the Pennsylvania State University Graduate School Commencement in State College, Pennsylvania 5/10/96 State College PA    
95 95 42 Bill Clinton Remarks at the United States Coast Guard Academy Commencement in New London, Connecticut 5/22/96 New London CT    
96 96 42 Bill Clinton Remarks at the Princeton University Commencement Ceremony in Princeton, New Jersey 6/4/96 Princeton NJ    
97 97 42 Bill Clinton Commencement Address at Morgan State University in Baltimore, Maryland 5/18/97 Baltimore MD    
98 98 42 Bill Clinton Commencement Address at the United States Military Academy in West Point, New York 5/31/97 West Point NY    
99 99 42 Bill Clinton Commencement Address at the Sidwell Friends School 6/6/97 Washington DC Sidwell Friends School Gymnasium
100 100 42 Bill Clinton Commencement Address at the University of California San Diego in La Jolla, California 6/14/97 La Jolla CA University of California  
101 101 42 Bill Clinton Remarks at a Commencement Luncheon at the University of California San Diego in La Jolla 6/14/97 La Jolla CA University of California  
102 102 42 Bill Clinton Commencement Address at the United States Naval Academy in Annapolis, Maryland 5/22/98 Annapolis MD    
103 103 42 Bill Clinton Commencement Address at the Massachusetts Institute of Technology in Cambridge, Massachusetts 6/5/98 Cambridge MA    
104 104 42 Bill Clinton Commencement Address at Portland State University in Portland, Oregon 6/13/98 Portland OR    
105 105 42 Bill Clinton Commencement Address at Grambling State University in Grambling, Louisiana 5/23/99 Grambling LA    
106 106 42 Bill Clinton Commencement Address at the United States Air Force Academy in Colorado Springs 6/2/99 Colorado Springs CO    
107 107 42 Bill Clinton Commencement Address at the University of Chicago in Chicago, Illinois 6/12/99 Chicago IL    
108 108 42 Bill Clinton Commencement Address at Eastern Michigan University in Ypsilanti, Michigan 4/30/00 Ypsilanti MI    
109 109 42 Bill Clinton Commencement Address at the United States Coast Guard Academy in New London, Connecticut 5/17/00 New London CT    
110 110 42 Bill Clinton Commencement Address at Carleton College in Northfield, Minnesota 6/10/00 Northfield MN    

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