puerto-rico-media/tv_hurricanes_by_network

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

84 rows

View and edit SQL

Suggested facets: Query

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