Home.md

@@ -274,9 +274,9 @@ SELECT distinct ?concept_uri ?country_en  WHERE {
 
 **Note:** The disputed territories are also included into the results of this SPARQL query.
 
-####     4\.7 Current countries and their related ISO codes:
+####     4\.7 Current official countries (only) and their related ISO codes:
 
-The following query retrieves all the current states, their related english (preferred) labels , and their ISO codes (ISO 3166-1 alpha-2, ISO 3166-1 alpha-3, ISO 3166-1 numeric) :
+The following query retrieves all the current 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):
 
 ```plaintext
 PREFIX dct: <http://purl.org/dc/terms/> 
@@ -288,13 +288,20 @@ 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 {    
+SELECT ?country_uri ?named_authority_code ?country_en ?ISO_31661_alpha2 
+       ?ISO_31661_alpha3 ?ISO_31661_num   
+  
+  WHERE {    
     
     ?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")
     
+    ?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> .
     
     optional {
     ?country_uri euvoc:xlNotation ?not_alpha2 .
@@ -316,5 +323,9 @@ SELECT ?country_uri ?country_en ?ISO_31661_alpha2 ?ISO_31661_alpha3 ?ISO_31661_n
     filter not exists {
     ?country_uri owl:deprecated ?dep
     }
+    filter not exists {
+    ?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>
     }
+} 
+
 ```
\ No newline at end of file