Wikidata

User:Erfurth/Science

< User:Erfurth
  • People: Prof. chem. TU-Dresden: Query
  • List of authors for a work
SELECT DISTINCT  ?order ?authorLabel WHERE {
   wd:Q56945806 p:P50 ?authors .
   ?authors ps:P50 ?author .
   ?authors pq:P1545 ?order.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY xsd:integer(?order)
  • university teachers in chemistry of tu dresden with their references count (in wikidata):
SELECT ?authorLabel (COUNT(?publication) AS ?count)
WHERE 
{
 ?item wdt:P2860 ?publication .
 ?publication wdt:P50 ?author .      
 ?author wdt:P108 wd:Q158158;
       wdt:P106 wd:Q1622272;
       wdt:P106 wd:Q593644;
       wdt:P569 ?born.
  FILTER (?born >= "1900-01-01T00:00:00Z"^^xsd:dateTime) .
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de". }
} GROUP BY ?authorLabel

Try it (IPFDD)

  • Artikel einer bestimmten Zeitschrift, Autoren als Zeichenkette
SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?authors; separator=', ') AS ?authorstring)  WHERE {
  ?item wdt:P31 wd:Q13442814.
  ?item wdt:P1433 wd:Q3274923.
  ?item wdt:P478 "30".
  ?item wdt:P433 "9-10".
  ?item wdt:P2093 ?authors.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?item ?itemLabel ?authorstring

Try it!

  • Special Issue "In Focus: Women in biointerface science"

Try it!, year=2018

  • Wissenschaftslandschaft in Sachsen

Bautzen (2) | Chemnitz (4) | Dresden (47) | Freiberg (3) | Görlitz (3) | Leipzig (19) | Meinsberg (1) | Mittweida (2) | Riesa (1) | Vogtland (3) | Zittau (3) | Zwickau (2)

  • DRESDEN-concept
SELECT ?author ?authorLabel ?facilityLabel (COUNT(?publication) AS ?count)
WHERE 
{
 ?item wdt:P2860 ?publication .
 ?publication wdt:P50 ?author .      
 ?author wdt:P108 ?facility .
 ?facility wdt:P361 wd:Q31837129.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?author ?authorLabel ?facilityLabel ORDER BY DESC (?count)
  • Publikationen von xyz bei Publishern
SELECT ?publisher ?publisherLabel (COUNT(?publisher) AS ?count) WHERE {
 ?item wdt:P31 wd:Q13442814. # wissenschaftl. Artikel
    ?item wdt:P50 ?author.
    ?author wdt:P108 wd:Q1739877. # beim IPFDD angestellt
 ?item wdt:P1433 ?publisher.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?publisher ?publisherLabel ORDER BY DESC (?count)

Software edit

scholarly articles edit 

# references of scholarly article
SELECT ?citedby ?citedbyLabel WHERE { 
   ?citedby wdt:P2860 ?pub .  
   ?pub wdt:P356 "10.1002/ANIE.200454078" .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Searching CitedBy-Authors edit 

SELECT ?authorLabel ?authorEmpLabel (COUNT(*) as ?count )
WHERE
{ 
   ?author wdt:P108 ?authorEmp.
   ?citedby wdt:P50 ?author.
   ?citedby wdt:P2860 ?pub .  
   ?pub wdt:P50 wd:Q59655686 .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   FILTER NOT EXISTS { ?author wdt:P108 wd:Q1739877 }
}
GROUP BY ?authorLabel ?authorEmpLabel
ORDER BY DESC(?count) ?authorLabel

Searching papers (fulltext) edit 

SELECT ?art ?artLabel
	WITH {
	SELECT ?art WHERE {
	?art wdt:P31 wd:Q13442814
	} LIMIT 750000 OFFSET 10500000
	} AS %RESULTS {
	INCLUDE %RESULTS
	?art wdt:P1476 ?artLabel .
	MINUS { ?art wdt:P921 wd:Q146393 }
	FILTER (contains(lcase(str(?artLabel)), "pvdf"))
	}

Finding not referenced authors edit 

#Macromolecules
SELECT ?names (COUNT(*) as ?count)
WHERE {
 ?item wdt:P1433 wd:Q2711584.
 ?item wdt:P2093 ?names.
 optional {
 ?item wdt:P50 ?author.
 }
 MINUS{?item wdt:P50 []}
} GROUP BY ?names ORDER BY DESC (?count)

Import per SQL edit 

SELECT ?sql
WHERE 
{
 ?item wdt:P106 wd:Q1650915.
 ?item wdt:P27 wd:Q183.
 ?item rdfs:label ?l filter (lang(?l) = "en").
 ?item wdt:P569 ?born.
 FILTER (?born >= "1900-01-01T00:00:00Z"^^xsd:dateTime) .
 BIND(CONCAT("insert into wd (profession,wd,name) values ('researcher','",STR(?item),"','",STR(?l),"');") as ?sql)
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Update per SQL edit 

#Macromolecules
SELECT ?sql
WHERE {
?item wdt:P1433 wd:Q2711584.
?item wdt:P2093 ?names.
optional {
?item wdt:P50 ?author.
}
BIND(CONCAT("update scientist set wd=\"Macromolecules\" where wd is null and name=\"",STR(?names),"\";") as ?sql)
MINUS{?item wdt:P50 []}
} GROUP BY ?sql
  • TryIt

Update per SPARQL edit 

SELECT ?sparql
WHERE 
{
 ?item wdt:P31 wd:Q29023906.
 ?item wdt:P276 wd:Q1792667.
 ?item rdfs:label ?l filter (lang(?l) = "nl").
 optional {
 ?item wdt:P17 ?country.
 }
 BIND(CONCAT(SUBSTR(STR(?item),32,9),"#P17#Q183#Lde#\"",STR(?l),"\"") as ?sparql)
 MINUS {
     ?item wdt:P17 [].

} 

 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nl". }
}

Journals edit 

#Journals, in denen Polymerchemiker publizieren
SELECT DISTINCT ?pub ?pubLabel (COUNT(*) as ?count)
WHERE 
{
 ?item wdt:P101 wd:Q3456979.
 ?article wdt:P50 ?item.
 ?article wdt:P1433 ?pub.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} GROUP BY ?pub ?pubLabel ORDER BY DESC (?count)

Facts edit

  • scholarly articles in WikiData: 23,058,725 (43.5%) Wikidata:Statistics/de
  • Top 100-Autoren der Angewandte Chemie International Edition der letzten 5 Jahre

Suchen edit 

#Wikidata-Items mit polymer brushes als Suchbegriff in Label per Author
SELECT ?item
WHERE 
{
  ?item wdt:P50 wd:Q61895041.
  ?item rdfs:label ?title filter (lang(?title) = "en").
  FILTER( CONTAINS( ?title, 'polymer brushes' )).
  MINUS { ?item wdt:P921 [] }
}
Try it! 
#Wikidata-Items eines Journals mit field-flow fractionation als Suchbegriff
SELECT ?item ?title ?subj
WHERE 
{
  ?item wdt:P1433 wd:Q15752537.
  ?item rdfs:label ?title filter (lang(?title) = "en").
  ?item wdt:P921 ?subj.
  FILTER( CONTAINS( ?title, 'field-flow fractionation' )).
  MINUS{
   ?item wdt:P921 wd:Q782281.
  }
}
Try it!

Scholia edit

  • cited work graph with title
   ?citing_work wdt:P577 ?citing_date . 
   ?cited_work wdt:P577 ?cited_date . 
   ?citing_work wdt:P1476 ?citing_title.
 ?cited_work wdt:P1476 ?cited_title .
    bind(year(?citing_date) as ?citing_year)
   bind(year(?cited_date) as ?cited_year)
   bind(concat(?citing_title, ", ", str(?citing_year)) as ?citing_workLabel)
   bind(concat(?cited_title, ", ", str(?cited_year)) as ?cited_workLabel)

# tool: scholia
#defaultView:Graph

PREFIX target: <http://www.wikidata.org/entity/Q19237133>

SELECT
  ?citing_work ?citing_workLabel ?rgb 
  ?cited_work ?cited_workLabel
WITH { 
  SELECT (COUNT(*) AS ?count) ?citing_work WHERE {
    target: (^wdt:P2860| wdt:P2860) / (^wdt:P2860 | wdt:P2860)? ?citing_work .
  }
  GROUP BY ?citing_work
  ORDER BY DESC(?count)
  LIMIT 40
} AS %citing_works
WITH { 
  SELECT (COUNT(*) AS ?count_) ?cited_work WHERE {
    target: (^wdt:P2860 | wdt:P2860) / (^wdt:P2860
Try it!
Retrieved from "https://www.wikidata.org/w/index.php?title=User:Erfurth/Science&oldid=1608943344"