Media Mentions 2020: cable_weekly.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
24 rows where "date" is on date 2019-07-21
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 |
---|---|---|---|---|---|---|---|---|
30 | 30 | 2019-07-21 | Amy Klobuchar | 25 | 2574 | 96027 | 0.0097125097125097 | ("Amy Klobuchar") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
73 | 73 | 2019-07-21 | Andrew Yang | 16 | 2574 | 96027 | 0.0062160062160062 | ("Andrew Yang") (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) |
159 | 159 | 2019-07-21 | Beto O'Rourke | 47 | 2574 | 96027 | 0.0182595182595182 | ("Beto O'Rourke") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
202 | 202 | 2019-07-21 | Bill de Blasio | 62 | 2574 | 96027 | 0.024087024087024 | ("Bill de Blasio") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
240 | 240 | 2019-07-21 | Cory Booker | 378 | 2574 | 96027 | 0.1468531468531468 | ("Cory Booker") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
283 | 283 | 2019-07-21 | Elizabeth Warren | 356 | 2574 | 96027 | 0.1383061383061383 | ("Elizabeth Warren") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
354 | 354 | 2019-07-21 | Jay Inslee | 0 | 2574 | 96027 | 0.0 | ("Jay Inslee") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
388 | 388 | 2019-07-21 | Joe Biden | 1152 | 2574 | 96027 | 0.4475524475524476 | ("Joe Biden") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
431 | 431 | 2019-07-21 | Joe Sestak | 1 | 2574 | 96027 | 0.0003885003885003 | ("Joe Sestak") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
474 | 474 | 2019-07-21 | John Delaney | 2 | 2574 | 96027 | 0.0007770007770007 | ("John Delaney") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
517 | 517 | 2019-07-21 | John Hickenlooper | 1 | 2574 | 96027 | 0.0003885003885003 | ("John Hickenlooper") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
550 | 550 | 2019-07-21 | Julian Castro | 35 | 2574 | 96027 | 0.0135975135975135 | ("Julian Castro" OR "Julián Castro") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
593 | 593 | 2019-07-21 | Kamala Harris | 621 | 2574 | 96027 | 0.2412587412587412 | ("Kamala Harris") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
636 | 636 | 2019-07-21 | Kirsten Gillibrand | 35 | 2574 | 96027 | 0.0135975135975135 | ("Kirsten Gillibrand") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
671 | 671 | 2019-07-21 | Marianne Williamson | 11 | 2574 | 96027 | 0.0042735042735042 | ("Marianne Williamson") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
714 | 714 | 2019-07-21 | Michael Bennet | 8 | 2574 | 96027 | 0.0031080031080031 | ("Michael Bennet") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
757 | 757 | 2019-07-21 | Mike Gravel | 0 | 2574 | 96027 | 0.0 | ("Mike Gravel") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
789 | 789 | 2019-07-21 | Pete Buttigieg | 89 | 2574 | 96027 | 0.0345765345765345 | ("Pete Buttigieg") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
832 | 832 | 2019-07-21 | Seth Moulton | 1 | 2574 | 96027 | 0.0003885003885003 | ("Seth Moulton") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
866 | 866 | 2019-07-21 | Steve Bullock | 12 | 2574 | 96027 | 0.0046620046620046 | ("Steve Bullock") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
909 | 909 | 2019-07-21 | Tim Ryan | 7 | 2574 | 96027 | 0.0027195027195027 | ("Tim Ryan") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
952 | 952 | 2019-07-21 | Tom Steyer | 95 | 2574 | 96027 | 0.0369075369075368 | ("Tom Steyer") (station:MSNBC OR station:CNN OR station:FOXNEWS) |
995 | 995 | 2019-07-21 | Tulsi Gabbard | 20 | 2574 | 96027 | 0.0077700077700077 | ("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 );