Wikidata

User:Daniel Mietchen

There are 119,707,225 content pages on Wikidata, of which 114,553,832 are items and 12,259 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 119,707,225  
  User total 6,726,669  
  Active users list 24,631  
  Administrators 73  
  Users/administrator 337  


Most recently created pages

edit

The ten most recently created items

edit

18 November 2024


The ten most recently created properties

edit

18 November 2024

17 November 2024

15 November 2024

13 November 2024

12 November 2024


The ten most recently created lexemes

edit

See also Wikidata:Lexical Masks.

18 November 2024


The ten most recently created pages in the Wikidata namespace

edit

18 November 2024


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.

29 October 2024


Properties I am interested in

edit
edit

As per Wikidata:Database reports/birthday today:

 

Pierre Nora (1931-11-17)
8th arrondissement of Paris

 

Martin Scorsese (1942-11-17)
Queens

 

Rem Koolhaas (1944-11-17)
Rotterdam

 

Danny DeVito (1944-11-17)
Neptune Township

 

amin berrabahgay (1945-11-17)
Mécheria

 

John Boehner (1949-11-17)
Reading

 

Stephen Root (1951-11-17)
Sarasota

 

Cyril Ramaphosa (1952-11-17)
Soweto

End of automatically generated list.

See also

Arbitrary access

edit

Other stuff

edit
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
edit
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
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 .
}
DOIs of works that are describing a project that uses a given resource
  • 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_ .
}
DOIs of works that are citing or cited by works on a given topic
  • 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_ .
}
DOIs of works that are citing or cited by works by a given author
  • 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_ .
}
DOIs of works that are citing or cited by a given work
  • 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
DOIs of works that are citing or cited by works one or both of two given topics
  • 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_ .
}
DOIs of works that are citing or cited by works published in a given venue

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
Try it!

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
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 without P4510 statement


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)
Words and phrases frequently occurring after "using" in titles of articles with P4510 statement

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
Try it!

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)
Try it!

variants

edit

Referencing PMC

edit

The following query uses these:

  • Properties: describes a project that uses (P4510)     , PMC publication ID (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 .
}
Try it!

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

ORCID scraper

edit

ORCIDator

edit

PubMedbyORCID

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 is a Participant of the Wikimedians for Sustainable Development
 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 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 Quest'utente può contribuire con un livello intermedio in italiano.
la-2 Hic usor/Haec ustrix 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).
mn-0 Энэ хэрэглэгч монгол хэлний мэдлэггүй байна (эсвэл их хүндрэлтэйгээр ойлгодог).
ne-0 यी प्रयोगकर्तासित नेपाली भाषाको ज्ञान छैन (अथवा कठिनता पूर्वक बुझ्दछन्).
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
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Daniel_Mietchen&oldid=2273806914"