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. 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

1,008 rows

✎ View and edit SQL

This data as json, 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.009382329945269744 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
2 2 2019-01-06 Amy Klobuchar 7 1031 82964 0.006789524733268671 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
3 3 2019-01-13 Amy Klobuchar 45 615 82521 0.07317073170731707 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
4 4 2019-01-20 Amy Klobuchar 10 991 83649 0.010090817356205851 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
5 5 2019-01-27 Amy Klobuchar 16 1914 80994 0.008359456635318705 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
6 6 2019-02-03 Amy Klobuchar 64 1454 79183 0.04401650618982118 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
7 7 2019-02-10 Amy Klobuchar 384 1917 81893 0.20031298904538344 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
8 8 2019-02-17 Amy Klobuchar 231 2422 82454 0.0953757225433526 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
9 9 2019-02-24 Amy Klobuchar 52 1545 82804 0.033656957928802585 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
10 10 2019-03-03 Amy Klobuchar 57 1587 81321 0.03591682419659736 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
11 11 2019-03-10 Amy Klobuchar 68 2431 85812 0.02797202797202797 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
12 12 2019-03-17 Amy Klobuchar 114 3174 95383 0.03591682419659736 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
13 13 2019-03-24 Amy Klobuchar 69 1248 96184 0.055288461538461536 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
14 14 2019-03-31 Amy Klobuchar 42 4205 93472 0.009988109393579072 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
15 15 2019-04-07 Amy Klobuchar 51 2345 94405 0.021748400852878463 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
16 16 2019-04-14 Amy Klobuchar 65 2639 95286 0.024630541871921183 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
17 17 2019-04-21 Amy Klobuchar 102 5749 94002 0.017742216037571753 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
18 18 2019-04-28 Amy Klobuchar 88 3956 95339 0.022244691607684528 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
19 19 2019-05-05 Amy Klobuchar 130 2748 94528 0.04730713245997089 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
20 20 2019-05-12 Amy Klobuchar 43 3694 94318 0.011640498105035191 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
21 21 2019-05-19 Amy Klobuchar 46 2650 94883 0.017358490566037738 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
22 22 2019-05-26 Amy Klobuchar 51 3059 95289 0.016672115070284408 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
23 23 2019-06-02 Amy Klobuchar 40 3103 95313 0.012890750886239123 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
24 24 2019-06-09 Amy Klobuchar 85 4780 95839 0.017782426778242686 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
25 25 2019-06-16 Amy Klobuchar 42 4485 96026 0.009364548494983277 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
26 26 2019-06-23 Amy Klobuchar 167 7316 96553 0.022826681246582832 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
27 27 2019-06-30 Amy Klobuchar 53 4384 92126 0.01208941605839416 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
28 28 2019-07-07 Amy Klobuchar 55 3052 94299 0.01802096985583224 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
29 29 2019-07-14 Amy Klobuchar 71 3029 94481 0.02344007923407065 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
30 30 2019-07-21 Amy Klobuchar 25 2574 96027 0.009712509712509712 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
31 31 2019-07-28 Amy Klobuchar 145 7361 95970 0.019698410542045918 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
32 32 2019-08-04 Amy Klobuchar 48 3028 95881 0.015852047556142668 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
33 33 2019-08-11 Amy Klobuchar 50 3288 94920 0.015206812652068129 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
34 34 2019-08-18 Amy Klobuchar 16 3488 94494 0.004587155963302753 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
35 35 2019-08-25 Amy Klobuchar 54 3171 94380 0.017029328287606442 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
36 36 2019-09-01 Amy Klobuchar 39 1829 93825 0.021323127392017496 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
37 37 2019-09-08 Amy Klobuchar 138 4164 94278 0.03314121037463977 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
38 38 2019-09-15 Amy Klobuchar 77 4248 94504 0.01812617702448211 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
39 39 2019-09-22 Amy Klobuchar 24 4582 96953 0.005237887385421213 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
40 40 2019-09-29 Amy Klobuchar 44 3986 93672 0.011038635223281485 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
41 41 2019-10-06 Amy Klobuchar 40 3030 94074 0.0132013201320132 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
42 42 2019-10-13 Amy Klobuchar 169 4393 94893 0.03847029364898703 ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS)
43 43 2019-10-20 Amy Klobuchar 102 3100 93205 0.032903225806451615 ("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)
45 45 2019-01-06 Andrew Yang 0 1031 82964 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
46 46 2019-01-13 Andrew Yang 0 615 82521 0.0 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
47 47 2019-01-20 Andrew Yang 1 991 83649 0.001009081735620585 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
48 48 2019-01-27 Andrew Yang 3 1914 80994 0.001567398119122257 ("Andrew Yang") (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)
50 50 2019-02-10 Andrew Yang 3 1917 81893 0.001564945226917058 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
51 51 2019-02-17 Andrew Yang 6 2422 82454 0.002477291494632535 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
52 52 2019-02-24 Andrew Yang 3 1545 82804 0.001941747572815534 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
53 53 2019-03-03 Andrew Yang 5 1587 81321 0.0031505986137366107 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
54 54 2019-03-10 Andrew Yang 2 2431 85812 0.0008227067050596463 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
55 55 2019-03-17 Andrew Yang 13 3174 95383 0.004095778197857593 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
56 56 2019-03-24 Andrew Yang 4 1248 96184 0.003205128205128205 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
57 57 2019-03-31 Andrew Yang 32 4205 93472 0.00760998810939358 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
58 58 2019-04-07 Andrew Yang 21 2345 94405 0.008955223880597015 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
59 59 2019-04-14 Andrew Yang 39 2639 95286 0.014778325123152709 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
60 60 2019-04-21 Andrew Yang 18 5749 94002 0.0031309793007479572 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
61 61 2019-04-28 Andrew Yang 10 3956 95339 0.0025278058645096056 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
62 62 2019-05-05 Andrew Yang 20 2748 94528 0.00727802037845706 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
63 63 2019-05-12 Andrew Yang 11 3694 94318 0.002977801840822956 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
64 64 2019-05-19 Andrew Yang 13 2650 94883 0.004905660377358491 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
65 65 2019-05-26 Andrew Yang 10 3059 95289 0.0032690421706440013 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
66 66 2019-06-02 Andrew Yang 5 3103 95313 0.0016113438607798904 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
67 67 2019-06-09 Andrew Yang 42 4780 95839 0.008786610878661089 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
68 68 2019-06-16 Andrew Yang 47 4485 96026 0.010479375696767 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
69 69 2019-06-23 Andrew Yang 67 7316 96553 0.009158009841443413 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
70 70 2019-06-30 Andrew Yang 20 4384 92126 0.004562043795620439 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
71 71 2019-07-07 Andrew Yang 18 3052 94299 0.005897771952817824 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
72 72 2019-07-14 Andrew Yang 33 3029 94481 0.010894684714427205 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
73 73 2019-07-21 Andrew Yang 16 2574 96027 0.006216006216006216 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
74 74 2019-07-28 Andrew Yang 155 7361 95970 0.02105692161391116 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
75 75 2019-08-04 Andrew Yang 45 3028 95881 0.014861294583883753 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
76 76 2019-08-11 Andrew Yang 109 3288 94920 0.03315085158150852 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
77 77 2019-08-18 Andrew Yang 48 3488 94494 0.013761467889908258 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
78 78 2019-08-25 Andrew Yang 57 3171 94380 0.017975402081362345 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
79 79 2019-09-01 Andrew Yang 43 1829 93825 0.023510114816839803 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
80 80 2019-09-08 Andrew Yang 150 4164 94278 0.03602305475504323 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
81 81 2019-09-15 Andrew Yang 104 4248 94504 0.024482109227871945 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
82 82 2019-09-22 Andrew Yang 30 4582 96953 0.0065473592317765155 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
83 83 2019-09-29 Andrew Yang 37 3986 93672 0.009282488710486704 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
84 84 2019-10-06 Andrew Yang 14 3030 94074 0.004620462046204621 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
85 85 2019-10-13 Andrew Yang 62 4393 94893 0.014113362167083997 ("Andrew Yang") (station:MSNBC OR station:CNN OR station:FOXNEWS)
86 86 2019-10-20 Andrew Yang 16 3100 93205 0.005161290322580645 ("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)
88 88 2019-01-06 Bernie Sanders 134 1031 82964 0.12997090203685746 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
89 89 2019-01-13 Bernie Sanders 70 615 82521 0.11382113821138212 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
90 90 2019-01-20 Bernie Sanders 147 991 83649 0.14833501513622604 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
91 91 2019-01-27 Bernie Sanders 146 1914 80994 0.07628004179728318 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
92 92 2019-02-03 Bernie Sanders 162 1454 79183 0.11141678129298486 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
93 93 2019-02-10 Bernie Sanders 101 1917 81893 0.05268648930620762 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
94 94 2019-02-17 Bernie Sanders 1039 2422 82454 0.4289843104872007 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
95 95 2019-02-24 Bernie Sanders 664 1545 82804 0.4297734627831715 ("Bernie Sanders") (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)
97 97 2019-03-10 Bernie Sanders 451 2431 85812 0.18552036199095026 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
98 98 2019-03-17 Bernie Sanders 467 3174 95383 0.1471329552614997 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
99 99 2019-03-24 Bernie Sanders 142 1248 96184 0.11378205128205128 ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS)
100 100 2019-03-31 Bernie Sanders 551 4205 93472 0.1310344827586207 ("Bernie Sanders") (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 86.82ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub