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

Cnn 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201901

36.33 kB
145 rows
7 columns

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

Cnn 201902

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201902

73.76 kB
347 rows
7 columns

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

Cnn 201903

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201903

65.9 kB
290 rows
7 columns

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

Cnn 201904

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201904

50.4 kB
205 rows
7 columns

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

Cnn 201905

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201905

69.89 kB
301 rows
7 columns

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

Cnn 201906

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201906

123.71 kB
585 rows
7 columns

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

Cnn 201907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201907

68.94 kB
330 rows
7 columns

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

Cnn 201908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201908

127.75 kB
612 rows
7 columns

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

Cnn 201909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201909

143.67 kB
701 rows
7 columns

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

Cnn 201910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201910

44.56 kB
216 rows
7 columns

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

Cnn 201911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201911

62.97 kB
328 rows
7 columns

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

Cnn 201912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201912

73.98 kB
374 rows
7 columns

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

Cnn 202001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_202001

56.24 kB
260 rows
7 columns

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

Foxnews 200907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200907

76.34 kB
422 rows
7 columns

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

Foxnews 200908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200908

31.68 kB
143 rows
7 columns

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

Foxnews 200909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200909

51.14 kB
264 rows
7 columns

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

Foxnews 200910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200910

77 kB
418 rows
7 columns

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

Foxnews 200911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200911

88.99 kB
483 rows
7 columns

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

Foxnews 200912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200912

278.33 kB
1,590 rows
7 columns

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

Foxnews 201001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201001

68.47 kB
351 rows
7 columns

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

Foxnews 201002

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201002

108.76 kB
602 rows
7 columns

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

Foxnews 201003

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201003

44.32 kB
210 rows
7 columns

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

Foxnews 201004

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201004

60.33 kB
308 rows
7 columns

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

Foxnews 201005

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201005

22.96 kB
79 rows
7 columns

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

Foxnews 201006

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201006

35.35 kB
147 rows
7 columns

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