Showing posts from July, 2017

Birthdays and Death Anniversaries of public figures in any country

Use the same queries as given in the previous post.
Change Q668 to proper value for a country of choice. For example, Q30 for USA. Q27 for Ireland.
How do you find Q# for country of your choice? Go here.

Birthdays and Death Anniversaries of public figures in India

Here are SPARQL queries you can run against Wikipedia data to generate a list of birthdays and death anniversaries of public figures in India.

1. Go to
2. In the query window, cut and paste any of the queries below.
3. Do not copy the comments that begins with //
4. Here is the link to the results collated.

Query #1:
// Indians born any day. Lists occupation as well.

SELECT ?a ?aLabel ?birth_date (month(?birth_date) as ?month) (day(?birth_date) as ?day)
?occupationLabel WHERE {

   ?a p:P569/psv:P569
   ?birth_date_node .
   ?birth_date_node wikibase:timePrecision "11"^^xsd:integer .
   ?birth_date_node wikibase:timeValue ?birth_date .

   FILTER (month(?birth_date) >= 1) .
   FILTER (day(?birth_date) >= 1) .
   ?a wdt:P27 wd:Q668 .
   ?a wdt:P106 ?occupation .

   SERVICE wikibase:label {
      bd:serviceParam wikibase:language "en" .
ORDER BY day(?birth_date) ?aLabel

Query #2:
// Indians with date of death any day. Lists occu…