Skip to content

Instantly share code, notes, and snippets.

@gpirrotta
Created November 16, 2019 14:28
Show Gist options
  • Save gpirrotta/a9fd3cc796233085658d8ac848f2cc11 to your computer and use it in GitHub Desktop.
Save gpirrotta/a9fd3cc796233085658d8ac848f2cc11 to your computer and use it in GitHub Desktop.
PREFIX ocd: <http://dati.camera.it/ocd/>
PREFIX osr: <http://dati.senato.it/osr/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT ?senatore ?nome ?cognome ?commissione ?dizione
WHERE
{
?senatore osr:afferisce ?afferenza.
?senatore foaf:firstName ?nome.
?senatore foaf:lastName ?cognome.
?senatore a osr:Senatore.
?afferenza osr:commissione ?commissione.
?afferenza osr:carica ?carica.
?commissione osr:denominazione ?denominazione.
?denominazione osr:titolo ?dizione.
OPTIONAL {?denominazione osr:fine ?dataFine}
OPTIONAL {?afferenza osr:fine ?fineAfferenza}
FILTER(REGEX(?nome,'Liliana'))
FILTER(REGEX(?cognome,'Segre'))
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment