Project: Analyze Crossref Member IDs / ROR IDs

ror-community / ror-updates

Central tracking for updates to ROR

51 stars 8 forks source link

Project: Analyze Crossref Member IDs / ROR IDs #892

Open amandafrench opened 2 years ago

amandafrench commented 2 years ago

Crossref is interested in replacing (edit: not replacing, but enhancing!) its ~15,000 Member IDs with ROR IDs. Crossref has said they can get us a spreadsheet with some member data that can be analyzed to see how many Crossref members already have ROR IDs, how many would need new ROR IDs, and how many would be out of scope for ROR (e.g., university departments).

amandafrench commented 2 years ago

Note too that Member IDs are in the Crossref API and can be queried. Documentation at https://api.crossref.org/swagger-ui/index.html#/Members/get_members

ynnig commented 2 years ago

Just a note that we wouldn't replace crossref member IDs but I want to add ROR IDs into our system so that we can report to any member or sponsor or subscriber what their ROR ID is. And I'm also curious what the overlap is. Will add Amanda Bartell to this thread! Thank-you Adam and Amanda F for kicking this off!

amandafrench commented 2 years ago

Ah, that makes sense! Sorry for the error.

adambuttrick commented 2 years ago

Attaching first pass at reconciliation via the API, as well as possible additional members that could be added to ROR via Wikidata reconciliation: 20220722_crossref_member_matches.xlsx 20220726_crossref_unmatched_members_reconciled_w_wikidata.xlsx .

amandafrench commented 1 year ago

Scripts now available at https://github.com/adambuttrick/reconcile_crossref_members