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

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