1. Home
  2. Datasets
  3. 003 -- Establishments by ...
To download the data set, please sign up or log in

003 -- Establishments by municipality 2013-2017

003 -- Establishments by municipality 2013-2017

Tables

Column Descriptions

Fact, Statfinpas alyr pxt 003 201700 px, Latest

Column Type Comment
municipality int Käytetty alueluokitus perustuu julkaisuun Kunnat ja kuntapohjaiset aluejaot v. 2015. . Column municipality has 6440 rows, out of which 20 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 999.
data string Datasource did not contain a description for Data. Column data has 6440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Lv_hlo.
year int Statistical reference year. . Column year has 6440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2017.
establishments_by_municipality_2015 int Datasource did not contain a description for Establishments_by_municipality_2015. Column establishments_by_municipality_2015 has 6440 rows, out of which 76 are empty, making the null percent 1.18. Minimum value is 11 and maximum value is 411193869.

Fact, Statfinpas alyr pxt 003 201700 px, Full history

Column Type Comment
municipality int Käytetty alueluokitus perustuu julkaisuun Kunnat ja kuntapohjaiset aluejaot v. 2015. . Column municipality has 6440 rows, out of which 20 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 999.
data string Datasource did not contain a description for Data. Column data has 6440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkmaara and maximum string is Lv_hlo.
year int Statistical reference year. . Column year has 6440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2017.
establishments_by_municipality_2015 int Datasource did not contain a description for Establishments_by_municipality_2015. Column establishments_by_municipality_2015 has 6440 rows, out of which 76 are empty, making the null percent 1.18. Minimum value is 11 and maximum value is 411193869.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas alyr pxt 003 201700 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 2013 and maximum value is 2017.
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 2013 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas alyr pxt 003 201700 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 2013 and maximum value is 2017.
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 2013 and maximum value is 2017.

Dim municipality, Statfinpas alyr pxt 003 201700 px, Full history

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

Dim municipality, Statfinpas alyr pxt 003 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 322 rows, out of which 1 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 999.
label string The label for the dimension value. Column label has 322 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Unknown.

Dim data, Statfinpas alyr pxt 003 201700 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 Henkmaara and maximum string is Lv_hlo.
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 Number of establishments and maximum string is Turnover/person EUR 1,000.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas alyr pxt 003 201700 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 Henkmaara and maximum string is Lv_hlo.
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 Number of establishments and maximum string is Turnover/person EUR 1,000.

Additional Info

Last Updated July 20, 2019
Created July 13, 2019