Skip to content

Convert Bundesbank banking export to a SQLite database

License

Notifications You must be signed in to change notification settings

mfa/bundesbank-to-sqlite

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Bundesbank to sqlite

Tests

About

The German Bundesbank releases every quarter of a year a list of all banks in Germany.
This script converts the xslx file to a sqlite database.

Download source data

https://www.bundesbank.de/en/tasks/payment-systems/services/bank-sort-codes/download-bank-sort-codes-626218

choose the XLS version of Bank sort code files, unpacked

install

python setup.py install

Convert downloaded file

bundesbank-to-sqlite convert blz.db blz-aktuell-xlsx-data.xlsx

Use with Datasette

install Datasette:

pip install datasette

run with Datasette:

datasette blz.db

Example queries

Run some queries in Datasette.

http://localhost:8001/blz/bundesbank_blz?blz=10000000
http://localhost:8001/blz/bundesbank_blz?bic=MARKDEF1100
http://localhost:8001/blz/bundesbank_blz?city=Berlin
http://localhost:8001/blz/bundesbank_blz?zipcode=10117

(this are the same examples as in deprecated banking_api)

Thanks

Simon Willison for Datasette and sqlite-utils.

About

Convert Bundesbank banking export to a SQLite database

Topics

Resources

License

Stars

Watchers

Forks

Languages