ROR

“ROR (Research Organization Registry) is a community-led registry of open, sustainable, usable, and unique identifiers for every research organization in the world.

ROR includes identifiers and metadata for more than 100,000 organizations. ROR identifiers are designed to link research organizations to research outputs in scholarly infrastructure. Search the ROR registry at https://ror.org/search.” – ROR website.

This telescope gets the latest ROR data from the available data dumps. See their docs for more information on the data dump.

Summary
Average runtime	<1h
Average download size	100MB-1GB
Harvest Type	API
Workflow Update Frequency	Monthly
Runs on remote worker	False
Catchup missed runs	True
Table Write Disposition	Truncate
Provider Update Frequency	Aprrox. Quarterly
Credentials Required	No
Uses Workflow Template	Snapshot
Each shard includes all data	Yes

Latest schema

name	type	mode	description
id	STRING	REQUIRED	Unique ROR ID for the organization
name	STRING	REQUIRED	The primary name of the organization
email_address	STRING	NULLABLE	A contact mail address for the organization. Deprecated field - Not actively curating
ip_addresses	STRING	REPEATED	IP address(es) associated with the organization. Deprecated field - Not actively curating
established	INTEGER	NULLABLE	Year the organization was established (CE)
types	STRING	REPEATED	Organization type. Allowed types: Education, Healthcare, Company, Archive, Nonprofit, Government, Facility, Other
relationships	RECORD	REPEATED	Related organizations in ROR. Allowed relationship types: Parent, Child, Related
relationships.id	STRING	NULLABLE
relationships.label	STRING	NULLABLE
relationships.type	STRING	NULLABLE
addresses	RECORD	REPEATED	The organization’s location
addresses.lat	FLOAT	NULLABLE
addresses.lng	FLOAT	NULLABLE
addresses.state	STRING	NULLABLE
addresses.state_code	STRING	NULLABLE
addresses.city	STRING	NULLABLE
addresses.geonames_city	RECORD	NULLABLE
addresses.geonames_city.id	INTEGER	NULLABLE
addresses.geonames_city.city	STRING	NULLABLE
addresses.geonames_city.geonames_admin1	RECORD	NULLABLE
addresses.geonames_city.geonames_admin1.name	STRING	NULLABLE
addresses.geonames_city.geonames_admin1.id	INTEGER	NULLABLE
addresses.geonames_city.geonames_admin1.ascii_name	STRING	NULLABLE
addresses.geonames_city.geonames_admin1.code	STRING	NULLABLE
addresses.geonames_city.geonames_admin2	RECORD	NULLABLE
addresses.geonames_city.geonames_admin2.name	STRING	NULLABLE
addresses.geonames_city.geonames_admin2.id	INTEGER	NULLABLE
addresses.geonames_city.geonames_admin2.ascii_name	STRING	NULLABLE
addresses.geonames_city.geonames_admin2.code	STRING	NULLABLE
addresses.geonames_city.license	RECORD	NULLABLE
addresses.geonames_city.license.attribution	STRING	NULLABLE
addresses.geonames_city.license.license	STRING	NULLABLE
addresses.geonames_city.nuts_level1	RECORD	NULLABLE
addresses.geonames_city.nuts_level1.name	STRING	NULLABLE
addresses.geonames_city.nuts_level1.code	STRING	NULLABLE
addresses.geonames_city.nuts_level2	RECORD	NULLABLE
addresses.geonames_city.nuts_level2.name	STRING	NULLABLE
addresses.geonames_city.nuts_level2.code	STRING	NULLABLE
addresses.geonames_city.nuts_level3	RECORD	NULLABLE
addresses.geonames_city.nuts_level3.name	STRING	NULLABLE
addresses.geonames_city.nuts_level3.code	STRING	NULLABLE
addresses.postcode	STRING	NULLABLE
addresses.primary	BOOLEAN	NULLABLE
addresses.line	STRING	NULLABLE
addresses.country_geonames_id	INTEGER	NULLABLE
links	STRING	REPEATED	Official website of the organization
aliases	STRING	REPEATED	Other names the organization is known by
acronyms	STRING	REPEATED	Acronyms or initialisms for the organization name
status	STRING	REQUIRED	Whether the organization is active or not
wikipedia_url	STRING	NULLABLE	Wikipedia link for the organization
labels	RECORD	REPEATED	Name(s) for the organization in other language(s)
labels.label	STRING	NULLABLE
labels.iso639	STRING	NULLABLE
country	RECORD	REQUIRED	Country where organization is located
country.country_name	STRING	NULLABLE
country.country_code	STRING	NULLABLE
external_ids	RECORD	NULLABLE	Other identifiers for the organization. Allowed external IDs: Crossref Funder ID (FundRef), GRID, ISNI, Wikidata. Other external IDs not actively curated include OrgRef, HESA, UCAS, UKPRN, CNRS.
external_ids.ISNI	RECORD	NULLABLE
external_ids.ISNI.preferred	STRING	NULLABLE
external_ids.ISNI.all	STRING	REPEATED
external_ids.OrgRef	RECORD	NULLABLE
external_ids.OrgRef.preferred	STRING	NULLABLE
external_ids.OrgRef.all	STRING	REPEATED
external_ids.Wikidata	RECORD	NULLABLE
external_ids.Wikidata.preferred	STRING	NULLABLE
external_ids.Wikidata.all	STRING	REPEATED
external_ids.GRID	RECORD	NULLABLE
external_ids.GRID.preferred	STRING	NULLABLE
external_ids.GRID.all	STRING	NULLABLE
external_ids.FundRef	RECORD	NULLABLE
external_ids.FundRef.preferred	STRING	NULLABLE
external_ids.FundRef.all	STRING	REPEATED
external_ids.CNRS	RECORD	NULLABLE
external_ids.CNRS.preferred	STRING	NULLABLE
external_ids.CNRS.all	STRING	REPEATED
external_ids.HESA	RECORD	NULLABLE
external_ids.HESA.preferred	STRING	NULLABLE
external_ids.HESA.all	STRING	REPEATED
external_ids.UCAS	RECORD	NULLABLE
external_ids.UCAS.preferred	STRING	NULLABLE
external_ids.UCAS.all	STRING	REPEATED
external_ids.UKPRN	RECORD	NULLABLE
external_ids.UKPRN.preferred	STRING	NULLABLE
external_ids.UKPRN.all	STRING	REPEATED
external_ids.LinkedIn	RECORD	NULLABLE
external_ids.LinkedIn.preferred	STRING	NULLABLE
external_ids.LinkedIn.all	STRING	REPEATED
external_ids.Ringgold	RECORD	NULLABLE
external_ids.Ringgold.preferred	STRING	NULLABLE
external_ids.Ringgold.all	STRING	REPEATED