Deprecated: GRID (Organizations)¶

Warning

The GRID table has been deprecated. It will continue to receive updates until October 2025. We intend to remove the table dimensions-ai.data_analytics.grid by the end of December 2025. Please use the replacement table dimensions-ai.data_analytics.organizations which has a closely compatible schema. Details regarding the new table can be found here: Organizations

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

GRID 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 established
`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.

GRID Links¶

The diagram below provides an overview of the outgoing links from GRID 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	Latitude 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’.