Project ‒ Download data

Throughout the site there are icons to indicate that extracts of data from the database may be downloaded in its corresponding format:

the JSON format ,
the CSV format .
The internal structure of all of these files is specific to the particular data contained within them and this structure may be subject to change.

Data available for download

Furthermore, some maps will have a save button on them, which allows the user to download the GeoJSON data with which the map was drawn.


JSON structure

Certain entities are represented in the JSON files consistently (this does not include the GeoJSON files). Their structure can be found below.

In order to minimize the resulting JSON file size, attributes with null values or default values are omitted. Examples of default values are false (for boolean attributes), 0 (for integer attributes), "" (for string attributes), or [] (an empty list).

"MetaData": {
  "TimeStamp": "date and time of compilation as an ISO 8601 string",
  "JsonUrl": "the URL from which the JSON file was downloaded",
  "Readme": "general information"
}
"FocusAreas": {
  "focus area id": {
    "Name": "name",
    "FocalPointWgs84": {
      "Latitude": latitude as a decimal number in the WGS 84 coordinate system,
      "Longitude": longitude as a decimal number in the WGS 84 coordinate system
    }
  }
}
"Languages": {
  "language id": {
    "LangName": "language name",
    "Iso693_3": "3 letter iso code",
    "AlternativeNames": "alternative language names",
    "LanguageArea": "language area description",
    "FkFocusArea": focus area id,
    "Reliability": "language reliability description",
    "TimeFrame": {
      "From": year,
      "Until": year
    },
    "FocalPointWgs84": {
      "Latitude": latitude as a decimal number in the WGS 84 coordinate system,
      "Longitude": longitude as a decimal number in the WGS 84 coordinate system
    }
  }
}
"GeographicalPresences": {
  "geographical presence id": {
    "FkLanguageId": associated language id
    "TimeFrame": {
      "From": year,
      "Until": year
    },
    "WktWgs84Url": "url for downloading a WKT representation, in the WGS 84 coordinate system",
    "SourceReferences": [source references (see below)]
  }
}
"Lexemes": {
  "lexeme id": {
    "FkLanguageId": associated language id,
    "FormTranscriptionNoMarkup": "transcription form without markup tags",
    "FormTranscriptionHtmlified": "transcription form with markup tags converted to HTML",
    "FormTransliteration" : "transliteration form",
    "FormIpa": "IPA form",
    "Meaning": "meaning",
    "MeaningNote": "meaning note".
    "GrammaticalData": "grammatical data",
    "LexemeNoteNoMarkup": "lexeme note without markup tags",
    "LexemeNoteHtmlified": "lexeme note with markup tags converted to HTML (truncated to 500 characters)",
    "SourceReferences": [source references (see below)]
  }
}
"Etymologies": {
  "etymological link id": {
    "FkParentId": id of the parent lexeme,
    "FkChildId": id of the child lexeme,
    "FkReliabilityId": id of the etymological reliability (always included, even if 0),
    "NoteNoMarkup": "etymology note without markup tags",
    "NoteHtmlified": "etymology note with markup tags converted to HTML (truncated to 100 characters)",
    "SourceReferences": [source references (see below)]
  }
}
"EtymologicalReliabilities": {
  "etymological reliability id": {
    "Description": "description",
    "Note": "note"
  }
}
{
  "FkSourceId": associated source id,
  "LocationWithinSource": "description of the location within the source (e.g. page number)",
  "Note": "note"
}
"Sources": {
  "source id": {
    "CitationKey": "citation key",
    "FullCitation": "full citation",
    "SourceType": "source type description"
  }
}
"WordLists": {
  "word list id": {
    "Name": "word list name",
    "Description": "word list description",
    "CognateSetsDownloadable": boolean value indicating if cognate sets may be downloaded for this word list,
    "FkFocusArea": id of the associated focus area,
    "WordListCategories": {
      "word list category id": {
        "Name": "word list category name",
        "WordListItems": {
          "word list item id": {
            "Name": "word list item name",
            "Note": "word list item note",
            "ConnectedLexemes": [list of lexeme ids]
          }
        }
      }
    }
  }
}