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 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201206

23.8 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

50.36 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.07 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.35 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

45.87 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

75.75 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.22 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

80.36 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

55.25 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

35.89 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.27 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.17 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

63.7 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

15.68 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

60.64 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

30.76 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

31.51 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.32 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

21.67 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

54.21 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

79.43 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

50.91 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

65.17 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

142.33 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

73.87 KB
369 rows
7 columns


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