Daniel Mietchen

Joined 15 November 2012
There are 113,866,608 content pages on Wikidata, of which 108,932,250 are items and 11,723 properties.
Wikidata URIs for different formats, e.g. https://www.wikidata.org/entity/Q1.rdf or https://www.wikidata.org/wiki/Special:EntityData/Q1.rdf?flavor=simple.
Wikidata RDF model
Lexicographic data on Wikidata, and tools around that
Tool for visualizing the contribution history on Wikipedia
Wikidatatrust, a tool for visualizing who contributed to which Wikidata statement

I am a biophysicist (Q14906342) interested in integrating research workflow (Q115682347) with online collaboration (Q116095133) — particularly if they relate to biodiversity (Q47041), medicine (Q11190), mathematics (Q395), cultural heritage (Q210272) or open science (Q309823). My contributions here cover similar topics, with a focus on scholarly publications as sources for statements in Wikidata, and the integration of scholarly and Wikimedia workflows more generally.

My most recent affiliations are as follows (see my ORCID profile for details):

I enjoy most of the interactions with the Wikidata community, which sometimes trigger wiki thanks.

For semi-automated or tool-assisted edits, I am experimenting with a separate account over at User:Research Bot.

Wikidata stats edit

Wikidata statistics
 
  Number of pages 113,866,608  
  User total 6,387,772  
  Active users list 25,428  
  Administrators 71  
  Users/administrator 358  


Most recently created pages edit

The ten most recently created items edit

The ten most recently created properties edit

The ten most recently created lexemes edit

See also Wikidata:Lexical Masks.

The ten most recently created pages in the Wikidata namespace edit


The ten most recently created pages in the Entity schema namespace edit

See also Special:NewEntitySchema, the Schema directory, a list of schemas and Schema visualization as well as YASHE.

Properties I am interested in edit

Wikidata list-based gallery edit

As per Wikidata:Database reports/birthday today:

 

Lennart Carleson (1928-03-18)
Stockholm

 

Brad Dourif (1950-03-18)
Huntington

 

Salome Zourabichvili (1952-03-18)
Paris

 

Ingemar Stenmark (1956-03-18)
Joesjö

 

Luc Besson (1959-03-18)
Paris

 

Vanessa Williams (1963-03-18
1963)

The Bronx

 

Queen Latifah (1970-03-18)
Newark

 

Adam Levine (1979-03-18)
Los Angeles

End of automatically generated list.

See also

Arbitrary access edit

Other stuff edit

Popular pages edit

Topic Pages edit

The PLoS Computational Biology articles serving as the basis for Wikipedia entries should be properly represented at Wikidata, which they are not yet. Dumping the list here for the moment - help is welcome.

These should link to the respective topic items via "main subject".

PAWS edit

Demos edit

Wikidata lists

Templates edit

Genome annotation releases edit

Ontologies edit

SPARQL edit

Interesting papers edit

Most viewed Wikidata pages edit

Wikidata and Commons edit

Property constraints edit

Properties around topics and research fields edit

QuickStatementsBot and Reinheitsgebot edit

Yet more to dig into edit

Labels, descriptions, aliases per language edit

Navel Gazer edit

Related Properties edit

Data Drainer edit

Cradle edit

Bugs to report edit

Italics in titles not recognized upon import edit

See also this discussion and its on-wiki counterpart.

Phenotype edit
Origin of the problem edit
Variants of the problem edit
Flagging edit

See also Help:Ranking and Help:Deprecation and usage stats for deprecated rank as well as for preferred rank

Examples edit

The problem may not be apparent from what is currently displayed here, so it is advisable to check the version history for the items in question.

MathML in titles edit

e.g.

No auto-relinking after merging of lexemes? edit

Quality control and maintenance for WikiProjects edit

Wikidata edit
English Wikipedia edit

Wrong translations edit

Tools gallery edit

MediaWiki graphs based on Wikidata query edit

Multilingual Wikipedia edit

Game to add senses to lexemes edit

Game to add descriptions to items edit

Learning game based on Wikidata SPARQL queries edit


Optimizing SPARQL queries edit

Wikidata blame edit

Template:Compare Wikidata with CSV edit

The Book edit

  • shows the first paragraph and first image for a set of articles on the same page, just like in old lexica
  • examples:

Search properties edit

Clickstream data visualizations edit


Topic tagging for taxa edit

Image tagging for works edit

