Puerto Rico Media: mediacloud_trump.csv

Table actions

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

51 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: title:"Puerto Rico", title:"Puerto Rico" AND (title:Trump OR title:President), title:Florida AND (title:Trump OR title:President), title:Texas AND (title:Trump OR title:President), Date (date)

Link rowid ▼ Date title:"Puerto Rico" title:"Puerto Rico" AND (title:Trump OR title:President) title:Florida title:Florida AND (title:Trump OR title:President) title:Texas title:Texas AND (title:Trump OR title:President)
1 1 2017-08-20 0 0 18 2 12 0
2 2 2017-08-21 1 0 41 0 79 0
3 3 2017-08-22 0 0 30 0 39 0
4 4 2017-08-23 1 0 39 0 83 6
5 5 2017-08-24 8 0 75 1 143 3
6 6 2017-08-25 2 0 28 0 218 11
7 7 2017-08-26 0 0 13 0 212 3
8 8 2017-08-27 0 0 13 0 223 38
9 9 2017-08-28 6 0 40 1 289 41
10 10 2017-08-29 1 0 38 3 378 133
11 11 2017-08-30 0 0 41 0 316 22
12 12 2017-08-31 2 0 29 0 300 15
13 13 2017-09-01 0 0 37 1 167 17
14 14 2017-09-02 0 0 58 0 161 51
15 15 2017-09-03 0 0 37 0 107 2
16 16 2017-09-04 8 0 37 0 71 1
17 17 2017-09-05 23 2 120 3 88 2
18 18 2017-09-06 55 0 157 2 62 3
19 19 2017-09-07 44 0 231 7 91 5
20 20 2017-09-08 2 0 294 4 64 1
21 21 2017-09-09 3 0 266 3 37 4
22 22 2017-09-10 6 1 332 21 38 0
23 23 2017-09-11 1 0 298 0 93 24
24 24 2017-09-12 1 0 217 4 59 0
25 25 2017-09-13 1 0 208 7 48 6
26 26 2017-09-14 2 0 168 59 49 1
27 27 2017-09-15 0 0 70 3 54 1
28 28 2017-09-16 0 0 67 0 38 0
29 29 2017-09-17 0 0 29 0 35 0
30 30 2017-09-18 36 0 40 1 26 3
31 31 2017-09-19 86 0 49 2 50 2
32 32 2017-09-20 204 0 39 1 33 3
33 33 2017-09-21 167 4 49 0 56 3
34 34 2017-09-22 175 0 29 4 51 3
35 35 2017-09-23 77 4 22 0 40 3
36 36 2017-09-24 73 2 14 1 17 1
37 37 2017-09-25 177 34 33 2 30 3
38 38 2017-09-26 308 113 50 0 57 9
39 39 2017-09-27 276 47 33 0 52 0
40 40 2017-09-28 300 86 31 0 41 2
41 41 2017-09-29 273 78 28 0 57 1
42 42 2017-09-30 157 56 37 0 18 0
43 43 2017-10-01 148 73 17 1 18 0
44 44 2017-10-02 105 30 20 2 27 0
45 45 2017-10-03 296 174 24 2 41 3
46 46 2017-10-04 154 65 27 0 49 4
47 47 2017-10-05 87 12 41 1 52 5
48 48 2017-10-06 161 20 35 0 46 1
49 49 2017-10-07 49 10 29 0 19 0
50 50 2017-10-08 36 13 13 0 17 1
51 51 2017-10-09 72 6 27 0 65 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "puerto-rico-media/mediacloud_trump" (
"Date" TEXT,
  "title:""Puerto Rico""" INTEGER,
  "title:""Puerto Rico"" AND (title:Trump OR title:President)" INTEGER,
  "title:Florida" INTEGER,
  "title:Florida AND (title:Trump OR title:President)" INTEGER,
  "title:Texas" INTEGER,
  "title:Texas AND (title:Trump OR title:President)" INTEGER
);