Bibliographical Items: Difference between revisions
From eneoli wikibase
Line 77: | Line 77: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} group by ?author ?authorLabel ?num_of_articles order by desc(?num_of_articles) | } group by ?author ?authorLabel ?num_of_articles order by desc(?num_of_articles) | ||
</sparql> | |||
== Authors with Wikidata ID == | |||
<sparql tryit="1"> | |||
#title: Authors with Wikidata ID | |||
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/> | |||
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/> | |||
select ?author ?authorLabel (iri(concat("http://www.wikidata.org/entity/",?wd)) as ?wikidata) | |||
where { | |||
?author endp:P5 enwb:Q5; endp:P1 ?wd. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} group by ?author ?authorLabel ?wd order by lcase(?authorLabel) | |||
</sparql> | </sparql> |
Revision as of 15:23, 14 May 2024
Source
Bibliographical items on this Wikibase stem from NeoCorpus Zotero group.
Database Queries
All bibliographical items
#title: All bibliographical items
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?item ?typeLabel ?date ?itemLabel
where {
?item endp:P5 enwb:Q2; endp:P6 ?type; endp:P30 ?date.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} order by ?date
Publication years and number of articles
#title: Publication years and # of articles
#defaultView:BarChart
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?year (count(distinct ?item) as ?num_of_articles)
where {
?item endp:P5 enwb:Q2; endp:P30 ?date.
bind(str(YEAR(?date)) as ?year)
# SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?year ?num_of_articles order by ?year
Languages and number of articles
#title: Languages and # of articles
#defaultView:BarChart
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?languageLabel (count(distinct ?item) as ?num_of_articles)
where {
?item endp:P5 enwb:Q2; endp:P7 ?language.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?languageLabel ?num_of_articles order by desc(?num_of_articles)
Bibliographical item types and number of articles
#title: Bibliographical item types
#defaultView:BubbleChart
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?typeLabel (count(distinct ?item) as ?number_of_articles)
where {
?item endp:P5 enwb:Q2; endp:P6 ?type.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?typeLabel ?number_of_articles order by desc(?number_of_articles)
Authors and number of articles
#title: Authors and number of articles
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?author ?authorLabel (count(?item) as ?num_of_articles)
where {
?item endp:P5 enwb:Q2.
?item endp:P40 ?author.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?author ?authorLabel ?num_of_articles order by desc(?num_of_articles)
Authors with Wikidata ID
#title: Authors with Wikidata ID
PREFIX enwb: <https://eneoli.wikibase.cloud/entity/>
PREFIX endp: <https://eneoli.wikibase.cloud/prop/direct/>
select ?author ?authorLabel (iri(concat("http://www.wikidata.org/entity/",?wd)) as ?wikidata)
where {
?author endp:P5 enwb:Q5; endp:P1 ?wd.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?author ?authorLabel ?wd order by lcase(?authorLabel)