srsearch edit

gsrsearch edit

DOI queries for citations edit

  • The following query uses these:
  • Properties: describes a project that uses (P4510)     , DOI (P356)     
    #title: DOIs of works that are describing a project that uses a given resource
    PREFIX target: <http://www.wikidata.org/entity/Q112063555>
    
    SELECT DISTINCT ?doi
    WITH {
      SELECT DISTINCT ?work WHERE {
        ?work wdt:P4510 target: .
      }
    } AS %works
    WHERE {
      INCLUDE %works
      ?work wdt:P356 ?doi .
    }
    
  • The following query uses these:
  • Properties: main subject (P921)     , cites work (P2860)     , DOI (P356)     
    #title: DOIs of works that are citing or cited by works on a given topic
    PREFIX target: <http://www.wikidata.org/entity/Q112158389> 
    
    SELECT DISTINCT 
    # (ENCODE_FOR_URI(?doi_) AS ?doi)
      ?doi_
    WITH {
      SELECT  ?cite_work 
      WHERE {
        ?work wdt:P921 target:
        {?cite_work wdt:P2860 ?work .}
        UNION
        {?cite_work ^wdt:P2860 ?work .}
      }
      GROUP BY ?cite_work
    } AS %result
    WHERE {
      INCLUDE %result
      ?cite_work wdt:P356 ?doi_ .
    }
    
  • The following query uses these:
  • Properties: author (P50)     , cites work (P2860)     , DOI (P356)     
    #title: DOIs of works that are citing or cited by works by a given author
    PREFIX target: <http://www.wikidata.org/entity/Q20895785>
    
    SELECT DISTINCT (ENCODE_FOR_URI(?doi_) AS ?doi)
    WITH {
      SELECT  ?cite_work 
      WHERE {
        ?work wdt:P50 target:
        {?cite_work wdt:P2860 ?work .}
        UNION
        {?cite_work ^wdt:P2860 ?work .}
      }
      GROUP BY ?cite_work
    } AS %result
    WHERE {
      INCLUDE %result
      ?cite_work wdt:P356 ?doi_ .
    }
    
  • The following query uses these:
  • Properties: cites work (P2860)     , DOI (P356)     
    #title: DOIs of works that are citing or cited by a given work
    PREFIX target: <http://www.wikidata.org/entity/Q27340070>
    
    SELECT DISTINCT (ENCODE_FOR_URI(?doi_) AS ?doi)
    WITH {
      SELECT  ?cite_work 
      WHERE {
        {?cite_work wdt:P2860 target: .}
        UNION
        {?cite_work ^wdt:P2860 target: .}
      }
      GROUP BY ?cite_work
    } AS %result
    WHERE {
      INCLUDE %result
      ?cite_work wdt:P356 ?doi_ .
    }
    
  • The following query uses these:
  • Properties: main subject (P921)     , part of (P361)     , facet of (P1269)     , instance of (P31)     , subclass of (P279)     , publication date (P577)     , DOI (P356)     
    #title: DOIs of works that are citing or cited by works one or both of two given topics
    PREFIX target1: <http://www.wikidata.org/entity/Q21447895>
    PREFIX target2: <http://www.wikidata.org/entity/Q2539>
    
    SELECT ?doi
    WITH {
      SELECT DISTINCT ?work WHERE {
        { ?work wdt:P921 / (wdt:P361+ | wdt:P1269+ | (wdt:P31* / wdt:P279*) ) target1: . }
        UNION
        { ?work wdt:P921 / (wdt:P361+ | wdt:P1269+ | (wdt:P31* / wdt:P279*) ) target2: . }
      }
    } AS %works
    WITH {
      SELECT (MAX(?dates) as ?datetime) ?work 
      WHERE {
        INCLUDE %works
        ?work wdt:P921 ?topic . 
        ?work wdt:P577 ?dates . 
      }
      GROUP BY ?work
    } AS %result
    WHERE {
      INCLUDE %result
      # There is a problem with BC dates
      # BIND(xsd:date(?datetime) AS ?date)
      BIND(REPLACE(STR(?datetime), 'T.*', '') AS ?date)
      ?work wdt:P356 ?doi .    
    }
    # GROUP BY ?date ?work ?workLabel ?topicsUrl ?topics
    ORDER BY DESC(?date)
    LIMIT 200
    
  • The following query uses these:
  • Properties: published in (P1433)     , cites work (P2860)     , DOI (P356)     
    #title: DOIs of works that are citing or cited by works published in a given venue
    PREFIX target: <http://www.wikidata.org/entity/Q15758330>
    
    SELECT DISTINCT (ENCODE_FOR_URI(?doi_) AS ?doi)
    WITH {
      SELECT  ?cite_work 
      WHERE {
        ?cite_work wdt:P1433 target: .
        {?cite_work wdt:P2860 target: .}
        UNION
        {?cite_work ^wdt:P2860 target: .}
      }
      GROUP BY ?cite_work
    } AS %result
    WHERE {
      INCLUDE %result
      ?cite_work wdt:P356 ?doi_ .
    }
    

