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 Puerto Rico

View and edit SQL

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

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