Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi#start/3463/end/3498	Thu Jul 05 2018 19:57:58 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With Ali Velshi	MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi	https://archive.org/download/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi.thumbs/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi_003447.jpg	someone who believes in climate change and takes it seriously for the benefit of all of us including our children. so, i would urge you to resign before your scandals push you out. i want to bring into the conversation emily holden, politico's climate change and
https://archive.org/details/MSNBCW_20180724_060000_The_11th_Hour_With_Brian_Williams#start/3137/end/3172	Tue Jul 24 2018 06:52:32 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20180724_060000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20180724_060000_The_11th_Hour_With_Brian_Williams/MSNBCW_20180724_060000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20180724_060000_The_11th_Hour_With_Brian_Williams_003117.jpg	saying that the proposal amounts to a frontal assault on one of former president barack obama's signature regulatory programs to curb greenhouse gas emissions that contribute to climate change. washington post reports that documents that were accidentally
https://archive.org/details/MSNBCW_20180703_100000_Morning_Joe#start/9598/end/9633	Tue Jul 03 2018 12:40:13 GMT+0000 (Coordinated Universal Time)	MSNBC	Morning Joe	MSNBCW_20180703_100000_Morning_Joe	https://archive.org/download/MSNBCW_20180703_100000_Morning_Joe/MSNBCW_20180703_100000_Morning_Joe.thumbs/MSNBCW_20180703_100000_Morning_Joe_009597.jpg	doing to the environment in our country. this is my son. he loves animals. he loves clean air. he loves clean water. we deserve to have somebody who actually does protect our environment, somebody who believes in climate change and
https://archive.org/details/MSNBCW_20180706_160000_Andrea_Mitchell_Reports#start/2/end/37	Fri Jul 06 2018 16:00:17 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBCW_20180706_160000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBCW_20180706_160000_Andrea_Mitchell_Reports/MSNBCW_20180706_160000_Andrea_Mitchell_Reports.thumbs/MSNBCW_20180706_160000_Andrea_Mitchell_Reports_000058.jpg	epa administrator scott pruitt is forced to resign amid pressure from lawmakers and the sheer embarrassment factor of moments like this one. we deserve to have something about at the epa who does protect our environment, someone who believes in climate change
https://archive.org/details/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi#start/2889/end/2924	Thu Jul 05 2018 19:48:24 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With Ali Velshi	MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi	https://archive.org/download/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi.thumbs/MSNBCW_20180705_190000_MSNBC_Live_With_Ali_Velshi_002877.jpg	it will be a lot of money poured into that. yet again it will raise the temperature. and i don't mean to make a global warming climate change pun here, it will raise the temperature in what's already going to be a very hot an contentious summer. right. and it's worth noting that there
https://archive.org/details/MSNBCW_20180714_180000_MSNBC_Live_With_David_Gura#start/756/end/791	Sat Jul 14 2018 18:12:51 GMT+0000 (Coordinated Universal Time)	MSNBC	MSNBC Live With David Gura	MSNBCW_20180714_180000_MSNBC_Live_With_David_Gura	https://archive.org/download/MSNBCW_20180714_180000_MSNBC_Live_With_David_Gura/MSNBCW_20180714_180000_MSNBC_Live_With_David_Gura.thumbs/MSNBCW_20180714_180000_MSNBC_Live_With_David_Gura_000747.jpg	life. families with young children protesting everything from donald trump's immigration policies to his stance on climate change and denials of climate change and we met american protesters. one woman said the protesters
https://archive.org/details/MSNBCW_20180703_220000_The_Beat_With_Ari_Melber#start/972/end/1007	Tue Jul 03 2018 22:16:27 GMT+0000 (Coordinated Universal Time)	MSNBC	The Beat With Ari Melber	MSNBCW_20180703_220000_The_Beat_With_Ari_Melber	https://archive.org/download/MSNBCW_20180703_220000_The_Beat_With_Ari_Melber/MSNBCW_20180703_220000_The_Beat_With_Ari_Melber.thumbs/MSNBCW_20180703_220000_The_Beat_With_Ari_Melber_000957.jpg	doing to the environment of our country. this is my son, who loves animals. he loves -- he deserve to have somebody at the epa who actually protects our environment. someone who believes in climate
https://archive.org/details/MSNBCW_20180703_160000_Andrea_Mitchell_Reports#start/2471/end/2506	Tue Jul 03 2018 16:41:26 GMT+0000 (Coordinated Universal Time)	MSNBC	Andrea Mitchell Reports	MSNBCW_20180703_160000_Andrea_Mitchell_Reports	https://archive.org/download/MSNBCW_20180703_160000_Andrea_Mitchell_Reports/MSNBCW_20180703_160000_Andrea_Mitchell_Reports.thumbs/MSNBCW_20180703_160000_Andrea_Mitchell_Reports_002458.jpg	i just wanted to encourage you to resign. this is my son. he loves animals. he loves air. he loves the water. we deserve to have somebody at the epa who actually does protect our environment, somebody who believes in climate
https://archive.org/details/MSNBCW_20180724_030000_The_11th_Hour_With_Brian_Williams#start/3156/end/3191	Tue Jul 24 2018 03:52:51 GMT+0000 (Coordinated Universal Time)	MSNBC	The 11th Hour With Brian Williams	MSNBCW_20180724_030000_The_11th_Hour_With_Brian_Williams	https://archive.org/download/MSNBCW_20180724_030000_The_11th_Hour_With_Brian_Williams/MSNBCW_20180724_030000_The_11th_Hour_With_Brian_Williams.thumbs/MSNBCW_20180724_030000_The_11th_Hour_With_Brian_Williams_003147.jpg	power. they will try to remove the regulation of car emissions. emission controls saying the proposal amounts to a frontal assault on one of former president barack obama's signature regulatory programs to curb green house gas emissions that contribute to climate
https://archive.org/details/MSNBCW_20180731_000000_All_In_With_Chris_Hayes#start/2981/end/3016	Tue Jul 31 2018 00:49:56 GMT+0000 (Coordinated Universal Time)	MSNBC	All In With Chris Hayes	MSNBCW_20180731_000000_All_In_With_Chris_Hayes	https://archive.org/download/MSNBCW_20180731_000000_All_In_With_Chris_Hayes/MSNBCW_20180731_000000_All_In_With_Chris_Hayes.thumbs/MSNBCW_20180731_000000_All_In_With_Chris_Hayes_002968.jpg	nail to ignore the problem of climate change or to make it worse. and none more so than the koch political network, which has already spent tens of millions of dollars fighting action on climate change over the years. and get this, they're reportedly going to drop another $400


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