Bibliographical Items: Difference between revisions

From eneoli wikibase
No edit summary
Line 61: Line 61:
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} group by ?typeLabel ?number_of_articles order by desc(?number_of_articles)
} group by ?typeLabel ?number_of_articles order by desc(?number_of_articles)
</sparql>
== Authors and number of articles ==
<sparql tryit="1">
#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)
</sparql>
</sparql>

Revision as of 15:18, 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

Try it!

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

Try it!

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)

Try it!

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)

Try it!

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)

Try it!