BigData LOD MOD21 examples

%endpoint https://dbpedia.org/sparql
%lang en
%show all

PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?writer ?photo
WHERE {
  ?writer a dbo:Writer.
  OPTIONAL{
    ?writer foaf:depiction ?photo.
  }
}
limit 10
Endpoint set to: https://dbpedia.org/sparql
Label preferred languages: ['en']
Result maximum size: unlimited
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?p (CONCAT(?gn, " ", ?fn) AS ?name)
WHERE {
  ?p  a          foaf:Person;
      foaf:givenName  ?gn;
      foaf:familyName ?fn.
}
LIMIT 5
PREFIX dbo: <http://dbpedia.org/ontology/>
PREFIX dbp: <http://dbpedia.org/property/>

SELECT ?actor ?nat
WHERE {
    ?actor a               dbo:Actor;
           dbp:nationality ?nat. 
    #FILTER (! ISIRI(?nat))
    FILTER (CONTAINS(STR(?nat), "Japanese"))
}
LIMIT 5
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?n (COUNT(?img) AS ?number_image)
WHERE {
  ?p a              foaf:Person;
     foaf:name      ?n ;
     foaf:depiction ?img.
}
GROUP BY ?n
LIMIT 6 
OFFSET 3
n number_image
Cadão Volpato 1
Ricardo Manuel Ferreira Sousa 1
Caesar Rodney 15
Caesar Cardini 2
Caesarion 6
Caetano Lima dos Santos, O.F.M Cap. 1
Total: 6, Shown: 6
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?bpl (COUNT(?p) AS ?cp)
WHERE {
  ?p a              foaf:Person;
     foaf:name      ?n;
     dbo:birthPlace      ?bp.
  ?bp dbp:name ?bpl.
}
GROUP BY ?bpl
LIMIT 5
bpl cp
Campos dos Goytacazes 74
Queensland 1335
San Diego 476
Berkeley, California 335
Breda 158
Total: 5, Shown: 5
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?bpl (COUNT(?p) AS ?cp)
WHERE {
  ?p a              foaf:Person;
     foaf:name      ?n;
     dbo:birthPlace      ?bp.
  ?bp dbp:name ?bpl.
}
GROUP BY ?bpl
HAVING(COUNT(?p)<5)
LIMIT 7
bpl cp
Matthews, North Carolina 4
Youxi County 1
Amsterdam-Noord 1
Joetown 1
Bersillies 1
Stiring-Wendel 1
Essequibo Islands-West Demerara 3
Total: 7, Shown: 7
SELECT ?name ?currentDateTime (CONCAT(?d," ",?m," ",?y) AS ?date_french)
WHERE {
  BIND(NOW()        AS ?currentDateTime)
  BIND(YEAR(?currentDateTime)  AS ?y)
  BIND(MONTH(?currentDateTime) AS ?m)
  BIND(DAY(?currentDateTime)   AS ?d)
}
Endpoint set to: https://dbpedia.org/sparql
Label preferred languages: ['en']
Result maximum size: unlimited
name currentDateTime date_french
2024-12-10T11:36:41.926944 10 12 2024
Total: 1, Shown: 1
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?bpl (COUNT(?n) AS ?cn) (GROUP_CONCAT(?n, " | ") AS ?names)
WHERE {
  ?p a              foaf:Person;
     foaf:name      ?n;
     dbo:birthPlace      ?bp.
  ?bp dbp:name ?bpl.
}
GROUP BY ?bpl
HAVING(COUNT(?p)<5)
LIMIT 7
bpl cn names
Matthews, North Carolina 4 Caine Wilkes | Ty Buttrey | Jim Black | Brennan Malone
Youxi County 1 Cai Qi
Amsterdam-Noord 1 Calvin Twigt
Joetown 1 Cam Henderson
Bersillies 1 Camille Lou
Stiring-Wendel 1 Camille Fischbach
Essequibo Islands-West Demerara 3 Carey Vanier | Sase Narain | Doreen Chung
Total: 7, Shown: 7
%endpoint https://dbpedia.org/sparql
%lang en
PREFIX foaf: <http://xmlns.com/foaf/0.1/>

SELECT ?p ?x
WHERE {
  ?p a foaf:Person.
  BIND (REPLACE(STR(?p), "^.*/([^/]*)$", "$1") AS ?x)
}
LIMIT 4
Endpoint set to: https://dbpedia.org/sparql
Label preferred languages: ['en']
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dbp: <http://dbpedia.org/property/>

SELECT ?p ?name
WHERE {
    ?p a              foaf:Person;
       foaf:name      ?name;
       dbp:occupation "Actor"@en, "author"@en.
}
LIMIT 6
PREFIX  foaf: <http://xmlns.com/foaf/0.1/>
PREFIX  dbp:  <http://dbpedia.org/property/>

SELECT  ?p ?name
WHERE {
   ?p  a               foaf:Person ;
        foaf:name       ?name ;
        dbp:occupation  "Actor"@en .
    VALUES ?name { "Carl Reiner"@en "Ross Kemp"@en }
}
PREFIX  foaf: <http://xmlns.com/foaf/0.1/>
PREFIX  dbp:  <http://dbpedia.org/property/>

SELECT  ?p ?name
WHERE
  { ?p  a               foaf:Person ;
        foaf:name       ?name ;
        dbp:occupation  "Actor"@en .
    FILTER ( ( ?name="Carl Reiner"@en ) || ( ?name="Ross Kemp"@en ) )
  }
PREFIX rdf:  <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dbo:  <http://dbpedia.org/ontology/>
PREFIX dbr:  <http://dbpedia.org/resource/>

