State of the State: index.csv

Table actions

This table contains the data behind the story What America’s Governors Are Talking About.

index.csv contains a listing of each of the 50 speeches, one for each state as well as the name and party of the state's governor and a link to an official source for the speech. If an official government source could not be found, we have linked to a news media source that had a transcript of the speech.

The speeches/ folder contains 50 .txt files containing the text of each of the speeches.

words.csv contains every one-word phrase that was mentioned in at least 10 speeches and every two- or three-word phrase that was mentioned in at least five speeches after a list of stop-words was removed and the word "healthcare" was replaced with "health care" so that they were not counted as distinct phrases. It also contains the results of a chi^2 test that shows the statistical significance of and associated p-value of phrases.

Column Definition
n-gram one-, two- or three-word phrase
category thematic categories for n-grams hand-coded by FiveThirtyEight staff: economy/fiscal issues, education, health care, energy/environment, crime/justice, mental health/substance abuse
d_speeches number of Democratic speeches containing the n-gram
r_speeches number of Republican speeches containing the n-gram
total total number of speeches containing the n-gram
percent_of_d_speeches percent of the 23 Democratic speeches containing the phrase
percent_of_r_speeches percent of the 27 Republican speeches containing the phrase
chi2 chi^2 statistic
pval p-value for chi^2 test

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

50 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: party

