User:Daniel/Queries/LinkedWikiTest: Difference between revisions
From MaRDI portal
< User:Daniel | Queries
Created page with "{{#sparql: PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX pq: <http://www.wikidata.org/prop/qualifier/> PREFIX psv: <http://www.wikidata.org/prop/statement/value/> PREFIX p: <http://www.wikidata.org/prop/> PREFIX bd: <http://www.bigdata.com/rdf#> PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> select distinct ?lat ?long ?presidentLabel where { ?president wdt:P3..." |
No edit summary |
||
| Line 26: | Line 26: | ||
} | } | ||
|config=http://www.wikidata.org | |config=http://www.wikidata.org | ||
|chart= | }} | ||
{{#sparql:PREFIX item: <http://www.wikidata.org/wiki/Q> | |||
PREFIX skos: <http://www.w3.org/2004/02/skos/core#> | |||
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | |||
PREFIX wikidata: <http://www.wikidata.org/ontology#> | |||
PREFIX dcat: <http://www.w3.org/ns/dcat#> | |||
PREFIX dct: <http://purl.org/dc/terms/> | |||
PREFIX dataset: <https://io.datascience-paris-saclay.fr/datasetView.php?dataset_id=> | |||
SELECT DISTINCT | |||
(SAMPLE(?themeText) as ?label) (COUNT(?title) as ?count) ?theme | |||
where { | |||
?dataset a dcat:Dataset ; | |||
dct:title ?title ; | |||
dcat:theme ?theme. | |||
?theme rdfs:label ?themeText. | |||
} | |||
GROUP BY ?theme | |||
ORDER BY DESC(?count) | |||
| endpoint = https://linkedwiki.com/sparql | |||
| chart=google.visualization.Pie | |||
| options= | |||
| log=2 | |||
}} | }} | ||
Revision as of 10:19, 8 June 2023
| lat | long | presidentLabel |
|---|---|---|
| 48.847222222222 | 2.3444444444444 | Jacques Chirac |
| 49.443055555556 | 1.1025 | François Hollande |
| 50.359722222222 | 7.5977777777778 | Valéry Giscard d'Estaing |
| 48.856666666667 | 2.3522222222222 | Nicolas Sarkozy |
| 50.631944444444 | 3.0575 | Charles de Gaulle |
| 45.681388888889 | -0.17583333333333 | François Mitterrand |
| 44.643611111111 | 4.8730555555556 | Émile Loubet |
| 47.007222222222 | 4.4713888888889 | Patrice de Mac Mahon |
| 48.771666666667 | 5.1672222222222 | Raymond Poincaré |
| 48.856666666667 | 2.3522222222222 | Napoléon III |
| 43.458611111111 | 2.0041666666667 | Vincent Auriol |
| 48.725555555556 | 2.4211111111111 | Alain Poher |
| 49.494166666667 | 0.10805555555556 | René Coty |
| 49.367777777778 | 5.8255555555556 | Albert Lebrun |
| 44.925277777778 | 2.4397222222222 | Paul Doumer |
| 45.371388888889 | 2.7313888888889 | Georges Pompidou |
| 43.296666666667 | 5.3763888888889 | Adolphe Thiers |
| 46.564722222222 | 3.3325 | Georges Bidault |
| 50.8675 | 4.3736111111111 | Paul Deschanel |
| 49.891944444444 | 2.2977777777778 | Emmanuel Macron |
| 48.856666666667 | 2.3522222222222 | Félix Faure |
| 48.856666666667 | 2.3522222222222 | Alexandre Millerand |
| 47.346388888889 | -3.1552777777778 | Louis Jules Trochu |
| 48.856666666667 | 2.3522222222222 | Eugène Cavaignac |
| 48.856666666667 | 2.3522222222222 | Frédéric François-Marsal |
| 48.870128 | 2.320808 | Jean Casimir-Perier |
| 46.980277777778 | 5.6022222222222 | Jules Grévy |
| 45.834444444444 | 1.2616666666667 | Sadi Carnot |
| 44.056666666667 | 0.25833333333333 | Armand Fallières |
| 43.739444444444 | 4.1805555555556 | Gaston Doumergue |
| 45.043333333333 | 3.885 | Charles Alexandre Dupuy |
| 07:05:36 01/03/2026 -- Refresh -- Duration of query :0.369s -- CSV | ||
