Name: Predicting The Financial Health Of Insurance Firms
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

Gen Bs 2011–1

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_1

31.05 kB
23 rows
37 columns

CREATE TABLE gen_bs_2011_1 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- TOTAL PAID-UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE  -- TOTAL PAID-UP CAPITAL, RES ERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES (QUOTED \u0026 UNQUOTED),
  "preference_shares_quoted_unquoted" VARCHAR  -- PREFERENCE SHARES (QUOTED \u0026 UNQUOTED),
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR  -- SECURED LOANS (INCLUDING LOAN OF POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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  -- AMOUNTS IN \u0027000\u0027 KES,
  "years" BIGINT
);

Gen Bs 2011–2

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_2

32.92 kB
12 rows
42 columns

CREATE TABLE gen_bs_2011_2 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- TOTAL PAID-UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE  -- TOTAL PAID-UP CAPITAL, RES ERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" DOUBLE  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES (QUOTED \u0026 UNQUOTED),
  "preference_shares_quoted_unquoted" VARCHAR  -- PREFERENCE SHARES (QUOTED \u0026 UNQUOTED),
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" DOUBLE,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR  -- SECURED LOANS (INCLUDING LOAN OF POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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  -- AMOUNTS IN \u0027000\u0027 KES,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" DOUBLE  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" DOUBLE  -- Unnamed: 40,
  "years" BIGINT
);

Gen Bs 2011–3

@kaggle.thedevastator_insurance_credit_scoring.gen_bs_2011_3

31.01 kB
13 rows
39 columns

CREATE TABLE gen_bs_2011_3 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- TOTAL PAID-UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_res_erves_liabilities" DOUBLE  -- TOTAL PAID-UP CAPITAL, RES ERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" DOUBLE  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES (QUOTED \u0026 UNQUOTED),
  "preference_shares_quoted_unquoted" VARCHAR  -- PREFERENCE SHARES (QUOTED \u0026 UNQUOTED),
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR  -- SECURED LOANS (INCLUDING LOAN OF POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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  -- AMOUNTS IN \u0027000\u0027 KES,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" DOUBLE  -- Unnamed: 37,
  "years" BIGINT
);

General 2012 Bs

@kaggle.thedevastator_insurance_credit_scoring.general_2012_bs

34.86 kB
41 rows
37 columns

