Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNN_20090709_130000_CNN_Newsroom#start/373/end/408	Thu Jul 09 2009 13:06:28 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNN_20090709_130000_CNN_Newsroom	https://archive.org/download/CNN_20090709_130000_CNN_Newsroom/CNN_20090709_130000_CNN_Newsroom.thumbs/CNN_20090709_130000_CNN_Newsroom_000356.jpg	crisis like the one that's taken place will never happen again. reporter: the president is also trying to move aggressively to deal with another potential crisis, climate change. he helped lead the group to support a reduction in greenhouse gas emissions among
https://archive.org/details/CNN_20090708_200000_The_Situation_Room_With_Wolf_Blitzer#start/9775/end/9810	Wed Jul 08 2009 22:43:10 GMT+0000 (Coordinated Universal Time)	CNN	The Situation Room With Wolf Blitzer	CNN_20090708_200000_The_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNN_20090708_200000_The_Situation_Room_With_Wolf_Blitzer/CNN_20090708_200000_The_Situation_Room_With_Wolf_Blitzer.thumbs/CNN_20090708_200000_The_Situation_Room_With_Wolf_Blitzer_009775.jpg	issues? well, wolf, he went to this summit with questions on climate change. a much stronger position than america has been in before because he passed that bill to address the global warming.
https://archive.org/details/CNN_20090709_200000_The_Situation_Room_With_Wolf_Blitzer#start/130/end/165	Thu Jul 09 2009 20:02:25 GMT+0000 (Coordinated Universal Time)	CNN	The Situation Room With Wolf Blitzer	CNN_20090709_200000_The_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNN_20090709_200000_The_Situation_Room_With_Wolf_Blitzer/CNN_20090709_200000_The_Situation_Room_With_Wolf_Blitzer.thumbs/CNN_20090709_200000_The_Situation_Room_With_Wolf_Blitzer_000116.jpg	climate change. reporter: the world leaders watered down the group statement committed to tackling global warming. just the day before the u.s. and other g-8 leaders signed on to the goal of cutting greenhouse gas emissions by 80% by 2050. but today joined by leaders from
https://archive.org/details/CNN_20090729_200000_The_Situation_Room_With_Wolf_Blitzer#start/7795/end/7830	Wed Jul 29 2009 22:10:10 GMT+0000 (Coordinated Universal Time)	CNN	The Situation Room With Wolf Blitzer	CNN_20090729_200000_The_Situation_Room_With_Wolf_Blitzer	https://archive.org/download/CNN_20090729_200000_The_Situation_Room_With_Wolf_Blitzer/CNN_20090729_200000_The_Situation_Room_With_Wolf_Blitzer.thumbs/CNN_20090729_200000_The_Situation_Room_With_Wolf_Blitzer_007770.jpg	now for the cafferty file. wolf, global warming has become a religion among the first world urban elites. now, that's just one explosive charge made by australian geologist ian climber who says that manmade global warming is
https://archive.org/details/CNN_20090712_150000_State_of_the_Union_With_John_King#start/579/end/614	Sun Jul 12 2009 15:09:54 GMT+0000 (Coordinated Universal Time)	CNN	State of the Union With John King	CNN_20090712_150000_State_of_the_Union_With_John_King	https://archive.org/download/CNN_20090712_150000_State_of_the_Union_With_John_King/CNN_20090712_150000_State_of_the_Union_With_John_King.thumbs/CNN_20090712_150000_State_of_the_Union_With_John_King_000570.jpg	gathers, the lawyers who render the opinion, it is criminalization of political and every time i come back to the timing. every time they get in trouble, which the president's poll numbers are slipping and his health care and global warming
https://archive.org/details/CNN_20090709_150000_CNN_Newsroom#start/4131/end/4166	Thu Jul 09 2009 16:09:06 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNN_20090709_150000_CNN_Newsroom	https://archive.org/download/CNN_20090709_150000_CNN_Newsroom/CNN_20090709_150000_CNN_Newsroom.thumbs/CNN_20090709_150000_CNN_Newsroom_004104.jpg	your comments. josh levs will be back to help us do just that. president obama, monitoring the health care debate and other issues from overseas right now. he's with other world leaders at the g-8 summit in italy. they've been tackling global warming issues today.
https://archive.org/details/CNN_20090708_100000_American_Morning#start/7366/end/7401	Wed Jul 08 2009 12:03:01 GMT+0000 (Coordinated Universal Time)	CNN	American Morning	CNN_20090708_100000_American_Morning	https://archive.org/download/CNN_20090708_100000_American_Morning/CNN_20090708_100000_American_Morning.thumbs/CNN_20090708_100000_American_Morning_007350.jpg	south korean officials say their government and private websites were also hit and that the attacks may be connected. turning to the most politics in the morning now, an ambitious agenda awaiting president obama at the g-8 summit in italy. the president will tackle a number of pressing issues, inclu…
https://archive.org/details/CNN_20090718_140000_CNN_Newsroom#start/732/end/767	Sat Jul 18 2009 14:12:27 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNN_20090718_140000_CNN_Newsroom	https://archive.org/download/CNN_20090718_140000_CNN_Newsroom/CNN_20090718_140000_CNN_Newsroom.thumbs/CNN_20090718_140000_CNN_Newsroom_000715.jpg	mumbai and one in delhi, in the capital. after that she traveled to bangkok and then a meeting of the association of southeast asian nations. clinton is talking about climate change and nonproliferation.
https://archive.org/details/CNN_20090710_050000_Anderson_Cooper_360#start/2599/end/2634	Fri Jul 10 2009 05:43:34 GMT+0000 (Coordinated Universal Time)	CNN	Anderson Cooper 360	CNN_20090710_050000_Anderson_Cooper_360	https://archive.org/download/CNN_20090710_050000_Anderson_Cooper_360/CNN_20090710_050000_Anderson_Cooper_360.thumbs/CNN_20090710_050000_Anderson_Cooper_360_002576.jpg	made important strides in combating climate change. critics were quick to point out the meeting didn't produce specific targets for reducing greenhouse gas emissions. today mr. obama will meet with
https://archive.org/details/CNN_20090728_020000_Anderson_Cooper_360#start/1700/end/1735	Tue Jul 28 2009 02:28:35 GMT+0000 (Coordinated Universal Time)	CNN	Anderson Cooper 360	CNN_20090728_020000_Anderson_Cooper_360	https://archive.org/download/CNN_20090728_020000_Anderson_Cooper_360/CNN_20090728_020000_Anderson_Cooper_360.thumbs/CNN_20090728_020000_Anderson_Cooper_360_001675.jpg	and chinese officials began in washington today. president obama, hillary clinton and tim geithner addressing the opening session of the two-day meeting. the talks will cover the global financial crisis, climate change, nuclear proliferation


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