puerto-rico-media/tv_states

52 rows

View and edit SQL

Link rowid Date Florida Texas Puerto Rico
1 8/20/17 0.0923 0.0286 0.0
2 8/21/17 0.0441 0.0904 0.0099
3 8/22/17 0.0359 0.0334 0.0
4 8/23/17 0.0431 0.0839 0.0103
5 8/24/17 0.0492 0.3978 0.0184
6 8/25/17 0.0442 1.4639 0.0
7 8/26/17 0.033 2.3203 0.0391
8 8/27/17 0.0825 1.6419 0.0459
9 8/28/17 0.0346 2.5069 0.0096
10 8/29/17 0.0338 2.3653 0.0069
11 8/30/17 0.0492 2.7901 0.0
12 8/31/17 0.046 2.5442 0.0142
13 9/1/17 0.0751 2.0006 0.0268
14 9/2/17 0.0514 1.6543 0.0173
15 9/3/17 0.0469 0.7525 0.0459
16 9/4/17 0.1194 0.4616 0.0363
17 9/5/17 0.5327 0.3904 0.1865
18 9/6/17 1.3598 0.3831 0.496
19 9/7/17 2.161 0.314 0.3286
20 9/8/17 3.2173 0.3867 0.1086
21 9/9/17 3.6556 0.20199999999999999 0.0481
22 9/10/17 2.0631 0.0776 0.0084
23 9/11/17 3.0005 0.295 0.113
24 9/12/17 2.228 0.1923 0.0936
25 9/13/17 0.9132 0.1261 0.0442
26 9/14/17 1.1859 0.1452 0.0408
27 9/15/17 0.2983 0.0807 0.0331
28 9/16/17 0.2434 0.0906 0.0
29 9/17/17 0.2607 0.0534 0.0245
30 9/18/17 0.1238 0.0645 0.2057
31 9/19/17 0.0751 0.0352 0.7063
32 9/20/17 0.1086 0.0648 1.3539
33 9/21/17 0.1569 0.1449 0.9296
34 9/22/17 0.0693 0.0663 0.4819
35 9/23/17 0.0709 0.0709 0.3109
36 9/24/17 0.0425 0.0369 0.1503
37 9/25/17 0.061 0.06 0.5015
38 9/26/17 0.1593 0.1876 1.4505
39 9/27/17 0.1278 0.1294 0.9554
40 9/28/17 0.1397 0.1248 1.1962
41 9/29/17 0.2069 0.1398 1.1392
42 9/30/17 0.2888 0.1628 1.9577
43 10/1/17 0.3284 0.1509 1.4489
44 10/2/17 0.1308 0.0996 0.3717
45 10/3/17 0.1773 0.1482 1.1783
46 10/4/17 0.0849 0.1266 0.8353
47 10/5/17 0.0856 0.0962 0.4597
48 10/6/17 0.1639 0.1433 0.3692
49 10/7/17 0.2304 0.127 0.4837
50 10/8/17 0.1254 0.085 0.3641
51 10/9/17 0.0433 0.0685 0.2254
52 10/10/17 0.0306 0.1051 0.213

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "puerto-rico-media/tv_states" (
"Date" TEXT,
  "Florida" REAL,
  "Texas" REAL,
  "Puerto Rico" REAL
);
Powered by Datasette · Query took 15.763ms