DiACL | Project ‒ Download data

Javascript is disabled in your browser. Without javascript, several elements of this site cannot work properly. Please enable javascript to ensure that the site is fully functional.

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

The language tree structure may be downloaded as JSON .
The list of all languages may be downloaded as JSON .
Any individual language (for example English), including its lexemes and geographical presences, may be downloaded as JSON .
The languages descending from any node in the language tree (for example Latin), including their lexemes and geographical presenences, may be downloaded as JSON .
For any focus area (for example Austronesia), all typological datapoints may be downloaded as JSON .
For any lexeme (for example the Proto-Germanic word *bōk(j)ō- 'beech'), its etymological context may be downloaded as JSON . The same JSON representation is used to draw the etymological diagram on the lexeme's Details page.
The word list structure may be downloaded as JSON .
Any word list (for example Culture words for Indo-European), may be downloaded including all the lexemes that are connected to it as JSON .
Data for some Swadesh wordlists may be downloaded for a select numbers of language families (for example the Swadesh 100 list for Indo-European), as JSON .
For some selected word lists, their connected lexemes may be downloaded arranged according to cognacy, as both JSON and CSV files, bundled into one ZIP archive.
The entire lexical portion of the database may be downloaded as JSON .

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

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

Focus areas

"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

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

Geographical presences

"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

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

Etymological links

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

Etymological reliabilities

"EtymologicalReliabilities": {
  "etymological reliability id": {
    "Description": "description",
    "Note": "note"
  }
}

A source reference

{
  "FkSourceId": associated source id,
  "LocationWithinSource": "description of the location within the source (e.g. page number)",
  "Note": "note"
}

Sources

"Sources": {
  "source id": {
    "CitationKey": "citation key",
    "FullCitation": "full citation",
    "SourceType": "source type description"
  }
}

Word lists

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