User:Daniel Mietchen

From Wikidata
Jump to navigation Jump to search
There are 114,327,793 content pages on Wikidata, of which 109,362,698 are items and 11,799 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 114,327,793  
  User total 6,432,122  
  Active users list 25,057  
  Administrators 71  
  Users/administrator 353  


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:

Jan Hammer (1948-04-17)
Prague

Afrika Bambaataa (1957-04-17)
New York City

Nick Hornby (1957-04-17)
Redhill

Peter Doig (1959-04-17)
Edinburgh

Sean Bean (1959-04-17)
Handsworth

Adam McKay (1968-04-17)
Philadelphia

Jennifer Garner (1972-04-17)
Houston

Victoria Beckham (1974-04-17)
Harlow

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)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, cites work (P2860)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, cites work (P2860)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, part of (P361)  View with Reasonator View with SQID, facet of (P1269)  View with Reasonator View with SQID, instance of (P31)  View with Reasonator View with SQID, subclass of (P279)  View with Reasonator View with SQID, publication date (P577)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, cites work (P2860)  View with Reasonator View with SQID, DOI (P356)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, author name string (P2093)  View with Reasonator View with SQID, object named as (P1932)  View with Reasonator View with SQID
    # 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)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID
    #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)  View with Reasonator View with SQID, describes a project that uses (P4510)  View with Reasonator View with SQID, programmed in (P277)  View with Reasonator View with SQID, title (P1476)  View with Reasonator View with SQID
    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)  View with Reasonator View with SQID
    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)  View with Reasonator View with SQID, PMCID (P932)  View with Reasonator View with SQID
    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
Scholia logoThis 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.
QuickStatements logoThis 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).
Inventaire logoThis 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