query-2228750ebb783e9d8eff26cd842e4250

rq turtle/ttl

TODO 原始列表 按年所属国家当年统计得奖人数

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#defaultView:LineChart
SELECT  ?year (COUNT(?human) AS ?TotalYearlyPrizeNumberByCountry) ?countryLabel  
#SELECT  ?year ?human ?countryLabel  
WHERE
{

{
  SELECT * WHERE {
    ?human (p:P166) ?awardStatement.
    ?awardStatement ps:P166/wdt:P279* wd:Q7191.
          ?awardStatement pq:P585 ?date.
    ?human  wdt:P27 ?country.
          bind(str(YEAR(?date)) AS ?year)
                    #SERVICE wikibase:label { bd:serviceParam wikibase:language "zh,[AUTO_LANGUAGE],". }
    }
  LIMIT 10000
}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?year ?countryLabel

Query found at

• https://www.wikidata.org/wiki/User:Bangbang.S
• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/10