CREATE TABLE general_2012_bs (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- TOTAL PAID-UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" BIGINT,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_reserves_liabilities" BIGINT  -- TOTAL PAID-UP CAPITAL, RESERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" BIGINT,
  "kenya_govt_securities" BIGINT  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES QUOTED \u0026 UNQUOTED,
  "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  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "reinsurers_share_of_technical_liabilities" VARCHAR  -- REINSURERS\u0027 SHARE OF TECHNICAL LIABILITIES,
  "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

54.43 kB
180 rows
37 columns

CREATE TABLE general_20_17_b_l (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- Loans Secured \u0026 Unsecured,
  "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

43.44 kB
138 rows
33 columns

CREATE TABLE general_bs_09_06 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "nominal_capital" DOUBLE,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "issued_capital" DOUBLE,
  "paid_up_capital" DOUBLE,
  "general_reserve" VARCHAR,
  "investment_flctn_reserve" VARCHAR  -- INVESTMENT FLCTN. RESERVE,
  "unapprtd_surplus_net" DOUBLE  -- UNAPPRTD SURPLUS (NET),
  "other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE  -- TOTAL PAID UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_reserves_liabilities" DOUBLE  -- TOTAL PAID-UP CAPITAL, RESERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" VARCHAR  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES QUOTED \u0026 UNQUOTED,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investments_in_subsidiary" DOUBLE,
  "ordinary_shares_quoted_unquoted" DOUBLE,
  "secured_loans_incl_loans_on_life_policies" DOUBLE  -- SECURED LOANS (INCL.LOANS ON LIFE POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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

33.51 kB
48 rows
35 columns

CREATE TABLE general_bs_10 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- TOTAL PAID-UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_re_serves_liabilities" VARCHAR  -- TOTAL PAID-UP CAPITAL, RE- SERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES (QUOTED \u0026 UNQUOTED),
  "preference_shares_quoted_unquoted" VARCHAR  -- PREFERENCE SHARES (QUOTED \u0026 UNQUOTED),
  "investment_in_subsidiary" VARCHAR,
  "quoted_ordinary_shares" VARCHAR,
  "unquoted_ordinary_shares" VARCHAR,
  "secured_loans_including_loan_of_policies" VARCHAR  -- SECURED LOANS (INCLUDING LOAN OF POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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

54.78 kB
161 rows
37 columns

CREATE TABLE general_bs_16_13 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- LOANS SECURED \u0026 UNSECURED,
  "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 Rev 12–11

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_12_11

20.52 kB
75 rows
19 columns

CREATE TABLE gen_rev_12_11 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR  -- NO.,
  "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  -- TRANSFER TO P\u0026L ACCOUNT,
  "fund_at_the_end_of_the_year" VARCHAR,
  "years" BIGINT,
  "unnamed_0" VARCHAR  -- UNNAMED: 0
);

Gen Rev 16–13

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_16_13

33.93 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  -- UNEXPIRED RISK RESERVE (B/F),
  "upr_c_f" VARCHAR,
  "unexpired_risk_reserve_b_f_1" VARCHAR  -- UNEXPIRED RISK RESERVE (B/F).1,
  "net_earned_premium_income" VARCHAR,
  "incurred_claims" VARCHAR,
  "net_commisions" VARCHAR,
  "expense_of_management" VARCHAR,
  "underwriting_profit_loss" VARCHAR  -- UNDERWRITING PROFIT /(LOSS),
  "investment_income" VARCHAR,
  "profit_transferred_to_p_l" VARCHAR  -- PROFIT TRANSFERRED TO P\u0026L,
  "years" BIGINT
);

Gen Rev 20–17

@kaggle.thedevastator_insurance_credit_scoring.gen_rev_20_17

31.06 kB
187 rows
18 columns

CREATE TABLE gen_rev_20_17 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- Unexpired Risk Reserve (B/F),
  "upr_c_f_x000d" DOUBLE,
  "n__unexpired_risk_reserve_b_f_1" DOUBLE  -- Unexpired Risk Reserve (B/F) .1,
  "net_earned_premium_income" DOUBLE,
  "incurred_claims" DOUBLE,
  "net_commisions" DOUBLE,
  "expense_of_management" DOUBLE,
  "underwriting_profit_loss" DOUBLE  -- Underwriting Profit /(Loss),
  "investment_income" DOUBLE,
  "profit_transferred_to_p_l" DOUBLE  -- Profit Transferred To P\u0026L,
  "years" BIGINT
);

Life 16–13

@kaggle.thedevastator_insurance_credit_scoring.life_16_13

53.33 kB
116 rows
42 columns

CREATE TABLE life_16_13 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- Loans Secured \u0026 Unsecured,
  "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 Continued Next Page,
  "amounts_in_thousand_shillings" VARCHAR,
  "amounts_in_thousand_shillings_continued_next_page_4e6a16" VARCHAR  -- Amounts In Thousand Shillings Continued Next Page,
  "amounts_in_thousand_shillings_continued_next_page_ec8729" VARCHAR  -- Amounts In Thousand Shillings Continued Next Page,
  "amounts_in_thousand_shillings_955b0a" VARCHAR  -- Amounts In Thousand Shillings
);

Life Bs 09–06

@kaggle.thedevastator_insurance_credit_scoring.life_bs_09_06

36.99 kB
96 rows
33 columns

