Environmental News NLP Dataset

url URL	matchdatetime MatchDateTime	station Station	show Show	iashowid IAShowID	iapreviewthumb IAPreviewThumb	snippet Snippet
https://archive.org/details/MSNBC_20110408_000000_The_Last_Word#start/227/end/262	Fri Apr 08 2011 00:04:02 GMT+0000 (Coordinated Universal Time)	MSNBC	The Last Word	MSNBC_20110408_000000_The_Last_Word	https://archive.org/download/MSNBC_20110408_000000_The_Last_Word/MSNBC_20110408_000000_The_Last_Word.thumbs/MSNBC_20110408_000000_The_Last_Word_000207.jpg	prohibits funds being made available for any purpose to planned parenthood or any of its affiliates. an amendment from congressman joe barton that redefines greenhou greenhouse gases.
https://archive.org/details/MSNBC_20110422_200000_The_Dylan_Ratigan_Show#start/2780/end/2815	Fri Apr 22 2011 20:46:35 GMT+0000 (Coordinated Universal Time)	MSNBC	The Dylan Ratigan Show	MSNBC_20110422_200000_The_Dylan_Ratigan_Show	https://archive.org/download/MSNBC_20110422_200000_The_Dylan_Ratigan_Show/MSNBC_20110422_200000_The_Dylan_Ratigan_Show.thumbs/MSNBC_20110422_200000_The_Dylan_Ratigan_Show_002753.jpg	welcome back. you can see we are with bjorn lomborg. his documentary cool it is based on the premise that global warming is real, but that the debate revolves around fear of global warming, not global
https://archive.org/details/MSNBC_20110407_180000_News_Nation#start/341/end/376	Thu Apr 07 2011 18:05:56 GMT+0000 (Coordinated Universal Time)	MSNBC	News Nation	MSNBC_20110407_180000_News_Nation	https://archive.org/download/MSNBC_20110407_180000_News_Nation/MSNBC_20110407_180000_News_Nation.thumbs/MSNBC_20110407_180000_News_Nation_000326.jpg	things like that, but now the republicans in the house have come back and, as you've heard, insisting on putting riders on it that deal with abortion in the district of columbia, the environmental protection agency and greenhouse gases, and now
https://archive.org/details/MSNBC_20110408_020000_The_Ed_Show#start/604/end/639	Fri Apr 08 2011 02:10:19 GMT+0000 (Coordinated Universal Time)	MSNBC	The Ed Show	MSNBC_20110408_020000_The_Ed_Show	https://archive.org/download/MSNBC_20110408_020000_The_Ed_Show/MSNBC_20110408_020000_The_Ed_Show.thumbs/MSNBC_20110408_020000_The_Ed_Show_000595.jpg	be able to use their own money for abortions for women in the city and because they want the environmental protection agency not to be able to enforce federal law with regard to greenhouse gas emissions.
https://archive.org/details/MSNBC_20110408_050000_The_Ed_Show#start/1199/end/1234	Fri Apr 08 2011 05:20:14 GMT+0000 (Coordinated Universal Time)	MSNBC	The Ed Show	MSNBC_20110408_050000_The_Ed_Show	https://archive.org/download/MSNBC_20110408_050000_The_Ed_Show/MSNBC_20110408_050000_The_Ed_Show.thumbs/MSNBC_20110408_050000_The_Ed_Show_001195.jpg	planned parenthood is already prohibited from spending federal funds on abortions. another big one -- republicans want to prohibit the epa from regulating carbon emissions. all part of the party's obsessive denial of climate change.
https://archive.org/details/MSNBC_20110422_200000_The_Dylan_Ratigan_Show#start/3038/end/3073	Fri Apr 22 2011 20:50:53 GMT+0000 (Coordinated Universal Time)	MSNBC	The Dylan Ratigan Show	MSNBC_20110422_200000_The_Dylan_Ratigan_Show	https://archive.org/download/MSNBC_20110422_200000_The_Dylan_Ratigan_Show/MSNBC_20110422_200000_The_Dylan_Ratigan_Show.thumbs/MSNBC_20110422_200000_The_Dylan_Ratigan_Show_003023.jpg	agricultural production the best at 1.7% plus. it's a very tiny outcome that we are really talking about because the whole globe is a fairly robust system. just to be clear from my own understanding and everybody else, you're not saying that global warming shouldn't be dealt with and not saying glob…
https://archive.org/details/MSNBC_20110419_080000_The_Rachel_Maddow_Show#start/943/end/978	Tue Apr 19 2011 08:15:58 GMT+0000 (Coordinated Universal Time)	MSNBC	The Rachel Maddow Show	MSNBC_20110419_080000_The_Rachel_Maddow_Show	https://archive.org/download/MSNBC_20110419_080000_The_Rachel_Maddow_Show/MSNBC_20110419_080000_The_Rachel_Maddow_Show.thumbs/MSNBC_20110419_080000_The_Rachel_Maddow_Show_000926.jpg	sort of establishment institution and the establishment is on the side of conservatism fundamentally, and so there is this imbalance because the things -- as i'm speaking, there's 10000 youth organizers in washington for the power shift congress, which is organized around climate change,
https://archive.org/details/MSNBC_20110406_060000_Hardball_With_Chris_Matthews#start/219/end/254	Wed Apr 06 2011 06:03:54 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBC_20110406_060000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBC_20110406_060000_Hardball_With_Chris_Matthews/MSNBC_20110406_060000_Hardball_With_Chris_Matthews.thumbs/MSNBC_20110406_060000_Hardball_With_Chris_Matthews_000206.jpg	yeah, boehner, and the president looks cool as a cucumber, like i can't wait for the fight. boehner says why do i have this job? i got the tea party in one ear, the people that hate abortion, hate birth control, climate change.
https://archive.org/details/MSNBC_20110406_060000_Hardball_With_Chris_Matthews#start/49/end/84	Wed Apr 06 2011 06:01:04 GMT+0000 (Coordinated Universal Time)	MSNBC	Hardball With Chris Matthews	MSNBC_20110406_060000_Hardball_With_Chris_Matthews	https://archive.org/download/MSNBC_20110406_060000_Hardball_With_Chris_Matthews/MSNBC_20110406_060000_Hardball_With_Chris_Matthews.thumbs/MSNBC_20110406_060000_Hardball_With_Chris_Matthews_000026.jpg	afternoon. their positions were clear. the president said he was done compromising and done making cuts. boehner said the democrats have to cut more, and by the way, he said, they have to agree to scratch planned parenthood funding and any action on climate change to boot.
https://archive.org/details/MSNBC_20110413_070000_The_Last_Word#start/1099/end/1134	Wed Apr 13 2011 07:18:34 GMT+0000 (Coordinated Universal Time)	MSNBC	The Last Word	MSNBC_20110413_070000_The_Last_Word	https://archive.org/download/MSNBC_20110413_070000_The_Last_Word/MSNBC_20110413_070000_The_Last_Word.thumbs/MSNBC_20110413_070000_The_Last_Word_001075.jpg	census money. that said, there are some cuts that have very, very real effects. 390 million that helped low-income family pay energy bills, 2.9 billion for building high speed rail, but of all the cuts in the bill, the biggest ideological hit was to programs that identify climate change and


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