Media Mentions 2020: online_weekly.csv

Table actions

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 · About: simonw/fivethirtyeight-datasette

1,008 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: name, query, date (date)

Link rowid ▼ date name matched_stories all_candidate_stories pct_of_all_candidate_stories query
1 1 2018-12-30 Amy Klobuchar 45 806 0.0558312655086848 ("Amy Klobuchar")
2 2 2019-01-06 Amy Klobuchar 55 915 0.0601092896174863 ("Amy Klobuchar")
3 3 2019-01-13 Amy Klobuchar 128 1052 0.1216730038022813 ("Amy Klobuchar")
4 4 2019-01-20 Amy Klobuchar 55 1024 0.0537109375 ("Amy Klobuchar")
5 5 2019-01-27 Amy Klobuchar 74 1605 0.0461059190031152 ("Amy Klobuchar")
6 6 2019-02-03 Amy Klobuchar 143 1428 0.1001400560224089 ("Amy Klobuchar")
7 7 2019-02-10 Amy Klobuchar 411 1612 0.2549627791563275 ("Amy Klobuchar")
8 8 2019-02-17 Amy Klobuchar 256 1406 0.182076813655761 ("Amy Klobuchar")
9 9 2019-02-24 Amy Klobuchar 169 1286 0.1314152410575427 ("Amy Klobuchar")
10 10 2019-03-03 Amy Klobuchar 242 1485 0.1629629629629629 ("Amy Klobuchar")
11 11 2019-03-10 Amy Klobuchar 185 1810 0.1022099447513812 ("Amy Klobuchar")
12 12 2019-03-17 Amy Klobuchar 223 1591 0.1401634192331866 ("Amy Klobuchar")
13 13 2019-03-24 Amy Klobuchar 167 1166 0.1432246998284734 ("Amy Klobuchar")
14 14 2019-03-31 Amy Klobuchar 150 1714 0.087514585764294 ("Amy Klobuchar")
15 15 2019-04-07 Amy Klobuchar 192 1600 0.12 ("Amy Klobuchar")
16 16 2019-04-14 Amy Klobuchar 190 1936 0.0981404958677686 ("Amy Klobuchar")
17 17 2019-04-21 Amy Klobuchar 251 2320 0.1081896551724137 ("Amy Klobuchar")
18 18 2019-04-28 Amy Klobuchar 191 1834 0.104143947655398 ("Amy Klobuchar")
19 19 2019-05-05 Amy Klobuchar 148 1577 0.0938490805326569 ("Amy Klobuchar")
20 20 2019-05-12 Amy Klobuchar 165 1952 0.0845286885245901 ("Amy Klobuchar")
21 21 2019-05-19 Amy Klobuchar 157 1580 0.0993670886075949 ("Amy Klobuchar")
22 22 2019-05-26 Amy Klobuchar 128 1474 0.0868385345997286 ("Amy Klobuchar")
23 23 2019-06-02 Amy Klobuchar 143 1652 0.0865617433414043 ("Amy Klobuchar")
24 24 2019-06-09 Amy Klobuchar 235 2049 0.11469009272816 ("Amy Klobuchar")
25 25 2019-06-16 Amy Klobuchar 155 1882 0.0823591923485653 ("Amy Klobuchar")
26 26 2019-06-23 Amy Klobuchar 548 3561 0.1538893569222128 ("Amy Klobuchar")
27 27 2019-06-30 Amy Klobuchar 151 1672 0.090311004784689 ("Amy Klobuchar")
28 28 2019-07-07 Amy Klobuchar 131 1880 0.0696808510638297 ("Amy Klobuchar")
29 29 2019-07-14 Amy Klobuchar 167 1802 0.0926748057713651 ("Amy Klobuchar")
30 30 2019-07-21 Amy Klobuchar 121 1414 0.0855728429985855 ("Amy Klobuchar")
31 31 2019-07-28 Amy Klobuchar 406 3210 0.1264797507788162 ("Amy Klobuchar")
32 32 2019-08-04 Amy Klobuchar 161 1937 0.0831182240578213 ("Amy Klobuchar")
33 33 2019-08-11 Amy Klobuchar 102 1513 0.0674157303370786 ("Amy Klobuchar")
34 34 2019-08-18 Amy Klobuchar 123 1451 0.0847691247415575 ("Amy Klobuchar")
35 35 2019-08-25 Amy Klobuchar 85 950 0.0894736842105263 ("Amy Klobuchar")
36 36 2019-09-01 Amy Klobuchar 142 1309 0.108479755538579 ("Amy Klobuchar")
37 37 2019-09-08 Amy Klobuchar 367 1957 0.1875319366377107 ("Amy Klobuchar")
38 38 2019-09-15 Amy Klobuchar 211 2071 0.1018831482375663 ("Amy Klobuchar")
39 39 2019-09-22 Amy Klobuchar 110 3682 0.0298750678978815 ("Amy Klobuchar")
40 40 2019-09-29 Amy Klobuchar 94 3355 0.0280178837555886 ("Amy Klobuchar")
41 41 2019-10-06 Amy Klobuchar 121 2459 0.049206994713298 ("Amy Klobuchar")
42 42 2019-10-13 Amy Klobuchar 382 2788 0.1370157819225251 ("Amy Klobuchar")
43 43 2019-10-20 Amy Klobuchar 175 1994 0.0877632898696088 ("Amy Klobuchar")
44 44 2018-12-30 Andrew Yang 2 806 0.0024813895781637 ("Andrew Yang")
45 45 2019-01-06 Andrew Yang 6 915 0.0065573770491803 ("Andrew Yang")
46 46 2019-01-13 Andrew Yang 9 1052 0.0085551330798479 ("Andrew Yang")
47 47 2019-01-20 Andrew Yang 7 1024 0.0068359375 ("Andrew Yang")
48 48 2019-01-27 Andrew Yang 14 1605 0.0087227414330218 ("Andrew Yang")
49 49 2019-02-03 Andrew Yang 11 1428 0.0077030812324929 ("Andrew Yang")
50 50 2019-02-10 Andrew Yang 28 1612 0.0173697270471464 ("Andrew Yang")
51 51 2019-02-17 Andrew Yang 13 1406 0.0092460881934566 ("Andrew Yang")
52 52 2019-02-24 Andrew Yang 12 1286 0.0093312597200622 ("Andrew Yang")
53 53 2019-03-03 Andrew Yang 27 1485 0.0181818181818181 ("Andrew Yang")
54 54 2019-03-10 Andrew Yang 37 1810 0.0204419889502762 ("Andrew Yang")
55 55 2019-03-17 Andrew Yang 66 1591 0.0414833438089252 ("Andrew Yang")
56 56 2019-03-24 Andrew Yang 30 1166 0.0257289879931389 ("Andrew Yang")
57 57 2019-03-31 Andrew Yang 57 1714 0.0332555425904317 ("Andrew Yang")
58 58 2019-04-07 Andrew Yang 70 1600 0.04375 ("Andrew Yang")
59 59 2019-04-14 Andrew Yang 88 1936 0.0454545454545454 ("Andrew Yang")
60 60 2019-04-21 Andrew Yang 49 2320 0.0211206896551724 ("Andrew Yang")
61 61 2019-04-28 Andrew Yang 46 1834 0.025081788440567 ("Andrew Yang")
62 62 2019-05-05 Andrew Yang 43 1577 0.0272669625871908 ("Andrew Yang")
63 63 2019-05-12 Andrew Yang 60 1952 0.0307377049180327 ("Andrew Yang")
64 64 2019-05-19 Andrew Yang 64 1580 0.040506329113924 ("Andrew Yang")
65 65 2019-05-26 Andrew Yang 42 1474 0.0284938941655359 ("Andrew Yang")
66 66 2019-06-02 Andrew Yang 35 1652 0.0211864406779661 ("Andrew Yang")
67 67 2019-06-09 Andrew Yang 138 2049 0.0673499267935578 ("Andrew Yang")
68 68 2019-06-16 Andrew Yang 77 1882 0.040913921360255 ("Andrew Yang")
69 69 2019-06-23 Andrew Yang 349 3561 0.0980061780398764 ("Andrew Yang")
70 70 2019-06-30 Andrew Yang 66 1672 0.0394736842105263 ("Andrew Yang")
71 71 2019-07-07 Andrew Yang 65 1880 0.0345744680851063 ("Andrew Yang")
72 72 2019-07-14 Andrew Yang 110 1802 0.0610432852386237 ("Andrew Yang")
73 73 2019-07-21 Andrew Yang 52 1414 0.0367751060820367 ("Andrew Yang")
74 74 2019-07-28 Andrew Yang 307 3210 0.0956386292834891 ("Andrew Yang")
75 75 2019-08-04 Andrew Yang 116 1937 0.0598864223025296 ("Andrew Yang")
76 76 2019-08-11 Andrew Yang 130 1513 0.0859220092531394 ("Andrew Yang")
77 77 2019-08-18 Andrew Yang 94 1451 0.0647829083390765 ("Andrew Yang")
78 78 2019-08-25 Andrew Yang 121 950 0.1273684210526315 ("Andrew Yang")
79 79 2019-09-01 Andrew Yang 157 1309 0.119938884644767 ("Andrew Yang")
80 80 2019-09-08 Andrew Yang 400 1957 0.2043944813490035 ("Andrew Yang")
81 81 2019-09-15 Andrew Yang 244 2071 0.1178174794785128 ("Andrew Yang")
82 82 2019-09-22 Andrew Yang 102 3682 0.0277023356871265 ("Andrew Yang")
83 83 2019-09-29 Andrew Yang 163 3355 0.0485842026825633 ("Andrew Yang")
84 84 2019-10-06 Andrew Yang 87 2459 0.0353802358682391 ("Andrew Yang")
85 85 2019-10-13 Andrew Yang 277 2788 0.0993543758967001 ("Andrew Yang")
86 86 2019-10-20 Andrew Yang 120 1994 0.0601805416248746 ("Andrew Yang")
87 87 2018-12-30 Bernie Sanders 277 806 0.3436724565756824 ("Bernie Sanders")
88 88 2019-01-06 Bernie Sanders 329 915 0.3595628415300546 ("Bernie Sanders")
89 89 2019-01-13 Bernie Sanders 250 1052 0.2376425855513308 ("Bernie Sanders")
90 90 2019-01-20 Bernie Sanders 297 1024 0.2900390625 ("Bernie Sanders")
91 91 2019-01-27 Bernie Sanders 410 1605 0.2554517133956386 ("Bernie Sanders")
92 92 2019-02-03 Bernie Sanders 412 1428 0.2885154061624649 ("Bernie Sanders")
93 93 2019-02-10 Bernie Sanders 359 1612 0.2227047146401985 ("Bernie Sanders")
94 94 2019-02-17 Bernie Sanders 633 1406 0.4502133712660028 ("Bernie Sanders")
95 95 2019-02-24 Bernie Sanders 628 1286 0.4883359253499222 ("Bernie Sanders")
96 96 2019-03-03 Bernie Sanders 667 1485 0.4491582491582491 ("Bernie Sanders")
97 97 2019-03-10 Bernie Sanders 585 1810 0.3232044198895027 ("Bernie Sanders")
98 98 2019-03-17 Bernie Sanders 599 1591 0.376492771841609 ("Bernie Sanders")
99 99 2019-03-24 Bernie Sanders 380 1166 0.3259005145797599 ("Bernie Sanders")
100 100 2019-03-31 Bernie Sanders 521 1714 0.3039673278879813 ("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
);