| ... | ... | @@ -128,7 +128,11 @@ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> |
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#>
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -169,7 +173,10 @@ PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#> |
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?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 {
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
|
|
|
?country_uri skos:prefLabel ?c_en . Bind(str(?c_en) as ?country_en) filter(lang(?c_en) = "en")
|
| ... | ... | @@ -229,7 +236,11 @@ PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#> |
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -269,7 +280,11 @@ PREFIX euvoc: <http://publications.europa.eu/ontology/euvoc#> |
|
|
|
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
|
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -307,7 +322,10 @@ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> |
|
|
|
PREFIX dct: <http://purl.org/dc/terms/>
|
|
|
|
|
|
|
|
SELECT distinct ?country_uri ?named_authority_code ?country_en
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
values ?scheme {
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0002>
|
|
|
|
<http://publications.europa.eu/resource/authority/country/0003>
|
| ... | ... | @@ -354,6 +372,8 @@ PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> |
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha3
|
|
|
|
?interinstitutional_style_guide_code ?ISO_31661_alpha2 ?ISO_31661_num
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
|
|
|
|
# Retrieving the current countries and their english preferred labels
|
| ... | ... | @@ -420,6 +440,8 @@ PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> |
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2
|
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the current countries, territories and marine areas, and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -478,6 +500,8 @@ PREFIX org: <http://www.w3.org/ns/org#> |
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2
|
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -543,6 +567,8 @@ PREFIX org: <http://www.w3.org/ns/org#> |
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2
|
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the countries and their english preferred labels
|
|
|
|
?country_uri a skos:Concept .
|
| ... | ... | @@ -591,3 +617,109 @@ 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:
|
|
|
|
|
|
|
|
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 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+)
|
|
|
|
|
|
|
|
- [JSON](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=application%2Fsparql-results%2Bjson&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
- [CSV](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%2Fcsv&timeout=0&debug=on&run=+Run+Query+)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
```plaintext
|
|
|
|
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#>
|
|
|
|
PREFIX org: <http://www.w3.org/ns/org#>
|
|
|
|
|
|
|
|
SELECT ?country_uri ?named_authority_code ?country_en ?country_long_en ?ISO_31661_alpha2
|
|
|
|
?ISO_31661_alpha3 ?ISO_31661_num ?start_date ?end_date ?status
|
|
|
|
|
|
|
|
from <http://publications.europa.eu/resource/authority/country>
|
|
|
|
from named <http://publications.europa.eu/resource/authority/concept-status>
|
|
|
|
|
|
|
|
WHERE {
|
|
|
|
# Retrieving the countries, territories and marine areas and their english preferred labels
|
|
|
|
?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
|
|
|
|
?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 long label in English
|
|
|
|
optional {
|
|
|
|
?country_uri skosxl:altLabel ?c_long_en .
|
|
|
|
?c_long_en dct:type <http://publications.europa.eu/resource/authority/label-type/LONGLABEL> .
|
|
|
|
?c_long_en skosxl:literalForm ?country_long_en .
|
|
|
|
filter(lang(?country_long_en) = "en")
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 2 letters 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
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the 3 digit ISO code
|
|
|
|
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> .
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the start date of the concept (available on all)
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:startDate ?start_date
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the end date of the concept (available on deprecated or retired concepts)
|
|
|
|
optional {
|
|
|
|
?country_uri euvoc:endDate ?end_date
|
|
|
|
}
|
|
|
|
|
|
|
|
# Retrieval of the status of the concept (current, deprecated or retired)
|
|
|
|
optional{
|
|
|
|
|
|
|
|
?country_uri euvoc:status ?country_status .
|
|
|
|
|
|
|
|
graph <http://publications.europa.eu/resource/authority/concept-status> {
|
|
|
|
|
|
|
|
?country_status skosxl:prefLabel ?label_status .
|
|
|
|
?label_status skosxl:literalForm ?c_status .
|
|
|
|
filter(lang(?c_status) = "en")
|
|
|
|
Bind(str(?c_status) as ?status)
|
|
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
# Removal of the 3 technical concepts : "Marine Zone", "Disputed region" and "OP_DATPRO"
|
|
|
|
filter(?named_authority_code != "XMAZ")
|
|
|
|
filter(?named_authority_code != "XDST")
|
|
|
|
filter(?named_authority_code != "OP_DATPRO")
|
|
|
|
|
|
|
|
|
|
|
|
} order by ?country_uri
|
|
|
|
```
|
|
|
|
|
