home / fivethirtyeight

Menu
  • GraphQL API

Puerto Rico Media: tv_states.csv

Table actions
  • GraphQL API for puerto-rico-media/tv_states

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.

  • mediacloud_hurricanes.csv contains the number of sentences per day that mention Hurricanes Harvey, Irma, Jose, and Maria in online news.
  • mediacloud_states.csv (Updated through 10/10/2017) contains the number of sentences per day that mention Puerto Rico, Texas, and Florida in online news.
  • mediacloud_trump.csv (Updated through 10/10/2017) contains the number of headlines that mention Puerto Rico, Texas, and Florida, as well as headlines that mention those three locations along with 'President' or 'Trump'.
  • mediacloud_top_online_news.csv contains a list of sources included in Media Cloud's "U.S. Top Online News" collection.

TV News Data

TV News Data was collected from the Internet TV News Archive using the Television Explorer tool.

  • tv_hurricanes.csv - contains the percent of sentences per day in TV News that mention Hurricanes Harvey, Irma, Jose, and Maria.
  • tv_hurricanes_by_network.csv - contains the percent of sentences per day in TV News per network that mention Hurricanes Harvey, Irma, Jose, and Maria.
  • tv_states.csv (Updated through 10/10/2017) - contains the percent of sentences per day in TV News that mention Puerto Rico, Texas, and Florida.

Google Search Queries

Google search data was collected using the Google Trends dashboard.

  • google_trends.csv - Contains data on google trend searches for Hurricanes Harvey, Irma, Jose, and Maria.

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

This data as json, copyable, CSV (advanced)

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