CREATE TABLE life_bs_09_06 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "nominal_capital" VARCHAR,
  "nominal_value_of_unissued_share_capital" VARCHAR,
  "isssued_capital" VARCHAR,
  "paid_up_capital" VARCHAR,
  "general_reserve" VARCHAR,
  "investment_flctn_reserve" VARCHAR  -- INVESTMENT FLCTN. RESERVE,
  "unapprtd_surplus_net" VARCHAR  -- UNAPPRTD SURPLUS (NET),
  "other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" DOUBLE  -- TOTAL PAID UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" DOUBLE,
  "long_term_liabilities" VARCHAR,
  "current_liablities" DOUBLE,
  "total_paid_up_capital_reserves_liabilities" DOUBLE  -- TOTAL PAID-UP CAPITAL, RESERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" DOUBLE,
  "kenya_govt_securities" VARCHAR  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES QUOTED \u0026 UNQUOTED,
  "preference_shares_quoted_unquoted" VARCHAR,
  "investment_in_subsidiary" VARCHAR,
  "ordinary_shares_quoted_unquoted" DOUBLE,
  "secured_loans_incl_loans_on_life_policies" VARCHAR  -- SECURED LOANS (INCL.LOANS ON LIFE POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" DOUBLE  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "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

47.2 kB
81 rows
45 columns

CREATE TABLE life_bs_12_10 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- UNAPPRTD SURPLUS/RETAINED EARNINGS (NET),
  "all_other_reserves" VARCHAR,
  "total_paid_up_capital_reserves" VARCHAR  -- TOTAL PAID UP CAPITAL \u0026 RESERVES,
  "underwriting_provisions" VARCHAR,
  "long_term_liabilities" VARCHAR,
  "current_liablities" VARCHAR,
  "total_paid_up_capital_reserves_liabilities" VARCHAR  -- TOTAL PAID UP CAPITAL, RESERVES \u0026 LIABILITIES,
  "land_buildings" VARCHAR  -- LAND \u0026 BUILDINGS,
  "investment_property" VARCHAR,
  "other_fixed_assets" VARCHAR,
  "kenya_govt_securities" VARCHAR  -- KENYA GOVT. SECURITIES,
  "local_govt_authority_securities" VARCHAR  -- LOCAL GOVT. AUTHORITY SECURITIES,
  "other_securities" VARCHAR,
  "debentures_quoted_unquoted" VARCHAR  -- DEBENTURES QUOTED \u0026 UNQUOTED,
  "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  -- SECURED LOANS (INCL.LOANS ON LIFE POLICIES),
  "unsecured_loans" VARCHAR,
  "deposits_with_banks_other_institutions" VARCHAR  -- DEPOSITS (WITH BANKS \u0026 OTHER INSTITUTIONS),
  "other_investments" VARCHAR,
  "outstanding_premiums" VARCHAR,
  "amounts_due_from_re_insurers" VARCHAR,
  "reinsurers_share_of_technical_liabilities" VARCHAR  -- REINSURERS\u0027 SHARE OF TECHNICAL LIABILITIES,
  "cash" VARCHAR,
  "other_current_assets" VARCHAR,
  "intangible_assets" VARCHAR,
  "total_assets" DOUBLE,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "years" BIGINT,
  "general_reserve" VARCHAR,
  "unapprtd_surplus_retained_earnings" VARCHAR,
  "debentures_quoted_unquoted_95c85d" VARCHAR  -- DEBENTURES (QUOTED \u0026 UNQUOTED),
  "preference_shares_quoted_unquoted_d97aaf" VARCHAR  -- PREFERENCE SHARES (QUOTED \u0026 UNQUOTED),
  "secured_loans_including_loan_of_policies" VARCHAR  -- SECURED LOANS (INCLUDING LOAN OF POLICIES),
  "amounts_in_000_kes" VARCHAR  -- AMOUNTS IN \u0027000\u0027 KES,
  "figures_in_thousands_kshs" VARCHAR  -- FIGURES IN THOUSANDS KSHS.
);

Life Bs 20–17

@kaggle.thedevastator_insurance_credit_scoring.life_bs_20_17

48.48 kB
120 rows
39 columns

