There are only 73 entries (including some duplicates) showing up for a straight P249 search, which is a bit strange in any case - https://query.wikidata.org/#SELECT%20%3Fitem%20%20%3Fstock%20WHERE%20%7B%0A… Sampling a few items suggests that most businesses don't use P249 directly, instead they use it as a qualifier on P414, eg https://www.wikidata.org/wiki/Q156578 or https://www.wikidata.org/wiki/Q156238 These won't show up on a straight search. I'm not familiar with how searching for qualifiers is best done, but at least it narrows down the problem... A. On 13 October 2016 at 18:42, Hampton Snowball <hamptonsnowball(a)gmail.com> wrote: -- - Andrew Gray andrew.gray(a)dunelm.org.uk

Thank you Andrew. You are pointing out that simply trying to export p249 alone is not working properly or needs a different query, I see. On Thu, Oct 13, 2016 at 3:02 PM, Hampton Snowball <hamptonsnowball(a)gmail.com > When I got to the 'what links here' for p249 seems like a lot more > (hundreds) of entries: > > https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P249 > > > On Thu, Oct 13, 2016 at 2:20 PM, Andrew Gray <andrew.gray(a)dunelm.org.uk> > >> There are only 73 entries (including some duplicates) showing up for a >> straight P249 search, which is a bit strange in any case - >> >> https://query.wikidata.org/#SELECT%20%3Fitem%20%20%3Fstock% >> 20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP249%20%3Fstock%20.%0A%20%7D >> >> Sampling a few items suggests that most businesses don't use P249 >> directly, instead they use it as a qualifier on P414, eg >> https://www.wikidata.org/wiki/Q156578 or >> https://www.wikidata.org/wiki/Q156238 >> >> These won't show up on a straight search. I'm not familiar with how >> searching for qualifiers is best done, but at least it narrows down >> the problem... >> >> A. >> >> On 13 October 2016 at 18:42, Hampton Snowball <hamptonsnowball(a)gmail.com> >>> > I took another query from this list and have been trying to modify it >> to get >> > stock symbols and there wikipedia pages. But I am only getting 64 >> results. >> > Am I doing something wrong, filtering the results? >> > >> > http://tinyurl.com/go8zpvy >> > >> > Thanks in advance! >> > >> > Hampton >> > >> > _______________________________________________ >> > Wikidata mailing list >> > Wikidata(a)lists.wikimedia.org >> > https://lists.wikimedia.org/mailman/listinfo/wikidata >> > >> >> >> >> -- >> - Andrew Gray >> andrew.gray(a)dunelm.org.uk >> >> _______________________________________________ >> Wikidata mailing list >> Wikidata(a)lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikidata >> > >

Hi! You can use something like this: http://tinyurl.com/hdoqrjt The key thing there is UNION - that's how you do "this or that". Note though ticker symbols are not unique (they are per exchange) so you may want to either group: http://tinyurl.com/jmbrf4p or add stock exchange name to it or do something else, depending on your case. -- Stas Malyshev smalyshev(a)wikimedia.org

As far as I can tell on https://www.wikidata.org/wiki/Q156578 VW indeed has three different stock symbols. On Thu, Oct 13, 2016 at 1:34 PM Hampton Snowball <hamptonsnowball(a)gmail.com> wrote: