Data table via SPARQL

Speeches

Data table via SPARQL Published 21 Jun 2016 Last modified 28 Jul 2021

Code and APIs for developers

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

uri	title	created	modified	published	language	translation_of_uri	mps_code	serial_title	description	type_uri	isbn	prod_id
<http://www.eea.europa.eu/media/speeches/29-11-2005_2>	"Launch of The European Environment State and Outlook Report 2005"@en	"2005-11-29T08:45:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2014-10-16T10:56:11Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2005-11-29T08:45:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Speech by Margot Wallstr\u00c3\u00b6m, Vice-President, Institutional Relations and Communication Strategy, European Commission"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"T34QMHB9SX"
<http://www.eea.europa.eu/media/speeches/03-10-2005>	"Outlook 2005-2010: Projections and scenarios for mobility, environment, health and economy with respect to regulated pollutants and noise in EU25 and in the 31 EEA member states. Business as usual vs. sustainability scenarios"@en	"2005-10-03T12:20:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2014-10-16T10:56:10Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2005-10-03T12:20:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Speech at the Austrian Parliament, 3 October 2005"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"9NT3ODMXJR"
<http://www.eea.europa.eu/media/speeches/environmental-information-and-public-participation>	"Environmental information and public participation"@en	"2008-11-13T09:46:03Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2011-04-13T19:43:13Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2008-11-13T09:47:46Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Presentation by Prof. Jacqueline McGlade, Executive Director, European Environment Agency. The role of information in an age of climate change \u2013 An international conference to mark the 10th anniversary of the Aarhus convention, Aarhus, November 13 2008."@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"4IOP1HAK2M"
<http://www.eea.europa.eu/media/speeches/29-11-2006>	"Visions of the future for Europe - Prelude - five scenarios for 2030"@en	"2006-11-29T12:58:13Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2011-04-13T19:43:10Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2006-11-29T13:20:20Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Prof. Jacqueline McGlade's speech at Friends of Europe, Brussels, 29 November 2006"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"0NGP9T67W5"
<http://www.eea.europa.eu/media/speeches/the-european-environment-2013-state>	"The European environment \u2013 state and outlook 2010"@en	"2010-12-02T13:19:39Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2011-04-13T19:43:19Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2010-12-02T13:20:59Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Speech by Joke Schauvliege, Flemish Minister for Environment, Nature and Culture at the launch of SOER 2010 in the European Parliament, Brussels, on 30 November 2010"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"J7VH2XM3TS"
<http://www.eea.europa.eu/media/speeches/unintended-effects-the-need-for-a-proper-assessment-framework-for-agrofuels>	"Unintended effects: the need for a proper assessment framework for agrofuels"@en	"2008-01-29T14:23:41Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2011-04-13T19:43:11Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2008-02-06T23:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"EEA Executive Director, Professor Jacqueline McGlade's speech at the EEAC Workshop, Brussels, Belgium, 29 January 2008"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"8ZKPH7XJ5T"
<http://www.eea.europa.eu/media/speeches/15-12-2005>	"The 10th Anniversary of EMAS in Germany"@en	"2006-02-15T08:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2014-10-16T10:56:11Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2006-02-15T08:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Address by Professor Jacqueline McGlade, Executive Director, European Environment Agency"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"3S2Y9JX4EH"
<http://www.eea.europa.eu/media/speeches/brussels20010424>	"The role of the European Environment Agency in delivering information to support the policy process"@en	"2001-04-23T22:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2014-10-16T10:56:02Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2001-04-23T22:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"The European Environment Agency (EEA) is a European Community institution with the aim of serving the Community and the Member States with information."@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"IY9NR8PQA6"
<http://www.eea.europa.eu/media/speeches/10-11-2004>	"Conference on Changing Land Use in Europe - Getting the Picture"@en	"2004-11-11T23:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2014-10-16T10:56:08Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2004-11-11T23:00:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"Speech to EU Conference 'Changing Land Use in Europe' Kasteel Groeneveld, the Netherlands, 9-12 November 2004"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"O7GI4F02HB"
<http://www.eea.europa.eu/media/speeches/internalisation-of-external-costs-and-greening-transport>	"Internalisation of external costs and greening transport"@en	"2008-12-11T11:24:00Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2011-04-13T19:43:14Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"2008-12-11T11:29:09Z"^^<http://www.w3.org/2001/XMLSchema#dateTime>	"en"	""	"2011"@en	""	"CLECAT Freight Forwarders\u2019 Conference, 50th Anniversary.\u000d\nPresentation by Prof. Jacqueline McGlade, Executive Director, European Environment Agency, in Brussels, 3rd December 2008"@en	<http://www.eea.europa.eu/portal_types/Speech#Speech>	""	"UB437V8ZY6"

Received 91 rows in 0.041 seconds.

JSON Url:
https://eea.europa.eu./code/api/speeches/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX eea: <http://www.eea.europa.eu/ontologies.rdf#>
PREFIX amp:<http://rdfdata.eionet.europa.eu/amp/ontology/> 
PREFIX prod: <http://www.eea.europa.eu/portal_types/Speech#>
PREFIX dc: <http://purl.org/dc/terms/>
PREFIX schema: <http://schema.org/>

SELECT DISTINCT 
?subject as ?uri
?title
?created
?modified
?published
lang(?title) as ?language
?translation_of_uri
?mps_code
?serial_title
?description
?type_uri
?isbn
?prod_id
WHERE {
  ?subject a prod:Speech .
  ?subject dc:title ?title .
  ?subject dc:created ?created .
  ?subject dc:modified ?modified .
  ?subject dc:issued ?published .
  OPTIONAL { ?subject eea:isTranslationOf ?translation_of_uri } .
  OPTIONAL { ?subject prod:management_plan ?mps_code } .
  OPTIONAL { ?subject prod:serial_title ?serial_title } .
  OPTIONAL { ?subject dc:description ?description } .
  ?subject a ?type_uri .
  FILTER (?type_uri = prod:Speech)
  OPTIONAL { ?subject prod:isbn ?isbn } .
  OPTIONAL { ?subject schema:productID ?prod_id } .
}