[Wikidata-l] Query generator spreadsheet - Wikidata

9 Mar 2015

Hi all,

We've been using WDQ queries a lot recently to update timelines in the
Histropedia directory and, while trying to speed up the process, I ended up
creating a very crude query generator tool over the weekend. After getting
a bit carried away with it, it seemed worth sharing as it could actually be
a handy tool for Wikidata editors, or anyone else interested in
experimenting with queries.

I have no real coding experience, so it's just made in a humble
spreadsheet! You can choose the input values for a query and the links to
Histropedia, AutoList and WDQ will update automatically.The idea is
obviously that this sort of tool should be written in Javascript by someone
who actually knows what they're doing ;) but they do work and can easily be
customised by adding more Wikidata items to the available options.

I've made 3 different types of query generator so far, which I'll publish
shortly as free templates on Google Sheets:

1) Date range query generator
<https://docs.google.com/spreadsheets/d/1A8wyqVc5USJ_T8ncFfYIsmJzfy8LIdmH2QLgeyegRAM/edit?usp=sharing>

2) People finder query generator
<https://docs.google.com/spreadsheets/d/16-x7NGyHTAtEJBa5uF9ZYBhNj6BhhCJrtDaKCcJIFuE/edit?usp=sharing>

3) Family tree query generator
<https://docs.google.com/spreadsheets/d/1dNTBoi-QbI0t-t0Ba4Ex5-sx7Q03qRecE27bapQGpAw/edit?usp=sharing>

They are publicly editable spreadsheets so feel free to make a copy if
someone is using the one you land on. And certainly don't hold back if
anyone wishes to make any improvements.

I hope someone finds it useful/fun to mess around with these, but I thought
it was a nice story to share in itself - that a non-coder can sit down and
create something genuinely useful by tapping into the power of Wikidata,
and of course Magnus' amazing tools! :)

Cheers,

Navino

-- 
___________________________

Histropedia

The Timeline for all of History
www.histropedia.com

Follow us on:
Twitter <https://twitter.com/Histropedia>     Facebo
<https://www.facebook.com/Histropedia>ok
<https://www.facebook.com/Histropedia>     Google +
<https://plus.google.com/u/0/b/104484373317792180682/104484373317792180682/posts>
   L <http://www.linkedin.com/company/histropedia-ltd>inke
<http://www.linkedin.com/company/histropedia-ltd>dIn
<http://www.linkedin.com/company/histropedia-ltd>