home / fivethirtyeight

Media Mentions 2020: online_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_stories, query

Link rowid date name matched_stories all_candidate_stories pct_of_all_candidate_stories query
1 2018-12-30 Amy Klobuchar 45 788 0.05710659898477158 "Amy Klobuchar"
2 2019-01-06 Amy Klobuchar 54 872 0.06192660550458716 "Amy Klobuchar"
3 2019-01-13 Amy Klobuchar 125 1013 0.123395853899309 "Amy Klobuchar"
4 2019-01-20 Amy Klobuchar 54 999 0.054054054054054064 "Amy Klobuchar"
5 2019-01-27 Amy Klobuchar 73 1564 0.046675191815856776 "Amy Klobuchar"
6 2019-02-03 Amy Klobuchar 142 1386 0.10245310245310243 "Amy Klobuchar"
7 2019-02-10 Amy Klobuchar 402 1527 0.2632612966601179 "Amy Klobuchar"
8 2019-02-17 Amy Klobuchar 243 1350 0.18 "Amy Klobuchar"
9 2019-02-24 Amy Klobuchar 166 1223 0.1357318070318888 "Amy Klobuchar"
10 2019-03-03 Amy Klobuchar 230 1369 0.16800584368151936 "Amy Klobuchar"
11 2019-03-10 Amy Klobuchar 173 1608 0.10758706467661693 "Amy Klobuchar"
12 2019-03-17 Amy Klobuchar 207 1444 0.1433518005540166 "Amy Klobuchar"
13 2019-03-24 Amy Klobuchar 155 1041 0.148895292987512 "Amy Klobuchar"
14 2019-03-31 Amy Klobuchar 139 1522 0.09132720105124836 "Amy Klobuchar"
15 2019-04-07 Amy Klobuchar 185 1490 0.12416107382550336 "Amy Klobuchar"
16 2019-04-14 Amy Klobuchar 175 1730 0.10115606936416184 "Amy Klobuchar"
17 2019-04-21 Amy Klobuchar 228 2126 0.10724365004703668 "Amy Klobuchar"
18 2019-04-28 Amy Klobuchar 182 1693 0.10750147666863556 "Amy Klobuchar"
19 2019-05-05 Amy Klobuchar 131 1444 0.0907202216066482 "Amy Klobuchar"
20 2019-05-12 Amy Klobuchar 151 1775 0.08507042253521127 "Amy Klobuchar"
21 2019-05-19 Amy Klobuchar 145 1445 0.10034602076124567 "Amy Klobuchar"
22 2019-05-26 Amy Klobuchar 117 1355 0.08634686346863467 "Amy Klobuchar"
23 2019-06-02 Amy Klobuchar 135 1536 0.087890625 "Amy Klobuchar"
24 2019-06-09 Amy Klobuchar 215 1844 0.11659436008676788 "Amy Klobuchar"
25 2019-06-16 Amy Klobuchar 146 1703 0.08573106283029946 "Amy Klobuchar"
26 2019-06-23 Amy Klobuchar 501 3221 0.1555417572182552 "Amy Klobuchar"
27 2018-12-30 Andrew Yang 2 788 0.0025380710659898475 "Andrew Yang"
28 2019-01-06 Andrew Yang 5 872 0.005733944954128441 "Andrew Yang"
29 2019-01-13 Andrew Yang 8 1013 0.007897334649555773 "Andrew Yang"
30 2019-01-20 Andrew Yang 6 999 0.006006006006006006 "Andrew Yang"
31 2019-01-27 Andrew Yang 14 1564 0.008951406649616368 "Andrew Yang"
32 2019-02-03 Andrew Yang 11 1386 0.007936507936507936 "Andrew Yang"
33 2019-02-10 Andrew Yang 26 1527 0.017026850032743943 "Andrew Yang"
34 2019-02-17 Andrew Yang 12 1350 0.008888888888888889 "Andrew Yang"
35 2019-02-24 Andrew Yang 11 1223 0.008994276369582993 "Andrew Yang"
36 2019-03-03 Andrew Yang 25 1369 0.01826150474799124 "Andrew Yang"
37 2019-03-10 Andrew Yang 32 1608 0.01990049751243781 "Andrew Yang"
38 2019-03-17 Andrew Yang 60 1444 0.04155124653739612 "Andrew Yang"
39 2019-03-24 Andrew Yang 29 1041 0.027857829010566763 "Andrew Yang"
40 2019-03-31 Andrew Yang 53 1522 0.03482260183968462 "Andrew Yang"
41 2019-04-07 Andrew Yang 65 1490 0.0436241610738255 "Andrew Yang"
42 2019-04-14 Andrew Yang 77 1730 0.04450867052023121 "Andrew Yang"
43 2019-04-21 Andrew Yang 46 2126 0.021636876763875827 "Andrew Yang"
44 2019-04-28 Andrew Yang 44 1693 0.02598936798582398 "Andrew Yang"
45 2019-05-05 Andrew Yang 40 1444 0.027700831024930747 "Andrew Yang"
46 2019-05-12 Andrew Yang 54 1775 0.030422535211267605 "Andrew Yang"
47 2019-05-19 Andrew Yang 59 1445 0.04083044982698962 "Andrew Yang"
48 2019-05-26 Andrew Yang 40 1355 0.029520295202952032 "Andrew Yang"
49 2019-06-02 Andrew Yang 30 1536 0.01953125 "Andrew Yang"
50 2019-06-09 Andrew Yang 124 1844 0.06724511930585682 "Andrew Yang"
51 2019-06-16 Andrew Yang 70 1703 0.04110393423370522 "Andrew Yang"
52 2019-06-23 Andrew Yang 320 3221 0.0993480285625582 "Andrew Yang"
53 2018-12-30 Bernie Sanders 276 788 0.350253807106599 "Bernie Sanders"
54 2019-01-06 Bernie Sanders 328 872 0.3761467889908257 "Bernie Sanders"
55 2019-01-13 Bernie Sanders 245 1013 0.2418558736426456 "Bernie Sanders"
56 2019-01-20 Bernie Sanders 291 999 0.2912912912912913 "Bernie Sanders"
57 2019-01-27 Bernie Sanders 405 1564 0.2589514066496164 "Bernie Sanders"
58 2019-02-03 Bernie Sanders 404 1386 0.29148629148629146 "Bernie Sanders"
59 2019-02-10 Bernie Sanders 349 1527 0.2285527177472168 "Bernie Sanders"
60 2019-02-17 Bernie Sanders 619 1350 0.4585185185185185 "Bernie Sanders"
61 2019-02-24 Bernie Sanders 614 1223 0.5020441537203598 "Bernie Sanders"
62 2019-03-03 Bernie Sanders 636 1369 0.4645726807888971 "Bernie Sanders"
63 2019-03-10 Bernie Sanders 541 1608 0.3364427860696517 "Bernie Sanders"
64 2019-03-17 Bernie Sanders 560 1444 0.3878116343490305 "Bernie Sanders"
65 2019-03-24 Bernie Sanders 349 1041 0.3352545629202689 "Bernie Sanders"
66 2019-03-31 Bernie Sanders 463 1522 0.30420499342969776 "Bernie Sanders"
67 2019-04-07 Bernie Sanders 605 1490 0.4060402684563759 "Bernie Sanders"
68 2019-04-14 Bernie Sanders 865 1730 0.5 "Bernie Sanders"
69 2019-04-21 Bernie Sanders 853 2126 0.4012229539040452 "Bernie Sanders"
70 2019-04-28 Bernie Sanders 585 1693 0.3455404607206143 "Bernie Sanders"
71 2019-05-05 Bernie Sanders 466 1444 0.32271468144044324 "Bernie Sanders"
72 2019-05-12 Bernie Sanders 625 1775 0.35211267605633795 "Bernie Sanders"
73 2019-05-19 Bernie Sanders 460 1445 0.31833910034602075 "Bernie Sanders"
74 2019-05-26 Bernie Sanders 390 1355 0.2878228782287823 "Bernie Sanders"
75 2019-06-02 Bernie Sanders 527 1536 0.3430989583333333 "Bernie Sanders"
76 2019-06-09 Bernie Sanders 707 1844 0.3834056399132321 "Bernie Sanders"
77 2019-06-16 Bernie Sanders 575 1703 0.3376394597768644 "Bernie Sanders"
78 2019-06-23 Bernie Sanders 1334 3221 0.4141570940701645 "Bernie Sanders"
79 2018-12-30 Beto O'Rourke 41 788 0.05203045685279188 "Beto O'Rourke"
80 2019-01-06 Beto O'Rourke 59 872 0.0676605504587156 "Beto O'Rourke"
81 2019-01-13 Beto O'Rourke 52 1013 0.05133267522211254 "Beto O'Rourke"
82 2019-01-20 Beto O'Rourke 21 999 0.021021021021021026 "Beto O'Rourke"
83 2019-01-27 Beto O'Rourke 34 1564 0.021739130434782608 "Beto O'Rourke"
84 2019-02-03 Beto O'Rourke 62 1386 0.044733044733044736 "Beto O'Rourke"
85 2019-02-10 Beto O'Rourke 149 1527 0.09757694826457106 "Beto O'Rourke"
86 2019-02-17 Beto O'Rourke 49 1350 0.0362962962962963 "Beto O'Rourke"
87 2019-02-24 Beto O'Rourke 51 1223 0.041700735895339326 "Beto O'Rourke"
88 2019-03-03 Beto O'Rourke 53 1369 0.03871439006574142 "Beto O'Rourke"
89 2019-03-10 Beto O'Rourke 296 1608 0.18407960199004966 "Beto O'Rourke"
90 2019-03-17 Beto O'Rourke 269 1444 0.18628808864265928 "Beto O'Rourke"
91 2019-03-24 Beto O'Rourke 110 1041 0.10566762728146012 "Beto O'Rourke"
92 2019-03-31 Beto O'Rourke 101 1522 0.06636005256241786 "Beto O'Rourke"
93 2019-04-07 Beto O'Rourke 89 1490 0.059731543624161075 "Beto O'Rourke"
94 2019-04-14 Beto O'Rourke 106 1730 0.061271676300578025 "Beto O'Rourke"
95 2019-04-21 Beto O'Rourke 84 2126 0.03951081843838194 "Beto O'Rourke"
96 2019-04-28 Beto O'Rourke 111 1693 0.06556408741878322 "Beto O'Rourke"
97 2019-05-05 Beto O'Rourke 63 1444 0.043628808864265935 "Beto O'Rourke"
98 2019-05-12 Beto O'Rourke 107 1775 0.06028169014084508 "Beto O'Rourke"
99 2019-05-19 Beto O'Rourke 94 1445 0.06505190311418685 "Beto O'Rourke"
100 2019-05-26 Beto O'Rourke 78 1355 0.05756457564575645 "Beto O'Rourke"

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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