Predicting The Financial Health Of Insurance Firms by Kaggle | Finance and Economics

About this Dataset

Predicting The Financial Health Of Insurance Firms

The main source of income for insurance firms is premium payments made by insurance policyholders. When
one enters an insurance cover co contract with any insurance firm, they are required to make payments called
premiums to the insurance firm for the insurance cover being offered. They are two types of premiums, they
are:

Earned premiums - are premiums collected by an insurance company for the portion of a policy
that has expired. It is what the insured party has paid for a portion of time in which the insurance
policy was in effect, but has since expired.
Unearned premiums - this is the premium amount that corresponds to the time period remaining
on an insurance policy. In other words, it is the portion of the policy premium that has not yet been
“earned” by the insurance company because the policy still has some time before it expires.

File Types:

rev: Revenue Statements
p_l: Profit and loss
Life: Life Insurance
Gen: Gen_BS

Problem Statement

More and more banks are getting into the insurance business. One of the ways they are doing this is by offering premium payment services on behalf of policyholders. An individual may be interested in an insurance policy but they do not have the funds to meet the premium payments. They can enter into an agreement with a bank, where the bank pays the premiums on their behalf to the insurance firm, while the individual repays the premium the bank paid to the insurance firm. Given that banks pay the premiums on
an annual basis, if the individual defaults on the premium repayments before the cover expires, the bank can claim the unearned premiums from the insurance firms. However, if an insurance firm is going under, it will not be able to refund the unearned premiums to the bank and as such, the bank will have lost on two fronts that are:

The default on the premium repayments.
The loss of the unearned premiums.

Therefore, the aim of this dataset is to develop an algorithm that can be used to model and predict the financial health of any insurance firm.

Credit: Data source

Tables

General 2012 Bs

@kaggle.thedevastator_insurance_credit_scoring.general_2012_bs

34.04 KB
41 rows
37 columns


CREATE TABLE general_2012_bs (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" BIGINT,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" BIGINT,
  "paid_up_capital" BIGINT,
  "general_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" BIGINT,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" BIGINT,
  "underwriting_provisions" BIGINT,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_reserves_liabilities" BIGINT,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" BIGINT,
  "kenya_govt_securities" BIGINT,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" BIGINT,
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "reinsurers_share_of_technical_liabilities" VARCHAR,
  "cash" BIGINT,
  "other_current_assets" BIGINT,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE,
  "years" BIGINT
);

General 20–17 B L

@kaggle.thedevastator_insurance_credit_scoring.general_20_17_b_l

53.16 KB
180 rows
37 columns


CREATE TABLE general_20_17_b_l (
  "unnamed_0" VARCHAR,
  "share_capital" DOUBLE,
  "share_premium_x000d" DOUBLE,
  "revaluation_reserves" DOUBLE,
  "statutory_reserves" DOUBLE,
  "retained_earnings" DOUBLE,
  "other_reserves" DOUBLE,
  "total_equity_x000d" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "actuarial_contract_liabilities" DOUBLE,
  "longterm_liabilities" DOUBLE,
  "current_liabilities" DOUBLE,
  "total_equity_and_liabilities" VARCHAR,
  "land_and_buildings" DOUBLE,
  "investment_property" DOUBLE,
  "other_fixed_assets" DOUBLE,
  "government_securities" DOUBLE,
  "other_securities" DOUBLE,
  "investment_in_related_companies" DOUBLE,
  "corporate_bonds" DOUBLE,
  "commercial_papers" DOUBLE,
  "debentures" DOUBLE,
  "ordinary_shares_quoted" DOUBLE,
  "ordinary_shares_unquoted" DOUBLE,
  "preference_shares_quoted" DOUBLE,
  "preference_shares_unquoted" DOUBLE,
  "loans_secured_unsecured" DOUBLE,
  "mortgages" DOUBLE,
  "term_deposits" DOUBLE,
  "cash_and_cash_balances" DOUBLE,
  "outstanding_premiums" DOUBLE,
  "other_receivables" DOUBLE,
  "other_assets" DOUBLE,
  "intangible_assets" DOUBLE,
  "total_assets" DOUBLE,
  "amounts_in_thousand_shillings" VARCHAR,
  "years" BIGINT
);

