govdirectory
Allow for multiple concurrent leaders of an organization
The feature
Allow multiple persons to show up as the leader of an organization.
We need to remove the SAMPLE in organizational-optional.rq and select all that don't have end date, but I think we need to do some queries checking that we don't get multiple values from other organizations where the data is not kept up-to-date.
Why?
In some rare occasions, there may be multiple leaders, like at the Embassy of Germany in Stockholm. We should be able to display that properly.
Examples and inspiration
https://stockholm.diplo.de/se-de/botschaft/lebenslauf-botschafter-1513398
The SAMPLE function can be replaced with GROUP_CONCAT and it should work as it is. There is an example here: https://github.com/glaciers-in-archives/snowman/tree/main/examples/nested-lists-with-single-query
Great! We still probably need to do a cleanup as Wikidata is notoriously lacking end dates on office holders still. Here is a query (with a very coarse filter) with >1500 offices with >2 office holders without end date. https://qlever.cs.uni-freiburg.de/wikidata/vvdkAx?exec=true
Most of them aren't in Govdirectory, but many are of a type that could be.