Environmental News NLP Dataset
This dataset can be used to have sentimental analysis on recent environment news
@kaggle.amritvirsinghx_environmental_news_nlp_dataset
This dataset can be used to have sentimental analysis on recent environment news
@kaggle.amritvirsinghx_environmental_news_nlp_dataset
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
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 |
CREATE TABLE msnbc_201809 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201810 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201811 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201812 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201901 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201902 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201903 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201904 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201905 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201906 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201907 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201908 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201909 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201910 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201911 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_201912 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
CREATE TABLE msnbc_202001 (
"url" VARCHAR,
"matchdatetime" TIMESTAMP,
"station" VARCHAR,
"show" VARCHAR,
"iashowid" VARCHAR,
"iapreviewthumb" VARCHAR,
"snippet" VARCHAR
);
Anyone who has the link will be able to view this.