Hi Amir, The idea that I think that you are trying to render reminds of a query I wrote some time ago that uses the number of sitelinks (which basically equates to the number of different language wikipedia articles for a given Wikidata concept) to make an ranked list (providing a rudimentary metric for linguistic "coverage") for a type.
For example, this one ranks instances of Q571 (a book). prefix schema: <http://schema.org/> prefix wd: <http://www.wikidata.org/entity/> prefix wdt: <http://www.wikidata.org/prop/direct/> SELECT ?s ?desc ?authorlabel (COUNT(DISTINCT ?sitelink) as ?linkcount) WHERE { ?s wdt:P31 wd:Q571 . ?sitelink schema:about ?s . ?s wdt:P50 ?author OPTIONAL { ?s rdfs:label ?desc filter (lang(?desc) = "en"). } OPTIONAL { ?author rdfs:label ?authorlabel filter (lang(?authorlabel) = "en"). } } GROUP BY ?s ?desc ?authorlabel ORDER BY DESC(?linkcount) Hope it helps, Christopher On 11 September 2017 at 14:00, <wikidata-requ...@lists.wikimedia.org> wrote: > Send Wikidata mailing list submissions to > wikidata@lists.wikimedia.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.wikimedia.org/mailman/listinfo/wikidata > or, via email, send a message with subject or body 'help' to > wikidata-requ...@lists.wikimedia.org > > You can reach the person managing the list at > wikidata-ow...@lists.wikimedia.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Wikidata digest..." > > > Today's Topics: > > 1. missing/existing Wikipedia articles by number of speakers > (Amir E. Aharoni) > 2. Re: [Wikimediaindia-l] New portal on Wikidata: > Wikidata:WikiProject India (Abhijeet Safai) > 3. Re: missing/existing Wikipedia articles by number of speakers > (Reem Al-Kashif) > 4. Re: missing/existing Wikipedia articles by number of speakers > (Gerard Meijssen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 10 Sep 2017 15:43:40 +0300 > From: "Amir E. Aharoni" <amir.ahar...@mail.huji.ac.il> > To: "Discussion list for the Wikidata project." > <wikidata@lists.wikimedia.org> > Subject: [Wikidata] missing/existing Wikipedia articles by number of > speakers > Message-ID: > <CACtNa8sEhyz66jm9XOzM5SAYzb3Nd2tDiqQcnxn5SxmRx91r_g@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi, > > Is there an existing tool that shows whether a Wikipedia article exists or > doesn't exist in a list of languages sorted by the number of speakers? > > For example, I'd give this tool an article name, and it would show me a > list similar to the one at the English Wikipedia article [[List of > languages by total number of speakers]], and indicating whether the article > exists or not in each language. > > If there is no such tool, I guess I could write something in SPARQL, but > I'd have to learn SPARQL first, so I'm trying to ask here :) > > Thanks! > > -- > Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי > http://aharoni.wordpress.com > “We're living in pieces, > I want to live in peace.” – T. Moore > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.wikimedia.org/pipermail/wikidata/ > attachments/20170910/2c37931c/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Sat, 9 Sep 2017 10:32:26 +0530 > From: Abhijeet Safai <abhijeet.sa...@gmail.com> > To: Wikimedia India Community list > <wikimediaindi...@lists.wikimedia.org> > Cc: "Discussion list for the Wikidata project." > <wikidata@lists.wikimedia.org> > Subject: Re: [Wikidata] [Wikimediaindia-l] New portal on Wikidata: > Wikidata:WikiProject India > Message-ID: > <CAAwPGk1+U41F0rkog7pNUc1X=X6HSq6dkQuWw-HkQ7ym_370-w@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > "This WikiProject is to coordinate the efforts to create, enhance and > populate the coverage of topics related to India including her history, > geography, culture, society, people, infrastructure, education, > demographics and anything related between India and other fields such as > science, technology, arts, entertainment etc." > > Excellent! I am extremely happy to see it. I do not know how much I will be > able to help, but I will try to help as per my time and abilities. > > -- > Dr. Abhijeet Safai > > On Sat, Sep 9, 2017 at 3:46 AM, ViswaPrabha (വിശ്വപ്രഭ) < > viswapra...@gmail.com> wrote: > > > > > Dear Wikimedians, > > > > As the month long country-wide Wikidata Training Tour by Asaf Bartov [*1] > > is in progress through several communities and cities within India, the > > term 'Wikidata' has started rolling out as a new technology buzzword > among > > Indian communities and media. > > Choosing the occasion as most befitting, some of us have opened up a new > > WikiProject portal on the Wikidata site, named WikiProject India. > > > > The page link is https://www.wikidata.org/wiki/ > Wikidata:WikiProject_India. > > > > This WikiProject is to coordinate the efforts to create, enhance and > > populate the coverage of topics related to India including her history, > > geography, culture, society, people, infrastructure, education, > > demographics and anything related between India and other fields such as > > science, technology, arts, entertainment etc. > > > > > > For now, an indicative list of topics of immediate interest are mentioned > > in the homepage. As the project grow up and get better shape, we can > expand > > the scope of the project both vertically and horizontally. > > > > A query library demonstrating some data drilling methods and samples is > > also available there. Together, we can also build up this library to its > > best form and beauty. > > > > An inspiring model to this venture was WikiProject Armenia ( > > https://www.wikidata.org/wiki/Wikidata:WikiProject_Armenia), which began > > around a year ago. We may fork and develop upon some of the work > show-cased > > there, including the model queries. > > (Building new queries based upon these are quite easy even for a > beginner!) > > > > I invite all of you too visit the project homepage. > > https://www.wikidata.org/wiki/Wikidata:WikiProject_India > > > > > > Are you interested to be among the pioneers of this project? > > Do you want to be part of a team that will build up a great national > > database that will eventually help at least one fifth of the world > > population in so many ways that we can not even predict now? > > > > If you do, if you are interested in editing and contributing to Wikidata, > > then please sign up and join the project. > > > > > > More questions and suggestions are welcome at the project's talk pages. > > > > Thanks and regards, > > > > User:Viswaprabha > > > > > > *1 . Asaf's Indian path of Wikidata conquest can be seen here: > > https://meta.wikimedia.org/wiki/User:Asaf_(WMF)/2017_ > > Technical_trainings_in_India > > > > > > > > > > _______________________________________________ > > Wikimediaindia-l mailing list > > wikimediaindi...@lists.wikimedia.org > > To unsubscribe from the list / change mailing preferences visit > > https://lists.wikimedia.org/mailman/listinfo/wikimediaindia-l > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.wikimedia.org/pipermail/wikidata/ > attachments/20170909/1c34080b/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Sun, 10 Sep 2017 18:54:26 +0300 > From: Reem Al-Kashif <reemalkas...@gmail.com> > To: "Discussion list for the Wikidata project." > <wikidata@lists.wikimedia.org> > Subject: Re: [Wikidata] missing/existing Wikipedia articles by number > of speakers > Message-ID: > <CADQP6NLbBiOLwATBJO0tyOQMj9_9+y8NB00DWfgu+-91t5LexQ@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi Amir, > > I don't think such a tool exists now. I believe a SPARQL can do it.You can > view some sparql examples and maybe personalize some of them here ( > https://m.wikidata.org/wiki/Special:MyLanguage/Wikidata: > SPARQL_query_service/queries/examples) > or you can go here (https://m.wikidata.org/wiki/Wikidata:Request_a_query), > explain what you want to do, and an amazing person will write it for you! > > Best, > Reem > > On 10 Sep 2017 14:44, "Amir E. Aharoni" <amir.ahar...@mail.huji.ac.il> > wrote: > > > Hi, > > > > Is there an existing tool that shows whether a Wikipedia article exists > or > > doesn't exist in a list of languages sorted by the number of speakers? > > > > For example, I'd give this tool an article name, and it would show me a > > list similar to the one at the English Wikipedia article [[List of > > languages by total number of speakers]], and indicating whether the > article > > exists or not in each language. > > > > If there is no such tool, I guess I could write something in SPARQL, but > > I'd have to learn SPARQL first, so I'm trying to ask here :) > > > > Thanks! > > > > -- > > Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי > > http://aharoni.wordpress.com > > “We're living in pieces, > > I want to live in peace.” – T. Moore > > > > _______________________________________________ > > Wikidata mailing list > > Wikidata@lists.wikimedia.org > > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.wikimedia.org/pipermail/wikidata/ > attachments/20170910/fc1d120c/attachment-0001.html> > > ------------------------------ > > Message: 4 > Date: Sun, 10 Sep 2017 17:58:31 +0200 > From: Gerard Meijssen <gerard.meijs...@gmail.com> > To: "Discussion list for the Wikidata project." > <wikidata@lists.wikimedia.org> > Subject: Re: [Wikidata] missing/existing Wikipedia articles by number > of speakers > Message-ID: > <CAO53wxUqe6nYDN62zWFNmCuTBNayg8KmJwFz0zoemq931kS8+Q@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hoi, > If memory serves me well, there is a tool that intends to propose articles > to write. Ask Leila Zia if it usable for any language. > > Ps the notion that a Wikipedia article has to exist is stale. It has to be > relevant in the context of the language / culture not necessarily what > other languages deem relevant > Thanks, > GerardM > > On 10 September 2017 at 14:43, Amir E. Aharoni < > amir.ahar...@mail.huji.ac.il > > wrote: > > > Hi, > > > > Is there an existing tool that shows whether a Wikipedia article exists > or > > doesn't exist in a list of languages sorted by the number of speakers? > > > > For example, I'd give this tool an article name, and it would show me a > > list similar to the one at the English Wikipedia article [[List of > > languages by total number of speakers]], and indicating whether the > article > > exists or not in each language. > > > > If there is no such tool, I guess I could write something in SPARQL, but > > I'd have to learn SPARQL first, so I'm trying to ask here :) > > > > Thanks! > > > > -- > > Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי > > http://aharoni.wordpress.com > > “We're living in pieces, > > I want to live in peace.” – T. Moore > > > > _______________________________________________ > > Wikidata mailing list > > Wikidata@lists.wikimedia.org > > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.wikimedia.org/pipermail/wikidata/ > attachments/20170910/8fbf5ec3/attachment-0001.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > ------------------------------ > > End of Wikidata Digest, Vol 70, Issue 11 > **************************************** >
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
