007 -- Capital stocks by industry 1975-2017

Tables

Dim asset, Statfin ttut pxt 007 px, Full historyTSV
Dimension Asset (Tavaratyyppi)
Dim asset, Statfin ttut pxt 007 px, LatestTSV
Dimension Asset (Tavaratyyppi)
Dim industry, Statfin ttut pxt 007 px, Full historyTSV
Dimension Industry (Toimiala)
Dim industry, Statfin ttut pxt 007 px, LatestTSV
Dimension Industry (Toimiala)
Dim sector, Statfin ttut pxt 007 px, Full historyTSV
Dimension Sector (Sektori)
Dim sector, Statfin ttut pxt 007 px, LatestTSV
Dimension Sector (Sektori)
Dim type, Statfin ttut pxt 007 px, Full historyTSV
Dimension Type (Tiedot)
Dim type, Statfin ttut pxt 007 px, LatestTSV
Dimension Type (Tiedot)
Dim year, Statfin ttut pxt 007 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin ttut pxt 007 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin ttut pxt 007 px, Full historyTSV
Capital stocks by industry by Industry, Sector, Asset, Type and Year
Fact, Statfin ttut pxt 007 px, LatestTSV
Capital stocks by industry by Industry, Sector, Asset, Type and Year

Column Descriptions

Fact, Statfin ttut pxt 007 px, Latest

Column	Type	Comment
industry	int	Datasource did not contain a description for Industry. Column industry has 247680 rows, out of which 58050 are empty, making the null percent 23.44. Minimum value is 0 and maximum value is 96.
sector	string	Datasource did not contain a description for Sector. Column sector has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S1Y.
asset	string	Datasource did not contain a description for Asset. Column asset has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N111 and maximum string is N1174.
type	string	Datasource did not contain a description for Type. Column type has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HINTA and maximum string is KANTA.
year	int	Datasource did not contain a description for Year. Column year has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1975 and maximum value is 2017.
capital_stocks_by_industry	int	Datasource did not contain a description for Capital_stocks_by_industry. Column capital_stocks_by_industry has 247680 rows, out of which 162115 are empty, making the null percent 65.45. Minimum value is -36 and maximum value is 795876.

Dim industry, Statfin ttut pxt 007 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 64 rows, out of which 15 are empty, making the null percent 23.44. Minimum value is 0 and maximum value is 96.
label	string	The label for the dimension value. Column label has 64 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Agriculture and huntin... and first 25 characters of maximum string: 97_98 Household service a...

Dim year, Statfin ttut pxt 007 px, Latest

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

Fact, Statfin ttut pxt 007 px, Full history

Column	Type	Comment
industry	int	Datasource did not contain a description for Industry. Column industry has 247680 rows, out of which 58050 are empty, making the null percent 23.44. Minimum value is 0 and maximum value is 96.
sector	string	Datasource did not contain a description for Sector. Column sector has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S1Y.
asset	string	Datasource did not contain a description for Asset. Column asset has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N111 and maximum string is N1174.
type	string	Datasource did not contain a description for Type. Column type has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is HINTA and maximum string is KANTA.
year	int	Datasource did not contain a description for Year. Column year has 247680 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1975 and maximum value is 2017.
capital_stocks_by_industry	int	Datasource did not contain a description for Capital_stocks_by_industry. Column capital_stocks_by_industry has 247680 rows, out of which 162115 are empty, making the null percent 65.45. Minimum value is -36 and maximum value is 795876.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sector, Statfin ttut pxt 007 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 S1 and maximum string is S1Y.
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 S1J Public sector (S13) and maximum string is S1Y Private sector.

Dim sector, Statfin ttut pxt 007 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 S1 and maximum string is S1Y.
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 S1J Public sector (S13) and maximum string is S1Y Private sector.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim type, Statfin ttut pxt 007 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 HINTA and maximum string is KANTA.
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. First 25 characters of minimum string: Capital price index, 2000... and first 25 characters of maximum string: Productive capital stock...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim type, Statfin ttut pxt 007 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 HINTA and maximum string is KANTA.
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. First 25 characters of minimum string: Capital price index, 2000... and first 25 characters of maximum string: Productive capital stock...

Dim industry, Statfin ttut pxt 007 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 64 rows, out of which 15 are empty, making the null percent 23.44. Minimum value is 0 and maximum value is 96.
label	string	The label for the dimension value. Column label has 64 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Agriculture and huntin... and first 25 characters of maximum string: 97_98 Household service a...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim asset, Statfin ttut pxt 007 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N111 and maximum string is N1174.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: N111 Dwellings... and first 25 characters of maximum string: N1174 Entertainment, lite...

Dim year, Statfin ttut pxt 007 px, Full history

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

Dim asset, Statfin ttut pxt 007 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is N111 and maximum string is N1174.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: N111 Dwellings... and first 25 characters of maximum string: N1174 Entertainment, lite...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	September 20, 2019
Created	August 3, 2019