Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20170422_080000_CNN_Newsroom_Live#start/2867/end/2902	Sat Apr 22 2017 08:48:02 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom Live	CNNW_20170422_080000_CNN_Newsroom_Live	https://archive.org/download/CNNW_20170422_080000_CNN_Newsroom_Live/CNNW_20170422_080000_CNN_Newsroom_Live.thumbs/CNNW_20170422_080000_CNN_Newsroom_Live_002848.jpg	china's total needs. reporter: the plan is part of a drive across china. the country's environment minister says the cleaner technatec technology will be installed by 2020. china puts more greenhouse gases
https://archive.org/details/CNNW_20170422_090000_CNN_Newsroom_Live#start/2909/end/2944	Sat Apr 22 2017 09:48:44 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom Live	CNNW_20170422_090000_CNN_Newsroom_Live	https://archive.org/download/CNNW_20170422_090000_CNN_Newsroom_Live/CNNW_20170422_090000_CNN_Newsroom_Live.thumbs/CNNW_20170422_090000_CNN_Newsroom_Live_002907.jpg	can satisfy china's total needs. reporter: the plan is part of a drive across china. the countrys environment minister says the cleaner technology will be installed at all coal power plants nationwide by 2020. china puts more greenhouse gas
https://archive.org/details/CNNW_20170421_140000_CNN_Newsroom_With_John_Berman_and_Poppy_Harlow#start/2382/end/2417	Fri Apr 21 2017 14:39:57 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With John Berman and Poppy Harlow	CNNW_20170421_140000_CNN_Newsroom_With_John_Berman_and_Poppy_Harlow	https://archive.org/download/CNNW_20170421_140000_CNN_Newsroom_With_John_Berman_and_Poppy_Harlow/CNNW_20170421_140000_CNN_Newsroom_With_John_Berman_and_Poppy_Harlow.thumbs/CNNW_20170421_140000_CNN_Newsroom_With_John_Berman_and_Poppy_Harlow_002367.jpg	there tomorrow. despite scientific evidence of changing sea levels, climate change a hard sell in parts of louisiana. louisiana, low-lying louisiana, who have seen the results of climate change firsthand.
https://archive.org/details/CNNW_20170427_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/525/end/560	Thu Apr 27 2017 08:09:00 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20170427_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20170427_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20170427_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20170427_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs_000507.jpg	team to hash out the differences and present him with a decision. the u.s. and 143 other nations signed on to this agreement under the obama administration with the goal of limiting global warming.
https://archive.org/details/CNNW_20170422_190000_CNN_Newsroom_With_Ana_Cabrera#start/1498/end/1533	Sat Apr 22 2017 19:25:13 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Ana Cabrera	CNNW_20170422_190000_CNN_Newsroom_With_Ana_Cabrera	https://archive.org/download/CNNW_20170422_190000_CNN_Newsroom_With_Ana_Cabrera/CNNW_20170422_190000_CNN_Newsroom_With_Ana_Cabrera.thumbs/CNNW_20170422_190000_CNN_Newsroom_With_Ana_Cabrera_001497.jpg	agencies including a 31% reduction for the epa. his administration is also considering withdrawing from the paris agreement which is aimed at reducing greenhouse gases that cause climate change according to experts. and the president has already e
https://archive.org/details/CNNW_20170422_120000_New_Day_Saturday#start/382/end/417	Sat Apr 22 2017 12:06:37 GMT+0000 (Coordinated Universal Time)	CNN	New Day Saturday	CNNW_20170422_120000_New_Day_Saturday	https://archive.org/download/CNNW_20170422_120000_New_Day_Saturday/CNNW_20170422_120000_New_Day_Saturday.thumbs/CNNW_20170422_120000_New_Day_Saturday_000358.jpg	adding carbon dioxide. and i will say, much as i love the cnn, you're doing a disservice by having one climate change skeptic and not 97 or 98 scientists or engineers concerned about climate change.
https://archive.org/details/CNNW_20170430_130000_State_of_the_Union_With_Jake_Tapper#start/768/end/803	Sun Apr 30 2017 13:13:03 GMT+0000 (Coordinated Universal Time)	CNN	State of the Union With Jake Tapper	CNNW_20170430_130000_State_of_the_Union_With_Jake_Tapper	https://archive.org/download/CNNW_20170430_130000_State_of_the_Union_With_Jake_Tapper/CNNW_20170430_130000_State_of_the_Union_With_Jake_Tapper.thumbs/CNNW_20170430_130000_State_of_the_Union_With_Jake_Tapper_000747.jpg	change information from its website to quote reflect the approach of new leadership. president trump has wrongly referred to climate change as a chinese hoax. you've been a republican leader on the need combat manmade climate change.
https://archive.org/details/CNNW_20170416_140000_Fareed_Zakaria_GPS#start/1792/end/1827	Sun Apr 16 2017 14:30:07 GMT+0000 (Coordinated Universal Time)	CNN	Fareed Zakaria GPS	CNNW_20170416_140000_Fareed_Zakaria_GPS	https://archive.org/download/CNNW_20170416_140000_Fareed_Zakaria_GPS/CNNW_20170416_140000_Fareed_Zakaria_GPS.thumbs/CNNW_20170416_140000_Fareed_Zakaria_GPS_001767.jpg	problem. kargt the union of concerned scientists, the top source is the primary cause of global warming. 23% of all greenhouse gas emissions in the u.s. come from power plants that use coal.
https://archive.org/details/CNNW_20170422_150000_CNN_Newsroom_With_Fredricka_Whitfield#start/2364/end/2399	Sat Apr 22 2017 15:39:39 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Fredricka Whitfield	CNNW_20170422_150000_CNN_Newsroom_With_Fredricka_Whitfield	https://archive.org/download/CNNW_20170422_150000_CNN_Newsroom_With_Fredricka_Whitfield/CNNW_20170422_150000_CNN_Newsroom_With_Fredricka_Whitfield.thumbs/CNNW_20170422_150000_CNN_Newsroom_With_Fredricka_Whitfield_002367.jpg	reporter: climate change experts say skeptics are denying what's unfolding before their very eyes and around here, climate change is a hard sell as we quickly discovered after sitting down with cecil clark and leo datson. i just don't think climate
https://archive.org/details/CNNW_20170421_110000_New_Day#start/2857/end/2892	Fri Apr 21 2017 11:47:52 GMT+0000 (Coordinated Universal Time)	CNN	New Day	CNNW_20170421_110000_New_Day	https://archive.org/download/CNNW_20170421_110000_New_Day/CNNW_20170421_110000_New_Day.thumbs/CNNW_20170421_110000_New_Day_002847.jpg	i'm not a denier. i won't put it that way. i'm skeptical as to how much control we have. reporter: climate change


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