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
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | phrase | category | d_speeches | r_speeches | total | percent_of_d_speeches | percent_of_r_speeches | chi2 | pval |
---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | good jobs | economy/fiscal issues | 9 | 3 | 12 | 39.13 | 11.11 | 4.062801932 | 0.043837703 |
102 | 102 | ve got | 9 | 3 | 12 | 39.13 | 11.11 | 4.062801932 | 0.043837703 | |
103 | 103 | example | 8 | 21 | 29 | 34.78 | 77.78 | 3.95852074 | 0.046634668 | |
104 | 104 | coverage | 13 | 6 | 19 | 56.52 | 22.22 | 3.845156369 | 0.049889869 | |
105 | 105 | works | 18 | 10 | 28 | 78.26 | 37.04 | 3.769036117 | 0.052209711 | |
106 | 106 | left | 18 | 10 | 28 | 78.26 | 37.04 | 3.769036117 | 0.052209711 | |
107 | 107 | begin | 6 | 17 | 23 | 26.09 | 62.96 | 3.671567598 | 0.055348105 | |
108 | 108 | state government | 6 | 17 | 23 | 26.09 | 62.96 | 3.671567598 | 0.055348105 | |
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 | |
112 | 112 | wait | 10 | 4 | 14 | 43.48 | 14.81 | 3.644352427 | 0.056259678 | |
113 | 113 | early childhood | education | 10 | 4 | 14 | 43.48 | 14.81 | 3.644352427 | 0.056259678 |
114 | 114 | school safety | crime/justice | 1 | 7 | 8 | 4.35 | 25.93 | 3.614331723 | 0.057283732 |
115 | 115 | raising taxes | economy/fiscal issues | 1 | 7 | 8 | 4.35 | 25.93 | 3.614331723 | 0.057283732 |
116 | 116 | nearly 000 | 1 | 7 | 8 | 4.35 | 25.93 | 3.614331723 | 0.057283732 | |
117 | 117 | solutions | 5 | 15 | 20 | 21.74 | 55.56 | 3.550724638 | 0.059519452 | |
118 | 118 | 40 | 5 | 15 | 20 | 21.74 | 55.56 | 3.550724638 | 0.059519452 | |
119 | 119 | account | 2 | 9 | 11 | 8.7 | 33.33 | 3.42687747 | 0.064143271 | |
120 | 120 | 11 | 3 | 11 | 14 | 13.04 | 40.74 | 3.402806533 | 0.065085592 | |
121 | 121 | rainy | 3 | 11 | 14 | 13.04 | 40.74 | 3.402806533 | 0.065085592 | |
122 | 122 | recommendations | 3 | 11 | 14 | 13.04 | 40.74 | 3.402806533 | 0.065085592 | |
123 | 123 | rainy day | economy/fiscal issues | 3 | 11 | 14 | 13.04 | 40.74 | 3.402806533 | 0.065085592 |
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 | |
144 | 144 | kindergarten | education | 11 | 5 | 16 | 47.83 | 18.52 | 3.33373591 | 0.067872542 |
145 | 145 | small businesses | economy/fiscal issues | 11 | 5 | 16 | 47.83 | 18.52 | 3.33373591 | 0.067872542 |
146 | 146 | lady | 7 | 18 | 25 | 30.43 | 66.67 | 3.260869565 | 0.070951492 | |
147 | 147 | make happen | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
148 | 148 | sharing | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
149 | 149 | forced | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
150 | 150 | seniors | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
151 | 151 | eager | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
152 | 152 | working hard | 8 | 3 | 11 | 34.78 | 11.11 | 3.163372859 | 0.075307444 | |
153 | 153 | assistance | 12 | 6 | 18 | 52.17 | 22.22 | 3.095008052 | 0.078532764 | |
154 | 154 | plans | 12 | 6 | 18 | 52.17 | 22.22 | 3.095008052 | 0.078532764 | |
155 | 155 | washington | 18 | 11 | 29 | 78.26 | 40.74 | 3.014548281 | 0.082520443 | |
156 | 156 | successful | 5 | 14 | 19 | 21.74 | 51.85 | 2.963725739 | 0.085151523 | |
157 | 157 | population | 5 | 14 | 19 | 21.74 | 51.85 | 2.963725739 | 0.085151523 | |
158 | 158 | income tax | economy/fiscal issues | 5 | 14 | 19 | 21.74 | 51.85 | 2.963725739 | 0.085151523 |
159 | 159 | men women | 5 | 14 | 19 | 21.74 | 51.85 | 2.963725739 | 0.085151523 | |
160 | 160 | make sure | 19 | 12 | 31 | 82.61 | 44.44 | 2.91771856 | 0.087611655 | |
161 | 161 | basic | 13 | 7 | 20 | 56.52 | 25.93 | 2.906602254 | 0.088217549 | |
162 | 162 | allowing | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
163 | 163 | responders | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
164 | 164 | commission | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
165 | 165 | regulations | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
166 | 166 | 14 | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
167 | 167 | duty | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
168 | 168 | nearly billion | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 | |
169 | 169 | expand access | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 | |
170 | 170 | members house senate | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 | |
171 | 171 | best possible | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 | |
172 | 172 | fellow citizens | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 | |
173 | 173 | high demand | economy/fiscal issues | 1 | 6 | 7 | 4.35 | 22.22 | 2.83436853 | 0.092267065 |
174 | 174 | old | 20 | 13 | 33 | 86.96 | 48.15 | 2.834187283 | 0.092277476 | |
175 | 175 | background | 9 | 4 | 13 | 39.13 | 14.81 | 2.824352781 | 0.092844313 | |
176 | 176 | democracy | 9 | 4 | 13 | 39.13 | 14.81 | 2.824352781 | 0.092844313 | |
177 | 177 | practices | 9 | 4 | 13 | 39.13 | 14.81 | 2.824352781 | 0.092844313 | |
178 | 178 | permanent | 9 | 4 | 13 | 39.13 | 14.81 | 2.824352781 | 0.092844313 | |
179 | 179 | adult | 9 | 4 | 13 | 39.13 | 14.81 | 2.824352781 | 0.092844313 | |
180 | 180 | people state | 14 | 8 | 22 | 60.87 | 29.63 | 2.75479432 | 0.096963285 | |
181 | 181 | succeed | 14 | 8 | 22 | 60.87 | 29.63 | 2.75479432 | 0.096963285 | |
182 | 182 | prisons | crime/justice | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 |
183 | 183 | scholarships | education | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 |
184 | 184 | 300 | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
185 | 185 | add | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
186 | 186 | appreciate | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
187 | 187 | sacrifice | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
188 | 188 | public safety | crime/justice | 7 | 17 | 24 | 30.43 | 62.96 | 2.737788513 | 0.098000306 |
189 | 189 | competitive | economy/fiscal issues | 7 | 17 | 24 | 30.43 | 62.96 | 2.737788513 | 0.098000306 |
190 | 190 | look forward | 7 | 17 | 24 | 30.43 | 62.96 | 2.737788513 | 0.098000306 | |
191 | 191 | given | 7 | 17 | 24 | 30.43 | 62.96 | 2.737788513 | 0.098000306 | |
192 | 192 | collaboration | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
193 | 193 | school district | education | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 |
194 | 194 | improved | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
195 | 195 | targeted | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
196 | 196 | regulatory | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
197 | 197 | 600 | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
198 | 198 | testing | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
199 | 199 | quality education | education | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 |
200 | 200 | keeps | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 |
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 );