How to Fetch All the books of just a Particular University

Hi team,

Is it possible to fetch all books/book chapters/book sets/ of a particular University? For examples, all the book records of authors that are affiliated with Harvard University, or the total number book records of authors that are affiliated with Harvard University. If it is possible, how to construct the queries?

Thanks in advance for your help and time!

3 Likes

Hi @JC2022 ,

Thanks for your message, and welcome to the Community Forum. Yes, that is possible. Our REST API is the best way to retrieve these records.

You can see all the book metadata records registered using Harvard University Press’s 10.4159 DOI prefix here:
http://0-api-crossref-org.pugwash.lib.warwick.ac.uk/prefixes/10.4159/works?filter=type:book&select=DOI,title,ISBN&rows=500&mailto=support@crossref.org

I have limited the metadata returned in the query to DOI, title, and ISBN, but if you want to see the complete metadata records for these books, you can simply remove the select parameter, like this:
http://0-api-crossref-org.pugwash.lib.warwick.ac.uk/prefixes/10.4159/works?filter=type:book&rows=500&mailto=support@crossref.org

Please let me know if you have any additional questions,
Isaac

Also, this intro to using our REST API might helpful: Ticket of the month - March 2022 - Getting started with REST API queries - #14 by ifarley

2 Likes

I failed to answer this question in my response, so here are details from our REST API on books registered with us that include authors affiliated with Harvard:
https://0-api-crossref-org.pugwash.lib.warwick.ac.uk/works?query.affiliation=Harvard&filter=type:book&select=DOI,title,ISBN,author&rows=500&mailto=support@crossref.org

I hope this is helpful,
Isaac

Thank you so much Isaac! This is really helpful.

  1. For this part “Harvard University Press’s 10.4159”, my understanding is that Harvard University Press is a publisher, is that right? For universities like the University of Rochester which doesn’t have a press, is it still possible to pull all the book metadata records?
  2. I apologize if this has already been answer. Where can I find DOI prefix for universities? Are these prefix published anywhere so people can look them up? Or do I have to talk to people in my university to figure that out? I tried looking up members of Crossref to figure if my university has a DOI prefix but didn’t see anything pop up.

Hi Isaac,

Just wanted to shared that I replaced the Harvard University Press’s DOI prefix with the University of Rochester’s. No records are returned using this URL: https://0-api-crossref-org.pugwash.lib.warwick.ac.uk/prefixes/10.47761/works?filter=type:book&rows=500&mailto=support@crossref.org. I looked up a few CrossRef documentations and got the impression that when depositing book metadata, affiliation information of authors are not asked to be provided.

Hi @JC2022. Yes, we would consider Harvard University Press a publisher, but differentiating between a publisher versus a scientific society versus a university isn’t meaningful from a broad metadata retrieval standpoint, like mine above using the REST API. If all of these organizations are members of Crossref, then the meaningful classification here would be: a Crossref member registering metadata records (with us).

I do see that the University of Rochester (River Campus Libraries) is a Crossref member registering metadata records: https://0-api-crossref-org.pugwash.lib.warwick.ac.uk/prefixes/10.47761/works?facet=type-name:*&mailto=support@crossref.org

They have not registered any books with us though:


University of Rochester (River Campus Libraries) has registered a journal, 34 journal issues, and 309 articles.

Where can I find DOI prefix for universities? Are these prefix published anywhere so people can look them up? Or do I have to talk to people in my university to figure that out?

All metadata records are available in our REST API, so you can certainly find works there. Full documentation on using our REST API is available here: api.crossref.org. Finding a list of every university registering metadata with us is a little more complicated. You may wish to try our titlelist here: crossref.org : : Title List or search in search.crossref.org, as those interfaces are designed more for the searches you’re aiming to conduct.

I looked up a few CrossRef documentations and got the impression that when depositing book metadata, affiliation information of authors are not asked to be provided.

There’s a difference here between not asking for author affiliations in our metadata and not requiring it. Author affiliation is not a required metadata element, but it is certainly best practice to include it. We encourage all members to provide rich metadata, including author affiliations.

My best,
Isaac