Wikidata currency information

query.sparql

SELECT ?cur ?curLabel ?code ?char ?symbol ?endTime ?countryLabel ?altLabel
WHERE 
{
  ?sign wdt:P31 wd:Q308229.
  ?sign wdt:P487 ?char .
  ?cur wdt:P489 ?sign .
  ?cur wdt:P31 wd:Q8142 .
  ?cur wdt:P498 ?code .
  OPTIONAL { ?cur wdt:P5061 ?symbol . }
  ?cur wdt:P17 ?country .
  OPTIONAL { ?cur wdt:P582 ?endTime . }
  OPTIONAL {?cur skos:altLabel ?altLabel .} FILTER (lang(?altLabel) = "[AUTO_LANGUAGE]" )

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}

SELECT ?subdivision ?subdivisionLabel ?superdivision ?superdivisionLabel ?numericValue ?faceValue
WHERE 
{
  ?subdivision wdt:P31 wd:Q11639620 .
  OPTIONAL {?superdivision wdt:P9059 ?subdivision .}
  OPTIONAL {?subdivision wdt:P1181 ?numericValue .}
  OPTIONAL {?subdivision wdt:P3934 ?faceValue .}
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}