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 url

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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