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

Cnn 201009

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201009

12.74 kB
19 rows
7 columns

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

Cnn 201010

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201010

16.53 kB
36 rows
7 columns

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

Cnn 201011

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201011

22.61 kB
76 rows
7 columns

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

Cnn 201012

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201012

21.91 kB
73 rows
7 columns

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

Cnn 201101

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201101

16.39 kB
36 rows
7 columns

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

Cnn 201102

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201102

9.16 kB
6 rows
7 columns

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

Cnn 201103

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201103

16.73 kB
39 rows
7 columns

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

Cnn 201104

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201104

19.49 kB
55 rows
7 columns

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

Cnn 201105

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201105

15.91 kB
35 rows
7 columns

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

Cnn 201106

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201106

18.52 kB
49 rows
7 columns

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

Cnn 201107

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201107

15.13 kB
40 rows
7 columns

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

Cnn 201108

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201108

21.48 kB
68 rows
7 columns

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

Cnn 201109

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201109

25.67 kB
94 rows
7 columns

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

Cnn 201110

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201110

18.84 kB
47 rows
7 columns

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

Cnn 201111

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201111

18.79 kB
48 rows
7 columns

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

Cnn 201112

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201112

26.21 kB
92 rows
7 columns

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

Cnn 201201

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201201

19.03 kB
53 rows
7 columns

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

Cnn 201202

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201202

15.89 kB
36 rows
7 columns

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

Cnn 201203

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201203

15.61 kB
34 rows
7 columns

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

Cnn 201204

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201204

17.2 kB
44 rows
7 columns

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

Cnn 201205

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201205

12.73 kB
21 rows
7 columns

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

Cnn 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201206

14.46 kB
33 rows
7 columns

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

Cnn 201207

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201207

20.43 kB
59 rows
7 columns

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

Cnn 201208

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201208

13.96 kB
28 rows
7 columns

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

Cnn 201209

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.cnn_201209

13.6 kB
22 rows
7 columns

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