Hi all,
sorry if I burst in with a simple question, but... is there a tool to count how many sitelinks for a single project are there in Wikidata?
I mean, if I want to know how many (and which) items in Wikidata have a sitelink to, say, Yoruba Wikipedia, what tool do I have to use, if exists?
Thanks.
Luca Martinelli, 24/09/2013 19:40:
Hi all,
sorry if I burst in with a simple question, but... is there a tool to count how many sitelinks for a single project are there in Wikidata?
I mean, if I want to know how many (and which) items in Wikidata have a sitelink to, say, Yoruba Wikipedia, what tool do I have to use, if exists?
I don't know the answer but I agree it's a good question. Could you please file a bug asking for http://stats.wikimedia.org/EN/TablesDatabaseWikiLinks.htm to be fixed, by using the SQL dump of langlinks table instead of the XML dump? In that way it would include Wikidata sitelinks and maybe would become fast enough for being reenabled. This is the component: https://bugzilla.wikimedia.org/enter_bug.cgi?product=Analytics&component=Wikistats
Nemo
For now: https://tools.wmflabs.org/magnustools/static_data/items_per_site.20130924.ta...
SQL query used: select ips_site_id,count(*) from wb_items_per_site group by ips_site_id
For a list of all items with these links, now that might be a little long to put in an attachment...
On Tue, Sep 24, 2013 at 7:10 PM, Federico Leva (Nemo) nemowiki@gmail.comwrote:
Luca Martinelli, 24/09/2013 19:40:
Hi all,
sorry if I burst in with a simple question, but... is there a tool to count how many sitelinks for a single project are there in Wikidata?
I mean, if I want to know how many (and which) items in Wikidata have a sitelink to, say, Yoruba Wikipedia, what tool do I have to use, if exists?
I don't know the answer but I agree it's a good question. Could you please file a bug asking for <http://stats.wikimedia.org/** EN/TablesDatabaseWikiLinks.htmhttp://stats.wikimedia.org/EN/TablesDatabaseWikiLinks.htm **> to be fixed, by using the SQL dump of langlinks table instead of the XML dump? In that way it would include Wikidata sitelinks and maybe would become fast enough for being reenabled. This is the component: <https://bugzilla.wikimedia.** org/enter_bug.cgi?product=**Analytics&component=Wikistatshttps://bugzilla.wikimedia.org/enter_bug.cgi?product=Analytics&component=Wikistats
Nemo
______________________________**_________________ Wikidata-l mailing list Wikidata-l@lists.wikimedia.org https://lists.wikimedia.org/**mailman/listinfo/wikidata-lhttps://lists.wikimedia.org/mailman/listinfo/wikidata-l
2013/9/24 Magnus Manske magnusmanske@googlemail.com:
For now: https://tools.wmflabs.org/magnustools/static_data/items_per_site.20130924.ta...
SQL query used: select ips_site_id,count(*) from wb_items_per_site group by ips_site_id
For a list of all items with these links, now that might be a little long to put in an attachment...
Well, this is a beginning. :) Thank you very much, I'm bothering you a lot in these days. :)
2013/9/24 Luca Martinelli martinelliluca@gmail.com:
2013/9/24 Magnus Manske magnusmanske@googlemail.com:
https://tools.wmflabs.org/magnustools/static_data/items_per_site.20130924.ta...
SQL query used: select ips_site_id,count(*) from wb_items_per_site group by ips_site_id
For a list of all items with these links, now that might be a little long to put in an attachment...
Well, this is a beginning. :) Thank you very much, I'm bothering you a lot in these days. :)
Quick question, the file says that in Wikidata there are: 1276758 items link it.wiki, but it.wiki has "only" 1066230 articles So there are many (~210k) Wikidata items pointing to non-article pages? Or maybe there is some double counting (linking)?
C
On Tue, Sep 24, 2013 at 5:10 PM, Cristian Consonni kikkocristian@gmail.comwrote
Quick question, the file says that in Wikidata there are: 1276758 items link it.wiki, but it.wiki has "only" 1066230 articles So there are many (~210k) Wikidata items pointing to non-article pages? Or maybe there is some double counting (linking)?
C
Links can be to any page, not just articles. According to < https://it.wikipedia.org/wiki/Speciale:Statistiche%3E, there are about 3.5 million pages that could be linked to.
--Legoktm