openregister

Data license: CC-By 4.0 · Data source: OpenCorporates

Custom SQL query

company

id, company_number, current_status, jurisdiction_code, name, registered_address, retrieved_at, register_flag_AD, register_flag_CD...

Many rows

name

id, company_name, company_id

Many rows

officer

id, name, position, start_date, type, company_id, city, firstname, flag...

Many rows

registrations

id, confidence, data_type, publication_date, retrieved_at, source_url, start_date, start_date_type, subsequent_registration_start_date...

Many rows

company_fts (hidden)

name, registered_address

Many rows

company_fts_config (hidden)

k, v

1 row

company_fts_data (hidden)

id, block

Many rows

company_fts_docsize (hidden)

id, sz

Many rows

company_fts_idx (hidden)

segid, term, pgno

23,360 rows

name_fts (hidden)

company_name

Many rows

name_fts_config (hidden)

k, v

1 row

name_fts_data (hidden)

id, block

Many rows

name_fts_docsize (hidden)

id, sz

Many rows

name_fts_idx (hidden)

segid, term, pgno

5,770 rows

officer_fts (hidden)

name

Many rows

officer_fts_config (hidden)

k, v

1 row

officer_fts_data (hidden)

id, block

Many rows

officer_fts_docsize (hidden)

id, sz

Many rows

officer_fts_idx (hidden)

segid, term, pgno

10,764 rows

Powered by Datasette · Query took 307.843ms · Data license: CC-By 4.0 · Data source: OpenCorporates