Puerto Rico Media: tv_hurricanes_by_network.csv

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

84 rows sorted by CNN

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	Date	Query	BBC News	CNN ▼	FOX News	MSNBC
34	34	9/24/17	Hurricane Irma	0.0	0.0	0.0	0.0
58	58	9/15/17	Hurricane Harvey	0.0	0.0	0.0151	0.0154
61	61	9/18/17	Hurricane Harvey	0.0	0.0	0.0171	0.0
62	62	9/19/17	Hurricane Harvey	0.0	0.0	0.0	0.0142
63	63	9/20/17	Hurricane Harvey	0.0082	0.0	0.0073	0.0069
66	66	9/23/17	Hurricane Harvey	0.0077	0.0	0.0593	0.0084
67	67	9/24/17	Hurricane Harvey	0.0	0.0	0.0156	0.0
69	69	9/6/17	Hurricane Jose	0.0	0.0	0.0172	0.0
73	73	9/10/17	Hurricane Jose	0.0206	0.0	0.0	0.0111
75	75	9/12/17	Hurricane Jose	0.0	0.0	0.0277	0.0067
77	77	9/14/17	Hurricane Jose	0.006999999999999999	0.0	0.0	0.0
82	82	9/19/17	Hurricane Jose	0.0	0.0	0.0148	0.0638
83	83	9/20/17	Hurricane Jose	0.0	0.0	0.0146	0.0
10	10	8/31/17	Hurricane Irma	0.0	0.0072	0.0315	0.0
59	59	9/16/17	Hurricane Harvey	0.006999999999999999	0.0073	0.0354	0.0139
13	13	9/3/17	Hurricane Irma	0.0	0.0075	0.0642	0.0332
78	78	9/15/17	Hurricane Jose	0.0	0.0076	0.0	0.0
84	84	9/21/17	Hurricane Jose	0.0	0.0084	0.0069	0.0
56	56	9/13/17	Hurricane Harvey	0.0	0.0091	0.0508	0.0261
76	76	9/13/17	Hurricane Jose	0.0075	0.0091	0.0085	0.0
60	60	9/17/17	Hurricane Harvey	0.0	0.0097	0.0079	0.0
81	81	9/18/17	Hurricane Jose	0.0	0.0104	0.0427	0.0284
35	35	9/25/17	Hurricane Irma	0.0	0.011000000000000001	0.0331	0.0
68	68	9/25/17	Hurricane Harvey	0.0	0.011000000000000001	0.0166	0.0194
52	52	9/9/17	Hurricane Harvey	0.0	0.0128	0.1691	0.1257
33	33	9/23/17	Hurricane Irma	0.023	0.0144	0.0066	0.0253
12	12	9/2/17	Hurricane Irma	0.0	0.0147	0.1081	0.0217
74	74	9/11/17	Hurricane Jose	0.0234	0.0161	0.0223	0.0192
32	32	9/22/17	Hurricane Irma	0.0145	0.0238	0.0499	0.0207
64	64	9/21/17	Hurricane Harvey	0.0	0.0251	0.0622	0.0212
53	53	9/10/17	Hurricane Harvey	0.0206	0.0278	0.1067	0.0
1	1	9/17/17	Hurricane Maria	0.0	0.028999999999999998	0.0079	0.0208
57	57	9/14/17	Hurricane Harvey	0.021	0.0309	0.0426	0.0077
54	54	9/11/17	Hurricane Harvey	0.0468	0.0322	0.1337	0.032
80	80	9/17/17	Hurricane Jose	0.0	0.0386	0.0237	0.0415
79	79	9/16/17	Hurricane Jose	0.0	0.0436	0.0283	0.0347
70	70	9/7/17	Hurricane Jose	0.0971	0.0467	0.0422	0.0146
65	65	9/22/17	Hurricane Harvey	0.0	0.0476	0.0427	0.0345
72	72	9/9/17	Hurricane Jose	0.2148	0.0511	0.0403	0.0887
55	55	9/12/17	Hurricane Harvey	0.0072	0.0524	0.09	0.0336
8	8	9/24/17	Hurricane Maria	0.0216	0.0676	0.0779	0.0234
26	26	9/16/17	Hurricane Irma	0.0558	0.109	0.1555	0.0902
11	11	9/1/17	Hurricane Irma	0.0	0.1109	0.0914	0.0146
50	50	9/7/17	Hurricane Harvey	0.0624	0.1134	0.2109	0.1457
36	36	8/24/17	Hurricane Harvey	0.0	0.114	0.121	0.0585
14	14	9/4/17	Hurricane Irma	0.0518	0.1166	0.1074	0.04
31	31	9/21/17	Hurricane Irma	0.0793	0.1174	0.0967	0.0283
25	25	9/15/17	Hurricane Irma	0.0418	0.1209	0.0756	0.1537
29	29	9/19/17	Hurricane Irma	0.4787	0.1374	0.0816	0.085
7	7	9/23/17	Hurricane Maria	0.39899999999999997	0.1442	0.0593	0.0674
48	48	9/5/17	Hurricane Harvey	0.0909	0.1498	0.1851	0.1223
27	27	9/17/17	Hurricane Irma	0.0281	0.1642	0.1027	0.1764
41	41	8/29/17	Hurricane Harvey	0.1885	0.1675	0.3127	0.2115
71	71	9/8/17	Hurricane Jose	0.1387	0.1679	0.0408	0.0267
51	51	9/8/17	Hurricane Harvey	0.0208	0.1746	0.2242	0.1534
30	30	9/20/17	Hurricane Irma	0.1715	0.1825	0.1747	0.1036
42	42	8/30/17	Hurricane Harvey	0.1011	0.1856	0.3229	0.2055
2	2	9/18/17	Hurricane Maria	0.2204	0.1866	0.1877	0.0473
28	28	9/18/17	Hurricane Irma	0.192	0.1866	0.1877	0.1231
46	46	9/3/17	Hurricane Harvey	0.0805	0.2093	0.2753	0.5202
47	47	9/4/17	Hurricane Harvey	0.0222	0.2331	0.3078	0.3
39	39	8/27/17	Hurricane Harvey	0.1089	0.2344	0.2734	0.2329
9	9	9/25/17	Hurricane Maria	0.0615	0.2536	0.1326	0.0583
49	49	9/6/17	Hurricane Harvey	0.0419	0.2543	0.223	0.1549
6	6	9/22/17	Hurricane Maria	0.2761	0.2778	0.1211	0.1998
40	40	8/28/17	Hurricane Harvey	0.1057	0.282	0.1554	0.2863
43	43	8/31/17	Hurricane Harvey	0.2116	0.2874	0.3308	0.2755
15	15	9/5/17	Hurricane Irma	0.3483	0.3329	0.2811	0.1583
44	44	9/1/17	Hurricane Harvey	0.1267	0.3771	0.5253	0.387
23	23	9/13/17	Hurricane Irma	0.4248	0.4102	0.203	0.174
24	24	9/14/17	Hurricane Irma	0.4412	0.41700000000000004	0.3971	0.3843
45	45	9/2/17	Hurricane Harvey	0.2444	0.491	0.7797	0.4783
3	3	9/19/17	Hurricane Maria	0.8901	0.5818	0.1779	0.2621
22	22	9/12/17	Hurricane Irma	0.6716	0.5916	0.6647	0.5033
5	5	9/21/17	Hurricane Maria	0.4756	0.6454	0.3177	0.2406
16	16	9/6/17	Hurricane Irma	1.1525	0.6921	0.5575	0.3442
21	21	9/11/17	Hurricane Irma	1.1942	0.7329	0.9287	0.7105
20	20	9/10/17	Hurricane Irma	1.4633	0.737	0.6727	0.2444
4	4	9/20/17	Hurricane Maria	0.988	0.7985	0.5387	0.4835
38	38	8/26/17	Hurricane Harvey	0.762	0.8628	1.0857	0.9577
37	37	8/25/17	Hurricane Harvey	0.3431	0.8813	0.6824	0.6498
17	17	9/7/17	Hurricane Irma	1.4428	1.0137	0.6116	0.5171
19	19	9/9/17	Hurricane Irma	1.1708	1.0285	1.208	1.2863
18	18	9/8/17	Hurricane Irma	1.3243	1.1146	0.9578	0.7001

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "puerto-rico-media/tv_hurricanes_by_network" (
"Date" TEXT,
  "Query" TEXT,
  "BBC News" REAL,
  "CNN" REAL,
  "FOX News" REAL,
  "MSNBC" REAL
)