|
|
|
The **"Country and territories"** dataset contains an extensive set of information that has been validated and checked to make it easier to use in a wide range of applications and context. The dataset is managed like a graph database, using dedicated storage and a specific query language to facilitate direct access via a web service. To make it easier to consult the data, it is also published in table form on the EU Vocabularies website.
|
|
|
|
|
|
|
|
The following wiki pages resume a set of links to directly retrieves the data in different formats (HTML, JSON and CSV) to help users having an easy access to their last updated version.
|
|
|
|
|
|
|
|
The CSV files can be uploaded into Excel, while the links retrieving JSON can be directly included in external systems to use the data.
|
|
|
|
|
|
|
|
**Note:** the data are directly retrieved from the triplestore of the Publications Office ([Cellar](https://publications.europa.eu/webapi/rdf/sparql)). The technical documentation attached to this page gives some information to develop any kind of custom query.
|
|
|
|
|
|
|
|
##### _The following queries retrieve the official published data directly from the main triple store of the Publication._
|
|
|
|
|
|
|
|
[[_TOC_]]
|
|
|
|
|
|
|
|
### 1\.0 - Current official countries and their related english (preferred) labels :
|
|
|
|
|
|
|
|
#### 1\.1 Results in HTML:
|
|
|
|
|
|
|
|
The results are on 2 columns :
|
|
|
|
|
|
|
|
- country_uri : the identifier of the country
|
|
|
|
- country_en : the preferred labels in English
|
|
|
|
|
|
|
|
[Current countries and territories (HTML)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 1\.2 Results in JSON:
|
|
|
|
|
|
|
|
The results have 2 fields : "country_uri" and "country_en". The values are returned as followed:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
{ "country_uri": { "type": "uri", "value": "http://publications.europa.eu/resource/authority/country/BDI" },
|
|
|
|
"country_en": { "type": "literal", "value": "Burundi" }}
|
|
|
|
```
|
|
|
|
|
|
|
|
[Current countries and territories (JSON)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 1\.3 Results in CSV for Excel:
|
|
|
|
|
|
|
|
The triple store returns directly a CSV file (comma separated), with 2 columns: country_uri and country_en.
|
|
|
|
|
|
|
|
[Current countries and territories (CSV) - for Excel](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AtopConceptOf+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E++.%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FDEPRECATED%3E%7D%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0A++++bind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0A+++++filter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 2\.0 All countries and territories available in the dataset
|
|
|
|
|
|
|
|
#### 2\.1 Results in HTML:
|
|
|
|
|
|
|
|
The results enclose all the countries and territories included the dataset (including the "deprecated" countries, which are available for historical reasons).
|
|
|
|
|
|
|
|
They are shown on 2 columns :
|
|
|
|
|
|
|
|
- country_uri : the identifier of the country
|
|
|
|
- country_en : the preferred labels in English
|
|
|
|
|
|
|
|
[Full list of countries and territories (HTML)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0Abind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0Afilter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 2\.2 Results in JSON:
|
|
|
|
|
|
|
|
The results have 2 fields : "country_uri" and "country_en". The values are returned as followed:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
{ "country_uri": { "type": "uri", "value": "http://publications.europa.eu/resource/authority/country/BDI" },
|
|
|
|
"country_en": { "type": "literal", "value": "Burundi" }}
|
|
|
|
```
|
|
|
|
|
|
|
|
[Full list of countries and territories (JSON)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0Abind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0Afilter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 2\.3 Results in CSV for Excel:
|
|
|
|
|
|
|
|
The triple store returns directly a CSV file (comma separated), with 2 columns: country_uri and country_en.
|
|
|
|
|
|
|
|
[Full list of countries and territories (CSV - for Excel)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fcountry_en++%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29+%0D%0Abind+%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29%0D%0A%0D%0Afilter+%28%3Fcountry_uri+%21%3D+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2FOP_DATPRO%3E+%29%0D%0A%7D&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 3\.0 Current EU Member states
|
|
|
|
|
|
|
|
The following queries retrieves all the current EU member states, their related english (preferred) labels and long labels, and their protocol order :
|
|
|
|
|
|
|
|
#### 3\.1 Results in HTML:
|
|
|
|
|
|
|
|
The results are set on 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](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0A%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fcountry_en+%3FlongLabel_en+%3Fprotocol_order%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++Values+%3Forganisation+%7B%0D%0A%09%09%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FEURUN%3E%0D%0A%09%7D%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A+++++%3Fcountry_uri+euvoc%3Aorder+%3Fprotocol_order+.%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Forganisation+.%0D%0A++%0D%0A%09%0D%0A++++optional+%7B%0D%0A+++++%0D%0A+++++%3Fcountry_uri+skosxl%3AaltLabel+%3Flong+.%0D%0A+++++%3Flong+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Flabel-type%2FLONGLABEL%3E+.%0D%0A+++++%0D%0A+++++%3Flong+skosxl%3AliteralForm+%3FlongLabel_en+.%0D%0A+++++%0D%0A+++++filter+%28lang%28%3FlongLabel_en%29+%3D+%22en%22%29%0D%0A+++++filter+not+exists+%7B%3Flong+euvoc%3AendDate+%3FendDate%7D%0D%0A++++%7D%0D%0A%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++Bind%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29%0D%0A+%0D%0A%7D+order+by+%3Fprotocol_order%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 3\.2 Results in JSON:
|
|
|
|
|
|
|
|
[Current EU members in JSON\](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0A%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fcountry_en+%3FlongLabel_en+%3Fprotocol_order%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++Values+%3Forganisation+%7B%0D%0A%09%09%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FEURUN%3E%0D%0A%09%7D%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A+++++%3Fcountry_uri+euvoc%3Aorder+%3Fprotocol_order+.%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Forganisation+.%0D%0A++%0D%0A%09%0D%0A++++optional+%7B%0D%0A+++++%0D%0A+++++%3Fcountry_uri+skosxl%3AaltLabel+%3Flong+.%0D%0A+++++%3Flong+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Flabel-type%2FLONGLABEL%3E+.%0D%0A+++++%0D%0A+++++%3Flong+skosxl%3AliteralForm+%3FlongLabel_en+.%0D%0A+++++%0D%0A+++++filter+%28lang%28%3FlongLabel_en%29+%3D+%22en%22%29%0D%0A+++++filter+not+exists+%7B%3Flong+euvoc%3AendDate+%3FendDate%7D%0D%0A++++%7D%0D%0A%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++Bind%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29%0D%0A+%0D%0A%7D+order+by+%3Fprotocol_order%0D%0A&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 3\.3 Results in CSV for Excel:
|
|
|
|
|
|
|
|
[Current EU members in CSV for Excel\](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0A%0D%0A%0D%0ASELECT+distinct+%3Fcountry_uri+%3Fcountry_en+%3FlongLabel_en+%3Fprotocol_order%0D%0A%0D%0AFROM++%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D%0A%0D%0AWHERE+%7B%0D%0A++++Values+%3Forganisation+%7B%0D%0A%09%09%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcorporate-body%2FEURUN%3E%0D%0A%09%7D%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A+++++%3Fcountry_uri+euvoc%3Aorder+%3Fprotocol_order+.%0D%0A++++%3Fcountry_uri+org%3AhasMembership+%3Fmembership+.%0D%0A++++%3Fmembership+org%3Aorganization+%3Forganisation+.%0D%0A++%0D%0A%09%0D%0A++++optional+%7B%0D%0A+++++%0D%0A+++++%3Fcountry_uri+skosxl%3AaltLabel+%3Flong+.%0D%0A+++++%3Flong+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Flabel-type%2FLONGLABEL%3E+.%0D%0A+++++%0D%0A+++++%3Flong+skosxl%3AliteralForm+%3FlongLabel_en+.%0D%0A+++++%0D%0A+++++filter+%28lang%28%3FlongLabel_en%29+%3D+%22en%22%29%0D%0A+++++filter+not+exists+%7B%3Flong+euvoc%3AendDate+%3FendDate%7D%0D%0A++++%7D%0D%0A%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fcountry_label_en+.%0D%0A++++Bind%28str%28%3Fcountry_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fcountry_label_en%29+%3D+%22en%22%29%0D%0A+%0D%0A%7D+order+by+%3Fprotocol_order%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 4\.0 Retrieving new information and data
|
|
|
|
|
|
|
|
**Note:** this data will only be officially published in september 2023 - they are available in ShowVoc as **Draft**.
|
|
|
|
|
|
|
|
**Note:** The following queries should be copy and paste into ShowVoc to retrieve the new information about Countries and territories which are not officially published.
|
|
|
|
|
|
|
|
**Note:** the following queries are based on [SPARQL](https://www.w3.org/TR/sparql11-query/), which is the query language for the databases based on semantics technologies.
|
|
|
|
|
|
|
|
#### 4\.1 Procedure to retrieve the data from ShowVoc:
|
|
|
|
|
|
|
|
- Access the page: https://showvoc.op.europa.eu/#/datasets/Countries_and_territories/sparql
|
|
|
|
- Copy and paste one of the following query into the text editor (replace the existing one)
|
|
|
|
- Press"Submit".
|
|
|
|
- The results appear as a list.
|
|
|
|
- On the right side, click on "Save result as..." and select the type of export you need.
|
|
|
|
- The data retrieval is automatically launched.
|
|
|
|
|
|
|
|
#### 4\.2 UN Members (English preferred labels):
|
|
|
|
|
|
|
|
The following query retrieves the 193 UN members and their english preferred labels.
|
|
|
|
|
|
|
|
```
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
|
|
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
```
|
|
|
|
|
|
|
|
#### 4\.3 UN Members (all EU languages):
|
|
|
|
|
|
|
|
The following query retrieves all the UN members with their labels in the 24 official EU languages (the header of the column are as follow : "?country_" + language tag.
|
|
|
|
```
|
|
|
|
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en ?country_bg ?country_cs ?country_da ?country_de ?country_el
|
|
|
|
?country_es ?country_et ?country_fi ?country_fr ?country_ga ?country_hr ?country_it ?country_lt
|
|
|
|
?country_lv ?country_mt ?country_nl ?country_pl ?country_pt ?country_ro ?country_sk ?country_sl ?country_sv
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en . Bind(str(?c_en) as ?country_en) filter(lang(?c_en) = "en")
|
|
|
|
?concept_uri skos:prefLabel ?c_bg . Bind(str(?c_bg) as ?country_bg) filter(lang(?c_bg) = "bg")
|
|
|
|
?concept_uri skos:prefLabel ?c_cs . Bind(str(?c_cs) as ?country_cs) filter(lang(?c_cs) = "cs")
|
|
|
|
?concept_uri skos:prefLabel ?c_da . Bind(str(?c_da) as ?country_da) filter(lang(?c_da) = "da")
|
|
|
|
?concept_uri skos:prefLabel ?c_de . Bind(str(?c_de) as ?country_de) filter(lang(?c_de) = "de")
|
|
|
|
?concept_uri skos:prefLabel ?c_el . Bind(str(?c_el) as ?country_el) filter(lang(?c_el) = "el")
|
|
|
|
?concept_uri skos:prefLabel ?c_es . Bind(str(?c_es) as ?country_es) filter(lang(?c_es) = "es")
|
|
|
|
?concept_uri skos:prefLabel ?c_et . Bind(str(?c_et) as ?country_et) filter(lang(?c_et) = "et")
|
|
|
|
?concept_uri skos:prefLabel ?c_fi . Bind(str(?c_fi) as ?country_fi) filter(lang(?c_fi) = "fi")
|
|
|
|
?concept_uri skos:prefLabel ?c_fr . Bind(str(?c_fr) as ?country_fr) filter(lang(?c_fr) = "fr")
|
|
|
|
?concept_uri skos:prefLabel ?c_ga . Bind(str(?c_ga) as ?country_ga) filter(lang(?c_ga) = "ga")
|
|
|
|
?concept_uri skos:prefLabel ?c_hr . Bind(str(?c_hr) as ?country_hr) filter(lang(?c_hr) = "hr")
|
|
|
|
?concept_uri skos:prefLabel ?c_hu . Bind(str(?c_hu) as ?country_hu) filter(lang(?c_hu) = "hu")
|
|
|
|
?concept_uri skos:prefLabel ?c_it . Bind(str(?c_it) as ?country_it) filter(lang(?c_it) = "it")
|
|
|
|
?concept_uri skos:prefLabel ?c_lt . Bind(str(?c_lt) as ?country_lt) filter(lang(?c_lt) = "lt")
|
|
|
|
?concept_uri skos:prefLabel ?c_lv . Bind(str(?c_lv) as ?country_lv) filter(lang(?c_lv) = "lv")
|
|
|
|
?concept_uri skos:prefLabel ?c_mt . Bind(str(?c_mt) as ?country_mt) filter(lang(?c_mt) = "mt")
|
|
|
|
?concept_uri skos:prefLabel ?c_nl . Bind(str(?c_nl) as ?country_nl) filter(lang(?c_nl) = "nl")
|
|
|
|
?concept_uri skos:prefLabel ?c_pl . Bind(str(?c_pl) as ?country_pl) filter(lang(?c_pl) = "pl")
|
|
|
|
?concept_uri skos:prefLabel ?c_pt . Bind(str(?c_pt) as ?country_pt) filter(lang(?c_pt) = "pt")
|
|
|
|
?concept_uri skos:prefLabel ?c_ro . Bind(str(?c_ro) as ?country_ro) filter(lang(?c_ro) = "ro")
|
|
|
|
?concept_uri skos:prefLabel ?c_sk . Bind(str(?c_sk) as ?country_sk) filter(lang(?c_sk) = "sk")
|
|
|
|
?concept_uri skos:prefLabel ?c_sl . Bind(str(?c_sl) as ?country_sl) filter(lang(?c_sl) = "sl")
|
|
|
|
?concept_uri skos:prefLabel ?c_sv . Bind(str(?c_sv) as ?country_sv) filter(lang(?c_sv) = "sv")
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
#### 4\.4 UN observers:
|
|
|
|
|
|
|
|
```
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
filter not exists {
|
|
|
|
?concept_uri skos:altLabel ?altwithstar .
|
|
|
|
filter(contains(?altwithstar, "*"))
|
|
|
|
}
|
|
|
|
}
|
|
|
|
optional {
|
|
|
|
?concept_uri skos:altLabel ?altwithstar .
|
|
|
|
Bind(str(?altwithstar) as ?country_en)
|
|
|
|
filter(lang(?altwithstar) = "en")
|
|
|
|
filter(contains(?altwithstar, "*"))
|
|
|
|
}
|
|
|
|
?concept_uri org:hasMembership ?membership .
|
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/UN_OBSERVER> .
|
|
|
|
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
#### 4\.5 Disputed territories:
|
|
|
|
|
|
|
|
```
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0004>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
?concept_uri skos:inScheme ?scheme .
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
```
|
|
|
|
|
|
|
|
#### 4\.6 Territories and marine areas:
|
|
|
|
|
|
|
|
The following query retrieves all the territories and marine areas with their labels in English.
|
|
|
|
|
|
|
|
```
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
|
|
|
|
SELECT distinct ?concept_uri ?country_en WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0002>
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0003>
|
|
|
|
}
|
|
|
|
?concept_uri a skos:Concept .
|
|
|
|
?concept_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
|
|
|
?concept_uri skos:inScheme ?scheme .
|
|
|
|
filter(lang(?c_en) = "en")
|
|
|
|
filter not exists {?concept_uri owl:deprecated ?true}
|
|
|
|
} order by ?country_en
|
|
|
|
```
|
|
|
|
|
|
|
|
**Note:** The disputed territories are also included into the results of this SPARQL query.
|
|
|
|
|
|
|
|
|
|
|
|
#### 4\.7 Current countries and their related ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current EU member states, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) :
|
|
|
|
|
|
|
|
```
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
|
|
|
|
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
|
|
|
|
PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
|
|
|
|
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
|
|
|
|
|
|
|
|
SELECT ?country_uri ?country_en ?ISO_31661_alpha2 ?ISO_31661_alpha3 ?ISO_31661_num WHERE {
|
|
|
|
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
|
filter(lang(?c_label_en) = "en")
|
|
|
|
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha2 .
|
|
|
|
?not_alpha2 rdf:value ?ISO_31661_alpha2 .
|
|
|
|
?not_alpha2 dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_ALPHA_2> .
|
|
|
|
}
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
|
|
|
?not_alpha3 dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_ALPHA_3> .
|
|
|
|
}
|
|
|
|
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_num .
|
|
|
|
?not_num rdf:value ?ISO_31661_num .
|
|
|
|
?not_num dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_NUM> .
|
|
|
|
}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
}
|
|
|
|
```
|
|
|
|
|
