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 date
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") |
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") |
213 | 213 | 2019-01-13 | Cory Booker | 131 | 1052 | 0.1245247148288973 | ("Cory Booker") |
256 | 256 | 2019-01-13 | Elizabeth Warren | 325 | 1052 | 0.30893536121673 | ("Elizabeth Warren") |
299 | 299 | 2019-01-13 | Eric Swalwell | 32 | 1052 | 0.0304182509505703 | ("Eric Swalwell") |
327 | 327 | 2019-01-13 | Jay Inslee | 26 | 1052 | 0.0247148288973384 | ("Jay Inslee") |
361 | 361 | 2019-01-13 | Joe Biden | 117 | 1052 | 0.1112167300380228 | ("Joe Biden") |
404 | 404 | 2019-01-13 | Joe Sestak | 1 | 1052 | 0.0009505703422053 | ("Joe Sestak") |
447 | 447 | 2019-01-13 | John Delaney | 41 | 1052 | 0.0389733840304182 | ("John Delaney") |
490 | 490 | 2019-01-13 | John Hickenlooper | 9 | 1052 | 0.0085551330798479 | ("John Hickenlooper") |
523 | 523 | 2019-01-13 | Julian Castro | 159 | 1052 | 0.1511406844106463 | ("Julian Castro" OR "Julián Castro") |
566 | 566 | 2019-01-13 | Kamala Harris | 220 | 1052 | 0.2091254752851711 | ("Kamala Harris") |
609 | 609 | 2019-01-13 | Kirsten Gillibrand | 258 | 1052 | 0.2452471482889733 | ("Kirsten Gillibrand") |
644 | 644 | 2019-01-13 | Marianne Williamson | 2 | 1052 | 0.0019011406844106 | ("Marianne Williamson") |
687 | 687 | 2019-01-13 | Michael Bennet | 5 | 1052 | 0.0047528517110266 | ("Michael Bennet") |
730 | 730 | 2019-01-13 | Mike Gravel | 0 | 1052 | 0.0 | ("Mike Gravel") |
762 | 762 | 2019-01-13 | Pete Buttigieg | 19 | 1052 | 0.0180608365019011 | ("Pete Buttigieg") |
805 | 805 | 2019-01-13 | Seth Moulton | 12 | 1052 | 0.0114068441064638 | ("Seth Moulton") |
839 | 839 | 2019-01-13 | Steve Bullock | 10 | 1052 | 0.0095057034220532 | ("Steve Bullock") |
882 | 882 | 2019-01-13 | Tim Ryan | 40 | 1052 | 0.0380228136882129 | ("Tim Ryan") |
925 | 925 | 2019-01-13 | Tom Steyer | 23 | 1052 | 0.0218631178707224 | ("Tom Steyer") |
968 | 968 | 2019-01-13 | Tulsi Gabbard | 171 | 1052 | 0.1625475285171102 | ("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") |
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 );