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

CREATE TABLE "puerto-rico-media/tv_states" (
"Date" TEXT,
  "Florida" REAL,
  "Texas" REAL,
  "Puerto Rico" REAL
);

Puerto Rico Media: tv_states.csv