Wikidata

Daniel Mietchen

Joined 15 November 2012
User page Discussion
There are 108,210,205 content pages on Wikidata, of which 103,558,906 are items and 11,011 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 statsEdit

Wikidata statistics
 
  Number of pages 108,210,205  
  User total 5,992,234  
  Active users list 24,274  
  Administrators 67  
  Users/administrator 362  


Most recently created pagesEdit

The ten most recently created itemsEdit

The ten most recently created propertiesEdit

The ten most recently created lexemesEdit

See also Wikidata:Lexical Masks.

The ten most recently created pages in the Wikidata namespaceEdit


The ten most recently created pages in the Entity schema namespaceEdit

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

Properties I am interested inEdit

Wikidata list-based galleryEdit

As per Wikidata:Database reports/birthday today:

 

Bob Dylan (1941-05-24)
Duluth

 

Fraser Stoddart (1942-05-24)
Edinburgh

 

Patti LaBelle (1944-05-24)
Philadelphia

 

Priscilla Presley (1945-05-24)
Brooklyn

 

Tansu Çiller (1946-05-24)
Istanbul

 

Jim Broadbent (1949-05-24)
Lincoln

 

Alfred Molina (1953-05-24)
Paddington

 

Kristin Scott Thomas (1960-05-24)
Redruth

End of automatically generated list.

See also

Arbitrary accessEdit

Other stuffEdit

Popular pagesEdit

Topic PagesEdit

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".

PAWSEdit

DemosEdit

Wikidata lists

TemplatesEdit

Genome annotation releasesEdit

OntologiesEdit

SPARQLEdit

Interesting papersEdit

Most viewed Wikidata pagesEdit

Wikidata and CommonsEdit

Property constraintsEdit

Properties around topics and research fieldsEdit

QuickStatementsBot and ReinheitsgebotEdit

Yet more to dig intoEdit

Labels, descriptions, aliases per languageEdit

Navel GazerEdit

Related PropertiesEdit

Data DrainerEdit

CradleEdit

Bugs to reportEdit

Italics in titles not recognized upon importEdit

See also this discussion and its on-wiki counterpart.

PhenotypeEdit
Origin of the problemEdit
Variants of the problemEdit
FlaggingEdit

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

ExamplesEdit

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 titlesEdit

e.g.

No auto-relinking after merging of lexemes?Edit

Quality control and maintenance for WikiProjects on enwpEdit

Wrong translationsEdit

Tools galleryEdit

MediaWiki graphs based on Wikidata queryEdit

Multilingual WikipediaEdit

Game to add senses to lexemesEdit

Game to add descriptions to itemsEdit

Learning game based on Wikidata SPARQL queriesEdit


Optimizing SPARQL queriesEdit

Wikidata blameEdit

Template:Compare Wikidata with CSVEdit

The BookEdit

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

Search propertiesEdit

Clickstream data visualizationsEdit


Topic tagging for taxaEdit

Image tagging for worksEdit

srsearchEdit

gsrsearchEdit

DOI queries for citationsEdit

  • 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 variantsEdit

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

Usage taggingEdit

GenericEdit

Words and phrases frequently occurring after "using" in titles of articlesEdit

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 statementEdit

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 statementEdit

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

SoftwareEdit

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

UltrasoundEdit

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

variantsEdit

Referencing PMCEdit

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 .
}
Run it!

Taxon author name disambiguatorEdit

as per

Autofix testingEdit

BackgroundEdit

Test casesEdit

DOI (P356)Edit
title (P1476)Edit

Full-text searchEdit

SubpagesEdit

Babel user informationEdit

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 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 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
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Daniel_Mietchen&oldid=1901197177"