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

Foxnews 201610

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201610

58.68 kB
298 rows
7 columns

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

Foxnews 201611

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201611

42 kB
181 rows
7 columns

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

Foxnews 201612

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201612

57.3 kB
302 rows
7 columns

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

Foxnews 201701

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201701

50.29 kB
237 rows
7 columns

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

Foxnews 201702

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201702

33.7 kB
160 rows
7 columns

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

Foxnews 201703

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201703

35.65 kB
145 rows
7 columns

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

Foxnews 201704

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201704

44.83 kB
228 rows
7 columns

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

Foxnews 201705

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201705

47.1 kB
216 rows
7 columns

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

Foxnews 201706

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201706

93.06 kB
494 rows
7 columns

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

Foxnews 201707

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201707

45.84 kB
219 rows
7 columns

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

Foxnews 201708

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201708

46.95 kB
232 rows
7 columns

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

Foxnews 201709

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201709

50.7 kB
266 rows
7 columns

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

Foxnews 201710

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201710

18.06 kB
42 rows
7 columns

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

Foxnews 201711

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201711

19 kB
53 rows
7 columns

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

Foxnews 201712

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201712

32.87 kB
126 rows
7 columns

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

Foxnews 201801

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201801

35.65 kB
148 rows
7 columns

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

Foxnews 201802

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201802

17.51 kB
41 rows
7 columns

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

Foxnews 201803

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201803

18.51 kB
45 rows
7 columns

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

Foxnews 201804

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201804

18.73 kB
45 rows
7 columns

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

Foxnews 201805

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201805

22.81 kB
75 rows
7 columns

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

Foxnews 201806

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201806

22.09 kB
65 rows
7 columns

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

Foxnews 201807

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201807

19.15 kB
51 rows
7 columns

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

Foxnews 201808

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201808

27.52 kB
92 rows
7 columns

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

Foxnews 201809

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201809

18.57 kB
44 rows
7 columns

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

Foxnews 201810

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201810

19.59 kB
53 rows
7 columns

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