Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams#start/2840/end/2875	Sat Jan 18 2020 04:47:35 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams_002847.jpg	everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200114_110000_Morning_Joe#start/2073/end/2108	Tue Jan 14 2020 11:34:48 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20200114_110000_Morning_Joe	https://archive.org/download/MSNBCW_20200114_110000_Morning_Joe/MSNBCW_20200114_110000_Morning_Joe.thumbs/MSNBCW_20200114_110000_Morning_Joe_002068.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams#start/1659/end/1694	Sat Jan 18 2020 04:27:54 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20200118_040000_The_11th_Hour_With_Brian_Williams_001648.jpg	this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200101_000000#start/900/end/935	Wed Jan 01 2020 00:15:15 GMT+0000 (Coordinated Universal Time)	MSNBC	nan	MSNBCW_20200101_000000	https://archive.org/download/MSNBCW_20200101_000000/MSNBCW_20200101_000000.thumbs/MSNBCW_20200101_000000_000809.jpg	welcome back to 'hardball.' that was the united nations secretary-general speaking to head of the u.n. climate change conference earlier this month in madrid. his dire warning follows the release of a u.n. report that indicated, quote, rapid unprecedented cuts in greenhouse
https://archive.org/details/MSNBCW_20200101_000000_Hardball_With_Chris_Matthews#start/897/end/932	Wed Jan 01 2020 00:15:12 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBCW_20200101_000000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBCW_20200101_000000_Hardball_With_Chris_Matthews/MSNBCW_20200101_000000_Hardball_With_Chris_Matthews.thumbs/MSNBCW_20200101_000000_Hardball_With_Chris_Matthews_000868.jpg	welcome back to 'hardball.' that was the united nations secretary-general speaking to head of the u.n. climate change conference earlier this month in madrid. his dire warning follows the release of a u.n. report that indicated, quote, rapid unprecedented cuts in greenhouse
https://archive.org/details/MSNBCW_20200117_110000_Morning_Joe#start/5729/end/5764	Fri Jan 17 2020 12:35:44 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20200117_110000_Morning_Joe	https://archive.org/download/MSNBCW_20200117_110000_Morning_Joe/MSNBCW_20200117_110000_Morning_Joe.thumbs/MSNBCW_20200117_110000_Morning_Joe_005668.jpg	usaa. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200110_110000_Morning_Joe#start/6933/end/6968	Fri Jan 10 2020 12:55:48 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20200110_110000_Morning_Joe	https://archive.org/download/MSNBCW_20200110_110000_Morning_Joe/MSNBCW_20200110_110000_Morning_Joe.thumbs/MSNBCW_20200110_110000_Morning_Joe_006929.jpg	experience '1917'. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200116_040000_The_11th_Hour_With_Brian_Williams#start/2682/end/2717	Thu Jan 16 2020 04:44:57 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20200116_040000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20200116_040000_The_11th_Hour_With_Brian_Williams/MSNBCW_20200116_040000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20200116_040000_The_11th_Hour_With_Brian_Williams_002639.jpg	he's a baby!. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200107_110000_Morning_Joe#start/1585/end/1620	Tue Jan 07 2020 11:26:40 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20200107_110000_Morning_Joe	https://archive.org/download/MSNBCW_20200107_110000_Morning_Joe/MSNBCW_20200107_110000_Morning_Joe.thumbs/MSNBCW_20200107_110000_Morning_Joe_001528.jpg	cigna. together, all the way. this melting pot of impacted species. everywhere is going to get touched by climate change.
https://archive.org/details/MSNBCW_20200117_040000_The_11th_Hour_With_Brian_Williams#start/1737/end/1772	Fri Jan 17 2020 04:29:12 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20200117_040000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20200117_040000_The_11th_Hour_With_Brian_Williams/MSNBCW_20200117_040000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20200117_040000_The_11th_Hour_With_Brian_Williams_001738.jpg	nothing is everything ask your dermatologist about skyrizi. this melting pot of impacted species. everywhere is going to get touched by climate change.


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