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_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 the query
total_clips Total number of 15-second clips that week across the three networks
pct (matched_clips / total_clips) * 100
query Query for the GDELT Television API

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

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

552 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, name, total_clips, query

Link rowid date name matched_clips total_clips pct query
1 1 2018-12-30 John Delaney 5 76029 0.006576437938155178 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
2 2 2019-01-06 John Delaney 2 82964 0.002410684152162384 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
3 3 2019-01-13 John Delaney 5 82521 0.006059063753468814 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
4 4 2019-01-20 John Delaney 2 83649 0.002390943107508757 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
5 5 2019-01-27 John Delaney 3 80994 0.00370397807244981 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
6 6 2019-02-03 John Delaney 1 79183 0.0012628973390753071 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
7 7 2019-02-10 John Delaney 8 81893 0.009768844712002248 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
8 8 2019-02-17 John Delaney 6 82454 0.007276784631430858 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
9 9 2019-02-24 John Delaney 3 82804 0.0036230133809960867 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
10 10 2019-03-03 John Delaney 19 81321 0.023364198669470367 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
11 11 2019-03-10 John Delaney 27 85812 0.0314641308907845 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
12 12 2019-03-17 John Delaney 26 95383 0.02725852615245904 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
13 13 2019-03-24 John Delaney 14 96184 0.014555435415453713 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
14 14 2019-03-31 John Delaney 19 93472 0.020326942827798702 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
15 15 2019-04-07 John Delaney 7 94405 0.00741486150097982 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
16 16 2019-04-14 John Delaney 9 95286 0.009445249039733015 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
17 17 2019-04-21 John Delaney 12 94002 0.012765685836471564 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
18 18 2019-04-28 John Delaney 16 95339 0.016782219238716582 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
19 19 2019-05-05 John Delaney 4 94528 0.0042315504400812455 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
20 20 2019-05-12 John Delaney 2 94318 0.0021204860153947284 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
21 21 2019-05-19 John Delaney 13 94883 0.013701084493534141 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
22 22 2019-05-26 John Delaney 13 95289 0.01364270797258865 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
23 23 2019-06-02 John Delaney 45 95313 0.04721286708004155 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
24 24 2019-06-09 John Delaney 30 95839 0.031302496895835724 "John Delaney" (station:MSNBC OR station:CNN OR station:FOXNEWS)
25 25 2018-12-30 Andrew Yang 0 76029 0.0 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
26 26 2019-01-06 Andrew Yang 0 82964 0.0 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
27 27 2019-01-13 Andrew Yang 0 82521 0.0 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
28 28 2019-01-20 Andrew Yang 1 83649 0.0011954715537543785 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
29 29 2019-01-27 Andrew Yang 3 80994 0.00370397807244981 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
30 30 2019-02-03 Andrew Yang 0 79183 0.0 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
31 31 2019-02-10 Andrew Yang 3 81893 0.0036633167670008415 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
32 32 2019-02-17 Andrew Yang 6 82454 0.007276784631430858 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
33 33 2019-02-24 Andrew Yang 3 82804 0.0036230133809960867 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
34 34 2019-03-03 Andrew Yang 5 81321 0.006148473334071151 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
35 35 2019-03-10 Andrew Yang 2 85812 0.0023306763622803336 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
36 36 2019-03-17 Andrew Yang 13 95383 0.013629263076229515 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
37 37 2019-03-24 Andrew Yang 4 96184 0.0041586958329867755 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
38 38 2019-03-31 Andrew Yang 32 93472 0.034234851078397806 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
39 39 2019-04-07 Andrew Yang 21 94405 0.022244584502939462 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
40 40 2019-04-14 Andrew Yang 39 95286 0.04092941250550973 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
41 41 2019-04-21 Andrew Yang 18 94002 0.019148528754707347 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
42 42 2019-04-28 Andrew Yang 10 95339 0.01048888702419786 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
43 43 2019-05-05 Andrew Yang 20 94528 0.02115775220040623 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
44 44 2019-05-12 Andrew Yang 11 94318 0.011662673084671006 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
45 45 2019-05-19 Andrew Yang 13 94883 0.013701084493534141 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
46 46 2019-05-26 Andrew Yang 10 95289 0.010494390748145116 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
47 47 2019-06-02 Andrew Yang 5 95313 0.005245874120004616 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
48 48 2019-06-09 Andrew Yang 42 95839 0.04382349565417002 "Andrew Yang" (station:MSNBC OR station:CNN OR station:FOXNEWS)
49 49 2018-12-30 Beto O'Rourke 101 76029 0.1328440463507346 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
50 50 2019-01-06 Beto O'Rourke 127 82964 0.15307844366231135 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
51 51 2019-01-13 Beto O'Rourke 78 82521 0.0945213945541135 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
52 52 2019-01-20 Beto O'Rourke 27 83649 0.03227773195136822 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
53 53 2019-01-27 Beto O'Rourke 28 80994 0.034570462009531566 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
54 54 2019-02-03 Beto O'Rourke 82 79183 0.10355758180417517 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
55 55 2019-02-10 Beto O'Rourke 418 81893 0.5104221362021174 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
56 56 2019-02-17 Beto O'Rourke 102 82454 0.1237053387343246 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
57 57 2019-02-24 Beto O'Rourke 78 82804 0.09419834790589826 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
58 58 2019-03-03 Beto O'Rourke 76 81321 0.09345679467788147 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
59 59 2019-03-10 Beto O'Rourke 870 85812 1.0138442175919449 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
60 60 2019-03-17 Beto O'Rourke 870 95383 0.91211222125536 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
61 61 2019-03-24 Beto O'Rourke 255 96184 0.26511685935290696 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
62 62 2019-03-31 Beto O'Rourke 300 93472 0.3209517288599795 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
63 63 2019-04-07 Beto O'Rourke 136 94405 0.1440601663047508 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
64 64 2019-04-14 Beto O'Rourke 163 95286 0.17106395483072015 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
65 65 2019-04-21 Beto O'Rourke 155 94002 0.16489010872109106 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
66 66 2019-04-28 Beto O'Rourke 221 95339 0.23180440323477275 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
67 67 2019-05-05 Beto O'Rourke 90 94528 0.09520988490182804 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
68 68 2019-05-12 Beto O'Rourke 217 94318 0.23007273267032805 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
69 69 2019-05-19 Beto O'Rourke 187 94883 0.1970848307916065 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
70 70 2019-05-26 Beto O'Rourke 112 95289 0.11753717637922532 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
71 71 2019-06-02 Beto O'Rourke 92 95313 0.09652408380808494 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
72 72 2019-06-09 Beto O'Rourke 209 95839 0.2180740617076556 "Beto O'Rourke" (station:MSNBC OR station:CNN OR station:FOXNEWS)
73 73 2018-12-30 John Hickenlooper 1 76029 0.0013152875876310355 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
74 74 2019-01-06 John Hickenlooper 1 82964 0.0012053420760811918 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
75 75 2019-01-13 John Hickenlooper 0 82521 0.0 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
76 76 2019-01-20 John Hickenlooper 3 83649 0.003586414661263135 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
77 77 2019-01-27 John Hickenlooper 3 80994 0.00370397807244981 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
78 78 2019-02-03 John Hickenlooper 2 79183 0.002525794678150613 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
79 79 2019-02-10 John Hickenlooper 0 81893 0.0 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
80 80 2019-02-17 John Hickenlooper 3 82454 0.003638392315715429 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
81 81 2019-02-24 John Hickenlooper 4 82804 0.0048306845079947825 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
82 82 2019-03-03 John Hickenlooper 90 81321 0.1106725200132807 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
83 83 2019-03-10 John Hickenlooper 15 85812 0.0174800727171025 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
84 84 2019-03-17 John Hickenlooper 102 95383 0.10693729490580084 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
85 85 2019-03-24 John Hickenlooper 22 96184 0.022872827081427263 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
86 86 2019-03-31 John Hickenlooper 17 93472 0.01818726463539884 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
87 87 2019-04-07 John Hickenlooper 11 94405 0.011651925215825431 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
88 88 2019-04-14 John Hickenlooper 7 95286 0.0073463048086812345 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
89 89 2019-04-21 John Hickenlooper 1 94002 0.0010638071530392973 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
90 90 2019-04-28 John Hickenlooper 21 95339 0.02202666275081551 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
91 91 2019-05-05 John Hickenlooper 12 94528 0.012694651320243736 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
92 92 2019-05-12 John Hickenlooper 13 94318 0.013783159100065737 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
93 93 2019-05-19 John Hickenlooper 9 94883 0.009485366187831329 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
94 94 2019-05-26 John Hickenlooper 33 95289 0.03463148946887888 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
95 95 2019-06-02 John Hickenlooper 63 95313 0.06609801391205816 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
96 96 2019-06-09 John Hickenlooper 46 95839 0.04799716190694811 "John Hickenlooper" (station:MSNBC OR station:CNN OR station:FOXNEWS)
97 97 2018-12-30 Jay Inslee 4 76029 0.005261150350524142 "Jay Inslee" (station:MSNBC OR station:CNN OR station:FOXNEWS)
98 98 2019-01-06 Jay Inslee 7 82964 0.008437394532568344 "Jay Inslee" (station:MSNBC OR station:CNN OR station:FOXNEWS)
99 99 2019-01-13 Jay Inslee 0 82521 0.0 "Jay Inslee" (station:MSNBC OR station:CNN OR station:FOXNEWS)
100 100 2019-01-20 Jay Inslee 7 83649 0.008368300876280649 "Jay Inslee" (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,
  "total_clips" INTEGER,
  "pct" REAL,
  "query" TEXT
)
Powered by Datasette · Query took 38.297ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub