User
Difference between revisions of "Ash Crow"
(Created page with "== Sparql Queries == === endpoint === https://lingualibre.fr/bigdata/#query === List of editors during the first quarter of 2020 === <code> PREFIX lli: <https://lingualibre.f...") |
|||
| Line 4: | Line 4: | ||
=== List of editors during the first quarter of 2020 === | === List of editors during the first quarter of 2020 === | ||
| − | < | + | <pre> |
PREFIX lli: <https://lingualibre.fr/entity/> | PREFIX lli: <https://lingualibre.fr/entity/> | ||
PREFIX llp: <https://lingualibre.fr/prop/direct/> | PREFIX llp: <https://lingualibre.fr/prop/direct/> | ||
| Line 15: | Line 15: | ||
?locutor rdfs:label ?locutorName . | ?locutor rdfs:label ?locutorName . | ||
} GROUP BY ?locutor ORDER BY DESC(?records) | } GROUP BY ?locutor ORDER BY DESC(?records) | ||
| − | </ | + | </pre> |
Latest revision as of 14:26, 30 March 2020
Sparql Queries
endpoint
https://lingualibre.fr/bigdata/#query
List of editors during the first quarter of 2020
PREFIX lli: <https://lingualibre.fr/entity/>
PREFIX llp: <https://lingualibre.fr/prop/direct/>
SELECT DISTINCT ?locutor (SAMPLE(?locutorName) as ?locutorName) (COUNT(DISTINCT ?record) as ?records) WHERE {
?record llp:P2 lli:Q2 .
?record llp:P5 ?locutor .
?record llp:P6 ?date .
FILTER (?date >= "2020-01-01T00:00:00Z"^^xsd:dateTime) .
FILTER (?date < "2020-04-01T00:00:00Z"^^xsd:dateTime) .
?locutor rdfs:label ?locutorName .
} GROUP BY ?locutor ORDER BY DESC(?records)