General Bs 09–06

@kaggle.thedevastator_insurance_credit_scoring.general_bs_09_06

42.42 KB
138 rows
33 columns


CREATE TABLE general_bs_09_06 (
  "unnamed_0" VARCHAR,
  "nominal_capital" DOUBLE,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_capital" DOUBLE,
  "paid_up_capital" DOUBLE,
  "general_reserve" VARCHAR,
  "investment_flctn_reserve" VARCHAR,
  "unapprtd_surplus_net" DOUBLE,
  "other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_reserves_liabilities" DOUBLE,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" VARCHAR,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investments_in_subsidiary" DOUBLE,
  "ordinary_shares_quoted_unquoted" DOUBLE,
  "secured_loans_incl_loans_on_life_policies" DOUBLE,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE,
  "outstanding_premiums" DOUBLE,
  "amounts_due_from_other_insurers" VARCHAR,
  "cash" DOUBLE,
  "miscellaneous" DOUBLE,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE
);

General Bs 10

@kaggle.thedevastator_insurance_credit_scoring.general_bs_10

32.73 KB
48 rows
35 columns


CREATE TABLE general_bs_10 (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" VARCHAR,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" VARCHAR,
  "paid_up_capital" VARCHAR,
  "general_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" VARCHAR,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_re_serves_liabilities" VARCHAR,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR,
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "cash" VARCHAR,
  "other_current_assets" VARCHAR,
  "intangible_assets" VARCHAR,
  "total_assets" VARCHAR
);

General Bs 16–13

@kaggle.thedevastator_insurance_credit_scoring.general_bs_16_13

53.49 KB
161 rows
37 columns


CREATE TABLE general_bs_16_13 (
  "unnamed_0" VARCHAR,
  "share_capital" BIGINT,
  "share_premium" VARCHAR,
  "revaluation_reserves" VARCHAR,
  "statutory_reserves" VARCHAR,
  "retained_earnings" BIGINT,
  "other_reserves" VARCHAR,
  "total_equity" BIGINT,
  "underwriting_provisions" VARCHAR,
  "actuarial_contract_liabilities" VARCHAR,
  "longterm_liabilities" VARCHAR,
  "current_liabilities" BIGINT,
  "total_equity_and_liabilities" BIGINT,
  "land_and_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "government_securities" BIGINT,
  "other_securities" VARCHAR,
  "investment_in_related_companies" VARCHAR,
  "corporate_bonds" VARCHAR,
  "commercial_papers" VARCHAR,
  "debentures" VARCHAR,
  "ordinary_shares_quoted" VARCHAR,
  "ordinary_shares_unquoted" VARCHAR,
  "preference_shares_quoted" VARCHAR,
  "preference_shares_unquoted" VARCHAR,
  "loans_secured_unsecured" VARCHAR,
  "mortgages" VARCHAR,
  "term_deposits" VARCHAR,
  "cash_and_cash_balances" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "other_receivables" VARCHAR,
  "other_assets" VARCHAR,
  "intangible_assets" VARCHAR,
  "total_assets" BIGINT,
  "amounts_in_thousand_shillings_continued_next_page" VARCHAR,
  "years" BIGINT
);

Gen Bs 2011–1

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_1

30.32 KB
23 rows
37 columns


CREATE TABLE gen_bs_2011_1 (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" DOUBLE,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" DOUBLE,
  "paid_up_capital" DOUBLE,
  "general_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR,
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "cash" DOUBLE,
  "other_current_assets" DOUBLE,
  "intangible_assets" VARCHAR,
  "total_assets" VARCHAR,
  "amounts_in_000_kes" VARCHAR,
  "years" BIGINT
);

