Wikidata is an online database which contains many details about many countries, politicians, paintings, etc. For instance, for each
country you have
map, which are all strings or URLs to online images.
How can I simply generate a CSV file containing the item type and properties I want?
For instance, if I say I want all
countrys and their
capital, then it would generate a CSV file like this:
country;capital India;New Delhi Brazil;Brasília ...
Any OS/webapp/app is OK. Preferably open source.
I don’t want to download the whole Wikidata database locally, so the tool would have to make requests to the official live server.
[Read, comment, and vote on my answer at Stack Exchange]
There are many tools to accomplish your goals and the advantages and disadvantages largely depend on your current skill set. Therefore, I will simply list the tools that I know about you will have to examine which tools match the languages your know and the platforms you have access to. Furthermore, my experiences is that all of the tools are imperfect and that you will have to improve them to get exactly what you need.
The information you are looking for almost certainly already exists somewhere. CIA world fact book, UN databases, and open data sources certainly have this information.