1. Home
  2. Datasets
  3. 001 -- Research and ...
To download the data set, please sign up or log in

001 -- Research and development expenditure, personnel and full-time equivalents by region in 1995 to 2017

001 -- Research and development expenditure, personnel and full-time equivalents by region in 1995 to 2017

Tables

Column Descriptions

Dim region, Statfin tkke pxt 001 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 120 rows, out of which 12 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 213.
label string The label for the dimension value. Column label has 120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eteläiset seinänaapurit and maximum string is Ålands skärgård.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin tkke pxt 001 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 33120 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.
region int Datasource did not contain a description for Region. Column region has 33120 rows, out of which 3312 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 213.
data string Datasource did not contain a description for Data. Column data has 33120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is henkilöstö and maximum string is ttv.
performing_sector string Datasource did not contain a description for Performing_sector. Column performing_sector has 33120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is JULK and maximum string is KK.
research_and_development_expenditure_personnel_and_fulltime_equivalents int Datasource did not contain a description for Research_and_development_expenditure_personnel_and_fulltime_equivalents. Column research_and_development_expenditure_personnel_and_fulltime_equivalents has 33120 rows, out of which 13128 are empty, making the null percent 39.64. Minimum value is 0 and maximum value is 80817.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfin tkke pxt 001 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 henkilöstö and maximum string is ttv.
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. First 25 characters of minimum string: R&D expenditure (EUR mil.... and first 25 characters of maximum string: R&D in full-time equivale...
orig_extractdate string The date when the data was originally fetched from the source.

Dim performing sector, Statfin tkke pxt 001 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 JULK and maximum string is KK.
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 All performing sectors and maximum string is Higher education sector.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin tkke pxt 001 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.

Fact, Statfin tkke pxt 001 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 33120 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.
region int Datasource did not contain a description for Region. Column region has 33120 rows, out of which 3312 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 213.
data string Datasource did not contain a description for Data. Column data has 33120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is henkilöstö and maximum string is ttv.
performing_sector string Datasource did not contain a description for Performing_sector. Column performing_sector has 33120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is JULK and maximum string is KK.
research_and_development_expenditure_personnel_and_fulltime_equivalents int Datasource did not contain a description for Research_and_development_expenditure_personnel_and_fulltime_equivalents. Column research_and_development_expenditure_personnel_and_fulltime_equivalents has 33120 rows, out of which 13128 are empty, making the null percent 39.64. Minimum value is 0 and maximum value is 80817.

Dim region, Statfin tkke pxt 001 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 120 rows, out of which 12 are empty, making the null percent 10.00. Minimum value is 1 and maximum value is 213.
label string The label for the dimension value. Column label has 120 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eteläiset seinänaapurit and maximum string is Ålands skärgård.

Dim data, Statfin tkke pxt 001 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 henkilöstö and maximum string is ttv.
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. First 25 characters of minimum string: R&D expenditure (EUR mil.... and first 25 characters of maximum string: R&D in full-time equivale...

Dim performing sector, Statfin tkke pxt 001 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 JULK and maximum string is KK.
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 All performing sectors and maximum string is Higher education sector.

Dim year, Statfin tkke pxt 001 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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019