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 sorted by matched_stories descending
This data as json, copyable, CSV (advanced)
Suggested facets: name, query, date (date)
Link | rowid | date | name | matched_stories ▲ | all_candidate_stories | pct_of_all_candidate_stories | query |
---|---|---|---|---|---|---|---|
397 | 397 | 2019-09-22 | Joe Biden | 3120 | 3682 | 0.8473655621944596 | ("Joe Biden") |
398 | 398 | 2019-09-29 | Joe Biden | 2596 | 3355 | 0.7737704918032787 | ("Joe Biden") |
399 | 399 | 2019-10-06 | Joe Biden | 1726 | 2459 | 0.7019113460756405 | ("Joe Biden") |
400 | 400 | 2019-10-13 | Joe Biden | 1651 | 2788 | 0.5921807747489239 | ("Joe Biden") |
384 | 384 | 2019-06-23 | Joe Biden | 1577 | 3561 | 0.4428531311429374 | ("Joe Biden") |
279 | 279 | 2019-06-23 | Elizabeth Warren | 1470 | 3561 | 0.4128053917438922 | ("Elizabeth Warren") |
112 | 112 | 2019-06-23 | Bernie Sanders | 1438 | 3561 | 0.4038191519236169 | ("Bernie Sanders") |
389 | 389 | 2019-07-28 | Joe Biden | 1400 | 3210 | 0.4361370716510903 | ("Joe Biden") |
117 | 117 | 2019-07-28 | Bernie Sanders | 1354 | 3210 | 0.4218068535825545 | ("Bernie Sanders") |
284 | 284 | 2019-07-28 | Elizabeth Warren | 1217 | 3210 | 0.3791277258566978 | ("Elizabeth Warren") |
401 | 401 | 2019-10-20 | Joe Biden | 1177 | 1994 | 0.5902708124373119 | ("Joe Biden") |
295 | 295 | 2019-10-13 | Elizabeth Warren | 1174 | 2788 | 0.4210903873744619 | ("Elizabeth Warren") |
589 | 589 | 2019-06-23 | Kamala Harris | 1173 | 3561 | 0.3294018534119629 | ("Kamala Harris") |
594 | 594 | 2019-07-28 | Kamala Harris | 1108 | 3210 | 0.3451713395638629 | ("Kamala Harris") |
383 | 383 | 2019-06-16 | Joe Biden | 1038 | 1882 | 0.5515409139213603 | ("Joe Biden") |
382 | 382 | 2019-06-09 | Joe Biden | 1036 | 2049 | 0.5056124938994632 | ("Joe Biden") |
375 | 375 | 2019-04-21 | Joe Biden | 1020 | 2320 | 0.4396551724137931 | ("Joe Biden") |
395 | 395 | 2019-09-08 | Joe Biden | 1004 | 1957 | 0.513030148185999 | ("Joe Biden") |
128 | 128 | 2019-10-13 | Bernie Sanders | 973 | 2788 | 0.3489956958393113 | ("Bernie Sanders") |
290 | 290 | 2019-09-08 | Elizabeth Warren | 951 | 1957 | 0.485947879407256 | ("Elizabeth Warren") |
102 | 102 | 2019-04-14 | Bernie Sanders | 944 | 1936 | 0.4876033057851239 | ("Bernie Sanders") |
396 | 396 | 2019-09-15 | Joe Biden | 933 | 2071 | 0.4505070014485756 | ("Joe Biden") |
372 | 372 | 2019-03-31 | Joe Biden | 929 | 1714 | 0.5420070011668612 | ("Joe Biden") |
103 | 103 | 2019-04-21 | Bernie Sanders | 921 | 2320 | 0.3969827586206896 | ("Bernie Sanders") |
123 | 123 | 2019-09-08 | Bernie Sanders | 910 | 1957 | 0.4649974450689831 | ("Bernie Sanders") |
236 | 236 | 2019-06-23 | Cory Booker | 910 | 3561 | 0.2555461948890761 | ("Cory Booker") |
291 | 291 | 2019-09-15 | Elizabeth Warren | 874 | 2071 | 0.4220183486238532 | ("Elizabeth Warren") |
785 | 785 | 2019-06-23 | Pete Buttigieg | 853 | 3561 | 0.2395394552092108 | ("Pete Buttigieg") |
270 | 270 | 2019-04-21 | Elizabeth Warren | 826 | 2320 | 0.3560344827586207 | ("Elizabeth Warren") |
568 | 568 | 2019-01-27 | Kamala Harris | 808 | 1605 | 0.5034267912772585 | ("Kamala Harris") |
376 | 376 | 2019-04-28 | Joe Biden | 806 | 1834 | 0.4394765539803708 | ("Joe Biden") |
385 | 385 | 2019-06-30 | Joe Biden | 783 | 1672 | 0.4683014354066985 | ("Joe Biden") |
110 | 110 | 2019-06-09 | Bernie Sanders | 773 | 2049 | 0.3772571986334797 | ("Bernie Sanders") |
293 | 293 | 2019-09-29 | Elizabeth Warren | 763 | 3355 | 0.2274217585692995 | ("Elizabeth Warren") |
296 | 296 | 2019-10-20 | Elizabeth Warren | 758 | 1994 | 0.3801404212637914 | ("Elizabeth Warren") |
590 | 590 | 2019-06-30 | Kamala Harris | 757 | 1672 | 0.4527511961722488 | ("Kamala Harris") |
386 | 386 | 2019-07-07 | Joe Biden | 753 | 1880 | 0.400531914893617 | ("Joe Biden") |
381 | 381 | 2019-06-02 | Joe Biden | 751 | 1652 | 0.4546004842615012 | ("Joe Biden") |
390 | 390 | 2019-08-04 | Joe Biden | 722 | 1937 | 0.3727413526071244 | ("Joe Biden") |
277 | 277 | 2019-06-09 | Elizabeth Warren | 719 | 2049 | 0.3509028794533919 | ("Elizabeth Warren") |
546 | 546 | 2019-06-23 | Julian Castro | 716 | 3561 | 0.2010671159786576 | ("Julian Castro" OR "Julián Castro") |
115 | 115 | 2019-07-14 | Bernie Sanders | 714 | 1802 | 0.3962264150943396 | ("Bernie Sanders") |
124 | 124 | 2019-09-15 | Bernie Sanders | 704 | 2071 | 0.3399323998068566 | ("Bernie Sanders") |
126 | 126 | 2019-09-29 | Bernie Sanders | 699 | 3355 | 0.2083457526080477 | ("Bernie Sanders") |
282 | 282 | 2019-07-14 | Elizabeth Warren | 693 | 1802 | 0.3845726970033296 | ("Elizabeth Warren") |
378 | 378 | 2019-05-12 | Joe Biden | 691 | 1952 | 0.3539959016393442 | ("Joe Biden") |
241 | 241 | 2019-07-28 | Cory Booker | 682 | 3210 | 0.2124610591900311 | ("Cory Booker") |
294 | 294 | 2019-10-06 | Elizabeth Warren | 678 | 2459 | 0.2757218381455876 | ("Elizabeth Warren") |
380 | 380 | 2019-05-26 | Joe Biden | 672 | 1474 | 0.4559023066485753 | ("Joe Biden") |
292 | 292 | 2019-09-22 | Elizabeth Warren | 671 | 3682 | 0.1822379141770777 | ("Elizabeth Warren") |
387 | 387 | 2019-07-14 | Joe Biden | 669 | 1802 | 0.3712541620421754 | ("Joe Biden") |
96 | 96 | 2019-03-03 | Bernie Sanders | 667 | 1485 | 0.4491582491582491 | ("Bernie Sanders") |
106 | 106 | 2019-05-12 | Bernie Sanders | 661 | 1952 | 0.3386270491803279 | ("Bernie Sanders") |
377 | 377 | 2019-05-05 | Joe Biden | 640 | 1577 | 0.4058338617628408 | ("Joe Biden") |
101 | 101 | 2019-04-07 | Bernie Sanders | 636 | 1600 | 0.3975 | ("Bernie Sanders") |
120 | 120 | 2019-08-18 | Bernie Sanders | 635 | 1451 | 0.4376292212267402 | ("Bernie Sanders") |
94 | 94 | 2019-02-17 | Bernie Sanders | 633 | 1406 | 0.4502133712660028 | ("Bernie Sanders") |
790 | 790 | 2019-07-28 | Pete Buttigieg | 631 | 3210 | 0.1965732087227414 | ("Pete Buttigieg") |
95 | 95 | 2019-02-24 | Bernie Sanders | 628 | 1286 | 0.4883359253499222 | ("Bernie Sanders") |
600 | 600 | 2019-09-08 | Kamala Harris | 627 | 1957 | 0.3203883495145631 | ("Kamala Harris") |
104 | 104 | 2019-04-28 | Bernie Sanders | 622 | 1834 | 0.3391494002181025 | ("Bernie Sanders") |
273 | 273 | 2019-05-12 | Elizabeth Warren | 616 | 1952 | 0.3155737704918033 | ("Elizabeth Warren") |
111 | 111 | 2019-06-16 | Bernie Sanders | 615 | 1882 | 0.3267800212539851 | ("Bernie Sanders") |
118 | 118 | 2019-08-04 | Bernie Sanders | 615 | 1937 | 0.3175012906556531 | ("Bernie Sanders") |
285 | 285 | 2019-08-04 | Elizabeth Warren | 610 | 1937 | 0.3149199793495095 | ("Elizabeth Warren") |
113 | 113 | 2019-06-30 | Bernie Sanders | 604 | 1672 | 0.361244019138756 | ("Bernie Sanders") |
258 | 258 | 2019-01-27 | Elizabeth Warren | 604 | 1605 | 0.3763239875389408 | ("Elizabeth Warren") |
98 | 98 | 2019-03-17 | Bernie Sanders | 599 | 1591 | 0.376492771841609 | ("Bernie Sanders") |
129 | 129 | 2019-10-20 | Bernie Sanders | 599 | 1994 | 0.3004012036108325 | ("Bernie Sanders") |
264 | 264 | 2019-03-10 | Elizabeth Warren | 599 | 1810 | 0.330939226519337 | ("Elizabeth Warren") |
276 | 276 | 2019-06-02 | Elizabeth Warren | 592 | 1652 | 0.3583535108958838 | ("Elizabeth Warren") |
259 | 259 | 2019-02-03 | Elizabeth Warren | 586 | 1428 | 0.4103641456582633 | ("Elizabeth Warren") |
97 | 97 | 2019-03-10 | Bernie Sanders | 585 | 1810 | 0.3232044198895027 | ("Bernie Sanders") |
278 | 278 | 2019-06-16 | Elizabeth Warren | 585 | 1882 | 0.3108395324123273 | ("Elizabeth Warren") |
287 | 287 | 2019-08-18 | Elizabeth Warren | 584 | 1451 | 0.4024810475534114 | ("Elizabeth Warren") |
281 | 281 | 2019-07-07 | Elizabeth Warren | 581 | 1880 | 0.3090425531914894 | ("Elizabeth Warren") |
114 | 114 | 2019-07-07 | Bernie Sanders | 579 | 1880 | 0.3079787234042553 | ("Bernie Sanders") |
591 | 591 | 2019-07-07 | Kamala Harris | 571 | 1880 | 0.3037234042553191 | ("Kamala Harris") |
592 | 592 | 2019-07-14 | Kamala Harris | 567 | 1802 | 0.3146503884572697 | ("Kamala Harris") |
394 | 394 | 2019-09-01 | Joe Biden | 562 | 1309 | 0.4293353705118411 | ("Joe Biden") |
109 | 109 | 2019-06-02 | Bernie Sanders | 558 | 1652 | 0.3377723970944309 | ("Bernie Sanders") |
801 | 801 | 2019-10-13 | Pete Buttigieg | 555 | 2788 | 0.1990674318507891 | ("Pete Buttigieg") |
269 | 269 | 2019-04-14 | Elizabeth Warren | 553 | 1936 | 0.2856404958677686 | ("Elizabeth Warren") |
26 | 26 | 2019-06-23 | Amy Klobuchar | 548 | 3561 | 0.1538893569222128 | ("Amy Klobuchar") |
260 | 260 | 2019-02-10 | Elizabeth Warren | 548 | 1612 | 0.3399503722084367 | ("Elizabeth Warren") |
379 | 379 | 2019-05-19 | Joe Biden | 543 | 1580 | 0.3436708860759493 | ("Joe Biden") |
265 | 265 | 2019-03-17 | Elizabeth Warren | 542 | 1591 | 0.3406662476429918 | ("Elizabeth Warren") |
580 | 580 | 2019-04-21 | Kamala Harris | 539 | 2320 | 0.2323275862068965 | ("Kamala Harris") |
198 | 198 | 2019-06-23 | Bill de Blasio | 538 | 3561 | 0.1510811569783768 | ("Bill de Blasio") |
392 | 392 | 2019-08-18 | Joe Biden | 538 | 1451 | 0.3707787732598208 | ("Joe Biden") |
775 | 775 | 2019-04-14 | Pete Buttigieg | 535 | 1936 | 0.2763429752066115 | ("Pete Buttigieg") |
122 | 122 | 2019-09-01 | Bernie Sanders | 526 | 1309 | 0.40183346065699 | ("Bernie Sanders") |
100 | 100 | 2019-03-31 | Bernie Sanders | 521 | 1714 | 0.3039673278879813 | ("Bernie Sanders") |
286 | 286 | 2019-08-11 | Elizabeth Warren | 521 | 1513 | 0.3443489755452742 | ("Elizabeth Warren") |
672 | 672 | 2019-07-28 | Marianne Williamson | 513 | 3210 | 0.1598130841121495 | ("Marianne Williamson") |
280 | 280 | 2019-06-30 | Elizabeth Warren | 509 | 1672 | 0.3044258373205741 | ("Elizabeth Warren") |
776 | 776 | 2019-04-21 | Pete Buttigieg | 509 | 2320 | 0.2193965517241379 | ("Pete Buttigieg") |
571 | 571 | 2019-02-17 | Kamala Harris | 507 | 1406 | 0.3605974395448079 | ("Kamala Harris") |
263 | 263 | 2019-03-03 | Elizabeth Warren | 502 | 1485 | 0.338047138047138 | ("Elizabeth Warren") |
119 | 119 | 2019-08-11 | Bernie Sanders | 497 | 1513 | 0.3284864507600793 | ("Bernie Sanders") |
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 );