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
| Field | Meaning |
|---|---|
id | Stable identifier. Other files refer to this record by it. |
th | Number in The Tchaikovsky Handbook (TH). |
cw | Number in the Thematic and Bibliographical Catalogue of Tchaikovsky's works (ČW). |
opus | Opus number, if the work has one. |
title_en, title_ru | Title. |
genre | Genre: symphony, concerto, orchestral, suite, opera, ballet, incidental, song, choral, cantata, piano, chamber, album-leaf, student, unfinished or arrangement. |
key_en, key_ru | Key, for works in one. |
description_en, description_ru | Short description from the catalogue, such as the scoring or the source of the text. |
original_composer | For arrangements, the composer of the original. |
years | Years of composition as the catalogue writes them, e.g. "1866–68, 1874". |
composed_from | First year of composition. |
composed_to | Last year of composition, when the catalogue gives it as a full year. Read years for the complete range. |
composed_at | Places where he worked on it (place ids). |
url | Page on this site, in English. Replace /en/ with /ru/ for the Russian page. |
source | The page this record was imported from. |
attribution | Who 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
| Field | Meaning |
|---|---|
tr | Letter number in the Tchaikovsky Research letter catalogue (TR). |
tr_label | Full TR number for letters added later, e.g. "95a". |
date | Date in the New Style (Gregorian) calendar: YYYY-MM-DD, or YYYY-MM or YYYY when the day or month is unknown. |
dated_os | True when the source dates it in the Old Style (Julian) calendar, 12 days behind in the 19th century. |
from | Writer (person id). |
to | Recipient (person id). |
place | Where it was written or took place (place id). |
original_lang | Language he wrote it in: ru, fr or de. |
language | Languages the letter can be read in on this site: the original first, then translations. |
translator | Who 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_in | Printed editions of the letter, with volume and pages, as Tchaikovsky Research lists them (ПСС is the Complete Edition of his works and letters). |
autograph | Where the original manuscript is kept, with its archive reference. |
works | Works it mentions (work ids). |
people_mentioned | People it mentions (person ids). |
places_mentioned | Places it mentions (place ids). |
url | Page 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.
| Field | Meaning |
|---|---|
id | Stable identifier. Other files refer to this record by it. |
name_en, name_ru | Name. |
name_variants | Other spellings and transliterations. |
born | Date of birth, New Style. |
died | Date of death, New Style. |
relationship_en, relationship_ru | Relation to Tchaikovsky. |
wikidata_id | Wikidata item, e.g. Q7315. |
url | Page on this site, in English. Replace /en/ with /ru/ for the Russian page. |
source | The page this record was imported from. |
attribution | Who to credit for this record. |
Places
Places in his life and letters, with latitude and longitude. 152 records.
places.json42 kBplaces.csv30 kB
| Field | Meaning |
|---|---|
id | Stable identifier. Other files refer to this record by it. |
name_en, name_ru | Name. |
lat | Latitude, decimal degrees. |
lon | Longitude, decimal degrees. |
url | Page on this site, in English. Replace /en/ with /ru/ for the Russian page. |
source | The page this record was imported from. |
attribution | Who 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.
| Field | Meaning |
|---|---|
place | Where it was written or took place (place id). |
from_ns | First letter of the stay, New Style date. |
from_os | The same date in the Old Style, given when that letter was dated in the Old Style (in Russia). |
to_ns | Last letter of the stay, New Style date. |
to_os | The same date in the Old Style, when that letter was dated in the Old Style. |
letters | Number of letters written there during the stay. |
first_tr | TR number of the first letter of the stay. |
last_tr | TR number of the last letter of the stay. |
Chronology
Dated entries from the chronology of his life. 321 records.
| Field | Meaning |
|---|---|
id | Stable identifier. Other files refer to this record by it. |
date | Date in the New Style (Gregorian) calendar: YYYY-MM-DD, or YYYY-MM or YYYY when the day or month is unknown. |
dated_os | True when the source dates it in the Old Style (Julian) calendar, 12 days behind in the 19th century. |
type | Kind of entry: life, premiere, concert or journey. |
title_en, title_ru | Title. |
place | Where it was written or took place (place id). |
people | People involved (person ids). |
works | Works it mentions (work ids). |
url | Page on this site, in English. Replace /en/ with /ru/ for the Russian page. |
source | The page this record was imported from. |
attribution | Who 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.