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

18.18 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

11.25 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

24.41 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

38.75 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

27.61 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

61.41 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

46 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.91 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.95 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

25.43 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

47.01 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

21.3 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.89 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.86 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

24.26 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

32.36 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.98 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

83.8 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

93.07 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

48.16 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

49.05 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

72.08 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

44.04 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

30.37 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

31.12 kB
131 rows
7 columns

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