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

35.48 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

72.04 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

64.35 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

49.22 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

68.25 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

120.81 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

67.33 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

124.76 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

140.3 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

43.52 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

61.49 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

72.25 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

54.93 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

74.55 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

30.94 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

49.94 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

75.2 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

86.9 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

271.81 KB
1590 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

66.86 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

106.21 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

43.28 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

58.92 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.42 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

34.52 KB
147 rows
7 columns


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