openregister
Tables
company
id, company_number, current_status, jurisdiction_code, name, registered_address, retrieved_at, register_flag_AD, register_flag_CD, register_flag_DK, register_flag_HD, register_flag_SI, register_flag_UT, register_flag_VOE, federal_state, native_company_number, registered_office, registrar, register_art, register_nummer, former_registrar, register_flag_, register_flag_Note:, _registerNummerSuffix, register_flag_Status information
5,305,727 rows
officer
id, name, position, start_date, type, company_id, city, firstname, flag, lastname, title, dismissed, end_date, maidenname, reference_no
4,803,514 rows
registrations
id, confidence, data_type, publication_date, retrieved_at, source_url, start_date, start_date_type, subsequent_registration_start_date, company_id, previous_company_number, previous_jurisdiction_code, previous_entity_type, subsequent_company_number, subsequent_jurisdiction_code, subsequent_entity_type, sample_date, alternate_company_number, alternate_jurisdiction_code, alternate_entity_type, previous_registration_end_date
375,180 rows
... and 15 hidden tables
Download SQLite DB: openregister.db 2.5 GB