To download the data set, please sign up or log in

11 g 3 -- Investments of employment pension, life insurance and non-life insurance companies, 2012-2017

11 g 3 -- Investments of employment pension, life insurance and non-life insurance companies, 2012-2017

Tables

Column Descriptions

Fact, Statfin vato pxt 11g3 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
reporting_institution int Datasource did not contain a description for Reporting_institution. Column reporting_institution has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 420.
net_investment_income_in_the_profit_and_loss_account int Datasource did not contain a description for Net_investment_income_in_the_profit_and_loss_account. Column net_investment_income_in_the_profit_and_loss_account has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 439158 and maximum value is 8748586.
income_from_investment_activities_total int Datasource did not contain a description for Income_from_investment_activities_total. Column income_from_investment_activities_total has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 803449 and maximum value is 33420508.
income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Income_from_investments_in_affiliated_undertakings. Column income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4469 and maximum value is 50297.
dividend_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Dividend_income_from_investments_in_affiliated_undertakings. Column dividend_income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349 and maximum value is 47487.
interest_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Interest_income_from_investments_in_affiliated_undertakings. Column interest_income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1303 and maximum value is 19643.
other_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Other_income_from_investments_in_affiliated_undertakings. Column other_income_from_investments_in_affiliated_undertakings has 18 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 11578.
income_from_investments_in_associated_undertakings int Datasource did not contain a description for Income_from_investments_in_associated_undertakings. Column income_from_investments_in_associated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 147 and maximum value is 31112.
share_of_associated_undertakings_profitslosses int Datasource did not contain a description for Share_of_associated_undertakings_profitslosses. Column share_of_associated_undertakings_profitslosses has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
dividend_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Dividend_income_from_investments_in_associated_undertakings. Column dividend_income_from_investments_in_associated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 88 and maximum value is 18855.
interest_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Interest_income_from_investments_in_associated_undertakings. Column interest_income_from_investments_in_associated_undertakings has 18 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 13154.
other_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Other_income_from_investments_in_associated_undertakings. Column other_income_from_investments_in_associated_undertakings has 18 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 25881.
income_from_investments_in_land_and_buildings int Datasource did not contain a description for Income_from_investments_in_land_and_buildings. Column income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75807 and maximum value is 843654.
dividend_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Dividend_income_from_investments_in_land_and_buildings. Column dividend_income_from_investments_in_land_and_buildings has 18 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 5734.
interest_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Interest_income_from_investments_in_land_and_buildings. Column interest_income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4264 and maximum value is 118220.
other_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Other_income_from_investments_in_land_and_buildings. Column other_income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 68715 and maximum value is 725435.
income_from_other_investments int Datasource did not contain a description for Income_from_other_investments. Column income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 325135 and maximum value is 10991636.
dividend_income_from_other_investments int Datasource did not contain a description for Dividend_income_from_other_investments. Column dividend_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82767 and maximum value is 1453951.
interest_income_from_other_investments int Datasource did not contain a description for Interest_income_from_other_investments. Column interest_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 117574 and maximum value is 1192159.
other_income_from_other_investments int Datasource did not contain a description for Other_income_from_other_investments. Column other_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 45672 and maximum value is 8759642.
returns_of_reductions_in_value int Datasource did not contain a description for Returns_of_reductions_in_value. Column returns_of_reductions_in_value has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 44596 and maximum value is 899679.
sales_profits int Datasource did not contain a description for Sales_profits. Column sales_profits has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 260481 and maximum value is 21708079.
investment_charges_total int Datasource did not contain a description for Investment_charges_total. Column investment_charges_total has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -26752356 and maximum value is -314587.
charges_arising_from_investments_in_land_and_buildings int Datasource did not contain a description for Charges_arising_from_investments_in_land_and_buildings. Column charges_arising_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -463428 and maximum value is -66828.
charges_arising_from_other_investments int Datasource did not contain a description for Charges_arising_from_other_investments. Column charges_arising_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -7638770 and maximum value is -44827.
interest_and_other_expenses_on_liabilities int Datasource did not contain a description for Interest_and_other_expenses_on_liabilities. Column interest_and_other_expenses_on_liabilities has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -436944 and maximum value is -10364.
reductions_in_value int Datasource did not contain a description for Reductions_in_value. Column reductions_in_value has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -2642155 and maximum value is -58526.
planned_depreciations_of_buildings int Datasource did not contain a description for Planned_depreciations_of_buildings. Column planned_depreciations_of_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -32994 and maximum value is -2532.
sales_losses int Datasource did not contain a description for Sales_losses. Column sales_losses has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -18802027 and maximum value is -61013.
value_changes_and_value_increases_of_investments_and_their_adjustments int Datasource did not contain a description for Value_changes_and_value_increases_of_investments_and_their_adjustments. Column value_changes_and_value_increases_of_investments_and_their_adjustments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -5948 and maximum value is 1691863.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin vato pxt 11g3 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2012 and maximum value is 2017.
reporting_institution int Datasource did not contain a description for Reporting_institution. Column reporting_institution has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 401 and maximum value is 420.
net_investment_income_in_the_profit_and_loss_account int Datasource did not contain a description for Net_investment_income_in_the_profit_and_loss_account. Column net_investment_income_in_the_profit_and_loss_account has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 439158 and maximum value is 8748586.
income_from_investment_activities_total int Datasource did not contain a description for Income_from_investment_activities_total. Column income_from_investment_activities_total has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 803449 and maximum value is 33420508.
income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Income_from_investments_in_affiliated_undertakings. Column income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4469 and maximum value is 50297.
dividend_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Dividend_income_from_investments_in_affiliated_undertakings. Column dividend_income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 349 and maximum value is 47487.
interest_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Interest_income_from_investments_in_affiliated_undertakings. Column interest_income_from_investments_in_affiliated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1303 and maximum value is 19643.
other_income_from_investments_in_affiliated_undertakings int Datasource did not contain a description for Other_income_from_investments_in_affiliated_undertakings. Column other_income_from_investments_in_affiliated_undertakings has 18 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 11578.
income_from_investments_in_associated_undertakings int Datasource did not contain a description for Income_from_investments_in_associated_undertakings. Column income_from_investments_in_associated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 147 and maximum value is 31112.
share_of_associated_undertakings_profitslosses int Datasource did not contain a description for Share_of_associated_undertakings_profitslosses. Column share_of_associated_undertakings_profitslosses has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
dividend_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Dividend_income_from_investments_in_associated_undertakings. Column dividend_income_from_investments_in_associated_undertakings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 88 and maximum value is 18855.
interest_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Interest_income_from_investments_in_associated_undertakings. Column interest_income_from_investments_in_associated_undertakings has 18 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 13154.
other_income_from_investments_in_associated_undertakings int Datasource did not contain a description for Other_income_from_investments_in_associated_undertakings. Column other_income_from_investments_in_associated_undertakings has 18 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 25881.
income_from_investments_in_land_and_buildings int Datasource did not contain a description for Income_from_investments_in_land_and_buildings. Column income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75807 and maximum value is 843654.
dividend_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Dividend_income_from_investments_in_land_and_buildings. Column dividend_income_from_investments_in_land_and_buildings has 18 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 5734.
interest_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Interest_income_from_investments_in_land_and_buildings. Column interest_income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4264 and maximum value is 118220.
other_income_from_investments_in_land_and_buildings int Datasource did not contain a description for Other_income_from_investments_in_land_and_buildings. Column other_income_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 68715 and maximum value is 725435.
income_from_other_investments int Datasource did not contain a description for Income_from_other_investments. Column income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 325135 and maximum value is 10991636.
dividend_income_from_other_investments int Datasource did not contain a description for Dividend_income_from_other_investments. Column dividend_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 82767 and maximum value is 1453951.
interest_income_from_other_investments int Datasource did not contain a description for Interest_income_from_other_investments. Column interest_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 117574 and maximum value is 1192159.
other_income_from_other_investments int Datasource did not contain a description for Other_income_from_other_investments. Column other_income_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 45672 and maximum value is 8759642.
returns_of_reductions_in_value int Datasource did not contain a description for Returns_of_reductions_in_value. Column returns_of_reductions_in_value has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 44596 and maximum value is 899679.
sales_profits int Datasource did not contain a description for Sales_profits. Column sales_profits has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 260481 and maximum value is 21708079.
investment_charges_total int Datasource did not contain a description for Investment_charges_total. Column investment_charges_total has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -26752356 and maximum value is -314587.
charges_arising_from_investments_in_land_and_buildings int Datasource did not contain a description for Charges_arising_from_investments_in_land_and_buildings. Column charges_arising_from_investments_in_land_and_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -463428 and maximum value is -66828.
charges_arising_from_other_investments int Datasource did not contain a description for Charges_arising_from_other_investments. Column charges_arising_from_other_investments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -7638770 and maximum value is -44827.
interest_and_other_expenses_on_liabilities int Datasource did not contain a description for Interest_and_other_expenses_on_liabilities. Column interest_and_other_expenses_on_liabilities has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -436944 and maximum value is -10364.
reductions_in_value int Datasource did not contain a description for Reductions_in_value. Column reductions_in_value has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -2642155 and maximum value is -58526.
planned_depreciations_of_buildings int Datasource did not contain a description for Planned_depreciations_of_buildings. Column planned_depreciations_of_buildings has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -32994 and maximum value is -2532.
sales_losses int Datasource did not contain a description for Sales_losses. Column sales_losses has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -18802027 and maximum value is -61013.
value_changes_and_value_increases_of_investments_and_their_adjustments int Datasource did not contain a description for Value_changes_and_value_increases_of_investments_and_their_adjustments. Column value_changes_and_value_increases_of_investments_and_their_adjustments has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -5948 and maximum value is 1691863.

Additional Info

Last Updated August 4, 2019
Created August 3, 2019