Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/BBCNEWS_20190813_160000_BBC_News_at_Five#start/3389/end/3424	Tue Aug 13 2019 16:56:44 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News at Five	BBCNEWS_20190813_160000_BBC_News_at_Five	https://archive.org/download/BBCNEWS_20190813_160000_BBC_News_at_Five/BBCNEWS_20190813_160000_BBC_News_at_Five.thumbs/BBCNEWS_20190813_160000_BBC_News_at_Five_003387.jpg	around you that the climate crisis is a real thing. the boat's electricity is from solar panels and turbines. the emission of greenhouse gases
https://archive.org/details/BBCNEWS_20190825_133000_Focus_on_Farming#start/563/end/598	Sun Aug 25 2019 13:39:38 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Focus on Farming	BBCNEWS_20190825_133000_Focus_on_Farming	https://archive.org/download/BBCNEWS_20190825_133000_Focus_on_Farming/BBCNEWS_20190825_133000_Focus_on_Farming.thumbs/BBCNEWS_20190825_133000_Focus_on_Farming_000538.jpg	this is what happens when flood defences fail. the government says it has put aside £2 billion for climate change. agriculture is a key driver of global warming. nitrogen fertilizers can lead to emissions of nitrous oxide, a potent greenhouse gas.
https://archive.org/details/BBCNEWS_20190826_103000_Focus_on_Farming#start/481/end/516	Mon Aug 26 2019 10:38:16 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Focus on Farming	BBCNEWS_20190826_103000_Focus_on_Farming	https://archive.org/download/BBCNEWS_20190826_103000_Focus_on_Farming/BBCNEWS_20190826_103000_Focus_on_Farming.thumbs/BBCNEWS_20190826_103000_Focus_on_Farming_000477.jpg	this is what happens when flood defences fail. the government says it has put aside £2 billion for climate change. agriculture is a key driver of global warming. nitrogen fertilizers can lead to emissions of nitrous oxide - a potent greenhouse gas.
https://archive.org/details/BBCNEWS_20190806_033000_HARDtalk#start/840/end/875	Tue Aug 06 2019 03:44:15 GMT+0000 (Coordinated Universal Time)	BBCNEWS	HARDtalk	BBCNEWS_20190806_033000_HARDtalk	https://archive.org/download/BBCNEWS_20190806_033000_HARDtalk/BBCNEWS_20190806_033000_HARDtalk.thumbs/BBCNEWS_20190806_033000_HARDtalk_000839.jpg	there are some interesting remarks from zhou dadi, a member of china's national expert panel, on climate change last summer, where he said china is the number one emitter of greenhouse gases.
https://archive.org/details/BBCNEWS_20190808_220000_BBC_News#start/227/end/262	Thu Aug 08 2019 22:04:02 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20190808_220000_BBC_News	https://archive.org/download/BBCNEWS_20190808_220000_BBC_News/BBCNEWS_20190808_220000_BBC_News.thumbs/BBCNEWS_20190808_220000_BBC_News_000209.jpg	so what we choose to put on our plate helps define what the carbon footprint and the level of greenhouse gases is in the atmosphere, so that choice between broccoli and ribs on your plate actually has a real link to the level of global warming
https://archive.org/details/BBCNEWS_20190805_233000_HARDtalk#start/962/end/997	Mon Aug 05 2019 23:46:17 GMT+0000 (Coordinated Universal Time)	BBCNEWS	HARDtalk	BBCNEWS_20190805_233000_HARDtalk	https://archive.org/download/BBCNEWS_20190805_233000_HARDtalk/BBCNEWS_20190805_233000_HARDtalk.thumbs/BBCNEWS_20190805_233000_HARDtalk_000958.jpg	and show that we're actually going to lead. because when companies make pledges, particularly short-term ones, they tend to stand by them. and what about governments? there are some interesting remarks from zhou dadi, a member of china's national expert panel on climate change last summer, where he …
https://archive.org/details/BBCNEWS_20190806_040000_The_Briefing#start/1080/end/1115	Tue Aug 06 2019 04:18:15 GMT+0000 (Coordinated Universal Time)	BBCNEWS	The Briefing	BBCNEWS_20190806_040000_The_Briefing	https://archive.org/download/BBCNEWS_20190806_040000_The_Briefing/BBCNEWS_20190806_040000_The_Briefing.thumbs/BBCNEWS_20190806_040000_The_Briefing_001078.jpg	peace pact with the opposition renamo group. and this evening, the 50th session of the intergovernmental panel on climate change comes to a formal close. it's been discussing how to account for different countries greenhouse gas emissions.
https://archive.org/details/BBCNEWS_20190802_130000_Afternoon_Live#start/5147/end/5182	Fri Aug 02 2019 14:26:02 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20190802_130000_Afternoon_Live	https://archive.org/download/BBCNEWS_20190802_130000_Afternoon_Live/BBCNEWS_20190802_130000_Afternoon_Live.thumbs/BBCNEWS_20190802_130000_Afternoon_Live_005128.jpg	by the world weather attribution group shows the fingerprint of temperature change and temperatures are three degrees hotter than they would have been because of greenhouse gases.
https://archive.org/details/BBCNEWS_20190809_010000_BBC_News#start/592/end/627	Fri Aug 09 2019 01:10:07 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20190809_010000_BBC_News	https://archive.org/download/BBCNEWS_20190809_010000_BBC_News/BBCNEWS_20190809_010000_BBC_News.thumbs/BBCNEWS_20190809_010000_BBC_News_000568.jpg	this is bbc news. the latest headlines: a major un report on land use and climate change says the west's high consumption of meat and dairy produce is fuelling global warming.
https://archive.org/details/BBCNEWS_20190809_020000_BBC_News#start/866/end/901	Fri Aug 09 2019 02:14:41 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News	BBCNEWS_20190809_020000_BBC_News	https://archive.org/download/BBCNEWS_20190809_020000_BBC_News/BBCNEWS_20190809_020000_BBC_News.thumbs/BBCNEWS_20190809_020000_BBC_News_000839.jpg	this is bbc news, the latest headlines: a major un report on land use and climate change says the west's high consumption of meat and dairy produce is fuelling global warming.


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