Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20160416_020000_Race_for_the_White_House#start/3469/end/3504	Sat Apr 16 2016 02:58:04 GMT+0000 (Coordinated Universal Time)	CNN	Race for the White House	CNNW_20160416_020000_Race_for_the_White_House	https://archive.org/download/CNNW_20160416_020000_Race_for_the_White_House/CNNW_20160416_020000_Race_for_the_White_House.thumbs/CNNW_20160416_020000_Race_for_the_White_House_003448.jpg	those little steps are not enough. not right now. not on climate change.
https://archive.org/details/CNNW_20160414_030000_Anderson_Cooper_360#start/3107/end/3142	Thu Apr 14 2016 03:52:02 GMT+0000 (Coordinated Universal Time)	CNN	Anderson Cooper 360	CNNW_20160414_030000_Anderson_Cooper_360	https://archive.org/download/CNNW_20160414_030000_Anderson_Cooper_360/CNNW_20160414_030000_Anderson_Cooper_360.thumbs/CNNW_20160414_030000_Anderson_Cooper_360_003088.jpg	more careful delineation of the dlirc differences between them, like fracking, like wall street, climate change.
https://archive.org/details/CNNW_20160423_080000_CNN_Newsroom_Live#start/1384/end/1419	Sat Apr 23 2016 08:23:19 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom Live	CNNW_20160423_080000_CNN_Newsroom_Live	https://archive.org/download/CNNW_20160423_080000_CNN_Newsroom_Live/CNNW_20160423_080000_CNN_Newsroom_Live.thumbs/CNNW_20160423_080000_CNN_Newsroom_Live_001377.jpg	events with climate change. something that we've seen a 50% increase in disaster, weather disaster, since 1985 to 1995 decade. so they're on the increase. and we start to see that human imprint with climate change
https://archive.org/details/CNNW_20160423_080000_CNN_Newsroom_Live#start/1102/end/1137	Sat Apr 23 2016 08:18:37 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom Live	CNNW_20160423_080000_CNN_Newsroom_Live	https://archive.org/download/CNNW_20160423_080000_CNN_Newsroom_Live/CNNW_20160423_080000_CNN_Newsroom_Live.thumbs/CNNW_20160423_080000_CNN_Newsroom_Live_001077.jpg	chances. erin mclaughlin, cnn. brulss. two of the world's biggest polluters the united states and china are promising to formally adopt an historic climate change
https://archive.org/details/CNNW_20160415_050000_CNN_Democratic_Debate#start/3666/end/3701	Fri Apr 15 2016 06:01:21 GMT+0000 (Coordinated Universal Time)	CNN	CNN Democratic Debate	CNNW_20160415_050000_CNN_Democratic_Debate	https://archive.org/download/CNNW_20160415_050000_CNN_Democratic_Debate/CNNW_20160415_050000_CNN_Democratic_Debate.thumbs/CNNW_20160415_050000_CNN_Democratic_Debate_003658.jpg	drought and floods and extreme weather disturbances. there's going to be international conflict. i am proud, wolf, that i have introduced the most comprehensive climate change
https://archive.org/details/CNNW_20160414_100000_New_Day#start/3938/end/3973	Thu Apr 14 2016 11:05:53 GMT+0000 (Coordinated Universal Time)	CNN	New Day	CNNW_20160414_100000_New_Day	https://archive.org/download/CNNW_20160414_100000_New_Day/CNNW_20160414_100000_New_Day.thumbs/CNNW_20160414_100000_New_Day_003928.jpg	that has been declining for 30 years and grotesque levels of inequality and a criminal justice system that is broken and we have climate change which
https://archive.org/details/CNNW_20160401_200000_The_Lead_With_Jake_Tapper#start/825/end/860	Fri Apr 01 2016 20:14:00 GMT+0000 (Coordinated Universal Time)	CNN	The Lead With Jake Tapper	CNNW_20160401_200000_The_Lead_With_Jake_Tapper	https://archive.org/download/CNNW_20160401_200000_The_Lead_With_Jake_Tapper/CNNW_20160401_200000_The_Lead_With_Jake_Tapper.thumbs/CNNW_20160401_200000_The_Lead_With_Jake_Tapper_000807.jpg	fronts. secretary clinton -- reporter: sanders and his supporters keeping alive their criticism of clinton receiving contributions from the oil and gas industry. this confrontation with a climate change activist going
https://archive.org/details/CNNW_20160401_210000_Situation_Room_With_Wolf_Blitzer#start/3982/end/4017	Fri Apr 01 2016 22:06:37 GMT+0000 (Coordinated Universal Time)	CNN	Situation Room With Wolf Blitzer	CNNW_20160401_210000_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNNW_20160401_210000_Situation_Room_With_Wolf_Blitzer/CNNW_20160401_210000_Situation_Room_With_Wolf_Blitzer.thumbs/CNNW_20160401_210000_Situation_Room_With_Wolf_Blitzer_003957.jpg	ramping up and expanding to new fronts. sanders and his supporters keep alive their criticism of clinton receiving contributions from the oil and gas industry. this confrontation with a climate change activist going
https://archive.org/details/CNNW_20160402_100000_New_Day_Saturday#start/959/end/994	Sat Apr 02 2016 10:16:14 GMT+0000 (Coordinated Universal Time)	CNN	New Day Saturday	CNNW_20160402_100000_New_Day_Saturday	https://archive.org/download/CNNW_20160402_100000_New_Day_Saturday/CNNW_20160402_100000_New_Day_Saturday.thumbs/CNNW_20160402_100000_New_Day_Saturday_000957.jpg	me. their democratic fight isn't winding down but ramping up. sanders and his supporters keeping alive their criticism of clinton, receiving contributions from the oil and gas industry. this with the climate change
https://archive.org/details/CNNW_20160403_160000_State_of_the_Union_With_Jake_Tapper#start/2682/end/2717	Sun Apr 03 2016 16:44:57 GMT+0000 (Coordinated Universal Time)	CNN	State of the Union With Jake Tapper	CNNW_20160403_160000_State_of_the_Union_With_Jake_Tapper	https://archive.org/download/CNNW_20160403_160000_State_of_the_Union_With_Jake_Tapper/CNNW_20160403_160000_State_of_the_Union_With_Jake_Tapper.thumbs/CNNW_20160403_160000_State_of_the_Union_With_Jake_Tapper_002668.jpg	they failed on that. in fact, we talk about the fossil fuel industry that bernie sanders has taken money from, hillary clinton, when she was secretary of state, laid the framework for this international compact to combat climate change.


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