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
Total: 10, Shown: 10
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
| p | name |
|---|---|
| http://dbpedia.org/resource/Sami_Kelopuro | Sami Kelopuro |
| http://dbpedia.org/resource/Ben_Lamb_(poker_player) | Ben Lamb |
| http://dbpedia.org/resource/Juha_Helppi | Juha Helppi |
| http://dbpedia.org/resource/Patrik_Antonius | Patrik Antonius |
| http://dbpedia.org/resource/Peter_Jetten | Peter Jetten |
Total: 5, Shown: 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
| actor | nat |
|---|---|
| http://dbpedia.org/resource/Satoru_Matsuo | Japanese |
| http://dbpedia.org/resource/Sayuri_Hara | Japanese |
| http://dbpedia.org/resource/Jukichi_Uno | Japanese |
| http://dbpedia.org/resource/Rei_Dan | Japanese |
| http://dbpedia.org/resource/Reisen_Ri | Japanese |
Total: 5, Shown: 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']
| p | x |
|---|---|
| http://dbpedia.org/resource/CaMia_Hopson | CaMia_Hopson |
| http://dbpedia.org/resource/Cab_Calloway | Cab_Calloway |
| http://dbpedia.org/resource/Cab_Kaye | Cab_Kaye |
| http://dbpedia.org/resource/Cabbrini_Foncette | Cabbrini_Foncette |
Total: 4, Shown: 4
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
| p | name |
|---|---|
| http://dbpedia.org/resource/Cady_McClain | Cady McClain |
| http://dbpedia.org/resource/Carl_Reiner | Carl Reiner |
| http://dbpedia.org/resource/Carrie_Hope_Fletcher | Carrie Hope Fletcher |
| http://dbpedia.org/resource/Rorke_Denver | Rorke Denver |
| http://dbpedia.org/resource/Ross_Kemp | Ross Kemp |
| http://dbpedia.org/resource/Roy_Hudd | Roy Hudd |
Total: 6, Shown: 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 }
}
| p | name |
|---|---|
| http://dbpedia.org/resource/Carl_Reiner | Carl Reiner |
| http://dbpedia.org/resource/Ross_Kemp | Ross Kemp |
Total: 2, Shown: 2
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 ) )
}
| p | name |
|---|---|
| http://dbpedia.org/resource/Carl_Reiner | Carl Reiner |
| http://dbpedia.org/resource/Ross_Kemp | Ross Kemp |
Total: 2, Shown: 2
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
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
Total: 10, Shown: 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