|
|
|
The **"Countries 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 **"Countries 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 as 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 displayed in a 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 following wiki pages resume a set of links to directly retrieve the data in different formats (HTML, JSON and CSV) to help users having an easy access to the 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.
|
|
|
|
The CSV files can be loaded 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.
|
|
|
|
|
| ... | ... | @@ -10,7 +10,7 @@ The CSV files can be uploaded into Excel, while the links retrieving JSON can be |
|
|
|
|
|
|
|
[[_TOC_]]
|
|
|
|
|
|
|
|
### 1\.0 - Current countries, their related english (preferred) labels and their ISO codes:
|
|
|
|
### 1\.0 - Current countries and territories issuing citizenship, their English (preferred) label and their ISO codes:
|
|
|
|
|
|
|
|
#### 1\.1 Results in HTML:
|
|
|
|
|
| ... | ... | @@ -18,15 +18,15 @@ The results are on 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)
|
|
|
|
- named_authority_code: same as ISO_31661_alpha3 when exists, or a user-assigned alpha-3 code when there is no ISO code
|
|
|
|
- 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
|
|
|
|
- ISO_31661_alpha2: the two-letter country code based on ISO 3166-1
|
|
|
|
- ISO_31661_alpha3: the three-letter country code based on ISO 3166-1
|
|
|
|
- ISO_31661_num: three-digit country code based on ISO 3166-1
|
|
|
|
|
|
|
|
The SPARQL query is available under 4.7.
|
|
|
|
|
|
|
|
[Current countries and territories (HTML)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
[Current countries and territories issuing citizenship (HTML)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%0D%0A&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
#### 1\.2 Results in JSON:
|
|
|
|
|
| ... | ... | @@ -38,13 +38,13 @@ As above, the results contains 7 fields. The values are returned as followed: |
|
|
|
{ "country_uri": { "type": "uri", "value": "http://publications.europa.eu/resource/authority/country/AFG" } , "named_authority_code": { "type": "literal", "value": "AFG" } , "country_en": { "type": "literal", "value": "Afghanistan" } , "ISO_31661_alpha3": { "type": "literal", "value": "AFG" } , "interinstitutional_style_guide_code": { "type": "literal", "value": "AF" } , "ISO_31661_alpha2": { "type": "literal", "value": "AF" } , "ISO_31661_num": { "type": "literal", "value": "004" }} ]
|
|
|
|
```
|
|
|
|
|
|
|
|
[Current countries and territories (JSON)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%0D%0A&format=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
[Current countries and territories issuing citizenship (JSON)](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%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 7 columns.
|
|
|
|
|
|
|
|
[Current countries and territories (CSV) - for Excel](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
[Current countries and territories issuing citizenship (CSV) - for Excel](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=PREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E+%0D%0APREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0A%0D%0ASELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3FISO_31661_alpha3++%0D%0A+++++++%3Finterinstitutional_style_guide_code+%3FISO_31661_alpha2+%3FISO_31661_num+%0D%0A++%0D%0A++WHERE+%7B++++%0D%0A%0D%0A++++%23+Retrieving+the+current+countries+and+their+english+preferred+labels%0D%0A++++%3Fcountry_uri+a+skos%3AConcept+.%0D%0A++++%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%2F0001%3E+.%0D%0A++++%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.%0D%0A++++Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.%0D%0A++++filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29%0D%0A++++%0D%0A++++%23+Retrieval+of+the+EU+official+code%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.%0D%0A++++%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.%0D%0A++++%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.%0D%0A++++%0D%0A++++%23+Retrieving+the+2+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.%0D%0A++++%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.%0D%0A++++%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Retrieving+the+3+alpha+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.%0D%0A++++%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.%0D%0A++++%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.%0D%0A++++%7D%0D%0A++++%0D%0A++++%23+Retrieving+the+numerical+ISO+codes+%28if+available%29%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.%0D%0A++++%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.%0D%0A++++%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23retrieving+the+codes+used+into+the+interinstitutional+style+guide+%0D%0A++++optional+%7B%0D%0A++++%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_style+.%0D%0A++++%3Fnot_style+rdf%3Avalue+%3Finterinstitutional_style_guide_code+.%0D%0A++++%3Fnot_style+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISG_COU%3E+.%0D%0A++++%7D%0D%0A%0D%0A++++%23+Filtering+out+the+deprecated+and+the+retired+concepts%0D%0A++++filter+not+exists+%7B%3Fcountry_uri+owl%3Adeprecated+%3Fdep%7D%0D%0A++++filter+not+exists+%7B%0D%0A++++%3Fcountry_uri+euvoc%3Astatus+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%2FRETIRED%3E%7D%0D%0A%7D+order+by+%3Fcountry_uri%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 2\.0 All countries and territories available in the dataset (including historical data)
|
|
|
|
|
| ... | ... | @@ -78,7 +78,7 @@ The triple store returns directly a CSV file (comma separated), with 2 columns: |
|
|
|
|
|
|
|
### 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 :
|
|
|
|
The following queries retrieves all the current EU member states, their English (preferred) labels and long labels, and their protocol order:
|
|
|
|
|
|
|
|
#### 3\.1 Results in HTML:
|
|
|
|
|
| ... | ... | @@ -86,8 +86,8 @@ 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.
|
|
|
|
- ?longLabel_en : the long label (in English)
|
|
|
|
- ?protocol_order: the 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+)
|
|
|
|
|
| ... | ... | @@ -101,8 +101,6 @@ The results are set on 4 columns: |
|
|
|
|
|
|
|
### 4\.0 Retrieving new information and data
|
|
|
|
|
|
|
|
**Note:** this data will only be officially published in september 2023.
|
|
|
|
|
|
|
|
**Note:** The following queries should be copy and paste into the user interface from Cellar to retrieve the information about Countries, territories and marine areas.
|
|
|
|
|
|
|
|
**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.
|
| ... | ... | @@ -116,7 +114,7 @@ The results are set on 4 columns: |
|
|
|
- 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):
|
|
|
|
#### 4\.2 UN members (English preferred labels):
|
|
|
|
|
|
|
|
The following query retrieves the 193 UN members and their english preferred labels.
|
|
|
|
|
| ... | ... | @@ -135,7 +133,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
# Retrieving the countries and their English preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
| ... | ... | @@ -146,7 +144,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
|
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
| ... | ... | @@ -159,7 +157,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
|
|
|
|
#### 4\.3 UN Members (all EU languages):
|
|
|
|
#### 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.
|
|
|
|
|
| ... | ... | @@ -226,7 +224,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en ?country_bg ?coun |
|
|
|
|
|
|
|
#### 4\.4 UN observers:
|
|
|
|
|
|
|
|
The following query retrieves the 2 UN observers and their english preferred labels.
|
|
|
|
The following query retrieves the 2 UN observers and their English preferred labels.
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX owl: <http://www.w3.org/2002/07/owl#>
|
| ... | ... | @@ -243,7 +241,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
# Retrieving the countries and their English preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
| ... | ... | @@ -287,7 +285,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
# Retrieving the concepts and their English preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
|
|
filter(lang(?c_en) = "en")
|
| ... | ... | @@ -301,7 +299,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
| ... | ... | @@ -332,7 +330,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
<http://publications.europa.eu/resource/authority/country/0003>
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the territories and the marine areas, and their english preferred labels
|
|
|
|
# Retrieving the territories and the marine areas, and their English preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en .
|
|
|
|
Bind(str(?c_en) as ?country_en)
|
| ... | ... | @@ -346,7 +344,7 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
| ... | ... | @@ -356,9 +354,9 @@ SELECT distinct ?country_uri ?named_authority_code ?country_en |
|
|
|
|
|
|
|
**Note:** The disputed territories are also included into the results of this SPARQL query.
|
|
|
|
|
|
|
|
#### 4\.7 Current countries, their related ISO and Interinstitutional Style Guide codes:
|
|
|
|
#### 4\.7 Current countries and territories issuing citizenship; their ISO and Interinstitutional Style Guide codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current states, their official codes, their related english (preferred) labels , their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric), and their Interinstitutional Style Guide (ISG) codes:
|
|
|
|
The following query retrieves all the current concepts, their authority code, English preferred label (short form), their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric), and their Interinstitutional Style Guide (ISG) code:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | ... | @@ -377,40 +375,40 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha3 |
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the current countries and their english preferred labels
|
|
|
|
# Retrieving the current concepts of the concept scheme 0001 and their English preferred label
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:inScheme <http://publications.europa.eu/resource/authority/country/0001> .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
|
filter(lang(?c_label_en) = "en")
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
|
|
|
|
|
|
|
# Retrieving the 2 alpha ISO codes (if available)
|
|
|
|
# Retrieving the alpha-2 ISO code (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the 3 alpha ISO codes (if available)
|
|
|
|
# Retrieving the alpha-3 ISO code (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the numerical ISO codes (if available)
|
|
|
|
# Retrieving the numerical ISO code (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
#retrieving the codes used into the interinstitutional style guide
|
|
|
|
#retrieving the code used in the ISG
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_style .
|
|
|
|
?not_style rdf:value ?interinstitutional_style_guide_code .
|
| ... | ... | @@ -426,7 +424,7 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha3 |
|
|
|
|
|
|
|
#### 4\.8 Current countries, territories and marines areas and their related ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current states, territories and marine areas, their official codes, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exists :
|
|
|
|
The following query retrieves all the current countries, territories and marine areas, their authority code, their English preferred label and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exist:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | ... | @@ -444,7 +442,7 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the current countries, territories and marine areas, and their english preferred labels
|
|
|
|
# Retrieving the current countries, territories and marine areas, and their English preferred label
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
| ... | ... | @@ -455,14 +453,14 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
|
|
|
|
|
|
|
# Retrieving the 2 alpha ISO codes (if available)
|
|
|
|
# Retrieving the alpha-2 ISO codes (if available)
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieving the 3 alpha ISO codes (if available)
|
|
|
|
# Retrieving the alpha-3 ISO codes (if available)
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
| ... | ... | @@ -483,9 +481,9 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
#### 4\.9 Current EU member states, their official code, their preferred labels in english and their ISO codes:
|
|
|
|
#### 4\.9 Current EU member states, their authority code, preferred labels in English and their ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current EU member states, their official codes, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exists :
|
|
|
|
The following query retrieves all the current EU member states, their authority code, their English preferred label, and ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exist:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | ... | @@ -517,19 +515,19 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
filter not exists {?membership euvoc:exitDate ?end }
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
|
|
|
|
|
|
|
# Retrieval of the 2 letters ISO code
|
|
|
|
# Retrieval of the 2 lettes ISO code
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 3 letters ISO code
|
|
|
|
# Retrieval of the 3 letter ISO code
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
| ... | ... | @@ -550,9 +548,9 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
#### 4\.10 Current OECD member states, their official code, their preferred labels in english and their ISO codes:
|
|
|
|
#### 4\.10 Current OECD member states, their authority code, their preferred label in English and their ISO codes:
|
|
|
|
|
|
|
|
The following query retrieves all the current OECD member states, their official codes, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exists :
|
|
|
|
The following query retrieves all the current OECD member states, their authority code, their English preferred labels, and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) if they exist:
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
| ... | ... | @@ -571,7 +569,7 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
# Retrieving the countries and their English preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:topConceptOf <http://publications.europa.eu/resource/authority/country> .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
| ... | ... | @@ -584,19 +582,19 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?membership org:role <http://publications.europa.eu/resource/authority/role/MEMBER> .
|
|
|
|
filter not exists {?membership euvoc:exitDate ?end }
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
|
|
|
|
|
|
|
# Retrieval of the 2 letters ISO code
|
|
|
|
# Retrieval of the 2 letter ISO code
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 3 letters ISO code
|
|
|
|
# Retrieval of the 3 letter ISO code
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
| ... | ... | @@ -618,9 +616,9 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
|
|
|
|
#### 4\.11 All countries, territories and marine areas, their official code, their preferred labels in english, their ISO codes and their status:
|
|
|
|
#### 4\.11 All countries, territories and marine areas, their authority code, their preferred label in English, their ISO codes and their status:
|
|
|
|
|
|
|
|
The following query retrieves all the concepts into the dataset (including the deprecated and the retired ones), their official codes, their related english preferred and long labels, their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric), their start and end dates, and their status (current, deprecated or retired) :
|
|
|
|
The following query retrieves all the concepts of the dataset (including the deprecated and the retired ones), their authority code, their English preferred and long label, ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric), start and end dates, and their status (current, deprecated or retired) :
|
|
|
|
|
|
|
|
The results can be directly retrieve using the following links:
|
|
|
|
- [HTML](https://publications.europa.eu/webapi/rdf/sparql?default-graph-uri=&query=+%0DPREFIX+dct%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E++%0DPREFIX+euvoc%3A+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fontology%2Feuvoc%23%3E+%0DPREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E+%0DPREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E+%0DPREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E+%0DPREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E+%0DPREFIX+skosxl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2008%2F05%2Fskos-xl%23%3E+%0DPREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E+%0DPREFIX+org%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Forg%23%3E+%0D+%0DSELECT+%3Fcountry_uri+%3Fnamed_authority_code+%3Fcountry_en+%3Fcountry_long_en+%3FISO_31661_alpha2++%0D+%3FISO_31661_alpha3+%3FISO_31661_num+%3Fstart_date+%3Fend_date+%3Fstatus+%0D+%0D+from+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+%0D+from+named+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%3E+%0D+%0D+WHERE+%7B++%0D+%23+Retrieving+the+countries,+territories+and+marine+areas+and+their+english+preferred+labels+%0D%0A+%0D+%3Fcountry_uri+a+skos%3AConcept+.+%0D+%3Fcountry_uri+skos%3AinScheme+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fcountry%3E+.+%0D+%3Fcountry_uri+skos%3AprefLabel+%3Fc_label_en+.+%0D+Bind%28str%28%3Fc_label_en%29+as+%3Fcountry_en%29+.+%0D+filter%28lang%28%3Fc_label_en%29+%3D+%22en%22%29+%0D++%0D+%23+Retrieval+of+the+EU+official+code+%0D%0A+%0D+%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_authority+.+%0D+%3Fnot_authority+rdf%3Avalue+%3Fnamed_authority_code+.+%0D+%3Fnot_authority+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FNAC%3E+.+%0D++%0D+%23+Retrieval+of+the+long+label+in+English+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+skosxl%3AaltLabel+%3Fc_long_en+.+%0D+%3Fc_long_en+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Flabel-type%2FLONGLABEL%3E+.+%0D+%3Fc_long_en+skosxl%3AliteralForm+%3Fcountry_long_en+.+%0D+filter%28lang%28%3Fcountry_long_en%29+%3D+%22en%22%29+%0D+%7D+%0D+%0D+%23+Retrieval+of+the+2+letters+ISO+code+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha2+.+%0D+%3Fnot_alpha2+rdf%3Avalue+%3FISO_31661_alpha2+.+%0D+%3Fnot_alpha2+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_2%3E+.+%0D+%7D+%0D++%0D+%23+Retrieval+of+the+3+letters+ISO+code+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_alpha3+.+%0D+%3Fnot_alpha3+rdf%3Avalue+%3FISO_31661_alpha3+.+%0D+%3Fnot_alpha3+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_ALPHA_3%3E+.+%0D+%7D+%0D++%0D+%23+Retrieval+of+the+3+digit+ISO+code+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+euvoc%3AxlNotation+%3Fnot_num+.+%0D+%3Fnot_num+rdf%3Avalue+%3FISO_31661_num+.+%0D+%3Fnot_num+dct%3Atype+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fnotation-type%2FISO_3166_1_NUM%3E+.+%0D+%7D+%0D+%0D+%23+Retrieval+of+the+start+date+of+the+concept+%28available+on+all%29+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+euvoc%3AstartDate+%3Fstart_date+%0D+%7D+%0D+%0D+%23+Retrieval+of+the+end+date+of+the+concept+%28available+on+deprecated+or+retired+concepts%29+%0D%0A+%0D+optional+%7B+%0D+%3Fcountry_uri+euvoc%3AendDate+%3Fend_date++%0D+%7D+%0D+%0D+%23+Retrieval+of+the+status+of+the+concept+%28current,+deprecated+or+retired%29+%0D%0A+%0D+optional%7B+%0D++%0D+%3Fcountry_uri+euvoc%3Astatus+%3Fcountry_status+.+%0D+%0D+graph+%3Chttp%3A%2F%2Fpublications.europa.eu%2Fresource%2Fauthority%2Fconcept-status%3E+%7B+%0D+%0D+%3Fcountry_status+skosxl%3AprefLabel+%3Flabel_status+.+%0D+%3Flabel_status+skosxl%3AliteralForm+%3Fc_status+.+%0D+filter%28lang%28%3Fc_status%29+%3D+%22en%22%29+%0D+Bind%28str%28%3Fc_status%29+as+%3Fstatus%29+%0D+%7D+%0D+%0D+%7D+%0D+%0D+%23+Removal+of+the+3+technical+concepts+%3A+%22Marine+Zone%22,+%22Disputed+region%22+and+%22OP_DATPRO%22+%0D%0A+%0D+filter%28%3Fnamed_authority_code+!%3D+%22XMAZ%22%29+%0D+filter%28%3Fnamed_authority_code+!%3D+%22XDST%22%29+%0D+filter%28%3Fnamed_authority_code+!%3D+%22OP_DATPRO%22%29+%0D+%0D+%0D%7D+order+by+%3Fcountry_uri+%0D+%0D&format=text%2Fhtml&timeout=0&debug=on&run=+Run+Query+)
|
| ... | ... | @@ -649,14 +647,14 @@ SELECT ?country_uri ?named_authority_code ?country_en ?country_long_en ?ISO_3166 |
|
|
|
from named <http://publications.europa.eu/resource/authority/concept-status>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the countries, territories and marine areas and their english preferred labels
|
|
|
|
# Retrieving the countries, territories and marine areas and their English preferred label
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:inScheme <http://publications.europa.eu/resource/authority/country> .
|
|
|
|
?country_uri skos:prefLabel ?c_label_en .
|
|
|
|
Bind(str(?c_label_en) as ?country_en) .
|
|
|
|
filter(lang(?c_label_en) = "en")
|
|
|
|
|
|
|
|
# Retrieval of the EU official code
|
|
|
|
# Retrieval of the authority code
|
|
|
|
?country_uri euvoc:xlNotation ?not_authority .
|
|
|
|
?not_authority rdf:value ?named_authority_code .
|
|
|
|
?not_authority dct:type <http://publications.europa.eu/resource/authority/notation-type/NAC> .
|
| ... | ... | @@ -669,14 +667,14 @@ SELECT ?country_uri ?named_authority_code ?country_en ?country_long_en ?ISO_3166 |
|
|
|
filter(lang(?country_long_en) = "en")
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 2 letters ISO code
|
|
|
|
# Retrieval of the 2 letter ISO code
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 3 letters ISO code
|
|
|
|
# Retrieval of the 3 letter ISO code
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:xlNotation ?not_alpha3 .
|
|
|
|
?not_alpha3 rdf:value ?ISO_31661_alpha3 .
|
| ... | ... | |
| ... | ... | |
