| ... | ... | @@ -45,7 +45,7 @@ The triple store returns directly a CSV file (comma separated), with 6 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_alpha2+%0D%0A+++++++%3FISO_31661_alpha3+%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++++%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+%0D%0A%0D%0A&format=text%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
### 2\.0 All countries and territories available in the dataset
|
|
|
|
### 2\.0 All countries and territories available in the dataset (including historical data)
|
|
|
|
|
|
|
|
#### 2\.1 Results in HTML:
|
|
|
|
|
| ... | ... | @@ -511,12 +511,11 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?not_num dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_NUM> .
|
|
|
|
}
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
filter not exists {?country_uri owl:deprecated ?dep}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
}
|
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
#### 4\.10 Current OECD member states, their official code, their preferred labels in english and their ISO codes:
|
| ... | ... | @@ -577,12 +576,11 @@ SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 |
|
|
|
?not_num dct:type <http://publications.europa.eu/resource/authority/notation-type/ISO_3166_1_NUM> .
|
|
|
|
}
|
|
|
|
# Filtering out the deprecated and the retired concepts
|
|
|
|
filter not exists {
|
|
|
|
?country_uri owl:deprecated ?dep
|
|
|
|
}
|
|
|
|
filter not exists { ?country_uri owl:deprecated ?dep}
|
|
|
|
filter not exists {
|
|
|
|
?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
|
|
|
|
}
|
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
|
