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

84 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Query

Link rowid ▲ Date Query BBC News CNN FOX News MSNBC
84 84 9/21/17 Hurricane Jose 0.0 0.0084 0.0069 0.0
83 83 9/20/17 Hurricane Jose 0.0 0.0 0.0146 0.0
82 82 9/19/17 Hurricane Jose 0.0 0.0 0.0148 0.0638
81 81 9/18/17 Hurricane Jose 0.0 0.0104 0.0427 0.0284
80 80 9/17/17 Hurricane Jose 0.0 0.0386 0.0237 0.0415
79 79 9/16/17 Hurricane Jose 0.0 0.0436 0.0283 0.0347
78 78 9/15/17 Hurricane Jose 0.0 0.0076 0.0 0.0
77 77 9/14/17 Hurricane Jose 0.007 0.0 0.0 0.0
76 76 9/13/17 Hurricane Jose 0.0075 0.0091 0.0085 0.0
75 75 9/12/17 Hurricane Jose 0.0 0.0 0.0277 0.0067
74 74 9/11/17 Hurricane Jose 0.0234 0.0161 0.0223 0.0192
73 73 9/10/17 Hurricane Jose 0.0206 0.0 0.0 0.0111
72 72 9/9/17 Hurricane Jose 0.2148 0.0511 0.0403 0.0887
71 71 9/8/17 Hurricane Jose 0.1387 0.1679 0.0408 0.0267
70 70 9/7/17 Hurricane Jose 0.0971 0.0467 0.0422 0.0146
69 69 9/6/17 Hurricane Jose 0.0 0.0 0.0172 0.0
68 68 9/25/17 Hurricane Harvey 0.0 0.011 0.0166 0.0194
67 67 9/24/17 Hurricane Harvey 0.0 0.0 0.0156 0.0
66 66 9/23/17 Hurricane Harvey 0.0077 0.0 0.0593 0.0084
65 65 9/22/17 Hurricane Harvey 0.0 0.0476 0.0427 0.0345
64 64 9/21/17 Hurricane Harvey 0.0 0.0251 0.0622 0.0212
63 63 9/20/17 Hurricane Harvey 0.0082 0.0 0.0073 0.0069
62 62 9/19/17 Hurricane Harvey 0.0 0.0 0.0 0.0142
61 61 9/18/17 Hurricane Harvey 0.0 0.0 0.0171 0.0
60 60 9/17/17 Hurricane Harvey 0.0 0.0097 0.0079 0.0
59 59 9/16/17 Hurricane Harvey 0.007 0.0073 0.0354 0.0139
58 58 9/15/17 Hurricane Harvey 0.0 0.0 0.0151 0.0154
57 57 9/14/17 Hurricane Harvey 0.021 0.0309 0.0426 0.0077
56 56 9/13/17 Hurricane Harvey 0.0 0.0091 0.0508 0.0261
55 55 9/12/17 Hurricane Harvey 0.0072 0.0524 0.09 0.0336
54 54 9/11/17 Hurricane Harvey 0.0468 0.0322 0.1337 0.032
53 53 9/10/17 Hurricane Harvey 0.0206 0.0278 0.1067 0.0
52 52 9/9/17 Hurricane Harvey 0.0 0.0128 0.1691 0.1257
51 51 9/8/17 Hurricane Harvey 0.0208 0.1746 0.2242 0.1534
50 50 9/7/17 Hurricane Harvey 0.0624 0.1134 0.2109 0.1457
49 49 9/6/17 Hurricane Harvey 0.0419 0.2543 0.223 0.1549
48 48 9/5/17 Hurricane Harvey 0.0909 0.1498 0.1851 0.1223
47 47 9/4/17 Hurricane Harvey 0.0222 0.2331 0.3078 0.3
46 46 9/3/17 Hurricane Harvey 0.0805 0.2093 0.2753 0.5202
45 45 9/2/17 Hurricane Harvey 0.2444 0.491 0.7797 0.4783
44 44 9/1/17 Hurricane Harvey 0.1267 0.3771 0.5253 0.387
43 43 8/31/17 Hurricane Harvey 0.2116 0.2874 0.3308 0.2755
42 42 8/30/17 Hurricane Harvey 0.1011 0.1856 0.3229 0.2055
41 41 8/29/17 Hurricane Harvey 0.1885 0.1675 0.3127 0.2115
40 40 8/28/17 Hurricane Harvey 0.1057 0.282 0.1554 0.2863
39 39 8/27/17 Hurricane Harvey 0.1089 0.2344 0.2734 0.2329
38 38 8/26/17 Hurricane Harvey 0.762 0.8628 1.0857 0.9577
37 37 8/25/17 Hurricane Harvey 0.3431 0.8813 0.6824 0.6498
36 36 8/24/17 Hurricane Harvey 0.0 0.114 0.121 0.0585
35 35 9/25/17 Hurricane Irma 0.0 0.011 0.0331 0.0
34 34 9/24/17 Hurricane Irma 0.0 0.0 0.0 0.0
33 33 9/23/17 Hurricane Irma 0.023 0.0144 0.0066 0.0253
32 32 9/22/17 Hurricane Irma 0.0145 0.0238 0.0499 0.0207
31 31 9/21/17 Hurricane Irma 0.0793 0.1174 0.0967 0.0283
30 30 9/20/17 Hurricane Irma 0.1715 0.1825 0.1747 0.1036
29 29 9/19/17 Hurricane Irma 0.4787 0.1374 0.0816 0.085
28 28 9/18/17 Hurricane Irma 0.192 0.1866 0.1877 0.1231
27 27 9/17/17 Hurricane Irma 0.0281 0.1642 0.1027 0.1764
26 26 9/16/17 Hurricane Irma 0.0558 0.109 0.1555 0.0902
25 25 9/15/17 Hurricane Irma 0.0418 0.1209 0.0756 0.1537
24 24 9/14/17 Hurricane Irma 0.4412 0.417 0.3971 0.3843
23 23 9/13/17 Hurricane Irma 0.4248 0.4102 0.203 0.174
22 22 9/12/17 Hurricane Irma 0.6716 0.5916 0.6647 0.5033
21 21 9/11/17 Hurricane Irma 1.1942 0.7329 0.9287 0.7105
20 20 9/10/17 Hurricane Irma 1.4633 0.737 0.6727 0.2444
19 19 9/9/17 Hurricane Irma 1.1708 1.0285 1.208 1.2863
18 18 9/8/17 Hurricane Irma 1.3243 1.1146 0.9578 0.7001
17 17 9/7/17 Hurricane Irma 1.4428 1.0137 0.6116 0.5171
16 16 9/6/17 Hurricane Irma 1.1525 0.6921 0.5575 0.3442
15 15 9/5/17 Hurricane Irma 0.3483 0.3329 0.2811 0.1583
14 14 9/4/17 Hurricane Irma 0.0518 0.1166 0.1074 0.04
13 13 9/3/17 Hurricane Irma 0.0 0.0075 0.0642 0.0332
12 12 9/2/17 Hurricane Irma 0.0 0.0147 0.1081 0.0217
11 11 9/1/17 Hurricane Irma 0.0 0.1109 0.0914 0.0146
10 10 8/31/17 Hurricane Irma 0.0 0.0072 0.0315 0.0
9 9 9/25/17 Hurricane Maria 0.0615 0.2536 0.1326 0.0583
8 8 9/24/17 Hurricane Maria 0.0216 0.0676 0.0779 0.0234
7 7 9/23/17 Hurricane Maria 0.399 0.1442 0.0593 0.0674
6 6 9/22/17 Hurricane Maria 0.2761 0.2778 0.1211 0.1998
5 5 9/21/17 Hurricane Maria 0.4756 0.6454 0.3177 0.2406
4 4 9/20/17 Hurricane Maria 0.988 0.7985 0.5387 0.4835
3 3 9/19/17 Hurricane Maria 0.8901 0.5818 0.1779 0.2621
2 2 9/18/17 Hurricane Maria 0.2204 0.1866 0.1877 0.0473
1 1 9/17/17 Hurricane Maria 0.0 0.029 0.0079 0.0208

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
);