Curation query for works, with capitatlization variants edit

The following query uses these:

  • Properties: author (P50)     , author name string (P2093)     , object named as (P1932)     
    # tool: scholia
    PREFIX target: <http://www.wikidata.org/entity/Q21045365> # Initial Sequencing of the human genome
    
    SELECT
    (COUNT(?work) AS ?count) 
    ?string 
    (CONCAT("https://author-disambiguator.toolforge.org/names_oauth.php?doit=Look+for+author&name=", 
            ENCODE_FOR_URI(?string)) AS ?author_resolver_url) 
    WITH {
      SELECT DISTINCT ?authorstring WHERE {
        target: wdt:P50 ?authorQID .    
        { target: wdt:P2093 ?authorstring . }
        UNION
        {
          { ?authorQID skos:altLabel ?author_. }
          UNION
          { ?authorQID rdfs:label ?author_. }
          BIND(STR(?author_) AS ?authorstring)
        }
        UNION
        {
          ?author_statement ps:P50 ?authorQID ;
                            pq:P1932 ?authorstring.
        }
      }
      LIMIT 10000
    } AS %rawstrings
    WITH
    # This part is due to Dipsacus fullonum, as per https://w.wiki/5Brk
    {
      # Calculate capitalization variants of these raw strings
      SELECT DISTINCT ?string
      WHERE
      {
        {
          INCLUDE %rawstrings
          BIND(STR(?authorstring) AS ?string) # the raw strings
        }
        UNION
        {
          INCLUDE %rawstrings
          BIND(UCASE(STR(?authorstring)) AS ?string) # uppercased versions of the raw strings
        }
        UNION
        {
          INCLUDE %rawstrings
          BIND(LCASE(STR(?authorstring)) AS ?string) # lowercased versions of the raw strings
        }
      }
    } AS %normalizedstrings
    WHERE {
      # Find works that have "author name string" values equal to these normalized strings
      INCLUDE %normalizedstrings
      ?work wdt:P2093 ?string. 
    }
    GROUP BY ?string
    ORDER BY DESC (?count)
    LIMIT 200
    

Usage tagging edit

Generic edit

Words and phrases frequently occurring after "using" in titles of articles edit

The following query uses these:

  • Properties: title (P1476)     
    #title: Words and phrases frequently occurring after "using" in titles of articles
    SELECT 
      DISTINCT
        ?using ?N (COUNT(?item) AS ?count)
    WHERE {
      hint:Query hint:optimizer "None".
      
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" and haswbstatement:P31=Q13442814".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
    UNION
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" -and haswbstatement:P31=Q13442814".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
      BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
      
      ?item wdt:P1476 ?title.
      BIND(STRAFTER(LCASE(?title), "using ") AS ?using) 
      BIND(STRLEN(REPLACE(?using, "\\b", "")) + 1 as ?N)
    }
    GROUP BY ?using ?N ?count
    ORDER BY DESC(?count)
    
Words and phrases frequently occurring after "using" in titles of articles without P4510 statement edit

The following query uses these:

  • Properties: title (P1476)     
    #title: Words and phrases frequently occurring after "using" in titles of articles without P4510 statement
    SELECT 
      DISTINCT
        ?using ?N (COUNT(?item) AS ?count)
    WHERE {
      hint:Query hint:optimizer "None".
      
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" and haswbstatement:P31=Q13442814 -haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
    UNION
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" -and haswbstatement:P31=Q13442814 -haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
      BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
      
      ?item wdt:P1476 ?title.
      BIND(STRAFTER(LCASE(?title), "using ") AS ?using) 
      BIND(STRLEN(REPLACE(?using, "\\b", "")) + 1 as ?N)
    }
    GROUP BY ?using ?N ?count
    ORDER BY DESC(?count)
    


