Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20190919_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/2525/end/2560	Thu Sep 19 2019 08:42:20 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190919_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190919_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190919_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190919_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs_002518.jpg	emission standards. i can't breathe. your kids will have hours of fun enjoying the toxic tailpipe solution. i can't see you. race 'em. crash 'em. contribute to greenhouse gases.
https://archive.org/details/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall#start/1991/end/2026	Wed Sep 04 2019 22:13:26 GMT+0000 (Coordinated Universal Time)	CNN	Andrew Yang Climate Town Hall	CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall	https://archive.org/download/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall.thumbs/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall_001978.jpg	we have another question. laura cunning schram a lawyer who specializes in litigation and private practice. she works for climate change law. tackling the climate crisis
https://archive.org/details/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall#start/51/end/86	Wed Sep 04 2019 21:01:06 GMT+0000 (Coordinated Universal Time)	CNN	Julian Castro Climate Town Hall	CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall	https://archive.org/download/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall.thumbs/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall_000029.jpg	this unprecedented townn hall i dedicated to the climate crisis. an issue many voters say needs to happen now. we're seeing firsthand the effects of climate change as a
https://archive.org/details/CNNW_20190914_210000_CNN_Newsroom_With_Ana_Cabrera#start/775/end/810	Sat Sep 14 2019 21:13:10 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Ana Cabrera	CNNW_20190914_210000_CNN_Newsroom_With_Ana_Cabrera	https://archive.org/download/CNNW_20190914_210000_CNN_Newsroom_With_Ana_Cabrera/CNNW_20190914_210000_CNN_Newsroom_With_Ana_Cabrera.thumbs/CNNW_20190914_210000_CNN_Newsroom_With_Ana_Cabrera_000748.jpg	joe schmo barstool argument. and it works for his base. do you think that it would be smart for democrats to hyper focus on issues like climate change and the climate crisis or
https://archive.org/details/CNNW_20190905_024000_Beto_ORourke_Climate_Town_Hall#start/334/end/369	Thu Sep 05 2019 02:45:49 GMT+0000 (Coordinated Universal Time)	CNN	Beto ORourke Climate Town Hall	CNNW_20190905_024000_Beto_ORourke_Climate_Town_Hall	https://archive.org/download/CNNW_20190905_024000_Beto_ORourke_Climate_Town_Hall/CNNW_20190905_024000_Beto_ORourke_Climate_Town_Hall.thumbs/CNNW_20190905_024000_Beto_ORourke_Climate_Town_Hall_000328.jpg	we have legally enforceable standards every year over which no polluter can emit. get to net zero greenhouse gas emissions by 2050. earlier if we can. half way by 230. and protect the most vulnerable communities on the front lines of climate change and pollution.
https://archive.org/details/CNNW_20190905_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/3109/end/3144	Thu Sep 05 2019 08:52:04 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190905_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190905_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190905_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190905_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs_003087.jpg	about climate change in dire terms. pete buttigieg said it could be more difficult to combat the climate crisis than it was to win world war ii. beto o'rourke said that climate
https://archive.org/details/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall#start/678/end/713	Wed Sep 04 2019 21:51:33 GMT+0000 (Coordinated Universal Time)	CNN	Andrew Yang Climate Town Hall	CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall	https://archive.org/download/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall.thumbs/CNNW_20190904_214000_Andrew_Yang_Climate_Town_Hall_000658.jpg	wouldn't stand in the way of that. are you in favor of a carbon free america? i'm in favor and my plan has us getting there in the next 30 years. do you support a carbon tax and how much should it be? i do support a carbon tax the
https://archive.org/details/CNNW_20190922_170000_Fareed_Zakaria_GPS#start/1727/end/1762	Sun Sep 22 2019 17:29:02 GMT+0000 (Coordinated Universal Time)	CNN	Fareed Zakaria GPS	CNNW_20190922_170000_Fareed_Zakaria_GPS	https://archive.org/download/CNNW_20190922_170000_Fareed_Zakaria_GPS/CNNW_20190922_170000_Fareed_Zakaria_GPS.thumbs/CNNW_20190922_170000_Fareed_Zakaria_GPS_001708.jpg	starting to work seriously. central banks are including climate change risks. we see rating agencies including climate change risks.
https://archive.org/details/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall#start/20/end/55	Wed Sep 04 2019 21:00:35 GMT+0000 (Coordinated Universal Time)	CNN	Julian Castro Climate Town Hall	CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall	https://archive.org/download/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall.thumbs/CNNW_20190904_210000_Julian_Castro_Climate_Town_Hall_000029.jpg	cnn's unprecedented live town hall on the climate crisis with ten democratic presidential candidates starts right now. thanks for watching. good evening and welcome to the cnn democratic presidential town hall. on the climate crisis.
https://archive.org/details/CNNW_20190904_200000_The_Lead_With_Jake_Tapper#start/1085/end/1120	Wed Sep 04 2019 20:18:20 GMT+0000 (Coordinated Universal Time)	CNN	The Lead With Jake Tapper	CNNW_20190904_200000_The_Lead_With_Jake_Tapper	https://archive.org/download/CNNW_20190904_200000_The_Lead_With_Jake_Tapper/CNNW_20190904_200000_The_Lead_With_Jake_Tapper.thumbs/CNNW_20190904_200000_The_Lead_With_Jake_Tapper_001078.jpg	series. joining me, professor veky. thank you for joining us. i know you can't draw a specific link but what, if any, links can be drawn between our change in climate, global warming, and the


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