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

Bbcnews 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201701

58.83 kB
279 rows
7 columns

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

Bbcnews 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201702

34.09 kB
168 rows
7 columns

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

Bbcnews 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201703

45.08 kB
218 rows
7 columns

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

Bbcnews 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201704

45.28 kB
206 rows
7 columns

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

Bbcnews 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201705

81.3 kB
417 rows
7 columns

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

Bbcnews 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201706

131.74 kB
683 rows
7 columns

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

Bbcnews 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201707

130.92 kB
696 rows
7 columns

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

Bbcnews 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201708

58.96 kB
297 rows
7 columns

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

Bbcnews 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201709

59.11 kB
302 rows
7 columns

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

Bbcnews 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201710

47.72 kB
255 rows
7 columns

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

Bbcnews 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201711

75.64 kB
402 rows
7 columns

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

Bbcnews 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201712

64.84 kB
345 rows
7 columns

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

Bbcnews 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201801

41.3 kB
191 rows
7 columns

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

Bbcnews 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201802

25.15 kB
91 rows
7 columns

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

Bbcnews 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201803

21.44 kB
70 rows
7 columns

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

Bbcnews 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201804

43.15 kB
193 rows
7 columns

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

Bbcnews 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201805

16.21 kB
36 rows
7 columns

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

Bbcnews 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201806

60.76 kB
299 rows
7 columns

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

Bbcnews 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201807

71.31 kB
347 rows
7 columns

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

Bbcnews 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201808

64.98 kB
337 rows
7 columns

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

Bbcnews 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201809

46.29 kB
222 rows
7 columns

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

Bbcnews 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201810

148.8 kB
812 rows
7 columns

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

Bbcnews 201811

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201811

171.06 kB
947 rows
7 columns

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

Bbcnews 201812

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201812

203.23 kB
1,142 rows
7 columns

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

Bbcnews 201901

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.bbcnews_201901

66.11 kB
331 rows
7 columns

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