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 201608

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201608

14.26 kB
28 rows
7 columns

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

Msnbc 201609

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201609

41.3 kB
170 rows
7 columns

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

Msnbc 201610

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201610

53.89 kB
274 rows
7 columns

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

Msnbc 201611

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201611

40.41 kB
182 rows
7 columns

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

Msnbc 201612

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201612

79.61 kB
390 rows
7 columns

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

Msnbc 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201701

47.59 kB
216 rows
7 columns

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

Msnbc 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201702

21.39 kB
59 rows
7 columns

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

Msnbc 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201703

41.19 kB
173 rows
7 columns

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

Msnbc 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201704

37.47 kB
147 rows
7 columns

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

Msnbc 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201705

53.14 kB
230 rows
7 columns

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

Msnbc 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201706

98.38 kB
477 rows
7 columns

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

Msnbc 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201707

43.61 kB
180 rows
7 columns

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

Msnbc 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201708

37.73 kB
154 rows
7 columns

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

Msnbc 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201709

50.53 kB
207 rows
7 columns

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

Msnbc 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201710

21.79 kB
60 rows
7 columns

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

Msnbc 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201711

25.23 kB
83 rows
7 columns

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

Msnbc 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201712

31.53 kB
118 rows
7 columns

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

Msnbc 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201801

23.57 kB
65 rows
7 columns

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

Msnbc 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201802

15.88 kB
30 rows
7 columns

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

Msnbc 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201803

18.36 kB
45 rows
7 columns

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

Msnbc 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201804

33.65 kB
126 rows
7 columns

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

Msnbc 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201805

25.1 kB
112 rows
7 columns

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

Msnbc 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201806

21.61 kB
79 rows
7 columns

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

Msnbc 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201807

20.83 kB
61 rows
7 columns

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

Msnbc 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201808

21.81 kB
58 rows
7 columns

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