Home.md

@@ -99,9 +99,9 @@ The results are set on 4 columns:
 
 ### 4\.0 Retrieving new information and data
 
-**Note:** this data will only be officially published in september 2023 - they are available in ShowVoc as **Draft**.
+**Note:** this data will only be officially published in september 2023.
 
-**Note:** The following queries should be copy and paste into ShowVoc to retrieve the new information about Countries and territories which are not officially published.
+**Note:** The following queries should be copy and paste into the user interface from Cellar to retrieve the information about Countries, territories and marine areas.
 
 **Note:** the following queries are based on [SPARQL](https://www.w3.org/TR/sparql11-query/), which is the query language for the databases based on semantics technologies.
 
@@ -123,22 +123,34 @@ 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 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 ?concept_uri ?country_en WHERE {
-    values ?scheme {
-     <http://publications.europa.eu/resource/authority/country/0004>
-    }
-    ?concept_uri a skos:Concept .
-    ?concept_uri skos:prefLabel ?c_en .
+SELECT distinct ?country_uri ?named_authority_code ?country_en WHERE {
+
+    # 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") 
     
-    ?concept_uri org:hasMembership ?membership .
+    # Filtering on the memberhip to UNO
+    ?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/MEMBER>  .
     
-    filter not exists {?concept_uri owl:deprecated ?true}
-}  order by ?country_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> .
+
+    # 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>}
+
+}  order by ?country_uri
 ```
 
 ####     4\.3 UN Members (all EU languages):