Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20191109_120000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul#start/826/end/861	Sat Nov 09 2019 12:14:01 GMT+0000 (Coordinated Universal Time)	CNN	New Day Weekend With Victor Blackwell and Christi Paul	CNNW_20191109_120000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul	https://archive.org/download/CNNW_20191109_120000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul/CNNW_20191109_120000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul.thumbs/CNNW_20191109_120000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul_000719.jpg	democratic candidates are back on the campaign trail. senator ber any sanders holding a climate crisis campaign.
https://archive.org/details/CNNW_20191117_150000_Fareed_Zakaria_GPS#start/2959/end/2994	Sun Nov 17 2019 15:49:34 GMT+0000 (Coordinated Universal Time)	CNN	Fareed Zakaria GPS	CNNW_20191117_150000_Fareed_Zakaria_GPS	https://archive.org/download/CNNW_20191117_150000_Fareed_Zakaria_GPS/CNNW_20191117_150000_Fareed_Zakaria_GPS.thumbs/CNNW_20191117_150000_Fareed_Zakaria_GPS_002939.jpg	confident we have time is because of global warming which is real and bad and we're not taking action on it. greenhouse gases are just a form of air pollution. i don't mean just because they're not easy but they're not mysterious. we've had amazing success at
https://archive.org/details/CNNW_20191117_180000_Fareed_Zakaria_GPS#start/2995/end/3030	Sun Nov 17 2019 18:50:10 GMT+0000 (Coordinated Universal Time)	CNN	Fareed Zakaria GPS	CNNW_20191117_180000_Fareed_Zakaria_GPS	https://archive.org/download/CNNW_20191117_180000_Fareed_Zakaria_GPS/CNNW_20191117_180000_Fareed_Zakaria_GPS.thumbs/CNNW_20191117_180000_Fareed_Zakaria_GPS_002997.jpg	dematerialization, as you call it? the only reason i'm not confident we have time is because of global warming, which is real and bad and we're not taking action on it. greenhouse gases are just a form of air pollution. i don't mean just because they're easy, but they're not
https://archive.org/details/CNNW_20191106_060000_Cuomo_Prime_Time#start/2657/end/2692	Wed Nov 06 2019 06:44:32 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191106_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191106_060000_Cuomo_Prime_Time/CNNW_20191106_060000_Cuomo_Prime_Time.thumbs/CNNW_20191106_060000_Cuomo_Prime_Time_002639.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191126_120000_New_Day_With_Alisyn_Camerota_and_John_Berman#start/3188/end/3223	Tue Nov 26 2019 12:53:23 GMT+0000 (Coordinated Universal Time)	CNN	New Day With Alisyn Camerota and John Berman	CNNW_20191126_120000_New_Day_With_Alisyn_Camerota_and_John_Berman	https://archive.org/download/CNNW_20191126_120000_New_Day_With_Alisyn_Camerota_and_John_Berman/CNNW_20191126_120000_New_Day_With_Alisyn_Camerota_and_John_Berman.thumbs/CNNW_20191126_120000_New_Day_With_Alisyn_Camerota_and_John_Berman_003118.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191106_030000_CNN_Tonight_With_Don_Lemon#start/1776/end/1811	Wed Nov 06 2019 03:29:51 GMT+0000 (Coordinated Universal Time)	CNN	CNN Tonight With Don Lemon	CNNW_20191106_030000_CNN_Tonight_With_Don_Lemon	https://archive.org/download/CNNW_20191106_030000_CNN_Tonight_With_Don_Lemon/CNNW_20191106_030000_CNN_Tonight_With_Don_Lemon.thumbs/CNNW_20191106_030000_CNN_Tonight_With_Don_Lemon_001769.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191130_150000_CNN_Newsroom_With_Victor_Blackwell_and_Christi_Paul#start/3284/end/3319	Sat Nov 30 2019 15:54:59 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Victor Blackwell and Christi Paul	CNNW_20191130_150000_CNN_Newsroom_With_Victor_Blackwell_and_Christi_Paul	https://archive.org/download/CNNW_20191130_150000_CNN_Newsroom_With_Victor_Blackwell_and_Christi_Paul/CNNW_20191130_150000_CNN_Newsroom_With_Victor_Blackwell_and_Christi_Paul.thumbs/CNNW_20191130_150000_CNN_Newsroom_With_Victor_Blackwell_and_Christi_Paul_003237.jpg	move past the pain of psoriasis. protestors in the world marching for action against climate change.
https://archive.org/details/CNNW_20191113_060000_Cuomo_Prime_Time#start/3337/end/3372	Wed Nov 13 2019 06:55:52 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191113_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191113_060000_Cuomo_Prime_Time/CNNW_20191113_060000_Cuomo_Prime_Time.thumbs/CNNW_20191113_060000_Cuomo_Prime_Time_003329.jpg	and it's built 5g ready. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191127_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/496/end/531	Wed Nov 27 2019 09:08:31 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20191127_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20191127_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20191127_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20191127_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_000477.jpg	warren's ultra millionaire tax charges 2%. houses with assets over $1 billion could face a 6% tax. climate change is making
https://archive.org/details/CNNW_20191125_120000_New_Day_With_Alisyn_Camerota_and_John_Berman#start/2954/end/2989	Mon Nov 25 2019 12:49:29 GMT+0000 (Coordinated Universal Time)	CNN	New Day With Alisyn Camerota and John Berman	CNNW_20191125_120000_New_Day_With_Alisyn_Camerota_and_John_Berman	https://archive.org/download/CNNW_20191125_120000_New_Day_With_Alisyn_Camerota_and_John_Berman/CNNW_20191125_120000_New_Day_With_Alisyn_Camerota_and_John_Berman.thumbs/CNNW_20191125_120000_New_Day_With_Alisyn_Camerota_and_John_Berman_002850.jpg	right here. right now. humira. this melting pot of impacted species. everywhere is going to get touched by climate change.


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