Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20190129_170000_Andrea_Mitchell_Reports#start/2733/end/2768	Tue Jan 29 2019 17:45:48 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBCW_20190129_170000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBCW_20190129_170000_Andrea_Mitchell_Reports/MSNBCW_20190129_170000_Andrea_Mitchell_Reports.thumbs/MSNBCW_20190129_170000_Andrea_Mitchell_Reports_002728.jpg	reelect donald trump. trump only today tweeted about the subfreezing weather across midwest and said, where's the climate change when we need it, where is global warming when we
https://archive.org/details/MSNBCW_20190130_100000_First_Look#start/1057/end/1092	Wed Jan 30 2019 10:17:52 GMT+0000 (Coordinated Universal Time)	MSNBC	First Look	MSNBCW_20190130_100000_First_Look	https://archive.org/download/MSNBCW_20190130_100000_First_Look/MSNBCW_20190130_100000_First_Look.thumbs/MSNBCW_20190130_100000_First_Look_001049.jpg	even colder. what is going on with misspeeld global warming. come back fast. we feed i. that's not how climate change or
https://archive.org/details/MSNBCW_20190131_000000_Hardball_With_Chris_Matthews#start/627/end/662	Thu Jan 31 2019 00:10:42 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20190131_000000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20190131_000000_Hardball_With_Chris_Matthews/MSNBCW_20190131_000000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20190131_000000_Hardball_With_Chris_Matthews_000600.jpg	the clown that used to come can on talk shows and brag about incredible knowledge and had none. knows more about isis than generals and intel chiefs and knows more about global warming than scientists.
https://archive.org/details/MSNBCW_20190105_150000_AM_Joy#start/6095/end/6130	Sat Jan 05 2019 16:41:50 GMT+0000 (Coordinated Universal Time)	MSNBC	AM Joy	MSNBCW_20190105_150000_AM_Joy	https://archive.org/download/MSNBCW_20190105_150000_AM_Joy/MSNBCW_20190105_150000_AM_Joy.thumbs/MSNBCW_20190105_150000_AM_Joy_006087.jpg	make climate change the paramount issue in this race and will pledge to the american people that they will make it the first and foremost effort to -- to enlarge and spark the creative genius of this country to defeat climate change.
https://archive.org/details/MSNBCW_20190104_140000_MSNBC_Live_With_Stephanie_Ruhle#start/2912/end/2947	Fri Jan 04 2019 14:48:47 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With Stephanie Ruhle	MSNBCW_20190104_140000_MSNBC_Live_With_Stephanie_Ruhle	https://archive.org/download/MSNBCW_20190104_140000_MSNBC_Live_With_Stephanie_Ruhle/MSNBCW_20190104_140000_MSNBC_Live_With_Stephanie_Ruhle.thumbs/MSNBCW_20190104_140000_MSNBC_Live_With_Stephanie_Ruhle_002908.jpg	united nations special envoy for climate change and po tell chul 2020 candidate just gave st. petersburg $2.5 million to fight climate change. he says fighting global warming will come down to mayors across the country because it's their
https://archive.org/details/MSNBCW_20190103_190000_MSNBC_Live_With_Katy_Tur#start/2224/end/2259	Thu Jan 03 2019 19:37:19 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With Katy Tur	MSNBCW_20190103_190000_MSNBC_Live_With_Katy_Tur	https://archive.org/download/MSNBCW_20190103_190000_MSNBC_Live_With_Katy_Tur/MSNBCW_20190103_190000_MSNBC_Live_With_Katy_Tur.thumbs/MSNBCW_20190103_190000_MSNBC_Live_With_Katy_Tur_002217.jpg	we must face the crisis manifested in natural disasters of epic proportions. the american people understand the urgency. the people are ahead of the congress. the congress must join them. that's why we have created a committee on climate crisis.
https://archive.org/details/MSNBCW_20190112_080000_All_In_With_Chris_Hayes#start/35/end/70	Sat Jan 12 2019 08:00:50 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20190112_080000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20190112_080000_All_In_With_Chris_Hayes/MSNBCW_20190112_080000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20190112_080000_All_In_With_Chris_Hayes_000057.jpg	his policy? the republican reckoning with steve king's wall. we can't shut that office unless we build a fence or a wall. tomorrow the national security emergency might be climate change.
https://archive.org/details/MSNBCW_20190112_080000_All_In_With_Chris_Hayes#start/1910/end/1945	Sat Jan 12 2019 08:32:05 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20190112_080000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20190112_080000_All_In_With_Chris_Hayes/MSNBCW_20190112_080000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20190112_080000_All_In_With_Chris_Hayes_001887.jpg	so let's seize fossil fuel plants or something. president trump's insistence there is a crisis. has focussed people's minds on what a crisis is. there's a consensus is climate change.
https://archive.org/details/MSNBCW_20190130_000000_Hardball_With_Chris_Matthews#start/2698/end/2733	Wed Jan 30 2019 00:45:13 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20190130_000000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20190130_000000_Hardball_With_Chris_Matthews/MSNBCW_20190130_000000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20190130_000000_Hardball_With_Chris_Matthews_002699.jpg	itstructive forest fire, taking the lives of 85 people. and historic flooding following major hurricanes like florence and spite all of that, president trump, the president mocked climate change. he tweeted.
https://archive.org/details/MSNBCW_20190104_100000_First_Look#start/1962/end/1997	Fri Jan 04 2019 10:32:57 GMT+0000 (Coordinated Universal Time)	MSNBC	First Look	MSNBCW_20190104_100000_First_Look	https://archive.org/download/MSNBCW_20190104_100000_First_Look/MSNBCW_20190104_100000_First_Look.thumbs/MSNBCW_20190104_100000_First_Look_001948.jpg	dismissal in federal court. the party is taking steps to intervene in a court case where a texas judge struck down obamacare as unconstitutional. house speaker nancy pelosi addressed climate change,


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