Select footballers from two or more countries with SPARQL wikidata query

Question

I'm trying to get the day of birth of all the footballers on wikipedia per country. Until now I've managed to get all the ones for one country, but I would like to get the ones on many countries at the same time, something like:

SELECT ?person ?dateOfBirth
WHERE {
  ?person wdt:P1532 wd:Q16 OR ?person wdt:P1532 wd:Q141;
  wdt:P569 ?dateOfBirth.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Q16 is canada and Q141 is Argentina

Thanks!

score 1 · Accepted Answer · answered Jun 30 '21 at 18:39

To not limit your query to a single country, replace wd:Q16 by a variable, i.e. ?person wdt:P1531 ?country.

Then you need to restrict your query to football players. This can be done with the following line

?person wdt:P106 wd:Q937857.

And probably you want the names of the players, not only der ID. Thus, add ?personLabel after "select".

Combined, the query reads

SELECT ?person ?personLabel ?country ?countryLabel ?dateOfBirth
WHERE {
  ?person wdt:P106 wd:Q937857;
          wdt:P1532 ?country;          
          wdt:P569 ?dateOfBirth.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
}

Thanks! That's a perfect answer – arderoma Jun 30 '21 at 19:55 — arderoma, Jun 30 '21 at 19:55

Select footballers from two or more countries with SPARQL wikidata query

1 Answers1