Gen Bs 2011–2

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_2

32.15 KB
12 rows
42 columns


CREATE TABLE gen_bs_2011_2 (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" DOUBLE,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" DOUBLE,
  "paid_up_capital" DOUBLE,
  "general_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" DOUBLE,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" DOUBLE,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE,
  "other_investments" VARCHAR,
  "outstanding_premiums" DOUBLE,
  "amounts_due_from_re_insurers" VARCHAR,
  "cash" DOUBLE,
  "other_current_assets" DOUBLE,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE,
  "amounts_in_000_kes" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" DOUBLE,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" DOUBLE,
  "years" BIGINT
);

Gen Bs 2011–3

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_3

30.29 KB
13 rows
39 columns


CREATE TABLE gen_bs_2011_3 (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" DOUBLE,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" DOUBLE,
  "paid_up_capital" DOUBLE,
  "general_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" DOUBLE,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR,
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "cash" VARCHAR,
  "other_current_assets" DOUBLE,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE,
  "amounts_in_000_kes" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" DOUBLE,
  "years" BIGINT
);

Gen Rev 12–11

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_12_11

20.04 KB
75 rows
19 columns


CREATE TABLE gen_rev_12_11 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR,
  "fund_at_the_beginning_of_the_year" VARCHAR,
  "net_premium" VARCHAR,
  "net_investment_income" VARCHAR,
  "investment_expense" VARCHAR,
  "claims_by_death" VARCHAR,
  "claims_by_maturity" VARCHAR,
  "other_claims" VARCHAR,
  "surrenders" VARCHAR,
  "bonuses_paid_in_cash" VARCHAR,
  "annuities_paid" VARCHAR,
  "commissions" VARCHAR,
  "expense_of_management" VARCHAR,
  "other_expenses" VARCHAR,
  "transfer_to_p_l_account" VARCHAR,
  "fund_at_the_end_of_the_year" VARCHAR,
  "years" BIGINT,
  "unnamed_0" VARCHAR
);

Gen Rev 16–13

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_16_13

33.14 KB
178 rows
17 columns


CREATE TABLE gen_rev_16_13 (
  "company" VARCHAR,
  "gross_direct_premium" VARCHAR,
  "inward_reinsurance" VARCHAR,
  "outward_reinsurance" VARCHAR,
  "net_premium_written" VARCHAR,
  "upr_b_f" VARCHAR,
  "unexpired_risk_reserve_b_f" VARCHAR,
  "upr_c_f" VARCHAR,
  "unexpired_risk_reserve_b_f_1" VARCHAR,
  "net_earned_premium_income" VARCHAR,
  "incurred_claims" VARCHAR,
  "net_commisions" VARCHAR,
  "expense_of_management" VARCHAR,
  "underwriting_profit_loss" VARCHAR,
  "investment_income" VARCHAR,
  "profit_transferred_to_p_l" VARCHAR,
  "years" BIGINT
);

Gen Rev 20–17

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_20_17

30.33 KB
187 rows
18 columns


CREATE TABLE gen_rev_20_17 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "gross_direct_premium" DOUBLE,
  "inward_reinsurance_x000d" DOUBLE,
  "outward_reinsurance" DOUBLE,
  "net_premium_written" DOUBLE,
  "upr_b_f" DOUBLE,
  "n__unexpired_risk_reserve_b_f" DOUBLE,
  "upr_c_f_x000d" DOUBLE,
  "n__unexpired_risk_reserve_b_f_1" DOUBLE,
  "net_earned_premium_income" DOUBLE,
  "incurred_claims" DOUBLE,
  "net_commisions" DOUBLE,
  "expense_of_management" DOUBLE,
  "underwriting_profit_loss" DOUBLE,
  "investment_income" DOUBLE,
  "profit_transferred_to_p_l" DOUBLE,
  "years" BIGINT
);

