Home.md

@@ -201,34 +201,37 @@ PREFIX owl: <http://www.w3.org/2002/07/owl#>
 PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
 PREFIX skosxl: <http://www.w3.org/2008/05/skos-xl#>
 PREFIX org: <http://www.w3.org/ns/org#>
+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 ?concept_uri ?country_en  WHERE {
-    values ?scheme {
-     <http://publications.europa.eu/resource/authority/country/0004>
-    }
-    ?concept_uri a skos:Concept .
+SELECT distinct ?country_uri ?named_authority_code ?country_en  WHERE {
   
-    optional {
-        ?concept_uri skos:prefLabel ?c_en .
+    # 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)
     filter(lang(?c_en) = "en")
-        filter not exists {
-               ?concept_uri skos:altLabel ?altwithstar .
-            filter(contains(?altwithstar, "*"))
-        }
-        }
-     optional  { 
-        ?concept_uri skos:altLabel ?altwithstar .
-    	Bind(str(?altwithstar) as ?country_en)
-    	filter(lang(?altwithstar) = "en")
-        filter(contains(?altwithstar, "*"))
-    }
-    ?concept_uri org:hasMembership ?membership .
+     
+    # Filtering on the memberships
+    ?country_uri org:hasMembership ?membership .
     ?membership org:organization <http://publications.europa.eu/resource/authority/corporate-body/UNO> .
     ?membership org:role <http://publications.europa.eu/resource/authority/role/UN_OBSERVER>  .
     
-    filter not exists {?concept_uri owl:deprecated ?true}
+    # Filtering out the deprecated and the retired concepts
+    filter not exists {?country_uri owl:deprecated ?true}
+    filter not exists {
+    ?country_uri euvoc:status <http://publications.europa.eu/resource/authority/concept-status/RETIRED>}
+  
+  	# 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> .
+
+  
 }  order by ?country_en
+
+
 ```
 
 ####     4\.5 Disputed territories: