Database Schema

Publications

{
    "_id": <string>,
    "publisher": <Publisher>,
    "journal": <Journal>,
    "year": <int?>,
    "published_date": <string>,
    "oa_color": <int?>,
    "dim": <PublicationSourceData>
}

Publisher

{
    "_id": <string>,
    "name": <string>,
    "oa_color": <int?>
}

Journal

{
"_id": <string>,
    "title": <string>,
    "oa_color": <int?>,
    "issns": [ <string>, <...> ]
}

PublicationSourceData

{
    "source_id": <string>,
    "organisations": [ <Organisation>, <...> ],
    "url": <string>
}

Organisation

{
    "_id": <string>,
    "grid_id": <string>,
    "name": <string>,
    "aliases": [ <string>, <...> ],
    "acronyms": [ <string>, <...> ],
    "type": <string>,
    "address": <RorAddress>,
    "labels": <RorLabels>,
    "relationships": <RorRelationship>,
    "corresponding": <bool?>
}

 RorAddress

{
    "city": <string>,
    "state": <string>,
    "state_code": <string>,
    "country": <string>,
    "country_code": <string>,
    "lat": <double?>,
    "lng": <double?>,
    "primary": <bool>,
    "postcode": <string>,
}

RorLabel

{
    "label": <string>,
    "iso639": <string>
}

RorRelationship

{
    "type": <string>,
    "id": <string>
}