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 · About: simonw/fivethirtyeight-datasette

52 rows sorted by rowid descending

View and edit SQL

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

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
);