Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20191230_140000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto#start/3228/end/3263	Mon Dec 30 2019 14:54:03 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom with Poppy Harlow and Jim Sciutto	CNNW_20191230_140000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto	https://archive.org/download/CNNW_20191230_140000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto/CNNW_20191230_140000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto.thumbs/CNNW_20191230_140000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto_003207.jpg	into mozambique in march, will become more powerful and more frequent. extreme events punishing countries that did little to cause climate change. we should realize that if we look at the historical responsibility for the problem of global warming, the entire
https://archive.org/details/CNNW_20191210_060000_Cuomo_Prime_Time#start/2398/end/2433	Tue Dec 10 2019 06:40:13 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191210_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191210_060000_Cuomo_Prime_Time/CNNW_20191210_060000_Cuomo_Prime_Time.thumbs/CNNW_20191210_060000_Cuomo_Prime_Time_002397.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191210_060000_Cuomo_Prime_Time#start/3399/end/3434	Tue Dec 10 2019 06:56:54 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191210_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191210_060000_Cuomo_Prime_Time/CNNW_20191210_060000_Cuomo_Prime_Time.thumbs/CNNW_20191210_060000_Cuomo_Prime_Time_003387.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191204_120000_New_Day_With_Alisyn_Camerota_and_John_Berman#start/904/end/939	Wed Dec 04 2019 12:15:19 GMT+0000 (Coordinated Universal Time)	CNN	New Day With Alisyn Camerota and John Berman	CNNW_20191204_120000_New_Day_With_Alisyn_Camerota_and_John_Berman	https://archive.org/download/CNNW_20191204_120000_New_Day_With_Alisyn_Camerota_and_John_Berman/CNNW_20191204_120000_New_Day_With_Alisyn_Camerota_and_John_Berman.thumbs/CNNW_20191204_120000_New_Day_With_Alisyn_Camerota_and_John_Berman_000900.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191214_090000_CNN_Newsroom_Live#start/3230/end/3265	Sat Dec 14 2019 09:54:05 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom Live	CNNW_20191214_090000_CNN_Newsroom_Live	https://archive.org/download/CNNW_20191214_090000_CNN_Newsroom_Live/CNNW_20191214_090000_CNN_Newsroom_Live.thumbs/CNNW_20191214_090000_CNN_Newsroom_Live_003207.jpg	afford and it's too much. polluters don't want to hear this or are turning away from the words. despite the signage declaring otherwise, these climate crisis
https://archive.org/details/CNNW_20191203_150000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto#start/2380/end/2415	Tue Dec 03 2019 15:39:55 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom with Poppy Harlow and Jim Sciutto	CNNW_20191203_150000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto	https://archive.org/download/CNNW_20191203_150000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto/CNNW_20191203_150000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto.thumbs/CNNW_20191203_150000_CNN_Newsroom_with_Poppy_Harlow_and_Jim_Sciutto_002368.jpg	and work together. [ speaking foreign language ] that sounded very good. [ laughter ] any questions. mr. president, climate change
https://archive.org/details/CNNW_20191210_060000_Cuomo_Prime_Time#start/873/end/908	Tue Dec 10 2019 06:14:48 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191210_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191210_060000_Cuomo_Prime_Time/CNNW_20191210_060000_Cuomo_Prime_Time.thumbs/CNNW_20191210_060000_Cuomo_Prime_Time_000868.jpg	naturally superior sleep. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191204_060000_Cuomo_Prime_Time#start/760/end/795	Wed Dec 04 2019 06:12:55 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191204_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191204_060000_Cuomo_Prime_Time/CNNW_20191204_060000_Cuomo_Prime_Time.thumbs/CNNW_20191204_060000_Cuomo_Prime_Time_000720.jpg	ask your dermatologist about skyrizi. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191211_060000_Cuomo_Prime_Time#start/2124/end/2159	Wed Dec 11 2019 06:35:39 GMT+0000 (Coordinated Universal Time)	CNN	Cuomo Prime Time	CNNW_20191211_060000_Cuomo_Prime_Time	https://archive.org/download/CNNW_20191211_060000_Cuomo_Prime_Time/CNNW_20191211_060000_Cuomo_Prime_Time.thumbs/CNNW_20191211_060000_Cuomo_Prime_Time_002098.jpg	we're reporters from the new york times. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/CNNW_20191207_110000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul#start/2171/end/2206	Sat Dec 07 2019 11:36:26 GMT+0000 (Coordinated Universal Time)	CNN	New Day Weekend With Victor Blackwell and Christi Paul	CNNW_20191207_110000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul	https://archive.org/download/CNNW_20191207_110000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul/CNNW_20191207_110000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul.thumbs/CNNW_20191207_110000_New_Day_Weekend_With_Victor_Blackwell_and_Christi_Paul_002158.jpg	climate change. researchers say global warming expose the millions to a smaller threat, as well. ticks and the illnesses they carry. cnn health reporter jacqueline howard joins us now. explain that connection to climate change and how is the


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