Majoitus- ja ravitsemistoiminnan tilinpäätöstiedot 2010, ennakko (TOL 2008)

Tables

Dim tiedot, T005 matipa tau 104 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, T005 matipa tau 104 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tilastovuosi, T005 matipa tau 104 fi px, Full historyTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim tilastovuosi, T005 matipa tau 104 fi px, LatestTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim toimiala tol 2008, T005 matipa tau 104 fi px, Full historyTSV
Dimension Toimiala_TOL_2008 (Toimiala (TOL 2008))
Dim toimiala tol 2008, T005 matipa tau 104 fi px, LatestTSV
Dimension Toimiala_TOL_2008 (Toimiala (TOL 2008))
Dim yrityksen suuruusluokka yrek, T005 matipa tau 104 fi px, Full historyTSV
Dimension Yrityksen_suuruusluokka_yrek (Yrityksen suuruusluokka (yrek))
Dim yrityksen suuruusluokka yrek, T005 matipa tau 104 fi px, LatestTSV
Dimension Yrityksen_suuruusluokka_yrek (Yrityksen suuruusluokka (yrek))
Fact, T005 matipa tau 104 fi px, Full historyTSV
Majoitus- ja ravitsemistoiminnan tilinpäätöstiedot 2010, ennakko (TOL2008)
Fact, T005 matipa tau 104 fi px, LatestTSV
Majoitus- ja ravitsemistoiminnan tilinpäätöstiedot 2010, ennakko (TOL2008)

Column Descriptions

Fact, T005 matipa tau 104 fi px, Full history

Column	Type	Comment
toimiala_tol_2008	string	Toimialat on määritelty toimialaluokitus TOL 2008:n mukaisina . Column toimiala_tol_2008 has 624 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 55 Majoitus and maximum string is 56 Ravitsemistoiminta.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 624 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 KOKVELAT.
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 624 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2010.
yrityksen_suuruusluokka_yrek	string	Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 624 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.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 624 rows, out of which 48 are empty, making the null percent 7.69. Minimum value is -193176609 and maximum value is 472975322.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T005 matipa tau 104 fi px, Latest

Column	Type	Comment
toimiala_tol_2008	string	Toimialat on määritelty toimialaluokitus TOL 2008:n mukaisina . Column toimiala_tol_2008 has 624 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 55 Majoitus and maximum string is 56 Ravitsemistoiminta.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 624 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 KOKVELAT.
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 624 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2010.
yrityksen_suuruusluokka_yrek	string	Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 624 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.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 624 rows, out of which 48 are empty, making the null percent 7.69. Minimum value is -193176609 and maximum value is 472975322.

Dim tilastovuosi, T005 matipa tau 104 fi px, Latest

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 2009 and maximum value is 2010.
label	int	The label for the dimension value. Column label has 2 rows, out of which 1 are empty, making the null percent 50.00. Constant value is 2009.

Dim tilastovuosi, T005 matipa tau 104 fi px, Full history

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 2009 and maximum value is 2010.
label	int	The label for the dimension value. Column label has 2 rows, out of which 1 are empty, making the null percent 50.00. Constant value is 2009.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim yrityksen suuruusluokka yrek, T005 matipa tau 104 fi px, Full history

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 yritykset and maximum string is Pk-yritykset.
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 yrityksen suuruusluokka yrek, T005 matipa tau 104 fi px, Latest

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 yritykset and maximum string is Pk-yritykset.
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.

Dim tiedot, T005 matipa tau 104 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 39 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 KOKVELAT.
label	string	The label for the dimension value. Column label has 39 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: Kokonaisvelat/liikevaihto...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, T005 matipa tau 104 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 39 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 KOKVELAT.
label	string	The label for the dimension value. Column label has 39 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: Kokonaisvelat/liikevaihto...

Dim toimiala tol 2008, T005 matipa tau 104 fi px, Full history

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 55 Majoitus and maximum string is 56 Ravitsemistoiminta.
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. Minimum string is 55 Majoitus and maximum string is 56 Ravitsemistoiminta.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim toimiala tol 2008, T005 matipa tau 104 fi px, Latest

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 55 Majoitus and maximum string is 56 Ravitsemistoiminta.
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. Minimum string is 55 Majoitus and maximum string is 56 Ravitsemistoiminta.

Additional Info

Last Updated	July 21, 2019
Created	July 13, 2019