Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20120402_230000_Erin_Burnett_OutFront#start/539/end/574	Mon Apr 02 2012 23:09:14 GMT+0000 (Coordinated Universal Time)	CNN	Erin Burnett OutFront	CNNW_20120402_230000_Erin_Burnett_OutFront	https://archive.org/download/CNNW_20120402_230000_Erin_Burnett_OutFront/CNNW_20120402_230000_Erin_Burnett_OutFront.thumbs/CNNW_20120402_230000_Erin_Burnett_OutFront_000540.jpg	getting from canada through pipelines today. and in addition to that, venezuelan oil. and in essence what susan has told you is the real reason behind the opposition to the pipeline. it's all about global warming.
https://archive.org/details/CNNW_20120401_020000_CNN_Newsroom#start/3350/end/3385	Sun Apr 01 2012 02:56:05 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120401_020000_CNN_Newsroom	https://archive.org/download/CNNW_20120401_020000_CNN_Newsroom/CNNW_20120401_020000_CNN_Newsroom.thumbs/CNNW_20120401_020000_CNN_Newsroom_000017.jpg	coast, well. it encourages homes, businesses and governments to turn off the lights for one hour to build awareness about energy use and climate change.
https://archive.org/details/CNNW_20120426_140856_CNN_Newsroom#start/1422/end/1457	Thu Apr 26 2012 14:32:53 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120426_140856_CNN_Newsroom	https://archive.org/download/CNNW_20120426_140856_CNN_Newsroom/CNNW_20120426_140856_CNN_Newsroom.thumbs/CNNW_20120426_140856_CNN_Newsroom_000024.jpg	diplomats. it may happen from time to time. it's not going to happen anymore i'm imagining. hopefully no. second question. president obama is on the cover of 'rolling stone.' he told the magazine's founder that climate change will likely
https://archive.org/details/CNNW_20120403_130000_CNN_Newsroom#start/6936/end/6971	Tue Apr 03 2012 14:55:51 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120403_130000_CNN_Newsroom	https://archive.org/download/CNNW_20120403_130000_CNN_Newsroom/CNNW_20120403_130000_CNN_Newsroom.thumbs/CNNW_20120403_130000_CNN_Newsroom_000018.jpg	this global warming is a misnomer. global climate change. colds are colder and warms are warmer. thank you, alexandra. how do you lose that record $656
https://archive.org/details/CNNW_20120426_140856_CNN_Newsroom#start/912/end/947	Thu Apr 26 2012 14:24:23 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120426_140856_CNN_Newsroom	https://archive.org/download/CNNW_20120426_140856_CNN_Newsroom/CNNW_20120426_140856_CNN_Newsroom.thumbs/CNNW_20120426_140856_CNN_Newsroom_000024.jpg	climate change in a serious way, end quote. but why the slow jam on the climate issue, mr. president? mr. obama said that with more people worried about jobs and the economy the other side has been able to pour millions of dollars into debunking climate
https://archive.org/details/CNNW_20120418_110000_Starting_Point#start/2352/end/2387	Wed Apr 18 2012 11:39:27 GMT+0000 (Coordinated Universal Time)	CNN	Starting Point	CNNW_20120418_110000_Starting_Point	https://archive.org/download/CNNW_20120418_110000_Starting_Point/CNNW_20120418_110000_Starting_Point.thumbs/CNNW_20120418_110000_Starting_Point_002340.jpg	as soon as we have the photos, we'll bring them to you. some other stories making news, christine has the headlines. warming up to climate change. a significant majority of americans now believe global warming contributed to our
https://archive.org/details/CNNW_20120426_140856_CNN_Newsroom#start/957/end/992	Thu Apr 26 2012 14:25:08 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120426_140856_CNN_Newsroom	https://archive.org/download/CNNW_20120426_140856_CNN_Newsroom/CNNW_20120426_140856_CNN_Newsroom.thumbs/CNNW_20120426_140856_CNN_Newsroom_000024.jpg	pipeline. environmentalists oppose it in part because they say the use of more fossil fuels adds to global warming, but still, the president hasn't talked much about the climate change part. is it because republicans keep talking about the much-needed jobs the pipeline would create,
https://archive.org/details/CNNW_20120426_140856_CNN_Newsroom#start/3047/end/3082	Thu Apr 26 2012 14:59:58 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120426_140856_CNN_Newsroom	https://archive.org/download/CNNW_20120426_140856_CNN_Newsroom/CNNW_20120426_140856_CNN_Newsroom.thumbs/CNNW_20120426_140856_CNN_Newsroom_000024.jpg	perhaps there may be something to this climate change nonsense. this from
https://archive.org/details/CNNW_20120422_230000_CNN_Newsroom#start/1145/end/1180	Sun Apr 22 2012 23:19:20 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120422_230000_CNN_Newsroom	https://archive.org/download/CNNW_20120422_230000_CNN_Newsroom/CNNW_20120422_230000_CNN_Newsroom.thumbs/CNNW_20120422_230000_CNN_Newsroom_001140.jpg	citizens united decision? where is he on all of this? i don't think he's changed his mind on any of it? does he still believe in climate
https://archive.org/details/CNNW_20120426_140856_CNN_Newsroom#start/941/end/976	Thu Apr 26 2012 14:24:52 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom	CNNW_20120426_140856_CNN_Newsroom	https://archive.org/download/CNNW_20120426_140856_CNN_Newsroom/CNNW_20120426_140856_CNN_Newsroom.thumbs/CNNW_20120426_140856_CNN_Newsroom_000024.jpg	what's causing climate change on this planet, and the idea of spending trillions and trillions of dollars to try to reduce co2 emissions is not the right course for us. of course, the lightning rod in the climate change debate this year is the keystone


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