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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|
2223 | 2223 | make | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2222 | 2222 | working | economy/fiscal issues | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 |
2221 | 2221 | people | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2220 | 2220 | thank | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2219 | 2219 | school | education | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 |
2218 | 2218 | education | education | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 |
2217 | 2217 | work | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2216 | 2216 | state | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2215 | 2215 | new | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2214 | 2214 | years | 23 | 27 | 50 | 100.0 | 100.0 | 0.0 | 1.0 | |
2213 | 2213 | invest | 17 | 20 | 37 | 73.91 | 74.07 | 4.35e-05 | 0.994736311 | |
2212 | 2212 | trump | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2211 | 2211 | haven | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2210 | 2210 | intend | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2209 | 2209 | 75 | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2208 | 2208 | high speed | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2207 | 2207 | fail | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2206 | 2206 | beautiful | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2205 | 2205 | win | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2204 | 2204 | facility | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2203 | 2203 | seven | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2202 | 2202 | importantly | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2201 | 2201 | immediately | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2200 | 2200 | high school students | education | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 |
2199 | 2199 | balanced | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2198 | 2198 | focusing | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2197 | 2197 | threat | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2196 | 2196 | fourth | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2195 | 2195 | workforce development | economy/fiscal issues | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 |
2194 | 2194 | cuts | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2193 | 2193 | represent | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2192 | 2192 | reflect | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2191 | 2191 | night | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2190 | 2190 | formula | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2189 | 2189 | residents | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
2188 | 2188 | built | 12 | 14 | 26 | 52.17 | 51.85 | 0.000247739 | 0.987442024 | |
2187 | 2187 | lost | 12 | 14 | 26 | 52.17 | 51.85 | 0.000247739 | 0.987442024 | |
2186 | 2186 | chance | 12 | 14 | 26 | 52.17 | 51.85 | 0.000247739 | 0.987442024 | |
2185 | 2185 | century | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
2184 | 2184 | political | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
2183 | 2183 | heard | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
2182 | 2182 | 200 | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
2181 | 2181 | save | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
2180 | 2180 | innovation | economy/fiscal issues | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 |
2179 | 2179 | number | 18 | 21 | 39 | 78.26 | 77.78 | 0.000371609 | 0.984620001 | |
2178 | 2178 | parents | 18 | 21 | 39 | 78.26 | 77.78 | 0.000371609 | 0.984620001 | |
2177 | 2177 | jobs | economy/fiscal issues | 22 | 26 | 48 | 95.65 | 96.3 | 0.000536769 | 0.98151605 |
2176 | 2176 | future | 22 | 26 | 48 | 95.65 | 96.3 | 0.000536769 | 0.98151605 | |
2175 | 2175 | job | economy/fiscal issues | 22 | 26 | 48 | 95.65 | 96.3 | 0.000536769 | 0.98151605 |
2174 | 2174 | let | 22 | 26 | 48 | 95.65 | 96.3 | 0.000536769 | 0.98151605 | |
2173 | 2173 | members | 22 | 26 | 48 | 95.65 | 96.3 | 0.000536769 | 0.98151605 | |
2172 | 2172 | higher | 16 | 19 | 35 | 69.57 | 70.37 | 0.001150219 | 0.972945034 | |
2171 | 2171 | low | 16 | 19 | 35 | 69.57 | 70.37 | 0.001150219 | 0.972945034 | |
2170 | 2170 | community colleges | education | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
2169 | 2169 | creative | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2168 | 2168 | 12 education | education | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
2167 | 2167 | retirement | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2166 | 2166 | inaugural | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2165 | 2165 | electric | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2164 | 2164 | allows | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2163 | 2163 | excited | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2162 | 2162 | exciting | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2161 | 2161 | alongside | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2160 | 2160 | amendment | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2159 | 2159 | job creation | economy/fiscal issues | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
2158 | 2158 | advocate | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2157 | 2157 | qualified | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2156 | 2156 | elementary | education | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
2155 | 2155 | salary | economy/fiscal issues | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
2154 | 2154 | loved | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2153 | 2153 | couple | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2152 | 2152 | worth | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2151 | 2151 | good work | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2150 | 2150 | state local | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2149 | 2149 | 100 million | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2148 | 2148 | 100 000 | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2147 | 2147 | common sense | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2146 | 2146 | 000 year | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2145 | 2145 | party | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2144 | 2144 | state state strong | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2143 | 2143 | strategies | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2142 | 2142 | strategic | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2141 | 2141 | obligation | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2140 | 2140 | outdoor | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2139 | 2139 | closely | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2138 | 2138 | fields | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2137 | 2137 | mom | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2136 | 2136 | named | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2135 | 2135 | positions | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2134 | 2134 | imagine | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2133 | 2133 | standard | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2132 | 2132 | preparing | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2131 | 2131 | taught | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2130 | 2130 | eye | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2129 | 2129 | help people | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2128 | 2128 | shown | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2127 | 2127 | million new | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2126 | 2126 | announce | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2125 | 2125 | products | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
2124 | 2124 | office | 19 | 22 | 41 | 82.61 | 81.48 | 0.001924512 | 0.965008618 |
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 );