Home.md

@@ -10,7 +10,7 @@ The CSV files can be uploaded into Excel, while the links retrieving JSON can be
 
 [[_TOC_]]
 
-### 1\.0 - Current official countries and their related english (preferred) labels :
+### 1\.0 - Current official countries, their related english (preferred) labels and their ISO codes:
 
 ####     1\.1 Results in HTML:
 
@@ -32,15 +32,16 @@ The SPARQL query is available under 4.7.
 As above, the results contains 6 fields. 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" }}
+{ "head": { "link": [], "vars": ["country_uri", "named_authority_code", "country_en", "ISO_31661_alpha2", "ISO_31661_alpha3", "ISO_31661_num"] },
+  "results": { "distinct": false, "ordered": true, "bindings": [
+    { "country_uri": { "type": "uri", "value": "http://publications.europa.eu/resource/authority/country/BDI" }	, "named_authority_code": { "type": "literal", "value": "BDI" }	, "country_en": { "type": "literal", "value": "Burundi" }	, "ISO_31661_alpha2": { "type": "literal", "value": "BI" }	, "ISO_31661_alpha3": { "type": "literal", "value": "BDI" }	, "ISO_31661_num": { "type": "literal", "value": "108" }} ]
 ```
 
 [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_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=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.
+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+)