To download the data set, please sign up or log in

Majoitus- ja ravitsemistoiminnan tilinpäätöstiedot 2007, ennakko

Majoitus- ja ravitsemistoiminnan tilinpäätöstiedot 2007, ennakko

Tables

Column Descriptions

Fact, Majoitus Ja Ravitsemistoiminnan Tilinpaatostiedot 2007 Ennakko

Column Type Comment
toimiala string Toimialat on määritelty toimialaluokitus TOL2002:n mukaisina . Column toimiala has 592 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 551-552 and maximum string is 553-555.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 592 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKONP.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 592 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2007.
yrityksen_pksuuruusluokka_eumaaritelm string Datasource did not contain a description for Yrityksen_PKsuuruusluokka_EUmaaritelm. Column yrityksen_pksuuruusluokka_eumaaritelm has 592 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki and maximum string is Pk.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 592 rows, out of which 40 are empty, making the null percent 6.76. Minimum value is -206814453 and maximum value is 382419174.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Toimiala, Majoitus Ja Ravitsemistoiminnan Tilinpaatostiedot 2007 Ennakko

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 551-552 and maximum string is 553-555.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 551-552 Majoitustoiminta... and first 25 characters of maximum string: 553-555 Ravitsemistoimint...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Tiedot, Majoitus Ja Ravitsemistoiminnan Tilinpaatostiedot 2007 Ennakko

Column Type Comment
code string The code for the dimension value. Column code has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKONP.
label string The label for the dimension value. Column label has 37 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineelliset nettoinvestoi... and first 25 characters of maximum string: Kokonaistulos-%...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Yrityksen Pksuuruusluokka Eumaaritelm, Majoitus Ja Ravitsemistoiminnan Tilinpaatostiedot 2007 Ennakko

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki and maximum string is Pk.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yritykset and maximum string is Pk-yritykset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Tilastovuosi, Majoitus Ja Ravitsemistoiminnan Tilinpaatostiedot 2007 Ennakko

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2007.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2006 and maximum string is 2007*.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created February 14, 2019