Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20160603_160000_MSNBC_Live#start/330/end/365	Fri Jun 03 2016 16:05:45 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live	MSNBCW_20160603_160000_MSNBC_Live	https://archive.org/download/MSNBCW_20160603_160000_MSNBC_Live/MSNBCW_20160603_160000_MSNBC_Live.thumbs/MSNBCW_20160603_160000_MSNBC_Live_000328.jpg	where the president really reign supreme is foreign policy. that's where he can move and do policies like global warming
https://archive.org/details/MSNBCW_20160629_190000_MSNBC_Live#start/1615/end/1650	Wed Jun 29 2016 19:27:10 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live	MSNBCW_20160629_190000_MSNBC_Live	https://archive.org/download/MSNBCW_20160629_190000_MSNBC_Live/MSNBCW_20160629_190000_MSNBC_Live.thumbs/MSNBCW_20160629_190000_MSNBC_Live_001588.jpg	contributed to its advancement. we would like to acknowledge the tireless efforts made towards the investment of the investment of addressing the challenges of global warming.
https://archive.org/details/MSNBCW_20160628_000000_All_In_With_Chris_Hayes#start/3128/end/3163	Tue Jun 28 2016 00:52:23 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20160628_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20160628_000000_All_In_With_Chris_Hayes/MSNBCW_20160628_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20160628_000000_All_In_With_Chris_Hayes_003117.jpg	when it comes to presidential politics and the issue of climate change, one candidate believes it's an urgent threat and defining challenge of our time and the other calls it a hoax and conco concocted by the chinese. donald trump's position on climate change is increasingly
https://archive.org/details/MSNBCW_20160628_000000_All_In_With_Chris_Hayes#start/3590/end/3625	Tue Jun 28 2016 01:00:05 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20160628_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20160628_000000_All_In_With_Chris_Hayes/MSNBCW_20160628_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20160628_000000_All_In_With_Chris_Hayes_003567.jpg	bear oh, alaska where people have relied on the ice and ocean and alaska is warming twice as fast as the rest of the country and having a catastrophic effect. barrow finds itself on the le leading edge of climate change and climate change research.
https://archive.org/details/MSNBCW_20160608_070000_The_Place_for_Politics_2016#start/640/end/675	Wed Jun 08 2016 07:10:55 GMT+0000 (Coordinated Universal Time)	MSNBC	The Place for Politics 2016	MSNBCW_20160608_070000_The_Place_for_Politics_2016	https://archive.org/download/MSNBCW_20160608_070000_The_Place_for_Politics_2016/MSNBCW_20160608_070000_The_Place_for_Politics_2016.thumbs/MSNBCW_20160608_070000_The_Place_for_Politics_2016_000627.jpg	we believe we need to make america the clean energy super power of the 21st century. [ cheers and applause ] not insist that climate change
https://archive.org/details/MSNBCW_20160626_140000_AM_Joy#start/3607/end/3642	Sun Jun 26 2016 15:00:22 GMT+0000 (Coordinated Universal Time)	MSNBC	AM Joy	MSNBCW_20160626_140000_AM_Joy	https://archive.org/download/MSNBCW_20160626_140000_AM_Joy/MSNBCW_20160626_140000_AM_Joy.thumbs/MSNBCW_20160626_140000_AM_Joy_000928.jpg	stance on the billing banks with a glass-steagall act plus an expansion of social security. sanders was not able to get planning badge in the platform opposing the tpp trade deal, also no freeze on fracking or a carbon tax to address climate
https://archive.org/details/MSNBCW_20160602_190000_MSNBC_Live#start/1371/end/1406	Thu Jun 02 2016 19:23:06 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live	MSNBCW_20160602_190000_MSNBC_Live	https://archive.org/download/MSNBCW_20160602_190000_MSNBC_Live/MSNBCW_20160602_190000_MSNBC_Live.thumbs/MSNBCW_20160602_190000_MSNBC_Live_001347.jpg	common ground when we can. that's why i worked with russia to reduce nuclear stockpiles and with china to increase pressure on north korea. it's how our diplomats negotiated the landmark agreement on climate change,
https://archive.org/details/MSNBCW_20160630_030000_All_In_With_Chris_Hayes#start/3165/end/3200	Thu Jun 30 2016 03:53:00 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20160630_030000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20160630_030000_All_In_With_Chris_Hayes/MSNBCW_20160630_030000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20160630_030000_All_In_With_Chris_Hayes_003147.jpg	on the edge of the continent, flanked by the tundra and the arctic ocean lies the northernmost city in the country, barrel, alaska. an american city 330 miles above the arctic circle and at the epicenter of climate change.
https://archive.org/details/MSNBCW_20160629_180000_MSNBC_Live#start/3543/end/3578	Wed Jun 29 2016 18:59:18 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live	MSNBCW_20160629_180000_MSNBC_Live	https://archive.org/download/MSNBCW_20160629_180000_MSNBC_Live/MSNBCW_20160629_180000_MSNBC_Live.thumbs/MSNBCW_20160629_180000_MSNBC_Live_003538.jpg	two neighbors. they are up in canada for a north american leaders summit. the final one for president obama. canada's new prime minister is host i hosting. so what are they talking about? terrorism, climate change and
https://archive.org/details/MSNBCW_20160628_030000_All_In_With_Chris_Hayes#start/3143/end/3178	Tue Jun 28 2016 03:52:38 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20160628_030000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20160628_030000_All_In_With_Chris_Hayes/MSNBCW_20160628_030000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20160628_030000_All_In_With_Chris_Hayes_003118.jpg	donald trump's position on climate change is increasingly disconnected not only from the scientific reality or political center but from the lived experiences of ordinary americans who are already dealing with its consequences. all this week we will be presenting stories how climate


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