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 201210

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201210

16.21 kB
38 rows
7 columns

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

Cnn 201211

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201211

42.22 kB
192 rows
7 columns

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

Cnn 201212

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201212

30.49 kB
185 rows
7 columns

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

Cnn 201301

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201301

48.96 kB
245 rows
7 columns

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

Cnn 201302

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201302

38.59 kB
190 rows
7 columns

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

Cnn 201303

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201303

23.47 kB
80 rows
7 columns

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

Cnn 201304

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201304

17.15 kB
75 rows
7 columns

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

Cnn 201305

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201305

18.06 kB
69 rows
7 columns

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

Cnn 201306

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201306

20.49 kB
66 rows
7 columns

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

Cnn 201307

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201307

8.57 kB
4 rows
7 columns

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

Cnn 201308

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201308

22.25 kB
74 rows
7 columns

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

Cnn 201309

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201309

29.65 kB
114 rows
7 columns

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

Cnn 201310

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201310

16.09 kB
35 rows
7 columns

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

Cnn 201311

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201311

31.59 kB
132 rows
7 columns

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

Cnn 201312

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201312

21.66 kB
66 rows
7 columns

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

Cnn 201401

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201401

24.4 kB
88 rows
7 columns

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

Cnn 201402

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201402

40.04 kB
173 rows
7 columns

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

Cnn 201403

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201403

19.11 kB
57 rows
7 columns

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

Cnn 201404

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201404

17.05 kB
43 rows
7 columns

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

Cnn 201405

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201405

53.12 kB
236 rows
7 columns

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

Cnn 201406

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201406

28.14 kB
105 rows
7 columns

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

Cnn 201407

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201407

14.97 kB
23 rows
7 columns

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

Cnn 201408

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201408

10.27 kB
6 rows
7 columns

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

Cnn 201409

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201409

31.4 kB
120 rows
7 columns

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

Cnn 201410

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201410

12.62 kB
17 rows
7 columns

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