Words and phrases frequently occurring after "using" in titles of articles with P4510 statement edit

The following query uses these:

  • Properties: title (P1476)     
    #title: Words and phrases frequently occurring after "using" in titles of articles with P4510 statement
    SELECT 
      DISTINCT
        ?using ?N (COUNT(?item) AS ?count)
    WHERE {
      hint:Query hint:optimizer "None".
      
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" and haswbstatement:P31=Q13442814 haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
    UNION
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using\" -and haswbstatement:P31=Q13442814 haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
      BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
      
      ?item wdt:P1476 ?title.
      BIND(STRAFTER(LCASE(?title), "using ") AS ?using) 
      BIND(STRLEN(REPLACE(?using, "\\b", "")) + 1 as ?N)
    }
    GROUP BY ?using ?N ?count
    ORDER BY DESC(?count)
    

Software edit

The following query uses these:

  • Properties: main subject (P921)     , describes a project that uses (P4510)     , programmed in (P277)     , title (P1476)     
    PREFIX target: <http://www.wikidata.org/entity/Q202864>
    
    SELECT ?item ?title ?n #?type ?typeLabel 
    WHERE {
     {
       SELECT  DISTINCT ?item ?n WHERE {
         ?paper wdt:P921 target: .
         ?paper wdt:P4510 ?soft .
         ?soft wdt:P277 [] .
         ?soft rdfs:label ?n.
        FILTER(LANG(?n) = "en").
        SERVICE wikibase:mwapi {
          bd:serviceParam wikibase:endpoint "www.wikidata.org";
                          wikibase:api "Generator";
                          mwapi:generator "search";
                          mwapi:gsrsearch ?n ;
                          mwapi:gsrlimit "max".
          ?item wikibase:apiOutputItem mwapi:title .
        }
      } LIMIT 10000
     }
     hint:Prior hint:runFirst "true".
     ?item wdt:P1476 ?title .
    } 
    LIMIT 1000
    

Ultrasound edit

The following query uses these:

  • Properties: title (P1476)     
    SELECT 
      DISTINCT
        ?using ?N (COUNT(?item) AS ?count)
    WHERE {
      hint:Query hint:optimizer "None".
      
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using ultrasound\" and haswbstatement:P31=Q13442814 -haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
    UNION
    {  SERVICE wikibase:mwapi {
        bd:serviceParam wikibase:api "Search";
                        wikibase:endpoint "www.wikidata.org";
                        mwapi:srsearch "\"using ultrasound\" -and haswbstatement:P31=Q13442814 -haswbstatement:P4510".
          ?page_title wikibase:apiOutput mwapi:title.
      }
     }
      BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
      
      ?item wdt:P1476 ?title.
      BIND(STRAFTER(LCASE(?title), "using ultrasound ") AS ?using) 
      BIND(STRLEN(REPLACE(?using, "\\b", "")) + 1 as ?N)
    }
    GROUP BY ?using ?N ?count
    ORDER BY DESC(?count)
    

variants edit

Referencing PMC edit

The following query uses these:

  • Properties: describes a project that uses (P4510)     , PMCID (P932)     
    SELECT 
      DISTINCT
    #   ?item ?pmcid
      (REPLACE(STR(?item), ".*Q", "Q") AS ?qid) 
      ("P4510" AS ?property)
      ("Q70357595" AS ?Jupyter)
      ("S248" AS ?statedin)
      ("Q229883" AS ?PMC)
      ("S854" AS ?heuristic)
      (CONCAT(
          '\"https://eutils.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi?db=pmc&id=PMC', ENCODE_FOR_URI(?pmcid), '&rettype=xml\"') AS ?resolver_url)
      ("S813" AS ?retrieved)
      ("+2022-05-24T00:00:00Z/11" AS ?date)
    
    WHERE {
      ?item wdt:P4510 wd:Q70357595 ;
            wdt:P932 ?pmcid .
    }
    

Taxon author name disambiguator edit

as per

Autofix testing edit

Background edit

Test cases edit

DOI (P356) edit
title (P1476) edit

Full-text search edit

Central External Resource Scraping and Extraction Infrastructure (CERSEI) edit

Wikibase edit

Subpages edit

Babel user information edit

I find the current way of handling this information rather unwieldy, but since it is basically required for editing Wikidata in multiple languages, I'm just pushing it to the bottom of the page, along with some pointers to topics or tools of interest.

