001 -- Index of turnover in industry 2010=100 (TOL 2008)

Tables

Dim industry, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Dimension Industry (Industry)
Dim industry, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Dimension Industry (Industry)
Dim period, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Dimension Period (Period)
Dim period, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Dimension Period (Period)
Dim serie, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Dimension Serie (Serie)
Dim serie, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Dimension Serie (Serie)
Dim variable, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Dimension Variable (Variable)
Dim variable, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Dimension Variable (Variable)
Dim year, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Dimension Year (Year)
Dim year, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Dimension Year (Year)
Fact, Statfinpas tlv pxt 001 201712 en px, Full historyTSV
Index of turnover in industry 2010=100 (TOL 2008) by Year, Period, Industry, Variable and Serie
Fact, Statfinpas tlv pxt 001 201712 en px, LatestTSV
Index of turnover in industry 2010=100 (TOL 2008) by Year, Period, Industry, Variable and Serie

Column Descriptions

Fact, Statfinpas tlv pxt 001 201712 en px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 204516 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.
period	int	Datasource did not contain a description for Period. Column period has 204516 rows, out of which 75348 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
industry	int	Datasource did not contain a description for Industry. Column industry has 204516 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2272 and maximum value is 2329.
variable	string	Datasource did not contain a description for Variable. Column variable has 204516 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kl and maximum string is vi.
serie	string	Datasource did not contain a description for Serie. Column serie has 204516 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.
index_of_turnover_in_industry_2010100_tol_2008	int	Datasource did not contain a description for Index_of_turnover_in_industry_2010100_TOL_2008. Column index_of_turnover_in_industry_2010100_tol_2008 has 204516 rows, out of which 35074 are empty, making the null percent 17.15. Minimum value is -75 and maximum value is 430.

Fact, Statfinpas tlv pxt 001 201712 en px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 204516 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.
period	int	Datasource did not contain a description for Period. Column period has 204516 rows, out of which 75348 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
industry	int	Datasource did not contain a description for Industry. Column industry has 204516 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2272 and maximum value is 2329.
variable	string	Datasource did not contain a description for Variable. Column variable has 204516 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kl and maximum string is vi.
serie	string	Datasource did not contain a description for Serie. Column serie has 204516 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.
index_of_turnover_in_industry_2010100_tol_2008	int	Datasource did not contain a description for Index_of_turnover_in_industry_2010100_TOL_2008. Column index_of_turnover_in_industry_2010100_tol_2008 has 204516 rows, out of which 35074 are empty, making the null percent 17.15. Minimum value is -75 and maximum value is 430.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfinpas tlv pxt 001 201712 en 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 year, Statfinpas tlv pxt 001 201712 en 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 period, Statfinpas tlv pxt 001 201712 en 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 1st half-year and maximum string is Year.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim period, Statfinpas tlv pxt 001 201712 en 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 1st half-year and maximum string is Year.

Dim industry, Statfinpas tlv pxt 001 201712 en px, Full history

Column	Type	Comment
code	int	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 value is 2272 and maximum value is 2329.
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: 07 Mining of metal ores... and first 25 characters of maximum string: MIG Non-durable consumer ...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry, Statfinpas tlv pxt 001 201712 en px, Latest

Column	Type	Comment
code	int	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 value is 2272 and maximum value is 2329.
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: 07 Mining of metal ores... and first 25 characters of maximum string: MIG Non-durable consumer ...

Dim variable, Statfinpas tlv pxt 001 201712 en px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kl and maximum string is vi.
label	string	The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Domestic sales and maximum string is Turnover.

Dim variable, Statfinpas tlv pxt 001 201712 en px, Full history

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

Dim serie, Statfinpas tlv pxt 001 201712 en 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 Original series and maximum string is Trend.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim serie, Statfinpas tlv pxt 001 201712 en 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 Original series and maximum string is Trend.

Additional Info

Last Updated	July 28, 2019
Created	July 27, 2019