Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/2850/end/2885	Wed Mar 27 2019 08:47:45 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs_002850.jpg	deal for climate change. but he's the only one offering up this idea in its place. this is the solution to climate change, babies. that's right. cute babies. senator lee claims climate
https://archive.org/details/CNNW_20190301_190000_CNN_Newsroom_With_Brooke_Baldwin#start/1012/end/1047	Fri Mar 01 2019 19:17:07 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Brooke Baldwin	CNNW_20190301_190000_CNN_Newsroom_With_Brooke_Baldwin	https://archive.org/download/CNNW_20190301_190000_CNN_Newsroom_With_Brooke_Baldwin/CNNW_20190301_190000_CNN_Newsroom_With_Brooke_Baldwin.thumbs/CNNW_20190301_190000_CNN_Newsroom_With_Brooke_Baldwin_000988.jpg	today. inslee says he will make combatting climate change the center of his campaign. cnn political director david chalian is with me, and david, my goodness keeping track of everyone. on the governor, climate change,
https://archive.org/details/CNNW_20190328_150000_At_This_Hour_With_Kate_Bolduan#start/1338/end/1373	Thu Mar 28 2019 15:22:33 GMT+0000 (Coordinated Universal Time)	CNN	At This Hour With Kate Bolduan	CNNW_20190328_150000_At_This_Hour_With_Kate_Bolduan	https://archive.org/download/CNNW_20190328_150000_At_This_Hour_With_Kate_Bolduan/CNNW_20190328_150000_At_This_Hour_With_Kate_Bolduan.thumbs/CNNW_20190328_150000_At_This_Hour_With_Kate_Bolduan_001319.jpg	i think he would be upset. i defer to you. a different topic, climate change, hr 9.
https://archive.org/details/CNNW_20190327_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/995/end/1030	Wed Mar 27 2019 09:16:50 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190327_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190327_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190327_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190327_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_000988.jpg	looking for a scapegoat for the economy. republican mike lee wants no part of the green deal for fight climate change change but he's the only one offering up this idea in its place. this is the real conclusion to climate change. babies.
https://archive.org/details/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/1104/end/1139	Wed Mar 27 2019 08:18:39 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190327_080000_Early_Start_with_Christine_Romans_and_Dave_Briggs_001078.jpg	issuing punishment. republican senator mike lee of utah wants no part of the green new deal to fight climate change. but he isn't the only one offering up this idea in its place. this is the real solution to climate change.
https://archive.org/details/CNNW_20190305_170000_Inside_Politics#start/3373/end/3408	Tue Mar 05 2019 17:56:28 GMT+0000 (Coordinated Universal Time)	CNN	Inside Politics	CNNW_20190305_170000_Inside_Politics	https://archive.org/download/CNNW_20190305_170000_Inside_Politics/CNNW_20190305_170000_Inside_Politics.thumbs/CNNW_20190305_170000_Inside_Politics_003209.jpg	call today for a free guide. inslee is trying to make a big impression coming out of the gate. inslee declared a climate change
https://archive.org/details/CNNW_20190308_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/2096/end/2131	Fri Mar 08 2019 09:35:11 GMT+0000 (Coordinated Universal Time)	CNN	Early Start with Christine Romans and Dave Briggs	CNNW_20190308_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs	https://archive.org/download/CNNW_20190308_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20190308_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20190308_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_002099.jpg	understand that an antisemimite will hear those words as a dog whistle. a week-long debate overshadowed all over initiati e initiatives like climate change.
https://archive.org/details/CNNW_20190327_180000_CNN_Newsroom_With_Brooke_Baldwin#start/2384/end/2419	Wed Mar 27 2019 18:39:59 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Brooke Baldwin	CNNW_20190327_180000_CNN_Newsroom_With_Brooke_Baldwin	https://archive.org/download/CNNW_20190327_180000_CNN_Newsroom_With_Brooke_Baldwin/CNNW_20190327_180000_CNN_Newsroom_With_Brooke_Baldwin.thumbs/CNNW_20190327_180000_CNN_Newsroom_With_Brooke_Baldwin_002369.jpg	took to the senate floor with props because he says he has an idea. roll it. this is the real solution to climate change. babies.
https://archive.org/details/CNNW_20190315_180000_CNN_Newsroom_With_Brooke_Baldwin#start/2583/end/2618	Fri Mar 15 2019 18:43:18 GMT+0000 (Coordinated Universal Time)	CNN	CNN Newsroom With Brooke Baldwin	CNNW_20190315_180000_CNN_Newsroom_With_Brooke_Baldwin	https://archive.org/download/CNNW_20190315_180000_CNN_Newsroom_With_Brooke_Baldwin/CNNW_20190315_180000_CNN_Newsroom_With_Brooke_Baldwin.thumbs/CNNW_20190315_180000_CNN_Newsroom_With_Brooke_Baldwin_002577.jpg	zero initiative with gorbachev in the then soviet union. the green new deal is a bit like that. we can argue about the particulars and specifics as it comes into form, but the general notion, solve the climate crisis
https://archive.org/details/CNNW_20190306_040000_CNN_Tonight_With_Don_Lemon#start/1868/end/1903	Wed Mar 06 2019 04:31:23 GMT+0000 (Coordinated Universal Time)	CNN	CNN Tonight With Don Lemon	CNNW_20190306_040000_CNN_Tonight_With_Don_Lemon	https://archive.org/download/CNNW_20190306_040000_CNN_Tonight_With_Don_Lemon/CNNW_20190306_040000_CNN_Tonight_With_Don_Lemon.thumbs/CNNW_20190306_040000_CNN_Tonight_With_Don_Lemon_001860.jpg	it seems to be slightly more populist county who's a little more left of center on the -- on the welfare state and is not highlighting climate change,


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