puerto-rico-media/mediacloud_states

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

51 rows

View and edit SQL

Link rowid ▼ Date Texas "Puerto Rico" Florida
1 8/20/17 295 32 239
2 8/21/17 998 24 527
3 8/22/17 696 32 577
4 8/23/17 1130 36 596
5 8/24/17 1851 135 933
6 8/25/17 2693 39 533
7 8/26/17 1953 15 199
8 8/27/17 2962 11 211
9 8/28/17 5072 42 569
10 8/29/17 5013 14 508
11 8/30/17 4436 42 589
12 8/31/17 3935 40 553
13 9/1/17 2746 18 651
14 9/2/17 1919 15 569
15 9/3/17 1435 50 528
16 9/4/17 1522 224 584
17 9/5/17 2114 500 1580
18 9/6/17 1728 938 2781
19 9/7/17 1607 635 3056
20 9/8/17 1384 227 3434
21 9/9/17 814 121 2974
22 9/10/17 724 154 4003
23 9/11/17 1226 151 3760
24 9/12/17 1224 143 2525
25 9/13/17 1067 73 2004
26 9/14/17 1007 127 1781
27 9/15/17 1122 56 1087
28 9/16/17 554 36 703
29 9/17/17 522 125 542
30 9/18/17 725 485 700
31 9/19/17 983 908 912
32 9/20/17 866 1461 700
33 9/21/17 799 1415 620
34 9/22/17 1070 1270 577
35 9/23/17 844 665 541
36 9/24/17 411 674 360
37 9/25/17 812 1562 518
38 9/26/17 1295 2577 832
39 9/27/17 924 2107 728
40 9/28/17 863 2177 675
41 9/29/17 949 2202 559
42 9/30/17 504 1593 491
43 10/1/17 604 1394 621
44 10/2/17 839 1026 684
45 10/3/17 891 2217 746
46 10/4/17 779 1492 635
47 10/5/17 907 824 722
48 10/6/17 758 1252 695
49 10/7/17 411 352 466
50 10/8/17 400 317 395
51 10/9/17 828 580 427

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "puerto-rico-media/mediacloud_states" (
"Date" TEXT,
  "Texas" INTEGER,
  """Puerto Rico""" INTEGER,
  "Florida" INTEGER
);
Powered by Datasette · Query took 25.886ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub