Media Mentions 2020: online_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_stories | all_candidate_stories | pct_of_all_candidate_stories | query |
---|---|---|---|---|---|---|---|
101 | 101 | 2019-04-07 | Bernie Sanders | 636 | 1600 | 0.3975 | ("Bernie Sanders") |
102 | 102 | 2019-04-14 | Bernie Sanders | 944 | 1936 | 0.4876033057851239 | ("Bernie Sanders") |
103 | 103 | 2019-04-21 | Bernie Sanders | 921 | 2320 | 0.3969827586206896 | ("Bernie Sanders") |
104 | 104 | 2019-04-28 | Bernie Sanders | 622 | 1834 | 0.3391494002181025 | ("Bernie Sanders") |
105 | 105 | 2019-05-05 | Bernie Sanders | 490 | 1577 | 0.310716550412175 | ("Bernie Sanders") |
106 | 106 | 2019-05-12 | Bernie Sanders | 661 | 1952 | 0.3386270491803279 | ("Bernie Sanders") |
107 | 107 | 2019-05-19 | Bernie Sanders | 485 | 1580 | 0.3069620253164557 | ("Bernie Sanders") |
108 | 108 | 2019-05-26 | Bernie Sanders | 414 | 1474 | 0.2808683853459973 | ("Bernie Sanders") |
109 | 109 | 2019-06-02 | Bernie Sanders | 558 | 1652 | 0.3377723970944309 | ("Bernie Sanders") |
110 | 110 | 2019-06-09 | Bernie Sanders | 773 | 2049 | 0.3772571986334797 | ("Bernie Sanders") |
111 | 111 | 2019-06-16 | Bernie Sanders | 615 | 1882 | 0.3267800212539851 | ("Bernie Sanders") |
112 | 112 | 2019-06-23 | Bernie Sanders | 1438 | 3561 | 0.4038191519236169 | ("Bernie Sanders") |
113 | 113 | 2019-06-30 | Bernie Sanders | 604 | 1672 | 0.361244019138756 | ("Bernie Sanders") |
114 | 114 | 2019-07-07 | Bernie Sanders | 579 | 1880 | 0.3079787234042553 | ("Bernie Sanders") |
115 | 115 | 2019-07-14 | Bernie Sanders | 714 | 1802 | 0.3962264150943396 | ("Bernie Sanders") |
116 | 116 | 2019-07-21 | Bernie Sanders | 453 | 1414 | 0.3203677510608204 | ("Bernie Sanders") |
117 | 117 | 2019-07-28 | Bernie Sanders | 1354 | 3210 | 0.4218068535825545 | ("Bernie Sanders") |
118 | 118 | 2019-08-04 | Bernie Sanders | 615 | 1937 | 0.3175012906556531 | ("Bernie Sanders") |
119 | 119 | 2019-08-11 | Bernie Sanders | 497 | 1513 | 0.3284864507600793 | ("Bernie Sanders") |
120 | 120 | 2019-08-18 | Bernie Sanders | 635 | 1451 | 0.4376292212267402 | ("Bernie Sanders") |
121 | 121 | 2019-08-25 | Bernie Sanders | 399 | 950 | 0.42 | ("Bernie Sanders") |
122 | 122 | 2019-09-01 | Bernie Sanders | 526 | 1309 | 0.40183346065699 | ("Bernie Sanders") |
123 | 123 | 2019-09-08 | Bernie Sanders | 910 | 1957 | 0.4649974450689831 | ("Bernie Sanders") |
124 | 124 | 2019-09-15 | Bernie Sanders | 704 | 2071 | 0.3399323998068566 | ("Bernie Sanders") |
125 | 125 | 2019-09-22 | Bernie Sanders | 494 | 3682 | 0.1341662140141227 | ("Bernie Sanders") |
126 | 126 | 2019-09-29 | Bernie Sanders | 699 | 3355 | 0.2083457526080477 | ("Bernie Sanders") |
127 | 127 | 2019-10-06 | Bernie Sanders | 491 | 2459 | 0.1996746644977633 | ("Bernie Sanders") |
128 | 128 | 2019-10-13 | Bernie Sanders | 973 | 2788 | 0.3489956958393113 | ("Bernie Sanders") |
129 | 129 | 2019-10-20 | Bernie Sanders | 599 | 1994 | 0.3004012036108325 | ("Bernie Sanders") |
130 | 130 | 2018-12-30 | Beto O'Rourke | 43 | 806 | 0.053349875930521 | ("Beto O'Rourke") |
131 | 131 | 2019-01-06 | Beto O'Rourke | 61 | 915 | 0.0666666666666666 | ("Beto O'Rourke") |
132 | 132 | 2019-01-13 | Beto O'Rourke | 55 | 1052 | 0.0522813688212927 | ("Beto O'Rourke") |
133 | 133 | 2019-01-20 | Beto O'Rourke | 22 | 1024 | 0.021484375 | ("Beto O'Rourke") |
134 | 134 | 2019-01-27 | Beto O'Rourke | 35 | 1605 | 0.0218068535825545 | ("Beto O'Rourke") |
135 | 135 | 2019-02-03 | Beto O'Rourke | 64 | 1428 | 0.0448179271708683 | ("Beto O'Rourke") |
136 | 136 | 2019-02-10 | Beto O'Rourke | 159 | 1612 | 0.0986352357320099 | ("Beto O'Rourke") |
137 | 137 | 2019-02-17 | Beto O'Rourke | 49 | 1406 | 0.034850640113798 | ("Beto O'Rourke") |
138 | 138 | 2019-02-24 | Beto O'Rourke | 55 | 1286 | 0.0427682737169517 | ("Beto O'Rourke") |
139 | 139 | 2019-03-03 | Beto O'Rourke | 59 | 1485 | 0.0397306397306397 | ("Beto O'Rourke") |
140 | 140 | 2019-03-10 | Beto O'Rourke | 334 | 1810 | 0.1845303867403314 | ("Beto O'Rourke") |
141 | 141 | 2019-03-17 | Beto O'Rourke | 295 | 1591 | 0.1854179761156505 | ("Beto O'Rourke") |
142 | 142 | 2019-03-24 | Beto O'Rourke | 119 | 1166 | 0.1020583190394511 | ("Beto O'Rourke") |
143 | 143 | 2019-03-31 | Beto O'Rourke | 123 | 1714 | 0.0717619603267211 | ("Beto O'Rourke") |
144 | 144 | 2019-04-07 | Beto O'Rourke | 94 | 1600 | 0.05875 | ("Beto O'Rourke") |
145 | 145 | 2019-04-14 | Beto O'Rourke | 118 | 1936 | 0.0609504132231404 | ("Beto O'Rourke") |
146 | 146 | 2019-04-21 | Beto O'Rourke | 97 | 2320 | 0.0418103448275862 | ("Beto O'Rourke") |
147 | 147 | 2019-04-28 | Beto O'Rourke | 119 | 1834 | 0.0648854961832061 | ("Beto O'Rourke") |
148 | 148 | 2019-05-05 | Beto O'Rourke | 72 | 1577 | 0.0456563094483195 | ("Beto O'Rourke") |
149 | 149 | 2019-05-12 | Beto O'Rourke | 117 | 1952 | 0.0599385245901639 | ("Beto O'Rourke") |
150 | 150 | 2019-05-19 | Beto O'Rourke | 102 | 1580 | 0.0645569620253164 | ("Beto O'Rourke") |
151 | 151 | 2019-05-26 | Beto O'Rourke | 83 | 1474 | 0.0563093622795115 | ("Beto O'Rourke") |
152 | 152 | 2019-06-02 | Beto O'Rourke | 90 | 1652 | 0.0544794188861985 | ("Beto O'Rourke") |
153 | 153 | 2019-06-09 | Beto O'Rourke | 154 | 2049 | 0.0751586139580283 | ("Beto O'Rourke") |
154 | 154 | 2019-06-16 | Beto O'Rourke | 63 | 1882 | 0.0334750265674814 | ("Beto O'Rourke") |
155 | 155 | 2019-06-23 | Beto O'Rourke | 321 | 3561 | 0.0901432181971356 | ("Beto O'Rourke") |
156 | 156 | 2019-06-30 | Beto O'Rourke | 103 | 1672 | 0.0616028708133971 | ("Beto O'Rourke") |
157 | 157 | 2019-07-07 | Beto O'Rourke | 72 | 1880 | 0.0382978723404255 | ("Beto O'Rourke") |
158 | 158 | 2019-07-14 | Beto O'Rourke | 124 | 1802 | 0.0688124306326304 | ("Beto O'Rourke") |
159 | 159 | 2019-07-21 | Beto O'Rourke | 61 | 1414 | 0.0431400282885431 | ("Beto O'Rourke") |
160 | 160 | 2019-07-28 | Beto O'Rourke | 187 | 3210 | 0.0582554517133956 | ("Beto O'Rourke") |
161 | 161 | 2019-08-04 | Beto O'Rourke | 318 | 1937 | 0.1641713990707279 | ("Beto O'Rourke") |
162 | 162 | 2019-08-11 | Beto O'Rourke | 141 | 1513 | 0.0931923331130204 | ("Beto O'Rourke") |
163 | 163 | 2019-08-18 | Beto O'Rourke | 69 | 1451 | 0.0475534114403859 | ("Beto O'Rourke") |
164 | 164 | 2019-08-25 | Beto O'Rourke | 72 | 950 | 0.0757894736842105 | ("Beto O'Rourke") |
165 | 165 | 2019-09-01 | Beto O'Rourke | 100 | 1309 | 0.0763941940412528 | ("Beto O'Rourke") |
166 | 166 | 2019-09-08 | Beto O'Rourke | 250 | 1957 | 0.1277465508431272 | ("Beto O'Rourke") |
167 | 167 | 2019-09-15 | Beto O'Rourke | 158 | 2071 | 0.0762916465475615 | ("Beto O'Rourke") |
168 | 168 | 2019-09-22 | Beto O'Rourke | 76 | 3682 | 0.0206409560021727 | ("Beto O'Rourke") |
169 | 169 | 2019-09-29 | Beto O'Rourke | 51 | 3355 | 0.0152011922503725 | ("Beto O'Rourke") |
170 | 170 | 2019-10-06 | Beto O'Rourke | 75 | 2459 | 0.0305002033346888 | ("Beto O'Rourke") |
171 | 171 | 2019-10-13 | Beto O'Rourke | 155 | 2788 | 0.0555954088952654 | ("Beto O'Rourke") |
172 | 172 | 2019-10-20 | Beto O'Rourke | 79 | 1994 | 0.0396188565697091 | ("Beto O'Rourke") |
173 | 173 | 2018-12-30 | Bill de Blasio | 46 | 806 | 0.0570719602977667 | ("Bill de Blasio") |
174 | 174 | 2019-01-06 | Bill de Blasio | 80 | 915 | 0.087431693989071 | ("Bill de Blasio") |
175 | 175 | 2019-01-13 | Bill de Blasio | 66 | 1052 | 0.0627376425855513 | ("Bill de Blasio") |
176 | 176 | 2019-01-20 | Bill de Blasio | 41 | 1024 | 0.0400390625 | ("Bill de Blasio") |
177 | 177 | 2019-01-27 | Bill de Blasio | 71 | 1605 | 0.0442367601246105 | ("Bill de Blasio") |
178 | 178 | 2019-02-03 | Bill de Blasio | 59 | 1428 | 0.0413165266106442 | ("Bill de Blasio") |
179 | 179 | 2019-02-10 | Bill de Blasio | 183 | 1612 | 0.1135235732009925 | ("Bill de Blasio") |
180 | 180 | 2019-02-17 | Bill de Blasio | 97 | 1406 | 0.0689900426742532 | ("Bill de Blasio") |
181 | 181 | 2019-02-24 | Bill de Blasio | 56 | 1286 | 0.0435458786936236 | ("Bill de Blasio") |
182 | 182 | 2019-03-03 | Bill de Blasio | 52 | 1485 | 0.035016835016835 | ("Bill de Blasio") |
183 | 183 | 2019-03-10 | Bill de Blasio | 95 | 1810 | 0.0524861878453038 | ("Bill de Blasio") |
184 | 184 | 2019-03-17 | Bill de Blasio | 62 | 1591 | 0.0389692017598994 | ("Bill de Blasio") |
185 | 185 | 2019-03-24 | Bill de Blasio | 38 | 1166 | 0.0325900514579759 | ("Bill de Blasio") |
186 | 186 | 2019-03-31 | Bill de Blasio | 30 | 1714 | 0.0175029171528588 | ("Bill de Blasio") |
187 | 187 | 2019-04-07 | Bill de Blasio | 100 | 1600 | 0.0625 | ("Bill de Blasio") |
188 | 188 | 2019-04-14 | Bill de Blasio | 67 | 1936 | 0.0346074380165289 | ("Bill de Blasio") |
189 | 189 | 2019-04-21 | Bill de Blasio | 40 | 2320 | 0.0172413793103448 | ("Bill de Blasio") |
190 | 190 | 2019-04-28 | Bill de Blasio | 46 | 1834 | 0.025081788440567 | ("Bill de Blasio") |
191 | 191 | 2019-05-05 | Bill de Blasio | 38 | 1577 | 0.0240963855421686 | ("Bill de Blasio") |
192 | 192 | 2019-05-12 | Bill de Blasio | 288 | 1952 | 0.1475409836065573 | ("Bill de Blasio") |
193 | 193 | 2019-05-19 | Bill de Blasio | 114 | 1580 | 0.0721518987341772 | ("Bill de Blasio") |
194 | 194 | 2019-05-26 | Bill de Blasio | 88 | 1474 | 0.0597014925373134 | ("Bill de Blasio") |
195 | 195 | 2019-06-02 | Bill de Blasio | 152 | 1652 | 0.0920096852300242 | ("Bill de Blasio") |
196 | 196 | 2019-06-09 | Bill de Blasio | 217 | 2049 | 0.1059053196681308 | ("Bill de Blasio") |
197 | 197 | 2019-06-16 | Bill de Blasio | 171 | 1882 | 0.0908607863974495 | ("Bill de Blasio") |
198 | 198 | 2019-06-23 | Bill de Blasio | 538 | 3561 | 0.1510811569783768 | ("Bill de Blasio") |
199 | 199 | 2019-06-30 | Bill de Blasio | 110 | 1672 | 0.0657894736842105 | ("Bill de Blasio") |
200 | 200 | 2019-07-07 | Bill de Blasio | 211 | 1880 | 0.1122340425531914 | ("Bill de Blasio") |
Advanced export
JSON shape: default, array, newline-delimited
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 );