Life 16–13

@kaggle.thedevastator_insurance_credit_scoring.life_16_13

52.08 KB
116 rows
42 columns


CREATE TABLE life_16_13 (
  "unnamed_0" VARCHAR,
  "share_capital" VARCHAR,
  "share_premium" VARCHAR,
  "revaluation_reserves" VARCHAR,
  "statutory_reserves" VARCHAR,
  "retained_earnings" VARCHAR,
  "other_reserves" VARCHAR,
  "total_equity" VARCHAR,
  "underwriting_provisions" VARCHAR,
  "actuarial_contract_liabilities" VARCHAR,
  "longterm_liabilities" VARCHAR,
  "current_liabilities" VARCHAR,
  "total_equity_and_liabilities" VARCHAR,
  "land_and_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "government_securities" VARCHAR,
  "other_securities" VARCHAR,
  "investment_in_related_companies" VARCHAR,
  "corporate_bonds" VARCHAR,
  "commercial_papers" VARCHAR,
  "debentures" VARCHAR,
  "ordinary_shares_quoted" VARCHAR,
  "ordinary_shares_unquoted" VARCHAR,
  "preference_shares_quoted" VARCHAR,
  "preference_shares_unquoted" VARCHAR,
  "loans_secured_unsecured" VARCHAR,
  "mortgages" VARCHAR,
  "term_deposits" VARCHAR,
  "cash_and_cash_balances" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "other_receivables" VARCHAR,
  "other_assets" VARCHAR,
  "intangible_assets" VARCHAR,
  "total_assets" VARCHAR,
  "amounts_in_thousand_shillings_continued_next_page" VARCHAR,
  "years" BIGINT,
  "amounts_in_thousand_shillings_continued_next_page_fcc05b" VARCHAR,
  "amounts_in_thousand_shillings" VARCHAR,
  "amounts_in_thousand_shillings_continued_next_page_4e6a16" VARCHAR,
  "amounts_in_thousand_shillings_continued_next_page_ec8729" VARCHAR,
  "amounts_in_thousand_shillings_955b0a" VARCHAR
);

Life Bs 09–06

@kaggle.thedevastator_insurance_credit_scoring.life_bs_09_06

36.12 KB
96 rows
33 columns


CREATE TABLE life_bs_09_06 (
  "unnamed_0" VARCHAR,
  "nominal_capital" VARCHAR,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "isssued_capital" VARCHAR,
  "paid_up_capital" VARCHAR,
  "general_reserve" VARCHAR,
  "investment_flctn_reserve" VARCHAR,
  "unapprtd_surplus_net" VARCHAR,
  "other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_reserves_liabilities" DOUBLE,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" VARCHAR,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "ordinary_shares_quoted_unquoted" DOUBLE,
  "secured_loans_incl_loans_on_life_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_other_insurers" VARCHAR,
  "cash" DOUBLE,
  "miscellaneous" DOUBLE,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE
);

Life Bs 12–10

@kaggle.thedevastator_insurance_credit_scoring.life_bs_12_10

46.09 KB
81 rows
45 columns


CREATE TABLE life_bs_12_10 (
  "unnamed_0" VARCHAR,
  "nominal_share_capital" VARCHAR,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_share_capital" VARCHAR,
  "paid_up_capital" VARCHAR,
  "statutory_reserve" VARCHAR,
  "investment_fluctuation_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings_net" VARCHAR,
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" VARCHAR,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_reserves_liabilities" VARCHAR,
  "land_buildings" VARCHAR,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR,
  "local_govt_authority_securities" VARCHAR,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "secured_loans_incl_loans_on_life_policies" VARCHAR,
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR,
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "reinsurers_share_of_technical_liabilities" VARCHAR,
  "cash" VARCHAR,
  "other_current_assets" VARCHAR,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE,
  "unnamed_36" VARCHAR,
  "years" BIGINT,
  "general_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "debentures_quoted_unquoted_95c85d" VARCHAR,
  "preference_shares_quoted_unquoted_d97aaf" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR,
  "amounts_in_000_kes" VARCHAR,
  "figures_in_thousands_kshs" VARCHAR
);

