home / fivethirtyeight

Media Mentions 2020: cable_weekly.csv

This table contains the data behind a series of stories about how often 2020 Democratic candidates are mentioned in cable news.

Cable News

cable_weekly.csv contains the mentions of currently declared major candidates for the 2020 Democratic primary since December 30, 2018 across CNN, Fox News, and MSNBC. The TV News Archive measures coverage by splitting daily news footage into 15-second clips and finding the clips that contain a mention of our search query. Our search queries are the full names of each candidate.

Column Description
date Start date for the week of coverage. A week of coverage spans from Sunday through Saturday. The cutoff for measuring coverage for any given day is midnight Eastern Standard Time. (Clock changes for Daylight Saving Time are ignored.)
name Candidate's name
matched_clips Number of 15-second clips that match query
all_candidate_clips Number of 15-second clips that match the following query ("Amy Klobuchar" OR "Andrew Yang" OR "Bernie Sanders" OR "Beto O'Rourke" OR "Bill de Blasio" OR "Cory Booker" OR "Elizabeth Warren" OR "Eric Swalwell" OR "Jay Inslee" OR "Joe Biden" OR "John Delaney" OR "John Hickenlooper" OR "Julian Castro" OR "Julián Castro" OR "Kamala Harris" OR "Kirsten Gillibrand" OR "Marianne Williamson" OR "Michael Bennet" OR "Mike Gravel" OR "Pete Buttigieg" OR "Seth Moulton" OR "Steve Bullock" OR "Tim Ryan" OR "Tulsi Gabbard")
total_clips Total number of 15-second clips that week across the three networks
pct_of_all_candidate_clips (matched_clips / all_candidate_clips)
query Query for the GDELT Television API

Data is collected using the GDELT Television API, which processes the data from the TV News Archive.

Online News

online_weekly.csv contains the mentions of currently declared major candidates for the 2020 Democratic primary since December 30, 2018 across in online news stories from two collections in the Media Cloud database (U.S. Top Online News and U.S. Top Digital Native News).

Column Description
date Start date for the week of coverage. A week of coverage spans from Sunday through Saturday.
name Candidate's name
matched_stories Number of stories that match query
all_candidate_stories Number of stories that match the following query ("Amy Klobuchar" OR "Andrew Yang" OR "Bernie Sanders" OR "Beto O'Rourke" OR "Bill de Blasio" OR "Cory Booker" OR "Elizabeth Warren" OR "Eric Swalwell" OR "Jay Inslee" OR "Joe Biden" OR "John Delaney" OR "John Hickenlooper" OR "Julian Castro" OR "Julián Castro" OR "Kamala Harris" OR "Kirsten Gillibrand" OR "Marianne Williamson" OR "Michael Bennet" OR "Mike Gravel" OR "Pete Buttigieg" OR "Seth Moulton" OR "Steve Bullock" OR "Tim Ryan" OR "Tulsi Gabbard")
pct_of_all_candidate_stories (matched_stories / all_candidate_stories)
query Query for Media Cloud

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

598 rows

View and edit SQL

Suggested facets: date, name, all_candidate_clips, total_clips, query

