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 201612

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201612

118.66 kB
626 rows
7 columns

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

Cnn 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201701

49.37 kB
227 rows
7 columns

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

Cnn 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201702

22.2 kB
59 rows
7 columns

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

Cnn 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201703

39.96 kB
174 rows
7 columns

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

Cnn 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201704

61.57 kB
284 rows
7 columns

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

Cnn 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201705

64.95 kB
290 rows
7 columns

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

Cnn 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201706

171.32 kB
900 rows
7 columns

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

Cnn 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201707

49.99 kB
208 rows
7 columns

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

Cnn 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201708

48.13 kB
224 rows
7 columns

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

Cnn 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201709

44.27 kB
191 rows
7 columns

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

Cnn 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201710

19.55 kB
51 rows
7 columns

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

Cnn 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201711

15.75 kB
31 rows
7 columns

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

Cnn 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201712

50.18 kB
231 rows
7 columns

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

Cnn 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201801

20.72 kB
57 rows
7 columns

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

Cnn 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201802

14.65 kB
25 rows
7 columns

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

Cnn 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201803

14.7 kB
24 rows
7 columns

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

Cnn 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201804

20.1 kB
51 rows
7 columns

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

Cnn 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201805

19.03 kB
53 rows
7 columns

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

Cnn 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201806

22.17 kB
61 rows
7 columns

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

Cnn 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201807

22.34 kB
63 rows
7 columns

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

Cnn 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201808

19.35 kB
55 rows
7 columns

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

Cnn 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201809

21.03 kB
59 rows
7 columns

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

Cnn 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201810

37.07 kB
142 rows
7 columns

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

Cnn 201811

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201811

109.37 kB
554 rows
7 columns

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

Cnn 201812

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201812

44.17 kB
196 rows
7 columns

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