Media Mentions 2020: online_weekly.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,008 rows sorted by all_candidate_stories
This data as json, copyable, CSV (advanced)
Suggested facets: name, query, date (date)
Link | rowid | date | name | matched_stories | all_candidate_stories ▼ | pct_of_all_candidate_stories | query |
---|---|---|---|---|---|---|---|
1 | 1 | 2018-12-30 | Amy Klobuchar | 45 | 806 | 0.0558312655086848 | ("Amy Klobuchar") |
44 | 44 | 2018-12-30 | Andrew Yang | 2 | 806 | 0.0024813895781637 | ("Andrew Yang") |
87 | 87 | 2018-12-30 | Bernie Sanders | 277 | 806 | 0.3436724565756824 | ("Bernie Sanders") |
130 | 130 | 2018-12-30 | Beto O'Rourke | 43 | 806 | 0.053349875930521 | ("Beto O'Rourke") |
173 | 173 | 2018-12-30 | Bill de Blasio | 46 | 806 | 0.0570719602977667 | ("Bill de Blasio") |
211 | 211 | 2018-12-30 | Cory Booker | 96 | 806 | 0.119106699751861 | ("Cory Booker") |
254 | 254 | 2018-12-30 | Elizabeth Warren | 443 | 806 | 0.5496277915632755 | ("Elizabeth Warren") |
297 | 297 | 2018-12-30 | Eric Swalwell | 27 | 806 | 0.0334987593052109 | ("Eric Swalwell") |
325 | 325 | 2018-12-30 | Jay Inslee | 24 | 806 | 0.0297766749379652 | ("Jay Inslee") |
359 | 359 | 2018-12-30 | Joe Biden | 158 | 806 | 0.1960297766749379 | ("Joe Biden") |
402 | 402 | 2018-12-30 | Joe Sestak | 0 | 806 | 0.0 | ("Joe Sestak") |
445 | 445 | 2018-12-30 | John Delaney | 38 | 806 | 0.0471464019851116 | ("John Delaney") |
488 | 488 | 2018-12-30 | John Hickenlooper | 10 | 806 | 0.0124069478908188 | ("John Hickenlooper") |
521 | 521 | 2018-12-30 | Julian Castro | 47 | 806 | 0.0583126550868486 | ("Julian Castro" OR "Julián Castro") |
564 | 564 | 2018-12-30 | Kamala Harris | 138 | 806 | 0.1712158808933002 | ("Kamala Harris") |
607 | 607 | 2018-12-30 | Kirsten Gillibrand | 63 | 806 | 0.0781637717121588 | ("Kirsten Gillibrand") |
642 | 642 | 2018-12-30 | Marianne Williamson | 1 | 806 | 0.0012406947890818 | ("Marianne Williamson") |
685 | 685 | 2018-12-30 | Michael Bennet | 2 | 806 | 0.0024813895781637 | ("Michael Bennet") |
728 | 728 | 2018-12-30 | Mike Gravel | 0 | 806 | 0.0 | ("Mike Gravel") |
760 | 760 | 2018-12-30 | Pete Buttigieg | 8 | 806 | 0.009925558312655 | ("Pete Buttigieg") |
803 | 803 | 2018-12-30 | Seth Moulton | 11 | 806 | 0.0136476426799007 | ("Seth Moulton") |
837 | 837 | 2018-12-30 | Steve Bullock | 6 | 806 | 0.0074441687344913 | ("Steve Bullock") |
880 | 880 | 2018-12-30 | Tim Ryan | 27 | 806 | 0.0334987593052109 | ("Tim Ryan") |
923 | 923 | 2018-12-30 | Tom Steyer | 41 | 806 | 0.0508684863523573 | ("Tom Steyer") |
966 | 966 | 2018-12-30 | Tulsi Gabbard | 17 | 806 | 0.021091811414392 | ("Tulsi Gabbard") |
2 | 2 | 2019-01-06 | Amy Klobuchar | 55 | 915 | 0.0601092896174863 | ("Amy Klobuchar") |
45 | 45 | 2019-01-06 | Andrew Yang | 6 | 915 | 0.0065573770491803 | ("Andrew Yang") |
88 | 88 | 2019-01-06 | Bernie Sanders | 329 | 915 | 0.3595628415300546 | ("Bernie Sanders") |
131 | 131 | 2019-01-06 | Beto O'Rourke | 61 | 915 | 0.0666666666666666 | ("Beto O'Rourke") |
174 | 174 | 2019-01-06 | Bill de Blasio | 80 | 915 | 0.087431693989071 | ("Bill de Blasio") |
212 | 212 | 2019-01-06 | Cory Booker | 132 | 915 | 0.1442622950819672 | ("Cory Booker") |
255 | 255 | 2019-01-06 | Elizabeth Warren | 321 | 915 | 0.3508196721311475 | ("Elizabeth Warren") |
298 | 298 | 2019-01-06 | Eric Swalwell | 12 | 915 | 0.0131147540983606 | ("Eric Swalwell") |
326 | 326 | 2019-01-06 | Jay Inslee | 37 | 915 | 0.0404371584699453 | ("Jay Inslee") |
360 | 360 | 2019-01-06 | Joe Biden | 162 | 915 | 0.1770491803278688 | ("Joe Biden") |
403 | 403 | 2019-01-06 | Joe Sestak | 0 | 915 | 0.0 | ("Joe Sestak") |
446 | 446 | 2019-01-06 | John Delaney | 51 | 915 | 0.0557377049180327 | ("John Delaney") |
489 | 489 | 2019-01-06 | John Hickenlooper | 10 | 915 | 0.0109289617486338 | ("John Hickenlooper") |
522 | 522 | 2019-01-06 | Julian Castro | 118 | 915 | 0.1289617486338797 | ("Julian Castro" OR "Julián Castro") |
565 | 565 | 2019-01-06 | Kamala Harris | 236 | 915 | 0.2579234972677595 | ("Kamala Harris") |
608 | 608 | 2019-01-06 | Kirsten Gillibrand | 68 | 915 | 0.0743169398907103 | ("Kirsten Gillibrand") |
643 | 643 | 2019-01-06 | Marianne Williamson | 1 | 915 | 0.0010928961748633 | ("Marianne Williamson") |
686 | 686 | 2019-01-06 | Michael Bennet | 7 | 915 | 0.0076502732240437 | ("Michael Bennet") |
729 | 729 | 2019-01-06 | Mike Gravel | 0 | 915 | 0.0 | ("Mike Gravel") |
761 | 761 | 2019-01-06 | Pete Buttigieg | 3 | 915 | 0.0032786885245901 | ("Pete Buttigieg") |
804 | 804 | 2019-01-06 | Seth Moulton | 3 | 915 | 0.0032786885245901 | ("Seth Moulton") |
838 | 838 | 2019-01-06 | Steve Bullock | 10 | 915 | 0.0109289617486338 | ("Steve Bullock") |
881 | 881 | 2019-01-06 | Tim Ryan | 10 | 915 | 0.0109289617486338 | ("Tim Ryan") |
924 | 924 | 2019-01-06 | Tom Steyer | 65 | 915 | 0.0710382513661202 | ("Tom Steyer") |
967 | 967 | 2019-01-06 | Tulsi Gabbard | 91 | 915 | 0.0994535519125683 | ("Tulsi Gabbard") |
35 | 35 | 2019-08-25 | Amy Klobuchar | 85 | 950 | 0.0894736842105263 | ("Amy Klobuchar") |
78 | 78 | 2019-08-25 | Andrew Yang | 121 | 950 | 0.1273684210526315 | ("Andrew Yang") |
121 | 121 | 2019-08-25 | Bernie Sanders | 399 | 950 | 0.42 | ("Bernie Sanders") |
164 | 164 | 2019-08-25 | Beto O'Rourke | 72 | 950 | 0.0757894736842105 | ("Beto O'Rourke") |
207 | 207 | 2019-08-25 | Bill de Blasio | 75 | 950 | 0.0789473684210526 | ("Bill de Blasio") |
245 | 245 | 2019-08-25 | Cory Booker | 144 | 950 | 0.151578947368421 | ("Cory Booker") |
288 | 288 | 2019-08-25 | Elizabeth Warren | 393 | 950 | 0.4136842105263157 | ("Elizabeth Warren") |
393 | 393 | 2019-08-25 | Joe Biden | 437 | 950 | 0.46 | ("Joe Biden") |
436 | 436 | 2019-08-25 | Joe Sestak | 15 | 950 | 0.0157894736842105 | ("Joe Sestak") |
479 | 479 | 2019-08-25 | John Delaney | 35 | 950 | 0.0368421052631578 | ("John Delaney") |
555 | 555 | 2019-08-25 | Julian Castro | 109 | 950 | 0.1147368421052631 | ("Julian Castro" OR "Julián Castro") |
598 | 598 | 2019-08-25 | Kamala Harris | 234 | 950 | 0.2463157894736842 | ("Kamala Harris") |
641 | 641 | 2019-08-25 | Kirsten Gillibrand | 105 | 950 | 0.1105263157894736 | ("Kirsten Gillibrand") |
676 | 676 | 2019-08-25 | Marianne Williamson | 59 | 950 | 0.0621052631578947 | ("Marianne Williamson") |
719 | 719 | 2019-08-25 | Michael Bennet | 54 | 950 | 0.0568421052631578 | ("Michael Bennet") |
794 | 794 | 2019-08-25 | Pete Buttigieg | 177 | 950 | 0.1863157894736842 | ("Pete Buttigieg") |
871 | 871 | 2019-08-25 | Steve Bullock | 61 | 950 | 0.0642105263157894 | ("Steve Bullock") |
914 | 914 | 2019-08-25 | Tim Ryan | 43 | 950 | 0.0452631578947368 | ("Tim Ryan") |
957 | 957 | 2019-08-25 | Tom Steyer | 86 | 950 | 0.0905263157894736 | ("Tom Steyer") |
1000 | 1000 | 2019-08-25 | Tulsi Gabbard | 77 | 950 | 0.0810526315789473 | ("Tulsi Gabbard") |
4 | 4 | 2019-01-20 | Amy Klobuchar | 55 | 1024 | 0.0537109375 | ("Amy Klobuchar") |
47 | 47 | 2019-01-20 | Andrew Yang | 7 | 1024 | 0.0068359375 | ("Andrew Yang") |
90 | 90 | 2019-01-20 | Bernie Sanders | 297 | 1024 | 0.2900390625 | ("Bernie Sanders") |
133 | 133 | 2019-01-20 | Beto O'Rourke | 22 | 1024 | 0.021484375 | ("Beto O'Rourke") |
176 | 176 | 2019-01-20 | Bill de Blasio | 41 | 1024 | 0.0400390625 | ("Bill de Blasio") |
214 | 214 | 2019-01-20 | Cory Booker | 135 | 1024 | 0.1318359375 | ("Cory Booker") |
257 | 257 | 2019-01-20 | Elizabeth Warren | 330 | 1024 | 0.322265625 | ("Elizabeth Warren") |
300 | 300 | 2019-01-20 | Eric Swalwell | 21 | 1024 | 0.0205078125 | ("Eric Swalwell") |
328 | 328 | 2019-01-20 | Jay Inslee | 19 | 1024 | 0.0185546875 | ("Jay Inslee") |
362 | 362 | 2019-01-20 | Joe Biden | 186 | 1024 | 0.181640625 | ("Joe Biden") |
405 | 405 | 2019-01-20 | Joe Sestak | 0 | 1024 | 0.0 | ("Joe Sestak") |
448 | 448 | 2019-01-20 | John Delaney | 35 | 1024 | 0.0341796875 | ("John Delaney") |
491 | 491 | 2019-01-20 | John Hickenlooper | 15 | 1024 | 0.0146484375 | ("John Hickenlooper") |
524 | 524 | 2019-01-20 | Julian Castro | 86 | 1024 | 0.083984375 | ("Julian Castro" OR "Julián Castro") |
567 | 567 | 2019-01-20 | Kamala Harris | 422 | 1024 | 0.412109375 | ("Kamala Harris") |
610 | 610 | 2019-01-20 | Kirsten Gillibrand | 238 | 1024 | 0.232421875 | ("Kirsten Gillibrand") |
645 | 645 | 2019-01-20 | Marianne Williamson | 3 | 1024 | 0.0029296875 | ("Marianne Williamson") |
688 | 688 | 2019-01-20 | Michael Bennet | 41 | 1024 | 0.0400390625 | ("Michael Bennet") |
731 | 731 | 2019-01-20 | Mike Gravel | 0 | 1024 | 0.0 | ("Mike Gravel") |
763 | 763 | 2019-01-20 | Pete Buttigieg | 89 | 1024 | 0.0869140625 | ("Pete Buttigieg") |
806 | 806 | 2019-01-20 | Seth Moulton | 4 | 1024 | 0.00390625 | ("Seth Moulton") |
840 | 840 | 2019-01-20 | Steve Bullock | 7 | 1024 | 0.0068359375 | ("Steve Bullock") |
883 | 883 | 2019-01-20 | Tim Ryan | 11 | 1024 | 0.0107421875 | ("Tim Ryan") |
926 | 926 | 2019-01-20 | Tom Steyer | 24 | 1024 | 0.0234375 | ("Tom Steyer") |
969 | 969 | 2019-01-20 | Tulsi Gabbard | 96 | 1024 | 0.09375 | ("Tulsi Gabbard") |
3 | 3 | 2019-01-13 | Amy Klobuchar | 128 | 1052 | 0.1216730038022813 | ("Amy Klobuchar") |
46 | 46 | 2019-01-13 | Andrew Yang | 9 | 1052 | 0.0085551330798479 | ("Andrew Yang") |
89 | 89 | 2019-01-13 | Bernie Sanders | 250 | 1052 | 0.2376425855513308 | ("Bernie Sanders") |
132 | 132 | 2019-01-13 | Beto O'Rourke | 55 | 1052 | 0.0522813688212927 | ("Beto O'Rourke") |
175 | 175 | 2019-01-13 | Bill de Blasio | 66 | 1052 | 0.0627376425855513 | ("Bill de Blasio") |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "media-mentions-2020/online_weekly" ( "date" TEXT, "name" TEXT, "matched_stories" INTEGER, "all_candidate_stories" INTEGER, "pct_of_all_candidate_stories" REAL, "query" TEXT );