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

115.88 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

48.21 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

21.68 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.02 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

60.12 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

63.42 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

167.31 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

48.82 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

47 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

43.23 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.1 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.38 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

49 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.23 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.31 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.36 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

19.63 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

18.58 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

21.65 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

21.81 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

18.9 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

20.54 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

36.21 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

106.8 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

43.13 KB
196 rows
7 columns


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