003 -- Innovation activity relating to product and process innovations by size category of personnel 2008-2016, share of enterprises with innovation activity relating to product and process innovations

Tables

Dim contents, Statfin inn pxt 003 px, Full historyTSV
Dimension Contents (Tiedot)
Dim contents, Statfin inn pxt 003 px, LatestTSV
Dimension Contents (Tiedot)
Dim industry, Statfin inn pxt 003 px, Full historyTSV
Dimension Industry (Toimiala)
Dim industry, Statfin inn pxt 003 px, LatestTSV
Dimension Industry (Toimiala)
Dim size category of personnel, Statfin inn pxt 003 px, Full historyTSV
Dimension Size_category_of_personnel (Henkilökunnan lukumäärä)
Dim size category of personnel, Statfin inn pxt 003 px, LatestTSV
Dimension Size_category_of_personnel (Henkilökunnan lukumäärä)
Dim year, Statfin inn pxt 003 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin inn pxt 003 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin inn pxt 003 px, Full historyTSV
Innovation activity relating to product and process innovations by size category of personnel 2008-2016, share of enterprises with innovation activity relating to product and process innovations by Year, Industry, Size category of personnel and Contents
Fact, Statfin inn pxt 003 px, LatestTSV
Innovation activity relating to product and process innovations by size category of personnel 2008-2016, share of enterprises with innovation activity relating to product and process innovations by Year, Industry, Size category of personnel and Contents

Column Descriptions

Fact, Statfin inn pxt 003 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2016.
industry	string	Datasource did not contain a description for Industry. Column industry has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palvelut and maximum string is Yhteensä.
size_category_of_personnel	string	Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 10-49 and maximum string is 250+.
contents	string	Datasource did not contain a description for Contents. Column contents has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Chiin_mean and maximum string is Hpuupieni_mean.
innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations	int	Datasource did not contain a description for Innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations. Column innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations has 9660 rows, out of which 3528 are empty, making the null percent 36.52. Minimum value is 0 and maximum value is 4945.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin inn pxt 003 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2016.
industry	string	Datasource did not contain a description for Industry. Column industry has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Palvelut and maximum string is Yhteensä.
size_category_of_personnel	string	Datasource did not contain a description for Size_category_of_personnel. Column size_category_of_personnel has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 10-49 and maximum string is 250+.
contents	string	Datasource did not contain a description for Contents. Column contents has 9660 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Chiin_mean and maximum string is Hpuupieni_mean.
innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations	int	Datasource did not contain a description for Innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations. Column innovation_activity_relating_to_product_and_process_innovations_by_size_category_of_personnel_20082016_share_of_enterprises_with_innovation_activity_relating_to_product_and_process_innovations has 9660 rows, out of which 3528 are empty, making the null percent 36.52. Minimum value is 0 and maximum value is 4945.

Dim industry, Statfin inn pxt 003 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 Palvelut and maximum string is Yhteensä.
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 All NACE and maximum string is Services.

Dim size category of personnel, Statfin inn pxt 003 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 10-49 and maximum string is 250+.
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 10-49 and maximum string is 250+.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim industry, Statfin inn pxt 003 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 Palvelut and maximum string is Yhteensä.
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 All NACE and maximum string is Services.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim size category of personnel, Statfin inn pxt 003 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 10-49 and maximum string is 250+.
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 10-49 and maximum string is 250+.

Dim year, Statfin inn pxt 003 px, Latest

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

Dim year, Statfin inn pxt 003 px, Full history

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

Dim contents, Statfin inn pxt 003 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 161 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Chiin_mean and maximum string is Hpuupieni_mean.
label	string	The label for the dimension value. Column label has 161 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Acquisition of external k... and first 25 characters of maximum string: Hampering factor/barrier,...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim contents, Statfin inn pxt 003 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 161 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Chiin_mean and maximum string is Hpuupieni_mean.
label	string	The label for the dimension value. Column label has 161 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Acquisition of external k... and first 25 characters of maximum string: Hampering factor/barrier,...

Additional Info

Last Updated	July 21, 2019
Created	July 13, 2019