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 201005

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201005
  • 22.97 kB
  • 69 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201005 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201006

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201006
  • 23.19 kB
  • 78 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201006 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201007

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201007
  • 26.3 kB
  • 91 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201007 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201008

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201008
  • 26.48 kB
  • 94 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201008 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201009

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201009
  • 27.02 kB
  • 104 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201009 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201010

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201010
  • 22.7 kB
  • 75 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201010 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201011

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201011
  • 33.98 kB
  • 143 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201011 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201012

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201012
  • 30.55 kB
  • 114 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201012 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201101

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201101
  • 29.34 kB
  • 128 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201101 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201102

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201102
  • 17.7 kB
  • 48 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201102 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201103

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201103
  • 23.39 kB
  • 74 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201103 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201104

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201104
  • 28.91 kB
  • 112 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201104 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201105

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201105
  • 22.36 kB
  • 67 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201105 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201106

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201106
  • 41.05 kB
  • 189 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201106 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201107

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201107
  • 16.77 kB
  • 41 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201107 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201108

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201108
  • 48.96 kB
  • 230 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201108 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201109

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201109
  • 27.97 kB
  • 100 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201109 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201110

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201110
  • 26.53 kB
  • 100 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201110 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201111

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201111
  • 39.45 kB
  • 168 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201111 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201112

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201112
  • 41.98 kB
  • 188 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201112 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201201

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201201
  • 26.7 kB
  • 100 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201201 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201202

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201202
  • 19.76 kB
  • 63 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201202 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201203

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201203
  • 26.11 kB
  • 98 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201203 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201204

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201204
  • 26.29 kB
  • 87 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201204 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201205

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201205
  • 14.85 kB
  • 26 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201205 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201206

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201206
  • 24.37 kB
  • 87 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201206 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201207

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201207
  • 51.57 kB
  • 271 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201207 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201208

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201208
  • 25.67 kB
  • 91 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201208 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201209

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201209
  • 20.84 kB
  • 59 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201209 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201210

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201210
  • 46.97 kB
  • 203 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201210 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201211

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201211
  • 77.56 kB
  • 362 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201211 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201212

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201212
  • 25.83 kB
  • 86 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201212 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201301

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201301
  • 82.29 kB
  • 389 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201301 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201302

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201302
  • 56.58 kB
  • 253 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201302 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201303

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201303
  • 36.75 kB
  • 150 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201303 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201304

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201304
  • 28.95 kB
  • 111 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201304 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201305

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201305
  • 27.82 kB
  • 102 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201305 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201306

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201306
  • 65.22 kB
  • 305 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201306 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201307

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201307
  • 16.06 kB
  • 32 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201307 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201308

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201308
  • 62.1 kB
  • 324 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201308 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201309

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201309
  • 31.5 kB
  • 136 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201309 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201310

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201310
  • 32.27 kB
  • 131 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201310 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201311

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201311
  • 25.93 kB
  • 95 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201311 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201312

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201312
  • 22.18 kB
  • 63 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201312 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201401

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201401
  • 55.51 kB
  • 280 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201401 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201402

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201402
  • 81.34 kB
  • 409 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201402 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201403

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201403
  • 52.14 kB
  • 222 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201403 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201404

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201404
  • 66.73 kB
  • 334 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201404 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201405

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201405
  • 145.75 kB
  • 754 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201405 (
  "url" VARCHAR,
  "matchdatetime" TIMESTAMP,
  "station" VARCHAR,
  "show" VARCHAR,
  "iashowid" VARCHAR,
  "iapreviewthumb" VARCHAR,
  "snippet" VARCHAR
);

Msnbc 201406

@kaggle.amritvirsinghx_environmental_news_nlp_dataset.msnbc_201406
  • 75.64 kB
  • 369 rows
  • 7 columns
Loading...
CREATE TABLE msnbc_201406 (
  "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.