001 -- Kivihiilen kulutus

Tables

Dim jakso, Statfinpas kivih pxt 001 201812 fi px, Full historyTSV
Dimension Jakso (Jakso)
Dim jakso, Statfinpas kivih pxt 001 201812 fi px, LatestTSV
Dimension Jakso (Jakso)
Dim tiedot, Statfinpas kivih pxt 001 201812 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas kivih pxt 001 201812 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tuote, Statfinpas kivih pxt 001 201812 fi px, Full historyTSV
Dimension Tuote (Tuote)
Dim tuote, Statfinpas kivih pxt 001 201812 fi px, LatestTSV
Dimension Tuote (Tuote)
Dim vuosi ennakollinen, Statfinpas kivih pxt 001 201812 fi px, Full historyTSV
Dimension Vuosi_ennakollinen (Vuosi(* ennakollinen))
Dim vuosi ennakollinen, Statfinpas kivih pxt 001 201812 fi px, LatestTSV
Dimension Vuosi_ennakollinen (Vuosi(* ennakollinen))
Fact, Statfinpas kivih pxt 001 201812 fi px, Full historyTSV
Kivihiilen kulutus muuttujina Tuote, Vuosi(* ennakollinen), Jakso ja Tiedot
Fact, Statfinpas kivih pxt 001 201812 fi px, LatestTSV
Kivihiilen kulutus muuttujina Tuote, Vuosi(* ennakollinen), Jakso ja Tiedot

Column Descriptions

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

Column	Type	Comment
tuote	string	Datasource did not contain a description for Tuote. Column tuote has 20580 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ktoe and maximum string is Liuku.
vuosi_ennakollinen	int	Datasource did not contain a description for Vuosi_ennakollinen. Column vuosi_ennakollinen has 20580 rows, out of which 420 are empty, making the null percent 2.04. Minimum value is 1970 and maximum value is 2017.
jakso	int	Datasource did not contain a description for Jakso. Column jakso has 20580 rows, out of which 8820 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 12.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 20580 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvo and maximum string is Kuukausimuutos.
kivihiilen_kulutus	int	Datasource did not contain a description for Kivihiilen_kulutus. Column kivihiilen_kulutus has 20580 rows, out of which 15378 are empty, making the null percent 74.72. Minimum value is -88 and maximum value is 54116363.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tuote, Statfinpas kivih pxt 001 201812 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ktoe and maximum string is Liuku.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kivihiilen kulutus, 1000 ... and first 25 characters of maximum string: Kulutuksen 12 kuukauden l...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tuote, Statfinpas kivih pxt 001 201812 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ktoe and maximum string is Liuku.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kivihiilen kulutus, 1000 ... and first 25 characters of maximum string: Kulutuksen 12 kuukauden l...

Dim vuosi ennakollinen, Statfinpas kivih pxt 001 201812 fi px, Full history

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

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

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

Dim jakso, Statfinpas kivih pxt 001 201812 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 rows, out of which 9 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 12.
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. First 25 characters of minimum string: 1. Vuosineljännes... and first 25 characters of maximum string: Tammi-joulukuu kumumulati...
orig_extractdate	string	The date when the data was originally fetched from the source.

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

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvo and maximum string is Kuukausimuutos.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kulutus and maximum string is Kuukausimuutos %.

Fact, Statfinpas kivih pxt 001 201812 fi px, Latest

Column	Type	Comment
tuote	string	Datasource did not contain a description for Tuote. Column tuote has 20580 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ktoe and maximum string is Liuku.
vuosi_ennakollinen	int	Datasource did not contain a description for Vuosi_ennakollinen. Column vuosi_ennakollinen has 20580 rows, out of which 420 are empty, making the null percent 2.04. Minimum value is 1970 and maximum value is 2017.
jakso	int	Datasource did not contain a description for Jakso. Column jakso has 20580 rows, out of which 8820 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 12.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 20580 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arvo and maximum string is Kuukausimuutos.
kivihiilen_kulutus	int	Datasource did not contain a description for Kivihiilen_kulutus. Column kivihiilen_kulutus has 20580 rows, out of which 15378 are empty, making the null percent 74.72. Minimum value is -88 and maximum value is 54116363.

Dim jakso, Statfinpas kivih pxt 001 201812 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 rows, out of which 9 are empty, making the null percent 42.86. Minimum value is 1 and maximum value is 12.
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. First 25 characters of minimum string: 1. Vuosineljännes... and first 25 characters of maximum string: Tammi-joulukuu kumumulati...

Dim vuosi ennakollinen, Statfinpas kivih pxt 001 201812 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 49 rows, out of which 1 are empty, making the null percent 2.04. Minimum value is 1970 and maximum value is 2017.
label	int	The label for the dimension value. Column label has 49 rows, out of which 1 are empty, making the null percent 2.04. Minimum value is 1970 and maximum value is 2017.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019