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 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201809

28.53 KB
121 rows
7 columns


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

Msnbc 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201810

48.87 KB
222 rows
7 columns


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

Msnbc 201811

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201811

87.67 KB
452 rows
7 columns


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

Msnbc 201812

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201812

50.68 KB
241 rows
7 columns


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

Msnbc 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201901

52.3 KB
243 rows
7 columns


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

Msnbc 201902

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201902

77.48 KB
375 rows
7 columns


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

Msnbc 201903

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201903

103.56 KB
525 rows
7 columns


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

Msnbc 201904

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201904

60.55 KB
274 rows
7 columns


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

Msnbc 201905

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201905

76.94 KB
355 rows
7 columns


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

Msnbc 201906

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201906

125.6 KB
619 rows
7 columns


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

Msnbc 201907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201907

86.9 KB
424 rows
7 columns


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

Msnbc 201908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201908

159.1 KB
813 rows
7 columns


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

Msnbc 201909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201909

182.44 KB
937 rows
7 columns


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

Msnbc 201910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201910

43.7 KB
217 rows
7 columns


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

Msnbc 201911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201911

76.45 KB
398 rows
7 columns


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

Msnbc 201912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201912

64.18 KB
317 rows
7 columns


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

Msnbc 202001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_202001

43.07 KB
202 rows
7 columns


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