e-maud

Garzoni People Search

About Person entities/mentions

How many person mentions

SELECT COUNT (distinct ?pm)
WHERE { ?pm a grz-owl:PersonMention .}

How many person entities

e-maud

Garzoni People Search

About Roles

Role distribution for Person Entities (ok)

SELECT ?roleType COUNT (distinct ?pm)
WHERE
{
  ?pm a grz-owl:Person .
  ?pm grz-owl:role/grz-owl:value ?roleType .

e-maud

Garzoni People Search

About person relations

#####Find all person knowing a certain person

SELECT ?x
WHERE
{

e-maud

Garzoni People Search : about Masters

Get masters having more than 1 apprentice

SELECT ?master
WHERE 
{
  ?master grz-owl:has_apprentice ?appStatement .
}
GROUP BY ?master

e-maud

Garzoni archival stuff search

Distribution of contract per year (ok)

SELECT ?year COUNT (?c)
WHERE 
{
  ?c a grz-owl:Contract .
  ?c sem:hasTimeStamp ?date .
 BIND (year(?date) AS ?year).

e-maud

Garzoni graphs

Extract all relations within time windows

SELECT ?person  ?plabel (str(?g1) AS ?pgender) ?ctype ?connection ?clabel (str(?g2) AS ?cgender) ?start 
WHERE 
{
  ?person a grz-owl:Person .  
  OPTIONAL { ?person rdfs:label ?plabel . }
 OPTIONAL { ?person grz-owl:gender ?g1 . }

e-maud

Garzoni various

Extract data for disamb

SELECT (strafter(str(?contract), "-data/") AS ?contract) str(?appStartDate) AS ?startApp  str(?contractDuration) AS ?durationInMonths
(str(?identifiedPerson) AS ?identifiedPerson) 
(strafter(str(?personEntity), "-data/") AS ?personEntity)
(str(?wfFirstname) AS ?firstname) 
(str(?wfSurname)  AS ?surname) 
(str(?wfPatronimic1) AS ?patronimic1) 

e-maud

Garzoni geography: about workshops, and others

# workshop mentions

SELECT (COUNT (distinct ?wm) AS ?workshopMention) 
WHERE
{ ?wm a grz-owl:WorkshopMention .}

Show workshop locations (all infos)

e-maud

Garzoni People Search : about guarantors

Number of contracts without guarantor

SELECT COUNT (?contract)
WHERE
{
?contract  a grz-owl:Contract . 
FILTER (NOT EXISTS 
{

e-maud

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 .