Project ‒ Download data

Throughout the site you will see these XML, JSON, and CSV icons indicating that database contents can be extracted and downloaded as an XML file or a JSON file, respectively.

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.

XML

XML icons appear:

CSV

CSV icons appear:

JSON

JSON icons appear:

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. Their structure is:

Attributes with null values or default values are omitted from the JSON. Examples of default values are false for boolean attributes, or "" for string attributes.

Dictionary indexed by the lexeme id.
Metadata
{
  "TimeStamp": "date and time of compilation as an ISO 8601 string",
  "Readme": "general information"
}
Focus areas
{
  "focus area id": {
    "Name": "name",
    "FocalPointWgs84": {
      "Latitude": WGS84 latitude as a decimal number,
      "Longitude": WGS84 longitude as a decimal number
    }
  }
}
Languages
{
  "language id": {
    "LangName": "language name",
    "Iso693_3": "3 letter iso code",
    "LanguageArea": "language area description",
    "FkFocusArea": focus area id,
    "Reliability": "language reliability description",
    "TimeFrame": {
      "From": year,
      "Until": year
    },
    "FocalPointWgs84": {
      "Latitude": WGS84 latitude as a decimal number,
      "Longitude": WGS84 longitude as a decimal number
    }
  }
}
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)"
  }
}
Etymological links
{
  "etymological link id": {
    "FkParentId": id of the parent lexeme,
    "FkChildId": id of the child lexeme,
    "FkReliabilityId": id of the etymological reliability,
    "NoteNoMarkup": "etymology note without markup tags",
    "NoteHtmlified": "etymology note with markup tags converted to HTML (truncated to 100 characters)"
  }
}
Etymological reliabilities
{
  "etymological reliability id": {
    "Description": "description",
    "Note": "note"
  }
}
Sources
{
  "source id": {
    "CitationKey": "citation key",
    "FullCitation": "full citation",
    "SourceType": "source type description"
  }
}