Puerto Rico Media: mediacloud_top_online_news.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

49 rows

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	name	url
1	1	al.com	http://www.al.com
2	2	bleacherreport.com	http://bleacherreport.com
3	3	Business Insider	http://www.businessinsider.com
4	4	Buzzfeed	http://www.buzzfeed.com
5	5	cbs news	http://www.cbsnews.com/
6	6	Chicago Tribune	http://www.chicagotribune.com/
7	7	CNET	http://cnet.com
8	8	CNN	http://www.cnn.com/
9	9	Daily Mail	http://www.dailymail.co.uk/home/index.html
10	10	Daily News	http://www.nydailynews.com/
11	11	Daily Telegraph	http://www.telegraph.co.uk/
12	12	Dallas Morning News	http://www.dallasnews.com/
13	13	elitedaily.com	http://elitedaily.com/#spider
14	14	Engadget	http://engadget.com
15	15	Examiner.com	http://examiner.com
16	16	foxnews.com	http://foxnews.com/
17	17	freep.com	http://www.freep.com
18	18	Gawker	http://gawker.com
19	19	Guardian	http://www.guardian.co.uk/
20	20	houstonchronicle	http://www.chron.com/
21	21	Huffington Post	http://www.huffingtonpost.com/#
22	22	Independent	http://www.independent.co.uk/
23	23	LA Times	http://www.latimes.com/
24	24	Mashable!	http://mashable.com
25	25	Mic	http://mic.com/
26	26	mlive.com	http://mlive.com/
27	27	MSNBC	http://www.msnbc.msn.com/
28	28	NBC News	http://www.nbcnews.com
29	29	New York Times	http://nytimes.com
30	30	nj.com	http://www.nj.com
31	31	NPR	http://www.npr.org/
32	32	NY Post	http://www.nypost.com/
33	33	Salon	http://www.salon.com/
34	34	sfchronicle	http://www.sfgate.com/
35	35	slate.com	http://www.slate.com
36	36	TechCrunch	http://techcrunch.com
37	37	The Atlantic	http://www.theatlantic.com/
38	38	The Blaze	http://www.theblaze.com
39	39	The Boston Globe	http://www.boston.com/bostonglobe/
40	40	The Daily Beast	http://www.thedailybeast.com/
41	41	themirror	http://www.mirror.co.uk/
42	42	Time	http://time.com
43	43	upworthy.com	http://www.upworthy.com
44	44	US News & World Report	http://www.usnews.com/
45	45	USAToday	http://usatoday.com/
46	46	Vice	http://m.vice.com
47	47	Vox	http://www.vox.com
48	48	Washington Post	http://washingtonpost.com
49	49	Yahoo News	http://news.yahoo.com/

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "puerto-rico-media/mediacloud_top_online_news" (
"name" TEXT,
  "url" TEXT
);