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 total_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 |
---|---|---|---|---|---|---|---|---|
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) |
6 | 6 | 2019-02-03 | Amy Klobuchar | 64 | 1454 | 79183 | 0.0440165061898211 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
49 | 49 | 2019-02-03 | Andrew Yang | 0 | 1454 | 79183 | 0.0 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
92 | 92 | 2019-02-03 | Bernie Sanders | 162 | 1454 | 79183 | 0.1114167812929848 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
135 | 135 | 2019-02-03 | Beto O'Rourke | 82 | 1454 | 79183 | 0.0563961485557083 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
178 | 178 | 2019-02-03 | Bill de Blasio | 3 | 1454 | 79183 | 0.0020632737276478 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
216 | 216 | 2019-02-03 | Cory Booker | 246 | 1454 | 79183 | 0.1691884456671251 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
259 | 259 | 2019-02-03 | Elizabeth Warren | 564 | 1454 | 79183 | 0.3878954607977992 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
302 | 302 | 2019-02-03 | Eric Swalwell | 28 | 1454 | 79183 | 0.0192572214580467 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
330 | 330 | 2019-02-03 | Jay Inslee | 6 | 1454 | 79183 | 0.0041265474552957 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
364 | 364 | 2019-02-03 | Joe Biden | 156 | 1454 | 79183 | 0.1072902338376891 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
407 | 407 | 2019-02-03 | Joe Sestak | 0 | 1454 | 79183 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
450 | 450 | 2019-02-03 | John Delaney | 1 | 1454 | 79183 | 0.0006877579092159 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
493 | 493 | 2019-02-03 | John Hickenlooper | 2 | 1454 | 79183 | 0.0013755158184319 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
526 | 526 | 2019-02-03 | Julian Castro | 26 | 1454 | 79183 | 0.0178817056396148 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
569 | 569 | 2019-02-03 | Kamala Harris | 238 | 1454 | 79183 | 0.1636863823933975 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
612 | 612 | 2019-02-03 | Kirsten Gillibrand | 62 | 1454 | 79183 | 0.0426409903713892 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
647 | 647 | 2019-02-03 | Marianne Williamson | 0 | 1454 | 79183 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
690 | 690 | 2019-02-03 | Michael Bennet | 0 | 1454 | 79183 | 0.0 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
733 | 733 | 2019-02-03 | Mike Gravel | 0 | 1454 | 79183 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
765 | 765 | 2019-02-03 | Pete Buttigieg | 1 | 1454 | 79183 | 0.0006877579092159 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
808 | 808 | 2019-02-03 | Seth Moulton | 0 | 1454 | 79183 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
842 | 842 | 2019-02-03 | Steve Bullock | 0 | 1454 | 79183 | 0.0 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
885 | 885 | 2019-02-03 | Tim Ryan | 4 | 1454 | 79183 | 0.0027510316368638 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
928 | 928 | 2019-02-03 | Tom Steyer | 5 | 1454 | 79183 | 0.0034387895460797 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
971 | 971 | 2019-02-03 | Tulsi Gabbard | 34 | 1454 | 79183 | 0.0233837689133425 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
5 | 5 | 2019-01-27 | Amy Klobuchar | 16 | 1914 | 80994 | 0.0083594566353187 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
48 | 48 | 2019-01-27 | Andrew Yang | 3 | 1914 | 80994 | 0.0015673981191222 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
91 | 91 | 2019-01-27 | Bernie Sanders | 146 | 1914 | 80994 | 0.0762800417972831 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
134 | 134 | 2019-01-27 | Beto O'Rourke | 28 | 1914 | 80994 | 0.0146290491118077 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
177 | 177 | 2019-01-27 | Bill de Blasio | 3 | 1914 | 80994 | 0.0015673981191222 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
215 | 215 | 2019-01-27 | Cory Booker | 378 | 1914 | 80994 | 0.1974921630094044 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
258 | 258 | 2019-01-27 | Elizabeth Warren | 354 | 1914 | 80994 | 0.1849529780564263 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
301 | 301 | 2019-01-27 | Eric Swalwell | 27 | 1914 | 80994 | 0.0141065830721003 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
329 | 329 | 2019-01-27 | Jay Inslee | 2 | 1914 | 80994 | 0.0010449320794148 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
363 | 363 | 2019-01-27 | Joe Biden | 185 | 1914 | 80994 | 0.0966562173458725 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
406 | 406 | 2019-01-27 | Joe Sestak | 0 | 1914 | 80994 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
449 | 449 | 2019-01-27 | John Delaney | 3 | 1914 | 80994 | 0.0015673981191222 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
492 | 492 | 2019-01-27 | John Hickenlooper | 3 | 1914 | 80994 | 0.0015673981191222 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
525 | 525 | 2019-01-27 | Julian Castro | 55 | 1914 | 80994 | 0.028735632183908 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
568 | 568 | 2019-01-27 | Kamala Harris | 905 | 1914 | 80994 | 0.4728317659352142 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
611 | 611 | 2019-01-27 | Kirsten Gillibrand | 43 | 1914 | 80994 | 0.022466039707419 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
646 | 646 | 2019-01-27 | Marianne Williamson | 0 | 1914 | 80994 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
689 | 689 | 2019-01-27 | Michael Bennet | 3 | 1914 | 80994 | 0.0015673981191222 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
732 | 732 | 2019-01-27 | Mike Gravel | 0 | 1914 | 80994 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
764 | 764 | 2019-01-27 | Pete Buttigieg | 3 | 1914 | 80994 | 0.0015673981191222 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
807 | 807 | 2019-01-27 | Seth Moulton | 0 | 1914 | 80994 | 0.0 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
841 | 841 | 2019-01-27 | Steve Bullock | 5 | 1914 | 80994 | 0.002612330198537 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
884 | 884 | 2019-01-27 | Tim Ryan | 2 | 1914 | 80994 | 0.0010449320794148 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
927 | 927 | 2019-01-27 | Tom Steyer | 7 | 1914 | 80994 | 0.0036572622779519 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
970 | 970 | 2019-01-27 | Tulsi Gabbard | 15 | 1914 | 80994 | 0.0078369905956112 | ("Tulsi Gabbard") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
10 | 10 | 2019-03-03 | Amy Klobuchar | 57 | 1587 | 81321 | 0.0359168241965973 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
53 | 53 | 2019-03-03 | Andrew Yang | 5 | 1587 | 81321 | 0.0031505986137366 | ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
96 | 96 | 2019-03-03 | Bernie Sanders | 521 | 1587 | 81321 | 0.3282923755513548 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
139 | 139 | 2019-03-03 | Beto O'Rourke | 76 | 1587 | 81321 | 0.0478890989287964 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
182 | 182 | 2019-03-03 | Bill de Blasio | 7 | 1587 | 81321 | 0.0044108380592312 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
220 | 220 | 2019-03-03 | Cory Booker | 92 | 1587 | 81321 | 0.0579710144927536 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
263 | 263 | 2019-03-03 | Elizabeth Warren | 217 | 1587 | 81321 | 0.1367359798361688 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
306 | 306 | 2019-03-03 | Eric Swalwell | 21 | 1587 | 81321 | 0.0132325141776937 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
334 | 334 | 2019-03-03 | Jay Inslee | 60 | 1587 | 81321 | 0.0378071833648393 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
368 | 368 | 2019-03-03 | Joe Biden | 440 | 1587 | 81321 | 0.2772526780088217 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
411 | 411 | 2019-03-03 | Joe Sestak | 0 | 1587 | 81321 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
454 | 454 | 2019-03-03 | John Delaney | 19 | 1587 | 81321 | 0.0119722747321991 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
497 | 497 | 2019-03-03 | John Hickenlooper | 90 | 1587 | 81321 | 0.0567107750472589 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
530 | 530 | 2019-03-03 | Julian Castro | 8 | 1587 | 81321 | 0.0050409577819785 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
573 | 573 | 2019-03-03 | Kamala Harris | 151 | 1587 | 81321 | 0.0951480781348456 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
616 | 616 | 2019-03-03 | Kirsten Gillibrand | 23 | 1587 | 81321 | 0.0144927536231884 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
651 | 651 | 2019-03-03 | Marianne Williamson | 0 | 1587 | 81321 | 0.0 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
694 | 694 | 2019-03-03 | Michael Bennet | 1 | 1587 | 81321 | 0.0006301197227473 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
737 | 737 | 2019-03-03 | Mike Gravel | 0 | 1587 | 81321 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
769 | 769 | 2019-03-03 | Pete Buttigieg | 16 | 1587 | 81321 | 0.0100819155639571 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
812 | 812 | 2019-03-03 | Seth Moulton | 1 | 1587 | 81321 | 0.0006301197227473 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
846 | 846 | 2019-03-03 | Steve Bullock | 3 | 1587 | 81321 | 0.0018903591682419 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
889 | 889 | 2019-03-03 | Tim Ryan | 0 | 1587 | 81321 | 0.0 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
932 | 932 | 2019-03-03 | Tom Steyer | 20 | 1587 | 81321 | 0.0126023944549464 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
975 | 975 | 2019-03-03 | Tulsi Gabbard | 21 | 1587 | 81321 | 0.0132325141776937 | ("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 );