municipalities of Japan

e-stat.rq

#
# 実行場所: http://data.e-stat.go.jp/lod/sparql/
# 
PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX org:<http://www.w3.org/ns/org#> 
PREFIX dcterms:<http://purl.org/dc/terms/> 
PREFIX sacs:<http://data.e-stat.go.jp/lod/terms/sacs#> 
PREFIX sac:<http://data.e-stat.go.jp/lod/sac/> 
PREFIX sace:<http://data.e-stat.go.jp/lod/sace/> 
PREFIX sacr:<http://data.e-stat.go.jp/lod/sacr/> 
select  * 
where {
  ?currentSAC a sacs:CurrentStandardAreaCode ;
    rdfs:label ?labelen ;
    rdfs:label ?labelja .
  FILTER (lang(?labelen) = 'en')
  FILTER (lang(?labelja) = 'ja')
} 
ORDER BY DESC(?s)

wikidata-with-altlabel.rq

#
#
# 実行例: http://tinyurl.com/hfyygdu
# 
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
PREFIX wds: <http://www.wikidata.org/entity/statement/>
PREFIX wdref: <http://www.wikidata.org/reference/>
PREFIX wdv: <http://www.wikidata.org/value/>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX prv: <http://www.wikidata.org/prop/reference/value/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX wdata: <http://www.wikidata.org/wiki/Special:EntityData/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX bds: <http://www.bigdata.com/rdf/search#>
PREFIX gas: <http://www.bigdata.com/rdf/gas#>
PREFIX hint: <http://www.bigdata.com/queryHints#>
SELECT * WHERE {
  ?municipality wdt:P31/wdt:P279 wd:Q1054813 ;
    rdfs:label ?labelen ;
    rdfs:label ?labelja .
  FILTER (lang(?labelen) = 'en')
  FILTER (lang(?labelja) = 'ja')
  OPTIONAL { 
    ?municipality skos:altLabel ?altLabel .  
    FILTER (lang(?altLabel) = 'en')
  }
  SERVICE <http://wikiba.se/ontology#label> { <http://www.bigdata.com/rdf#serviceParam> <http://wikiba.se/ontology#language> "ja,en". }     
}

wikidata.rq

#
# 実行場所: https://query.wikidata.org
# 実行例: http://tinyurl.com/jf9l3us
# 
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
PREFIX wds: <http://www.wikidata.org/entity/statement/>
PREFIX wdref: <http://www.wikidata.org/reference/>
PREFIX wdv: <http://www.wikidata.org/value/>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX prv: <http://www.wikidata.org/prop/reference/value/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX wdata: <http://www.wikidata.org/wiki/Special:EntityData/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX bds: <http://www.bigdata.com/rdf/search#>
PREFIX gas: <http://www.bigdata.com/rdf/gas#>
PREFIX hint: <http://www.bigdata.com/queryHints#>
SELECT * WHERE {
  ?municipality wdt:P31/wdt:P279 wd:Q1054813 ;
    rdfs:label ?labelen ;
    rdfs:label ?labelja .
  FILTER (lang(?labelen) = 'en')
  FILTER (lang(?labelja) = 'ja')
  SERVICE <http://wikiba.se/ontology#label> { <http://www.bigdata.com/rdf#serviceParam> <http://wikiba.se/ontology#language> "ja,en". }     
}