puerto-rico-media/mediacloud_hurricanes

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, newline-delimited

CSV options:

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