home

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...

5,305,727 rows

name

id, company_name, company_id

1,409,429 rows

officer

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

4,803,514 rows

registrations

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

375,180 rows

company_fts (hidden)

name, registered_address

5,305,727 rows

company_fts_config (hidden)

k, v

1 row

company_fts_data (hidden)

id, block

38,643 rows

company_fts_docsize (hidden)

id, sz

5,305,727 rows

company_fts_idx (hidden)

segid, term, pgno

23,360 rows

name_fts (hidden)

company_name

1,409,429 rows

name_fts_config (hidden)

k, v

1 row

name_fts_data (hidden)

id, block

7,855 rows

name_fts_docsize (hidden)

id, sz

1,409,429 rows

name_fts_idx (hidden)

segid, term, pgno

5,770 rows

officer_fts (hidden)

name

4,803,514 rows

officer_fts_config (hidden)

k, v

1 row

officer_fts_data (hidden)

id, block

15,757 rows

officer_fts_docsize (hidden)

id, sz

4,803,514 rows

officer_fts_idx (hidden)

segid, term, pgno

10,764 rows

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