Life Bs 20–17

@kaggle.thedevastator_insurance_credit_scoring.life_bs_20_17

47.34 KB
120 rows
39 columns


CREATE TABLE life_bs_20_17 (
  "unnamed_0" VARCHAR,
  "share_capital" DOUBLE,
  "share_premium_x000d" DOUBLE,
  "revaluation_reserves" DOUBLE,
  "statutory_reserves" DOUBLE,
  "retained_earnings" DOUBLE,
  "other_reserves" DOUBLE,
  "total_equity_x000d" DOUBLE,
  "underwriting_provisions" DOUBLE,
  "actuarial_contract_liabilities" DOUBLE,
  "longterm_liabilities" DOUBLE,
  "current_liabilities" DOUBLE,
  "total_equity_and_liabilities" DOUBLE,
  "land_and_buildings" DOUBLE,
  "investment_property" DOUBLE,
  "other_fixed_assets" DOUBLE,
  "government_securities" DOUBLE,
  "other_securities" DOUBLE,
  "investment_in_related_companies" DOUBLE,
  "corporate_bonds" DOUBLE,
  "commercial_papers" DOUBLE,
  "debentures" DOUBLE,
  "ordinary_shares_quoted" DOUBLE,
  "ordinary_shares_unquoted" DOUBLE,
  "preference_shares_quoted" DOUBLE,
  "preference_shares_unquoted" DOUBLE,
  "loans_secured_unsecured" DOUBLE,
  "mortgages" DOUBLE,
  "term_deposits" DOUBLE,
  "cash_and_cash_balances" DOUBLE,
  "outstanding_premiums" DOUBLE,
  "other_receivables" DOUBLE,
  "other_assets" DOUBLE,
  "intangible_assets" DOUBLE,
  "total_assets" DOUBLE,
  "amounts_in_thousand_shillings" VARCHAR,
  "year" BIGINT,
  "amounts_in_thousand_shillings_955b0a" VARCHAR,
  "amounts_in_thousand_shillings_abfe8d" VARCHAR
);

Life Rev 12–10

@kaggle.thedevastator_insurance_credit_scoring.life_rev_12_10

22.17 KB
104 rows
20 columns


CREATE TABLE life_rev_12_10 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR,
  "fund_at_the_beginning_of_the_year" VARCHAR,
  "net_premium" VARCHAR,
  "gross_investment_income" VARCHAR,
  "investment_expense" VARCHAR,
  "net_investment_income" VARCHAR,
  "claims_by_death" VARCHAR,
  "claims_by_maturity" VARCHAR,
  "other_claims" VARCHAR,
  "surrenders" VARCHAR,
  "bonuses_paid_in_cash" VARCHAR,
  "annuities_paid" VARCHAR,
  "commissions" VARCHAR,
  "expense_of_management" VARCHAR,
  "other_expenses" VARCHAR,
  "transfer_to_p_l_account" VARCHAR,
  "fund_at_the_end_of_the_year" VARCHAR,
  "years" BIGINT,
  "unnamed_1" VARCHAR
);

Life Rev 16–13

@kaggle.thedevastator_insurance_credit_scoring.life_rev_16_13

24.22 KB
133 rows
17 columns


