Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBC_20100929_080000_Countdown_With_Keith_Olbermann#start/2376/end/2411	Wed Sep 29 2010 08:39:51 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100929_080000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100929_080000_Countdown_With_Keith_Olbermann/MSNBC_20100929_080000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100929_080000_Countdown_With_Keith_Olbermann_002370.jpg	valero and tesoro, also two of the state's top polluters. they're behind an initiative on the november ballot called proposition 23, which would suspend our law to reduce greenhouse gas emissions.
https://archive.org/details/MSNBC_20100924_020000_Countdown_With_Keith_Olbermann#start/758/end/793	Fri Sep 24 2010 02:12:53 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100924_020000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100924_020000_Countdown_With_Keith_Olbermann/MSNBC_20100924_020000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100924_020000_Countdown_With_Keith_Olbermann_000750.jpg	things that you believe in, right? and things that are popular. a lot of things don't fall in that middle intersection. we should raise energy. we should raise the price of energy a tremendous amount to forestall global warming.
https://archive.org/details/MSNBC_20100901_200000_The_Dylan_Ratigan_Show#start/2533/end/2568	Wed Sep 01 2010 20:42:28 GMT+0000 (Coordinated Universal Time)	MSNBC	The Dylan Ratigan Show	MSNBC_20100901_200000_The_Dylan_Ratigan_Show	https://archive.org/download/MSNBC_20100901_200000_The_Dylan_Ratigan_Show/MSNBC_20100901_200000_The_Dylan_Ratigan_Show.thumbs/MSNBC_20100901_200000_The_Dylan_Ratigan_Show_002514.jpg	show on that network. there's no mention in any of the information and literature written by james jae lee referring to sarah palin or that show. his issues are directed to the discovery channel and how they cover global warming.
https://archive.org/details/MSNBC_20100924_080000_Countdown_With_Keith_Olbermann#start/747/end/782	Fri Sep 24 2010 08:12:42 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100924_080000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100924_080000_Countdown_With_Keith_Olbermann/MSNBC_20100924_080000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100924_080000_Countdown_With_Keith_Olbermann_000720.jpg	looking for this diagram, which is things that are good policy, things that you believe in, right? and things that are popular. a lot of things don't fall in that middle intersection. we should raise energy. we should raise the price of energy a tremendous amount to forestall global warming.
https://archive.org/details/MSNBC_20100902_100000_Morning_Joe#start/5762/end/5797	Thu Sep 02 2010 11:36:17 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBC_20100902_100000_Morning_Joe	https://archive.org/download/MSNBC_20100902_100000_Morning_Joe/MSNBC_20100902_100000_Morning_Joe.thumbs/MSNBC_20100902_100000_Morning_Joe_005751.jpg	inside. we weren't sure if the gunman was going to come up the other floors or anything. reporter: police say james lee of maryland had a history of protesting in front of the discovery channel. handing out rambling leaflets calling for more programming about global warming and animal
https://archive.org/details/MSNBC_20100909_030000_The_Rachel_Maddow_Show#start/3376/end/3411	Thu Sep 09 2010 03:56:31 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20100909_030000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20100909_030000_The_Rachel_Maddow_Show/MSNBC_20100909_030000_The_Rachel_Maddow_Show.thumbs/MSNBC_20100909_030000_The_Rachel_Maddow_Show_003354.jpg	a year ago an astroturf group sent him letters pretending to be a hispanic group of virginia and state chapters of the naacp. the letters urged perriello to vote against climate change legislation.
https://archive.org/details/MSNBC_20100914_050000_Countdown_With_Keith_Olbermann#start/3476/end/3511	Tue Sep 14 2010 05:58:11 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100914_050000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100914_050000_Countdown_With_Keith_Olbermann/MSNBC_20100914_050000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100914_050000_Countdown_With_Keith_Olbermann_003450.jpg	let's not forget this guy has held office in delaware for 30 years, probably shaken every single hand in that state. democrats will probably try to present him as having tacked to the right a bit on abortion rights, climate change
https://archive.org/details/MSNBC_20100930_030000_Countdown_With_Keith_Olbermann#start/2250/end/2285	Thu Sep 30 2010 03:37:45 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100930_030000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100930_030000_Countdown_With_Keith_Olbermann/MSNBC_20100930_030000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100930_030000_Countdown_With_Keith_Olbermann_002160.jpg	committee and the gop takes the house in november, they have the opportunity to get rid of it. in our third story, george sensenbrenner wants to keep a committee alive to show there is no such thing as climate change.
https://archive.org/details/MSNBC_20100915_130000_The_Daily_Rundown#start/2919/end/2954	Wed Sep 15 2010 13:48:54 GMT+0000 (Coordinated Universal Time)	MSNBC	The Daily Rundown	MSNBC_20100915_130000_The_Daily_Rundown	https://archive.org/download/MSNBC_20100915_130000_The_Daily_Rundown/MSNBC_20100915_130000_The_Daily_Rundown.thumbs/MSNBC_20100915_130000_The_Daily_Rundown_002910.jpg	course and had really gotten into the zeitgeist, about 85% of americans felt it was important. and the film itself was adopted as part of the curriculum in five countries around the world. and led to a number of bills and so on about climate change being
https://archive.org/details/MSNBC_20100930_000000_Countdown_With_Keith_Olbermann#start/2246/end/2281	Thu Sep 30 2010 00:37:41 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20100930_000000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20100930_000000_Countdown_With_Keith_Olbermann/MSNBC_20100930_000000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20100930_000000_Countdown_With_Keith_Olbermann_002070.jpg	go national. go like a pro. he voted against the committee's creation. his fellow republican members see no point to it. if the gop takes the house in november they'll have the opportunity to get rid of it. congressman jim sensenbrenner wants to keep a climate change


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