State of the State: words.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
2,223 rows sorted by percent_of_r_speeches
This data as json, copyable, CSV (advanced)
Suggested facets: category, d_speeches, r_speeches, percent_of_d_speeches, percent_of_r_speeches
Link | rowid | phrase | category | d_speeches | r_speeches | total | percent_of_d_speeches | percent_of_r_speeches ▼ | chi2 | pval |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | minimum wage | economy/fiscal issues | 9 | 0 | 9 | 39.13 | 0.0 | 10.56521739 | 0.001152355 |
4 | 4 | gun violence | crime/justice | 8 | 0 | 8 | 34.78 | 0.0 | 9.391304348 | 0.00218017 |
7 | 7 | education need | education | 7 | 0 | 7 | 30.43 | 0.0 | 8.217391304 | 0.00414908 |
14 | 14 | students state | education | 6 | 0 | 6 | 26.09 | 0.0 | 7.043478261 | 0.007955439 |
15 | 15 | just weeks ago | 6 | 0 | 6 | 26.09 | 0.0 | 7.043478261 | 0.007955439 | |
16 | 16 | gun safety | crime/justice | 6 | 0 | 6 | 26.09 | 0.0 | 7.043478261 | 0.007955439 |
17 | 17 | protect health | 6 | 0 | 6 | 26.09 | 0.0 | 7.043478261 | 0.007955439 | |
18 | 18 | pre existing | 6 | 0 | 6 | 26.09 | 0.0 | 7.043478261 | 0.007955439 | |
29 | 29 | pre existing conditions | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
30 | 30 | need make sure | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 | |
31 | 31 | reproductive health | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
32 | 32 | educators deserve | education | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
33 | 33 | expanding access | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 | |
34 | 34 | energy future | energy/environment | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
35 | 35 | economy works | economy/fiscal issues | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
36 | 36 | existing conditions | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
37 | 37 | sure children | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 | |
38 | 38 | cost health | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
39 | 39 | good faith | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 | |
2 | 2 | clean energy | energy/environment | 11 | 1 | 12 | 47.83 | 3.7 | 10.07461084 | 0.001503264 |
5 | 5 | affordable care | 10 | 1 | 11 | 43.48 | 3.7 | 8.931196018 | 0.002803407 | |
9 | 9 | affordable care act | health care | 9 | 1 | 10 | 39.13 | 3.7 | 7.793880837 | 0.005242347 |
10 | 10 | middle class | economy/fiscal issues | 9 | 1 | 10 | 39.13 | 3.7 | 7.793880837 | 0.005242347 |
11 | 11 | sick | health care | 9 | 1 | 10 | 39.13 | 3.7 | 7.793880837 | 0.005242347 |
12 | 12 | care act | 9 | 1 | 10 | 39.13 | 3.7 | 7.793880837 | 0.005242347 | |
21 | 21 | business community | economy/fiscal issues | 8 | 1 | 9 | 34.78 | 3.7 | 6.664698515 | 0.009834129 |
22 | 22 | economic success | economy/fiscal issues | 8 | 1 | 9 | 34.78 | 3.7 | 6.664698515 | 0.009834129 |
44 | 44 | state let | 7 | 1 | 8 | 30.43 | 3.7 | 5.546698873 | 0.018515575 | |
45 | 45 | expand medicaid | health care | 7 | 1 | 8 | 30.43 | 3.7 | 5.546698873 | 0.018515575 |
46 | 46 | past years ve | 7 | 1 | 8 | 30.43 | 3.7 | 5.546698873 | 0.018515575 | |
68 | 68 | looks like | 6 | 1 | 7 | 26.09 | 3.7 | 4.444674488 | 0.035010264 | |
69 | 69 | friends neighbors | 6 | 1 | 7 | 26.09 | 3.7 | 4.444674488 | 0.035010264 | |
70 | 70 | just weeks | 6 | 1 | 7 | 26.09 | 3.7 | 4.444674488 | 0.035010264 | |
71 | 71 | paid family | 6 | 1 | 7 | 26.09 | 3.7 | 4.444674488 | 0.035010264 | |
124 | 124 | rate lowest | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
125 | 125 | members cabinet | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
126 | 126 | open doors | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
127 | 127 | reach potential | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
128 | 128 | people world | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
129 | 129 | start new | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
130 | 130 | college tuition | education | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
131 | 131 | honored guests | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
132 | 132 | know know | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
133 | 133 | fiscally responsible | economy/fiscal issues | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
134 | 134 | federal funding | economy/fiscal issues | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
135 | 135 | economy strong | economy/fiscal issues | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
136 | 136 | changing economy | economy/fiscal issues | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
137 | 137 | special education | education | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
138 | 138 | schools year | education | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
139 | 139 | health outcomes | health care | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 |
140 | 140 | challenges face | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
141 | 141 | care need | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
142 | 142 | rural hospitals | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
143 | 143 | water infrastructure | 5 | 1 | 6 | 21.74 | 3.7 | 3.36661299 | 0.066530403 | |
233 | 233 | state want | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
234 | 234 | start business | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
235 | 235 | unemployment rate lowest | economy/fiscal issues | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
236 | 236 | family leave | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
237 | 237 | expanded medicaid | health care | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
238 | 238 | support need | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
239 | 239 | state great | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
240 | 240 | help state | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
241 | 241 | facing state | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
242 | 242 | air water | energy/environment | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
243 | 243 | today stand | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
244 | 244 | equal rights | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
245 | 245 | education health | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
246 | 246 | eager work | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
247 | 247 | work day | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
248 | 248 | decades ago | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
249 | 249 | state funding | economy/fiscal issues | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
250 | 250 | need continue | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
251 | 251 | progress past | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
252 | 252 | rapidly changing | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
253 | 253 | need invest | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
254 | 254 | partisan issue | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
255 | 255 | paid family leave | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
256 | 256 | place people | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
257 | 257 | public lands | energy/environment | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
258 | 258 | year degree | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
259 | 259 | training programs | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
260 | 260 | children future | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
261 | 261 | skilled workforce | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
262 | 262 | signed executive | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
263 | 263 | administration work | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
264 | 264 | make decisions | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
265 | 265 | make easier | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
3 | 3 | climate change | energy/environment | 13 | 2 | 15 | 56.52 | 7.41 | 9.986580784 | 0.001576851 |
8 | 8 | universal | 11 | 2 | 13 | 47.83 | 7.41 | 7.803914282 | 0.005213318 | |
41 | 41 | child care | education | 9 | 2 | 11 | 39.13 | 7.41 | 5.681305812 | 0.017146602 |
62 | 62 | concerns | 8 | 2 | 10 | 34.78 | 7.41 | 4.653784219 | 0.030985168 | |
63 | 63 | carbon | energy/environment | 8 | 2 | 10 | 34.78 | 7.41 | 4.653784219 | 0.030985168 |
64 | 64 | sustain | 8 | 2 | 10 | 34.78 | 7.41 | 4.653784219 | 0.030985168 | |
109 | 109 | access health | health care | 7 | 2 | 9 | 30.43 | 7.41 | 3.65879406 | 0.055773989 |
110 | 110 | year old | 7 | 2 | 9 | 30.43 | 7.41 | 3.65879406 | 0.055773989 | |
111 | 111 | need make | 7 | 2 | 9 | 30.43 | 7.41 | 3.65879406 | 0.055773989 | |
207 | 207 | today state | 6 | 2 | 8 | 26.09 | 7.41 | 2.708534622 | 0.09981264 | |
208 | 208 | let start | 6 | 2 | 8 | 26.09 | 7.41 | 2.708534622 | 0.09981264 | |
209 | 209 | thank service | 6 | 2 | 8 | 26.09 | 7.41 | 2.708534622 | 0.09981264 | |
210 | 210 | affordable health | 6 | 2 | 8 | 26.09 | 7.41 | 2.708534622 | 0.09981264 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state-of-the-state/words" ( "phrase" TEXT, "category" TEXT, "d_speeches" INTEGER, "r_speeches" INTEGER, "total" INTEGER, "percent_of_d_speeches" REAL, "percent_of_r_speeches" REAL, "chi2" REAL, "pval" REAL );