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

58.67 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

31.85 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

48.98 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

27.83 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

54.83 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

58.6 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.09 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

32.41 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

50.86 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

49.64 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.08 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

28.89 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

68.22 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

44.95 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

79.91 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

46.12 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

25.61 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.16 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

24.74 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

35.82 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.08 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

30.38 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.11 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

23.46 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.07 KB
105 rows
7 columns


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