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

Cnn 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201901

36.33 kB
145 rows
7 columns

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

Cnn 201902

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201902

73.76 kB
347 rows
7 columns

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

Cnn 201903

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201903

65.9 kB
290 rows
7 columns

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

Cnn 201904

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201904

50.4 kB
205 rows
7 columns

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

Cnn 201905

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201905

69.89 kB
301 rows
7 columns

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

Cnn 201906

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201906

123.71 kB
585 rows
7 columns

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

Cnn 201907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201907

68.94 kB
330 rows
7 columns

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

Cnn 201908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201908

127.75 kB
612 rows
7 columns

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

Cnn 201909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201909

143.67 kB
701 rows
7 columns

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

Cnn 201910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201910

44.56 kB
216 rows
7 columns

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

Cnn 201911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201911

62.97 kB
328 rows
7 columns

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

Cnn 201912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201912

73.98 kB
374 rows
7 columns

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

Cnn 202001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_202001

56.24 kB
260 rows
7 columns

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

Foxnews 200907

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200907

76.34 kB
422 rows
7 columns

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

Foxnews 200908

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200908

31.68 kB
143 rows
7 columns

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

Foxnews 200909

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200909

51.14 kB
264 rows
7 columns

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

Foxnews 200910

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200910

77 kB
418 rows
7 columns

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

Foxnews 200911

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200911

88.99 kB
483 rows
7 columns

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

Foxnews 200912

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_200912

278.33 kB
1,590 rows
7 columns

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

Foxnews 201001

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201001

68.47 kB
351 rows
7 columns

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

Foxnews 201002

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201002

108.76 kB
602 rows
7 columns

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

Foxnews 201003

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201003

44.32 kB
210 rows
7 columns

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

Foxnews 201004

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201004

60.33 kB
308 rows
7 columns

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

Foxnews 201005

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201005

22.96 kB
79 rows
7 columns

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

Foxnews 201006

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201006

35.35 kB
147 rows
7 columns

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

Foxnews 201007

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201007

25.64 kB
99 rows
7 columns

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

Foxnews 201008

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201008

30.62 kB
145 rows
7 columns

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

Foxnews 201009

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201009

32.51 kB
137 rows
7 columns

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

Foxnews 201010

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201010

29.44 kB
127 rows
7 columns

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

Foxnews 201011

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201011

34.02 kB
147 rows
7 columns

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

Foxnews 201012

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201012

42.01 kB
196 rows
7 columns

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

Foxnews 201101

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201101

27 kB
100 rows
7 columns

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

Foxnews 201102

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201102

17.69 kB
49 rows
7 columns

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

Foxnews 201103

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201103

15.76 kB
35 rows
7 columns

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

Foxnews 201104

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201104

27.93 kB
104 rows
7 columns

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

Foxnews 201105

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201105

20.04 kB
60 rows
7 columns

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

Foxnews 201106

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201106

26.91 kB
101 rows
7 columns

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

Foxnews 201107

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201107

20.67 kB
62 rows
7 columns

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

Foxnews 201108

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201108

45.35 kB
231 rows
7 columns

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

Foxnews 201109

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201109

26.49 kB
102 rows
7 columns

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

Foxnews 201110

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201110

27.59 kB
114 rows
7 columns

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

Foxnews 201111

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201111

26.11 kB
100 rows
7 columns

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

Foxnews 201112

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201112

35.12 kB
162 rows
7 columns

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

Foxnews 201201

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201201

27.83 kB
104 rows
7 columns

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

Foxnews 201202

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201202

25.59 kB
92 rows
7 columns

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

Foxnews 201203

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201203

27.11 kB
95 rows
7 columns

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

Foxnews 201204

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201204

25.57 kB
86 rows
7 columns

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

Foxnews 201205

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201205

18.1 kB
44 rows
7 columns

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

Foxnews 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201206

14.55 kB
29 rows
7 columns

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

Foxnews 201207

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201207

22.44 kB
76 rows
7 columns

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