Ideally Wikidata would have great information for the entire history of every country, but for the sake of making this investigation a little bit more manageable, we’re going to reduce that scope a bit. Given that we’re already restricting this to UN member states, the obvious approach is to check how good the information is back to the point at which they became members.
So let’s update our SPARQL to also include the date countries joined:
https://gist.github.com/tmtmtmtm/b2de6e919d623cffa4e38704cc738ea4
That, rather surprisingly, gives us 194 results, rather than 193, however.
After a bit of investigation it seems that Indonesia joined, then left, then joined again, and so gets returned twice. So we probably also want to update the query to remove any memberships with an end date:
https://gist.github.com/tmtmtmtm/71f54ed7fa1f3e9a49026b6613d805f6
This time we get the 193 results we expect.
Leave a Reply