Baselight

Environmental News NLP Dataset

This dataset can be used to have sentimental analysis on recent environment news

@kaggle.amritvirsinghx_environmental_news_nlp_dataset

Loading...
Loading...

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

Msnbc 201407

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201407
  • 31.16 KB
  • 120 rows
  • 7 columns
Loading...

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

Msnbc 201408

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201408
  • 26.74 KB
  • 96 rows
  • 7 columns
Loading...

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

Msnbc 201409

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201409
  • 50.08 KB
  • 246 rows
  • 7 columns
Loading...

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

Msnbc 201410

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201410
  • 37.56 KB
  • 162 rows
  • 7 columns
Loading...

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

Msnbc 201411

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201411
  • 79.09 KB
  • 403 rows
  • 7 columns
Loading...

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

Msnbc 201412

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201412
  • 26.42 KB
  • 92 rows
  • 7 columns
Loading...

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

Msnbc 201501

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201501
  • 45.57 KB
  • 215 rows
  • 7 columns
Loading...

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

Msnbc 201502

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201502
  • 34.92 KB
  • 148 rows
  • 7 columns
Loading...

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

Msnbc 201503

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201503
  • 58.98 KB
  • 312 rows
  • 7 columns
Loading...

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

Msnbc 201504

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201504
  • 51.78 KB
  • 250 rows
  • 7 columns
Loading...

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

Msnbc 201505

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201505
  • 58.38 KB
  • 287 rows
  • 7 columns
Loading...

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

Msnbc 201506

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201506
  • 43.63 KB
  • 197 rows
  • 7 columns
Loading...

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

Msnbc 201507

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201507
  • 40.5 KB
  • 169 rows
  • 7 columns
Loading...

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

Msnbc 201508

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201508
  • 59.9 KB
  • 289 rows
  • 7 columns
Loading...

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

Msnbc 201509

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201509
  • 125.93 KB
  • 681 rows
  • 7 columns
Loading...

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

Msnbc 201510

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201510
  • 42.73 KB
  • 198 rows
  • 7 columns
Loading...

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

Msnbc 201511

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201511
  • 47.07 KB
  • 217 rows
  • 7 columns
Loading...

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

Msnbc 201512

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201512
  • 83.79 KB
  • 438 rows
  • 7 columns
Loading...

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

Msnbc 201601

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201601
  • 31.63 KB
  • 112 rows
  • 7 columns
Loading...

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

Msnbc 201602

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201602
  • 23.67 KB
  • 78 rows
  • 7 columns
Loading...

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

Msnbc 201603

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201603
  • 27.63 KB
  • 102 rows
  • 7 columns
Loading...

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

Msnbc 201604

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201604
  • 34.56 KB
  • 150 rows
  • 7 columns
Loading...

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

Msnbc 201605

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201605
  • 35.34 KB
  • 167 rows
  • 7 columns
Loading...

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

Msnbc 201606

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201606
  • 27.46 KB
  • 120 rows
  • 7 columns
Loading...

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

Msnbc 201607

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201607
  • 29.64 KB
  • 124 rows
  • 7 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.