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

Msnbc 201407

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201407

31.91 kB
120 rows
7 columns

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

Msnbc 201408

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201408

27.38 kB
96 rows
7 columns

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

Msnbc 201409

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201409

51.28 kB
246 rows
7 columns

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

Msnbc 201410

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201410

38.46 kB
162 rows
7 columns

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

Msnbc 201411

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201411

80.98 kB
403 rows
7 columns

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

Msnbc 201412

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201412

27.05 kB
92 rows
7 columns

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

Msnbc 201501

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201501

46.67 kB
215 rows
7 columns

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

Msnbc 201502

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201502

35.76 kB
148 rows
7 columns

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

Msnbc 201503

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201503

60.4 kB
312 rows
7 columns

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

Msnbc 201504

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201504

53.03 kB
250 rows
7 columns

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

Msnbc 201505

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201505

59.78 kB
287 rows
7 columns

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

Msnbc 201506

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201506

44.68 kB
197 rows
7 columns

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

Msnbc 201507

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201507

41.48 kB
169 rows
7 columns

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

Msnbc 201508

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201508

61.34 kB
289 rows
7 columns

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

Msnbc 201509

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201509

128.95 kB
681 rows
7 columns

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

Msnbc 201510

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201510

43.75 kB
198 rows
7 columns

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

Msnbc 201511

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201511

48.2 kB
217 rows
7 columns

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

Msnbc 201512

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201512

85.8 kB
438 rows
7 columns

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

Msnbc 201601

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201601

32.39 kB
112 rows
7 columns

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

Msnbc 201602

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201602

24.24 kB
78 rows
7 columns

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

Msnbc 201603

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201603

28.29 kB
102 rows
7 columns

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

Msnbc 201604

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201604

35.39 kB
150 rows
7 columns

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

Msnbc 201605

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201605

36.19 kB
167 rows
7 columns

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

Msnbc 201606

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201606

28.12 kB
120 rows
7 columns

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

Msnbc 201607

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201607

30.35 kB
124 rows
7 columns

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