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

26 rows where Query = "Hurricane Irma"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: BBC News, MSNBC

Link rowid ▼ Date Query BBC News CNN FOX News MSNBC
10 10 8/31/17 Hurricane Irma 0.0 0.0072 0.0315 0.0
11 11 9/1/17 Hurricane Irma 0.0 0.1109 0.0914 0.0146
12 12 9/2/17 Hurricane Irma 0.0 0.0147 0.1081 0.0217
13 13 9/3/17 Hurricane Irma 0.0 0.0075 0.0642 0.0332
14 14 9/4/17 Hurricane Irma 0.0518 0.1166 0.1074 0.04
15 15 9/5/17 Hurricane Irma 0.3483 0.3329 0.2811 0.1583
16 16 9/6/17 Hurricane Irma 1.1525 0.6921 0.5575 0.3442
17 17 9/7/17 Hurricane Irma 1.4428 1.0137 0.6116 0.5171
18 18 9/8/17 Hurricane Irma 1.3243 1.1146 0.9578 0.7001
19 19 9/9/17 Hurricane Irma 1.1708 1.0285 1.208 1.2863
20 20 9/10/17 Hurricane Irma 1.4633 0.737 0.6727 0.2444
21 21 9/11/17 Hurricane Irma 1.1942 0.7329 0.9287 0.7105
22 22 9/12/17 Hurricane Irma 0.6716 0.5916 0.6647 0.5033
23 23 9/13/17 Hurricane Irma 0.4248 0.4102 0.203 0.174
24 24 9/14/17 Hurricane Irma 0.4412 0.417 0.3971 0.3843
25 25 9/15/17 Hurricane Irma 0.0418 0.1209 0.0756 0.1537
26 26 9/16/17 Hurricane Irma 0.0558 0.109 0.1555 0.0902
27 27 9/17/17 Hurricane Irma 0.0281 0.1642 0.1027 0.1764
28 28 9/18/17 Hurricane Irma 0.192 0.1866 0.1877 0.1231
29 29 9/19/17 Hurricane Irma 0.4787 0.1374 0.0816 0.085
30 30 9/20/17 Hurricane Irma 0.1715 0.1825 0.1747 0.1036
31 31 9/21/17 Hurricane Irma 0.0793 0.1174 0.0967 0.0283
32 32 9/22/17 Hurricane Irma 0.0145 0.0238 0.0499 0.0207
33 33 9/23/17 Hurricane Irma 0.023 0.0144 0.0066 0.0253
34 34 9/24/17 Hurricane Irma 0.0 0.0 0.0 0.0
35 35 9/25/17 Hurricane Irma 0.0 0.011 0.0331 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
);