User:Pigsonthewing/Armenia

Setup edit

Slides edit

Project Chat edit

In Armenian: Wikidata:Խորհրդարան

Properties edit

Queries edit

Museums in Yerevan edit

SELECT DISTINCT ?item ?itemLabel ?itemLabelHy ?coord WHERE {
  ?item wdt:P31/wdt:P279* wd:Q33506;
        wdt:P131 wd:Q1953;
        wdt:P625 ?coord .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
  OPTIONAL { ?item rdfs:label ?itemLabelHy FILTER( LANG( ?itemLabelHy ) = 'hy' ) } .
}
Try it!

Train stations in Armenia edit

SELECT DISTINCT ?item ?itemLabel ?itemLabelHy ?coord WHERE {
  ?item wdt:P31/wdt:P279* wd:Q55488;
        wdt:P17 wd:Q399;
        wdt:P625 ?coord .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
  OPTIONAL { ?item rdfs:label ?itemLabelHy FILTER( LANG( ?itemLabelHy ) = 'hy' ) } .
}
Try it!

Properties with Armenian label or description missing edit

Where hy is the code for the target language, Armenian, (note that it occurs twice) and en is the comparison language:

SELECT ?property ?propertyLabel ?propertyDescription ?datatype ?missingLbl ?missingDesc WHERE {
  ?property wikibase:propertyType ?datatype .
  OPTIONAL { ?property rdfs:label ?missingLbl . FILTER(LANG(?missingLbl) = 'hy') }
  OPTIONAL { ?property schema:description ?missingDesc . FILTER(LANG(?missingDesc) = 'hy') }
  FILTER(!BOUND(?missingLbl)|| !BOUND(?missingDesc)) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'hy' }
}
Try it!

As of 2018-05-19 = 4617 results

Armenian people with no Armenian label edit

SELECT ?item ?itemLabel WHERE 
{
  ?item wdt:P27 wd:Q399 .
  OPTIONAL {
    ?item rdfs:label ?label .
    FILTER(LANG(?label) = 'hy') .
  }
  FILTER(!BOUND($label)) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'hy' }
}
Try it!

As of 2018-05-19 = 448 results