Media Mentions 2020: cable_weekly.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
1,008 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | name | matched_clips | all_candidate_clips | total_clips | pct_of_all_candidate_clips | query |
---|---|---|---|---|---|---|---|---|
101 | 101 | 2019-04-07 | Bernie Sanders | 664 | 2345 | 94405 | 0.2831556503198294 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
102 | 102 | 2019-04-14 | Bernie Sanders | 970 | 2639 | 95286 | 0.3675634710117469 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
103 | 103 | 2019-04-21 | Bernie Sanders | 1099 | 5749 | 94002 | 0.1911636806401113 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
104 | 104 | 2019-04-28 | Bernie Sanders | 602 | 3956 | 95339 | 0.1521739130434782 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
105 | 105 | 2019-05-05 | Bernie Sanders | 503 | 2748 | 94528 | 0.183042212518195 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
106 | 106 | 2019-05-12 | Bernie Sanders | 530 | 3694 | 94318 | 0.1434759068760151 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
107 | 107 | 2019-05-19 | Bernie Sanders | 465 | 2650 | 94883 | 0.1754716981132075 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
108 | 108 | 2019-05-26 | Bernie Sanders | 365 | 3059 | 95289 | 0.119320039228506 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
109 | 109 | 2019-06-02 | Bernie Sanders | 341 | 3103 | 95313 | 0.1098936513051885 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
110 | 110 | 2019-06-09 | Bernie Sanders | 894 | 4780 | 95839 | 0.1870292887029288 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
111 | 111 | 2019-06-16 | Bernie Sanders | 655 | 4485 | 96026 | 0.1460423634336677 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
112 | 112 | 2019-06-23 | Bernie Sanders | 1055 | 7316 | 96553 | 0.1442044833242209 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
113 | 113 | 2019-06-30 | Bernie Sanders | 590 | 4384 | 92126 | 0.1345802919708029 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
114 | 114 | 2019-07-07 | Bernie Sanders | 354 | 3052 | 94299 | 0.1159895150720838 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
115 | 115 | 2019-07-14 | Bernie Sanders | 738 | 3029 | 94481 | 0.2436447672499174 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
116 | 116 | 2019-07-21 | Bernie Sanders | 350 | 2574 | 96027 | 0.1359751359751359 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
117 | 117 | 2019-07-28 | Bernie Sanders | 1276 | 7361 | 95970 | 0.173346012770004 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
118 | 118 | 2019-08-04 | Bernie Sanders | 296 | 3028 | 95881 | 0.0977542932628798 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
119 | 119 | 2019-08-11 | Bernie Sanders | 509 | 3288 | 94920 | 0.1548053527980535 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
120 | 120 | 2019-08-18 | Bernie Sanders | 590 | 3488 | 94494 | 0.169151376146789 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
121 | 121 | 2019-08-25 | Bernie Sanders | 586 | 3171 | 94380 | 0.184799747713655 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
122 | 122 | 2019-09-01 | Bernie Sanders | 301 | 1829 | 93825 | 0.1645708037178786 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
123 | 123 | 2019-09-08 | Bernie Sanders | 613 | 4164 | 94278 | 0.1472142170989433 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
124 | 124 | 2019-09-15 | Bernie Sanders | 420 | 4248 | 94504 | 0.0988700564971751 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
125 | 125 | 2019-09-22 | Bernie Sanders | 228 | 4582 | 96953 | 0.0497599301615015 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
126 | 126 | 2019-09-29 | Bernie Sanders | 555 | 3986 | 93672 | 0.1392373306573005 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
127 | 127 | 2019-10-06 | Bernie Sanders | 421 | 3030 | 94074 | 0.1389438943894389 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
128 | 128 | 2019-10-13 | Bernie Sanders | 727 | 4393 | 94893 | 0.165490553152743 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
129 | 129 | 2019-10-20 | Bernie Sanders | 527 | 3100 | 93205 | 0.17 | ("Bernie Sanders") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
130 | 130 | 2018-12-30 | Beto O'Rourke | 101 | 1279 | 76029 | 0.0789679437060203 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
131 | 131 | 2019-01-06 | Beto O'Rourke | 127 | 1031 | 82964 | 0.1231813773035887 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
132 | 132 | 2019-01-13 | Beto O'Rourke | 78 | 615 | 82521 | 0.1268292682926829 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
133 | 133 | 2019-01-20 | Beto O'Rourke | 27 | 991 | 83649 | 0.0272452068617558 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
134 | 134 | 2019-01-27 | Beto O'Rourke | 28 | 1914 | 80994 | 0.0146290491118077 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
135 | 135 | 2019-02-03 | Beto O'Rourke | 82 | 1454 | 79183 | 0.0563961485557083 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
136 | 136 | 2019-02-10 | Beto O'Rourke | 418 | 1917 | 81893 | 0.2180490349504434 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
137 | 137 | 2019-02-17 | Beto O'Rourke | 102 | 2422 | 82454 | 0.042113955408753 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
138 | 138 | 2019-02-24 | Beto O'Rourke | 78 | 1545 | 82804 | 0.0504854368932038 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
139 | 139 | 2019-03-03 | Beto O'Rourke | 76 | 1587 | 81321 | 0.0478890989287964 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
140 | 140 | 2019-03-10 | Beto O'Rourke | 870 | 2431 | 85812 | 0.3578774167009461 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
141 | 141 | 2019-03-17 | Beto O'Rourke | 870 | 3174 | 95383 | 0.2741020793950851 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
142 | 142 | 2019-03-24 | Beto O'Rourke | 255 | 1248 | 96184 | 0.204326923076923 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
143 | 143 | 2019-03-31 | Beto O'Rourke | 300 | 4205 | 93472 | 0.0713436385255648 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
144 | 144 | 2019-04-07 | Beto O'Rourke | 136 | 2345 | 94405 | 0.0579957356076759 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
145 | 145 | 2019-04-14 | Beto O'Rourke | 163 | 2639 | 95286 | 0.06176582038651 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
146 | 146 | 2019-04-21 | Beto O'Rourke | 155 | 5749 | 94002 | 0.0269612106453296 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
147 | 147 | 2019-04-28 | Beto O'Rourke | 221 | 3956 | 95339 | 0.0558645096056622 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
148 | 148 | 2019-05-05 | Beto O'Rourke | 90 | 2748 | 94528 | 0.0327510917030567 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
149 | 149 | 2019-05-12 | Beto O'Rourke | 217 | 3694 | 94318 | 0.0587439090416892 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
150 | 150 | 2019-05-19 | Beto O'Rourke | 187 | 2650 | 94883 | 0.070566037735849 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
151 | 151 | 2019-05-26 | Beto O'Rourke | 112 | 3059 | 95289 | 0.0366132723112128 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
152 | 152 | 2019-06-02 | Beto O'Rourke | 92 | 3103 | 95313 | 0.0296487270383499 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
153 | 153 | 2019-06-09 | Beto O'Rourke | 209 | 4780 | 95839 | 0.0437238493723849 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
154 | 154 | 2019-06-16 | Beto O'Rourke | 104 | 4485 | 96026 | 0.0231884057971014 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
155 | 155 | 2019-06-23 | Beto O'Rourke | 445 | 7316 | 96553 | 0.0608255877528704 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
156 | 156 | 2019-06-30 | Beto O'Rourke | 113 | 4384 | 92126 | 0.0257755474452554 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
157 | 157 | 2019-07-07 | Beto O'Rourke | 63 | 3052 | 94299 | 0.0206422018348623 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
158 | 158 | 2019-07-14 | Beto O'Rourke | 120 | 3029 | 94481 | 0.0396170353251898 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
159 | 159 | 2019-07-21 | Beto O'Rourke | 47 | 2574 | 96027 | 0.0182595182595182 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
160 | 160 | 2019-07-28 | Beto O'Rourke | 269 | 7361 | 95970 | 0.0365439478331748 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
161 | 161 | 2019-08-04 | Beto O'Rourke | 540 | 3028 | 95881 | 0.178335535006605 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
162 | 162 | 2019-08-11 | Beto O'Rourke | 275 | 3288 | 94920 | 0.0836374695863746 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
163 | 163 | 2019-08-18 | Beto O'Rourke | 122 | 3488 | 94494 | 0.0349770642201834 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
164 | 164 | 2019-08-25 | Beto O'Rourke | 87 | 3171 | 94380 | 0.0274361400189214 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
165 | 165 | 2019-09-01 | Beto O'Rourke | 116 | 1829 | 93825 | 0.0634226353198469 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
166 | 166 | 2019-09-08 | Beto O'Rourke | 518 | 4164 | 94278 | 0.1243996157540826 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
167 | 167 | 2019-09-15 | Beto O'Rourke | 285 | 4248 | 94504 | 0.067090395480226 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
168 | 168 | 2019-09-22 | Beto O'Rourke | 105 | 4582 | 96953 | 0.0229157573112178 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
169 | 169 | 2019-09-29 | Beto O'Rourke | 66 | 3986 | 93672 | 0.0165579528349222 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
170 | 170 | 2019-10-06 | Beto O'Rourke | 71 | 3030 | 94074 | 0.0234323432343234 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
171 | 171 | 2019-10-13 | Beto O'Rourke | 160 | 4393 | 94893 | 0.0364215797860232 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
172 | 172 | 2019-10-20 | Beto O'Rourke | 61 | 3100 | 93205 | 0.0196774193548387 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
173 | 173 | 2018-12-30 | Bill de Blasio | 2 | 1279 | 76029 | 0.0015637216575449 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
174 | 174 | 2019-01-06 | Bill de Blasio | 23 | 1031 | 82964 | 0.0223084384093113 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
175 | 175 | 2019-01-13 | Bill de Blasio | 25 | 615 | 82521 | 0.040650406504065 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
176 | 176 | 2019-01-20 | Bill de Blasio | 3 | 991 | 83649 | 0.0030272452068617 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
177 | 177 | 2019-01-27 | Bill de Blasio | 3 | 1914 | 80994 | 0.0015673981191222 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
178 | 178 | 2019-02-03 | Bill de Blasio | 3 | 1454 | 79183 | 0.0020632737276478 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
179 | 179 | 2019-02-10 | Bill de Blasio | 29 | 1917 | 81893 | 0.0151278038601982 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
180 | 180 | 2019-02-17 | Bill de Blasio | 16 | 2422 | 82454 | 0.0066061106523534 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
181 | 181 | 2019-02-24 | Bill de Blasio | 9 | 1545 | 82804 | 0.0058252427184466 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
182 | 182 | 2019-03-03 | Bill de Blasio | 7 | 1587 | 81321 | 0.0044108380592312 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
183 | 183 | 2019-03-10 | Bill de Blasio | 29 | 2431 | 85812 | 0.0119292472233648 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
184 | 184 | 2019-03-17 | Bill de Blasio | 20 | 3174 | 95383 | 0.0063011972274732 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
185 | 185 | 2019-03-24 | Bill de Blasio | 3 | 1248 | 96184 | 0.0024038461538461 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
186 | 186 | 2019-03-31 | Bill de Blasio | 3 | 4205 | 93472 | 0.0007134363852556 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
187 | 187 | 2019-04-07 | Bill de Blasio | 14 | 2345 | 94405 | 0.0059701492537313 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
188 | 188 | 2019-04-14 | Bill de Blasio | 1 | 2639 | 95286 | 0.0003789314134141 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
189 | 189 | 2019-04-21 | Bill de Blasio | 31 | 5749 | 94002 | 0.0053922421290659 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
190 | 190 | 2019-04-28 | Bill de Blasio | 14 | 3956 | 95339 | 0.0035389282103134 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
191 | 191 | 2019-05-05 | Bill de Blasio | 10 | 2748 | 94528 | 0.0036390101892285 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
192 | 192 | 2019-05-12 | Bill de Blasio | 263 | 3694 | 94318 | 0.0711965349214943 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
193 | 193 | 2019-05-19 | Bill de Blasio | 83 | 2650 | 94883 | 0.0313207547169811 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
194 | 194 | 2019-05-26 | Bill de Blasio | 40 | 3059 | 95289 | 0.013076168682576 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
195 | 195 | 2019-06-02 | Bill de Blasio | 42 | 3103 | 95313 | 0.013535288430551 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
196 | 196 | 2019-06-09 | Bill de Blasio | 92 | 4780 | 95839 | 0.0192468619246861 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
197 | 197 | 2019-06-16 | Bill de Blasio | 52 | 4485 | 96026 | 0.0115942028985507 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
198 | 198 | 2019-06-23 | Bill de Blasio | 168 | 7316 | 96553 | 0.0229633679606342 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
199 | 199 | 2019-06-30 | Bill de Blasio | 16 | 4384 | 92126 | 0.0036496350364963 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
200 | 200 | 2019-07-07 | Bill de Blasio | 64 | 3052 | 94299 | 0.0209698558322411 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
Advanced export
JSON shape: default, array, newline-delimited
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 );