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

Foxnews 201811

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201811

50.02 kB
226 rows
7 columns

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

Foxnews 201812

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201812

81.44 kB
397 rows
7 columns

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

Foxnews 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201901

49.5 kB
216 rows
7 columns

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

Foxnews 201902

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201902

108.33 kB
530 rows
7 columns

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

Foxnews 201903

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201903

129.64 kB
635 rows
7 columns

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

Foxnews 201904

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201904

72.98 kB
329 rows
7 columns

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

Foxnews 201905

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201905

66.72 kB
297 rows
7 columns

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

Foxnews 201906

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201906

81.02 kB
371 rows
7 columns

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

Foxnews 201907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201907

58.27 kB
265 rows
7 columns

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

Foxnews 201908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201908

97.28 kB
461 rows
7 columns

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

Foxnews 201909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201909

161.14 kB
810 rows
7 columns

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

Foxnews 201910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201910

53.52 kB
230 rows
7 columns

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

Foxnews 201911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201911

60.16 kB
272 rows
7 columns

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

Foxnews 201912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201912

50.37 kB
219 rows
7 columns

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

Foxnews 202001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_202001

38.56 kB
154 rows
7 columns

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

Msnbc 200907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200907

27.82 kB
90 rows
7 columns

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

Msnbc 200908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200908

33.59 kB
133 rows
7 columns

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

Msnbc 200909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200909

34.42 kB
144 rows
7 columns

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

Msnbc 200910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200910

43.98 kB
203 rows
7 columns

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

Msnbc 200911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200911

33.01 kB
123 rows
7 columns

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

Msnbc 200912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_200912

153.43 kB
787 rows
7 columns

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

Msnbc 201001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201001

28.91 kB
115 rows
7 columns

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

Msnbc 201002

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201002

59.64 kB
341 rows
7 columns

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

Msnbc 201003

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201003

29.64 kB
131 rows
7 columns

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

Msnbc 201004

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201004

57.4 kB
325 rows
7 columns

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