Babel user information
 This user uses Scholia.
 This user is a member of
WikiProject Open Access.
 This user is a member of
WikiProject Mathematics
 This user is a member of
WikiProject Medicine
.
 This user is a member of
WikiProject Physics.
 This user is a member of WikiProject Chemistry.
 This user is a member of WikiProject COVID19.
 This user uses QuickStatements.
 This user loves Wikidata.
 This user uses Mix'n'match.
 This user is a member of WikiProject India.
 This user contributes using Mozilla Firefox.
 This contributor uses Project Jupyter (Q55630549).
 This user shares their books on inventaire.io (Q32193244).
 This user is on GitHub.
Users by language
Babel user information
de-N Dieser Benutzer spricht Deutsch als Muttersprache.
en-4 This user has near native speaker knowledge of English.
fr-4 Cet utilisateur dispose de connaissances proches de la langue maternelle en français.
ru-4 Этот участник владеет русским языком почти как родным.
eo-2 Ĉi tiu uzanto havas meznivelan scion de Esperanto.
es-2 Esta persona tiene un conocimiento intermedio del español.
it-2 Questo utente può contribuire con un livello intermedio in italiano.
la-2 Hic usor lingua Latina mediae difficultatis conferre potest.
nl-2 Deze gebruiker heeft basiskennis van het Nederlands.
sv-2 Den här användaren har medelgoda kunskaper i svenska.
uk-2 Цей користувач володіє українською мовою на середньому рівні.
eo-2 Ĉi tiu uzanto havas meznivelan scion de Esperanto.
af-1 Hierdie gebruiker het basiese kennis van Afrikaans.
ar-1 هذا المستخدم لديه معرفة أساسية بالعربية.
bg-1 Този потребител има основни познания по български език.
ca-1 Aquest usuari té un coneixement bàsic de català.
cs-1 Tento uživatel má základní znalosti češtiny.
da-1 Denne bruger har grundlæggende kendskab til dansk.
el-1 Αυτός ο χρήστης έχει βασικές γνώσεις Ελληνικών.
fa-1 این کاربر فارسی را در حد مقدماتی می‌فهمد.
ja-1 この利用者は初級日本語ができます。
kk-1 Бұл қатысушы қазақша бастапқы деңгейде меңгереді.
ko-1 이 사용자는 한국어조금 할 수 있습니다.
ky-1 Бул колдонуучу кыргыз тилин башталгыч деңгээлде билет.
nb-1 Denne brukeren har grunnleggende kjennskap til norsk bokmål.
pl-1 Ten użytkownik posługuje się językiem polskim na poziomie podstawowym.
pt-1 Este utilizador tem um nível básico de português.
ro-1 Acest utilizator poate contribui cu un nivel de bază de română.
sh-1 Ovaj korisnik zna srpskohrvatski / српскохрватски na osnovnoj razini.
sk-1 Tento užívateľ má základné znalosti slovenčiny.
sl-1 Uporabnik pozna osnove slovenskega jezika.
sw-1 Mtumiaji huyu ni mwongeaji wa Kiswahili cha kiwango cha Msingi.
tg-1 Ин корбар тоҷикӣро дар сатҳи муқаддамотӣ мефаҳмад.
tr-1 Bu kullanıcı temel düzeyde Türkçe bilir.
ur-1 یہ صارف اردو کا بنیادی علم رکھتا ہے۔
uz-1 Bu foydalanuvchi oʻzbek tilini boshlangʻich darajada biladi.
zh-1 这位用户的中文达到初级水平
ee-0 Ezãla sia mese Eʋegbe o.
fi-0 Tämä käyttäjä osaa hyvin vähän tai ei lainkaan suomea.
hi-0 इस सदस्य को हिन्दी का ज्ञान नहीं है (अथवा समझने में बहुत परेशानी होती है)।
hu-0 Ez a szerkesztő nem beszéli a magyar nyelvet (vagy csak nagyon nehezen érti meg).
is-0 Þessi notandi talar ekki íslensku (á erfitt með að skilja hana eða kýs að tala hana ekki).
sa-0 एषः सदस्यः संस्कृतेन लेखितुं शक्नोति (अथवा तु बहुकष्टेन ज्ञातुं प्रभवति ।)।
simple-4 This user has near native speaker knowledge of Simple English.
Users by language
Authority control