CREATE TABLE life_rev_16_13 (
  "company" VARCHAR,
  "life_fund_bf" VARCHAR,
  "gross_premium" VARCHAR,
  "net_premium" VARCHAR,
  "other_fee_income" VARCHAR,
  "total_benefits" DOUBLE,
  "claims" VARCHAR,
  "surrenders" VARCHAR,
  "bonuses_paid" VARCHAR,
  "annuities_paid" VARCHAR,
  "net_commisions" VARCHAR,
  "expense_of_management" VARCHAR,
  "investment_income" VARCHAR,
  "investment_expenses" VARCHAR,
  "transfer_to_from_p_l" VARCHAR,
  "life_fund_cf" VARCHAR,
  "years" BIGINT
);

Life Rev 20–17

@kaggle.thedevastator_insurance_credit_scoring.life_rev_20_17

23.41 KB
133 rows
18 columns


CREATE TABLE life_rev_20_17 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "life_fund_bf" DOUBLE,
  "gross_premium" DOUBLE,
  "net_premium" DOUBLE,
  "other_fee_income" DOUBLE,
  "total_benefits" DOUBLE,
  "claims" DOUBLE,
  "surrenders_x000d" DOUBLE,
  "bonuses_paid" DOUBLE,
  "annuities_paid" DOUBLE,
  "net_commisions" DOUBLE,
  "expense_of_management" DOUBLE,
  "investment_income" DOUBLE,
  "investment_expenses" DOUBLE,
  "transfer_to_from_p_l" DOUBLE,
  "life_fund_cf" DOUBLE,
  "years" BIGINT
);

P L 12–10 Life

@kaggle.thedevastator_insurance_credit_scoring.p_l_12_10_life

25.17 KB
151 rows
18 columns


CREATE TABLE p_l_12_10_life (
  "company" VARCHAR,
  "no" VARCHAR,
  "profit_loss_from_revenue" VARCHAR,
  "investment_income" VARCHAR,
  "other_incomes" VARCHAR,
  "management_expenses" VARCHAR,
  "other_expenses" VARCHAR,
  "profit_loss_before_taxation" VARCHAR,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR,
  "unapprtd_profit_loss_b_f" VARCHAR,
  "transfer_to_reserve" VARCHAR,
  "dividend" VARCHAR,
  "other_appropriations" VARCHAR,
  "unapprrtd_profit_loss_c_f" VARCHAR,
  "years" BIGINT,
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR
);

P L B2 Life 2016–2013

@kaggle.thedevastator_insurance_credit_scoring.p_l_b2_life_2016_2013

30.72 KB
133 rows
27 columns


CREATE TABLE p_l_b2_life_2016_2013 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "profit_transferred_from_revenue" VARCHAR,
  "investment_income" VARCHAR,
  "other_income" VARCHAR,
  "total_income" VARCHAR,
  "loss_transferred_from_revenue" VARCHAR,
  "management_expenses" VARCHAR,
  "total_outgo" VARCHAR,
  "profit_loss_before_taxation" VARCHAR,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR,
  "unappropriated_profit_loss_bf" VARCHAR,
  "transfer_to_reserves" VARCHAR,
  "other_appropriations" VARCHAR,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" VARCHAR,
  "years" BIGINT,
  "profit_transferred_from_revenue_6628fd" VARCHAR,
  "loss_transferred_from_revenue_b720fb" VARCHAR,
  "profit_loss_before_taxation_3fccad" VARCHAR,
  "provision_for_taxation_7d9c9b" VARCHAR,
  "profit_loss_after_taxation_6ba389" VARCHAR,
  "unappropri_ated_profit_loss_bf" VARCHAR,
  "transfer_to_reserves_42ba48" VARCHAR,
  "other_appropria_tions" VARCHAR,
  "unappropriated_profit_loss_cf_fc5f67" VARCHAR
);

P L Gen 09–06

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_09_06

17.71 KB
134 rows
17 columns


