Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20150409_210000_The_Ed_Show#start/43/end/78	Thu Apr 09 2015 21:00:58 GMT+0000 (Coordinated Universal Time)	MSNBC	The Ed Show	MSNBCW_20150409_210000_The_Ed_Show	https://archive.org/download/MSNBCW_20150409_210000_The_Ed_Show/MSNBCW_20150409_210000_The_Ed_Show.thumbs/MSNBCW_20150409_210000_The_Ed_Show_000046.jpg	shooting. what do we want? justice. i took my phone out and started recording. later a drought dilemma. water is so precious. and wisconsin's anti-climate change crusade. the climate change threat real?
https://archive.org/details/MSNBCW_20150422_220000_PoliticsNation#start/1030/end/1065	Wed Apr 22 2015 22:17:25 GMT+0000 (Coordinated Universal Time)	MSNBC	PoliticsNation	MSNBCW_20150422_220000_PoliticsNation	https://archive.org/download/MSNBCW_20150422_220000_PoliticsNation/MSNBCW_20150422_220000_PoliticsNation.thumbs/MSNBCW_20150422_220000_PoliticsNation_001005.jpg	donated $100000 to organizations working on climate change and global warming. and the white house tweeted out this incredible shot urging people to act on climate change. coming up president obama
https://archive.org/details/MSNBCW_20150414_220000_PoliticsNation#start/1446/end/1481	Tue Apr 14 2015 22:24:21 GMT+0000 (Coordinated Universal Time)	MSNBC	PoliticsNation	MSNBCW_20150414_220000_PoliticsNation	https://archive.org/download/MSNBCW_20150414_220000_PoliticsNation/MSNBCW_20150414_220000_PoliticsNation.thumbs/MSNBCW_20150414_220000_PoliticsNation_001426.jpg	the affordable care act. the republican will repeal it. the democrat will raise taxes on the wealthiest the republican will want to cut them. and while the democratic candidate will try to fight climate change the republicans will try to block climate change
https://archive.org/details/MSNBCW_20150410_070000_All_In_With_Chris_Hayes#start/1661/end/1696	Fri Apr 10 2015 07:27:56 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20150410_070000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20150410_070000_All_In_With_Chris_Hayes/MSNBCW_20150410_070000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20150410_070000_All_In_With_Chris_Hayes_001635.jpg	hopeful at the nra's annual meeting tomorrow. a snub that raises the question, is rand paul too extreme for the nra? we'll discuss that later in the show. plus, a wisconsin state board votes to ban any discussion sore work related to global warming.
https://archive.org/details/MSNBCW_20150422_170000_MSNBC_Live_With_Thomas_Roberts#start/1165/end/1200	Wed Apr 22 2015 17:19:40 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With Thomas Roberts	MSNBCW_20150422_170000_MSNBC_Live_With_Thomas_Roberts	https://archive.org/download/MSNBCW_20150422_170000_MSNBC_Live_With_Thomas_Roberts/MSNBCW_20150422_170000_MSNBC_Live_With_Thomas_Roberts.thumbs/MSNBCW_20150422_170000_MSNBC_Live_With_Thomas_Roberts_001156.jpg	presidential trip to the everglades. just moments ago, mr. obama arrived in miami. he is expected to talk later today about the threat of climate change to the u.s. economy. the white house says that this trip is also an effort to raise the climate change debate.
https://archive.org/details/MSNBCW_20150422_220000_PoliticsNation#start/1840/end/1875	Wed Apr 22 2015 22:30:55 GMT+0000 (Coordinated Universal Time)	MSNBC	PoliticsNation	MSNBCW_20150422_220000_PoliticsNation	https://archive.org/download/MSNBCW_20150422_220000_PoliticsNation/MSNBCW_20150422_220000_PoliticsNation.thumbs/MSNBCW_20150422_220000_PoliticsNation_001815.jpg	and 40% of them say global warming will never happen. compare to today's gop, richard nixon sounds like a flower child. well, listen i'm not going to -- i'm not qualified to debate the science over climate
https://archive.org/details/MSNBCW_20150422_230000_Hardball_With_Chris_Matthews#start/1967/end/2002	Wed Apr 22 2015 23:33:02 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20150422_230000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20150422_230000_Hardball_With_Chris_Matthews/MSNBCW_20150422_230000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20150422_230000_Hardball_With_Chris_Matthews_001966.jpg	never seen wackier weather in my life than just the last six months. it's not that it's gotten hotter and obviously. so it's not seasonal like it used to be. is that evidence to you of climate change, or is that just weather? well, i think we're all experiencing climate change.
https://archive.org/details/MSNBCW_20150407_030000_All_In_With_Chris_Hayes#start/2307/end/2342	Tue Apr 07 2015 03:38:42 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20150407_030000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20150407_030000_All_In_With_Chris_Hayes/MSNBCW_20150407_030000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20150407_030000_All_In_With_Chris_Hayes_002295.jpg	here is the thing. so far agriculture has been largely spared from rationing. how long will that last? and will california reckon with their post climate change future
https://archive.org/details/MSNBCW_20150421_000000_All_In_With_Chris_Hayes#start/1684/end/1719	Tue Apr 21 2015 00:28:19 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20150421_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20150421_000000_All_In_With_Chris_Hayes/MSNBCW_20150421_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20150421_000000_All_In_With_Chris_Hayes_001665.jpg	aside between the two positions impossible to run away from -- immigration and common core -- he's already done a backflip on that. a general overall notion of climate change.
https://archive.org/details/MSNBCW_20150421_070000_All_In_With_Chris_Hayes#start/1679/end/1714	Tue Apr 21 2015 07:28:14 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20150421_070000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20150421_070000_All_In_With_Chris_Hayes/MSNBCW_20150421_070000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20150421_070000_All_In_With_Chris_Hayes_001665.jpg	aside between the two positions impossible to run away from -- immigration and common core -- he's already done a backflip on that. a general overall notion of climate change.


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