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

117.96 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

91.96 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

240.37 KB
1334 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

222.93 KB
1255 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

230.32 KB
1249 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

147.14 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

272.71 KB
1543 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

240.55 KB
1322 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

131.98 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

256.14 KB
1362 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

359.25 KB
2103 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

222.3 KB
1237 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

40.48 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.07 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.35 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

31.68 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

282.99 KB
1506 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.38 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

23.69 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

21.98 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

38.76 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

15.9 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.47 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.3 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

19.93 KB
59 rows
7 columns


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