Link rowid date name matched_clips all_candidate_clips total_clips pct_of_all_candidate_clips query
1 2018-12-30 John Delaney 5 1268 76029 0.003943217665615143 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
2 2019-01-06 John Delaney 2 1021 82964 0.0019588638589618022 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
3 2019-01-13 John Delaney 5 613 82521 0.008156606851549755 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
4 2019-01-20 John Delaney 2 991 83649 0.00201816347124117 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
5 2019-01-27 John Delaney 3 1908 80994 0.0015723270440251573 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
6 2019-02-03 John Delaney 1 1449 79183 0.0006901311249137336 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
7 2019-02-10 John Delaney 8 1913 81893 0.004181913225300575 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
8 2019-02-17 John Delaney 6 2416 82454 0.002483443708609272 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
9 2019-02-24 John Delaney 3 1529 82804 0.0019620667102681487 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
10 2019-03-03 John Delaney 19 1567 81321 0.012125079770261648 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
11 2019-03-10 John Delaney 27 2418 85812 0.011166253101736972 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
12 2019-03-17 John Delaney 26 3173 95383 0.008194138039710053 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
13 2019-03-24 John Delaney 14 1243 96184 0.011263073209975863 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
14 2019-03-31 John Delaney 19 4205 93472 0.004518430439952439 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
15 2019-04-07 John Delaney 7 2329 94405 0.0030055817947617003 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
16 2019-04-14 John Delaney 9 2598 95286 0.003464203233256351 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
17 2019-04-21 John Delaney 12 5716 94002 0.0020993701889433173 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
18 2019-04-28 John Delaney 16 3942 95339 0.004058853373921867 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
19 2019-05-05 John Delaney 4 2747 94528 0.0014561339643247178 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
20 2019-05-12 John Delaney 2 3688 94318 0.0005422993492407808 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
21 2019-05-19 John Delaney 13 2644 94883 0.004916792738275341 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
22 2019-05-26 John Delaney 13 3042 95289 0.004273504273504274 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
23 2019-06-02 John Delaney 45 3099 95313 0.014520813165537268 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
24 2019-06-09 John Delaney 30 4776 95839 0.00628140703517588 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
25 2019-06-16 John Delaney 15 4478 96026 0.0033497096918267085 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
26 2019-06-23 John Delaney 105 7311 96553 0.014361920393926959 ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS)
27 2018-12-30 Andrew Yang 0 1268 76029 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
28 2019-01-06 Andrew Yang 0 1021 82964 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
29 2019-01-13 Andrew Yang 0 613 82521 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
30 2019-01-20 Andrew Yang 1 991 83649 0.001009081735620585 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
31 2019-01-27 Andrew Yang 3 1908 80994 0.0015723270440251573 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
32 2019-02-03 Andrew Yang 0 1449 79183 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
33 2019-02-10 Andrew Yang 3 1913 81893 0.0015682174594877155 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
34 2019-02-17 Andrew Yang 6 2416 82454 0.002483443708609272 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
35 2019-02-24 Andrew Yang 3 1529 82804 0.0019620667102681487 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
36 2019-03-03 Andrew Yang 5 1567 81321 0.003190810465858328 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
37 2019-03-10 Andrew Yang 2 2418 85812 0.0008271298593879237 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
38 2019-03-17 Andrew Yang 13 3173 95383 0.0040970690198550265 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
39 2019-03-24 Andrew Yang 4 1243 96184 0.0032180209171359607 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
40 2019-03-31 Andrew Yang 32 4205 93472 0.00760998810939358 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
41 2019-04-07 Andrew Yang 21 2329 94405 0.009016745384285102 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
42 2019-04-14 Andrew Yang 39 2598 95286 0.015011547344110853 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
43 2019-04-21 Andrew Yang 18 5716 94002 0.0031490552834149755 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
44 2019-04-28 Andrew Yang 10 3942 95339 0.002536783358701167 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
45 2019-05-05 Andrew Yang 20 2747 94528 0.007280669821623589 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
46 2019-05-12 Andrew Yang 11 3688 94318 0.002982646420824295 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
47 2019-05-19 Andrew Yang 13 2644 94883 0.004916792738275341 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
48 2019-05-26 Andrew Yang 10 3042 95289 0.003287310979618672 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
49 2019-06-02 Andrew Yang 5 3099 95313 0.0016134236850596966 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
50 2019-06-09 Andrew Yang 42 4776 95839 0.008793969849246231 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
51 2019-06-16 Andrew Yang 47 4478 96026 0.010495757034390351 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
52 2019-06-23 Andrew Yang 67 7311 96553 0.00916427301326768 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
53 2018-12-30 Beto O'Rourke 101 1268 76029 0.07965299684542587 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
54 2019-01-06 Beto O'Rourke 127 1021 82964 0.12438785504407444 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
55 2019-01-13 Beto O'Rourke 78 613 82521 0.1272430668841762 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
56 2019-01-20 Beto O'Rourke 27 991 83649 0.027245206861755803 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
57 2019-01-27 Beto O'Rourke 28 1908 80994 0.014675052410901468 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
58 2019-02-03 Beto O'Rourke 82 1449 79183 0.05659075224292615 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
59 2019-02-10 Beto O'Rourke 418 1913 81893 0.21850496602195504 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
60 2019-02-17 Beto O'Rourke 102 2416 82454 0.042218543046357616 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
61 2019-02-24 Beto O'Rourke 78 1529 82804 0.05101373446697188 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
62 2019-03-03 Beto O'Rourke 76 1567 81321 0.04850031908104658 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
63 2019-03-10 Beto O'Rourke 870 2418 85812 0.3598014888337469 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
64 2019-03-17 Beto O'Rourke 870 3173 95383 0.2741884651749133 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
65 2019-03-24 Beto O'Rourke 255 1243 96184 0.20514883346741755 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
66 2019-03-31 Beto O'Rourke 300 4205 93472 0.0713436385255648 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
67 2019-04-07 Beto O'Rourke 136 2329 94405 0.0583941605839416 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
68 2019-04-14 Beto O'Rourke 163 2598 95286 0.06274056966897612 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
69 2019-04-21 Beto O'Rourke 155 5716 94002 0.027116864940517845 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
70 2019-04-28 Beto O'Rourke 221 3942 95339 0.05606291222729578 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
71 2019-05-05 Beto O'Rourke 90 2747 94528 0.03276301419730615 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
72 2019-05-12 Beto O'Rourke 217 3688 94318 0.058839479392624724 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
73 2019-05-19 Beto O'Rourke 187 2644 94883 0.07072617246596066 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
74 2019-05-26 Beto O'Rourke 112 3042 95289 0.03681788297172912 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
75 2019-06-02 Beto O'Rourke 92 3099 95313 0.02968699580509842 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
76 2019-06-09 Beto O'Rourke 209 4776 95839 0.04376046901172529 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
77 2019-06-16 Beto O'Rourke 104 4478 96026 0.023224653863331845 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
78 2019-06-23 Beto O'Rourke 445 7311 96553 0.060867186431404735 ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS)
79 2018-12-30 John Hickenlooper 1 1268 76029 0.0007886435331230284 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
80 2019-01-06 John Hickenlooper 1 1021 82964 0.0009794319294809011 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
81 2019-01-13 John Hickenlooper 0 613 82521 0.0 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
82 2019-01-20 John Hickenlooper 3 991 83649 0.003027245206861756 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
83 2019-01-27 John Hickenlooper 3 1908 80994 0.0015723270440251573 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
84 2019-02-03 John Hickenlooper 2 1449 79183 0.0013802622498274672 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
85 2019-02-10 John Hickenlooper 0 1913 81893 0.0 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
86 2019-02-17 John Hickenlooper 3 2416 82454 0.0012417218543046358 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
87 2019-02-24 John Hickenlooper 4 1529 82804 0.002616088947024199 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
88 2019-03-03 John Hickenlooper 90 1567 81321 0.0574345883854499 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
89 2019-03-10 John Hickenlooper 15 2418 85812 0.00620347394540943 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
90 2019-03-17 John Hickenlooper 102 3173 95383 0.032146233848093286 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
91 2019-03-24 John Hickenlooper 22 1243 96184 0.017699115044247787 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
92 2019-03-31 John Hickenlooper 17 4205 93472 0.004042806183115339 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
93 2019-04-07 John Hickenlooper 11 2329 94405 0.0047230571060541005 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
94 2019-04-14 John Hickenlooper 7 2598 95286 0.0026943802925327174 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
95 2019-04-21 John Hickenlooper 1 5716 94002 0.0001749475157452764 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
96 2019-04-28 John Hickenlooper 21 3942 95339 0.00532724505327245 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
97 2019-05-05 John Hickenlooper 12 2747 94528 0.004368401892974154 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
98 2019-05-12 John Hickenlooper 13 3688 94318 0.0035249457700650758 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
99 2019-05-19 John Hickenlooper 9 2644 94883 0.00340393343419062 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)
100 2019-05-26 John Hickenlooper 33 3042 95289 0.010848126232741616 ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
)
Powered by Datasette · Query took 24.834ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub