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 201411

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201411

53.73 kB
254 rows
7 columns

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

Cnn 201412

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201412

23.64 kB
68 rows
7 columns

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

Cnn 201501

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201501

23.57 kB
79 rows
7 columns

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

Cnn 201502

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201502

14.5 kB
26 rows
7 columns

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

Cnn 201503

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201503

13.98 kB
25 rows
7 columns

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

Cnn 201504

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201504

23.69 kB
75 rows
7 columns

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

Cnn 201505

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201505

24.08 kB
74 rows
7 columns

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

Cnn 201506

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201506

27.59 kB
91 rows
7 columns

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

Cnn 201507

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201507

21.94 kB
70 rows
7 columns

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

Cnn 201508

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201508

51.09 kB
240 rows
7 columns

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

Cnn 201509

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201509

102.21 kB
514 rows
7 columns

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

Cnn 201510

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201510

40.6 kB
177 rows
7 columns

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

Cnn 201511

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201511

52.46 kB
232 rows
7 columns

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

Cnn 201512

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201512

76.05 kB
368 rows
7 columns

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

Cnn 201601

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201601

25.34 kB
79 rows
7 columns

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

Cnn 201602

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201602

35.85 kB
138 rows
7 columns

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

Cnn 201603

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201603

32.42 kB
130 rows
7 columns

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

Cnn 201604

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201604

40.41 kB
183 rows
7 columns

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

Cnn 201605

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201605

29.61 kB
101 rows
7 columns

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

Cnn 201606

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201606

24.42 kB
74 rows
7 columns

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

Cnn 201607

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201607

25.91 kB
88 rows
7 columns

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

Cnn 201608

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201608

15.01 kB
23 rows
7 columns

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

Cnn 201609

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201609

42.55 kB
180 rows
7 columns

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

Cnn 201610

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201610

51.02 kB
238 rows
7 columns

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

Cnn 201611

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201611

52.77 kB
229 rows
7 columns

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