Publications Office of the EU
Download samples - EU Vocabularies
SPARQL samples

Downloads via SPARQL queries

Download is done by retrieving the official published data directly from the common data repository of the Publications Office (Cellar) in the specified format. The download links are direct links to the downloadable query results. HTML format opens in a table view in the browser, CSV and JSON files will be downloaded.

The CSV files can be imported into Excel (NB: don’t use ‘open with’ but open the Excel first and import data: Data/From text/CSV – select the downloaded file; import; choose the delimiter: comma; load). The links retrieving JSON can be directly included in external systems to use the data.

Asset Publisher

Only EU Member States must be listed alphabetically using the spelling of their source language. To retrieve the correct listing the protocol order attribute can be used.

For other countries and territories no specific recommendations are made. 

The following queries retrieves all the current EU member states, their related English (preferred) labels and long labels, and their protocol order:

The results are set in 4 columns:

  • ?country_uri : the identifier of the country or the territory inside the dataset
  • ?country_en : the preferred label (in English)
  • ?longLabel_en : the related long label (in English)
  • ?protocol_order: the related protocol order.

Current EU members in HTML

Current EU members in JSON

Current EU members in CSV for Excel

The following queries retrieves all the current countries, their related English (preferred) labels and their ISO codes:

The results are in 7 columns :

  • country_uri: the identifier of the country
  • country_en: the preferred labels in English
  • named_authority_code: official codes representing the country (it can be different from the ISO codes)
  • interinstitutional_style_guide_code: an alpha-2 code used in EU institutions which is the same as ISO_31661_alpha2 except for Greece and UK
  • ISO_31661_alpha2: the two-letter country codes based on ISO 3166-1
  • ISO_31661_alpha3: the three-letter country codes based on ISO 3166-1
  • ISO_31661_num: three-digit country codes based on ISO 3166-1

Current countries and territories in HTML

Current countries and territories in JSON

Current countries and territories in CSV - for Excel

The results enclose all the countries and territories included in the dataset (including the "deprecated" countries, which are available for historical reasons).

They are shown in 2 columns :

  • country_uri : the identifier of the country
  • country_en : the preferred labels in English

Full list of countries and territories in HTML

Full list of countries and territories in JSON

Full list of countries and territories in CSV - for Excel