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 all_candidate_clips
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 |
---|---|---|---|---|---|---|---|---|
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) |
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) |
13 | 13 | 2019-03-24 | Amy Klobuchar | 69 | 1248 | 96184 | 0.0552884615384615 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
56 | 56 | 2019-03-24 | Andrew Yang | 4 | 1248 | 96184 | 0.0032051282051282 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
99 | 99 | 2019-03-24 | Bernie Sanders | 142 | 1248 | 96184 | 0.1137820512820512 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
142 | 142 | 2019-03-24 | Beto O'Rourke | 255 | 1248 | 96184 | 0.204326923076923 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
185 | 185 | 2019-03-24 | Bill de Blasio | 3 | 1248 | 96184 | 0.0024038461538461 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
223 | 223 | 2019-03-24 | Cory Booker | 121 | 1248 | 96184 | 0.0969551282051282 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
266 | 266 | 2019-03-24 | Elizabeth Warren | 135 | 1248 | 96184 | 0.1081730769230769 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
309 | 309 | 2019-03-24 | Eric Swalwell | 52 | 1248 | 96184 | 0.0416666666666666 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
337 | 337 | 2019-03-24 | Jay Inslee | 6 | 1248 | 96184 | 0.0048076923076923 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
371 | 371 | 2019-03-24 | Joe Biden | 321 | 1248 | 96184 | 0.2572115384615384 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
414 | 414 | 2019-03-24 | Joe Sestak | 0 | 1248 | 96184 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
457 | 457 | 2019-03-24 | John Delaney | 14 | 1248 | 96184 | 0.0112179487179487 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
500 | 500 | 2019-03-24 | John Hickenlooper | 22 | 1248 | 96184 | 0.0176282051282051 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
533 | 533 | 2019-03-24 | Julian Castro | 10 | 1248 | 96184 | 0.0080128205128205 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
576 | 576 | 2019-03-24 | Kamala Harris | 158 | 1248 | 96184 | 0.1266025641025641 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
619 | 619 | 2019-03-24 | Kirsten Gillibrand | 56 | 1248 | 96184 | 0.0448717948717948 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
654 | 654 | 2019-03-24 | Marianne Williamson | 0 | 1248 | 96184 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
697 | 697 | 2019-03-24 | Michael Bennet | 0 | 1248 | 96184 | 0.0 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
740 | 740 | 2019-03-24 | Mike Gravel | 0 | 1248 | 96184 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
772 | 772 | 2019-03-24 | Pete Buttigieg | 60 | 1248 | 96184 | 0.048076923076923 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
815 | 815 | 2019-03-24 | Seth Moulton | 1 | 1248 | 96184 | 0.000801282051282 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
849 | 849 | 2019-03-24 | Steve Bullock | 0 | 1248 | 96184 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
892 | 892 | 2019-03-24 | Tim Ryan | 1 | 1248 | 96184 | 0.000801282051282 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
935 | 935 | 2019-03-24 | Tom Steyer | 5 | 1248 | 96184 | 0.0040064102564102 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
978 | 978 | 2019-03-24 | Tulsi Gabbard | 4 | 1248 | 96184 | 0.0032051282051282 | ("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 );