Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] Publish ROR data dump as CSV (in addition to JSON) #140

Closed
lizkrznarich opened this issue Jan 30, 2023 · 1 comment
Closed

[FEATURE] Publish ROR data dump as CSV (in addition to JSON) #140

lizkrznarich opened this issue Jan 30, 2023 · 1 comment
Labels
feature Totally new functionality that does not exist in ROR currently

Comments

@lizkrznarich
Copy link
Contributor

Describe the problem you would like to solve
GRID previously made its data dump available in CSV, as well as JSON and RDF. For those who previously used the GRID CSV, those looking to import ROR data into a SQL database, and those who would like to interact with ROR data without having to parse JSON, it would be useful also publish ROR data dumps in CSV.

Note: This issue covers the CSV portion of the work described on ror-community/ror-api#113 . The RDF portion on issue 113 will be addressed separately.

Describe the solution you'd like
Initially, we will produce a single CSV with a subset of fields (those that are not deprecated or empty in all records). The structure of this CSV is different from GRID CSV files; ROR does not use a database for curation, so we will not include a full_tables directory.

id
name
status
types
established
country.country_name
country.country_code
addresses.geonames_city.id
addresses.geonames_city.name
addresses.geonames_city.geonames_admin1.code
addresses.geonames_city.geonames_admin1.name
aliases (delimited list in one field)
acronyms (delimited list in one field)
labels (delimited list in one field)
links
wikipedia_url
external_ids (GRID, ISNI, Funder Registry and Wikidata only, as columns with [id name].preferred and [id_name].all as headings)
relationships (delimited list in one field)

Who would benefit from this feature?
Developers, Librarians, Researchers; others who wish to use ROR data without parsing JSON

Additional information
Add any other information or screenshots about the feature request here.

@lizkrznarich lizkrznarich added the feature Totally new functionality that does not exist in ROR currently label Jan 30, 2023
@lizkrznarich
Copy link
Contributor Author

@mariagould mariagould moved this to Released 2023-03-16 in ROR Completed Work Aug 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature Totally new functionality that does not exist in ROR currently
Projects
Status: Released 2023-03-16
Development

No branches or pull requests

1 participant