State of the State: index.csv

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

Suggested facets: party

Link rowid ▼ state governor party filename url
1 Alabama Kay Ivey R Alabama_SOTS.txt
2 Alaska Mike Dunleavy R Alaska_SOTS.txt
3 Arizona Doug Ducey R Arizona_SOTS.txt
4 Arkansas Asa Hutchinson R Arkansas_SOTS.txt
5 California Gavin Newsom D California_SOTS.txt
6 Colorado Jared Polis D Colorado_SOTS.txt
7 Connecticut Ned Lamont D Connecticut_SOTS.txt
8 Delaware John Carney D Delaware_SOTS.txt
9 Florida Ron DeSantis R Florida_SOTS.txt
10 Georgia Brian Kemp R Georgia_SOTS.txt
11 Hawaii David Ige D Hawaii_SOTS.txt
12 Idaho Brad Little R Idaho_SOTS.txt
13 Illinois JB Pritzker D Illinois_Both.txt
14 Indiana Eric Holcomb R Indiana_SOTS.txt
15 Iowa Kim Reynolds R Iowa_SOTS.txt
16 Kansas Laura Kelly D Kansas_SOTS.txt
17 Kentucky Matt Bevin R Kentucky_SOTS.txt
18 Louisiana John Bel Edwards D Louisiana_SOTS.txt
19 Maine Janet Mills D Maine_SOTS.txt
20 Maryland Larry Hogan R Maryland_SOTS.txt
21 Massachusetts Charlie Baker R Massachusetts_Both.txt
22 Michigan Gretchen Whitmer D Michigan_SOTS.txt
23 Minnesota Tim Walz D Minnesota_SOTS.txt
24 Mississippi Phil Bryant R Mississippi_SOTS.txt
25 Missouri Mike Parson R Missouri_SOTS.txt
26 Montana Steve Bullock D Montana_SOTS.txt
27 Nebraska Pete Ricketts R Nebraska_SOTS.txt
28 Nevada Steve Sisolak D Nevada_SOTS.txt
29 New Hampshire Chris Sununu R NewHampshire_Both.txt
30 New Jersey Phil Murphy D NewJersey_SOTS.txt
31 New Mexico Michelle Lujan Grisham D NewMexico_SOTS.txt
32 New York Andrew Cuomo D NewYork_SOTS.txt
33 North Carolina Roy Cooper D NorthCarolina_SOTS.txt
34 North Dakota Doug Burgum R NorthDakota_SOTS.txt
35 Ohio Mike DeWine R Ohio_SOTS.txt
36 Oklahoma Kevin Stitt R Oklahoma_SOTS.txt
37 Oregon Kate Brown D Oregon_Both.txt
38 Pennsylvania Tom Wolf D Pennsylvania_SOTS.txt
39 Rhode Island Gina Raimondo D RhodeIsland_SOTS.txt
40 South Carolina Henry McMaster R SouthCarolina_SOTS.txt
41 South Dakota Kristi Noem R SouthDakota_SOTS.txt
42 Tennessee Bill Lee R Tennessee_SOTS.txt
43 Texas Greg Abbott R Texas_SOTS.txt
44 Utah Gary Herbert R Utah_SOTS.txt
45 Vermont Phil Scott R Vermont_Both.txt
46 Virginia Ralph Northam D Virginia_SOTS.txt
47 Washington Jay Inslee D Washington_SOTS.txt
48 West Virginia Jim Justice R WestVirginia_SOTS.txt
49 Wisconsin Tony Evers D Wisconsin_SOTS.txt
50 Wyoming Mark Gordon R Wyoming_SOTS.txt

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
Powered by Datasette · Query took 18.883ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette