Thanks to everyone who added their answers - this all did the trick! :)
On Mon, Nov 9, 2015 at 1:59 PM, Tom Morris <tfmorris(a)gmail.com> wrote:
This StackExchange answer describes how to get site
links:
http://opendata.stackexchange.com/questions/6050/get-wikipedia-urls-sitelin…
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 <
hamptonsnowball(a)gmail.com> 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 <
remko(a)remkodekeijzer.nl> 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 <
<hamptonsnowball@gmail.com>hamptonsnowball@gmail.com> 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 <
<remko@remkodekeijzer.nl>remko@remkodekeijzer.nl> 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:P…
>
> I am looking for the Wikipedia Article_Name + the value associated
> with that property.
>
> Thanks in advance!
>
>
>
> _______________________________________________
> Wikidata mailing
listWikidata@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata
>
>
>
> _______________________________________________
> Wikidata mailing list
> Wikidata(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikidata
>
>
_______________________________________________
Wikidata mailing
listWikidata@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata