To download the data set, please sign up or log in
Helsingin kaupunginorkesterin konsertit 1882-
Tables
-
Table, Helsingin Kaupunginorkesterin Konsertit CsvTSV
Helsingin kaupunginorkesterin (HKO) esittämät ja järjestämät konsertit teoksineen vuodesta 1882 alkaen. Aineisto päivitetään kerran vuodessa. Päivityksen yhteydessä myös historiatietoihin voi tulla muutoksia ja täydennyksiä. Orkesterin nimenä on ollut Helsingin Orkesteriyhdistys 1882-1894 Helsingin Filharmoninen Seura 1894-1914 Helsingin kaupunginorkesteri 1914- Aineistossa on seuraavat tiedot Konsertti-id Konsertin päivämäärä ja kellonaika Teosten esitysjärjestys konsertissa Kapellimestarin nimi Säveltäjän nimi Teoksen nimi Sovittajan nimi Orkesterin / yhtyeen nimi Solisti(e)n nimi ja instrumentti Konsertin nimike Konserttipaikka Tietoa konsertista Lisätietoa Lisätiedot sisältävät mm. seuraavaa Ohjelma arkistossa = ohjelma HKO:n arkistossa (20 vuotta vanhemmat ohjelmat ovat...
Column Descriptions
Table, Helsingin Kaupunginorkesterin Konsertit Csv
| Column | Type | Comment |
|---|---|---|
| id_paivamaara_ja_konsertin_jarjestys_viikolla | string | Data source did not contain a description for Id_Paivamaara_ja_konsertin_jarjestys_viikolla. Column id_paivamaara_ja_konsertin_jarjestys_viikolla has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 18821003_1 and maximum string is 20170612_1 . |
| aloitusaika | string | Data source did not contain a description for Aloitusaika. Column aloitusaika has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is 18:00. |
| esitysjarjestys | int | Data source did not contain a description for Esitysjarjestys. Column esitysjarjestys has 50553 rows, out of which 47 are empty, making the null percent 0.09. Minimum value is 1 and maximum value is 58. |
| paivamaara | string | Data source did not contain a description for Paivamaara. Column paivamaara has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01.01.1887 and maximum string is 12.6.2017. |
| kapellimestari | string | Data source did not contain a description for Kapellimestari. Column kapellimestari has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is Hárs József . |
| saveltaja | string | Data source did not contain a description for Saveltaja. Column saveltaja has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is Ruotsalainen kansanlaulu . |
| teoksen_nimi | string | Data source did not contain a description for Teoksen_nimi. Column teoksen_nimi has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is Suvivirsi . |
| sovittaja | string | Data source did not contain a description for Sovittaja. Column sovittaja has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is sov./arr. Jorma Härkönen . |
| orkesteriyhtye | string | Data source did not contain a description for Orkesteriyhtye. Column orkesteriyhtye has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ... and first 25 characters of maximum string: Helsingin kaupunginorkest... |
| solisti_instrumentti | string | Data source did not contain a description for Solisti_instrumentti. Column solisti_instrumentti has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is Denk Jeremy (piano) . |
| konsertin_nimike | string | Data source did not contain a description for Konsertin_nimike. Column konsertin_nimike has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is (ei sarjoissa) and maximum string is Muu esiintyminen . |
| konserttipaikka | string | Data source did not contain a description for Konserttipaikka. Column konserttipaikka has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ... and first 25 characters of maximum string: Konserttisali, Musiikkita... |
| tietoa_konsertista | string | Data source did not contain a description for Tietoa_konsertista. Column tietoa_konsertista has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: ... and first 25 characters of maximum string: Suomi 100 Helsinkipäivä, ... |
| lisatietoa_konsertista | string | Data source did not contain a description for Lisatietoa_konsertista. Column lisatietoa_konsertista has 50553 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is and maximum string is Ohjelma puuttuu. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 12, 2019 |
|---|---|
| Created | June 12, 2018 |