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: https://www.wikidata.org/w/api.php?action=wbgetentities&ids=Q107146&props=claims.
For a SQL-like syntax, Wikidata Query 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@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata