To download the data set, please sign up or log in

Toimipaikat maakunnittain ja toimialoittain 1993-2000 (TOL 1995)

Toimipaikat maakunnittain ja toimialoittain 1993-2000 (TOL 1995)

Tables

Column Descriptions

Fact, Toimipaikat 1993 2000 maak fi px, Latest

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 21.
toimiala int Toimialaluokitus 1995 . Column toimiala has 90240 rows, out of which 33600 are empty, making the null percent 37.23. Minimum value is 1 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 7.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
toimipaikat_maakunnittain_ja_toimialoittain_19932000_tol_1995 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_19932000_TOL_1995. Column toimipaikat_maakunnittain_ja_toimialoittain_19932000_tol_1995 has 90240 rows, out of which 29907 are empty, making the null percent 33.14. Minimum value is 0 and maximum value is 103093376.

Dim maakunta, Toimipaikat 1993 2000 maak fi px, Full history

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

Dim vuosi, Toimipaikat 1993 2000 maak fi px, Full history

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

Dim toimipaikkojen tiedot, Toimipaikat 1993 2000 maak fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...

Dim toimiala, Toimipaikat 1993 2000 maak fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 94 rows, out of which 35 are empty, making the null percent 37.23. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 94 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 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...

Dim toimiala, Toimipaikat 1993 2000 maak fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 94 rows, out of which 35 are empty, making the null percent 37.23. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 94 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 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Toimipaikat 1993 2000 maak fi px, Latest

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

Dim toimipaikkojen tiedot, Toimipaikat 1993 2000 maak fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Toimipaikat 1993 2000 maak fi px, Full history

Column Type Comment
maakunta int Datasource did not contain a description for Maakunta. Column maakunta has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 21.
toimiala int Toimialaluokitus 1995 . Column toimiala has 90240 rows, out of which 33600 are empty, making the null percent 37.23. Minimum value is 1 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 7.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 90240 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 5.
toimipaikat_maakunnittain_ja_toimialoittain_19932000_tol_1995 int Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_19932000_TOL_1995. Column toimipaikat_maakunnittain_ja_toimialoittain_19932000_tol_1995 has 90240 rows, out of which 29907 are empty, making the null percent 33.14. Minimum value is 0 and maximum value is 103093376.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 20, 2019
Created July 13, 2019