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

Vähittäiskaupan toimipaikat kunnittain 1993-2007

Vähittäiskaupan toimipaikat kunnittain 1993-2007

Tables

Column Descriptions

Fact, T080 syr 2007 2008 11 28 tau 108 fi px, Full history

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 37440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 37440 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 14.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 37440 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.
vahittaiskaupan_toimipaikat_19932007_tol_2002 int Datasource did not contain a description for Vahittaiskaupan_toimipaikat_19932007_TOL_2002. Column vahittaiskaupan_toimipaikat_19932007_tol_2002 has 37440 rows, out of which 10982 are empty, making the null percent 29.33. Minimum value is 1 and maximum value is 5313265.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kunta, T080 syr 2007 2008 11 28 tau 108 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 416 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 416 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 Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimipaikkojen tiedot, T080 syr 2007 2008 11 28 tau 108 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 kunta, T080 syr 2007 2008 11 28 tau 108 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 416 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
label string The label for the dimension value. Column label has 416 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 Äänekoski.

Fact, T080 syr 2007 2008 11 28 tau 108 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 37440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 992.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 37440 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 14.
toimipaikkojen_tiedot int Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 37440 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.
vahittaiskaupan_toimipaikat_19932007_tol_2002 int Datasource did not contain a description for Vahittaiskaupan_toimipaikat_19932007_TOL_2002. Column vahittaiskaupan_toimipaikat_19932007_tol_2002 has 37440 rows, out of which 10982 are empty, making the null percent 29.33. Minimum value is 1 and maximum value is 5313265.

Dim vuosi, T080 syr 2007 2008 11 28 tau 108 fi px, Full history

Column Type Comment
code int 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 value is 0 and maximum value is 14.
label int 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. Minimum value is 1993 and maximum value is 2007.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T080 syr 2007 2008 11 28 tau 108 fi px, Latest

Column Type Comment
code int 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 value is 0 and maximum value is 14.
label int 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. Minimum value is 1993 and maximum value is 2007.

Dim toimipaikkojen tiedot, T080 syr 2007 2008 11 28 tau 108 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.

Additional Info

Last Updated September 22, 2019
Created August 5, 2019