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:

• On the Language Index page, where a list of all languages (with geographical metadata) may be downloaded, as well as any individual language (without geographical metadata, but with their lexemes).
• On the Language Tree page, where a list of all descending languages (including lexemes) of a node may be downloaded.
• On the Typological Grid Index page for a specific focus area, where a record of all recorded typological features for that focus area may be downloaded.
• On the Word List Index page, where an individual word list with all its items and connected lexemes may be downloaded.
• On this page, where you can download an extract of the lexical part of the database (note that this file is quite big and may take some time to be compiled): . This extract includes all lexemes and their etymological relationships (with their sources), the word lists they appear in and the languages they belong to. The etymological connections form a directed graph of lexemes that may contain cycles.

CSV

CSV icons appear:

• Wordlists

JSON

JSON icons appear:

• On the Language Tree page, where the tree structure may be downloaded.
• On the details page of a individual lexeme or etymological link, where the etymological connections of a lexeme may be downloaded.

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"
  }
}

---