Liikenteen tilinpäätöstiedot 2005-2008 (TOL 2002)

Tables

Dim tiedot, T010 litipa tau 101 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, T010 litipa tau 101 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tilastovuosi, T010 litipa tau 101 fi px, Full historyTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim tilastovuosi, T010 litipa tau 101 fi px, LatestTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim toimiala, T010 litipa tau 101 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T010 litipa tau 101 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim yrityksen pksuuruusluokka eumaaritelm, T010 litipa tau 101 fi px, Full historyTSV
Dimension Yrityksen_PKsuuruusluokka_EUmaaritelm (Yrityksen PK-suuruusluokka, EU-määritelm)
Dim yrityksen pksuuruusluokka eumaaritelm, T010 litipa tau 101 fi px, LatestTSV
Dimension Yrityksen_PKsuuruusluokka_EUmaaritelm (Yrityksen PK-suuruusluokka, EU-määritelm)
Fact, T010 litipa tau 101 fi px, Full historyTSV
Liikenteen tilinpäätöstiedot 2005-2008 (TOL2002)
Fact, T010 litipa tau 101 fi px, LatestTSV
Liikenteen tilinpäätöstiedot 2005-2008 (TOL2002)

Column Descriptions

Dim tilastovuosi, T010 litipa tau 101 fi px, Full history

Column	Type	Comment
code	int	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 value is 2005 and maximum value is 2008.
label	int	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 value is 2005 and maximum value is 2008.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim toimiala, T010 litipa tau 101 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum value is 61 and maximum value is 642.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 61 Vesiliikenne and maximum string is 642 Teleliikenne.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tilastovuosi, T010 litipa tau 101 fi px, Latest

Column	Type	Comment
code	int	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 value is 2005 and maximum value is 2008.
label	int	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 value is 2005 and maximum value is 2008.

Fact, T010 litipa tau 101 fi px, Full history

Column	Type	Comment
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 3328 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2008.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 3328 rows, out of which 2080 are empty, making the null percent 62.50. Minimum value is 61 and maximum value is 642.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 3328 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.
yrityksen_pksuuruusluokka_eumaaritelm	string	Datasource did not contain a description for Yrityksen_PKsuuruusluokka_EUmaaritelm. Column yrityksen_pksuuruusluokka_eumaaritelm has 3328 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-yritykset.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 3328 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -219878784 and maximum value is 470395758.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim toimiala, T010 litipa tau 101 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum value is 61 and maximum value is 642.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 61 Vesiliikenne and maximum string is 642 Teleliikenne.

Dim tiedot, T010 litipa tau 101 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 52 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 52 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 yrityksen pksuuruusluokka eumaaritelm, T010 litipa tau 101 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 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 and maximum string is Pk-yritykset.

Fact, T010 litipa tau 101 fi px, Latest

Column	Type	Comment
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 3328 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2008.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 3328 rows, out of which 2080 are empty, making the null percent 62.50. Minimum value is 61 and maximum value is 642.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 3328 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.
yrityksen_pksuuruusluokka_eumaaritelm	string	Datasource did not contain a description for Yrityksen_PKsuuruusluokka_EUmaaritelm. Column yrityksen_pksuuruusluokka_eumaaritelm has 3328 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-yritykset.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 3328 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -219878784 and maximum value is 470395758.

Dim yrityksen pksuuruusluokka eumaaritelm, T010 litipa tau 101 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 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 and maximum string is Pk-yritykset.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, T010 litipa tau 101 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 52 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 52 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...

Additional Info

Last Updated	September 20, 2019
Created	August 4, 2019