About this Dataset

Asset Allocation Of Insurance Companies

This dataset shows the direct investments of insurers in a detailed list of financial instruments and their indirect investments through collective investment schemes. Users can find the asset allocation broken down by ownership of insurance companies (domestic undertakings, foreign controlled undertakings and branches and agencies), insurance type (life, non-life, composite), insurer type (direct insurer, reinsurer) and destination of investments (domestic or foreign).

Tables

Observations

@oecd.oecd_daf_cm_dsd_ins_df_asset_alloc_v1_0.observations

5.6 MB
3,013,084 rows
23 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "premiums" VARCHAR,
  "ownership" VARCHAR,
  "insurance_type" VARCHAR,
  "insurance_business" VARCHAR,
  "insurer_type" VARCHAR,
  "contract_type" VARCHAR,
  "employer_type" VARCHAR,
  "risk_location" VARCHAR,
  "counterpart_area" VARCHAR,
  "insurance_class" VARCHAR,
  "destination" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "unit_mult" BIGINT,
  "currency" VARCHAR,
  "decimals" BIGINT
);