state-of-the-state/index

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

50 rows

descending

This data as json, copyable, CSV (advanced)

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

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