Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20191015_030000_The_11th_Hour_With_Brian_Williams#start/2386/end/2421	Tue Oct 15 2019 03:40:01 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191015_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191015_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191015_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191015_030000_The_11th_Hour_With_Brian_Williams_002397.jpg	everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191022_030000_The_11th_Hour_With_Brian_Williams#start/1688/end/1723	Tue Oct 22 2019 03:28:23 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191022_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191022_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191022_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191022_030000_The_11th_Hour_With_Brian_Williams_001679.jpg	everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191003_100000_Morning_Joe#start/10328/end/10363	Thu Oct 03 2019 12:52:23 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20191003_100000_Morning_Joe	https://archive.org/download/MSNBCW_20191003_100000_Morning_Joe/MSNBCW_20191003_100000_Morning_Joe.thumbs/MSNBCW_20191003_100000_Morning_Joe_010318.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191019_030000_The_11th_Hour_With_Brian_Williams#start/1687/end/1722	Sat Oct 19 2019 03:28:22 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191019_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191019_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191019_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191019_030000_The_11th_Hour_With_Brian_Williams_001678.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191024_030000_The_11th_Hour_With_Brian_Williams#start/3309/end/3344	Thu Oct 24 2019 03:55:24 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191024_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191024_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191024_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191024_030000_The_11th_Hour_With_Brian_Williams_003298.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191008_030000_The_11th_Hour_With_Brian_Williams#start/2840/end/2875	Tue Oct 08 2019 03:47:35 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191008_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191008_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191008_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191008_030000_The_11th_Hour_With_Brian_Williams_002849.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191009_030000_The_11th_Hour_With_Brian_Williams#start/3303/end/3338	Wed Oct 09 2019 03:55:18 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20191009_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20191009_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20191009_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20191009_030000_The_11th_Hour_With_Brian_Williams_003298.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191030_000000_All_In_With_Chris_Hayes#start/2391/end/2426	Wed Oct 30 2019 00:40:06 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20191030_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20191030_000000_All_In_With_Chris_Hayes/MSNBCW_20191030_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20191030_000000_All_In_With_Chris_Hayes_002338.jpg	fidelity. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191016_000000_All_In_With_Chris_Hayes#start/3137/end/3172	Wed Oct 16 2019 00:52:32 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20191016_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20191016_000000_All_In_With_Chris_Hayes/MSNBCW_20191016_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20191016_000000_All_In_With_Chris_Hayes_003147.jpg	el niño is starting to go haywire. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20191025_230000_Hardball_With_Chris_Matthews#start/2753/end/2788	Fri Oct 25 2019 23:46:08 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20191025_230000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20191025_230000_Hardball_With_Chris_Matthews/MSNBCW_20191025_230000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20191025_230000_Hardball_With_Chris_Matthews_002758.jpg	appointments available now. this melting pot of impacted species. everywhere is going to get touched by climate change.


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