söndag 19 november 2017


  • Q3356092 Administrative territorial entity of Ireland
    • list 
      • wd:Q179872 County of Ireland
      • wd:Q486972  community of - feels like Ireland has bad structure in Wikidata


Districts Q1149652 - 748

torsdag 16 november 2017


Example what is in Wikidata that could be used in WikiTree for making categories with good infoboxes and good structures.... all pictures are from Wikicommon and are CC0 = "no copyright reserved" 
See also:

Below query

SELECT ?item ?itemLabel  ?itemDescription ?img ?map ?start ?location ?admLabel ?capital ?short(?admLabel as ?layer) ?Geoname WHERE {
  ?item wdt:P31 wd:Q328584.
  OPTIONAL {?item wdt:P625 ?location}
  OPTIONAL {?item wdt:P131 ?adm}
  OPTIONAL {?item wdt:P18 ?img}
  OPTIONAL {?item wdt:P242 ?map}
  OPTIONAL {?item wdt:P571 ?start}
  OPTIONAL {?item wdt:P1813 ?short}
  OPTIONAL {?item wdt:P36 ?capital}
  OPTIONAL {?item wdt:P1566 ?geonameID}
  BIND(URI(CONCAT("http://www.geonames.org/",?geonameID)) AS ?Geoname)

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "sl","en","de","es" . 
order by ?itemLabel


Image grid showing overview maps and pictures from the area

Pictures in Wikicommon are CC0 = "no copyright reserved" 

Just overview maps from Wikicommon that can be copied and used....

Pictures in Wikicommon are CC0 = "no copyright reserved" 

Wikidata and OSM - Linked data - same as Wikidata....

Open Street map has a tag for Wikidata ==> If we have the wikidata object its easy find the node/relation in OSM. Borders are in OSM implemented as relations....

  • Q507051 is Občina Kranjska Gora
  • A search can be done see link to find the object in OSM with Wikidata tag using Overpass and the query language

    out body;
    out skel qt;

    ==> we get OSM relation 1675593 ==> link https://www.openstreetmap.org/relation/1675593 
See also

How to extract data to a spreadsheet

wd:Q852446 United States

  • wd:Q852446 administrative territorial entity of the United States
    • List 

Images for counties

Pictures in Wikicommon are CC0 = "no copyright reserved" 


Just locator maps

Pictures in Wikicommon are CC0 = "no copyright reserved" 


Arrondissement - 448

Cantone de France - 5535

Communes of France - 38476

Video time

måndag 13 november 2017

referenser i Wikidata och Döboken

Exempel på hur man kan referera i Wikidata till Svensk Dödbok Q10686079

dvs. Wikidata Q3109655#P569

  1. Property P569 födelsedatum
    1. Har 3 referenser 
      1. data.bnf.fr
      2. SBL från Riksarkivet
      3. Sveriges Dödbok som anges med
        1. P248 Anges i
          1. Värde Q10686079 Sveriges Dödbok
        2. Datum vi kollade Property:P813 
          1. 13 nov 2017
        3. Omnämd som Property 1810 
          1. innehåller nyckel och namn på Döskivan 

söndag 12 november 2017

P2168 Svensk Filmdatabas

* alla med P2168 = +51000

Verkar vara som web:en byggts om


Hitta Wikidata/Wikipedia artikel utifrån ID i Filmdatasen

För att hitta Wikidata objektet för person med ID 60950 i Svensk Filmdatabas kan man fråga på property P2168 ==>

 ==> Svensk Wikipedia Wolfgang_Amadeus_Mozart

Wikidata har +4000 externa identifierare ==>

Går att ställa frågor med frågespråket SPARQL på många olika sätt

Se även hur MOMA i New York kopplar till Wikidata på sin WEB

måndag 6 november 2017

Wikidata People in SBL with occupation music and no Spotify ID

select distinct  ?Spotify ?person ?death ?personLabel  ?personDescription

   { ?person wdt:P3217 ?SBLID .}
   { ?person wdt:P570 ?death .}
   minus  { ?person wdt:P1902 ?SpotifyID .}
   {?person wdt:P106/wdt:P279* wd:Q639669}
   BIND (URI(CONCAT("https://open.spotify.com/artist/",?SpotifyID)) AS ?Spotify)
   SERVICE wikibase:label { bd:serviceParam wikibase:language "sv","en"}
Order by Desc(?death)


lördag 4 november 2017

Wikidata checks gender diversity

Question: Why is there a big difference between Sweden and Finland in the number women documented at SBL vs. Kansallisbiografia?

Below external identifiers in Wikidata and gender diversity

Feels like Wikidata can be a way to "benchmark" gender diversity between external source e.g. 

P3222 Nationalencyklopedin Online - Ratio: 11%

Male: 11724 - Female: 1576

P3217 Swedish National Archive SBL - Ratio: 6 %

Male: 6901 - Female: 508

P2538 Nationalmuseum Sweden artist - Ratio: 10 %

Male: 4088 - Female: 460

P2180 Finnish Kansallisbiografia - Ratio: 14,5 %

Male: 4270 - Female: 735

P4357 Swedish Musikverket - Ratio: 50 %

Male: 792 - Female: 801

P3360 Nobel Prize People Nomination - Ratio: 5 %

Male: 3102 - Female: 147

P1138 Nobel prize ID - Ratio: 10 %

Male: 4141 - Female: 463

Next step ?

I can see as Wikidata gets more information we can start measure
  1. How well museums document minorites
  2. Minority languages
  3. People working in the whole country and not just people in e.g. the capital of Stockholm
  4. Start create maps like below but for how well they support diversity

onsdag 1 november 2017

Haplogroups in Wikidata

This weekend we had a great event in Berlin Wikidata 5 years plus 2 new properties were created
Lesson learned is that 
Some questions challenges

  1. How to do this useable?
  2. What level of the Haplogroup should be tracked in Wikidata
  3. Can Wikidata be the stable object that can track differences in haplogroups between different vendors etc... 

Example of how a record in Wikidata can be defined

Edvard IV av England

Below Edvard IV with references to studies.... best would be if we could have referencies to test results.....

List instances of mitochondrial DNA haplogroup Q42262065 or any of the classes in its subclass tree today in Wikidata

List instances of Y-DNA Haplogroups Q42262353 or any of the classes in its subclass tree

  • Number of people in Wikidata is today 3,5 million link


Nice application to view graves in Wikidata on a map