gpirrotta

#!/bin/bash
#
# █▄▄ █░█ █▀▄▀█ █▀█ ▄▄ █░█ █▀▀ █▀█ █▀ █ █▀█ █▄░█
# █▄█ █▄█ █░▀░█ █▀▀ ░░ ▀▄▀ ██▄ █▀▄ ▄█ █ █▄█ █░▀█
#
# Description:
#   - This script automates bumping the git software project's version using automation.

#   - It does several things that are typically required for releasing a Git repository, like git tagging, 
#     automatic updating of CHANGELOG.md, and incrementing the version number in various JSON files.

gpirrotta

PREFIX shoah: <http://dati.cdec.it/lod/shoah/>
PREFIX bio-ext: <http://dati.cdec.it/lod/bio-ext/>

SELECT ?name ?familyName
FROM <http://dati.cdec.it/lod/shoah/> 
WHERE{
?uri a shoah:Persecution.
?person shoah:persecution ?uri.
?person bio-ext:shoahSurvivor "false".
?person foaf:familyName ?familyName.

gpirrotta

PREFIX bio-ext: <http://dati.cdec.it/lod/bio-ext/>
PREFIX shoah: <http://dati.cdec.it/lod/shoah/>

SELECT  count(?country) as ?count
FROM <http://dati.cdec.it/lod/shoah/>  
WHERE {
?IRI a foaf:Person; 
     bio-ext:birthPlace ?birth. 
?birth foaf:country ?country.
FILTER(?country != 'Italia').

gpirrotta

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.

gpirrotta

PREFIX osr: <http://dati.senato.it/osr/>

SELECT DISTINCT ?dataSeduta ?numeroSeduta ?votazione ?numero ?oggetto ?esito
?presenti ?maggioranza ?numeroLegale ?votanti ?favorevoli ?contrari
?astenuti ?presidente
WHERE
{
    ?votazione a osr:Votazione.
    ?votazione osr:numero ?numero.
    ?votazione osr:seduta ?seduta.

gpirrotta

PREFIX osr: <http://dati.senato.it/osr/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT DISTINCT ?senatore ?nome ?cognome ?tipo ?dataNomina
WHERE {
    ?senatore a osr:Senatore.
    ?senatore foaf:firstName ?nome.
    ?senatore foaf:lastName ?cognome.
    ?senatore osr:mandato ?mandato.
    OPTIONAL { ?mandato osr:fine ?fine }

gpirrotta

PREFIX bio-ext: <http://dati.cdec.it/lod/bio-ext/>

SELECT ?firstName ?familyName ?consortName ?childName ?districtOfResidence

FROM <http://dati.cdec.it/lod/shoah/>
WHERE 
{
?uri a foaf:Person;
     foaf:firstName ?firstName;
     foaf:familyName ?familyName;

gpirrotta

PREFIX shoah: <http://dati.cdec.it/lod/shoah/>
PREFIX bio-ext: <http://dati.cdec.it/lod/bio-ext/>

SELECT DISTINCT ?labelConvoy ?deparDate ?labelCamp ?gender (count(?gender) as ?count)  
FROM <http://dati.cdec.it/lod/shoah/> where
{
   ?convoy a shoah:Convoy;
           rdfs:label ?labelConvoy;
           shoah:departureDate ?deparDate;
           shoah:toNaziCamp ?naziCamp.

gpirrotta

PREFIX shoah: <http://dati.cdec.it/lod/shoah/>
PREFIX bio-ext: <http://dati.cdec.it/lod/bio-ext/>

SELECT distinct ?convoy ?deparDate ?labelCamp 
FROM <http://dati.cdec.it/lod/shoah/>  
WHERE
{ 
?uri a shoah:Convoy;
          rdfs:label ?convoy;
          shoah:departureDate ?deparDate;

gpirrotta

PREFIX shoah: <http://dati.cdec.it/lod/shoah/>

SELECT ?prigione 
FROM <http://dati.cdec.it/lod/shoah/>
WHERE {
?uri a shoah:DetentionPlace;
 rdfs:label ?prigione.
}