GRZ-apprentices.md

Garzoni People Search : about apprentices

Age distribution (=> histogram) (ok)

SELECT COUNT (distinct ?app) ?age
WHERE
{
  ?app  a grz-owl:PersonMention .
  ?app grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:age ?age .
}
GROUP BY ?age
ORDER BY ASC (?age)

Age distribution with time window (=> histogram)

SELECT COUNT (distinct ?app) ?age
WHERE
{
  ?app  a grz-owl:PersonMention .
  ?app grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:age ?age .
  ?app grz-owl:introduced_in/sem:hasTimeStamp ?date .
  FILTER (year(?date) > 1600 AND year(?date) < 1650)
}
GROUP BY ?age
ORDER BY ASC (?age)

Age distribution for a given profession category (ok, with param later)

SELECT COUNT (distinct ?app) ?age
WHERE
{
  ?app  a grz-owl:PersonMention .
  ?app grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:age ?age .
  ?app grz-owl:profession/grz-owl:professionCategory "musica" .
}
GROUP BY ?age
ORDER BY ASC (?age)

Age distribution for a given profession category and a given time window

SELECT COUNT (distinct ?app) ?age
WHERE
{
  ?app  a grz-owl:PersonMention .
  ?app grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:age ?age .
  ?app grz-owl:introduced_in/sem:hasTimeStamp ?date .
  ?app grz-owl:profession/grz-owl:professionCategory "stampa" .
  FILTER (year(?date) > 1600 AND year(?date) < 1650)
}
GROUP BY ?age
ORDER BY ASC (?age)

Gender distribution for apprentices (ok)

SELECT COUNT (distinct ?app) ?gender
WHERE
{
  ?app  a grz-owl:Person .
  ?app grz-owl:role/grz-owl:value/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:gender ?gender .
}
GROUP BY ?gender

Give me apprentices who are mentioned in more than one contract (as apprentice)

SELECT ?app COUNT (distinct ?link) 
WHERE
{
  ?app  a grz-owl:Person .
  ?app grz-owl:role/grz-owl:value/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:has_mention ?link .
  ?link grz-owl:is_entityLink_of ?appMention .
  ?appMention grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
}
GROUP BY ?app
HAVING  COUNT (distinct ?link) > 1

Give me apprentices who are mentioned in more than one contract wich is not related to a previous contract

SELECT ?app COUNT (distinct ?link) 
WHERE
{
  ?app  a grz-owl:Person .
  ?app grz-owl:role/grz-owl:value/grz-owl:roleType  grz-owl:apprentice .
  ?app grz-owl:has_mention ?link .
  ?link grz-owl:is_entityLink_of ?appMention .
  ?appMention grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?appMention grz-owl:introduced_in ?contract .
  FILTER (NOT EXISTS {?contract grz-owl:cites ?anotherContract})
  FILTER (NOT EXISTS {?yetAnotherContract grz-owl:cites ?contract})
}
GROUP BY ?app
HAVING  COUNT (distinct ?link) > 1

Geographic Origins (ok)

SELECT ?GeoOriginWrittenForm ?GeoOriginStandardForm ?coordinates
WHERE
{
  ?app  a grz-owl:PersonMention .
  ?app grz-owl:role/grz-owl:roleType  grz-owl:apprentice .
  ?app  grz-owl:geographicOrigin ?geoOrigin .
  OPTIONAL {?geoOrigin grz-owl:standardForm ?GeoOriginStandardForm . }
  ?geoOrigin grz-owl:writtenForm ?GeoOriginWrittenForm .
  OPTIONAL {?geoOrigin  geo:geometry ?coordinates } .
}