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 201005

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201005

22.97 kB
69 rows
7 columns

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

Msnbc 201006

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201006

23.19 kB
78 rows
7 columns

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

Msnbc 201007

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201007

26.3 kB
91 rows
7 columns

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

Msnbc 201008

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201008

26.48 kB
94 rows
7 columns

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

Msnbc 201009

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201009

27.02 kB
104 rows
7 columns

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

Msnbc 201010

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201010

22.7 kB
75 rows
7 columns

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

Msnbc 201011

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201011

33.98 kB
143 rows
7 columns

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

Msnbc 201012

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201012

30.55 kB
114 rows
7 columns

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

Msnbc 201101

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201101

29.34 kB
128 rows
7 columns

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

Msnbc 201102

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201102

17.7 kB
48 rows
7 columns

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

Msnbc 201103

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201103

23.39 kB
74 rows
7 columns

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

Msnbc 201104

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201104

28.91 kB
112 rows
7 columns

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

Msnbc 201105

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201105

22.36 kB
67 rows
7 columns

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

Msnbc 201106

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201106

41.05 kB
189 rows
7 columns

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

Msnbc 201107

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201107

16.77 kB
41 rows
7 columns

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

Msnbc 201108

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201108

48.96 kB
230 rows
7 columns

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

Msnbc 201109

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201109

27.97 kB
100 rows
7 columns

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

Msnbc 201110

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201110

26.53 kB
100 rows
7 columns

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

Msnbc 201111

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201111

39.45 kB
168 rows
7 columns

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

Msnbc 201112

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201112

41.98 kB
188 rows
7 columns

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

Msnbc 201201

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201201

26.7 kB
100 rows
7 columns

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

Msnbc 201202

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201202

19.76 kB
63 rows
7 columns

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

Msnbc 201203

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201203

26.11 kB
98 rows
7 columns

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

Msnbc 201204

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201204

26.29 kB
87 rows
7 columns

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

Msnbc 201205

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201205

14.85 kB
26 rows
7 columns

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

Msnbc 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201206

24.37 kB
87 rows
7 columns

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

Msnbc 201207

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201207

51.57 kB
271 rows
7 columns

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

Msnbc 201208

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201208

25.67 kB
91 rows
7 columns

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

Msnbc 201209

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201209

20.84 kB
59 rows
7 columns

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

Msnbc 201210

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201210

46.97 kB
203 rows
7 columns

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

Msnbc 201211

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201211

77.56 kB
362 rows
7 columns

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

Msnbc 201212

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201212

25.83 kB
86 rows
7 columns

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

Msnbc 201301

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201301

82.29 kB
389 rows
7 columns

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

Msnbc 201302

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201302

56.58 kB
253 rows
7 columns

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

Msnbc 201303

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201303

36.75 kB
150 rows
7 columns

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

Msnbc 201304

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201304

28.95 kB
111 rows
7 columns

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

Msnbc 201305

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201305

27.82 kB
102 rows
7 columns

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

Msnbc 201306

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201306

65.22 kB
305 rows
7 columns

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

Msnbc 201307

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201307

16.06 kB
32 rows
7 columns

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

Msnbc 201308

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201308

62.1 kB
324 rows
7 columns

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

Msnbc 201309

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201309

31.5 kB
136 rows
7 columns

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

Msnbc 201310

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201310

32.27 kB
131 rows
7 columns

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

Msnbc 201311

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201311

25.93 kB
95 rows
7 columns

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

Msnbc 201312

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201312

22.18 kB
63 rows
7 columns

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

Msnbc 201401

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201401

55.51 kB
280 rows
7 columns

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

Msnbc 201402

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201402

81.34 kB
409 rows
7 columns

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

Msnbc 201403

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201403

52.14 kB
222 rows
7 columns

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

Msnbc 201404

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201404

66.73 kB
334 rows
7 columns

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

Msnbc 201405

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201405

145.75 kB
754 rows
7 columns

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

Msnbc 201406

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201406

75.64 kB
369 rows
7 columns

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