Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/BBCNEWS_20180609_230000_BBC_News#start/800/end/835	Sat Jun 09 2018 23:13:35 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20180609_230000_BBC_News	https://archive.org/download/BBCNEWS_20180609_230000_BBC_News/BBCNEWS_20180609_230000_BBC_News.thumbs/BBCNEWS_20180609_230000_BBC_News_000777.jpg	bp and equinor of norway company all sent representatives. he has long spoken about the need for urgent action on climate change. in 2015, months ahead of the paris climate conference, he published an encyclical. in it, he said that global warming
https://archive.org/details/BBCNEWS_20180613_230000_Newsday#start/28/end/63	Wed Jun 13 2018 23:00:43 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Newsday	BBCNEWS_20180613_230000_Newsday	https://archive.org/download/BBCNEWS_20180613_230000_Newsday/BBCNEWS_20180613_230000_Newsday.thumbs/BBCNEWS_20180613_230000_Newsday_000057.jpg	the main port. aid agencies are warning of a humanitarian disaster, because crucial supplies won't get through. a new study says antarctica lost 3 trillion tons of light because of global warming in the
https://archive.org/details/BBCNEWS_20180608_130000_Afternoon_Live#start/5182/end/5217	Fri Jun 08 2018 14:26:37 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20180608_130000_Afternoon_Live	https://archive.org/download/BBCNEWS_20180608_130000_Afternoon_Live/BBCNEWS_20180608_130000_Afternoon_Live.thumbs/BBCNEWS_20180608_130000_Afternoon_Live_005158.jpg	there were crocodiles back then the sides of buses, but then cybill volcanoes started to rub -- but then super volcanoes volcanoes started to rub -- but then super volcanoes started to erupt. we had global warming, but the
https://archive.org/details/BBCNEWS_20180623_143000_Click#start/1182/end/1217	Sat Jun 23 2018 14:49:57 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Click	BBCNEWS_20180623_143000_Click	https://archive.org/download/BBCNEWS_20180623_143000_Click/BBCNEWS_20180623_143000_Click.thumbs/BBCNEWS_20180623_143000_Click_001167.jpg	up with no ecosystem. the corals building that habitat are very thermally sensitive. they are some of the most climate change sensitive species on the planet. the reason they are so sensitive to climate change is
https://archive.org/details/BBCNEWS_20180624_033000_Click#start/1082/end/1117	Sun Jun 24 2018 03:48:17 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Click	BBCNEWS_20180624_033000_Click	https://archive.org/download/BBCNEWS_20180624_033000_Click/BBCNEWS_20180624_033000_Click.thumbs/BBCNEWS_20180624_033000_Click_001077.jpg	to slow down the wave. the problem is thatjust when we need coral to protect from climate change,
https://archive.org/details/BBCNEWS_20180609_140000_BBC_News#start/222/end/257	Sat Jun 09 2018 14:03:57 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20180609_140000_BBC_News	https://archive.org/download/BBCNEWS_20180609_140000_BBC_News/BBCNEWS_20180609_140000_BBC_News.thumbs/BBCNEWS_20180609_140000_BBC_News_000207.jpg	which isolates president trump from the other six nations. there are big divides over climate change, iran
https://archive.org/details/BBCNEWS_20180629_013000_Thursday_in_Parliament#start/909/end/944	Fri Jun 29 2018 01:45:24 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Thursday in Parliament	BBCNEWS_20180629_013000_Thursday_in_Parliament	https://archive.org/download/BBCNEWS_20180629_013000_Thursday_in_Parliament/BBCNEWS_20180629_013000_Thursday_in_Parliament.thumbs/BBCNEWS_20180629_013000_Thursday_in_Parliament_000898.jpg	to the committee of privileges. you're watching thursday in parliament, with me, alicia mccarthy. a parliamentary committee on climate change has told
https://archive.org/details/BBCNEWS_20180610_010000_BBC_News#start/1259/end/1294	Sun Jun 10 2018 01:21:14 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20180610_010000_BBC_News	https://archive.org/download/BBCNEWS_20180610_010000_BBC_News/BBCNEWS_20180610_010000_BBC_News.thumbs/BBCNEWS_20180610_010000_BBC_News_001258.jpg	companies including exxon mobil, bp and equinor of norway company all sent representatives. he has long spoken about the need for urgent action on climate change.
https://archive.org/details/BBCNEWS_20180625_130000_Afternoon_Live#start/7850/end/7885	Mon Jun 25 2018 15:11:05 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20180625_130000_Afternoon_Live	https://archive.org/download/BBCNEWS_20180625_130000_Afternoon_Live/BBCNEWS_20180625_130000_Afternoon_Live.thumbs/BBCNEWS_20180625_130000_Afternoon_Live_007827.jpg	pollution, bright residents of west london. she said a vote in favour of expansion today would be willingly waving the white flag to catastrophic climate change. we have
https://archive.org/details/BBCNEWS_20180610_200000_World_News_Today#start/525/end/560	Sun Jun 10 2018 20:09:00 GMT+0000 (Coordinated Universal Time)	BBCNEWS	World News Today	BBCNEWS_20180610_200000_World_News_Today	https://archive.org/download/BBCNEWS_20180610_200000_World_News_Today/BBCNEWS_20180610_200000_World_News_Today.thumbs/BBCNEWS_20180610_200000_World_News_Today_000507.jpg	actually at the centre of this debate. it is not particularly controversial. in fact, there are even, inside this agreement, agreements to disagree on agreements! on climate change, for


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