Name: Environmental News NLP Dataset
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Environmental News NLP Dataset

Context and Inspiration

Due to the global pandemic situation, various lockdowns have been imposed in different countries, This data contains short snippets of news from 2017 to Jan 2020. this can be useful to perform sentimental analysis on news and have a general idea about what were the sentiments of the people before the pandemic situation. What was going on in the news, then we can do a comparative study of before and after the pandemic news.

Different news sources are present in this dataset

Data Dictionary

Feature Name	Description
URL	Link to the news archive
MatchDateTime	Date and time of airing
Station	News Station
Show	Name of the show aired on
IAShowID	Custom Show ID in archive
IAPreviewThumb	Link to the thumbnail image
Snippet	Actual snippet of news published and aired

Tables

Bbcnews 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201701

58.83 kB
279 rows
7 columns

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

Bbcnews 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201702

34.09 kB
168 rows
7 columns

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

Bbcnews 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201703

45.08 kB
218 rows
7 columns

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

Bbcnews 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201704

45.28 kB
206 rows
7 columns

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

Bbcnews 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201705

81.3 kB
417 rows
7 columns

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

Bbcnews 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201706

131.74 kB
683 rows
7 columns

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

Bbcnews 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201707

130.92 kB
696 rows
7 columns

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

Bbcnews 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201708

58.96 kB
297 rows
7 columns

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

Bbcnews 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201709

59.11 kB
302 rows
7 columns

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

Bbcnews 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201710

47.72 kB
255 rows
7 columns

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

Bbcnews 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201711

75.64 kB
402 rows
7 columns

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

Bbcnews 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201712

64.84 kB
345 rows
7 columns

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

Bbcnews 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201801

41.3 kB
191 rows
7 columns

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

Bbcnews 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201802

25.15 kB
91 rows
7 columns

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

Bbcnews 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201803

21.44 kB
70 rows
7 columns

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

Bbcnews 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201804

43.15 kB
193 rows
7 columns

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

Bbcnews 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201805

16.21 kB
36 rows
7 columns

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

Bbcnews 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201806

60.76 kB
299 rows
7 columns

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

Bbcnews 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201807

71.31 kB
347 rows
7 columns

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

Bbcnews 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201808

64.98 kB
337 rows
7 columns

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

Bbcnews 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201809

46.29 kB
222 rows
7 columns

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

Bbcnews 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201810

148.8 kB
812 rows
7 columns

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

Bbcnews 201811

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201811

171.06 kB
947 rows
7 columns

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

Bbcnews 201812

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201812

203.23 kB
1,142 rows
7 columns

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

Bbcnews 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201901

66.11 kB
331 rows
7 columns

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

Bbcnews 201902

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201902

120.79 kB
632 rows
7 columns

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

Bbcnews 201903

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201903

94.17 kB
490 rows
7 columns

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

Bbcnews 201904

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201904

246.13 kB
1,334 rows
7 columns

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

Bbcnews 201905

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201905

228.28 kB
1,255 rows
7 columns

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

Bbcnews 201906

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201906

235.85 kB
1,249 rows
7 columns

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

Bbcnews 201907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201907

150.67 kB
783 rows
7 columns

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

Bbcnews 201908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201908

279.26 kB
1,543 rows
7 columns

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

Bbcnews 201909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201909

246.32 kB
1,322 rows
7 columns

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

Bbcnews 201910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201910

135.15 kB
664 rows
7 columns

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

Bbcnews 201911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201911

262.29 kB
1,362 rows
7 columns

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

Bbcnews 201912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201912

367.87 kB
2,103 rows
7 columns

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

Bbcnews 202001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_202001

227.64 kB
1,237 rows
7 columns

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

Cnn 200907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_200907

41.45 kB
170 rows
7 columns

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

Cnn 200908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_200908

22.6 kB
65 rows
7 columns

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

Cnn 200909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_200909

13.67 kB
19 rows
7 columns

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

Cnn 200911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_200911

32.44 kB
134 rows
7 columns

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

Cnn 200912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_200912

289.78 kB
1,506 rows
7 columns

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

Cnn 201001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201001

20.87 kB
60 rows
7 columns

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

Cnn 201002

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201002

24.25 kB
83 rows
7 columns

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

Cnn 201003

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201003

22.51 kB
66 rows
7 columns

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

Cnn 201004

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201004

39.69 kB
165 rows
7 columns

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

Cnn 201005

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201005

16.28 kB
35 rows
7 columns

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

Cnn 201006

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201006

14.81 kB
27 rows
7 columns

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

Cnn 201007

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201007

20.79 kB
53 rows
7 columns

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

Cnn 201008

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201008

20.4 kB
59 rows
7 columns

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