SELECT DISTINCT ?person ?death_cause
WHERE { ?person rdf:type dbo:Person .
        ?person rdfs:label ?label .
        OPTIONAL {?person dbp:deathCause ?death_cause} .
        ?person dbo:deathDate ?deathDate .
                 FILTER (?deathDate > "1980-01-01"^^xsd:date) .
}
ORDER BY DESC(?death_cause)
LIMIT 30
person death_cause
http://dbpedia.org/resource/Murder_of_Dana_Bradley 1981-12-18
http://dbpedia.org/resource/Aa_Jimmy 2018
http://dbpedia.org/resource/Mbah_Maridjan 2010
http://dbpedia.org/resource/Moustapha_Akkad 2005
http://dbpedia.org/resource/Saeed_Chmagh 30
http://dbpedia.org/resource/Ricardo_Cerna http://dbpedia.org/resource/Suicide_by_gunshot
http://dbpedia.org/resource/Moner_Mohammad_Abu_Salha http://dbpedia.org/resource/Suicide_bombing
http://dbpedia.org/resource/Wbaldino_Acosta http://dbpedia.org/resource/Stroke
http://dbpedia.org/resource/Murder_of_Clare_Morrison http://dbpedia.org/resource/Strangulation
http://dbpedia.org/resource/Murder_of_Celia_Douty http://dbpedia.org/resource/Murder
http://dbpedia.org/resource/Murder_of_Glory_Chau_and_Moon_Siu http://dbpedia.org/resource/Murder
http://dbpedia.org/resource/Viyan_Peyman http://dbpedia.org/resource/Killed_in_action
http://dbpedia.org/resource/Raj_Narain http://dbpedia.org/resource/Heart_attack
http://dbpedia.org/resource/Sheikh_Nur_Mohamed_Abkey http://dbpedia.org/resource/Gunshot_wound
http://dbpedia.org/resource/Murder_of_Annie_Ee http://dbpedia.org/resource/Fat_embolism_syndrome
http://dbpedia.org/resource/P_Namgyal http://dbpedia.org/resource/COVID-19
http://dbpedia.org/resource/Telésforo_Santiago_Enríquez http://dbpedia.org/resource/Ballistic_trauma
http://dbpedia.org/resource/Najma_Sadeque
http://dbpedia.org/resource/Nakayama_Zenye
http://dbpedia.org/resource/Namo_Hermios
http://dbpedia.org/resource/Nan_Hoover
http://dbpedia.org/resource/Nancy_Asire
http://dbpedia.org/resource/Nancy_Cooke_de_Herrera
http://dbpedia.org/resource/Nancy_Drexel
http://dbpedia.org/resource/Nancy_Ezer
http://dbpedia.org/resource/Nancy_Foster
http://dbpedia.org/resource/Naomi_Chance
http://dbpedia.org/resource/Naomi_Datta
http://dbpedia.org/resource/Naomi_Gray
http://dbpedia.org/resource/Napolioni_Dawai
Total: 30, Shown: 30
PREFIX dbc: <http://dbpedia.org/resource/Category:>
PREFIX dct: <http://purl.org/dc/terms/>

SELECT ?Xname
WHERE { 
        { ?X dct:subject dbc:Portuguese_poets }
    UNION
        { ?X dct:subject dbc:Portuguese_philosophers}
    ?X foaf:name ?Xname.
}
ORDER BY DESC(?Xname)
LIMIT 5
Xname
Teófilo Braga
Texeira de Pascoaes
Texeira de Pascoaes
Teodoro de Almeida
Luis Filipe B. Teixeira
Total: 5, Shown: 5
PREFIX dbc: <http://dbpedia.org/resource/Category:>
PREFIX dct: <http://purl.org/dc/terms/>

SELECT distinct(?Xname) (COUNT(?X) AS ?cX)

WHERE { 
        { ?X dct:subject dbc:Portuguese_poets }
    UNION
        { ?X dct:subject dbc:Portuguese_philosophers}

    ?X foaf:name ?Xname.
}
ORDER BY DESC(?cX)
LIMIT 5
Xname cX
Texeira de Pascoaes 2
Jorge de Sena 1
Damião de Góis 1
Teodoro de Almeida 1
Desidério Murcho 1
Total: 5, Shown: 5
# Names of people who have not stated that they know anyone
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT ?name ?who
WHERE 
{
  ?x foaf:givenName ?name .
  FILTER NOT EXISTS { ?x foaf:knows ?who }
}
LIMIT 10
name who
Cabell Calloway III
Nii-lante Augustus Kwamlah Quaye
Frank Kwame Gyasi- Frimpong
Israel López Valdés
Gerardo Horacio López von Linden
Robert Paulson
Raffaella Rivarolo
Cade Larson
Roland Pemberton
Blaine Cameron Johnson
Total: 10, Shown: 10
PREFIX dbo:  <http://dbpedia.org/ontology/>
PREFIX dbp:  <http://dbpedia.org/property/>

SELECT ?actor ?nat
WHERE {
  ?actor a               dbo:Actor;
         dbp:nationality ?nat;
         dbp:name        ?name.
  filter( isLiteral(?nat) && LANGMATCHES(LANG(?name), "en"))
}
LIMIT 10
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dbp:  <http://dbpedia.org/property/>

SELECT ?p ?name ?pbd ?ypbd
WHERE {
  ?p a               foaf:Person ;
     foaf:familyName ?name ;
     dbp:birthDate   ?pbd .
  BIND (year(xsd:date(?pbd)) AS ?ypbd)
}
LIMIT 2
p name pbd ypbd
http://dbpedia.org/resource/Ben_Lamb_(poker_player) Lamb 1985-03-31 1985
http://dbpedia.org/resource/Juha_Helppi Helppi 1977-03-04 1977
Total: 2, Shown: 2