Lookup a UK company using duckdb
https://duckdb.org/docs/installation/
Do this in a virtual environments to remain sane.
pip install duckdb
http://download.companieshouse.gov.uk/en_output.html
wget http://download.companieshouse.gov.uk/BasicCompanyDataAsOneFile-2022-09-01.zip
unzip BasicCompanyDataAsOneFile-2022-09-01.zip
python company_lookup.py
$ time python company_lookup.py
[('MATATIKA LIMITED', '08275103', 'Private Limited Company')]
real 0m17.092s
user 0m17.280s
sys 0m1.150s