Open data

The records this site is built from, as plain files you can open in a spreadsheet or load in code. They are rebuilt with the site, so they always match the pages. Last built 18 November 2026.

Letter texts are not in the files: they stay on each letter page. The letters file has the date, the writer and recipient, the place, the languages and translator of the texts, the printed editions, where the autograph is kept, and the works, people and places each letter mentions.

Works

Every work in the catalogue, with its catalogue numbers, genre, key and years of composition. 258 records.

works.json168 kBworks.csv103 kB

Fields in works.json, works.csv
FieldMeaning
idStable identifier. Other files refer to this record by it.
thNumber in The Tchaikovsky Handbook (TH).
cwNumber in the Thematic and Bibliographical Catalogue of Tchaikovsky's works (ČW).
opusOpus number, if the work has one.
title_en, title_ruTitle.
genreGenre: symphony, concerto, orchestral, suite, opera, ballet, incidental, song, choral, cantata, piano, chamber, album-leaf, student, unfinished or arrangement.
key_en, key_ruKey, for works in one.
description_en, description_ruShort description from the catalogue, such as the scoring or the source of the text.
original_composerFor arrangements, the composer of the original.
yearsYears of composition as the catalogue writes them, e.g. "1866–68, 1874".
composed_fromFirst year of composition.
composed_toLast year of composition, when the catalogue gives it as a full year. Read years for the complete range.
composed_atPlaces where he worked on it (place ids).
urlPage on this site, in English. Replace /en/ with /ru/ for the Russian page.
sourceThe page this record was imported from.
attributionWho to credit for this record.

Letters

Metadata for every letter on the site: when and where it was written, by whom, to whom, and what it mentions. 5,387 records.

letters.json3.8 MBletters.csv2.6 MB

Fields in letters.json, letters.csv
FieldMeaning
trLetter number in the Tchaikovsky Research letter catalogue (TR).
tr_labelFull TR number for letters added later, e.g. "95a".
dateDate in the New Style (Gregorian) calendar: YYYY-MM-DD, or YYYY-MM or YYYY when the day or month is unknown.
dated_osTrue when the source dates it in the Old Style (Julian) calendar, 12 days behind in the 19th century.
fromWriter (person id).
toRecipient (person id).
placeWhere it was written or took place (place id).
original_langLanguage he wrote it in: ru, fr or de.
languageLanguages the letter can be read in on this site: the original first, then translations.
translatorWho translated the English text: a Tchaikovsky Research translator, or Dear Tchaikovsky for translations made for this site in 2026. Russian translations of French and German letters were also made for this site.
published_inPrinted editions of the letter, with volume and pages, as Tchaikovsky Research lists them (ПСС is the Complete Edition of his works and letters).
autographWhere the original manuscript is kept, with its archive reference.
worksWorks it mentions (work ids).
people_mentionedPeople it mentions (person ids).
places_mentionedPlaces it mentions (place ids).
urlPage on this site, in English. Replace /en/ with /ru/ for the Russian page.

People

People in Tchaikovsky's life and letters, his correspondents among them. 626 records.

people.json325 kB

Fields in people.json
FieldMeaning
idStable identifier. Other files refer to this record by it.
name_en, name_ruName.
name_variantsOther spellings and transliterations.
bornDate of birth, New Style.
diedDate of death, New Style.
relationship_en, relationship_ruRelation to Tchaikovsky.
wikidata_idWikidata item, e.g. Q7315.
urlPage on this site, in English. Replace /en/ with /ru/ for the Russian page.
sourceThe page this record was imported from.
attributionWho to credit for this record.

Places

Places in his life and letters, with latitude and longitude. 152 records.

places.json42 kBplaces.csv30 kB

Fields in places.json, places.csv
FieldMeaning
idStable identifier. Other files refer to this record by it.
name_en, name_ruName.
latLatitude, decimal degrees.
lonLongitude, decimal degrees.
urlPage on this site, in English. Replace /en/ with /ru/ for the Russian page.
sourceThe page this record was imported from.
attributionWho to credit for this record.

Stays

Where he was and when, worked out from his letters: consecutive dated letters written from one place make one stay. A stay runs from the first of those letters to the last, so he may have arrived earlier and left later. 597 records.

stays.json94 kBstays.csv39 kB

Fields in stays.json, stays.csv
FieldMeaning
placeWhere it was written or took place (place id).
from_nsFirst letter of the stay, New Style date.
from_osThe same date in the Old Style, given when that letter was dated in the Old Style (in Russia).
to_nsLast letter of the stay, New Style date.
to_osThe same date in the Old Style, when that letter was dated in the Old Style.
lettersNumber of letters written there during the stay.
first_trTR number of the first letter of the stay.
last_trTR number of the last letter of the stay.

Chronology

Dated entries from the chronology of his life. 321 records.

events.json172 kB

Fields in events.json
FieldMeaning
idStable identifier. Other files refer to this record by it.
dateDate in the New Style (Gregorian) calendar: YYYY-MM-DD, or YYYY-MM or YYYY when the day or month is unknown.
dated_osTrue when the source dates it in the Old Style (Julian) calendar, 12 days behind in the 19th century.
typeKind of entry: life, premiere, concert or journey.
title_en, title_ruTitle.
placeWhere it was written or took place (place id).
peoplePeople involved (person ids).
worksWorks it mentions (work ids).
urlPage on this site, in English. Replace /en/ with /ru/ for the Russian page.
sourceThe page this record was imported from.
attributionWho to credit for this record.

Reading the files

Text fields come in pairs, such as title_en and title_ru. Most Russian fields are still empty while translation goes on; empty means not yet written, not unknown.

Fields ending in an id, or holding a list of ids, join to the id field of another file: from, to and people_mentioned to people.json, place and composed_at to places.json, works to works.json.

JSON files hold one array, one record per line; missing values are null. CSV files are UTF-8 with a byte-order mark so spreadsheets read the Cyrillic correctly; lists are joined with a vertical bar (|) and missing values are left empty.

Licence

The data is shared under CC BY-NC-SA 4.0. Most of it was imported from Tchaikovsky Research, which publishes under the same licence. You can copy, adapt and share it for non-commercial use, as long as you credit Dear Tchaikovsky and Tchaikovsky Research and share what you make under the same terms.

A credit line you can copy:

Data from Dear Tchaikovsky (deartchaikovsky.com) and Tchaikovsky Research (en.tchaikovsky-research.net), CC BY-NC-SA 4.0.

How to cite the dataset

Give the date of the copy you used: the files are rebuilt with the site, so the date tells others which version you mean. For a single letter, work or person, use the “Cite this page” box on its page instead.

Dear Tchaikovsky. “Open data: works, letters, people, places, stays and chronology.” Version of 18 November 2026. https://deartchaikovsky.com/en/data/. Based on Tchaikovsky Research (en.tchaikovsky-research.net). CC BY-NC-SA 4.0.