Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann#start/58/end/93	Fri Nov 05 2010 06:01:13 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20101105_060000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann_000056.jpg	while pushing fracking. republicans planning federal investigations of what they call the global warming hoax.
https://archive.org/details/MSNBC_20101112_210000_The_Dylan_Ratigan_Show#start/2306/end/2341	Fri Nov 12 2010 21:38:41 GMT+0000 (Coordinated Universal Time)	MSNBC	The Dylan Ratigan Show	MSNBC_20101112_210000_The_Dylan_Ratigan_Show	https://archive.org/download/MSNBC_20101112_210000_The_Dylan_Ratigan_Show/MSNBC_20101112_210000_The_Dylan_Ratigan_Show.thumbs/MSNBC_20101112_210000_The_Dylan_Ratigan_Show_002304.jpg	tackling global warming because we've been trying the wrong way. maybe it's time to try a new approach. i helped organize some of the world's top climate economists, top economists, including three nobel laureates. they looked at all the ways we could tackle global warming.
https://archive.org/details/MSNBC_20101123_020000_The_Rachel_Maddow_Show#start/1444/end/1479	Tue Nov 23 2010 02:24:19 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20101123_020000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20101123_020000_The_Rachel_Maddow_Show/MSNBC_20101123_020000_The_Rachel_Maddow_Show.thumbs/MSNBC_20101123_020000_The_Rachel_Maddow_Show_001440.jpg	their future children and grandchildren. even the grandchildren. absolutely. i know you have done a lot of work on the hill around the climate change legislation that was there. first of all, with this pledge that's been signed by the house leadership, is hair any meaningful climate change
https://archive.org/details/MSNBC_20101111_070000_Countdown_With_Keith_Olbermann#start/1454/end/1489	Thu Nov 11 2010 07:24:29 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20101111_070000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20101111_070000_Countdown_With_Keith_Olbermann/MSNBC_20101111_070000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20101111_070000_Countdown_With_Keith_Olbermann_001434.jpg	for those who have both faith and belief in science and evolution and sort of the history of the planet? well, it is pretty scary that somebody would, as you see in a house hearing, say that he knows that global warming can't harm
https://archive.org/details/MSNBC_20101115_110000_Morning_Joe#start/6148/end/6183	Mon Nov 15 2010 12:42:43 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBC_20101115_110000_Morning_Joe	https://archive.org/download/MSNBC_20101115_110000_Morning_Joe/MSNBC_20101115_110000_Morning_Joe.thumbs/MSNBC_20101115_110000_Morning_Joe_006150.jpg	basically spend two years mounting a disinformation campaign about climate change and the reality of climate change, it's not surprising that when it comes around to passing a clean energy bill, which will require some kind of carbon tax, some kind of price signal, you
https://archive.org/details/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann#start/1222/end/1257	Fri Nov 05 2010 06:20:37 GMT+0000 (Coordinated Universal Time)	MSNBC	Countdown With Keith Olbermann	MSNBC_20101105_060000_Countdown_With_Keith_Olbermann	https://archive.org/download/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann.thumbs/MSNBC_20101105_060000_Countdown_With_Keith_Olbermann_001136.jpg	as easiyly as tossing off a dark cloak to reveal his true self, another one, karl rove went before an energy group and declared this. quote, climate is gone. in our fourth story, it's not enough that climate change
https://archive.org/details/MSNBC_20101123_050000_The_Rachel_Maddow_Show#start/1445/end/1480	Tue Nov 23 2010 05:24:20 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20101123_050000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20101123_050000_The_Rachel_Maddow_Show/MSNBC_20101123_050000_The_Rachel_Maddow_Show.thumbs/MSNBC_20101123_050000_The_Rachel_Maddow_Show_001440.jpg	attain a cleaner, sustainable environment for our current members and workers and also their future children and grandchildren. even the grandchildren. absolutely. i know you have done a lot of work on the hill around the climate change legislation that
https://archive.org/details/MSNBC_20101112_210000_The_Dylan_Ratigan_Show#start/2063/end/2098	Fri Nov 12 2010 21:34:38 GMT+0000 (Coordinated Universal Time)	MSNBC	The Dylan Ratigan Show	MSNBC_20101112_210000_The_Dylan_Ratigan_Show	https://archive.org/download/MSNBC_20101112_210000_The_Dylan_Ratigan_Show/MSNBC_20101112_210000_The_Dylan_Ratigan_Show.thumbs/MSNBC_20101112_210000_The_Dylan_Ratigan_Show_002064.jpg	the current approach is broken. 'cool it.' that's the title of a new doultary on climate change and its message to all global warming fear mongers out there. in the film bjorn lomborg
https://archive.org/details/MSNBC_20101103_170000_Andrea_Mitchell_Reports#start/2350/end/2385	Wed Nov 03 2010 17:39:25 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBC_20101103_170000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBC_20101103_170000_Andrea_Mitchell_Reports/MSNBC_20101103_170000_Andrea_Mitchell_Reports.thumbs/MSNBC_20101103_170000_Andrea_Mitchell_Reports_002334.jpg	greenhouse gases and seeing are there ways that we can make progress in the short-term and invest in technologies in the long-term that start giving us the tools to reduce greenhouse gases and solve this problem?
https://archive.org/details/MSNBC_20101116_110000_Morning_Joe#start/9648/end/9683	Tue Nov 16 2010 13:41:03 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBC_20101116_110000_Morning_Joe	https://archive.org/download/MSNBC_20101116_110000_Morning_Joe/MSNBC_20101116_110000_Morning_Joe.thumbs/MSNBC_20101116_110000_Morning_Joe_009630.jpg	let's get it out. do you believe in climate change? yes. global warming is real. it's manmade. it's an important problem but we are not tackling itery well. we are throwing hundreds of billions of dollars into


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