I don't think the information you're looking for is available for direct
queries.
If you need data about a predetermined set of items, just use the
official Wikidata API:
s=claims.
For a SQL-like syntax, Wikidata Query <https://wdq.wmflabs.org> comes in
handy.
Il 22/05/2015 05:15, Raymond Yee ha scritto:
Is it possible to get claims made in Wikidata using
the SQL interface
to the replicas of the production databases run by Wikimedia Labs
(
https://wikitech.wikimedia.org/wiki/Help:Tool_Labs/Database)?
I see on
http://quarry.wmflabs.org/ (a service to "Run SQL queries
against Wikipedia & other databases from your browser!") queries
involving the wikidatawiki_p database -- e.g.,
http://quarry.wmflabs.org/query/3152. But I've not been able to find
queries that pull out values for Wikidata claims.
To provide a concrete example, can one write a SQL query on the
Wikimedia databases to return claims about the population of Alameda
County, California (
https://www.wikidata.org/wiki/Q107146), which was
specifically, 1,510,271 in the 2010 census?
P1082 (
https://www.wikidata.org/wiki/Property:P1082) is the population
properly. In
https://www.wikidata.org/wiki/Special:EntityData/Q107146.json, we see
the following json fragment:
P1082: [
{
id: "Q107146$8938463B-C469-4162-80F7-96DDDE1429DD",
mainsnak:
{
snaktype: "value",
property: "P1082",
datatype: "quantity",
datavalue:
{
value:
{
amount: "+1510271",
unit: "1",
upperBound: "+1510271",
lowerBound: "+1510271"
},
type: "quantity"
}
}
...
}
]
},
I've looked through the tables in wikidatawiki_p but can't find any
table that has the claim data.
So I suspect the answer is no -- that although there's lot of metadata
about Wikidata available to SQL queries on the replicas. (SQL not
mentioned in
https://www.wikidata.org/wiki/Wikidata:Data_access). Is
this correct?
Thanks,
-Raymond
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata