Hello.
I want to ask, is there a table in Toolforge DB replicas, that contains data from Wikidata items? I want to gather some statistics about FA/GA in all wikipedias and want to know, how to get this data in machine-readable form. I read https://www.mediawiki.org/wiki/Wikibase/Schema , but didn't understand if any of these tables contains the data I need. If this data can be obtained through API ( https://www.wikidata.org/wiki/Special:ApiSandbox ), it will be useful too.
user:MBH@ruwiki
Hello Max,
Most of Wikidata items content is not stored in the SQL database. There is a SPARQL endpoint called the "Wikidata Query Service" that allows to do such queries easily.
For example here is the query that allows to get the number of quality article per wiki: http://tinyurl.com/ydz56lnb
The Wikidata Query Service help is here: https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_H...
I hope it helps.
Cheers,
Thomas
Le lun. 28 janv. 2019 à 12:26, max mbhwik@gmail.com a écrit :
Hello.
I want to ask, is there a table in Toolforge DB replicas, that contains data from Wikidata items? I want to gather some statistics about FA/GA in all wikipedias and want to know, how to get this data in machine-readable form. I read https://www.mediawiki.org/wiki/Wikibase/Schema , but didn't understand if any of these tables contains the data I need. If this data can be obtained through API ( https://www.wikidata.org/wiki/Special:ApiSandbox ), it will be useful too.
user:MBH@ruwiki
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
Thanks. My query is too complicated for me to do it myself, so I create a request
https://www.wikidata.org/wiki/Wikidata:Request_a_query#Entities_with_most_fe...
If someone in this mailing list can perform this request, that would be great.
28.01.2019 18:37, Thomas Pellissier Tanon пишет:
Hello Max,
Most of Wikidata items content is not stored in the SQL database. There is a SPARQL endpoint called the "Wikidata Query Service" that allows to do such queries easily.
For example here is the query that allows to get the number of quality article per wiki: http://tinyurl.com/ydz56lnb
The Wikidata Query Service help is here: https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/Wikidata_Query_H...
I hope it helps.
Cheers,
Thomas
Le lun. 28 janv. 2019 à 12:26, max mbhwik@gmail.com a écrit :
Hello.
I want to ask, is there a table in Toolforge DB replicas, that contains data from Wikidata items? I want to gather some statistics about FA/GA in all wikipedias and want to know, how to get this data in machine-readable form. I read https://www.mediawiki.org/wiki/Wikibase/Schema , but didn't understand if any of these tables contains the data I need. If this data can be obtained through API ( https://www.wikidata.org/wiki/Special:ApiSandbox ), it will be useful too.
user:MBH@ruwiki
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
Wikidata-tech mailing list Wikidata-tech@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-tech
wikidata-tech@lists.wikimedia.org