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

57.31 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

41.02 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

55.95 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

49.11 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

32.91 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

34.81 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

43.78 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

46 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

90.87 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

44.77 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

45.85 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

49.51 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

17.64 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

18.55 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.1 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

34.82 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.1 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.08 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.29 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.27 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

21.57 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

18.7 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

26.87 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.14 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.13 KB
53 rows
7 columns


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