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 phrase
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 |
---|---|---|---|---|---|---|---|---|---|---|
2078 | 2078 | 0 | 20 | 23 | 43 | 86.96 | 85.19 | 0.004531326 | 0.946330836 | |
1653 | 1653 | 000 jobs | 2 | 3 | 5 | 8.7 | 11.11 | 0.072463768 | 0.787782743 | |
1254 | 1254 | 000 new | 7 | 6 | 13 | 30.43 | 22.22 | 0.322185061 | 0.570297453 | |
433 | 433 | 000 new jobs | 6 | 3 | 9 | 26.09 | 11.11 | 1.547504026 | 0.213504293 | |
917 | 917 | 000 people | 3 | 6 | 9 | 13.04 | 22.22 | 0.581320451 | 0.445795211 | |
446 | 446 | 000 students | 2 | 6 | 8 | 8.7 | 22.22 | 1.420289855 | 0.2333557 | |
2146 | 2146 | 000 year | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 | |
685 | 685 | 10 | 18 | 15 | 33 | 78.26 | 55.56 | 0.970136144 | 0.324646227 | |
1158 | 1158 | 10 000 | 4 | 3 | 7 | 17.39 | 11.11 | 0.34989648 | 0.554171736 | |
1248 | 1248 | 10 million | 7 | 6 | 13 | 30.43 | 22.22 | 0.322185061 | 0.570297453 | |
1021 | 1021 | 10 percent | 3 | 2 | 5 | 13.04 | 7.41 | 0.39452496 | 0.529930429 | |
363 | 363 | 10 years | 5 | 2 | 7 | 21.74 | 7.41 | 1.822176213 | 0.177054454 | |
698 | 698 | 100 | 19 | 16 | 35 | 82.61 | 59.26 | 0.967333793 | 0.325346024 | |
2148 | 2148 | 100 000 | 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 | |
637 | 637 | 100 new | 4 | 2 | 6 | 17.39 | 7.41 | 1.031669351 | 0.309766908 | |
1947 | 1947 | 100 percent | 3 | 4 | 7 | 13.04 | 14.81 | 0.027835289 | 0.867496644 | |
120 | 120 | 11 | 3 | 11 | 14 | 13.04 | 40.74 | 3.402806533 | 0.065085592 | |
26 | 26 | 11 million | 0 | 7 | 7 | 0.0 | 25.93 | 5.962962963 | 0.014609469 | |
1373 | 1373 | 12 | 16 | 16 | 32 | 69.57 | 59.26 | 0.206119163 | 0.64982632 | |
2168 | 2168 | 12 education | education | 5 | 6 | 11 | 21.74 | 22.22 | 0.001317523 | 0.971044984 |
1708 | 1708 | 12 schools | education | 2 | 3 | 5 | 8.7 | 11.11 | 0.072463768 | 0.787782743 |
528 | 528 | 120 million | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
2101 | 2101 | 13 | 7 | 8 | 15 | 30.43 | 29.63 | 0.002683843 | 0.958683416 | |
166 | 166 | 14 | 4 | 12 | 16 | 17.39 | 44.44 | 2.84057971 | 0.091911049 | |
527 | 527 | 14 000 | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
1980 | 1980 | 15 | 10 | 11 | 21 | 43.48 | 40.74 | 0.022160877 | 0.881659923 | |
1006 | 1006 | 15 000 | 3 | 2 | 5 | 13.04 | 7.41 | 0.39452496 | 0.529930429 | |
1790 | 1790 | 150 | 6 | 8 | 14 | 26.09 | 29.63 | 0.055670577 | 0.81347447 | |
1008 | 1008 | 150 000 | 3 | 2 | 5 | 13.04 | 7.41 | 0.39452496 | 0.529930429 | |
60 | 60 | 16 | 3 | 13 | 16 | 13.04 | 48.15 | 4.783011272 | 0.028741818 | |
2107 | 2107 | 17 | 7 | 8 | 15 | 30.43 | 29.63 | 0.002683843 | 0.958683416 | |
1669 | 1669 | 17 000 | 2 | 3 | 5 | 8.7 | 11.11 | 0.072463768 | 0.787782743 | |
413 | 413 | 18 | 12 | 8 | 20 | 52.17 | 29.63 | 1.578099839 | 0.209034609 | |
790 | 790 | 19 | 4 | 8 | 12 | 17.39 | 29.63 | 0.775093935 | 0.378645801 | |
1825 | 1825 | 20 | 13 | 14 | 27 | 56.52 | 51.85 | 0.050158049 | 0.822788485 | |
1666 | 1666 | 20 million | 2 | 3 | 5 | 8.7 | 11.11 | 0.072463768 | 0.787782743 | |
1792 | 1792 | 20 years | 6 | 8 | 14 | 26.09 | 29.63 | 0.055670577 | 0.81347447 | |
2182 | 2182 | 200 | 11 | 13 | 24 | 47.83 | 48.15 | 0.000268384 | 0.986929289 | |
1663 | 1663 | 200 000 | 2 | 3 | 5 | 8.7 | 11.11 | 0.072463768 | 0.787782743 | |
1960 | 1960 | 200 million | 3 | 4 | 7 | 13.04 | 14.81 | 0.027835289 | 0.867496644 | |
52 | 52 | 2014 | 1 | 9 | 10 | 4.35 | 33.33 | 5.217391304 | 0.022362073 | |
1622 | 1622 | 2015 | 6 | 6 | 12 | 26.09 | 22.22 | 0.077294686 | 0.780997606 | |
1471 | 1471 | 2017 | 11 | 15 | 26 | 47.83 | 55.56 | 0.142697882 | 0.705613548 | |
361 | 361 | 2018 | 5 | 12 | 17 | 21.74 | 44.44 | 1.883205456 | 0.169970274 | |
603 | 603 | 2019 | 11 | 8 | 19 | 47.83 | 29.63 | 1.082210357 | 0.29820361 | |
1914 | 1914 | 2020 | 7 | 9 | 16 | 30.43 | 33.33 | 0.032608696 | 0.856698213 | |
1536 | 1536 | 21st | 8 | 8 | 16 | 34.78 | 29.63 | 0.103059581 | 0.748188459 | |
1535 | 1535 | 21st century | 8 | 8 | 16 | 34.78 | 29.63 | 0.103059581 | 0.748188459 | |
1342 | 1342 | 25 | 9 | 13 | 22 | 39.13 | 48.15 | 0.229541795 | 0.631863789 | |
1764 | 1764 | 26 | 5 | 5 | 10 | 21.74 | 18.52 | 0.064412238 | 0.799653425 | |
927 | 927 | 30 | 11 | 17 | 28 | 47.83 | 62.96 | 0.508166552 | 0.475933621 | |
724 | 724 | 30 million | 2 | 5 | 7 | 8.7 | 18.52 | 0.855992639 | 0.354862558 | |
1192 | 1192 | 30 years | 5 | 4 | 9 | 21.74 | 14.81 | 0.330828413 | 0.565171695 | |
184 | 184 | 300 | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
118 | 118 | 40 | 5 | 15 | 20 | 21.74 | 55.56 | 3.550724638 | 0.059519452 | |
1961 | 1961 | 40 000 | 3 | 4 | 7 | 13.04 | 14.81 | 0.027835289 | 0.867496644 | |
1882 | 1882 | 40 percent | 3 | 3 | 6 | 13.04 | 11.11 | 0.038647343 | 0.844148964 | |
1765 | 1765 | 400 | 5 | 5 | 10 | 21.74 | 18.52 | 0.064412238 | 0.799653425 | |
1768 | 1768 | 45 | 5 | 5 | 10 | 21.74 | 18.52 | 0.064412238 | 0.799653425 | |
832 | 832 | 50 | 9 | 15 | 24 | 39.13 | 55.56 | 0.698067633 | 0.40343376 | |
335 | 335 | 50 million | 2 | 7 | 9 | 8.7 | 25.93 | 2.048488102 | 0.152357423 | |
1962 | 1962 | 50 years | 3 | 4 | 7 | 13.04 | 14.81 | 0.027835289 | 0.867496644 | |
2054 | 2054 | 500 | 9 | 11 | 20 | 39.13 | 40.74 | 0.00805153 | 0.928501524 | |
1410 | 1410 | 60 | 7 | 10 | 17 | 30.43 | 37.04 | 0.159230842 | 0.689865651 | |
1054 | 1054 | 60 million | 3 | 2 | 5 | 13.04 | 7.41 | 0.39452496 | 0.529930429 | |
1949 | 1949 | 60 percent | 3 | 4 | 7 | 13.04 | 14.81 | 0.027835289 | 0.867496644 | |
197 | 197 | 600 | 2 | 8 | 10 | 8.7 | 29.63 | 2.721417069 | 0.09901008 | |
1630 | 1630 | 70 | 6 | 6 | 12 | 26.09 | 22.22 | 0.077294686 | 0.780997606 | |
2209 | 2209 | 75 | 6 | 7 | 13 | 26.09 | 25.93 | 0.00012387 | 0.991119987 | |
1444 | 1444 | 90 | 4 | 6 | 10 | 17.39 | 22.22 | 0.144927536 | 0.703430697 | |
1174 | 1174 | 90 percent | 4 | 3 | 7 | 17.39 | 11.11 | 0.34989648 | 0.554171736 | |
430 | 430 | TRUE | 10 | 19 | 29 | 43.48 | 70.37 | 1.548614582 | 0.213340083 | |
737 | 737 | ability | 8 | 14 | 22 | 34.78 | 51.85 | 0.82242717 | 0.364471473 | |
1398 | 1398 | able | 13 | 13 | 26 | 56.52 | 48.15 | 0.16747182 | 0.682368525 | |
656 | 656 | absolutely | 3 | 7 | 10 | 13.04 | 25.93 | 1.030595813 | 0.310018769 | |
1922 | 1922 | abuse | 7 | 9 | 16 | 30.43 | 33.33 | 0.032608696 | 0.856698213 | |
546 | 546 | access | 20 | 16 | 36 | 86.96 | 59.26 | 1.323313652 | 0.249998219 | |
109 | 109 | access health | health care | 7 | 2 | 9 | 30.43 | 7.41 | 3.65879406 | 0.055773989 |
211 | 211 | access health care | health care | 6 | 2 | 8 | 26.09 | 7.41 | 2.708534622 | 0.09981264 |
518 | 518 | access high | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
1175 | 1175 | access quality | 4 | 3 | 7 | 17.39 | 11.11 | 0.34989648 | 0.554171736 | |
1244 | 1244 | accessible | 6 | 5 | 11 | 26.09 | 18.52 | 0.323378715 | 0.569584201 | |
453 | 453 | accomplish | 5 | 11 | 16 | 21.74 | 40.74 | 1.40136876 | 0.23649453 | |
661 | 661 | accomplished | 3 | 7 | 10 | 13.04 | 25.93 | 1.030595813 | 0.310018769 | |
119 | 119 | account | 2 | 9 | 11 | 8.7 | 33.33 | 3.42687747 | 0.064143271 | |
905 | 905 | accountability | 5 | 9 | 14 | 21.74 | 33.33 | 0.596273292 | 0.440003477 | |
567 | 567 | accountable | 4 | 9 | 13 | 17.39 | 33.33 | 1.214046823 | 0.270532137 | |
2116 | 2116 | achieve | 13 | 15 | 28 | 56.52 | 55.56 | 0.002070393 | 0.963707519 | |
271 | 271 | achievement | 7 | 3 | 10 | 30.43 | 11.11 | 2.31884058 | 0.127815263 | |
1619 | 1619 | acknowledge | 6 | 6 | 12 | 26.09 | 22.22 | 0.077294686 | 0.780997606 | |
387 | 387 | act | 20 | 15 | 35 | 86.96 | 55.56 | 1.749482402 | 0.185941815 | |
1594 | 1594 | action | 13 | 17 | 30 | 56.52 | 62.96 | 0.085882984 | 0.769477828 | |
1809 | 1809 | actions | 6 | 8 | 14 | 26.09 | 29.63 | 0.055670577 | 0.81347447 | |
1446 | 1446 | activity | 4 | 6 | 10 | 17.39 | 22.22 | 0.144927536 | 0.703430697 | |
825 | 825 | actually | 8 | 6 | 14 | 34.78 | 22.22 | 0.699792961 | 0.402853271 | |
185 | 185 | add | 3 | 10 | 13 | 13.04 | 37.04 | 2.750030967 | 0.097252545 | |
2093 | 2093 | added | 7 | 8 | 15 | 30.43 | 29.63 | 0.002683843 | 0.958683416 | |
944 | 944 | addiction | mental health/substance abuse | 6 | 10 | 16 | 26.09 | 37.04 | 0.465378422 | 0.495121029 |
1514 | 1514 | addition | 9 | 9 | 18 | 39.13 | 33.33 | 0.115942029 | 0.733478056 |
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 );