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 category
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 |
---|---|---|---|---|---|---|---|---|---|---|
1153 | 1153 | budget ll | 4 | 3 | 7 | 17.39 | 11.11 | 0.34989648 | 0.554171736 | |
5 | 5 | affordable care | 10 | 1 | 11 | 43.48 | 3.7 | 8.931196018 | 0.002803407 | |
6 | 6 | international | 0 | 10 | 10 | 0.0 | 37.04 | 8.518518519 | 0.003515506 | |
8 | 8 | universal | 11 | 2 | 13 | 47.83 | 7.41 | 7.803914282 | 0.005213318 | |
12 | 12 | care act | 9 | 1 | 10 | 39.13 | 3.7 | 7.793880837 | 0.005242347 | |
13 | 13 | implemented | 1 | 12 | 13 | 4.35 | 44.44 | 7.680044593 | 0.005583479 | |
15 | 15 | just weeks ago | 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 | |
19 | 19 | set aside | 0 | 8 | 8 | 0.0 | 29.63 | 6.814814815 | 0.009040468 | |
23 | 23 | freedom | 1 | 10 | 11 | 4.35 | 37.04 | 6.032645294 | 0.014043672 | |
24 | 24 | wind | 11 | 3 | 14 | 47.83 | 11.11 | 5.979296066 | 0.014474778 | |
25 | 25 | choices | 11 | 3 | 14 | 47.83 | 11.11 | 5.979296066 | 0.014474778 | |
26 | 26 | 11 million | 0 | 7 | 7 | 0.0 | 25.93 | 5.962962963 | 0.014609469 | |
30 | 30 | need make sure | 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 | |
37 | 37 | sure children | 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 | |
40 | 40 | values | 14 | 5 | 19 | 60.87 | 18.52 | 5.862276464 | 0.015468775 | |
42 | 42 | core | 2 | 12 | 14 | 8.7 | 44.44 | 5.66873706 | 0.017269885 | |
43 | 43 | officer | 2 | 12 | 14 | 8.7 | 44.44 | 5.66873706 | 0.017269885 | |
44 | 44 | state let | 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 | |
47 | 47 | list | 3 | 14 | 17 | 13.04 | 51.85 | 5.501657668 | 0.018998456 | |
49 | 49 | childhood | 12 | 4 | 16 | 52.17 | 14.81 | 5.417069243 | 0.019940805 | |
50 | 50 | minimum | 12 | 4 | 16 | 52.17 | 14.81 | 5.417069243 | 0.019940805 | |
51 | 51 | ongoing | 1 | 9 | 10 | 4.35 | 33.33 | 5.217391304 | 0.022362073 | |
52 | 52 | 2014 | 1 | 9 | 10 | 4.35 | 33.33 | 5.217391304 | 0.022362073 | |
53 | 53 | affordable | 20 | 10 | 30 | 86.96 | 37.04 | 5.158346753 | 0.023134909 | |
54 | 54 | thanking | 2 | 11 | 13 | 8.7 | 40.74 | 4.905363558 | 0.026773415 | |
55 | 55 | enjoy | 2 | 11 | 13 | 8.7 | 40.74 | 4.905363558 | 0.026773415 | |
58 | 58 | necessary | 5 | 17 | 22 | 21.74 | 62.96 | 4.796955058 | 0.028510082 | |
59 | 59 | bless great state | 3 | 13 | 16 | 13.04 | 48.15 | 4.783011272 | 0.028741818 | |
60 | 60 | 16 | 3 | 13 | 16 | 13.04 | 48.15 | 4.783011272 | 0.028741818 | |
61 | 61 | man | 4 | 15 | 19 | 17.39 | 55.56 | 4.760488177 | 0.029120288 | |
62 | 62 | concerns | 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 | |
65 | 65 | pre | 14 | 6 | 20 | 60.87 | 22.22 | 4.637681159 | 0.031277237 | |
66 | 66 | starts | 11 | 4 | 15 | 47.83 | 14.81 | 4.511540526 | 0.033666905 | |
67 | 67 | afford | 19 | 10 | 29 | 82.61 | 37.04 | 4.447165306 | 0.034959231 | |
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 | |
72 | 72 | house senate | 1 | 8 | 9 | 4.35 | 29.63 | 4.410270174 | 0.035723183 | |
76 | 76 | state law | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
77 | 77 | department commerce | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
81 | 81 | skills necessary | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
83 | 83 | cost doing | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
84 | 84 | continues grow | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
85 | 85 | line duty | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
87 | 87 | long ago | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
89 | 89 | thanks leadership | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
90 | 90 | mr chief justice | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
91 | 91 | mr chief | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 | |
92 | 92 | conservative | 2 | 10 | 12 | 8.7 | 37.04 | 4.156736447 | 0.041469233 | |
94 | 94 | involved | 2 | 10 | 12 | 8.7 | 37.04 | 4.156736447 | 0.041469233 | |
95 | 95 | adults | 12 | 5 | 17 | 52.17 | 18.52 | 4.137633797 | 0.041939755 | |
96 | 96 | reach | 16 | 8 | 24 | 69.57 | 29.63 | 4.126677402 | 0.042212153 | |
98 | 98 | continued | 4 | 14 | 18 | 17.39 | 51.85 | 4.096976203 | 0.042959981 | |
99 | 99 | positive | 3 | 12 | 15 | 13.04 | 44.44 | 4.082125604 | 0.043339106 | |
100 | 100 | looks | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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 );