fivethirtyeight: puerto-rico-media/tv

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 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 data was collected using the Google Trends dashboard.

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

descending

Link	rowid ▼	Date	Harvey	Irma	Maria	Jose
1	1	8/20/17	0.0	0.0	0.0	0.0
2	2	8/21/17	0.0	0.0	0.0	0.0
3	3	8/22/17	0.0	0.0	0.0	0.0
4	4	8/23/17	0.0	0.0	0.0	0.0
5	5	8/24/17	0.1259	0.0	0.0	0.0
6	6	8/25/17	0.7544	0.0	0.0	0.0
7	7	8/26/17	0.8878	0.0	0.0	0.0
8	8	8/27/17	0.2163	0.0	0.0	0.0
9	9	8/28/17	0.3013	0.0	0.0	0.0
10	10	8/29/17	0.2395	0.0	0.0	0.0
11	11	8/30/17	0.318	0.0101	0.0	0.0
12	12	8/31/17	0.3217	0.0148	0.0	0.0
13	13	9/1/17	0.4643	0.0632	0.0	0.0
14	14	9/2/17	0.4694	0.047	0.0	0.0
15	15	9/3/17	0.277	0.033	0.0	0.0
16	16	9/4/17	0.2308	0.0767	0.0	0.0
17	17	9/5/17	0.2466	0.2577	0.0	0.0118
18	18	9/6/17	0.2737	0.5302	0.0	0.0196
19	19	9/7/17	0.2039	0.669	0.0	0.0366
20	20	9/8/17	0.1884	0.862	0.0	0.0605
21	21	9/9/17	0.1134	0.948	0.0	0.0565
22	22	9/10/17	0.1099	0.4994	0.0	0.0223
23	23	9/11/17	0.0948	0.7643	0.0	0.019
24	24	9/12/17	0.0743	0.5085	0.0	0.018
25	25	9/13/17	0.0522	0.2756	0.0	0.0088
26	26	9/14/17	0.0389	0.3174	0.0	0.017
27	27	9/15/17	0.0343	0.1035	0.0	0.0076
28	28	9/16/17	0.0207	0.1087	0.0	0.0355
29	29	9/17/17	0.0087	0.109	0.0184	0.0337
30	30	9/18/17	0.0242	0.1168	0.129	0.0331
31	31	9/19/17	0.0355	0.0812	0.3079	0.0359
32	32	9/20/17	0.0259	0.1266	0.5094	0.0146
33	33	9/21/17	0.0412	0.0739	0.338	0.0076
34	34	9/22/17	0.0324	0.0354	0.168	0.0
35	35	9/23/17	0.037	0.0147	0.0834	0.0
36	36	9/24/17	0.0156	0.0	0.0652	0.0
37	37	9/25/17	0.0353	0.0345	0.1183	0.0

CREATE TABLE "puerto-rico-media/tv_hurricanes" (
"Date" TEXT,
  "Harvey" REAL,
  "Irma" REAL,
  "Maria" REAL,
  "Jose" REAL
);

Puerto Rico Media: tv_hurricanes.csv