Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20130718_000000_All_In_With_Chris_Hayes#start/1838/end/1873	Thu Jul 18 2013 00:30:53 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20130718_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20130718_000000_All_In_With_Chris_Hayes/MSNBCW_20130718_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20130718_000000_All_In_With_Chris_Hayes_001816.jpg	argue her point of view, she boils up a stew of the most fear mongering propaganda. she's in the global warming iis
https://archive.org/details/MSNBCW_20130705_110000_Morning_Joe#start/1229/end/1264	Fri Jul 05 2013 11:20:44 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20130705_110000_Morning_Joe	https://archive.org/download/MSNBCW_20130705_110000_Morning_Joe/MSNBCW_20130705_110000_Morning_Joe.thumbs/MSNBCW_20130705_110000_Morning_Joe_001215.jpg	into the main narrative. i don't think if you're an african-american you find him uninspiri uninspiring. his numbers in that community are about 90%. we're talking about oratory here though. but that second inaugural may be seen as a big one. his speeches on climate change
https://archive.org/details/MSNBCW_20130711_030000_All_In_With_Chris_Hayes#start/2755/end/2790	Thu Jul 11 2013 03:46:10 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20130711_030000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20130711_030000_All_In_With_Chris_Hayes/MSNBCW_20130711_030000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20130711_030000_All_In_With_Chris_Hayes_002746.jpg	pollutants, including greenhouse gases. what we're seeing here is the shale revolution is leading to congested rail lines to move oil to fuel cars in uncongested
https://archive.org/details/MSNBCW_20130711_070000_All_In_With_Chris_Hayes#start/2754/end/2789	Thu Jul 11 2013 07:46:09 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20130711_070000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20130711_070000_All_In_With_Chris_Hayes/MSNBCW_20130711_070000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20130711_070000_All_In_With_Chris_Hayes_002745.jpg	being flaired off, it's being burned off at the well head which is a major issue for emissions of all sorts of pollutants, including greenhouse gases. what we're seeing here is the
https://archive.org/details/MSNBCW_20130711_000000_All_In_With_Chris_Hayes#start/2777/end/2812	Thu Jul 11 2013 00:46:32 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20130711_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20130711_000000_All_In_With_Chris_Hayes/MSNBCW_20130711_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20130711_000000_All_In_With_Chris_Hayes_002776.jpg	burned off at the well head which is a major issue for emissions of all sorts of pollutants, including greenhouse gases. what we're seeing here is the shale revolution is leading to
https://archive.org/details/MSNBCW_20130706_120000_Up_WSteve_Kornacki#start/4687/end/4722	Sat Jul 06 2013 13:18:22 GMT+0000 (Coordinated Universal Time)	MSNBC	Up WSteve Kornacki	MSNBCW_20130706_120000_Up_WSteve_Kornacki	https://archive.org/download/MSNBCW_20130706_120000_Up_WSteve_Kornacki/MSNBCW_20130706_120000_Up_WSteve_Kornacki.thumbs/MSNBCW_20130706_120000_Up_WSteve_Kornacki_004666.jpg	tough issue because it's expensive and it's hard to get people onboard with paying more for energy and things like that. so, i think that having a victory, democratic victory in kentucky would be easier for people who want to see climate
https://archive.org/details/MSNBCW_20130725_010000_The_Rachel_Maddow_Show#start/2892/end/2927	Thu Jul 25 2013 01:48:27 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBCW_20130725_010000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBCW_20130725_010000_The_Rachel_Maddow_Show/MSNBCW_20130725_010000_The_Rachel_Maddow_Show.thumbs/MSNBCW_20130725_010000_The_Rachel_Maddow_Show_002895.jpg	house that were warned to force -- when the shutdown occurred and the polls went south on them, there was enough would beabliness there to pull them back. the hope is, can you replicate something like that. in terms of policy, climate
https://archive.org/details/MSNBCW_20130701_230000_Hardball_With_Chris_Matthews#start/1110/end/1145	Mon Jul 01 2013 23:18:45 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20130701_230000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20130701_230000_Hardball_With_Chris_Matthews/MSNBCW_20130701_230000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20130701_230000_Hardball_With_Chris_Matthews_001066.jpg	when you think about youth appeal in politics, the first thing that pops into mind isn't usually the republican party. there is something about a party that officially supports even now a constitutional ban on all gay marriage and still has national candidates who deny there is such a thing as clima…
https://archive.org/details/MSNBCW_20130724_170000_Andrea_Mitchell_Reports#start/2155/end/2190	Wed Jul 24 2013 17:36:10 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBCW_20130724_170000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBCW_20130724_170000_Andrea_Mitchell_Reports/MSNBCW_20130724_170000_Andrea_Mitchell_Reports.thumbs/MSNBCW_20130724_170000_Andrea_Mitchell_Reports_002145.jpg	we need to combat climate change and stand up for women's rights. [ applause ] so, all those issues are
https://archive.org/details/MSNBCW_20130701_100000_Morning_Joe#start/5441/end/5476	Mon Jul 01 2013 11:30:56 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20130701_100000_Morning_Joe	https://archive.org/download/MSNBCW_20130701_100000_Morning_Joe/MSNBCW_20130701_100000_Morning_Joe.thumbs/MSNBCW_20130701_100000_Morning_Joe_005416.jpg	for the climate change issue and to get some significant, if not comprehensive, things done. if you add all that up, it's not a terrible presidency. but, you know, we've reached


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