media-mentions-2020/cable_weekly

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

1,008 rows

View and edit SQL

Suggested facets: name, query, date (date)

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