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.43 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

22.65 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

25.69 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

25.85 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

26.39 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.17 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.19 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

29.83 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

28.65 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.28 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

22.84 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.23 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

21.84 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

40.08 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.38 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

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

25.91 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

38.53 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

40.99 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.07 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.3 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

25.5 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

25.67 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.5 KB
26 rows
7 columns


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