Bundesbank to sqlite
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
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
Datasette
Use withinstall 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.