Re: [Wikidata-l] querying wikidata for an unknown relationship between two items

Hi Matthew, You can use our experimental SPARQL endpoint http://milenio.dcc.uchile.cl/sparql. It has direct relations for all statements that have no qualifiers, and two-step relations for all statements (with or without qualifiers), which are a bit more complex but give you more power over what you can query for. Examples: If you only care for statements without qualifiers, you can use something like this: PREFIX : <http://www.wikidata.org/entity/> SELECT * WHERE { :Q5571382 ?simpleProperty :Q223243 } The result is [1], in HTML format (you can also get many other formats; see the query page). The result contains IRIs like http://www.wikidata.org/entity/P54c (note the added "c") that we currently use for these simple statement properties in RDF. You can just remove the c to get the property. If you care for qualifiers, you can ask a query that gives you all ways in which two items are connected either directly, or by a qualifier of a statement: PREFIX : <http://www.wikidata.org/entity/> SELECT ?statementProperty ?qualifierOrValueProperty WHERE { :Q5571382 ?statementProperty ?statement . ?statement a <http://www.wikidata.org/ontology#Statement> . ?statement ?qualifierOrValueProperty :Q223243 } The result is at [2]. You can see here two properties: one is the main property of the statement, one is the value or qualifier property: http://www.wikidata.org/entity/P54s, http://www.wikidata.org/entity/P54v The "s" is for statement, the "v" for value. If you have a qualifier instead of the main value, you would get a property ending in q in the second position. For example: "What has 'The Imitation Game' to do with Alan Turing?" PREFIX : <http://www.wikidata.org/entity/> SELECT ?statementProperty ?qualifierOrValueProperty WHERE { :Q14918344 ?statementProperty ?statement . ?statement a <http://www.wikidata.org/ontology#Statement> . ?statement ?qualifierOrValueProperty :Q7251 } See [3]. So this last query pattern gives you two kinds of direct relationships: "entity -> statement value" and "entity -> qualifier value". You could also ask for "statement value -> qualifier value", e.g., what has Benedict Cumberbadge to do with Alan Turing? PREFIX : <http://www.wikidata.org/entity/> SELECT ?qualifierOrValueProperty1 ?qualifierOrValueProperty2 WHERE { ?statement a <http://www.wikidata.org/ontology#Statement> . ?statement ?qualifierOrValueProperty1 :Q244674 . ?statement ?qualifierOrValueProperty2 :Q7251 } See [4]. Right now, you cannot easily say that you only want properties that are qualifiers/value properties. This will be better once we have classes for these (and other) types of properties. It's still experimental after all. Also note that this is not live data. Cheers, Markus [1] http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=PREFIX+%3A… [2] http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=PREFIX+%3A… [3] http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=PREFIX+%3A… [4] http://milenio.dcc.uchile.cl/sparql?default-graph-uri=&query=PREFIX+%3A… On 19.04.2015 08:28, English, S. Matthew wrote: