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 d_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 |
---|---|---|---|---|---|---|---|---|---|---|
6 | 6 | international | 0 | 10 | 10 | 0.0 | 37.04 | 8.518518519 | 0.003515506 | |
19 | 19 | set aside | 0 | 8 | 8 | 0.0 | 29.63 | 6.814814815 | 0.009040468 | |
26 | 26 | 11 million | 0 | 7 | 7 | 0.0 | 25.93 | 5.962962963 | 0.014609469 | |
27 | 27 | doing business | economy/fiscal issues | 0 | 7 | 7 | 0.0 | 25.93 | 5.962962963 | 0.014609469 |
28 | 28 | state income | economy/fiscal issues | 0 | 7 | 7 | 0.0 | 25.93 | 5.962962963 | 0.014609469 |
73 | 73 | savings account | economy/fiscal issues | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 |
74 | 74 | schools safer | crime/justice | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 |
75 | 75 | local law enforcement | crime/justice | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 |
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 | |
78 | 78 | prison population | crime/justice | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 |
79 | 79 | local law | crime/justice | 0 | 5 | 5 | 0.0 | 18.52 | 4.259259259 | 0.03903694 |
80 | 80 | state income tax | economy/fiscal issues | 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 | |
82 | 82 | education workforce | education | 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 | |
86 | 86 | tax rates | economy/fiscal issues | 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 | |
88 | 88 | fully funding | economy/fiscal issues | 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 | |
13 | 13 | implemented | 1 | 12 | 13 | 4.35 | 44.44 | 7.680044593 | 0.005583479 | |
23 | 23 | freedom | 1 | 10 | 11 | 4.35 | 37.04 | 6.032645294 | 0.014043672 | |
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 | |
72 | 72 | house senate | 1 | 8 | 9 | 4.35 | 29.63 | 4.410270174 | 0.035723183 | |
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 | |
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 |
307 | 307 | federal state | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
308 | 308 | elected leaders | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
309 | 309 | department corrections | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
310 | 310 | american dream | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
311 | 311 | best brightest | education | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 |
312 | 312 | people don | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
313 | 313 | people live | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
314 | 314 | budget provides | economy/fiscal issues | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 |
315 | 315 | dignity work | economy/fiscal issues | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 |
316 | 316 | job creators | economy/fiscal issues | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 |
317 | 317 | people people | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
318 | 318 | governor office | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
319 | 319 | programs state | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
320 | 320 | years years | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
321 | 321 | join recognizing | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
322 | 322 | willingness serve | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
323 | 323 | let talk | 1 | 5 | 6 | 4.35 | 18.52 | 2.078368223 | 0.149399814 | |
478 | 478 | economic impact | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
479 | 479 | largest investment | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
480 | 480 | budget calls | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
481 | 481 | service sacrifice | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
482 | 482 | year want | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
483 | 483 | god continue | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
484 | 484 | air force | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
485 | 485 | water quality | energy/environment | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
486 | 486 | lowest unemployment | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
487 | 487 | high paying jobs | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
488 | 488 | like ve | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
489 | 489 | want begin | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
490 | 490 | high demand jobs | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
491 | 491 | health issues | health care | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
492 | 492 | government spending | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
493 | 493 | god continue bless | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
494 | 494 | ve great | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
495 | 495 | continue bless great | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
496 | 496 | child welfare | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
497 | 497 | children foster care | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
498 | 498 | children foster | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
499 | 499 | think agree | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
500 | 500 | important issue | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
501 | 501 | increase number | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
502 | 502 | today like | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
503 | 503 | future state | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
504 | 504 | bachelor degree | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
505 | 505 | step forward | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
506 | 506 | state today | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
507 | 507 | continue bless | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
508 | 508 | join thanking | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
509 | 509 | special interests | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
510 | 510 | tax cuts | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
511 | 511 | high paying | economy/fiscal issues | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
512 | 512 | mental health issues | mental health/substance abuse | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
513 | 513 | teacher pay raise | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
514 | 514 | school boards | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
515 | 515 | school college | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
516 | 516 | department transportation | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
517 | 517 | make sense | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
518 | 518 | access high | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
519 | 519 | private partnership | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
520 | 520 | school student | education | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
521 | 521 | help reduce | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 | |
522 | 522 | demand jobs | 1 | 4 | 5 | 4.35 | 14.81 | 1.360708535 | 0.243414724 |
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 );