CREATE TABLE life_bs_20_17 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "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  -- Loans Secured \u0026 Unsecured,
  "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,
  "amounts_in_thousand_shillings_abfe8d" VARCHAR  -- Amounts In Thousand Shillings
);

Life Rev 12–10

@kaggle.thedevastator_insurance_credit_scoring.life_rev_12_10

22.7 kB
104 rows
20 columns

CREATE TABLE life_rev_12_10 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR  -- NO.,
  "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  -- TRANSFER TO P\u0026L ACCOUNT,
  "fund_at_the_end_of_the_year" VARCHAR,
  "years" BIGINT,
  "unnamed_1" VARCHAR  -- UNNAMED: 1
);

Life Rev 16–13

@kaggle.thedevastator_insurance_credit_scoring.life_rev_16_13

24.81 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  -- OTHER (FEE) INCOME,
  "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  -- TRANSFER TO (FROM) P \u0026 L,
  "life_fund_cf" VARCHAR,
  "years" BIGINT
);

Life Rev 20–17

@kaggle.thedevastator_insurance_credit_scoring.life_rev_20_17

23.97 kB
133 rows
18 columns

CREATE TABLE life_rev_20_17 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "company" VARCHAR,
  "life_fund_bf" DOUBLE,
  "gross_premium" DOUBLE,
  "net_premium" DOUBLE,
  "other_fee_income" DOUBLE  -- Other (Fee) Income,
  "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  -- Transfer To (From) P \u0026 L,
  "life_fund_cf" DOUBLE,
  "years" BIGINT
);

P L 12–10 Life

@kaggle.thedevastator_insurance_credit_scoring.p_l_12_10_life

25.77 kB
151 rows
18 columns

CREATE TABLE p_l_12_10_life (
  "company" VARCHAR,
  "no" VARCHAR  -- NO.,
  "profit_loss_from_revenue" VARCHAR  -- PROFIT/(LOSS) FROM REVENUE,
  "investment_income" VARCHAR,
  "other_incomes" VARCHAR,
  "management_expenses" VARCHAR,
  "other_expenses" VARCHAR,
  "profit_loss_before_taxation" VARCHAR  -- PROFIT/(LOSS) BEFORE TAXATION,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR  -- PROFIT/(LOSS) AFTER TAXATION,
  "unapprtd_profit_loss_b_f" VARCHAR  -- UNAPPRTD PROFIT/(LOSS) B/F,
  "transfer_to_reserve" VARCHAR,
  "dividend" VARCHAR,
  "other_appropriations" VARCHAR,
  "unapprrtd_profit_loss_c_f" VARCHAR  -- UNAPPRRTD PROFIT/(LOSS) C/F,
  "years" BIGINT,
  "unnamed_0" VARCHAR  -- UNNAMED: 0,
  "unnamed_1" VARCHAR  -- UNNAMED: 1
);

P L B2 Life 2016–2013

@kaggle.thedevastator_insurance_credit_scoring.p_l_b2_life_2016_2013

31.46 kB
133 rows
27 columns

CREATE TABLE p_l_b2_life_2016_2013 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- PROFIT / (LOSS) BEFORE TAXATION,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR  -- PROFIT/(LOSS) AFTER TAXATION,
  "unappropriated_profit_loss_bf" VARCHAR  -- UNAPPROPRIATED PROFIT/(LOSS) BF,
  "transfer_to_reserves" VARCHAR,
  "other_appropriations" VARCHAR,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" VARCHAR  -- UNAPPROPRIATED PROFIT /(LOSS) CF,
  "years" BIGINT,
  "profit_transferred_from_revenue_6628fd" VARCHAR  -- PROFIT TRANSFERRED FROM REVENUE,
  "loss_transferred_from_revenue_b720fb" VARCHAR  -- LOSS TRANSFERRED FROM REVENUE,
  "profit_loss_before_taxation_3fccad" VARCHAR  -- PROFIT / (LOSS) BEFORE TAXATION,
  "provision_for_taxation_7d9c9b" VARCHAR  -- PROVISION FOR TAXATION,
  "profit_loss_after_taxation_6ba389" VARCHAR  -- PROFIT/(LOSS) AFTER TAXATION,
  "unappropri_ated_profit_loss_bf" VARCHAR  -- UNAPPROPRI- ATED PROFIT/ (LOSS) BF,
  "transfer_to_reserves_42ba48" VARCHAR  -- TRANSFER TO RESERVES,
  "other_appropria_tions" VARCHAR  -- OTHER APPROPRIA- TIONS,
  "unappropriated_profit_loss_cf_fc5f67" VARCHAR  -- UNAPPROPRIATED PROFIT /(LOSS) CF
);

