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). This table is also made openly available to anyone with Google BigQuery, details can be found here: GRID: Global Database of Research Institutes

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.

email_address

Literal: String

A contact email address for the institute.

established

Literal: Integer

Year when the organization was estabilished

external_ids

Entity: ExternalIdentifierSet

Other IDs known to refer to the institute.

id

Literal: String

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.

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.

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.

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’.