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 201206
@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201206
- 14.12 KB
- 33 rows
- 7 columns
urlURL | matchdatetimeMatchDateTime | stationStation | showShow | iashowidIAShowID | iapreviewthumbIAPreviewThumb | snippetSnippet |
|---|---|---|---|---|---|---|
| https://archive.org/details/CNNW_20120610_140000_Fareed_Zakaria_GPS#start/1807/end/1842 | Sun Jun 10 2012 14:30:22 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120610_140000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120610_140000_Fareed_Zakaria_GPS/CNNW_20120610_140000_Fareed_Zakaria_GPS.thumbs/CNNW_20120610_140000_Fareed_Zakaria_GPS_001800.jpg | stability and not instability. one problem, there's a significant lobby against shale gas and the way it's produced. fracking consumes a lot of water. shale production also creates large quantities of methane, a greenhouse gas. |
| https://archive.org/details/CNNW_20120617_170000_Fareed_Zakaria_GPS#start/2418/end/2453 | Sun Jun 17 2012 17:40:33 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120617_170000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120617_170000_Fareed_Zakaria_GPS/CNNW_20120617_170000_Fareed_Zakaria_GPS.thumbs/CNNW_20120617_170000_Fareed_Zakaria_GPS_002400.jpg | u.n. summit in rio will be a wasted opportunity. i'll have an interesting guest who will explain why. there's perhaps a 0 -- 0.6% of all deaths in the developing world caused by global warming. |
| https://archive.org/details/CNNW_20120627_150000_CNN_Newsroom#start/4284/end/4319 | Wed Jun 27 2012 16:11:39 GMT+0000 (Coordinated Universal Time) | CNN | CNN Newsroom | CNNW_20120627_150000_CNN_Newsroom | https://archive.org/download/CNNW_20120627_150000_CNN_Newsroom/CNNW_20120627_150000_CNN_Newsroom.thumbs/CNNW_20120627_150000_CNN_Newsroom_004260.jpg | mexico. thank you. more that we are working on that newshour, egypt held its first democratic election and a woman will serve as vice president. and it looks like pond scum, but it is a weapon against global warming. |
| https://archive.org/details/CNNW_20120624_170000_Fareed_Zakaria_GPS#start/3431/end/3466 | Sun Jun 24 2012 17:57:26 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120624_170000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120624_170000_Fareed_Zakaria_GPS/CNNW_20120624_170000_Fareed_Zakaria_GPS.thumbs/CNNW_20120624_170000_Fareed_Zakaria_GPS_003420.jpg | this week's 'book of the week' is fate of the species. it is an elegant compelling. it lays out mega challenges we confront -- super viruses, climate change, disappearing |
| https://archive.org/details/CNNW_20120610_140000_Fareed_Zakaria_GPS#start/141/end/176 | Sun Jun 10 2012 14:02:36 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120610_140000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120610_140000_Fareed_Zakaria_GPS/CNNW_20120610_140000_Fareed_Zakaria_GPS.thumbs/CNNW_20120610_140000_Fareed_Zakaria_GPS_000120.jpg | decade. why? in both those cases, human beings responded to the crisis. governments around the world cooperated and acted. when we look at our problems, economic slowdowns, debt, terrorism, climate change, keep |
| https://archive.org/details/CNNW_20120611_200000_The_Situation_Room#start/4594/end/4629 | Mon Jun 11 2012 21:16:49 GMT+0000 (Coordinated Universal Time) | CNN | The Situation Room | CNNW_20120611_200000_The_Situation_Room | https://archive.org/download/CNNW_20120611_200000_The_Situation_Room/CNNW_20120611_200000_The_Situation_Room.thumbs/CNNW_20120611_200000_The_Situation_Room_004590.jpg | comprehensive immigration reform. and if you think through the politics of those two things. i think it's very unlikely, and i couldn't get almost anyone at the white house to tell me it was likely, that he would push hard on climate change. |
| https://archive.org/details/CNNW_20120620_150000_CNN_Newsroom#start/6894/end/6929 | Wed Jun 20 2012 16:55:09 GMT+0000 (Coordinated Universal Time) | CNN | CNN Newsroom | CNNW_20120620_150000_CNN_Newsroom | https://archive.org/download/CNNW_20120620_150000_CNN_Newsroom/CNNW_20120620_150000_CNN_Newsroom.thumbs/CNNW_20120620_150000_CNN_Newsroom_006870.jpg | the meetings in the united states. many leaders say they have been forced to put the environmental in the back burner. they have to manage many crisis situations, and they are basically in a crisis mode. reporter: 20 years ago, rio hosted the landmark effort summit with real commits to tackle climat… |
| https://archive.org/details/CNNW_20120627_150000_CNN_Newsroom#start/7108/end/7143 | Wed Jun 27 2012 16:58:43 GMT+0000 (Coordinated Universal Time) | CNN | CNN Newsroom | CNNW_20120627_150000_CNN_Newsroom | https://archive.org/download/CNNW_20120627_150000_CNN_Newsroom/CNNW_20120627_150000_CNN_Newsroom.thumbs/CNNW_20120627_150000_CNN_Newsroom_007080.jpg | capture carbon dioxide and with the water and the sunlight, the algae multiplies and oxygen is produced as a byproduct, and bye-bye greenhouse gases and hello pure oxygen. he made this rough prototype for |
| https://archive.org/details/CNNW_20120610_170000_Fareed_Zakaria_GPS#start/1803/end/1838 | Sun Jun 10 2012 17:30:18 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120610_170000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120610_170000_Fareed_Zakaria_GPS/CNNW_20120610_170000_Fareed_Zakaria_GPS.thumbs/CNNW_20120610_170000_Fareed_Zakaria_GPS_001800.jpg | fracking consumes a lot of water. shale production also creates large quantities of methane, a greenhouse gas. sometimes methane pours out of |
| https://archive.org/details/CNNW_20120610_170000_Fareed_Zakaria_GPS#start/3421/end/3456 | Sun Jun 10 2012 17:57:16 GMT+0000 (Coordinated Universal Time) | CNN | Fareed Zakaria GPS | CNNW_20120610_170000_Fareed_Zakaria_GPS | https://archive.org/download/CNNW_20120610_170000_Fareed_Zakaria_GPS/CNNW_20120610_170000_Fareed_Zakaria_GPS.thumbs/CNNW_20120610_170000_Fareed_Zakaria_GPS_003420.jpg | if you like freak nom hicks or malcolm glad well. it explains why success often leads to failure. we all need to learn how to adapt to new business opportunities, to financial downturns even to climate |
CREATE TABLE cnn_201206 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);