P L Gen 09–06

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_09_06

18.13 kB
134 rows
17 columns

CREATE TABLE p_l_gen_09_06 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- PROFIT / (LOSS) BEFORE TAXATION,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" DOUBLE  -- PROFIT/(LOSS) AFTER TAXATION,
  "unappropri_ated_profit_loss_bf" VARCHAR  -- UNAPPROPRI- ATED PROFIT/ (LOSS) BF,
  "transfer_to_reserves" VARCHAR,
  "other_appropria_tions" VARCHAR  -- OTHER APPROPRIA- TIONS,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" DOUBLE  -- UNAPPROPRIATED PROFIT / (LOSS) CF
);

P L Gen 16–13

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_16_13

31.83 kB
181 rows
18 columns

CREATE TABLE p_l_gen_16_13 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- PROFIT /(LOSS) BEFORE TAXATION,
  "provision_for_taxation" VARCHAR,
  "profit_loss_after_taxation" VARCHAR  -- PROFIT/(LOSS) AFTER TAXATION,
  "unappropriated_profit_loss_bf" VARCHAR  -- UNAPPROPRIATED PROFIT/(LOSS) BF,
  "transfer_to_reserves" VARCHAR,
  "other_appropriations" VARCHAR,
  "dividend" VARCHAR,
  "unappropriated_profit_loss_cf" VARCHAR  -- UNAPPROPRIATED PROFIT /(LOSS) CF,
  "years" BIGINT
);

P L Gen 20–17

@kaggle.thedevastator_insurance_credit_scoring.p_l_gen_20_17

28.49 kB
191 rows
18 columns

CREATE TABLE p_l_gen_20_17 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- Profit / (Loss) Before Taxation,
  "provision_for_taxation" DOUBLE,
  "profit_loss_after_taxation" DOUBLE  -- Profit/(Loss) After Taxation,
  "unappropriated_profit_loss_bf" DOUBLE  -- Unappropriated Profit/(Loss) BF,
  "transfer_to_reserves" DOUBLE,
  "other_appropriations" DOUBLE,
  "dividend" DOUBLE,
  "unappropriated_profit_loss_cf" DOUBLE  -- Unappropriated Profit /(Loss) CF,
  "years" BIGINT
);

P L Life 2006–2009

@kaggle.thedevastator_insurance_credit_scoring.p_l_life_2006_2009

17.71 kB
144 rows
16 columns

CREATE TABLE p_l_life_2006_2009 (
  "name_of_insurer" VARCHAR,
  "no" VARCHAR  -- NO.,
  "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.73 kB
137 rows
18 columns

CREATE TABLE p_l_life_20_17 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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  -- Profit / (Loss) Before Taxation,
  "provision_for_taxation" DOUBLE,
  "profit_loss_after_taxation" DOUBLE  -- Profit/(Loss) After Taxation,
  "unappropriated_profit_loss_bf" DOUBLE  -- Unappropriated Profit/(Loss) BF,
  "transfer_to_reserves" DOUBLE,
  "other_appropriations" DOUBLE,
  "dividend" DOUBLE,
  "unappropriated_profit_loss_cf" DOUBLE  -- Unappropriated Profit /(Loss) CF,
  "years" BIGINT
);