Puerto Rico Media: tv_hurricanes_by_network.csv

Table actions

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

16 rows where Query = "Hurricane Jose"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: BBC News, CNN, FOX News, MSNBC

Link rowid ▼ Date Query BBC News CNN FOX News MSNBC
69 69 9/6/17 Hurricane Jose 0.0 0.0 0.0172 0.0
70 70 9/7/17 Hurricane Jose 0.0971 0.0467 0.0422 0.0146
71 71 9/8/17 Hurricane Jose 0.1387 0.1679 0.0408 0.0267
72 72 9/9/17 Hurricane Jose 0.2148 0.0511 0.0403 0.0887
73 73 9/10/17 Hurricane Jose 0.0206 0.0 0.0 0.0111
74 74 9/11/17 Hurricane Jose 0.0234 0.0161 0.0223 0.0192
75 75 9/12/17 Hurricane Jose 0.0 0.0 0.0277 0.0067
76 76 9/13/17 Hurricane Jose 0.0075 0.0091 0.0085 0.0
77 77 9/14/17 Hurricane Jose 0.007 0.0 0.0 0.0
78 78 9/15/17 Hurricane Jose 0.0 0.0076 0.0 0.0
79 79 9/16/17 Hurricane Jose 0.0 0.0436 0.0283 0.0347
80 80 9/17/17 Hurricane Jose 0.0 0.0386 0.0237 0.0415
81 81 9/18/17 Hurricane Jose 0.0 0.0104 0.0427 0.0284
82 82 9/19/17 Hurricane Jose 0.0 0.0 0.0148 0.0638
83 83 9/20/17 Hurricane Jose 0.0 0.0 0.0146 0.0
84 84 9/21/17 Hurricane Jose 0.0 0.0084 0.0069 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "puerto-rico-media/tv_hurricanes_by_network" (
"Date" TEXT,
  "Query" TEXT,
  "BBC News" REAL,
  "CNN" REAL,
  "FOX News" REAL,
  "MSNBC" REAL
);