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 201610

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201610

58.68 kB
298 rows
7 columns

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

Foxnews 201611

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201611

42 kB
181 rows
7 columns

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

Foxnews 201612

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201612

57.3 kB
302 rows
7 columns

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

Foxnews 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201701

50.29 kB
237 rows
7 columns

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

Foxnews 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201702

33.7 kB
160 rows
7 columns

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

Foxnews 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201703

35.65 kB
145 rows
7 columns

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

Foxnews 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201704

44.83 kB
228 rows
7 columns

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

Foxnews 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201705

47.1 kB
216 rows
7 columns

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

Foxnews 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201706

93.06 kB
494 rows
7 columns

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

Foxnews 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201707

45.84 kB
219 rows
7 columns

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

Foxnews 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201708

46.95 kB
232 rows
7 columns

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

Foxnews 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201709

50.7 kB
266 rows
7 columns

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

Foxnews 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201710

18.06 kB
42 rows
7 columns

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

Foxnews 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201711

19 kB
53 rows
7 columns

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

Foxnews 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201712

32.87 kB
126 rows
7 columns

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

Foxnews 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201801

35.65 kB
148 rows
7 columns

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

Foxnews 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201802

17.51 kB
41 rows
7 columns

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

Foxnews 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201803

18.51 kB
45 rows
7 columns

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

Foxnews 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201804

18.73 kB
45 rows
7 columns

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

Foxnews 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201805

22.81 kB
75 rows
7 columns

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

Foxnews 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201806

22.09 kB
65 rows
7 columns

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

Foxnews 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201807

19.15 kB
51 rows
7 columns

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

Foxnews 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201808

27.52 kB
92 rows
7 columns

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

Foxnews 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201809

18.57 kB
44 rows
7 columns

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

Foxnews 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201810

19.59 kB
53 rows
7 columns

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

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
);