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 201007

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201007

25.04 KB
99 rows
7 columns


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

Foxnews 201008

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201008

29.9 KB
145 rows
7 columns


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

Foxnews 201009

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201009

31.75 KB
137 rows
7 columns


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

Foxnews 201010

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201010

28.75 KB
127 rows
7 columns


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

Foxnews 201011

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201011

33.22 KB
147 rows
7 columns


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

Foxnews 201012

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201012

41.03 KB
196 rows
7 columns


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

Foxnews 201101

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201101

26.37 KB
100 rows
7 columns


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

Foxnews 201102

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201102

17.28 KB
49 rows
7 columns


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

Foxnews 201103

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201103

15.39 KB
35 rows
7 columns


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

Foxnews 201104

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201104

27.27 KB
104 rows
7 columns


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

Foxnews 201105

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201105

19.57 KB
60 rows
7 columns


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

Foxnews 201106

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201106

26.28 KB
101 rows
7 columns


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

Foxnews 201107

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201107

20.18 KB
62 rows
7 columns


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

Foxnews 201108

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201108

44.29 KB
231 rows
7 columns


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

Foxnews 201109

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201109

25.87 KB
102 rows
7 columns


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

Foxnews 201110

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201110

26.94 KB
114 rows
7 columns


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

Foxnews 201111

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201111

25.5 KB
100 rows
7 columns


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

Foxnews 201112

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201112

34.3 KB
162 rows
7 columns


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

Foxnews 201201

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201201

27.17 KB
104 rows
7 columns


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

Foxnews 201202

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201202

24.99 KB
92 rows
7 columns


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

Foxnews 201203

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201203

26.48 KB
95 rows
7 columns


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

Foxnews 201204

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201204

24.97 KB
86 rows
7 columns


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

Foxnews 201205

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201205

17.68 KB
44 rows
7 columns


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

Foxnews 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201206

14.21 KB
29 rows
7 columns


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

Foxnews 201207

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.foxnews_201207

21.91 KB
76 rows
7 columns


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