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. All candidates are queried starting December 30, 2018, however candidates are removed from the query once they have dropped out from the race.

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). All candidates are queried starting December 30, 2018, however candidates are removed from the query once they have dropped out from the race.

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

899 rows

View and edit SQL

Suggested facets: name, query, date (date)

Link rowid date name matched_stories all_candidate_stories pct_of_all_candidate_stories query
1 2018-12-30 Amy Klobuchar 45 787 0.05717916137229988 ("Amy Klobuchar")
2 2019-01-06 Amy Klobuchar 55 912 0.06030701754385965 ("Amy Klobuchar")
3 2019-01-13 Amy Klobuchar 128 1028 0.1245136186770428 ("Amy Klobuchar")
4 2019-01-20 Amy Klobuchar 54 1012 0.0533596837944664 ("Amy Klobuchar")
5 2019-01-27 Amy Klobuchar 74 1594 0.04642409033877039 ("Amy Klobuchar")
6 2019-02-03 Amy Klobuchar 143 1394 0.10258249641319944 ("Amy Klobuchar")
7 2019-02-10 Amy Klobuchar 411 1596 0.2575187969924812 ("Amy Klobuchar")
8 2019-02-17 Amy Klobuchar 256 1399 0.18298784846318802 ("Amy Klobuchar")
9 2019-02-24 Amy Klobuchar 169 1257 0.13444709626093873 ("Amy Klobuchar")
10 2019-03-03 Amy Klobuchar 241 1473 0.16361167684996605 ("Amy Klobuchar")
11 2019-03-10 Amy Klobuchar 185 1788 0.1034675615212528 ("Amy Klobuchar")
12 2019-03-17 Amy Klobuchar 222 1572 0.14122137404580154 ("Amy Klobuchar")
13 2019-03-24 Amy Klobuchar 167 1114 0.14991023339317774 ("Amy Klobuchar")
14 2019-03-31 Amy Klobuchar 150 1699 0.08828722778104768 ("Amy Klobuchar")
15 2019-04-07 Amy Klobuchar 192 1547 0.12411118293471235 ("Amy Klobuchar")
16 2019-04-14 Amy Klobuchar 188 1876 0.10021321961620468 ("Amy Klobuchar")
17 2019-04-21 Amy Klobuchar 250 2295 0.10893246187363836 ("Amy Klobuchar")
18 2019-04-28 Amy Klobuchar 190 1805 0.10526315789473684 ("Amy Klobuchar")
19 2019-05-05 Amy Klobuchar 147 1549 0.0948999354422208 ("Amy Klobuchar")
20 2019-05-12 Amy Klobuchar 164 1942 0.08444902162718848 ("Amy Klobuchar")
21 2019-05-19 Amy Klobuchar 157 1571 0.09993634627625717 ("Amy Klobuchar")
22 2019-05-26 Amy Klobuchar 127 1452 0.087465564738292 ("Amy Klobuchar")
23 2019-06-02 Amy Klobuchar 143 1633 0.08756889161053276 ("Amy Klobuchar")
24 2019-06-09 Amy Klobuchar 233 2013 0.11574764033780427 ("Amy Klobuchar")
25 2019-06-16 Amy Klobuchar 155 1864 0.08315450643776824 ("Amy Klobuchar")
26 2019-06-23 Amy Klobuchar 547 3537 0.154650834040147 ("Amy Klobuchar")
27 2019-06-30 Amy Klobuchar 151 1662 0.09085439229843563 ("Amy Klobuchar")
28 2019-07-07 Amy Klobuchar 131 1855 0.07061994609164421 ("Amy Klobuchar")
29 2019-07-14 Amy Klobuchar 167 1787 0.09345271404588697 ("Amy Klobuchar")
30 2019-07-21 Amy Klobuchar 121 1408 0.0859375 ("Amy Klobuchar")
31 2019-07-28 Amy Klobuchar 402 3191 0.12597931682858038 ("Amy Klobuchar")
32 2019-08-04 Amy Klobuchar 160 1941 0.0824317362184441 ("Amy Klobuchar")
33 2019-08-11 Amy Klobuchar 102 1512 0.06746031746031746 ("Amy Klobuchar")
34 2019-08-18 Amy Klobuchar 123 1445 0.08512110726643599 ("Amy Klobuchar")
35 2019-08-25 Amy Klobuchar 83 944 0.08792372881355932 ("Amy Klobuchar")
36 2019-09-01 Amy Klobuchar 138 1282 0.10764430577223087 ("Amy Klobuchar")
37 2019-09-08 Amy Klobuchar 352 1894 0.1858500527983105 ("Amy Klobuchar")
38 2018-12-30 Andrew Yang 2 787 0.0025412960609911056 ("Andrew Yang")
39 2019-01-06 Andrew Yang 6 912 0.006578947368421052 ("Andrew Yang")
40 2019-01-13 Andrew Yang 9 1028 0.008754863813229572 ("Andrew Yang")
41 2019-01-20 Andrew Yang 6 1012 0.005928853754940711 ("Andrew Yang")
42 2019-01-27 Andrew Yang 14 1594 0.00878293601003764 ("Andrew Yang")
43 2019-02-03 Andrew Yang 11 1394 0.007890961262553802 ("Andrew Yang")
44 2019-02-10 Andrew Yang 28 1596 0.017543859649122806 ("Andrew Yang")
45 2019-02-17 Andrew Yang 13 1399 0.009292351679771264 ("Andrew Yang")
46 2019-02-24 Andrew Yang 12 1257 0.00954653937947494 ("Andrew Yang")
47 2019-03-03 Andrew Yang 27 1473 0.018329938900203662 ("Andrew Yang")
48 2019-03-10 Andrew Yang 36 1788 0.020134228187919462 ("Andrew Yang")
49 2019-03-17 Andrew Yang 66 1572 0.04198473282442748 ("Andrew Yang")
50 2019-03-24 Andrew Yang 30 1114 0.026929982046678638 ("Andrew Yang")
51 2019-03-31 Andrew Yang 57 1699 0.033549146556798116 ("Andrew Yang")
52 2019-04-07 Andrew Yang 70 1547 0.045248868778280535 ("Andrew Yang")
53 2019-04-14 Andrew Yang 86 1876 0.04584221748400853 ("Andrew Yang")
54 2019-04-21 Andrew Yang 49 2295 0.021350762527233117 ("Andrew Yang")
55 2019-04-28 Andrew Yang 45 1805 0.024930747922437674 ("Andrew Yang")
56 2019-05-05 Andrew Yang 42 1549 0.02711426726920594 ("Andrew Yang")
57 2019-05-12 Andrew Yang 60 1942 0.030895983522142127 ("Andrew Yang")
58 2019-05-19 Andrew Yang 64 1571 0.04073838319541693 ("Andrew Yang")
59 2019-05-26 Andrew Yang 42 1452 0.028925619834710745 ("Andrew Yang")
60 2019-06-02 Andrew Yang 35 1633 0.021432945499081445 ("Andrew Yang")
61 2019-06-09 Andrew Yang 138 2013 0.06855439642324887 ("Andrew Yang")
62 2019-06-16 Andrew Yang 77 1864 0.04130901287553648 ("Andrew Yang")
63 2019-06-23 Andrew Yang 348 3537 0.09838846480067856 ("Andrew Yang")
64 2019-06-30 Andrew Yang 66 1662 0.03971119133574008 ("Andrew Yang")
65 2019-07-07 Andrew Yang 65 1855 0.03504043126684636 ("Andrew Yang")
66 2019-07-14 Andrew Yang 110 1787 0.06155567991046446 ("Andrew Yang")
67 2019-07-21 Andrew Yang 52 1408 0.03693181818181818 ("Andrew Yang")
68 2019-07-28 Andrew Yang 305 3191 0.09558132246944533 ("Andrew Yang")
69 2019-08-04 Andrew Yang 116 1941 0.059763008758371976 ("Andrew Yang")
70 2019-08-11 Andrew Yang 130 1512 0.08597883597883597 ("Andrew Yang")
71 2019-08-18 Andrew Yang 94 1445 0.06505190311418685 ("Andrew Yang")
72 2019-08-25 Andrew Yang 118 944 0.125 ("Andrew Yang")
73 2019-09-01 Andrew Yang 155 1282 0.12090483619344773 ("Andrew Yang")
74 2019-09-08 Andrew Yang 386 1894 0.20380147835269272 ("Andrew Yang")
75 2018-12-30 Bernie Sanders 277 787 0.3519695044472681 ("Bernie Sanders")
76 2019-01-06 Bernie Sanders 329 912 0.3607456140350877 ("Bernie Sanders")
77 2019-01-13 Bernie Sanders 249 1028 0.2422178988326848 ("Bernie Sanders")
78 2019-01-20 Bernie Sanders 296 1012 0.2924901185770751 ("Bernie Sanders")
79 2019-01-27 Bernie Sanders 410 1594 0.2572145545796738 ("Bernie Sanders")
80 2019-02-03 Bernie Sanders 410 1394 0.29411764705882354 ("Bernie Sanders")
81 2019-02-10 Bernie Sanders 359 1596 0.22493734335839602 ("Bernie Sanders")
82 2019-02-17 Bernie Sanders 633 1399 0.4524660471765547 ("Bernie Sanders")
83 2019-02-24 Bernie Sanders 627 1257 0.4988066825775656 ("Bernie Sanders")
84 2019-03-03 Bernie Sanders 665 1473 0.45145960624575704 ("Bernie Sanders")
85 2019-03-10 Bernie Sanders 582 1788 0.325503355704698 ("Bernie Sanders")
86 2019-03-17 Bernie Sanders 597 1572 0.3797709923664122 ("Bernie Sanders")
87 2019-03-24 Bernie Sanders 380 1114 0.34111310592459604 ("Bernie Sanders")
88 2019-03-31 Bernie Sanders 519 1699 0.30547380812242503 ("Bernie Sanders")
89 2019-04-07 Bernie Sanders 635 1547 0.4104718810601163 ("Bernie Sanders")
90 2019-04-14 Bernie Sanders 940 1876 0.5010660980810234 ("Bernie Sanders")
91 2019-04-21 Bernie Sanders 919 2295 0.40043572984749454 ("Bernie Sanders")
92 2019-04-28 Bernie Sanders 621 1805 0.3440443213296399 ("Bernie Sanders")
93 2019-05-05 Bernie Sanders 488 1549 0.31504196255648803 ("Bernie Sanders")
94 2019-05-12 Bernie Sanders 661 1942 0.3403707518022657 ("Bernie Sanders")
95 2019-05-19 Bernie Sanders 485 1571 0.3087205601527689 ("Bernie Sanders")
96 2019-05-26 Bernie Sanders 413 1452 0.284435261707989 ("Bernie Sanders")
97 2019-06-02 Bernie Sanders 557 1633 0.3410900183710961 ("Bernie Sanders")
98 2019-06-09 Bernie Sanders 769 2013 0.3820168902136115 ("Bernie Sanders")
99 2019-06-16 Bernie Sanders 615 1864 0.3299356223175965 ("Bernie Sanders")
100 2019-06-23 Bernie Sanders 1437 3537 0.4062765055131468 ("Bernie Sanders")

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 454.05ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub