1. Home
  2. Datasets
  3. Maakunnittainen luottokanta ...
To download the data set, please sign up or log in

Maakunnittainen luottokanta luotonantajan ja -saajan toimialan mukaan vuodesta 2000 alkaen

Maakunnittainen luottokanta luotonantajan ja -saajan toimialan mukaan vuodesta 2000 alkaen

Tables

Column Descriptions

Dim vuosi, T020 alkan tau 102 fi px, Full history

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

Fact, T020 alkan tau 102 fi px, Latest

Column Type Comment
luotonsaajan_toimiala int Datasource did not contain a description for Luotonsaajan_toimiala. Column luotonsaajan_toimiala has 35640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 9999.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 35640 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 8.
luotonantajasektori int Datasource did not contain a description for Luotonantajasektori. Column luotonantajasektori has 35640 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 351.
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 35640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S100 and maximum string is S131.
maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan int Datasource did not contain a description for Maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan. Column maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan has 35640 rows, out of which 1606 are empty, making the null percent 4.51. Minimum value is -2 and maximum value is 67125.

Dim luotonantajasektori, T020 alkan tau 102 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 12 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 351.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S.121 Suomen Pankki and maximum string is S.13141 Työeläkelaitokset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim luotonantajasektori, T020 alkan tau 102 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 12 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 351.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S.121 Suomen Pankki and maximum string is S.13141 Työeläkelaitokset.

Dim maakunta, T020 alkan tau 102 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S100 and maximum string is S131.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Erittelemättömät luotot and maximum string is MK21 Ahvenanmaa.

Dim vuosi, T020 alkan tau 102 fi px, Latest

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

Fact, T020 alkan tau 102 fi px, Full history

Column Type Comment
luotonsaajan_toimiala int Datasource did not contain a description for Luotonsaajan_toimiala. Column luotonsaajan_toimiala has 35640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 9999.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 35640 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 8.
luotonantajasektori int Datasource did not contain a description for Luotonantajasektori. Column luotonantajasektori has 35640 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 351.
maakunta string Datasource did not contain a description for Maakunta. Column maakunta has 35640 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S100 and maximum string is S131.
maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan int Datasource did not contain a description for Maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan. Column maakunnittainen_luottokanta_luotonantajasektorin_ja_luotonsaajan_toimialan_mukaan has 35640 rows, out of which 1606 are empty, making the null percent 4.51. Minimum value is -2 and maximum value is 67125.
orig_extractdate string The date when the data was originally fetched from the source.

Dim maakunta, T020 alkan tau 102 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S100 and maximum string is S131.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Erittelemättömät luotot and maximum string is MK21 Ahvenanmaa.
orig_extractdate string The date when the data was originally fetched from the source.

Dim luotonsaajan toimiala, T020 alkan tau 102 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 5 and maximum value is 9999.
label string 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. First 25 characters of minimum string: 00...O Kaikki yhteensä... and first 25 characters of maximum string: O Muut yhteiskunnalliset ...

Dim luotonsaajan toimiala, T020 alkan tau 102 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 5 and maximum value is 9999.
label string 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. First 25 characters of minimum string: 00...O Kaikki yhteensä... and first 25 characters of maximum string: O Muut yhteiskunnalliset ...
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