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

001 -- Hotellien kapasiteetti ja sen käyttö

001 -- Hotellien kapasiteetti ja sen käyttö

Tables

Column Descriptions

Fact, Statfinpas matk pxt 001 201812 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 45864 rows, out of which 1911 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi has 45864 rows, out of which 3528 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
hotellien_kapasiteetti_ja_sen_kaytto int Datasource did not contain a description for Hotellien_kapasiteetti_ja_sen_kaytto. Column hotellien_kapasiteetti_ja_sen_kaytto has 45864 rows, out of which 626 are empty, making the null percent 1.36. Minimum value is 6 and maximum value is 120638.

Fact, Statfinpas matk pxt 001 201812 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 45864 rows, out of which 1911 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi has 45864 rows, out of which 3528 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
hotellien_kapasiteetti_ja_sen_kaytto int Datasource did not contain a description for Hotellien_kapasiteetti_ja_sen_kaytto. Column hotellien_kapasiteetti_ja_sen_kaytto has 45864 rows, out of which 626 are empty, making the null percent 1.36. Minimum value is 6 and maximum value is 120638.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas matk pxt 001 201812 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneen keskihinta, € and maximum string is Yöpymisen keskihinta, €.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kuukausi, Statfinpas matk pxt 001 201812 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Elokuu and maximum string is Joulukuu.

Dim kuukausi, Statfinpas matk pxt 001 201812 fi px, Full history

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

Dim vuosi, Statfinpas matk pxt 001 201812 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
label int The label for the dimension value. Column label has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas matk pxt 001 201812 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneen keskihinta, € and maximum string is Yöpymisen keskihinta, €.

Dim maakunta, Statfinpas matk pxt 001 201812 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
label string The label for the dimension value. Column label has 21 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 maakunta, Statfinpas matk pxt 001 201812 fi px, Latest

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

Additional Info

Last Updated September 22, 2019
Created August 5, 2019