Thanks! There is about 5000 item ids in the Natural Earth dataset,
what would be the best way to get them? Also, how can I get the latest
data? For example in your query Italy shows 2016, and there is 2017
and 2020 in there.

On Wed, 18 Mar 2020 at 23:34, Lucas Werkmeister
<m...@lucaswerkmeister.de> wrote:
>
> If you have the item IDs already, the query is relatively simple:
>
> SELECT ?item ?population WHERE {
>   VALUES ?item { wd:Q38 wd:Q148 wd:Q884 }
>   ?item wdt:P1082 ?population.
> }
>
> https://w.wiki/KjA
>
> You can add more values for the ?item (and spread them across several
> lines as well), the three above are just an example.
>
> Cheers,
> Lucas
>
> On 18.03.20 22:58, Zsolt Ero wrote:
> > Hi,
> >
> > I'm contributing to develop an open source scraper for COVID-19 data
> > and we are looking to download the population data from Wikidata for
> > regions around the world.
> >
> > First, we'd like to get province / state / county items but later on
> > probably much finer granularity. We have Wikidata Q id-s from Natural
> > Earth, we just don't know how to get the population data from Wikidata
> > without scraping. I've seen that there is either a 71 GB gzip JSON
> > archive or the query service on https://query.wikidata.org/.
> >
> > What I'm looking for would be very simple, just {"Q1234567":
> > population} pairs in a JSON, I guess the query service would be ideal,
> > but I have no idea how to use it (even after looking at the tutorial).
> >
> > Can you help me write this very simple query?
> >
> > Zsolt
> >
> > _______________________________________________
> > Wikidata mailing list
> > Wikidata@lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/wikidata
> >
>
> _______________________________________________
> Wikidata mailing list
> Wikidata@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Reply via email to