Environmental News NLP Dataset
This dataset can be used to have sentimental analysis on recent environment news
@kaggle.amritvirsinghx_environmental_news_nlp_dataset
Cnn 201712
@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201712
- 49 KB
- 231 rows
- 7 columns
urlURL | matchdatetimeMatchDateTime | stationStation | showShow | iashowidIAShowID | iapreviewthumbIAPreviewThumb | snippetSnippet |
|---|---|---|---|---|---|---|
| https://archive.org/details/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/3309/end/3344 | Fri Dec 29 2017 09:55:24 GMT+0000 (Coordinated Universal Time) | CNN | Early Start with Christine Romans and Dave Briggs | CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs | https://archive.org/download/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_003267.jpg | apparently not realizing climate change and weather are not the same thing. he fired off this tweet. perhaps we could use a little bit of that good old global warming. |
| https://archive.org/details/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer#start/2937/end/2972 | Fri Dec 29 2017 23:49:12 GMT+0000 (Coordinated Universal Time) | CNN | Situation Room With Wolf Blitzer | CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer | https://archive.org/download/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer.thumbs/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer_002937.jpg | dangerous windchill values across the nation. standby for the latest weekend forecast. and as americans bundle up, the president is doubling down on his skepticism on climate change. is he confused on the difference between weather and global warming? |
| https://archive.org/details/CNNW_20171229_210000_The_Lead_With_Jake_Tapper#start/242/end/277 | Fri Dec 29 2017 21:04:17 GMT+0000 (Coordinated Universal Time) | CNN | The Lead With Jake Tapper | CNNW_20171229_210000_The_Lead_With_Jake_Tapper | https://archive.org/download/CNNW_20171229_210000_The_Lead_With_Jake_Tapper/CNNW_20171229_210000_The_Lead_With_Jake_Tapper.thumbs/CNNW_20171229_210000_The_Lead_With_Jake_Tapper_000237.jpg | temperatures in the east to talk about global warming. |
| https://archive.org/details/CNNW_20171229_040000_Anderson_Cooper_360#start/1998/end/2033 | Fri Dec 29 2017 04:33:33 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20171229_040000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20171229_040000_Anderson_Cooper_360/CNNW_20171229_040000_Anderson_Cooper_360.thumbs/CNNW_20171229_040000_Anderson_Cooper_360_001977.jpg | made today. the most recent is the president's statement on twitter about global warming. after he pulled the u.s. out of the paris climate accords, everyone in the white house pressed and pressed and pressed, mr. president, do you believe in global warming. they would ask the press secretary, do yo… |
| https://archive.org/details/CNNW_20171229_010000_Anderson_Cooper_360#start/2132/end/2167 | Fri Dec 29 2017 01:35:47 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20171229_010000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20171229_010000_Anderson_Cooper_360/CNNW_20171229_010000_Anderson_Cooper_360.thumbs/CNNW_20171229_010000_Anderson_Cooper_360_002127.jpg | about 'vanity fair' even though his nemesis is no longer there. old school trump in palm beach like josh said, unstaffed. global warming tweet reminded |
| https://archive.org/details/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs#start/3355/end/3390 | Fri Dec 29 2017 09:56:10 GMT+0000 (Coordinated Universal Time) | CNN | Early Start with Christine Romans and Dave Briggs | CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs | https://archive.org/download/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs.thumbs/CNNW_20171229_090000_Early_Start_with_Christine_Romans_and_Dave_Briggs_003327.jpg | president's golf course in ireland recently received permission to build sea walls to preve prevent erosion. the company cited global warming on its application for the wall. is he acknowledging global |
| https://archive.org/details/CNNW_20171229_040000_Anderson_Cooper_360#start/2616/end/2651 | Fri Dec 29 2017 04:43:51 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20171229_040000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20171229_040000_Anderson_Cooper_360/CNNW_20171229_040000_Anderson_Cooper_360.thumbs/CNNW_20171229_040000_Anderson_Cooper_360_002607.jpg | never see. but i think we've got to deliver on some of these things from our constituents. so just to use an example from the last hour, let's say. he wrote on twitter about global warming, basically suggesting that the cold temperatures in the northeast that we're feeling right now, you know, prove… |
| https://archive.org/details/CNNW_20171229_105900_New_Day#start/1434/end/1469 | Fri Dec 29 2017 11:23:09 GMT+0000 (Coordinated Universal Time) | CNN | New Day | CNNW_20171229_105900_New_Day | https://archive.org/download/CNNW_20171229_105900_New_Day/CNNW_20171229_105900_New_Day.thumbs/CNNW_20171229_105900_New_Day_001408.jpg | tiny part of a big heated planet. it is sort of like not understanding when the sun goes down in your naked, it's not dark everywhere. it's not? no. well, i don't know, david. case closed on global warming. |
| https://archive.org/details/CNNW_20171201_020000_Anderson_Cooper_360#start/2912/end/2947 | Fri Dec 01 2017 02:48:47 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20171201_020000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20171201_020000_Anderson_Cooper_360/CNNW_20171201_020000_Anderson_Cooper_360.thumbs/CNNW_20171201_020000_Anderson_Cooper_360_002908.jpg | skeptics. some of the evidence is obvious, warmer temperatures, rising sea levels, more forest fires and heat waves. other evidence is further away from washington. with alarming indications for the planet. part one of global warming, arctic melt. |
| https://archive.org/details/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer#start/3397/end/3432 | Fri Dec 29 2017 23:56:52 GMT+0000 (Coordinated Universal Time) | CNN | Situation Room With Wolf Blitzer | CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer | https://archive.org/download/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer.thumbs/CNNW_20171229_230000_Situation_Room_With_Wolf_Blitzer_003387.jpg | it also magnifies his misunderstanding of a science behind climate change. and tonight, scientists are calling the president's weather tweet irresponsible. the president using the cold snap in the u.s. to cast doubt on climate change. |
CREATE TABLE cnn_201712 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);