Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20170921_030000_CNN_Tonight_With_Don_Lemon#start/701/end/736	Thu Sep 21 2017 03:11:56 GMT+0000 (Coordinated Universal Time)	CNN	CNN Tonight With Don Lemon	CNNW_20170921_030000_CNN_Tonight_With_Don_Lemon	https://archive.org/download/CNNW_20170921_030000_CNN_Tonight_With_Don_Lemon/CNNW_20170921_030000_CNN_Tonight_With_Don_Lemon.thumbs/CNNW_20170921_030000_CNN_Tonight_With_Don_Lemon_000688.jpg	robust. i want to mention someone pushing back on this, a professor of atmospheric science at the university of washington is pushing back on the idea that the massive flooding we saw from hurricane harvey was caused by climate change or global warming.
https://archive.org/details/CNNW_20170919_030000_CNN_Tonight_With_Don_Lemon#start/1622/end/1657	Tue Sep 19 2017 03:27:17 GMT+0000 (Coordinated Universal Time)	CNN	CNN Tonight With Don Lemon	CNNW_20170919_030000_CNN_Tonight_With_Don_Lemon	https://archive.org/download/CNNW_20170919_030000_CNN_Tonight_With_Don_Lemon/CNNW_20170919_030000_CNN_Tonight_With_Don_Lemon.thumbs/CNNW_20170919_030000_CNN_Tonight_With_Don_Lemon_001618.jpg	important point, which is we have probably passed the pint of simply having a strategy which is about stopping global warming. what we need now is a strategy to mitigate -- i'm sorry, to adapt to global warming.
https://archive.org/details/CNNW_20170917_100000_New_Day_Sunday#start/1671/end/1706	Sun Sep 17 2017 10:28:06 GMT+0000 (Coordinated Universal Time)	CNN	New Day Sunday	CNNW_20170917_100000_New_Day_Sunday	https://archive.org/download/CNNW_20170917_100000_New_Day_Sunday/CNNW_20170917_100000_New_Day_Sunday.thumbs/CNNW_20170917_100000_New_Day_Sunday_001647.jpg	though he announced the u.s. would be withdrawing in june, this is a lengthy process under the terms of the paris agreement. it was something that was going to take until november of 2020. it's also important to note the u.s. sets its own goals when it comes to reducing greenhouse gas
https://archive.org/details/CNNW_20170919_110000_New_Day#start/3529/end/3564	Tue Sep 19 2017 11:59:04 GMT+0000 (Coordinated Universal Time)	CNN	New Day	CNNW_20170919_110000_New_Day	https://archive.org/download/CNNW_20170919_110000_New_Day/CNNW_20170919_110000_New_Day.thumbs/CNNW_20170919_110000_New_Day_003507.jpg	well a. few people in the white house. i guess my point is, now is no time to talk about climate change, and it's intensetive to talk about climate change and we
https://archive.org/details/CNNW_20170901_010000_Cuomo_Prime_Time#start/1331/end/1366	Fri Sep 01 2017 01:22:26 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20170901_010000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20170901_010000_Cuomo_Prime_Time/CNNW_20170901_010000_Cuomo_Prime_Time.thumbs/CNNW_20170901_010000_Cuomo_Prime_Time_001317.jpg	houston area, as i understand it, than any time that people have measured. is it related to climate change? is some of the intensity and the magnitude of this rainfall related to climate change?
https://archive.org/details/CNNW_20170913_230000_Erin_Burnett_OutFront#start/3041/end/3076	Wed Sep 13 2017 23:50:56 GMT+0000 (Coordinated Universal Time)	CNN	Erin Burnett OutFront	CNNW_20170913_230000_Erin_Burnett_OutFront	https://archive.org/download/CNNW_20170913_230000_Erin_Burnett_OutFront/CNNW_20170913_230000_Erin_Burnett_OutFront.thumbs/CNNW_20170913_230000_Erin_Burnett_OutFront_003027.jpg	storms. scientist say the reason they were so massive and devastating there will be climate change, rising temperatures increasing the intensity and impact of major storm since they feed off water. the trump administration refuses to bring climate change.
https://archive.org/details/CNNW_20170913_200000_The_Lead_With_Jake_Tapper#start/1045/end/1080	Wed Sep 13 2017 20:17:40 GMT+0000 (Coordinated Universal Time)	CNN	The Lead With Jake Tapper	CNNW_20170913_200000_The_Lead_With_Jake_Tapper	https://archive.org/download/CNNW_20170913_200000_The_Lead_With_Jake_Tapper/CNNW_20170913_200000_The_Lead_With_Jake_Tapper.thumbs/CNNW_20170913_200000_The_Lead_With_Jake_Tapper_001018.jpg	havoc that we've seen, why is fighting it or trying to learn more about a waste of money? jake, i'll be more than happy to have a longer discussion on another day about climate change, man-made climate change.
https://archive.org/details/CNNW_20170902_130000_Smerconish#start/2746/end/2781	Sat Sep 02 2017 13:46:01 GMT+0000 (Coordinated Universal Time)	CNN	Smerconish	CNNW_20170902_130000_Smerconish	https://archive.org/download/CNNW_20170902_130000_Smerconish/CNNW_20170902_130000_Smerconish.thumbs/CNNW_20170902_130000_Smerconish_002727.jpg	peter in my last segment i began a conversation about the role of climate change in hurricane harvey. and i want to put on the screen something that you wrote. for houston, the cruel irony is that the greenhouse gases that contribute to superstorms are
https://archive.org/details/CNNW_20170913_020000_CNN_Tonight_With_Don_Lemon#start/3527/end/3562	Wed Sep 13 2017 02:59:02 GMT+0000 (Coordinated Universal Time)	CNN	CNN Tonight With Don Lemon	CNNW_20170913_020000_CNN_Tonight_With_Don_Lemon	https://archive.org/download/CNNW_20170913_020000_CNN_Tonight_With_Don_Lemon/CNNW_20170913_020000_CNN_Tonight_With_Don_Lemon.thumbs/CNNW_20170913_020000_CNN_Tonight_With_Don_Lemon_003507.jpg	this is nothing but -- but boosterism for their cause based on the sufferings and the disasters of people. it is shameful. so the climate change agenda
https://archive.org/details/CNNW_20170930_230000_CNN_Newsroom_With_Ana_Cabrera#start/885/end/920	Sat Sep 30 2017 23:15:00 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Ana Cabrera	CNNW_20170930_230000_CNN_Newsroom_With_Ana_Cabrera	https://archive.org/download/CNNW_20170930_230000_CNN_Newsroom_With_Ana_Cabrera/CNNW_20170930_230000_CNN_Newsroom_With_Ana_Cabrera.thumbs/CNNW_20170930_230000_CNN_Newsroom_With_Ana_Cabrera_000867.jpg	you would be like a poster child for what this activist republican base hates. you know, you believe in global institutions. you believe in trade. you believe in climate change.


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