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 201409

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201409

60.08 kB
310 rows
7 columns

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

Foxnews 201410

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201410

32.62 kB
151 rows
7 columns

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

Foxnews 201411

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201411

50.15 kB
232 rows
7 columns

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

Foxnews 201412

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201412

28.5 kB
103 rows
7 columns

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

Foxnews 201501

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201501

56.14 kB
298 rows
7 columns

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

Foxnews 201502

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201502

60.01 kB
308 rows
7 columns

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

Foxnews 201503

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201503

22.62 kB
84 rows
7 columns

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

Foxnews 201504

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201504

33.19 kB
136 rows
7 columns

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

Foxnews 201505

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201505

52.08 kB
252 rows
7 columns

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

Foxnews 201506

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201506

50.83 kB
239 rows
7 columns

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

Foxnews 201507

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201507

23.64 kB
82 rows
7 columns

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

Foxnews 201508

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201508

29.59 kB
106 rows
7 columns

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

Foxnews 201509

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201509

69.86 kB
340 rows
7 columns

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

Foxnews 201510

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201510

46.03 kB
236 rows
7 columns

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

Foxnews 201511

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201511

81.83 kB
418 rows
7 columns

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

Foxnews 201512

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201512

47.23 kB
218 rows
7 columns

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

Foxnews 201601

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201601

26.22 kB
95 rows
7 columns

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

Foxnews 201602

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201602

23.72 kB
79 rows
7 columns

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

Foxnews 201603

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201603

25.33 kB
81 rows
7 columns

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

Foxnews 201604

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201604

36.68 kB
154 rows
7 columns

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

Foxnews 201605

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201605

31.83 kB
130 rows
7 columns

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

Foxnews 201606

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201606

31.11 kB
118 rows
7 columns

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

Foxnews 201607

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201607

33.91 kB
135 rows
7 columns

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

Foxnews 201608

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201608

24.02 kB
76 rows
7 columns

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

Foxnews 201609

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201609

30.79 kB
105 rows
7 columns

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