home / fivethirtyeight

Puerto Rico Media: tv_states.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

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

CSV options:

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