Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/FOXNEWSW_20160124_070000_Red_Eye#start/2164/end/2199	Sun Jan 24 2016 07:36:19 GMT+0000 (Coordinated Universal Time)	FOXNEWS	Red Eye	FOXNEWSW_20160124_070000_Red_Eye	https://archive.org/download/FOXNEWSW_20160124_070000_Red_Eye/FOXNEWSW_20160124_070000_Red_Eye.thumbs/FOXNEWSW_20160124_070000_Red_Eye_002157.jpg	yeah. i meant the ription. i meant the rings. i am curious why you believe this, but think scientists are worried about global warming. i said this before. i believe in global warming.
https://archive.org/details/FOXNEWSW_20160121_010000_The_OReilly_Factor#start/1188/end/1223	Thu Jan 21 2016 01:20:03 GMT+0000 (Coordinated Universal Time)	FOXNEWS	The OReilly Factor	FOXNEWSW_20160121_010000_The_OReilly_Factor	https://archive.org/download/FOXNEWSW_20160121_010000_The_OReilly_Factor/FOXNEWSW_20160121_010000_The_OReilly_Factor.thumbs/FOXNEWSW_20160121_010000_The_OReilly_Factor_001185.jpg	fast and furious chaos. this story may be about to explode again. later, stossel on politics and gamblers, also miller on global warming. up ahead.
https://archive.org/details/FOXNEWSW_20160101_220000_The_OReilly_Factor#start/2914/end/2949	Fri Jan 01 2016 22:48:49 GMT+0000 (Coordinated Universal Time)	FOXNEWS	The OReilly Factor	FOXNEWSW_20160101_220000_The_OReilly_Factor	https://archive.org/download/FOXNEWSW_20160101_220000_The_OReilly_Factor/FOXNEWSW_20160101_220000_The_OReilly_Factor.thumbs/FOXNEWSW_20160101_220000_The_OReilly_Factor_002895.jpg	water and food and other resources, fooden insecure women may be vulnerable to situations such as sex work. transactional sex. unquote. so we're linking global warming
https://archive.org/details/FOXNEWSW_20160130_110000_Fox_and_Friends_Saturday#start/1069/end/1104	Sat Jan 30 2016 11:18:04 GMT+0000 (Coordinated Universal Time)	FOXNEWS	Fox and Friends Saturday	FOXNEWSW_20160130_110000_Fox_and_Friends_Saturday	https://archive.org/download/FOXNEWSW_20160130_110000_Fox_and_Friends_Saturday/FOXNEWSW_20160130_110000_Fox_and_Friends_Saturday.thumbs/FOXNEWSW_20160130_110000_Fox_and_Friends_Saturday_001047.jpg	different. championed obama's amnesty and led the gang of 8. on taxes? i'm in favor of a mandate that they go[ out and design a cap and trade or carbon tax program.
https://archive.org/details/FOXNEWSW_20160107_110000_FOX__Friends#start/691/end/726	Thu Jan 07 2016 11:11:46 GMT+0000 (Coordinated Universal Time)	FOXNEWS	FOX Friends	FOXNEWSW_20160107_110000_FOX__Friends	https://archive.org/download/FOXNEWSW_20160107_110000_FOX__Friends/FOXNEWSW_20160107_110000_FOX__Friends.thumbs/FOXNEWSW_20160107_110000_FOX__Friends_000675.jpg	as far as foreign relations are concerned be when there's another year left. sure. what's our president talking about? global climate change and now gun control in this country. yeah. the report is he wants to re-emphasize climate change.
https://archive.org/details/FOXNEWSW_20160109_010000_The_OReilly_Factor#start/82/end/117	Sat Jan 09 2016 01:01:37 GMT+0000 (Coordinated Universal Time)	FOXNEWS	The OReilly Factor	FOXNEWSW_20160109_010000_The_OReilly_Factor	https://archive.org/download/FOXNEWSW_20160109_010000_The_OReilly_Factor/FOXNEWSW_20160109_010000_The_OReilly_Factor.thumbs/FOXNEWSW_20160109_010000_The_OReilly_Factor_000075.jpg	i am bill o'reilly. thanks for watching us tonight. president obama's parallel universe. that's the subject of this evening's talking points memo. economy and the terror threat posed by islamic killers. president obama apparently believes global warming and
https://archive.org/details/FOXNEWSW_20160112_090000_Special_Report_With_Bret_Baier#start/2002/end/2037	Tue Jan 12 2016 09:33:37 GMT+0000 (Coordinated Universal Time)	FOXNEWS	Special Report With Bret Baier	FOXNEWSW_20160112_090000_Special_Report_With_Bret_Baier	https://archive.org/download/FOXNEWSW_20160112_090000_Special_Report_With_Bret_Baier/FOXNEWSW_20160112_090000_Special_Report_With_Bret_Baier.thumbs/FOXNEWSW_20160112_090000_Special_Report_With_Bret_Baier_001995.jpg	new jobs second best for job creation since 1999. also on the president's checklist, renewed relation with cuba and iran nuclear deal and initiatives on climate change.
https://archive.org/details/FOXNEWSW_20160109_010000_The_OReilly_Factor#start/386/end/421	Sat Jan 09 2016 01:06:41 GMT+0000 (Coordinated Universal Time)	FOXNEWS	The OReilly Factor	FOXNEWSW_20160109_010000_The_OReilly_Factor	https://archive.org/download/FOXNEWSW_20160109_010000_The_OReilly_Factor/FOXNEWSW_20160109_010000_The_OReilly_Factor.thumbs/FOXNEWSW_20160109_010000_The_OReilly_Factor_000375.jpg	presentation to me sounded like timing is everything in life. in paris he shouldn't have talked climate change the way he did because people were concerned about the 132 people who'd just been slaughtered. that's right. so that's about timing. but that doesn't diminish in the big picture climate cha…
https://archive.org/details/FOXNEWSW_20160118_040000_Americas_Election_HQ#start/1692/end/1727	Mon Jan 18 2016 04:28:27 GMT+0000 (Coordinated Universal Time)	FOXNEWS	Americas Election HQ	FOXNEWSW_20160118_040000_Americas_Election_HQ	https://archive.org/download/FOXNEWSW_20160118_040000_Americas_Election_HQ/FOXNEWSW_20160118_040000_Americas_Election_HQ.thumbs/FOXNEWSW_20160118_040000_Americas_Election_HQ_001665.jpg	three? the top three i believe it was framed in initiatives we need to have wages go up and we need to ploy other people and recognize climate change is the
https://archive.org/details/FOXNEWSW_20160118_110000_FOX__Friends#start/4149/end/4184	Mon Jan 18 2016 12:09:24 GMT+0000 (Coordinated Universal Time)	FOXNEWS	FOX Friends	FOXNEWSW_20160118_110000_FOX__Friends	https://archive.org/download/FOXNEWSW_20160118_110000_FOX__Friends/FOXNEWSW_20160118_110000_FOX__Friends.thumbs/FOXNEWSW_20160118_110000_FOX__Friends_004125.jpg	and for the chinese in order to make u.s. manufacturing noncompetitive.' well i think climate change is just a very, very expensive form of tax. lot of people are making a lot of money. i know much about climate


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