Maakunnittainen luottokanta luotonantajan ja -saajan sektorin mukaan vuodesta 2000 alkaen

Tables

Dim luotonantajasektori, T010 alkan tau 101 fi px, LatestTSV
Dimension Luotonantajasektori (Luotonantajasektori)
Dim luotonsaajasektori, T010 alkan tau 101 fi px, Full historyTSV
Dimension Luotonsaajasektori (Luotonsaajasektori)
Dim luotonsaajasektori, T010 alkan tau 101 fi px, LatestTSV
Dimension Luotonsaajasektori (Luotonsaajasektori)
Dim maakunta, T010 alkan tau 101 fi px, Full historyTSV
Dimension Maakunta (Maakunta)
Dim maakunta, T010 alkan tau 101 fi px, LatestTSV
Dimension Maakunta (Maakunta)
Dim vuosi, T010 alkan tau 101 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, T010 alkan tau 101 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, T010 alkan tau 101 fi px, Full historyTSV
Maakunnittainen luottokanta luotonantajan ja -saajan sektorin mukaan muuttujina Luotonsaajasektori, Vuosi, Luotonantajasektori ja Maakunta
Fact, T010 alkan tau 101 fi px, LatestTSV
Maakunnittainen luottokanta luotonantajan ja -saajan sektorin mukaan muuttujina Luotonsaajasektori, Vuosi, Luotonantajasektori ja Maakunta

Column Descriptions

Dim vuosi, T010 alkan tau 101 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.

Dim luotonsaajasektori, T010 alkan tau 101 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 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 6666.
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. First 25 characters of minimum string: Asuntoluotot... and first 25 characters of maximum string: S.15 Kotitalouksia palvel...

Dim luotonsaajasektori, T010 alkan tau 101 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 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 6666.
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. First 25 characters of minimum string: Asuntoluotot... and first 25 characters of maximum string: S.15 Kotitalouksia palvel...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, T010 alkan tau 101 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, T010 alkan tau 101 fi px, Latest

Column	Type	Comment
luotonsaajasektori	int	Datasource did not contain a description for Luotonsaajasektori. Column luotonsaajasektori has 30888 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 6666.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 30888 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 30888 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 30888 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_luotonantajan_ja_saajan_sektorin_mukaan	int	Datasource did not contain a description for Maakunnittainen_luottokanta_luotonantajan_ja_saajan_sektorin_mukaan. Column maakunnittainen_luottokanta_luotonantajan_ja_saajan_sektorin_mukaan has 30888 rows, out of which 1254 are empty, making the null percent 4.06. Minimum value is 0 and maximum value is 179833.

Fact, T010 alkan tau 101 fi px, Full history

Column	Type	Comment
luotonsaajasektori	int	Datasource did not contain a description for Luotonsaajasektori. Column luotonsaajasektori has 30888 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 6666.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 30888 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 30888 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 30888 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_luotonantajan_ja_saajan_sektorin_mukaan	int	Datasource did not contain a description for Maakunnittainen_luottokanta_luotonantajan_ja_saajan_sektorin_mukaan. Column maakunnittainen_luottokanta_luotonantajan_ja_saajan_sektorin_mukaan has 30888 rows, out of which 1254 are empty, making the null percent 4.06. Minimum value is 0 and maximum value is 179833.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim luotonantajasektori, T010 alkan tau 101 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, T010 alkan tau 101 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 maakunta, T010 alkan tau 101 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.

Additional Info

Last Updated	July 21, 2019
Created	July 19, 2019