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

57.45 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

33.29 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

44.03 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

44.22 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

79.39 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

128.65 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

127.85 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

57.58 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

57.72 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

46.6 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

73.87 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

63.32 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

40.33 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

24.56 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

20.94 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

42.14 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

15.83 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

59.33 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

69.64 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

63.46 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

45.21 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

145.31 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

167.05 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

198.47 KB
1142 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

64.56 KB
331 rows
7 columns


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