001 -- Kaupan liikevaihtokuvaaja 2010=100 (TOL 2008)

Tables

Dim ajanjakso, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Dimension Ajanjakso (Ajanjakso)
Dim ajanjakso, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Dimension Ajanjakso (Ajanjakso)
Dim muuttuja, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Dimension Muuttuja (Muuttuja)
Dim muuttuja, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Dimension Muuttuja (Muuttuja)
Dim sarja, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Dimension Sarja (Sarja)
Dim sarja, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Dimension Sarja (Sarja)
Dim toimiala, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim vuosi, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfinpas klv pxt 001 201712 fi px, Full historyTSV
Kaupan liikevaihtokuvaaja 2010=100 (TOL 2008) muuttujina Vuosi, Ajanjakso, Toimiala, Muuttuja ja Sarja
Fact, Statfinpas klv pxt 001 201712 fi px, LatestTSV
Kaupan liikevaihtokuvaaja 2010=100 (TOL 2008) muuttujina Vuosi, Ajanjakso, Toimiala, Muuttuja ja Sarja

Column Descriptions

Fact, Statfinpas klv pxt 001 201712 fi px, Full history

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso	int	Datasource did not contain a description for Ajanjakso. Column ajanjakso has 87400 rows, out of which 32200 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2216 and maximum value is 2246.
muuttuja	string	Datasource did not contain a description for Muuttuja. Column muuttuja has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
sarja	string	Datasource did not contain a description for Sarja. Column sarja has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
kaupan_liikevaihtokuvaaja_2010100_tol_2008	int	Datasource did not contain a description for Kaupan_liikevaihtokuvaaja_2010100_TOL_2008. Column kaupan_liikevaihtokuvaaja_2010100_tol_2008 has 87400 rows, out of which 1558 are empty, making the null percent 1.78. Minimum value is -60 and maximum value is 280.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas klv pxt 001 201712 fi px, Latest

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso	int	Datasource did not contain a description for Ajanjakso. Column ajanjakso has 87400 rows, out of which 32200 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2216 and maximum value is 2246.
muuttuja	string	Datasource did not contain a description for Muuttuja. Column muuttuja has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
sarja	string	Datasource did not contain a description for Sarja. Column sarja has 87400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
kaupan_liikevaihtokuvaaja_2010100_tol_2008	int	Datasource did not contain a description for Kaupan_liikevaihtokuvaaja_2010100_TOL_2008. Column kaupan_liikevaihtokuvaaja_2010100_tol_2008 has 87400 rows, out of which 1558 are empty, making the null percent 1.78. Minimum value is -60 and maximum value is 280.

Dim vuosi, Statfinpas klv pxt 001 201712 fi px, Full history

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

Dim vuosi, Statfinpas klv pxt 001 201712 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
label	int	The label for the dimension value. Column label has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.

Dim ajanjakso, Statfinpas klv pxt 001 201712 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 19 rows, out of which 7 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
label	string	The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. puolivuosi and maximum string is Vuosi.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim ajanjakso, Statfinpas klv pxt 001 201712 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 19 rows, out of which 7 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
label	string	The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. puolivuosi and maximum string is Vuosi.

Dim muuttuja, Statfinpas klv pxt 001 201712 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 lv and maximum string is mi.
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 Liikevaihto and maximum string is Määräindeksi.

Dim toimiala, Statfinpas klv pxt 001 201712 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2216 and maximum value is 2246.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 45 Moottoriajoneuvojen ka... and first 25 characters of maximum string: Muu väh.kauppa (47595,476...

Dim muuttuja, Statfinpas klv pxt 001 201712 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 lv and maximum string is mi.
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 Liikevaihto and maximum string is Määräindeksi.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sarja, Statfinpas klv pxt 001 201712 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 Alkuperainen and maximum string is Trendi.
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 Alkuperäinen sarja and maximum string is Trendisarja.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sarja, Statfinpas klv pxt 001 201712 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 Alkuperainen and maximum string is Trendi.
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 Alkuperäinen sarja and maximum string is Trendisarja.

Dim toimiala, Statfinpas klv pxt 001 201712 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2216 and maximum value is 2246.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 45 Moottoriajoneuvojen ka... and first 25 characters of maximum string: Muu väh.kauppa (47595,476...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 18, 2019
Created	July 12, 2019