Thanks to everyone who added their answers - this all did the trick! :) On Mon, Nov 9, 2015 at 1:59 PM, Tom Morris <[email protected]> wrote:
> This StackExchange answer describes how to get site links: > > > http://opendata.stackexchange.com/questions/6050/get-wikipedia-urls-sitelinks-in-wikidata-sparql-query# > > You could graft in the appropriate clause from that answer to get enwiki > sitelinks. It looks like there are a total of 37092 Twitter handles, of > which 29945 have links to enwiki and 29930 have an English label as well > (of course you could get the English names for the others by looking at the > title of the Wikipedia article). > > Two things to be aware of are that this isn't a one-to-one correspondence > and the quality of the links varies, so, for example, @ADFP_Peru has 7 > English wikipedia articles nominally "about" it, but none of them actually > describe the Peruvian professional football association. That article is > the rather generically named > https://en.wikipedia.org/wiki/Professional_Football_Sports_Association > > There are only ~160 Twitter accounts with multiple articles though. All > 22 the links for the account @status should be ignored as their the result > of a bots bad parse of things like the link to > https://twitter.com/WAFCA/status/410033143148978176 in > https://en.wikipedia.org/wiki/Tye_Sheridan#cite_note-22 > > Tom > > prefix schema: <http://schema.org/> > PREFIX wd: <http://www.wikidata.org/entity/> > PREFIX wdt: <http://www.wikidata.org/prop/direct/> > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > > SELECT ?Twitter ?item ?item_label ?article WHERE { > {?item wdt:P2002 ?Twitter FILTER(?Twitter = "ADFP_Peru") } > {?item rdfs:label ?item_label filter (lang(?item_label) = "en") .} > { > ?article schema:about ?item . > FILTER (SUBSTR(str(?article), 1, 25) = "https://en.wikipedia.org/";) > } > } > > > > On Mon, Nov 9, 2015 at 12:25 PM, Hampton Snowball < > [email protected]> wrote: > >> Thank you for doing what you could! In terms of wikipedia links it does >> look like the wikidata records do link to wikpedia, e.g. at the bottom of >> this record: >> >> https://www.wikidata.org/wiki/Q25369 >> >> Since there is multiple wikpedia entries, I guess I'd be going for the >> "en" english one. >> >> Best, >> HS >> >> >> On Mon, Nov 9, 2015 at 12:18 PM, Remko de Keijzer < >> [email protected]> wrote: >> >>> No. The label is the label in Wikidata. Not a sitelink. You're not >>> querying Wikipedia, but Wikidata. >>> If you really need the sitelink, I hope someone else can help you >>> further, since I'm a mere beginner at SPARQL and was happy I could get this >>> result. >>> >>> -- >>> Mbch331 >>> >>> When you have eliminated the impossible, whatever remains, however >>> improbable, must be the truth. >>> (Sir Arthur Conan Doyle) >>> >>> Op 9-11-2015 om 18:13 schreef Hampton Snowball: >>> >>> Maybe I misunderstood. I think the item label is actually what's used >>> in the wikipedia article url, just convert spaces to underscores? >>> >>> Thanks! >>> >>> On Mon, Nov 9, 2015 at 11:47 AM, Hampton Snowball < >>> <[email protected]>[email protected]> wrote: >>> >>>> Thank you. Is there a way to export it though with the Wikipedia >>>> Article name with underscores or wikipedia url? So like Barack_Obama or >>>> en.wikipedia.org/wiki/Barack_Obama. >>>> >>>> On Mon, Nov 9, 2015 at 11:34 AM, Remko de Keijzer < >>>> <[email protected]>[email protected]> wrote: >>>> >>>>> I think this: http://tinyurl.com/o5lahko is what you wanted. It's got >>>>> the item ID, the label and the value of P2002. >>>>> >>>>> -- >>>>> Mbch331 >>>>> >>>>> When you have eliminated the impossible, whatever remains, however >>>>> improbable, must be the truth. >>>>> (Sir Arthur Conan Doyle) >>>>> >>>>> Op 9-11-2015 om 17:09 schreef Hampton Snowball: >>>>> >>>>> I'm looking to use the <https://query.wikidata.org/> >>>>> https://query.wikidata.org/ interface to export to csv all wikidatas >>>>> with this property P2002. >>>>> >>>>> >>>>> <https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Property:P2002&limit=500&from=21542767&back=20967485> >>>>> https://www.wikidata.org/w/index.php?title=Special:WhatLinksHere/Property:P2002&limit=500&from=21542767&back=20967485 >>>>> >>>>> I am looking for the Wikipedia Article_Name + the value associated >>>>> with that property. >>>>> >>>>> Thanks in advance! >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Wikidata mailing >>>>> [email protected]https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Wikidata mailing list >>>>> [email protected] >>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>>>> >>>>> >>>> >>> >>> >>> _______________________________________________ >>> Wikidata mailing >>> [email protected]https://lists.wikimedia.org/mailman/listinfo/wikidata >>> >>> >>> >>> _______________________________________________ >>> Wikidata mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/wikidata >>> >>> >> >> _______________________________________________ >> Wikidata mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/wikidata >> >> > > _______________________________________________ > Wikidata mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata > >
_______________________________________________ Wikidata mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata
