Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBC_20100423_220000_The_Ed_Show#start/2534/end/2569	Fri Apr 23 2010 22:42:29 GMT+0000 (Coordinated Universal Time)	MSNBC	The Ed Show	MSNBC_20100423_220000_The_Ed_Show	https://archive.org/download/MSNBC_20100423_220000_The_Ed_Show/MSNBC_20100423_220000_The_Ed_Show.thumbs/MSNBC_20100423_220000_The_Ed_Show_002010.jpg	we talked about this at the white house with robert gibbs. there's no doubt about it. this arizona law has met means that we have leap frogged ahead of climate change and global
https://archive.org/details/MSNBC_20100403_010000_The_Rachel_Maddow_Show#start/2815/end/2850	Sat Apr 03 2010 01:47:10 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20100403_010000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20100403_010000_The_Rachel_Maddow_Show/MSNBC_20100403_010000_The_Rachel_Maddow_Show.thumbs/MSNBC_20100403_010000_The_Rachel_Maddow_Show_002816.jpg	preaching global warming found to be full of hot air. the climate change e-mails uncovered at the university of east age glee ya. one of the things on climate
https://archive.org/details/MSNBC_20100401_010000_The_Rachel_Maddow_Show#start/1549/end/1584	Thu Apr 01 2010 01:26:04 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20100401_010000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20100401_010000_The_Rachel_Maddow_Show/MSNBC_20100401_010000_The_Rachel_Maddow_Show.thumbs/MSNBC_20100401_010000_The_Rachel_Maddow_Show_001527.jpg	and they -- it basically became the beginning of a campaign that a lot of these 40 different organizations that i was talking about earlier drew on to -- then it was tobacco, today it's -- it's greenhouse gases. _
https://archive.org/details/MSNBC_20100423_000000_Countdown_With_Keith_Olbermann#start/3566/end/3601	Fri Apr 23 2010 00:59:41 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100423_000000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100423_000000_Countdown_With_Keith_Olbermann/MSNBC_20100423_000000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100423_000000_Countdown_With_Keith_Olbermann_003566.jpg	wasted at the front means lives lost. and the third reason is the one you alluded to, the climate change. the generals have come to understand that one of the biggest sources of war and strife in the future is going to be global warming causing, you
https://archive.org/details/MSNBC_20100422_220000_The_Ed_Show#start/3571/end/3606	Thu Apr 22 2010 22:59:46 GMT+0000 (Coordinated Universal Time)	MSNBC	The Ed Show	MSNBC_20100422_220000_The_Ed_Show	https://archive.org/download/MSNBC_20100422_220000_The_Ed_Show/MSNBC_20100422_220000_The_Ed_Show.thumbs/MSNBC_20100422_220000_The_Ed_Show_003567.jpg	happy to help them out, not showing the other side of the story and teaching environmental science in a way that doesn't scare children. do the parents think al gore doesn't deal in absolutes? i saw 'an inconvenient truth.' it talks about greenhouse gases
https://archive.org/details/MSNBC_20100401_030000_The_Rachel_Maddow_Show#start/1268/end/1303	Thu Apr 01 2010 03:21:23 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20100401_030000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20100401_030000_The_Rachel_Maddow_Show/MSNBC_20100401_030000_The_Rachel_Maddow_Show.thumbs/MSNBC_20100401_030000_The_Rachel_Maddow_Show_001256.jpg	pro-oil, global warming is bunk messaging. everything from praising opposition to cap and trade policies, to be afraid, be afraid, hyperventilating about an environmental protection agency, global warming power
https://archive.org/details/MSNBC_20100423_050000_Countdown_With_Keith_Olbermann#start/2294/end/2329	Fri Apr 23 2010 05:38:29 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100423_050000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100423_050000_Countdown_With_Keith_Olbermann/MSNBC_20100423_050000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100423_050000_Countdown_With_Keith_Olbermann_002277.jpg	but global warming is forecast to make unpredictable weather more frequent and more extreme. experts now say the world's 45000 large dams need to be upgraded to protect them from the effects of global warming or
https://archive.org/details/MSNBC_20100426_170000_Andrea_Mitchell_Reports#start/97/end/132	Mon Apr 26 2010 17:01:52 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBC_20100426_170000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBC_20100426_170000_Andrea_Mitchell_Reports/MSNBC_20100426_170000_Andrea_Mitchell_Reports.thumbs/MSNBC_20100426_170000_Andrea_Mitchell_Reports_000086.jpg	including poll results. meanwhile, climate change legislation is temporarily derailed by immigration reform. what now? we'll talk to senator joe lieberman, one of the authors of the climate change compromise.
https://archive.org/details/MSNBC_20100406_160000_MSNBC_News_Live#start/2132/end/2167	Tue Apr 06 2010 16:35:47 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC News Live	MSNBC_20100406_160000_MSNBC_News_Live	https://archive.org/download/MSNBC_20100406_160000_MSNBC_News_Live/MSNBC_20100406_160000_MSNBC_News_Live.thumbs/MSNBC_20100406_160000_MSNBC_News_Live_002127.jpg	problems. it is the number one producer of greenhouse gases, which are the cause of global warming. and especially in this region, where this tragedy has happened, this is the epicenter of so-called mountain top removal
https://archive.org/details/MSNBC_20100409_140000_MSNBC_News_Live#start/2623/end/2658	Fri Apr 09 2010 14:43:58 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC News Live	MSNBC_20100409_140000_MSNBC_News_Live	https://archive.org/download/MSNBC_20100409_140000_MSNBC_News_Live/MSNBC_20100409_140000_MSNBC_News_Live.thumbs/MSNBC_20100409_140000_MSNBC_News_Live_002606.jpg	of the swing votes from sandra day o'connor in the bush administration included suspension of suspected terrorist following september 11th attacks and tilt towards protecting businesses from lawsuits, its refusal to act against global warming.


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