home / fivethirtyeight

Puerto Rico Media: mediacloud_hurricanes.csv

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.

TV News Data

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

Google Search Queries

Google search data was collected using the Google Trends dashboard.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

38 rows

View and edit SQL

Suggested facets: Irma, Maria, Jose

Link rowid Date Harvey Irma Maria Jose
1 8/20/17 0 0 0 0
2 8/21/17 0 0 0 0
3 8/22/17 4 1 0 0
4 8/23/17 6 1 0 0
5 8/24/17 309 0 0 0
6 8/25/17 1348 1 0 0
7 8/26/17 995 0 0 0
8 8/27/17 960 0 0 0
9 8/28/17 1956 1 0 0
10 8/29/17 2283 0 0 0
11 8/30/17 1603 0 0 0
12 8/31/17 1503 61 0 0
13 9/1/17 1109 66 0 0
14 9/2/17 700 36 0 0
15 9/3/17 546 52 0 0
16 9/4/17 713 221 0 0
17 9/5/17 1203 793 0 0
18 9/6/17 933 1668 0 31
19 9/7/17 744 1994 0 93
20 9/8/17 716 2049 0 167
21 9/9/17 420 1595 0 195
22 9/10/17 278 2544 0 94
23 9/11/17 400 2416 0 61
24 9/12/17 508 1388 0 42
25 9/13/17 465 1057 1 50
26 9/14/17 338 896 0 9
27 9/15/17 266 488 6 30
28 9/16/17 89 316 1 65
29 9/17/17 107 244 41 78
30 9/18/17 288 360 304 63
31 9/19/17 196 575 518 82
32 9/20/17 234 300 545 20
33 9/21/17 169 262 528 7
34 9/22/17 155 175 409 1
35 9/23/17 12 5 1 0
36 9/24/17 4 3 0 0
37 9/25/17 0 0 0 0
38 9/26/17 0 0 0 0

Advanced export

JSON shape: default, array

CSV options:

CREATE TABLE "puerto-rico-media/mediacloud_hurricanes" (
"Date" TEXT,
  "Harvey" INTEGER,
  "Irma" INTEGER,
  "Maria" INTEGER,
  "Jose" INTEGER
)
Powered by Datasette · Query took 24.042ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub