Organizations (GRID)

This page contains information about the Organizations data source in the Dimensions BigQuery project.

Note: the organizations data type is present in the table named grid (within the normal data_analytics dataset where other data types are present).

See also

Dimensions DSL API Documentation for this type is also available from here.

Organizations Schema

Field	Type	Description
acronyms	Array of < Literal: String >	A list of short acronyms the institute is known as (e.g. MRC for the Medical Research Council)
address	Entity: Address	Address associated with the institute.
aliases	Array of < Literal: String >	A list of other names the institute is known as.
closed	Literal: Integer	If the organization has closed, the year when it was closed.
email_address	Literal: String	A contact email address for the institute.
established	Literal: Integer Partitioning field	Year when the organization was estabilished
external_ids	Entity: ExternalIdentifierSet	Other IDs known to refer to the institute.
id	Literal: String Clustering field	GRID ID of the organization. E.g., “grid.26999.3d”.
labels	Array of < Entity: Label >	The name of the institute in different languages.
links	Array of < Literal: String >	URLs linking to things such as the homepage of the institute.
name	Literal: String	GRID name of the organization. E.g., “University of Tokyo” for grid.26999.3d
organization_child_ids	Array of < Literal: String >	Child organization IDs.
organization_parent_ids	Array of < Literal: String >	Parent organization IDs.
organization_recursive_child_ids	Array of < Literal: String >	Child organization IDs, recursively resolved using the record as the root of the resolved hierarchy.
organization_related_ids	Array of < Literal: String >	Related organization IDs.
redirect	Literal: String	GRID identifier where a redirected organization now points to.
relationships	Array of < Entity: Relationship >	Any relationships the institute has to others.
status	Literal: String	For an active institute, this is always set to “active”.
types	Array of < Literal: String >	Type of an organization Eg. “Company”, “Education”, “Government” etc.
wikipedia_url	Literal: String	URL of the wikipedia page for the institute.

Organizations Links

The diagram below provides an overview of the outgoing links from Organizations to other sources.

Auxiliary Entities

Address

Field	Type	Description
city	Literal: String	The name of the city.
country	Literal: String	The name of the country.
country_code	Literal: String	The ISO 3166-1 alpha-2 code of the country.
country_geonames_id	Literal: Integer	The GeoNames ID of the country.
geonames_city	Entity: GeoNamesCity	The GeoNames data of the institutes associated city.
latitude	Literal: Float	Latitute of the institute.
line_1	Literal: String	First line of the address.
line_2	Literal: String	Second line of the address.
line_3	Literal: String	Third line of the address.
longitude	Literal: Float	Longitude of the institute.
postcode	Literal: String	The postcode/zipcode.
state	Literal: String	The name of the state/region.
state_code	Literal: String	The ISO 3166-2 region code.

ExternalIdentifier

Field	Type	Description
all	Array of < Literal: String >	A list of all IDs for the ‘External ID type’ format.
preferred	Literal: String	The preferred ID for this type, or null if none are preferred.

ExternalIdentifierSet

Field	Type	Description
cnrs	Entity: ExternalIdentifier	CNRS IDs for this organization.
fundref	Entity: ExternalIdentifier	Fundref IDs for this organization.
hesa	Entity: ExternalIdentifier	HESA IDs for this organization.
isni	Entity: ExternalIdentifier	ISNI IDs for this organization.
orgref	Entity: ExternalIdentifier	OrgRef IDs for this organization.
ror	Entity: ExternalIdentifier	ROR IDs for this organization.
ucas	Entity: ExternalIdentifier	UCAS IDs for this organization.
ukprn	Entity: ExternalIdentifier	UKPRN IDs for this organization.
wikidata	Entity: ExternalIdentifier	WikiData IDs for this organization.

GeoNamesAdmin

Field	Type	Description
ascii_name	Literal: String
code	Literal: String
name	Literal: String

GeoNamesCity

Field	Type	Description
city	Literal: String	The name of the city.
geonames_admin1	Entity: GeoNamesAdmin	The admin1 region in GeoNames.
geonames_admin2	Entity: GeoNamesAdmin	The geonames_admin2 region in GeoNames.
id	Literal: Integer	The GeoNames ID.
license	Entity: GeoNamesLicense
nuts_level1	Entity: GeoNamesLevel	The NUTS level 1 region the GeoNames city is in.
nuts_level2	Entity: GeoNamesLevel	The NUTS level 2 region the GeoNames city is in.
nuts_level3	Entity: GeoNamesLevel	The NUTS level 3 region the GeoNames city is in.

GeoNamesLevel

Field	Type	Description
code	Literal: String
name	Literal: String

GeoNamesLicense

Field	Type	Description
attribution	Literal: String
license	Literal: String

Label

Field	Type	Description
iso639	Literal: String	The ISO-639-1 language code.
label	Literal: String	The institute name in a language variant.

Relationship

Field	Type	Description
id	Literal: String	The GRID ID of the related institute.
label	Literal: String	The name of the related institute.
type	Literal: String	The type of relationship E.g. ‘Parent’, ‘Child’.