Kaupan tilinpäätöstiedot 2006-2012 (TOL 2008)

Tables

Dim tiedot, T008 katipa tau 103 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, T008 katipa tau 103 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tilastovuosi, T008 katipa tau 103 fi px, Full historyTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim tilastovuosi, T008 katipa tau 103 fi px, LatestTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim toimiala, T008 katipa tau 103 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T008 katipa tau 103 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim yrityksen suuruusluokka yrek, T008 katipa tau 103 fi px, Full historyTSV
Dimension Yrityksen_suuruusluokka_yrek (Yrityksen suuruusluokka (yrek))
Dim yrityksen suuruusluokka yrek, T008 katipa tau 103 fi px, LatestTSV
Dimension Yrityksen_suuruusluokka_yrek (Yrityksen suuruusluokka (yrek))
Fact, T008 katipa tau 103 fi px, Full historyTSV
Kaupan tilinpäätöstiedot 2006-2012 (TOL 2008)
Fact, T008 katipa tau 103 fi px, LatestTSV
Kaupan tilinpäätöstiedot 2006-2012 (TOL 2008)

Column Descriptions

Dim tilastovuosi, T008 katipa tau 103 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 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 2012.
label	int	The label for the dimension value. Column label has 7 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 2012.

Dim toimiala, T008 katipa tau 103 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...
label	string	The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T008 katipa tau 103 fi px, Full history

Column	Type	Comment
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 21546 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 21546 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 21546 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 2012.
yrityksen_suuruusluokka_yrek	string	Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 21546 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yrity and maximum string is Pk-yritykset.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 21546 rows, out of which 1134 are empty, making the null percent 5.26. Minimum value is -219916282 and maximum value is 512623893.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tilastovuosi, T008 katipa tau 103 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 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 2012.
label	int	The label for the dimension value. Column label has 7 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 2012.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T008 katipa tau 103 fi px, Latest

Column	Type	Comment
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 21546 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 21546 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 21546 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 2012.
yrityksen_suuruusluokka_yrek	string	Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 21546 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yrity and maximum string is Pk-yritykset.
tilinpaatostiedot	int	Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 21546 rows, out of which 1134 are empty, making the null percent 5.26. Minimum value is -219916282 and maximum value is 512623893.

Dim tiedot, T008 katipa tau 103 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 57 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 57 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 yrityksen suuruusluokka yrek, T008 katipa tau 103 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 yrity 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 toimiala, T008 katipa tau 103 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...
label	string	The label for the dimension value. Column label has 27 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 451 Moottoriajoneuvojen k... and first 25 characters of maximum string: 479 Väh.kauppa muualla ku...

Dim yrityksen suuruusluokka yrek, T008 katipa tau 103 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 yrity 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 tiedot, T008 katipa tau 103 fi px, Full history

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

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019