Environmental News NLP Dataset
This dataset can be used to have sentimental analysis on recent environment news
@kaggle.amritvirsinghx_environmental_news_nlp_dataset
Table List
- 417 tables(19.74 MB)
- Bbcnews 201701
- Bbcnews 201702
- Bbcnews 201703
- Bbcnews 201704
- Bbcnews 201705
- Bbcnews 201706
- Bbcnews 201707
- Bbcnews 201708
- Bbcnews 201709
- Bbcnews 201710
- Bbcnews 201711
- Bbcnews 201712
- Bbcnews 201801
- Bbcnews 201802
- Bbcnews 201803
- Bbcnews 201804
- Bbcnews 201805
- Bbcnews 201806
- Bbcnews 201807
- Bbcnews 201808
- Bbcnews 201809
- Bbcnews 201810
- Bbcnews 201811
- Bbcnews 201812
- Bbcnews 201901
- Bbcnews 201902
- Bbcnews 201903
- Bbcnews 201904
- Bbcnews 201905
- Bbcnews 201906
- Bbcnews 201907
- Bbcnews 201908
- Bbcnews 201909
- Bbcnews 201910
- Bbcnews 201911
- Bbcnews 201912
- Bbcnews 202001
- Cnn 200907
- Cnn 200908
- Cnn 200909
- Cnn 200911
- Cnn 200912
- Cnn 201001
- Cnn 201002
- Cnn 201003
- Cnn 201004
- Cnn 201005
- Cnn 201006
- Cnn 201007
- Cnn 201008
- Cnn 201009
- Cnn 201010
- Cnn 201011
- Cnn 201012
- Cnn 201101
- Cnn 201102
- Cnn 201103
- Cnn 201104
- Cnn 201105
- Cnn 201106
- Cnn 201107
- Cnn 201108
- Cnn 201109
- Cnn 201110
- Cnn 201111
- Cnn 201112
- Cnn 201201
- Cnn 201202
- Cnn 201203
- Cnn 201204
- Cnn 201205
- Cnn 201206
- Cnn 201207
- Cnn 201208
- Cnn 201209
- Cnn 201210
- Cnn 201211
- Cnn 201212
- Cnn 201301
- Cnn 201302
- Cnn 201303
- Cnn 201304
- Cnn 201305
- Cnn 201306
- Cnn 201307
- Cnn 201308
- Cnn 201309
- Cnn 201310
- Cnn 201311
- Cnn 201312
- Cnn 201401
- Cnn 201402
- Cnn 201403
- Cnn 201404
- Cnn 201405
- Cnn 201406
- Cnn 201407
- Cnn 201408
- Cnn 201409
- Cnn 201410
- Cnn 201411
- Cnn 201412
- Cnn 201501
- Cnn 201502
- Cnn 201503
- Cnn 201504
- Cnn 201505
- Cnn 201506
- Cnn 201507
- Cnn 201508
- Cnn 201509
- Cnn 201510
- Cnn 201511
- Cnn 201512
- Cnn 201601
- Cnn 201602
- Cnn 201603
- Cnn 201604
- Cnn 201605
- Cnn 201606
- Cnn 201607
- Cnn 201608
- Cnn 201609
- Cnn 201610
- Cnn 201611
- Cnn 201612
- Cnn 201701
- Cnn 201702
- Cnn 201703
- Cnn 201704
- Cnn 201705
- Cnn 201706
- Cnn 201707
- Cnn 201708
- Cnn 201709
- Cnn 201710
- Cnn 201711
- Cnn 201712
- Cnn 201801
- Cnn 201802
- Cnn 201803
- Cnn 201804
- Cnn 201805
- Cnn 201806
- Cnn 201807
- Cnn 201808
- Cnn 201809
- Cnn 201810
- Cnn 201811
- Cnn 201812
- Cnn 201901
- Cnn 201902
- Cnn 201903
- Cnn 201904
- Cnn 201905
- Cnn 201906
- Cnn 201907
- Cnn 201908
- Cnn 201909
- Cnn 201910
- Cnn 201911
- Cnn 201912
- Cnn 202001
- Foxnews 200907
- Foxnews 200908
- Foxnews 200909
- Foxnews 200910
- Foxnews 200911
- Foxnews 200912
- Foxnews 201001
- Foxnews 201002
- Foxnews 201003
- Foxnews 201004
- Foxnews 201005
- Foxnews 201006
- Foxnews 201007
- Foxnews 201008
- Foxnews 201009
- Foxnews 201010
- Foxnews 201011
- Foxnews 201012
- Foxnews 201101
- Foxnews 201102
- Foxnews 201103
- Foxnews 201104
- Foxnews 201105
- Foxnews 201106
- Foxnews 201107
- Foxnews 201108
- Foxnews 201109
- Foxnews 201110
- Foxnews 201111
- Foxnews 201112
- Foxnews 201201
- Foxnews 201202
- Foxnews 201203
- Foxnews 201204
- Foxnews 201205
- Foxnews 201206
- Foxnews 201207
- Foxnews 201208
- Foxnews 201209
- Foxnews 201210
- Foxnews 201211
- Foxnews 201212
- Foxnews 201301
- Foxnews 201302
- Foxnews 201303
- Foxnews 201304
- Foxnews 201305
- Foxnews 201306
- Foxnews 201307
- Foxnews 201308
- Foxnews 201309
- Foxnews 201310
- Foxnews 201311
- Foxnews 201312
- Foxnews 201401
- Foxnews 201402
- Foxnews 201403
- Foxnews 201404
- Foxnews 201405
- Foxnews 201406
- Foxnews 201407
- Foxnews 201408
- Foxnews 201409
- Foxnews 201410
- Foxnews 201411
- Foxnews 201412
- Foxnews 201501
- Foxnews 201502
- Foxnews 201503
- Foxnews 201504
- Foxnews 201505
- Foxnews 201506
- Foxnews 201507
- Foxnews 201508
- Foxnews 201509
- Foxnews 201510
- Foxnews 201511
- Foxnews 201512
- Foxnews 201601
- Foxnews 201602
- Foxnews 201603
- Foxnews 201604
- Foxnews 201605
- Foxnews 201606
- Foxnews 201607
- Foxnews 201608
- Foxnews 201609
- Foxnews 201610
- Foxnews 201611
- Foxnews 201612
- Foxnews 201701
- Foxnews 201702
- Foxnews 201703
- Foxnews 201704
- Foxnews 201705
- Foxnews 201706
- Foxnews 201707
- Foxnews 201708
- Foxnews 201709
- Foxnews 201710
- Foxnews 201711
- Foxnews 201712
- Foxnews 201801
- Foxnews 201802
- Foxnews 201803
- Foxnews 201804
- Foxnews 201805
- Foxnews 201806
- Foxnews 201807
- Foxnews 201808
- Foxnews 201809
- Foxnews 201810
- Foxnews 201811
- Foxnews 201812
- Foxnews 201901
- Foxnews 201902
- Foxnews 201903
- Foxnews 201904
- Foxnews 201905
- Foxnews 201906
- Foxnews 201907
- Foxnews 201908
- Foxnews 201909
- Foxnews 201910
- Foxnews 201911
- Foxnews 201912
- Foxnews 202001
- Msnbc 200907
- Msnbc 200908
- Msnbc 200909
- Msnbc 200910
- Msnbc 200911
- Msnbc 200912
- Msnbc 201001
- Msnbc 201002
- Msnbc 201003
- Msnbc 201004
- Msnbc 201005
- Msnbc 201006
- Msnbc 201007
- Msnbc 201008
- Msnbc 201009
- Msnbc 201010
- Msnbc 201011
- Msnbc 201012
- Msnbc 201101
- Msnbc 201102
- Msnbc 201103
- Msnbc 201104
- Msnbc 201105
- Msnbc 201106
- Msnbc 201107
- Msnbc 201108
- Msnbc 201109
- Msnbc 201110
- Msnbc 201111
- Msnbc 201112
- Msnbc 201201
- Msnbc 201202
- Msnbc 201203
- Msnbc 201204
- Msnbc 201205
- Msnbc 201206
- Msnbc 201207
- Msnbc 201208
- Msnbc 201209
- Msnbc 201210
- Msnbc 201211
- Msnbc 201212
- Msnbc 201301
- Msnbc 201302
- Msnbc 201303
- Msnbc 201304
- Msnbc 201305
- Msnbc 201306
- Msnbc 201307
- Msnbc 201308
- Msnbc 201309
- Msnbc 201310
- Msnbc 201311
- Msnbc 201312
- Msnbc 201401
- Msnbc 201402
- Msnbc 201403
- Msnbc 201404
- Msnbc 201405
- Msnbc 201406
- Msnbc 201407
- Msnbc 201408
- Msnbc 201409
- Msnbc 201410
- Msnbc 201411
- Msnbc 201412
- Msnbc 201501
- Msnbc 201502
- Msnbc 201503
- Msnbc 201504
- Msnbc 201505
- Msnbc 201506
- Msnbc 201507
- Msnbc 201508
- Msnbc 201509
- Msnbc 201510
- Msnbc 201511
- Msnbc 201512
- Msnbc 201601
- Msnbc 201602
- Msnbc 201603
- Msnbc 201604
- Msnbc 201605
- Msnbc 201606
- Msnbc 201607
- Msnbc 201608
- Msnbc 201609
- Msnbc 201610
- Msnbc 201611
- Msnbc 201612
- Msnbc 201701
- Msnbc 201702
- Msnbc 201703
- Msnbc 201704
- Msnbc 201705
- Msnbc 201706
- Msnbc 201707
- Msnbc 201708
- Msnbc 201709
- Msnbc 201710
- Msnbc 201711
- Msnbc 201712
- Msnbc 201801
- Msnbc 201802
- Msnbc 201803
- Msnbc 201804
- Msnbc 201805
- Msnbc 201806
- Msnbc 201807
- Msnbc 201808
- Msnbc 201809
- Msnbc 201810
- Msnbc 201811
- Msnbc 201812
- Msnbc 201901
- Msnbc 201902
- Msnbc 201903
- Msnbc 201904
- Msnbc 201905
- Msnbc 201906
- Msnbc 201907
- Msnbc 201908
- Msnbc 201909
- Msnbc 201910
- Msnbc 201911
- Msnbc 201912
- Msnbc 202001
Cnn 201209
@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201209
- 13.28 KB
- 22 rows
- 7 columns
urlURL | matchdatetimeMatchDateTime | stationStation | showShow | iashowidIAShowID | iapreviewthumbIAPreviewThumb | snippetSnippet |
|---|---|---|---|---|---|---|
| https://archive.org/details/CNNW_20120927_040000_Piers_Morgan_Tonight#start/2478/end/2513 | Thu Sep 27 2012 04:41:33 GMT+0000 (Coordinated Universal Time) | CNN | Piers Morgan Tonight | CNNW_20120927_040000_Piers_Morgan_Tonight | https://archive.org/download/CNNW_20120927_040000_Piers_Morgan_Tonight/CNNW_20120927_040000_Piers_Morgan_Tonight.thumbs/CNNW_20120927_040000_Piers_Morgan_Tonight_002458.jpg | how you can be involved. your area, energy oil, talk to me about that and your relationship with cgi about that. we have to understand our responsibilities as global citizens. global warming, climate change it is a fact. we had the lowest ice pack at |
| https://archive.org/details/CNNW_20120924_090000_EarlyStart#start/619/end/654 | Mon Sep 24 2012 09:10:34 GMT+0000 (Coordinated Universal Time) | CNN | EarlyStart | CNNW_20120924_090000_EarlyStart | https://archive.org/download/CNNW_20120924_090000_EarlyStart/CNNW_20120924_090000_EarlyStart.thumbs/CNNW_20120924_090000_EarlyStart_000597.jpg | they basically say global warming is one of the main factors. we have no way of actually determining that. this is what most of these climbers have been saying. and the avalanches are not just more freak went but a lot bigger |
| https://archive.org/details/CNNW_20120907_040000_Piers_Morgan_Tonight#start/3168/end/3203 | Fri Sep 07 2012 04:53:03 GMT+0000 (Coordinated Universal Time) | CNN | Piers Morgan Tonight | CNNW_20120907_040000_Piers_Morgan_Tonight | https://archive.org/download/CNNW_20120907_040000_Piers_Morgan_Tonight/CNNW_20120907_040000_Piers_Morgan_Tonight.thumbs/CNNW_20120907_040000_Piers_Morgan_Tonight_003148.jpg | [ applause ] and yes, my plan will continue to reduce the carbon pollution that is heating our planet, because climate change is not a hoax. more droughts and floods and |
| https://archive.org/details/CNNW_20120907_050000_Democratic_National_Convention#start/5115/end/5150 | Fri Sep 07 2012 06:25:30 GMT+0000 (Coordinated Universal Time) | CNN | Democratic National Convention | CNNW_20120907_050000_Democratic_National_Convention | https://archive.org/download/CNNW_20120907_050000_Democratic_National_Convention/CNNW_20120907_050000_Democratic_National_Convention.thumbs/CNNW_20120907_050000_Democratic_National_Convention_005097.jpg | 600000 new jobs in natural gas alone. [ applause ] and yes, my plan will continue to reduce the carbon pollution that is heating our planet, because climate change is not a |
| https://archive.org/details/CNNW_20120924_160000_CNN_Newsroom#start/1923/end/1958 | Mon Sep 24 2012 16:32:18 GMT+0000 (Coordinated Universal Time) | CNN | CNN Newsroom | CNNW_20120924_160000_CNN_Newsroom | https://archive.org/download/CNNW_20120924_160000_CNN_Newsroom/CNNW_20120924_160000_CNN_Newsroom.thumbs/CNNW_20120924_160000_CNN_Newsroom_001918.jpg | it was still avalanche season to that mountain. it hadn't changed the season yet. sure. how common are they in that region because i know local mountain guides have reported there's more of this ice melting because of global warming on the peaks? it's kind of not true. |
| https://archive.org/details/CNNW_20120901_000000_Anderson_Cooper_360#start/1808/end/1843 | Sat Sep 01 2012 00:30:23 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20120901_000000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20120901_000000_Anderson_Cooper_360/CNNW_20120901_000000_Anderson_Cooper_360.thumbs/CNNW_20120901_000000_Anderson_Cooper_360_001798.jpg | to their evangelicals. they're climate change denial t denialists. that's what elections are? they appeal to that. when you're saying, look, we have got to cut the debt and everybody has to sacrifice, |
| https://archive.org/details/CNNW_20120907_070000_Piers_Morgan_Tonight#start/3316/end/3351 | Fri Sep 07 2012 07:55:31 GMT+0000 (Coordinated Universal Time) | CNN | Piers Morgan Tonight | CNNW_20120907_070000_Piers_Morgan_Tonight | https://archive.org/download/CNNW_20120907_070000_Piers_Morgan_Tonight/CNNW_20120907_070000_Piers_Morgan_Tonight.thumbs/CNNW_20120907_070000_Piers_Morgan_Tonight_003298.jpg | gas alone. and yes, my plan will continue to reduce the carbon pollution that is heating our planet, because climate change is not a hoax. more droughts and floods and wildfires are not a joke. |
| https://archive.org/details/CNNW_20120901_050000_Anderson_Cooper_360#start/1781/end/1816 | Sat Sep 01 2012 05:29:56 GMT+0000 (Coordinated Universal Time) | CNN | Anderson Cooper 360 | CNNW_20120901_050000_Anderson_Cooper_360 | https://archive.org/download/CNNW_20120901_050000_Anderson_Cooper_360/CNNW_20120901_050000_Anderson_Cooper_360.thumbs/CNNW_20120901_050000_Anderson_Cooper_360_001768.jpg | to some extent that is what everybody does. the republican party appealing to the evangelicals and the climate change denialists. that what the elections are now? yes, they appeal to that. i don't think that when you say, |
| https://archive.org/details/CNNW_20120906_200000_Democratic_National_Convention#start/1002/end/1037 | Thu Sep 06 2012 20:16:57 GMT+0000 (Coordinated Universal Time) | CNN | Democratic National Convention | CNNW_20120906_200000_Democratic_National_Convention | https://archive.org/download/CNNW_20120906_200000_Democratic_National_Convention/CNNW_20120906_200000_Democratic_National_Convention.thumbs/CNNW_20120906_200000_Democratic_National_Convention_000988.jpg | unpopular. climate change -- how about -- explain them they're not so unpopular. let's go back to the governor's analogy. great depression lasted from 1929 to 1945. you know why it lasted so long? because we tried exactly the same policys that are failing |
| https://archive.org/details/CNNW_20120923_140000_Fareed_Zakaria_GPS#start/2228/end/2263 | Sun Sep 23 2012 14:37:23 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120923_140000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120923_140000_Fareed_Zakaria_GPS/CNNW_20120923_140000_Fareed_Zakaria_GPS.thumbs/CNNW_20120923_140000_Fareed_Zakaria_GPS_002217.jpg | couple of their stores. they think this is a good investment, so they're glad they're on the cutting edge of the fight against climate change, but they think it will save them money, save their customers money, create more jobs, and they designed it from the beginning. |
CREATE TABLE cnn_201209 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);