CREATE TABLE p_l_gen_09_06 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "profit_transferred_from_revenue" VARCHAR,
  "investment_income" VARCHAR,
  "other_income" VARCHAR,
  "total_income" DOUBLE,
  "loss_transferred_from_revenue" VARCHAR,
  "management_expenses" VARCHAR,
  "total_outgo" VARCHAR,
  "profit_loss_before_taxation" DOUBLE,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" DOUBLE,
  "unappropri_ated_profit_loss_bf" VARCHAR,
  "transfer_to_reserves" VARCHAR,
  "other_appropria_tions" VARCHAR,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" DOUBLE
);

P L Gen 16–13

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_16_13

31.08 KB
181 rows
18 columns


CREATE TABLE p_l_gen_16_13 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "profit_transferred_from_revenue" VARCHAR,
  "investment_income" VARCHAR,
  "other_income" VARCHAR,
  "total_income" VARCHAR,
  "loss_transferred_from_revenue" VARCHAR,
  "management_expenses" VARCHAR,
  "total_outgo" VARCHAR,
  "profit_loss_before_taxation" VARCHAR,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR,
  "unappropriated_profit_loss_bf" VARCHAR,
  "transfer_to_reserves" VARCHAR,
  "other_appropriations" VARCHAR,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" VARCHAR,
  "years" BIGINT
);

P L Gen 20–17

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_20_17

27.82 KB
191 rows
18 columns


CREATE TABLE p_l_gen_20_17 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "profit_transferred_from_revenue" DOUBLE,
  "investment_income" DOUBLE,
  "other_income" DOUBLE,
  "total_income" DOUBLE,
  "loss_transferred_from_revenue" DOUBLE,
  "management_expenses" DOUBLE,
  "total_outgo" DOUBLE,
  "profit_loss_before_taxation" DOUBLE,
  "provision_for_taxation" DOUBLE,
  "profit_loss_after_taxation" DOUBLE,
  "unappropriated_profit_loss_bf" DOUBLE,
  "transfer_to_reserves" DOUBLE,
  "other_appropriations" DOUBLE,
  "dividend" DOUBLE,
  "unappropriated_profit_loss_cf" DOUBLE,
  "years" BIGINT
);

P L Life 2006–2009

@kaggle.thedevastator_insurance_credit_scoring.p_l_life_2006_2009

17.3 KB
144 rows
16 columns


CREATE TABLE p_l_life_2006_2009 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR,
  "profit_loss_transferred_from_revenue" DOUBLE,
  "investment_income" DOUBLE,
  "share_in_motor_pool" DOUBLE,
  "other_incomes" DOUBLE,
  "management_expenses" DOUBLE,
  "other_expenses" DOUBLE,
  "provision_for_taxation" DOUBLE,
  "profit_or_loss_after_taxition" DOUBLE,
  "unapprtd_profit_loss_b_f" DOUBLE,
  "total_profit_available_for_distribution" DOUBLE,
  "transfers_to_reserves" DOUBLE,
  "dividends" DOUBLE,
  "other_apprtns" DOUBLE,
  "unapprtd_profit_loss_c_f" DOUBLE
);

P L Life 20–17

@kaggle.thedevastator_insurance_credit_scoring.p_l_life_20_17

22.19 KB
137 rows
18 columns


CREATE TABLE p_l_life_20_17 (
  "unnamed_0" BIGINT,
  "company" VARCHAR,
  "profit_transferred_from_revenue" DOUBLE,
  "investment_income" DOUBLE,
  "other_income" DOUBLE,
  "total_income" DOUBLE,
  "loss_transferred_from_revenue" DOUBLE,
  "management_expenses" DOUBLE,
  "total_outgo" DOUBLE,
  "profit_loss_before_taxation" DOUBLE,
  "provision_for_taxation" DOUBLE,
  "profit_loss_after_taxation" DOUBLE,
  "unappropriated_profit_loss_bf" DOUBLE,
  "transfer_to_reserves" DOUBLE,
  "other_appropriations" DOUBLE,
  "dividend" DOUBLE,
  "unappropriated_profit_loss_cf" DOUBLE,
  "years" BIGINT
);