query-dce694bb7211ea3904ebfcbc306f56a5

rq turtle/ttl

Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM) Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below SELECT ?country ?countryLabel ?wikiPersons ?population (ROUND(?wikiPersons/?population1000000) AS ?wikiPersonsPerM) WHERE { { SELECT ?country (count() as ?wikiPersons) WHERE { {SELECT DISTINCT ?person ?country WHERE { wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries ?person wdt:P31 wd:Q5 . ?person wdt:P27 ?country . FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people } } } GROUP BY ?country } ?country wdt:P1082 ?population SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" } } ORDER BY DESC(?wikiPersonsPerM)

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Interesting maintenance query that shows the relative prominence of a country's current (living) population on Wikidata. The query tends to time out when using all countries at once, but it might be possible to get the figures for each individual country by using uncommenting the line as indicated below
SELECT
  ?country ?countryLabel
  ?wikiPersons
  ?population
  (ROUND(?wikiPersons/?population*1000000) AS ?wikiPersonsPerM)
WHERE
{
  { SELECT ?country (count(*) as ?wikiPersons) WHERE {
    {SELECT DISTINCT ?person ?country WHERE {
      wd:Q458 wdt:P150 ?country . # European Union contains administrative territorial entity
      # BIND( wd:Q30 AS ?country ) # use instead of previous line to check individual countries
      ?person wdt:P31 wd:Q5 .
      ?person wdt:P27 ?country .
      FILTER NOT EXISTS{ ?person wdt:P570 ?date } # only count living people
    } }
  } GROUP BY ?country }
  ?country wdt:P1082 ?population
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en" }
}
ORDER BY DESC(?wikiPersonsPerM)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?country"):::projected v3("?date") v2("?person") v6("?population"):::projected v5("?wikiPersons"):::projected v7("?wikiPersonsPerM") c9(["bd:serviceParam"]):::iri c2(["wd:Q458"]):::iri c5(["wd:Q5"]):::iri c11(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P570"--> e0v2 e0v2("?date"):::projected e0v1("?person"):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> v3 v2 --"wdt:P570"--> v3 c2 --"wdt:P150"--> v4 v2 --"wdt:P31"--> c5 v2 --"wdt:P27"--> v4 bind2[/"count(*)"/] bind2 --as--o v5 v4 --"wdt:P1082"--> v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end bind3[/"numeric-round(?wikiPersons / ?population * '1000000^^xsd:integer')"/] v5 --o bind3 v6 --o bind3 bind3 --as--o v7