media-mentions-2020/online_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_stories all_candidate_stories pct_of_all_candidate_stories query
1 2018-12-30 Amy Klobuchar 45 806 0.05583126550868486 ("Amy Klobuchar")
2 2019-01-06 Amy Klobuchar 55 915 0.060109289617486336 ("Amy Klobuchar")
3 2019-01-13 Amy Klobuchar 128 1052 0.12167300380228135 ("Amy Klobuchar")
4 2019-01-20 Amy Klobuchar 55 1024 0.0537109375 ("Amy Klobuchar")
5 2019-01-27 Amy Klobuchar 74 1605 0.04610591900311527 ("Amy Klobuchar")
6 2019-02-03 Amy Klobuchar 143 1428 0.10014005602240897 ("Amy Klobuchar")
7 2019-02-10 Amy Klobuchar 411 1612 0.25496277915632753 ("Amy Klobuchar")
8 2019-02-17 Amy Klobuchar 256 1406 0.18207681365576106 ("Amy Klobuchar")
9 2019-02-24 Amy Klobuchar 169 1286 0.13141524105754274 ("Amy Klobuchar")
10 2019-03-03 Amy Klobuchar 242 1485 0.16296296296296298 ("Amy Klobuchar")
11 2019-03-10 Amy Klobuchar 185 1810 0.10220994475138122 ("Amy Klobuchar")
12 2019-03-17 Amy Klobuchar 223 1591 0.14016341923318668 ("Amy Klobuchar")
13 2019-03-24 Amy Klobuchar 167 1166 0.1432246998284734 ("Amy Klobuchar")
14 2019-03-31 Amy Klobuchar 150 1714 0.08751458576429405 ("Amy Klobuchar")
15 2019-04-07 Amy Klobuchar 192 1600 0.12 ("Amy Klobuchar")
16 2019-04-14 Amy Klobuchar 190 1936 0.0981404958677686 ("Amy Klobuchar")
17 2019-04-21 Amy Klobuchar 251 2320 0.1081896551724138 ("Amy Klobuchar")
18 2019-04-28 Amy Klobuchar 191 1834 0.10414394765539804 ("Amy Klobuchar")
19 2019-05-05 Amy Klobuchar 148 1577 0.09384908053265696 ("Amy Klobuchar")
20 2019-05-12 Amy Klobuchar 165 1952 0.08452868852459018 ("Amy Klobuchar")
21 2019-05-19 Amy Klobuchar 157 1580 0.09936708860759494 ("Amy Klobuchar")
22 2019-05-26 Amy Klobuchar 128 1474 0.08683853459972862 ("Amy Klobuchar")
23 2019-06-02 Amy Klobuchar 143 1652 0.08656174334140436 ("Amy Klobuchar")
24 2019-06-09 Amy Klobuchar 235 2049 0.11469009272816008 ("Amy Klobuchar")
25 2019-06-16 Amy Klobuchar 155 1882 0.08235919234856535 ("Amy Klobuchar")
26 2019-06-23 Amy Klobuchar 548 3561 0.15388935692221287 ("Amy Klobuchar")
27 2019-06-30 Amy Klobuchar 151 1672 0.09031100478468901 ("Amy Klobuchar")
28 2019-07-07 Amy Klobuchar 131 1880 0.06968085106382979 ("Amy Klobuchar")
29 2019-07-14 Amy Klobuchar 167 1802 0.09267480577136517 ("Amy Klobuchar")
30 2019-07-21 Amy Klobuchar 121 1414 0.08557284299858557 ("Amy Klobuchar")
31 2019-07-28 Amy Klobuchar 406 3210 0.1264797507788162 ("Amy Klobuchar")
32 2019-08-04 Amy Klobuchar 161 1937 0.08311822405782138 ("Amy Klobuchar")
33 2019-08-11 Amy Klobuchar 102 1513 0.06741573033707865 ("Amy Klobuchar")
34 2019-08-18 Amy Klobuchar 123 1451 0.08476912474155755 ("Amy Klobuchar")
35 2019-08-25 Amy Klobuchar 85 950 0.08947368421052633 ("Amy Klobuchar")
36 2019-09-01 Amy Klobuchar 142 1309 0.10847975553857908 ("Amy Klobuchar")
37 2019-09-08 Amy Klobuchar 367 1957 0.1875319366377108 ("Amy Klobuchar")
38 2019-09-15 Amy Klobuchar 211 2071 0.1018831482375664 ("Amy Klobuchar")
39 2019-09-22 Amy Klobuchar 110 3682 0.029875067897881587 ("Amy Klobuchar")
40 2019-09-29 Amy Klobuchar 94 3355 0.028017883755588675 ("Amy Klobuchar")
41 2019-10-06 Amy Klobuchar 121 2459 0.049206994713298084 ("Amy Klobuchar")
42 2019-10-13 Amy Klobuchar 382 2788 0.13701578192252512 ("Amy Klobuchar")
43 2019-10-20 Amy Klobuchar 175 1994 0.08776328986960882 ("Amy Klobuchar")
44 2018-12-30 Andrew Yang 2 806 0.0024813895781637717 ("Andrew Yang")
45 2019-01-06 Andrew Yang 6 915 0.006557377049180328 ("Andrew Yang")
46 2019-01-13 Andrew Yang 9 1052 0.008555133079847909 ("Andrew Yang")
47 2019-01-20 Andrew Yang 7 1024 0.0068359375 ("Andrew Yang")
48 2019-01-27 Andrew Yang 14 1605 0.008722741433021807 ("Andrew Yang")
49 2019-02-03 Andrew Yang 11 1428 0.0077030812324929985 ("Andrew Yang")
50 2019-02-10 Andrew Yang 28 1612 0.017369727047146403 ("Andrew Yang")
51 2019-02-17 Andrew Yang 13 1406 0.009246088193456615 ("Andrew Yang")
52 2019-02-24 Andrew Yang 12 1286 0.00933125972006221 ("Andrew Yang")
53 2019-03-03 Andrew Yang 27 1485 0.01818181818181818 ("Andrew Yang")
54 2019-03-10 Andrew Yang 37 1810 0.020441988950276244 ("Andrew Yang")
55 2019-03-17 Andrew Yang 66 1591 0.0414833438089252 ("Andrew Yang")
56 2019-03-24 Andrew Yang 30 1166 0.025728987993138937 ("Andrew Yang")
57 2019-03-31 Andrew Yang 57 1714 0.03325554259043174 ("Andrew Yang")
58 2019-04-07 Andrew Yang 70 1600 0.04375 ("Andrew Yang")
59 2019-04-14 Andrew Yang 88 1936 0.045454545454545456 ("Andrew Yang")
60 2019-04-21 Andrew Yang 49 2320 0.02112068965517241 ("Andrew Yang")
61 2019-04-28 Andrew Yang 46 1834 0.025081788440567063 ("Andrew Yang")
62 2019-05-05 Andrew Yang 43 1577 0.027266962587190868 ("Andrew Yang")
63 2019-05-12 Andrew Yang 60 1952 0.030737704918032783 ("Andrew Yang")
64 2019-05-19 Andrew Yang 64 1580 0.04050632911392405 ("Andrew Yang")
65 2019-05-26 Andrew Yang 42 1474 0.028493894165535955 ("Andrew Yang")
66 2019-06-02 Andrew Yang 35 1652 0.0211864406779661 ("Andrew Yang")
67 2019-06-09 Andrew Yang 138 2049 0.06734992679355782 ("Andrew Yang")
68 2019-06-16 Andrew Yang 77 1882 0.04091392136025505 ("Andrew Yang")
69 2019-06-23 Andrew Yang 349 3561 0.09800617803987643 ("Andrew Yang")
70 2019-06-30 Andrew Yang 66 1672 0.03947368421052632 ("Andrew Yang")
71 2019-07-07 Andrew Yang 65 1880 0.034574468085106384 ("Andrew Yang")
72 2019-07-14 Andrew Yang 110 1802 0.06104328523862375 ("Andrew Yang")
73 2019-07-21 Andrew Yang 52 1414 0.036775106082036775 ("Andrew Yang")
74 2019-07-28 Andrew Yang 307 3210 0.0956386292834891 ("Andrew Yang")
75 2019-08-04 Andrew Yang 116 1937 0.05988642230252968 ("Andrew Yang")
76 2019-08-11 Andrew Yang 130 1513 0.08592200925313946 ("Andrew Yang")
77 2019-08-18 Andrew Yang 94 1451 0.0647829083390765 ("Andrew Yang")
78 2019-08-25 Andrew Yang 121 950 0.12736842105263158 ("Andrew Yang")
79 2019-09-01 Andrew Yang 157 1309 0.11993888464476699 ("Andrew Yang")
80 2019-09-08 Andrew Yang 400 1957 0.2043944813490036 ("Andrew Yang")
81 2019-09-15 Andrew Yang 244 2071 0.1178174794785128 ("Andrew Yang")
82 2019-09-22 Andrew Yang 102 3682 0.02770233568712656 ("Andrew Yang")
83 2019-09-29 Andrew Yang 163 3355 0.04858420268256334 ("Andrew Yang")
84 2019-10-06 Andrew Yang 87 2459 0.035380235868239115 ("Andrew Yang")
85 2019-10-13 Andrew Yang 277 2788 0.09935437589670014 ("Andrew Yang")
86 2019-10-20 Andrew Yang 120 1994 0.06018054162487463 ("Andrew Yang")
87 2018-12-30 Bernie Sanders 277 806 0.3436724565756824 ("Bernie Sanders")
88 2019-01-06 Bernie Sanders 329 915 0.35956284153005463 ("Bernie Sanders")
89 2019-01-13 Bernie Sanders 250 1052 0.2376425855513308 ("Bernie Sanders")
90 2019-01-20 Bernie Sanders 297 1024 0.2900390625 ("Bernie Sanders")
91 2019-01-27 Bernie Sanders 410 1605 0.2554517133956386 ("Bernie Sanders")
92 2019-02-03 Bernie Sanders 412 1428 0.28851540616246496 ("Bernie Sanders")
93 2019-02-10 Bernie Sanders 359 1612 0.2227047146401985 ("Bernie Sanders")
94 2019-02-17 Bernie Sanders 633 1406 0.4502133712660029 ("Bernie Sanders")
95 2019-02-24 Bernie Sanders 628 1286 0.4883359253499223 ("Bernie Sanders")
96 2019-03-03 Bernie Sanders 667 1485 0.4491582491582492 ("Bernie Sanders")
97 2019-03-10 Bernie Sanders 585 1810 0.3232044198895028 ("Bernie Sanders")
98 2019-03-17 Bernie Sanders 599 1591 0.37649277184160906 ("Bernie Sanders")
99 2019-03-24 Bernie Sanders 380 1166 0.3259005145797599 ("Bernie Sanders")
100 2019-03-31 Bernie Sanders 521 1714 0.3039673278879813 ("Bernie Sanders")

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Query took 244.282ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub