User:Daniel/Queries: Difference between revisions

From MaRDI portal
 
(6 intermediate revisions by the same user not shown)
Line 10: Line 10:
=== Map of institutions involved in NFDI consortia ===
=== Map of institutions involved in NFDI consortia ===


* [https://query.wikidata.org/#%23defaultView%3AMap%0A%0APREFIX%20target%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2FQ99534506%3E%0A%0ASELECT%20%3Fpartner%20%3FpartnerLabel%20%3Flocation%20%3Fproject%20%3FprojectLabel%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fpartner%20%3Flocation%20%3Fproject%20WHERE%20%7B%0A%20%20%20%20%3Fproject%20wdt%3AP31%20wd%3AQ98270496%20.%0A%20%20%20%20%3Fproject%20%28%5Ewdt%3AP1344%20%7C%20wdt%3AP710%29%2a%20%2F%20%28wdt%3AP527%20%7C%20wdt%3AP710%20%7C%20wdt%3AP1416%29%20%3Fpartner%20.%0A%20%20%20%20%3Fpartner%20wdt%3AP159%2a%20%2F%20wdt%3AP625%20%3Flocation%20.%0A%20%20%7D%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D overall]
* [https://w.wiki/6Hd9 (Cord Wiljes)]
* [https://w.wiki/6Hd9 (Cord Wiljes)]
** [https://query.wikidata.org/#%23defaultView%3AGraph%0ASELECT%20DISTINCT%20%20%3Fwsingular%20%3FwsingularLabel%20%3Fp%20%3FpLabel%20%28%22EC0000%22%20AS%20%3Frgb%29%0AWHERE%20%0A%7B%0A%20%20wd%3AQ108327788%20wdt%3AP1416%20%3Fwsingular%20.%0A%20%20%3Fp%20wdt%3AP31%20wd%3AQ98270496%20.%0A%20%20%3Fp%20p%3AP1416%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP1416%20%3Fwsingular%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP3831%20%3FaffiliationType%20.%7D%20%20%0A%20%20OPTIONAL%20%7B%20%3Fwsingular%20wdt%3AP154%20%3Fwsingularpicture%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fp%20wdt%3AP154%20%3Fppicture%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cde%2Cen%22%20.%20%7D%0A%7D%20ORDER%20BY%20ASC%28%3FwsingularLabel%29%20ASC%28%3FpLabel%29 variant]
** [https://query.wikidata.org/#%23defaultView%3AGraph%0ASELECT%20DISTINCT%20%20%3Fwsingular%20%3FwsingularLabel%20%3Fp%20%3FpLabel%20%28%22EC0000%22%20AS%20%3Frgb%29%0AWHERE%20%0A%7B%0A%20%20wd%3AQ108327788%20wdt%3AP1416%20%3Fwsingular%20.%0A%20%20%3Fp%20wdt%3AP31%20wd%3AQ98270496%20.%0A%20%20%3Fp%20p%3AP1416%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP1416%20%3Fwsingular%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP3831%20%3FaffiliationType%20.%7D%20%20%0A%20%20OPTIONAL%20%7B%20%3Fwsingular%20wdt%3AP154%20%3Fwsingularpicture%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fp%20wdt%3AP154%20%3Fppicture%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cde%2Cen%22%20.%20%7D%0A%7D%20ORDER%20BY%20ASC%28%3FwsingularLabel%29%20ASC%28%3FpLabel%29 variant]
Line 46: Line 47:
* https://w.wiki/7Qmx
* https://w.wiki/7Qmx


=== Mathematicians who have had non-mathematical things named after them ===
=== Mathematicians and things named after them ===
 
==== Mathematicians and their theorems ====
* [https://w.wiki/BgKJ Chronology of deaths of mathematicians, with their theorems] ([https://x.com/Pyb75/status/1849805466643181634 source])
** [https://query.wikidata.org/index.html#%23Chronologie%20des%20d%C3%A9c%C3%A8s%20des%20math%C3%A9maticiens%2C%20avec%20leurs%20th%C3%A9or%C3%A8mes%0A%23defaultView%3ATimeline%0ASELECT%0A%20%20%3FgenderLabel%0A%20%20%3Ftheorem%0A%20%20%3FtheoremLabel%0A%20%20%3FnameLabel%0A%20%20%3Fdeath%0A%20%20%3Fformula%0AWHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cmul%2Cen%2Cde%2Cpl%22.%20%7D%0A%20%20%3Ftheorem%20wdt%3AP31%20wd%3AQ65943%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20wd%3AQ331089%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fname.%0A%20%20%3Fname%20%20%20%20wdt%3AP570%20%3Fdeath%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP21%20%3Fgender%20.%0A%20%20%23%20OPTIONAL%7B%0A%20%20%3Ftheorem%20wdt%3AP2534%20%3Fformula.%0A%20%20%23%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fdeath%29%0ALIMIT%20100 MathML error]
 
==== Mathematicians who have had non-mathematical things named after them ====


* [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D e.g. lunar craters OR asteroids OR species]
* [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D e.g. lunar craters OR asteroids OR species]
** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP11497%20%3Fid4%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D variant with OR mathematical functions]
** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP11497%20%3Fid4%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D variant with OR mathematical functions]
** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%3Ffunction%20wdt%3AP11497%20%3Fdlmf%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fcrater%20wdt%3AP2824%20%3Fobject_name1%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fasteroid%20wdt%3AP716%20%3Fobject_name2%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Ftaxon%20wdt%3AP225%20%3Ftaxonname%20%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20ASC%28%3Fdob%29 variant with AND for all of the above]
** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%3Ffunction%20wdt%3AP11497%20%3Fdlmf%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fcrater%20wdt%3AP2824%20%3Fobject_name1%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fasteroid%20wdt%3AP716%20%3Fobject_name2%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Ftaxon%20wdt%3AP225%20%3Ftaxonname%20%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20ASC%28%3Fdob%29 variant with AND for all of the above]
=== Most cited math papers in DBLP ===
* [https://sparql.dblp.org/?query=%23+Most+cited+publications+with+title+string+%22math%22%0APREFIX+dblp%3A+%3Chttps%3A%2F%2Fdblp.org%2Frdf%2Fschema%23%3E%0APREFIX+cito%3A+%3Chttp%3A%2F%2Fpurl.org%2Fspar%2Fcito%2F%3E%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0ASELECT+%3Fpubl+%3Flabel+%28COUNT%28%3Fcitation%29+as+%3Fcites%29+WHERE+%7B%0A++%3Fpubl+rdf%3Atype+dblp%3APublication+.%0A++%3Fpubl+dblp%3Atitle+%3Ftitle+.%0A++FILTER+CONTAINS%28%3Ftitle%2C+%22math%22%29+.%0A++%3Fpubl+dblp%3Aomid+%3Fomid+.%0A++%3Fpubl+rdfs%3Alabel+%3Flabel+.%0A++%3Fcitation+rdf%3Atype+cito%3ACitation+.%0A++%3Fcitation+cito%3AhasCitedEntity+%3Fomid+.%0A%7D%0AGROUP+BY+%3Fpubl+%3Flabel+%0AORDER+BY+DESC%28%3Fcites%29%0ALIMIT+100 query]


== Housekeeping queries ==
== Housekeeping queries ==
Line 81: Line 91:
**:This looks like a good dataset to work with, paving the way for disambiguating strings with initials later with more confidence.
**:This looks like a good dataset to work with, paving the way for disambiguating strings with initials later with more confidence.
** [https://query.wikidata.org/#SELECT%0A%20%20%23%20Number%20of%20works%20with%20the%20author%0A%20%20%3Fcount%0A%0A%20%20%23%20Author%20score%20-%203%20points%20for%20authoring%20a%20work%2C%201%20for%20being%20cited%0A%20%20%3Fscore%0A%0A%20%20%23%20Author%20as%20a%20string%0A%20%20%3Fauthor%0A%0A%20%20%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%20%20%28URI%28CONCAT%28%0A%20%20%20%20%20%20%27https%3A%2F%2Fauthor-disambiguator.toolforge.org%2Fnames_oauth.php%3Fdoit%3DLook%2Bfor%2Bauthor%26name%3D%27%2C%0A%20%20%20%20%20%20ENCODE_FOR_URI%28%3Fauthor%29%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%7D%0A%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%20%20%28COUNT%28%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%20%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25result%0A%0A%23%20Generate%20a%20score%20for%20each%20author%0AWITH%20%7B%0A%20%20SELECT%20%28SUM%28%3Fscore_%29%20AS%20%3Fscore%29%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%203%20points%20if%20they%20are%20an%20author%20of%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%283%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%201%20point%20if%20they%20are%20the%20author%20of%20a%20work%20that%20is%20cited%20by%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%281%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP2860%20%3Fwork%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25scores%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20INCLUDE%20%25scores%0A%0A%20%20%23%20Label%20the%20result%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fscore%29%0ALIMIT%20200%0A Common author name strings on documents that have a zbMATH document ID]
** [https://query.wikidata.org/#SELECT%0A%20%20%23%20Number%20of%20works%20with%20the%20author%0A%20%20%3Fcount%0A%0A%20%20%23%20Author%20score%20-%203%20points%20for%20authoring%20a%20work%2C%201%20for%20being%20cited%0A%20%20%3Fscore%0A%0A%20%20%23%20Author%20as%20a%20string%0A%20%20%3Fauthor%0A%0A%20%20%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%20%20%28URI%28CONCAT%28%0A%20%20%20%20%20%20%27https%3A%2F%2Fauthor-disambiguator.toolforge.org%2Fnames_oauth.php%3Fdoit%3DLook%2Bfor%2Bauthor%26name%3D%27%2C%0A%20%20%20%20%20%20ENCODE_FOR_URI%28%3Fauthor%29%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%7D%0A%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%20%20%28COUNT%28%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%20%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25result%0A%0A%23%20Generate%20a%20score%20for%20each%20author%0AWITH%20%7B%0A%20%20SELECT%20%28SUM%28%3Fscore_%29%20AS%20%3Fscore%29%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%203%20points%20if%20they%20are%20an%20author%20of%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%283%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%201%20point%20if%20they%20are%20the%20author%20of%20a%20work%20that%20is%20cited%20by%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%281%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP2860%20%3Fwork%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25scores%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20INCLUDE%20%25scores%0A%0A%20%20%23%20Label%20the%20result%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fscore%29%0ALIMIT%20200%0A Common author name strings on documents that have a zbMATH document ID]
* Find zbMATH author IDs to be added to Wikidata author items: [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20two%20co-authors%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%3Fauthor3%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor3Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements3%20%20%20%20%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fauthor3%20%3Fzbm_doc%20%3Fitem%20WHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2030000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%2C%20%3Fauthor3%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20%3Fauthor2%20wdt%3AP1556%20%3Fzbm_au2%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20%28%3Fauthor2%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor3%20wdt%3AP1556%20%3Fzbm_au%20%7D%0A%20%20%20%20%7D%0A%7D%20AS%20%25prep%0AWHERE%20%7B%0A%20%20INCLUDE%20%25prep%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor3%20wikibase%3Astatements%20%3Fstatements3%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements3%29%0A%23%20LIMIT%201000 Wikidata items of authors for which Wikidata does not know the zbMATH author ID but the zbMATH author ID of at least two co-authors on a paper with zbMATH document ID, from which the missing zbMATH author ID may be inferred.]
* Find zbMATH author IDs to be added to Wikidata author items: [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20two%20co-authors%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor3%0A%3Fauthor3Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements3%20%20%20%20%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fauthor3%20%3Fzbm_doc%20%3Fitem%20WHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2030000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%2C%20%3Fauthor3%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20%3Fauthor2%20wdt%3AP1556%20%3Fzbm_au2%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20%28%3Fauthor2%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor3%20wdt%3AP1556%20%3Fzbm_au%20%7D%0A%20%20%20%20%7D%0A%7D%20AS%20%25prep%0AWHERE%20%7B%0A%20%20INCLUDE%20%25prep%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor3%20wikibase%3Astatements%20%3Fstatements3%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements3%29%0A%23%20LIMIT%201000 Wikidata items of authors for which Wikidata does not know the zbMATH author ID but the zbMATH author ID of at least two co-authors on a paper with zbMATH document ID, from which the missing zbMATH author ID may be inferred.]
** [https://w.wiki/8Ygk variant without zbMATH document ID]
** [https://w.wiki/8Ygk variant without zbMATH document ID]
** [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20one%20co-author%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%3Fauthor2%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor2Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements2%20%20%20%20%0AWHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor2%20wdt%3AP1556%20%5B%5D%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor2%20wikibase%3Astatements%20%3Fstatements2%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements2%29%0A%23%20LIMIT%20101112345 variant for one co-author]
** [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20one%20co-author%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%3Fauthor2%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor2Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements2%20%20%20%20%0AWHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor2%20wdt%3AP1556%20%5B%5D%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor2%20wikibase%3Astatements%20%3Fstatements2%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements2%29%0A%23%20LIMIT%20101112345 variant for one co-author]
Line 96: Line 106:


* swMATH: [https://query.portal.mardi4nfdi.de/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fstatement%2F%3E%0A%0ASELECT%20DISTINCT%0A%3FitemLabel%20%3Fswmath%0A%7B%0A%20%20%3Fitem%20p%3AP13%20%3Fstatement%20.%0A%20%20%3Fstatement%20wikibase%3Arank%20%3Frank%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20ps%3AP13%20%3Fdbvalue%20%7D%0A%0A%20%20BIND%28COALESCE%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22unknown%22%2C%20%22concrete%22%29%2C%20%22novalue%22%29%20AS%20%3Fsnacktype%29%0A%20%20BIND%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22%22%2C%20%3Fdbvalue%29%20AS%20%3Fswmath%29%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20%7D%0A%20%20%0A%7D package name and swMATH ID]
* swMATH: [https://query.portal.mardi4nfdi.de/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fstatement%2F%3E%0A%0ASELECT%20DISTINCT%0A%3FitemLabel%20%3Fswmath%0A%7B%0A%20%20%3Fitem%20p%3AP13%20%3Fstatement%20.%0A%20%20%3Fstatement%20wikibase%3Arank%20%3Frank%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20ps%3AP13%20%3Fdbvalue%20%7D%0A%0A%20%20BIND%28COALESCE%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22unknown%22%2C%20%22concrete%22%29%2C%20%22novalue%22%29%20AS%20%3Fsnacktype%29%0A%20%20BIND%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22%22%2C%20%3Fdbvalue%29%20AS%20%3Fswmath%29%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20%7D%0A%20%20%0A%7D package name and swMATH ID]
* [https://query.portal.mardi4nfdi.de/#SELECT%20DISTINCT%20%3Fmardi_item%20%3Fdoi%20WHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP27%20%3Fdoi%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fmardi_item%20wdt%3AP16%20%3Fauthor%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fmardi_item%20wdt%3AP12%20%3Fwikidata%20%7D%0A%7D MaRDI items with DOI but no Wikidata QID]


== Tools ==
== Tools ==

Latest revision as of 06:54, 13 November 2024

About

This page assists with the creation, curation and maintenance of queries related to mathematical content here on the MaRDI portal or in other knowledge bases, especially in Wikidata.


Demo queries

These are queries that highlight some particular aspect of the data or the associated technical contexts.

Map of institutions involved in NFDI consortia

Formulas involving mass

Meaning of a given symbol in various formulas

Meaning of the symbol 'η' in various formulas

Meaning of the symbol 'μ' in various formulas

Most frequent topics of publications with a zbMATH document ID

Most frequent topics of publications by an author with a zbMATH author ID

Items matching a certain identifier

DLMF ID

Formulas containing certain LaTeX strings

Mathematicians and things named after them

Mathematicians and their theorems

Mathematicians who have had non-mathematical things named after them

Most cited math papers in DBLP

Housekeeping queries

List of MaRDI Wikibase properties


Author identifiers

Editing queries

These queries generate commands that can be used to make additional edits in the same Wikibase or another.

Maintenance queries

These queries help maintain or improve data quality, e.g. by checking for consistency or gaps.

zbMATH-related queries

On Wikidata

See also recent changes to items linked from zbMATH work ID (P894), items linking to zbMATH work ID (P894), items linked from zbMATH author ID (P1556) and items linking to author ID (P1556) as well as frequent curators of zbMATH work ID (P894) statements and frequent curators of zbMATH author ID (P1556) statements.

On Wikipedia

On MaRDI

Tools

Q & A

Annotation

See also

  • A generic Query GUI
  • To experiment with the MaRDI Query Service time-out limit, see this query and try it with other limits