Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/BBCNEWS_20190327_110000_BBC_Newsroom_Live#start/4078/end/4113	Wed Mar 27 2019 12:08:13 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC Newsroom Live	BBCNEWS_20190327_110000_BBC_Newsroom_Live	https://archive.org/download/BBCNEWS_20190327_110000_BBC_Newsroom_Live/BBCNEWS_20190327_110000_BBC_Newsroom_Live.thumbs/BBCNEWS_20190327_110000_BBC_Newsroom_Live_004078.jpg	thatcher told the un general assembly that the threat from global warming needed an equivalent response from the whole world. what progress is being made on reducing greenhouse gas emissions that
https://archive.org/details/BBCNEWS_20190311_090000_BBC_News_at_9#start/1157/end/1192	Mon Mar 11 2019 09:19:32 GMT+0000 (Coordinated Universal Time)	BBCNEWS	BBC News at 9	BBCNEWS_20190311_090000_BBC_News_at_9	https://archive.org/download/BBCNEWS_20190311_090000_BBC_News_at_9/BBCNEWS_20190311_090000_BBC_News_at_9.thumbs/BBCNEWS_20190311_090000_BBC_News_at_9_001138.jpg	marshall has this report. the dairy industry produces a large amount of the gases that help to heat the atmosphere and contribute to climate change, in order to supply us with our pints of milk. a cow's digestive process emits methane, a potent greenhouse gas.
https://archive.org/details/BBCNEWS_20190311_050000_The_Briefing#start/981/end/1016	Mon Mar 11 2019 05:16:36 GMT+0000 (Coordinated Universal Time)	BBCNEWS	The Briefing	BBCNEWS_20190311_050000_The_Briefing	https://archive.org/download/BBCNEWS_20190311_050000_The_Briefing/BBCNEWS_20190311_050000_The_Briefing.thumbs/BBCNEWS_20190311_050000_The_Briefing_000958.jpg	mooing the dairy industry produces a large amount of the gases that help to heat the atmosphere and contribute to climate change in order to supply us us with our pints of milk. a cow's digestive process emits methane, a potent greenhouse gas. there's also
https://archive.org/details/BBCNEWS_20190311_100000_Victoria_Derbyshire#start/2046/end/2081	Mon Mar 11 2019 10:34:21 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Victoria Derbyshire	BBCNEWS_20190311_100000_Victoria_Derbyshire	https://archive.org/download/BBCNEWS_20190311_100000_Victoria_Derbyshire/BBCNEWS_20190311_100000_Victoria_Derbyshire.thumbs/BBCNEWS_20190311_100000_Victoria_Derbyshire_002038.jpg	it s the fourth and final week of our student challenge with a giant map of the world and different modes of transport, why? because transport is the biggest contributor to greenhouse gases. and
https://archive.org/details/BBCNEWS_20190311_100000_Victoria_Derbyshire#start/2064/end/2099	Mon Mar 11 2019 10:34:39 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Victoria Derbyshire	BBCNEWS_20190311_100000_Victoria_Derbyshire	https://archive.org/download/BBCNEWS_20190311_100000_Victoria_Derbyshire/BBCNEWS_20190311_100000_Victoria_Derbyshire.thumbs/BBCNEWS_20190311_100000_Victoria_Derbyshire_002038.jpg	one of the big things we will look at is how we can reduce our transport not just in transport notjust in the uk, but also abroad, more of us are travelling abroad than ever before. it is also about our domestic energy use. the average uk home emits eight tonnes of greenhouse gases every
https://archive.org/details/BBCNEWS_20190304_023000_The_Week_in_Parliament#start/896/end/931	Mon Mar 04 2019 02:45:11 GMT+0000 (Coordinated Universal Time)	BBCNEWS	The Week in Parliament	BBCNEWS_20190304_023000_The_Week_in_Parliament	https://archive.org/download/BBCNEWS_20190304_023000_The_Week_in_Parliament/BBCNEWS_20190304_023000_The_Week_in_Parliament.thumbs/BBCNEWS_20190304_023000_The_Week_in_Parliament_000867.jpg	above the maximum limit of 1.5%, after which the risk of droughts, floods and extreme heat increases significantly. the green mp argued climate change was here now, and she said the government's response to what she called the climate crisis was nowhere
https://archive.org/details/BBCNEWS_20190304_023000_The_Week_in_Parliament#start/927/end/962	Mon Mar 04 2019 02:45:42 GMT+0000 (Coordinated Universal Time)	BBCNEWS	The Week in Parliament	BBCNEWS_20190304_023000_The_Week_in_Parliament	https://archive.org/download/BBCNEWS_20190304_023000_The_Week_in_Parliament/BBCNEWS_20190304_023000_The_Week_in_Parliament.thumbs/BBCNEWS_20190304_023000_The_Week_in_Parliament_000928.jpg	and, on the opposition benches, while many honourable members grasp the severity of this situation, the policy proposed by some of their participants aren't good enough either. it is not possible to tackle the climate crisis and expand airports or build new runways. we cannot be tackling climate cha…
https://archive.org/details/BBCNEWS_20190315_140000_Afternoon_Live#start/1365/end/1400	Fri Mar 15 2019 14:23:00 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20190315_140000_Afternoon_Live	https://archive.org/download/BBCNEWS_20190315_140000_Afternoon_Live/BBCNEWS_20190315_140000_Afternoon_Live.thumbs/BBCNEWS_20190315_140000_Afternoon_Live_001857.jpg	to go on strike. they are inspired by swedish teenager greta thunberg, who protests weekly outside sweden's parliament. scientists say tougher measures are needed to cut global warming.
https://archive.org/details/BBCNEWS_20190315_140000_Afternoon_Live#start/490/end/525	Fri Mar 15 2019 14:08:25 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20190315_140000_Afternoon_Live	https://archive.org/download/BBCNEWS_20190315_140000_Afternoon_Live/BBCNEWS_20190315_140000_Afternoon_Live.thumbs/BBCNEWS_20190315_140000_Afternoon_Live_001857.jpg	teacher, i like to say i am still a geography teacher. geography covers this for many years. still today, people confuse the holes in the ozone layer with global warming.
https://archive.org/details/BBCNEWS_20190315_140000_Afternoon_Live#start/157/end/192	Fri Mar 15 2019 14:02:52 GMT+0000 (Coordinated Universal Time)	BBCNEWS	Afternoon Live	BBCNEWS_20190315_140000_Afternoon_Live	https://archive.org/download/BBCNEWS_20190315_140000_Afternoon_Live/BBCNEWS_20190315_140000_Afternoon_Live.thumbs/BBCNEWS_20190315_140000_Afternoon_Live_001857.jpg	against climate change. good afternoon.


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