home / fivethirtyeight

Menu
  • GraphQL API

Puerto Rico Media: mediacloud_top_online_news.csv

Table actions
  • GraphQL API for puerto-rico-media/mediacloud_top_online_news

This table contains data behind the stories: The Media Really Has Neglected Puerto Rico The Media Really Started Paying Attention To Puerto Rico When Trump Did

Online News Data

Data about Online News was collected using the Media Cloud dashboard, an open source suite of tools for analyzing a database of online news.

  • mediacloud_hurricanes.csv contains the number of sentences per day that mention Hurricanes Harvey, Irma, Jose, and Maria in online news.
  • mediacloud_states.csv (Updated through 10/10/2017) contains the number of sentences per day that mention Puerto Rico, Texas, and Florida in online news.
  • mediacloud_trump.csv (Updated through 10/10/2017) contains the number of headlines that mention Puerto Rico, Texas, and Florida, as well as headlines that mention those three locations along with 'President' or 'Trump'.
  • mediacloud_top_online_news.csv contains a list of sources included in Media Cloud's "U.S. Top Online News" collection.

TV News Data

TV News Data was collected from the Internet TV News Archive using the Television Explorer tool.

  • tv_hurricanes.csv - contains the percent of sentences per day in TV News that mention Hurricanes Harvey, Irma, Jose, and Maria.
  • tv_hurricanes_by_network.csv - contains the percent of sentences per day in TV News per network that mention Hurricanes Harvey, Irma, Jose, and Maria.
  • tv_states.csv (Updated through 10/10/2017) - contains the percent of sentences per day in TV News that mention Puerto Rico, Texas, and Florida.

Google Search Queries

Google search data was collected using the Google Trends dashboard.

  • google_trends.csv - Contains data on google trend searches for Hurricanes Harvey, Irma, Jose, and Maria.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

49 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ name url
49 49 Yahoo News http://news.yahoo.com/
48 48 Washington Post http://washingtonpost.com
47 47 Vox http://www.vox.com
46 46 Vice http://m.vice.com
45 45 USAToday http://usatoday.com/
44 44 US News & World Report http://www.usnews.com/
43 43 upworthy.com http://www.upworthy.com
42 42 Time http://time.com
41 41 themirror http://www.mirror.co.uk/
40 40 The Daily Beast http://www.thedailybeast.com/
39 39 The Boston Globe http://www.boston.com/bostonglobe/
38 38 The Blaze http://www.theblaze.com
37 37 The Atlantic http://www.theatlantic.com/
36 36 TechCrunch http://techcrunch.com
35 35 slate.com http://www.slate.com
34 34 sfchronicle http://www.sfgate.com/
33 33 Salon http://www.salon.com/
32 32 NY Post http://www.nypost.com/
31 31 NPR http://www.npr.org/
30 30 nj.com http://www.nj.com
29 29 New York Times http://nytimes.com
28 28 NBC News http://www.nbcnews.com
27 27 MSNBC http://www.msnbc.msn.com/
26 26 mlive.com http://mlive.com/
25 25 Mic http://mic.com/
24 24 Mashable! http://mashable.com
23 23 LA Times http://www.latimes.com/
22 22 Independent http://www.independent.co.uk/
21 21 Huffington Post http://www.huffingtonpost.com/#
20 20 houstonchronicle http://www.chron.com/
19 19 Guardian http://www.guardian.co.uk/
18 18 Gawker http://gawker.com
17 17 freep.com http://www.freep.com
16 16 foxnews.com http://foxnews.com/
15 15 Examiner.com http://examiner.com
14 14 Engadget http://engadget.com
13 13 elitedaily.com http://elitedaily.com/#spider
12 12 Dallas Morning News http://www.dallasnews.com/
11 11 Daily Telegraph http://www.telegraph.co.uk/
10 10 Daily News http://www.nydailynews.com/
9 9 Daily Mail http://www.dailymail.co.uk/home/index.html
8 8 CNN http://www.cnn.com/
7 7 CNET http://cnet.com
6 6 Chicago Tribune http://www.chicagotribune.com/
5 5 cbs news http://www.cbsnews.com/
4 4 Buzzfeed http://www.buzzfeed.com
3 3 Business Insider http://www.businessinsider.com
2 2 bleacherreport.com http://bleacherreport.com
1 1 al.com http://www.al.com

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "puerto-rico-media/mediacloud_top_online_news" (
"name" TEXT,
  "url" TEXT
);
Powered by Datasette · Queries took 221.985ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette