How to extract and download data from the Local Systems database.
Data may be downloaded as XML in the same format used to harvest the local systems
Section MXD below
Data may be downloaded as JSON in the same format we use to build the portal
Section JSON Data below
MXD
DDF-MXD is the Danish Research Database Metadata Exchange Format for Documents.
It is the only format supported for adding data to NORA Local Systems portal.
The JSON data is an internal representation of the MXD data.
It is subset of the MXD data fields, only those which are useful and supported by the portal.
It does however contain enhancements, primarily the normalisation of some of the data like Danish organisation names, locations, OAI Scope, etc.
View JSON fields description
[
{
"abstract" : "", // - Abstract text, in English if available
"author_count" : "", // - Authors count, based on authors in that record
"bfi_cno" : "", // - BFI conference number, old records only
"bfi_pno" : "", // - BFI publisher number, old records only
"bfi_sno" : "", // - BFI serial number, old records only
"bfi_subject" : "", // - BFI expert group, old records only
"dimID" : [""], // - List of Dimensions IDs for this record
"event" : {
"acronym" : "", // - Event acronym
"end" : "", // - Event end date
"place" : "", // - Event location
"start" : "", // - Event start date
"title" : "", // - Event full name
"year" : "" // - Event year
},
"filters" : { // - Filters are generally for internal indexing use but some of the detailed
// information can be generally usefull
"altsrc" : [""], // - List of gobal sources in which this record can be found
"continent" : [""], // - List of geographic regions of organisations collaborating to this publication
"corpau" : [""], // - List of corporate authors
"country" : [""], // - List of countries of organisations collaborating to this publication
"glorg" : [""], // - List of global organisations collaborating to this publication. Also includes
// "All Global Affiliations" for search purpose.
"level" : "", // - MXD doc_level
"mra" : "", // - MXD research area (code)
"oa" : "", // - The type of Open Access to this record
"oaiscope" : "", // - Boolean Yes or No, defines if this record is part of OA-Indicator.
"org" : {
"level1" : [""], // - Level 1 Danish orgs for filtering only, always di
"level2" : [""], // - Level 2 Danish orgs for filtering only, so far DI-HO (Hospitals),
// DI-OT (Other Research), DI-PR (Private Research), DI-SE (Specialized Research),
// DI-U (Universities), DI=UC (University Colleges).
"level3" : {
"HO" : [""], // - Lists of org codes, split by org types level2.
"OT" : [""],
"PR" : [""],
"SE" : [""],
"U" : [""],
"UC" : [""]
}
},
"review" : "", // - Review codes, direct from MXD
"src" : "", // - Data source, direct from MXD
"type" : "", // - Record type, direct from MXD
"type-grp" : [""] // - Type group, based on type. So that the only active group is pub. You may also
// find dat (data), pat (patent) and all.
},
"id" : "", // - Original UUID
"identifier" : [
{
"id" : "", // - Some form of ID
"type" : "" // - Types, so far: scopus, pmid, wos
}
],
"inetpub" : [
{
"access" : "", // - Direct from MXD
"text" : "",
"uri" : ""
}
],
"keyword" : [""], // - Direct from MXD
"lang" : "", // - English text version of Language
"level" : "", // - English text version of MXD level
"mra" : "", // - English text versionof MXD MRA
"oa_link" : [
{
"access" : "", // - Direct from MXD
"embargo" : "",
"license" : "",
"type" : "",
"url" : "",
"version" : ""
}
],
"oai" : { // - Added OA-Indicator
"class" : "", // - OA-Indicator class (Blocked, Realised, Unused)
"mra" : "", // - Main Research Area
"yearPub" : "", // - Publication year
"yearSub" : "" // - Submission year
},
"org" : [
{
"affno" : "", // - Affiliation number for link with person below
"country" : "", // - Country code, 2 letters
"l2" : "", // - NORA level 2 code (org type)
"l2n" : "", // - Corresponding text in English
"l3" : "", // - NORA level 3 code (org code)
"l3nl" : "", // - Long English text version of l3
"l3nn" : "", // - More compact version of the text
"loc" : [""], // - Local country / regions
"name" : "", // - Full org name
"nora_code" : "", // - Same as l3
"role" : "" // - Can be used for "Corporate author"
}
],
"person" : [
{
"affno" : "", // - Affiliation number for link with org above
"country" : "", // - Country code, 2 letters
"locid" : "", // - Local ID from data provider (src)
"name" : "", // - Full name
"first" : "", // - First name
"last" : "" // - Last name
"orcid" : "", // - ORCID
"role" : "" // - So far: Editor, Editor of Host Publication, Illustrator, Inventor, Other,
// Publisher, Supervisor, Translator
}
],
"pub" : {
"doi" : "", // - DOI mostly document level but also sometimes higher publication level, like
// book for a book chapter.
"edition" : "", // - Direct from MXD
"eisbn" : [""], // - Electronic ISBN
"eissn" : [""], // - Electronic ISSN
"isbn" : [""], // - ISBN
"issn" : [""], // - ISSN
"issue" : "", // - Issue number, direct from MXD
"journal" : "", // - Journal title
"newspaper" : "", // - Newspaper title
"other" : "", // - Other publication (Direct from MXD)
"pages" : "", // - Number of pages or page range
"place" : "", // - Publication place
"publisher" : "", // - Publisher name
"repno" : "", // - Report number
"series" : "", // - Series title
"status" : "", // - Publication status code (direct from MXD)
"subtitle" : "", // - Sub-title
"title" : "", // - Publication title
"volume" : "" // - Volume
},
"review" : "", // - Review text
"scoID" : [""], // - ID of corresponding Scopus record
"sdg" : [""], // - List of SDG classifications
"search" : {
"DAF" : [""], // - Danish university code and text, for search purpose
"PST" : "" // - Publication status text, for search purpose
},
"sid" : "", // - A combination of src and id, used internally only so far
"src" : "", // - Data provider as abbreviated English text
"title" : "", // - Record title
"type" : "", // - Record type as Enlish text
"wosID" : [""], // - ID of corresponding Clarivate record
"year" : "", // - Publication year
"yearsub" : "" // - Submission year
}
]
JSON Array
If you have enough memory to parse the whole JSON at once, you can use the following extracts which are formatted as JSON arrays of records.
JSON Record List
For easier parsing with more limited memory, you can use the following extracts which are formatted as lists of JSON records, one per line.