Link rowid ▼ state governor party filename url
1 1 Alabama Kay Ivey R Alabama_SOTS.txt https://governor.alabama.gov/remarks-speeches/2019-state-of-the-state-address/
2 2 Alaska Mike Dunleavy R Alaska_SOTS.txt https://gov.alaska.gov/newsroom/2019/01/22/2019-state-of-the-state-address/
3 3 Arizona Doug Ducey R Arizona_SOTS.txt https://azgovernor.gov/governor/news/2019/01/governor-ducey-delivers-state-state-address
4 4 Arkansas Asa Hutchinson R Arkansas_SOTS.txt https://governor.arkansas.gov/news-media/speeches/2019-state-of-the-state
5 5 California Gavin Newsom D California_SOTS.txt https://www.gov.ca.gov/2019/02/12/state-of-the-state-address/
6 6 Colorado Jared Polis D Colorado_SOTS.txt http://www.cpr.org/news/story/2019-polis-colorado-state-of-the-state
7 7 Connecticut Ned Lamont D Connecticut_SOTS.txt https://portal.ct.gov/Office-of-the-Governor/News/Speeches/Governor-Lamont-2019-State-of-the-State-Address?platform=hootsuite
8 8 Delaware John Carney D Delaware_SOTS.txt https://governor.delaware.gov/wp-content/uploads/sites/24/2019/01/State-of-the-State-01172019.pdf
9 9 Florida Ron DeSantis R Florida_SOTS.txt https://www.flgov.com/2019/03/05/governor-desantis-state-of-the-state-address/
10 10 Georgia Brian Kemp R Georgia_SOTS.txt https://www.11alive.com/article/news/governor-brian-kemp-issues-first-state-of-the-state-address-read-full-transcript/85-7af10d01-6c5b-40cd-b991-2d11ac43d5ea
11 11 Hawaii David Ige D Hawaii_SOTS.txt https://governor.hawaii.gov/wp-content/uploads/2019/01/2019-State-of-the-State-Address-by-Governor-David-Ige.pdf
12 12 Idaho Brad Little R Idaho_SOTS.txt https://gov.idaho.gov/wp-content/uploads/sites/74/2019/01/2019-sos.pdf
13 13 Illinois JB Pritzker D Illinois_Both.txt https://www2.illinois.gov/sites/gov/newsroom/Documents/01.14.19InauguralSpeech.pdf
14 14 Indiana Eric Holcomb R Indiana_SOTS.txt https://www.in.gov/gov/3027.htm
15 15 Iowa Kim Reynolds R Iowa_SOTS.txt https://governor.iowa.gov/2019/01/gov-reynolds-to-deliver-condition-of-the-state-address
16 16 Kansas Laura Kelly D Kansas_SOTS.txt https://governor.kansas.gov/governor-laura-kellys-state-of-the-state-address/
17 17 Kentucky Matt Bevin R Kentucky_SOTS.txt https://ketorg.cdn.ket.org/wp-content/uploads/2018/01/2018-Bevin-budget-speech.pdf?_ga=2.204846416.1172937214.1550158485-1238189224.1485811080
18 18 Louisiana John Bel Edwards D Louisiana_SOTS.txt http://gov.louisiana.gov/index.cfm/newsroom/detail/1871
19 19 Maine Janet Mills D Maine_SOTS.txt https://www.maine.gov/governor/mills/news/governor-janet-mills-state-budget-address-2019-02-11
20 20 Maryland Larry Hogan R Maryland_SOTS.txt https://governor.maryland.gov/2019/01/30/2019-state-of-the-state-address/
21 21 Massachusetts Charlie Baker R Massachusetts_Both.txt https://www.mass.gov/news/governor-charlie-baker-delivers-inaugural-address-for-second-term
22 22 Michigan Gretchen Whitmer D Michigan_SOTS.txt https://www.michigan.gov/documents/whitmer/20190212-Speech-Whitmer-SOTS19_646125_7.pdf
23 23 Minnesota Tim Walz D Minnesota_SOTS.txt https://mn.gov/governor/news/#/detail/appId/1/id/378589
24 24 Mississippi Phil Bryant R Mississippi_SOTS.txt https://www.clarionledger.com/story/news/politics/2019/01/15/watch-live-gov-phil-bryants-state-state-address-text-speech-ms-leg/2581705002/
25 25 Missouri Mike Parson R Missouri_SOTS.txt https://www.mo.gov/wp-content/uploads/2019/01/2019-State-of-the-State-Text.pdf
26 26 Montana Steve Bullock D Montana_SOTS.txt http://governor.mt.gov/Pressroom/governor-steve-bullocks-2019-state-of-the-state-address
27 27 Nebraska Pete Ricketts R Nebraska_SOTS.txt https://governor.nebraska.gov/press/gov-ricketts-state-state-address
28 28 Nevada Steve Sisolak D Nevada_SOTS.txt http://gov.nv.gov/uploadedFiles/govnew.nv.gov/Content/News/Press/2019/Sisolak_SOTS.pdf
29 29 New Hampshire Chris Sununu R NewHampshire_Both.txt https://www.governor.nh.gov/news-media/speeches/inaugural-2019.htm
30 30 New Jersey Phil Murphy D NewJersey_SOTS.txt https://nj.gov/governor/news/addresses/approved/20190115_sos.shtml
31 31 New Mexico Michelle Lujan Grisham D NewMexico_SOTS.txt http://www.santafenewmexican.com/text-of-gov-lujan-grisham-s-first-state-of-the/article_9a7b5a6a-1926-11e9-8218-3bf11adbcd54.html
32 32 New York Andrew Cuomo D NewYork_SOTS.txt https://www.governor.ny.gov/news/video-audio-photos-rush-transcript-governor-cuomo-outlines-2019-justice-agenda-time-now
33 33 North Carolina Roy Cooper D NorthCarolina_SOTS.txt https://files.nc.gov/governor/documents/files/2019_State_of_the_State_0.pdf
34 34 North Dakota Doug Burgum R NorthDakota_SOTS.txt https://www.governor.nd.gov/sites/governor/files/documents/2019%20State%20of%20the%20State%20Final%20Copy.pdf
35 35 Ohio Mike DeWine R Ohio_SOTS.txt https://governor.ohio.gov/wps/wcm/connect/gov/5ee4eee4-b8ce-4bbe-8270-9e89036059c8/2019+State+of+the+State+Address.pdf?MOD=AJPERES&CONVERT_TO=url&CACHEID=ROOTWORKSPACE.Z18_M1HGGIK0N0JO00QO9DDDDM3000-5ee4eee4-b8ce-4bbe-8270-9e89036059c8-mBfX-ua
36 36 Oklahoma Kevin Stitt R Oklahoma_SOTS.txt https://www.tulsaworld.com/opinion/read-the-full-transcript-of-gov-kevin-stitt-s-state/article_92e71b97-ddba-5019-9f96-1bd1c8abf02a.html
37 37 Oregon Kate Brown D Oregon_Both.txt https://www.oregon.gov/gov/media/Pages/speeches/Governor-Kate-Brown-Inaugural-Address-2019.aspx
38 38 Pennsylvania Tom Wolf D Pennsylvania_SOTS.txt https://www.governor.pa.gov/remarks-by-governor-wolf-at-budget-address/
39 39 Rhode Island Gina Raimondo D RhodeIsland_SOTS.txt http://www.governor.ri.gov/newsroom/speeches/2019/state-of-the-state.php
40 40 South Carolina Henry McMaster R SouthCarolina_SOTS.txt https://governor.sc.gov/news/2019-01/state-state-address-prepared-delivery
41 41 South Dakota Kristi Noem R SouthDakota_SOTS.txt https://kelo.com/news/articles/2019/jan/09/transcript-gov-noems-state-of-the-state-address/
42 42 Tennessee Bill Lee R Tennessee_SOTS.txt https://www.tn.gov/governor/about-bill-lee/state-of-the-state-2019-address.html
43 43 Texas Greg Abbott R Texas_SOTS.txt https://gov.texas.gov/news/post/governor-greg-abbott-delivers-state-of-the-state-address
44 44 Utah Gary Herbert R Utah_SOTS.txt https://governor.utah.gov/2019/01/31/governor-herberts-2019-state-of-the-state-address-full-transcript/
45 45 Vermont Phil Scott R Vermont_Both.txt https://governor.vermont.gov/press-release/governor-phil-scott-delivers-second-inaugural-address
46 46 Virginia Ralph Northam D Virginia_SOTS.txt https://www.governor.virginia.gov/newsroom/all-releases/2019/january/headline-837676-en.html
47 47 Washington Jay Inslee D Washington_SOTS.txt https://www.governor.wa.gov/news-media/news-media/speeches/2019-state-state
48 48 West Virginia Jim Justice R WestVirginia_SOTS.txt https://governor.wv.gov/News/press-releases/2019/Pages/2019-West-Virginia-State-of-the-State-Address-.aspx
49 49 Wisconsin Tony Evers D Wisconsin_SOTS.txt https://evers.wi.gov/Pages/Newsroom/Press-Releases/012219-Governor-Evers-Gives-2019-State-of-the-State-Address.aspx
50 50 Wyoming Mark Gordon R Wyoming_SOTS.txt https://drive.google.com/file/d/0B5QDlu63DmCiY1AwRnBsM3VuQlJtc01YWkVYUDVFdEhNVWI4/view

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "state-of-the-state/index" (
"state" TEXT,
  "governor" TEXT,
  "party" TEXT,
  "filename" TEXT,
  "url" TEXT
);