Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20160717_000000_Dateline_Extra#start/2682/end/2717	Sun Jul 17 2016 00:44:57 GMT+0000 (Coordinated Universal Time)	MSNBC	Dateline Extra	MSNBCW_20160717_000000_Dateline_Extra	https://archive.org/download/MSNBCW_20160717_000000_Dateline_Extra/MSNBCW_20160717_000000_Dateline_Extra.thumbs/MSNBCW_20160717_000000_Dateline_Extra_001745.jpg	enough that they were willing to figure out exactly what climate change or global warming is. 17 years after the failed kyoto protocol, 195 countries sign the paris agreement. promising to limit global
https://archive.org/details/MSNBCW_20160716_100000_The_Rachel_Maddow_Show#start/2665/end/2700	Sat Jul 16 2016 10:44:40 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBCW_20160716_100000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBCW_20160716_100000_The_Rachel_Maddow_Show/MSNBCW_20160716_100000_The_Rachel_Maddow_Show.thumbs/MSNBCW_20160716_100000_The_Rachel_Maddow_Show_002637.jpg	that explained the science in a way that almost anybody could understand. what 'an inconvenient truth' did, is it got people curious enough they were willing to figure out exactly what climate change or global warming is.
https://archive.org/details/MSNBCW_20160710_060000_Dateline_Extra#start/2482/end/2517	Sun Jul 10 2016 06:41:37 GMT+0000 (Coordinated Universal Time)	MSNBC	Dateline Extra	MSNBCW_20160710_060000_Dateline_Extra	https://archive.org/download/MSNBCW_20160710_060000_Dateline_Extra/MSNBCW_20160710_060000_Dateline_Extra.thumbs/MSNBCW_20160710_060000_Dateline_Extra_002298.jpg	and a bunch of smaller issues. some of which we haven't gotten to yet and a late night tonight on fracking and carbon tax but
https://archive.org/details/MSNBCW_20160729_030000_MSNBC_-_Democratic_National_Convention#start/181/end/216	Fri Jul 29 2016 03:03:16 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC - Democratic National Convention	MSNBCW_20160729_030000_MSNBC_-_Democratic_National_Convention	https://archive.org/download/MSNBCW_20160729_030000_MSNBC_-_Democratic_National_Convention/MSNBCW_20160729_030000_MSNBC_-_Democratic_National_Convention.thumbs/MSNBCW_20160729_030000_MSNBC_-_Democratic_National_Convention_000178.jpg	and i believe in science! i believe climate change is real
https://archive.org/details/MSNBCW_20160712_150000_MSNBC_Live#start/2724/end/2759	Tue Jul 12 2016 15:45:39 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live	MSNBCW_20160712_150000_MSNBC_Live	https://archive.org/download/MSNBCW_20160712_150000_MSNBC_Live/MSNBCW_20160712_150000_MSNBC_Live.thumbs/MSNBCW_20160712_150000_MSNBC_Live_002698.jpg	school without debt. [ applause ] this election is about climate change, the greatest
https://archive.org/details/MSNBCW_20160701_000000_All_In_With_Chris_Hayes#start/3084/end/3119	Fri Jul 01 2016 00:51:39 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20160701_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20160701_000000_All_In_With_Chris_Hayes/MSNBCW_20160701_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20160701_000000_All_In_With_Chris_Hayes_003058.jpg	this week we showed you the effect of climate change on a small island in the bayous of louisiana and a remote city on the northern coast of alaska. tonight we'll take you to miami, florida. the signs of climate change are
https://archive.org/details/MSNBCW_20160727_230000_MSNBC_-_Democratic_National_Convention#start/2421/end/2456	Wed Jul 27 2016 23:40:36 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC - Democratic National Convention	MSNBCW_20160727_230000_MSNBC_-_Democratic_National_Convention	https://archive.org/download/MSNBCW_20160727_230000_MSNBC_-_Democratic_National_Convention/MSNBCW_20160727_230000_MSNBC_-_Democratic_National_Convention.thumbs/MSNBCW_20160727_230000_MSNBC_-_Democratic_National_Convention_002397.jpg	convention for 76 long and painful minutes, trump contradict a host of dark threats but never once mention the words 'climate change' or
https://archive.org/details/MSNBCW_20160709_220000_Dateline_Extra#start/2487/end/2522	Sat Jul 09 2016 22:41:42 GMT+0000 (Coordinated Universal Time)	MSNBC	Dateline Extra	MSNBCW_20160709_220000_Dateline_Extra	https://archive.org/download/MSNBCW_20160709_220000_Dateline_Extra/MSNBCW_20160709_220000_Dateline_Extra.thumbs/MSNBCW_20160709_220000_Dateline_Extra_002304.jpg	breaking up big banks he wanted. and a ban of the death penalty, something that clinton has not personally come out against. and a bunch of smaller issues. some of which we haven't gotten to yet and a late night tonight on fracking and carbon tax but
https://archive.org/details/MSNBCW_20160716_070000_Dateline_Extra#start/2673/end/2708	Sat Jul 16 2016 07:44:48 GMT+0000 (Coordinated Universal Time)	MSNBC	Dateline Extra	MSNBCW_20160716_070000_Dateline_Extra	https://archive.org/download/MSNBCW_20160716_070000_Dateline_Extra/MSNBCW_20160716_070000_Dateline_Extra.thumbs/MSNBCW_20160716_070000_Dateline_Extra_001739.jpg	figure out exactly what climate change or global warming is. 17 years after the failed kyoto protocol, 195 countries sign the paris agreement, promising to limit global warming to well below 2 degrees celsus. we are going to win this, the
https://archive.org/details/MSNBCW_20160717_000000_Dateline_Extra#start/2619/end/2654	Sun Jul 17 2016 00:43:54 GMT+0000 (Coordinated Universal Time)	MSNBC	Dateline Extra	MSNBCW_20160717_000000_Dateline_Extra	https://archive.org/download/MSNBCW_20160717_000000_Dateline_Extra/MSNBCW_20160717_000000_Dateline_Extra.thumbs/MSNBCW_20160717_000000_Dateline_Extra_001745.jpg	we rely on government in times of crisis and to protect us, and it failed. it failed a lot of people. it was shameful. since 1992, world leaders have convened every year to discuss ways to fight climate change.


CREATE TABLE msnbc_201607 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);