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 Florida

View and edit SQL

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

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