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 total
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 |
---|---|---|---|---|---|---|---|---|---|---|
29 | 29 | pre existing conditions | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
30 | 30 | need make sure | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 | |
31 | 31 | reproductive health | health care | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
32 | 32 | educators deserve | education | 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 | |
34 | 34 | energy future | energy/environment | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
35 | 35 | economy works | economy/fiscal issues | 5 | 0 | 5 | 21.74 | 0.0 | 5.869565217 | 0.015404856 |
36 | 36 | existing conditions | health care | 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 | |
38 | 38 | cost health | health care | 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 | |
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 | |
233 | 233 | state want | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
234 | 234 | start business | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
235 | 235 | unemployment rate lowest | economy/fiscal issues | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
236 | 236 | family leave | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
237 | 237 | expanded medicaid | health care | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
238 | 238 | support need | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
239 | 239 | state great | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
240 | 240 | help state | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
241 | 241 | facing state | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
242 | 242 | air water | energy/environment | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
243 | 243 | today stand | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
244 | 244 | equal rights | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
245 | 245 | education health | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
246 | 246 | eager work | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
247 | 247 | work day | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
248 | 248 | decades ago | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
249 | 249 | state funding | economy/fiscal issues | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
250 | 250 | need continue | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
251 | 251 | progress past | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
252 | 252 | rapidly changing | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
253 | 253 | need invest | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
254 | 254 | partisan issue | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
255 | 255 | paid family leave | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
256 | 256 | place people | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
257 | 257 | public lands | energy/environment | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
258 | 258 | year degree | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
259 | 259 | training programs | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
260 | 260 | children future | education | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 |
261 | 261 | skilled workforce | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
262 | 262 | signed executive | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
263 | 263 | administration work | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
264 | 264 | make decisions | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
265 | 265 | make easier | 4 | 1 | 5 | 17.39 | 3.7 | 2.32689211 | 0.127155523 | |
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 |
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 );