Media Mentions 2020: cable_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_clips | all_candidate_clips | total_clips | pct_of_all_candidate_clips | query |
---|---|---|---|---|---|---|---|---|
1 | 1 | 2018-12-30 | Amy Klobuchar | 12 | 1279 | 76029 | 0.0093823299452697 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
44 | 44 | 2018-12-30 | Andrew Yang | 0 | 1279 | 76029 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
87 | 87 | 2018-12-30 | Bernie Sanders | 246 | 1279 | 76029 | 0.1923377638780297 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
130 | 130 | 2018-12-30 | Beto O'Rourke | 101 | 1279 | 76029 | 0.0789679437060203 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
173 | 173 | 2018-12-30 | Bill de Blasio | 2 | 1279 | 76029 | 0.0015637216575449 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
211 | 211 | 2018-12-30 | Cory Booker | 39 | 1279 | 76029 | 0.0304925723221266 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
254 | 254 | 2018-12-30 | Elizabeth Warren | 721 | 1279 | 76029 | 0.5637216575449571 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
297 | 297 | 2018-12-30 | Eric Swalwell | 31 | 1279 | 76029 | 0.0242376856919468 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
325 | 325 | 2018-12-30 | Jay Inslee | 4 | 1279 | 76029 | 0.0031274433150899 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
359 | 359 | 2018-12-30 | Joe Biden | 177 | 1279 | 76029 | 0.1383893666927287 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
402 | 402 | 2018-12-30 | Joe Sestak | 0 | 1279 | 76029 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
445 | 445 | 2018-12-30 | John Delaney | 5 | 1279 | 76029 | 0.0039093041438623 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
488 | 488 | 2018-12-30 | John Hickenlooper | 1 | 1279 | 76029 | 0.0007818608287724 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
521 | 521 | 2018-12-30 | Julian Castro | 5 | 1279 | 76029 | 0.0039093041438623 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
564 | 564 | 2018-12-30 | Kamala Harris | 74 | 1279 | 76029 | 0.0578577013291634 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
607 | 607 | 2018-12-30 | Kirsten Gillibrand | 8 | 1279 | 76029 | 0.0062548866301798 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
642 | 642 | 2018-12-30 | Marianne Williamson | 0 | 1279 | 76029 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
685 | 685 | 2018-12-30 | Michael Bennet | 0 | 1279 | 76029 | 0.0 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
728 | 728 | 2018-12-30 | Mike Gravel | 0 | 1279 | 76029 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
760 | 760 | 2018-12-30 | Pete Buttigieg | 0 | 1279 | 76029 | 0.0 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
803 | 803 | 2018-12-30 | Seth Moulton | 0 | 1279 | 76029 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
837 | 837 | 2018-12-30 | Steve Bullock | 0 | 1279 | 76029 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
880 | 880 | 2018-12-30 | Tim Ryan | 14 | 1279 | 76029 | 0.0109460516028147 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
923 | 923 | 2018-12-30 | Tom Steyer | 12 | 1279 | 76029 | 0.0093823299452697 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
966 | 966 | 2018-12-30 | Tulsi Gabbard | 0 | 1279 | 76029 | 0.0 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
2 | 2 | 2019-01-06 | Amy Klobuchar | 7 | 1031 | 82964 | 0.0067895247332686 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
45 | 45 | 2019-01-06 | Andrew Yang | 0 | 1031 | 82964 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
88 | 88 | 2019-01-06 | Bernie Sanders | 134 | 1031 | 82964 | 0.1299709020368574 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
131 | 131 | 2019-01-06 | Beto O'Rourke | 127 | 1031 | 82964 | 0.1231813773035887 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
174 | 174 | 2019-01-06 | Bill de Blasio | 23 | 1031 | 82964 | 0.0223084384093113 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
212 | 212 | 2019-01-06 | Cory Booker | 15 | 1031 | 82964 | 0.01454898157129 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
255 | 255 | 2019-01-06 | Elizabeth Warren | 424 | 1031 | 82964 | 0.4112512124151309 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
298 | 298 | 2019-01-06 | Eric Swalwell | 22 | 1031 | 82964 | 0.0213385063045586 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
326 | 326 | 2019-01-06 | Jay Inslee | 7 | 1031 | 82964 | 0.0067895247332686 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
360 | 360 | 2019-01-06 | Joe Biden | 183 | 1031 | 82964 | 0.1774975751697381 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
403 | 403 | 2019-01-06 | Joe Sestak | 0 | 1031 | 82964 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
446 | 446 | 2019-01-06 | John Delaney | 2 | 1031 | 82964 | 0.0019398642095053 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
489 | 489 | 2019-01-06 | John Hickenlooper | 1 | 1031 | 82964 | 0.0009699321047526 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
522 | 522 | 2019-01-06 | Julian Castro | 68 | 1031 | 82964 | 0.0659553831231813 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
565 | 565 | 2019-01-06 | Kamala Harris | 99 | 1031 | 82964 | 0.096023278370514 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
608 | 608 | 2019-01-06 | Kirsten Gillibrand | 2 | 1031 | 82964 | 0.0019398642095053 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
643 | 643 | 2019-01-06 | Marianne Williamson | 0 | 1031 | 82964 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
686 | 686 | 2019-01-06 | Michael Bennet | 0 | 1031 | 82964 | 0.0 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
729 | 729 | 2019-01-06 | Mike Gravel | 0 | 1031 | 82964 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
761 | 761 | 2019-01-06 | Pete Buttigieg | 0 | 1031 | 82964 | 0.0 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
804 | 804 | 2019-01-06 | Seth Moulton | 0 | 1031 | 82964 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
838 | 838 | 2019-01-06 | Steve Bullock | 0 | 1031 | 82964 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
881 | 881 | 2019-01-06 | Tim Ryan | 3 | 1031 | 82964 | 0.002909796314258 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
924 | 924 | 2019-01-06 | Tom Steyer | 11 | 1031 | 82964 | 0.0106692531522793 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
967 | 967 | 2019-01-06 | Tulsi Gabbard | 16 | 1031 | 82964 | 0.0155189136760426 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
3 | 3 | 2019-01-13 | Amy Klobuchar | 45 | 615 | 82521 | 0.073170731707317 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
46 | 46 | 2019-01-13 | Andrew Yang | 0 | 615 | 82521 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
89 | 89 | 2019-01-13 | Bernie Sanders | 70 | 615 | 82521 | 0.1138211382113821 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
132 | 132 | 2019-01-13 | Beto O'Rourke | 78 | 615 | 82521 | 0.1268292682926829 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
175 | 175 | 2019-01-13 | Bill de Blasio | 25 | 615 | 82521 | 0.040650406504065 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
213 | 213 | 2019-01-13 | Cory Booker | 31 | 615 | 82521 | 0.0504065040650406 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
256 | 256 | 2019-01-13 | Elizabeth Warren | 105 | 615 | 82521 | 0.1707317073170731 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
299 | 299 | 2019-01-13 | Eric Swalwell | 19 | 615 | 82521 | 0.0308943089430894 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
327 | 327 | 2019-01-13 | Jay Inslee | 0 | 615 | 82521 | 0.0 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
361 | 361 | 2019-01-13 | Joe Biden | 104 | 615 | 82521 | 0.1691056910569105 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
404 | 404 | 2019-01-13 | Joe Sestak | 0 | 615 | 82521 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
447 | 447 | 2019-01-13 | John Delaney | 5 | 615 | 82521 | 0.008130081300813 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
490 | 490 | 2019-01-13 | John Hickenlooper | 0 | 615 | 82521 | 0.0 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
523 | 523 | 2019-01-13 | Julian Castro | 48 | 615 | 82521 | 0.0780487804878048 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
566 | 566 | 2019-01-13 | Kamala Harris | 64 | 615 | 82521 | 0.1040650406504065 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
609 | 609 | 2019-01-13 | Kirsten Gillibrand | 94 | 615 | 82521 | 0.1528455284552845 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
644 | 644 | 2019-01-13 | Marianne Williamson | 0 | 615 | 82521 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
687 | 687 | 2019-01-13 | Michael Bennet | 0 | 615 | 82521 | 0.0 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
730 | 730 | 2019-01-13 | Mike Gravel | 0 | 615 | 82521 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
762 | 762 | 2019-01-13 | Pete Buttigieg | 0 | 615 | 82521 | 0.0 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
805 | 805 | 2019-01-13 | Seth Moulton | 0 | 615 | 82521 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
839 | 839 | 2019-01-13 | Steve Bullock | 0 | 615 | 82521 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
882 | 882 | 2019-01-13 | Tim Ryan | 1 | 615 | 82521 | 0.0016260162601626 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
925 | 925 | 2019-01-13 | Tom Steyer | 2 | 615 | 82521 | 0.0032520325203252 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
968 | 968 | 2019-01-13 | Tulsi Gabbard | 28 | 615 | 82521 | 0.0455284552845528 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
4 | 4 | 2019-01-20 | Amy Klobuchar | 10 | 991 | 83649 | 0.0100908173562058 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
47 | 47 | 2019-01-20 | Andrew Yang | 1 | 991 | 83649 | 0.0010090817356205 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
90 | 90 | 2019-01-20 | Bernie Sanders | 147 | 991 | 83649 | 0.148335015136226 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
133 | 133 | 2019-01-20 | Beto O'Rourke | 27 | 991 | 83649 | 0.0272452068617558 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
176 | 176 | 2019-01-20 | Bill de Blasio | 3 | 991 | 83649 | 0.0030272452068617 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
214 | 214 | 2019-01-20 | Cory Booker | 59 | 991 | 83649 | 0.0595358224016145 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
257 | 257 | 2019-01-20 | Elizabeth Warren | 158 | 991 | 83649 | 0.1594349142280524 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
300 | 300 | 2019-01-20 | Eric Swalwell | 31 | 991 | 83649 | 0.0312815338042381 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
328 | 328 | 2019-01-20 | Jay Inslee | 7 | 991 | 83649 | 0.007063572149344 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
362 | 362 | 2019-01-20 | Joe Biden | 155 | 991 | 83649 | 0.1564076690211907 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
405 | 405 | 2019-01-20 | Joe Sestak | 0 | 991 | 83649 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
448 | 448 | 2019-01-20 | John Delaney | 2 | 991 | 83649 | 0.0020181634712411 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
491 | 491 | 2019-01-20 | John Hickenlooper | 3 | 991 | 83649 | 0.0030272452068617 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
524 | 524 | 2019-01-20 | Julian Castro | 8 | 991 | 83649 | 0.0080726538849646 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
567 | 567 | 2019-01-20 | Kamala Harris | 366 | 991 | 83649 | 0.3693239152371342 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
610 | 610 | 2019-01-20 | Kirsten Gillibrand | 93 | 991 | 83649 | 0.0938446014127144 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
645 | 645 | 2019-01-20 | Marianne Williamson | 0 | 991 | 83649 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
688 | 688 | 2019-01-20 | Michael Bennet | 18 | 991 | 83649 | 0.0181634712411705 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
731 | 731 | 2019-01-20 | Mike Gravel | 0 | 991 | 83649 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
763 | 763 | 2019-01-20 | Pete Buttigieg | 23 | 991 | 83649 | 0.0232088799192734 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
806 | 806 | 2019-01-20 | Seth Moulton | 0 | 991 | 83649 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
840 | 840 | 2019-01-20 | Steve Bullock | 0 | 991 | 83649 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
883 | 883 | 2019-01-20 | Tim Ryan | 1 | 991 | 83649 | 0.0010090817356205 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
926 | 926 | 2019-01-20 | Tom Steyer | 0 | 991 | 83649 | 0.0 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
969 | 969 | 2019-01-20 | Tulsi Gabbard | 22 | 991 | 83649 | 0.0221997981836528 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "media-mentions-2020/cable_weekly" ( "date" TEXT, "name" TEXT, "matched_clips" INTEGER, "all_candidate_clips" INTEGER, "total_clips" INTEGER, "pct_of_all_candidate_clips" REAL, "query" TEXT );