1. Home
  2. Datasets
  3. 011 -- External assets and ...
To download the data set, please sign up or log in

011 -- External assets and liabilities by investment type and sectors, flow

011 -- External assets and liabilities by investment type and sectors, flow

Tables

Column Descriptions

Fact, Statfin mata pxt 011 px, Latest

Column Type Comment
ref_sector string Datasource did not contain a description for ref_sector. Column ref_sector has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S14+S15.
accounting_entry string Datasource did not contain a description for Accounting_entry. Column accounting_entry has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is N.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _t_f and maximum string is R_f.
year int Datasource did not contain a description for Year. Column year has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2018.
external_assets_and_liabilities_by_investment_type_and_sectors_flow int Datasource did not contain a description for External_assets_and_liabilities_by_investment_type_and_sectors_flow. Column external_assets_and_liabilities_by_investment_type_and_sectors_flow has 7488 rows, out of which 2913 are empty, making the null percent 38.90. Minimum value is -96622 and maximum value is 89077.

Fact, Statfin mata pxt 011 px, Full history

Column Type Comment
ref_sector string Datasource did not contain a description for ref_sector. Column ref_sector has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S14+S15.
accounting_entry string Datasource did not contain a description for Accounting_entry. Column accounting_entry has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is N.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _t_f and maximum string is R_f.
year int Datasource did not contain a description for Year. Column year has 7488 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2018.
external_assets_and_liabilities_by_investment_type_and_sectors_flow int Datasource did not contain a description for External_assets_and_liabilities_by_investment_type_and_sectors_flow. Column external_assets_and_liabilities_by_investment_type_and_sectors_flow has 7488 rows, out of which 2913 are empty, making the null percent 38.90. Minimum value is -96622 and maximum value is 89077.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ref sector, Statfin mata pxt 011 px, Latest

Column Type Comment
code string 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 string is S1 and maximum string is S14+S15.
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. First 25 characters of minimum string: S11 Non-financial corpora... and first 25 characters of maximum string: S14+S15 Households and no...

Dim ref sector, Statfin mata pxt 011 px, Full history

Column Type Comment
code string 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 string is S1 and maximum string is S14+S15.
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. First 25 characters of minimum string: S11 Non-financial corpora... and first 25 characters of maximum string: S14+S15 Households and no...
orig_extractdate string The date when the data was originally fetched from the source.

Dim accounting entry, Statfin mata pxt 011 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is N.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Assets and maximum string is Net.

Dim accounting entry, Statfin mata pxt 011 px, Full history

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

Dim tiedot, Statfin mata pxt 011 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _t_f and maximum string is R_f.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.1.1 Equity capital and maximum string is 1.5 Reserve assets.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfin mata pxt 011 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _t_f and maximum string is R_f.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.1.1 Equity capital and maximum string is 1.5 Reserve assets.

Dim year, Statfin mata pxt 011 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 2006 and maximum value is 2018.
label int 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 value is 2006 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin mata pxt 011 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 2006 and maximum value is 2018.
label int 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 value is 2006 and maximum value is 2018.

Additional Info

Last Updated July 31, 2019
Created July 31, 2019