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 201208

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201208

17.75 KB
53 rows
7 columns


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

Foxnews 201209

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201209

10.98 KB
16 rows
7 columns


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

Foxnews 201210

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201210

23.83 KB
102 rows
7 columns


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

Foxnews 201211

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201211

37.84 KB
187 rows
7 columns


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

Foxnews 201212

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201212

26.97 KB
102 rows
7 columns


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

Foxnews 201301

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201301

59.97 KB
315 rows
7 columns


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

Foxnews 201302

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201302

44.93 KB
237 rows
7 columns


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

Foxnews 201303

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201303

37.02 KB
161 rows
7 columns


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

Foxnews 201304

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201304

20.46 KB
65 rows
7 columns


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

Foxnews 201305

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201305

24.84 KB
106 rows
7 columns


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

Foxnews 201306

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201306

45.91 KB
237 rows
7 columns


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

Foxnews 201307

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201307

20.8 KB
60 rows
7 columns


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

Foxnews 201308

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201308

32.12 KB
142 rows
7 columns


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

Foxnews 201309

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201309

25.25 KB
86 rows
7 columns


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

Foxnews 201310

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201310

23.7 KB
89 rows
7 columns


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

Foxnews 201311

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201311

31.6 KB
129 rows
7 columns


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

Foxnews 201312

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201312

31.23 KB
122 rows
7 columns


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

Foxnews 201401

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201401

81.84 KB
497 rows
7 columns


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

Foxnews 201402

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201402

90.89 KB
501 rows
7 columns


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

Foxnews 201403

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201403

47.03 KB
236 rows
7 columns


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

Foxnews 201404

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201404

47.9 KB
245 rows
7 columns


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

Foxnews 201405

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201405

70.39 KB
370 rows
7 columns


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

Foxnews 201406

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201406

43.01 KB
191 rows
7 columns


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

Foxnews 201407

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201407

29.65 KB
115 rows
7 columns


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

Foxnews 201408

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201408

30.39 KB
131 rows
7 columns


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