
Bank Capital to Assets Ratio (%) | World Bank Open Data
Provided By: Rearc

Bank Capital to Assets Ratio (%) | World Bank Open Data
Provided By: Rearc
This product contains bank Capital to Assets Ratio information. Bank capital to assets is the ratio of bank capital and reserves to total assets. The data is available from year 2000. Capital and reserves include funds contributed by owners, retained earnings, general and special reserves, provisions, and valuation adjustments. World Bank Open Data provides free and open access to various global development data. This product works with GS Financial Cloud.
Product offers
The following offers are available for this product. Choose an offer to view the pricing and access duration options for the offer. Select an offer and continue to subscribe. Your subscription begins on the date that your request is approved by the provider. Additional taxes or fees might apply.
Public offer
Payment schedule: Upfront payment | Offer auto-renewal: Supported
$0 for 12 months
Overview
The size and mobility of international capital flows make it increasingly important to monitor the strength of financial systems. Robust financial systems can increase economic activity and welfare, but instability can disrupt financial activity and impose widespread costs on the economy. The ratio of bank capital to assets, a measure of bank solvency and resiliency, shows the extent to which banks can deal with unexpected losses. Capital includes tier 1 capital (paid-up shares and common stock), a common feature in all countries' banking systems, and total regulatory capital, which includes several types of subordinated debt instruments that need not be repaid if the funds are required to maintain minimum capital levels (tier 2 and tier 3 capital). Total assets include all nonfinancial and financial assets. Data are from internally consistent financial statements.
The original publisher of this data is The World Bank. This content is published as World Bank Open Data and provides free and open access to global development data. This work is licensed under a Creative Commons Attribution 4.0 (CC-BY 4.0). This data is anonymized/aggregated.
More Information:
- Source - International Monetary Fund, Global Financial Stability Report
- Schema Definitions
- Sample Dataset
- Terms of Use
- World Bank Open Data Homepage
- Frequency: Annual
What's included?
You will receive access to the following:
- Bank Capital to Assets Ratio (%) from 2000 (bank-capital-to-assets-ratio.csv)
- CloudFormation template that setups up automatic revision updates plus AWS analytics services such as AWS Glue and Amazon Athena (cloudformation.yaml)
- AWS Lambda code for revision updates (post-processing-code.zip)
Please note, in the post processing code, we use a Lambda layer that extends the AWS Python SDK (boto3) that is built into the Lambda Python runtime by adding the AWS Data Exchange and AWS Marketplace Catalog API SDKs as of November 13, 2019. Once the public SDKs are updated to include AWS Data Exchange APIs, we will update the code to remove this Lambda layer.
Deploy CloudFormation template to set up automatic revision updates and AWS Analytics services
Assuming you have subscribed to this product listing, below are the detailed steps to deploy CloudFormation template:
(Please note that you will need IAM permissions for CloudFormation, AWS Data Exchange, IAM, Lambda, Glue, Athena and QuickSight, in order to deploy the CloudFormation template.)
- Under the product listing, scroll down to
Data sets
section and click on the Data set name - Under the
Revisions
section, click on the most recent revision - Under
Assets
, checkmarkbank-capital-to-assets-ratio/automation/post-processing-code.zip
and clickExport to S3
- Choose the S3 Bucket where you would like to store the dataset. Make sure you only choose the S3 bucket. The asset comes with a pre-defined directory structure
- Under
Assets
, checkmarkbank-capital-to-assets-ratio/automation/cloudformation.yaml
and click eitherExport to S3
orExport to computer
- If you exported the
cloudformation.yaml
to S3, go to the S3 UI on the AWS console and navigate to the location where thecloudformation.yaml
is stored. In S3, click on the cloudformation.yaml and copy the url from theObject URL
- Now, from your AWS Management Console, log onto Amazon CloudFormation UI and click
Create Stack
- Under
Choose a template
either provide the template via uploading from local computer or specify the S3 object url and clickNext
- Provide a friendly stack name in the
Stack name
text box - In the
SourceS3Bucket
field, input the S3 bucket name that you chose earlier to store the bank-capital-to-assets-ratio/automation/post-processing-code.zip file - Leave rest of the fields as is
- Click
Next
- In the
Options
screen, clickNext
- Tick mark the
I acknowledge that AWS CloudFormation might create IAM resources.
box - Click
Create
At a high level, CloudFormation will setup following resources automatically.
- Lambda function to setup automatic AWS Data Exchange revision updates for this dataset
- CloudWatch Event rule that will automatically trigger the Lambda function every time a new revision update is published
- Another Lambda function to setup AWS Glue and Amazon Athena
- Necessary IAM roles and permissions
If you are interested in looking at the AWS Lambda code or the CloudFormation template, feel free to inspect files inside bank-capital-to-assets-ratio/automation/post-processing-code.zip
and bank-capital-to-assets-ratio/automation/cloudformation.yaml
Analytics & Visualizations
Apart from the source data, what we are also providing in this product listing is an easy way to interact and extract value out of the dataset. Native AWS Analytics services such as AWS Glue, Amazon Athena and Amazon QuickSight provide different ways to interact and visualize the data. The included AWS CloudFormation template sets up AWS Glue and Amazon Athena automatically in your AWS account.
Data Analysis - This diagram shows how all the AWS services interact
Using AWS Glue and Amazon Athena to run interactive queries against the dataset
Once the CloudFormation template is successfully deployed, the data is immediately searchable, queryable, and available on Athena. You can go to the Athena UI from the AWS Management Console and run SQL queries on the dataset.
Here are some sample Athena SQL queries you can try on the dataset.
# list bank capital to assets ratio for all countries for year 2017
SELECT "country_name", "2017" FROM "bank_capital_to_assets_ratio"."data";
# list yearly bank capital to assets ratio for "united states"
SELECT * FROM "bank_capital_to_assets_ratio"."data" WHERE "country_name" = 'united states';
# compare bank capital to assets ratio for "united states between year "2009" and "2017"
SELECT "country_name", "2009", "2017" FROM "bank_capital_to_assets_ratio"."data" WHERE "country_name" = 'united states';
# compare bank capital to assets ratio between "united states" and "china"
SELECT * FROM "bank_capital_to_assets_ratio"."data" WHERE "country_name" IN ('united states', 'china');
Setup Amazon QuickSight to create visualizations on the dataset
Below are the detailed steps to analyze dataset using Amazon QuickSight
- From your AWS Management Console, log onto Amazon QuickSight
- Click
Manage data
- Click
New data set
- If you ran the provided CloudFormation template, you should already have your database and table with schema created in AWS Glue and Athena
- Click on
Athena
to connect to your data source - Provide a name for your QuickSight
Data source name
and clickCreate data source
- In the
Database: contain sets of table
dropdown, choose database asbank_capital_to_assets_ratio
and underTables: contain the data you can visualize
, choose table asdata
- At this point, you can
Edit/Preview data
if you like - You can then click on
Select
- In the
Finish data set creation
screen, you can selectVisualize
to finish the creation of data set process - Visualize the data set by selecting the
Horizontal bar chart
from theVisual types
- Drag
country_name
field to theY axis
inField wells
and for e.g. drag2017
field in theValue
block to chart the data
You are now ready to start analyzing and visualizing the dataset.
Contact Information
If you have questions about the source data, please contact data@worldbank.org. If you have any questions about the CloudFormation stack, Lambda code or any of the AWS services being used, please contact data@rearc.io.
About Rearc
Rearc is a cloud, software and services company. We believe that empowering engineers drives innovation. Cloud-native architectures, modern software and data practices, and the ability to safely experiment can enable engineers to realize their full potential. We have partnered with several enterprises and startups to help them achieve agility. Our approach is simple — empower engineers with the best tools possible to make an impact within their industry.
Provided By
Fulfillment Method
AWS Data Exchange
Data sets (1)
You will receive access to the following data sets
Revision access rules
All historical revisions | All future revisions
Name | Type | Data dictionary | AWS Region |
---|---|---|---|
Bank Capital to Assets Ratio (%) | World Bank Open Data | Not included | US East (N. Virginia) |
Usage information
By subscribing to this product, you agree that your use of this product is subject to the provider's offer terms including pricing information and Data Subscription Agreement . Your use of AWS services remains subject to the AWS Customer Agreement or other agreement with AWS governing your use of such services.
Support information
Support contact email address
Support contact URL
Refund policy
Refunds Not Applicable
General AWS Data Exchange support