Media Mentions 2020: cable_weekly.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
25 rows where "date" is on date 2019-05-05
This data as json, copyable, CSV (advanced)
Suggested facets: matched_clips, pct_of_all_candidate_clips
Link | rowid ▼ | date | name | matched_clips | all_candidate_clips | total_clips | pct_of_all_candidate_clips | query |
---|---|---|---|---|---|---|---|---|
19 | 19 | 2019-05-05 | Amy Klobuchar | 130 | 2748 | 94528 | 0.0473071324599708 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
62 | 62 | 2019-05-05 | Andrew Yang | 20 | 2748 | 94528 | 0.007278020378457 | ("Andrew Yang") (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) |
148 | 148 | 2019-05-05 | Beto O'Rourke | 90 | 2748 | 94528 | 0.0327510917030567 | ("Beto O'Rourke") (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) |
229 | 229 | 2019-05-05 | Cory Booker | 137 | 2748 | 94528 | 0.0498544395924308 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
272 | 272 | 2019-05-05 | Elizabeth Warren | 289 | 2748 | 94528 | 0.1051673944687045 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
315 | 315 | 2019-05-05 | Eric Swalwell | 39 | 2748 | 94528 | 0.0141921397379912 | ("Eric Swalwell") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
343 | 343 | 2019-05-05 | Jay Inslee | 10 | 2748 | 94528 | 0.0036390101892285 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
377 | 377 | 2019-05-05 | Joe Biden | 1411 | 2748 | 94528 | 0.5134643377001455 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
420 | 420 | 2019-05-05 | Joe Sestak | 0 | 2748 | 94528 | 0.0 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
463 | 463 | 2019-05-05 | John Delaney | 4 | 2748 | 94528 | 0.0014556040756914 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
506 | 506 | 2019-05-05 | John Hickenlooper | 12 | 2748 | 94528 | 0.0043668122270742 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
539 | 539 | 2019-05-05 | Julian Castro | 7 | 2748 | 94528 | 0.0025473071324599 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
582 | 582 | 2019-05-05 | Kamala Harris | 266 | 2748 | 94528 | 0.0967976710334788 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
625 | 625 | 2019-05-05 | Kirsten Gillibrand | 33 | 2748 | 94528 | 0.0120087336244541 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
660 | 660 | 2019-05-05 | Marianne Williamson | 9 | 2748 | 94528 | 0.0032751091703056 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
703 | 703 | 2019-05-05 | Michael Bennet | 27 | 2748 | 94528 | 0.009825327510917 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
746 | 746 | 2019-05-05 | Mike Gravel | 0 | 2748 | 94528 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
778 | 778 | 2019-05-05 | Pete Buttigieg | 196 | 2748 | 94528 | 0.0713245997088791 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
821 | 821 | 2019-05-05 | Seth Moulton | 3 | 2748 | 94528 | 0.0010917030567685 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
855 | 855 | 2019-05-05 | Steve Bullock | 5 | 2748 | 94528 | 0.0018195050946142 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
898 | 898 | 2019-05-05 | Tim Ryan | 5 | 2748 | 94528 | 0.0018195050946142 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
941 | 941 | 2019-05-05 | Tom Steyer | 1 | 2748 | 94528 | 0.0003639010189228 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
984 | 984 | 2019-05-05 | Tulsi Gabbard | 5 | 2748 | 94528 | 0.0018195050946142 | ("Tulsi Gabbard") (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 );