Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20170830_095900_New_Day#start/3449/end/3484	Wed Aug 30 2017 10:56:44 GMT+0000 (Coordinated Universal Time)	CNN	New Day	CNNW_20170830_095900_New_Day	https://archive.org/download/CNNW_20170830_095900_New_Day/CNNW_20170830_095900_New_Day.thumbs/CNNW_20170830_095900_New_Day_003448.jpg	mayor down there in lake charles, louisiana. yes, they're ridiculously resilient down there, incredible people with what they've learned to deal with as normal. it seems they're under water almost every year. the greenhouse gases we add
https://archive.org/details/CNNW_20170808_150000_At_This_Hour_With_Kate_Bolduan#start/2525/end/2560	Tue Aug 08 2017 15:42:20 GMT+0000 (Coordinated Universal Time)	CNN	At This Hour With Kate Bolduan	CNNW_20170808_150000_At_This_Hour_With_Kate_Bolduan	https://archive.org/download/CNNW_20170808_150000_At_This_Hour_With_Kate_Bolduan/CNNW_20170808_150000_At_This_Hour_With_Kate_Bolduan.thumbs/CNNW_20170808_150000_At_This_Hour_With_Kate_Bolduan_002517.jpg	i spent some of the morning going through past tweets and statements on climate change and global warming. going back to 2012, he has been outspoken as a very strong skeptic. he probably tweeted 30 times, it's cold in new york, climate
https://archive.org/details/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer#start/3450/end/3485	Tue Aug 08 2017 22:57:45 GMT+0000 (Coordinated Universal Time)	CNN	Situation Room With Wolf Blitzer	CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer.thumbs/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer_003447.jpg	questioned the science behind climate change. we've got a blizzard outside. what does the president actually believe on climate change? i have not had an opportunity to discuss that. regarding climate change,
https://archive.org/details/CNNW_20170802_010000_CNN_Town_Hall_The_Climate_Crisis_Al_Gore#start/354/end/389	Wed Aug 02 2017 01:06:09 GMT+0000 (Coordinated Universal Time)	CNN	CNN Town Hall The Climate Crisis Al Gore	CNNW_20170802_010000_CNN_Town_Hall_The_Climate_Crisis_Al_Gore	https://archive.org/download/CNNW_20170802_010000_CNN_Town_Hall_The_Climate_Crisis_Al_Gore/CNNW_20170802_010000_CNN_Town_Hall_The_Climate_Crisis_Al_Gore.thumbs/CNNW_20170802_010000_CNN_Town_Hall_The_Climate_Crisis_Al_Gore_000328.jpg	i want to show just a short preview from your new film. let's take a look. storms get stronger and more destructive. watch the water splash off the city. this is global warming.
https://archive.org/details/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer#start/3372/end/3407	Tue Aug 08 2017 22:56:27 GMT+0000 (Coordinated Universal Time)	CNN	Situation Room With Wolf Blitzer	CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer.thumbs/CNNW_20170808_220000_Situation_Room_With_Wolf_Blitzer_003357.jpg	warming planet. in the most comprehensive draft of a u.s. government report on climate change, scientists conclude record-breaking climate-related weather extremes are undoubtedly linked to climate change.
https://archive.org/details/CNNW_20170802_200000_The_Lead_With_Jake_Tapper#start/3039/end/3074	Wed Aug 02 2017 20:50:54 GMT+0000 (Coordinated Universal Time)	CNN	The Lead With Jake Tapper	CNNW_20170802_200000_The_Lead_With_Jake_Tapper	https://archive.org/download/CNNW_20170802_200000_The_Lead_With_Jake_Tapper/CNNW_20170802_200000_The_Lead_With_Jake_Tapper.thumbs/CNNW_20170802_200000_The_Lead_With_Jake_Tapper_003028.jpg	difficult weather. scientist joel clemente says science is under attack. clemente specializes in climate change policy. he spoke out about climate
https://archive.org/details/CNNW_20170808_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/2374/end/2409	Tue Aug 08 2017 09:39:49 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20170808_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20170808_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20170808_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20170808_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_002367.jpg	catastrophic. another key finding -- it is possible to attribute some extreme weather to climate change. the study by scientists from 13 federal agencies directly contradicts claims by the president and some cabinet officials who say the human contribution to climate change
https://archive.org/details/CNNW_20170806_140000_Fareed_Zakaria_GPS#start/1200/end/1235	Sun Aug 06 2017 14:20:15 GMT+0000 (Coordinated Universal Time)	CNN	Fareed Zakaria GPS	CNNW_20170806_140000_Fareed_Zakaria_GPS	https://archive.org/download/CNNW_20170806_140000_Fareed_Zakaria_GPS/CNNW_20170806_140000_Fareed_Zakaria_GPS.thumbs/CNNW_20170806_140000_Fareed_Zakaria_GPS_001198.jpg	and from my point of view, the worst of it is that it's producing constant distractions from the big tasks that we have before us. and of course the biggest of all is solving the climate crisis.
https://archive.org/details/CNNW_20170808_180000_CNN_Newsroom_With_Brooke_Baldwin#start/1506/end/1541	Tue Aug 08 2017 18:25:21 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Brooke Baldwin	CNNW_20170808_180000_CNN_Newsroom_With_Brooke_Baldwin	https://archive.org/download/CNNW_20170808_180000_CNN_Newsroom_With_Brooke_Baldwin/CNNW_20170808_180000_CNN_Newsroom_With_Brooke_Baldwin.thumbs/CNNW_20170808_180000_CNN_Newsroom_With_Brooke_Baldwin_001498.jpg	believe that climate change is real, and a threat to the united states. you know what's interesting about all the discussions we had, the focus remained on whether paris put us at a disadvantage, and in fact, it did. does the president believe today that climate change is a
https://archive.org/details/CNNW_20170815_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/378/end/413	Tue Aug 15 2017 09:06:33 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20170815_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20170815_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20170815_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20170815_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_000358.jpg	saying that no frazier will have more time to lower rip-off drug prices. corporate america quick to rebuke trump on issues, now immigration and climate change


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