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 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
);