Hong Kong Companies
Hong Kong Companies Registry company directory
crhk_companies
- Rows
- 3,936,660
- Coverage
- October 1865 to November 2026
- Columns
- 67
- Latest data
- 2026-11-04
Sample
8 rows shown
500 companies stratified across active local / dissolved local / foreign / ceased-amalgamated-struck-off / funds & special forms. Regenerated quarterly.
| business_registration_number | cr_number | has_no_cr_number | english_name | chinese_name | status | is_active | is_dissolved | is_dormant | dormant_since | lifecycle_substatus | money_lender_licence_status | company_type | ownership | liability | incorporation_date | incorporation_year | years_since_incorporation | dissolution_date | dissolution_mode | redomicile_date | amalgamation_date | ceased_business_date | registered_office_address | has_address | address_as_of | charges_register | has_charges | winding_up_mode | striking_off_in_progress | deregistration_in_progress | winding_up_in_progress | has_name_dispensation_licence | is_listed_company_legacy_marker | is_one_member_company | has_receiver_appointed | is_deregistered | deregistration_date | strike_off_date | is_s291_striking_off | is_winding_up | winding_up_date | restoration_date | accounting_reference_date | last_agm_date | one_member_status_date | registry_remark | registry_notice_type | amalgamated_into_crn | is_on_watch_list | has_prosecution | chapter_number | incorporation_country | incorporation_country_code | incorporation_country_chinese | address_building_id | address_canonical_en | address_canonical_zh | address_floor | address_unit | address_latitude | address_longitude | address_match_level | address_match_confidence | updated_at | updated_at_inferred | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81524437 | — | false | Haldencrest Limited | — | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-03 22:23:30.762000 | false | a35a15d52eb594f2f2b0260c939a4299 |
| 81524445 | — | false | HOIYEE DESIGN COMPANY LIMITED | 凱怡設計有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-03 22:42:14.909000 | false | e1ec22781669a89d27cbb6d958eeeeb0 |
| 81524453 | — | false | Hong Kong Healroom Limited | 癒顏館有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-03 23:02:02.046000 | false | 682c58eda7e18233ea38bd276c49edb8 |
| 81524461 | — | false | RAS AL KHAIMAH INTERNATIONAL LIMITED | 樂數雅路國際有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-04 11:23:23.149000 | false | 77dc3552b196448645b15db4ad7d33a3 |
| 81524479 | — | false | Hongkong Ruiway Limited | — | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-04 11:41:18.503000 | false | a1f560427b924d5aaa3d7a51abc05a71 |
| 81524487 | — | false | HAPPY SELECT TRADING COMPANY LIMITED | 歡喜環球有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-04 11:23:21.055000 | false | 5b0ec9e9ec600e2a7858f5c7a0a02c2c |
| 81524495 | — | false | Hong Kong Jingyu International Trade Limited | 香港鯨榆國際貿易有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-04 12:08:52.423000 | false | e71acf4c46a78c009ea5348f3cf8f5c2 |
| 81524500 | — | false | Hong Kong Jingrui International Trade Limited | 香港鯨睿國際貿易有限公司 | Live | true | false | false | — | Live | — | Local company | Private | Limited by shares | 2026-11-04 | 2026 | 0 | — | — | — | — | — | — | false | — | — | false | — | false | false | false | false | false | false | false | false | — | — | false | false | — | — | — | — | — | — | — | — | false | false | - | — | — | — | — | — | — | — | — | — | — | — | — | 2026-11-04 12:01:31.120000 | false | ddf2e25f39a3a0a98e998f3b0bad2d15 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| business_registration_number | text | Business Registration Number (BRNO) — primary identifier for the company |
| cr_number | text | Company Registration Number (CRN) — empty when no CRN is on record for the company. See has_no_cr_number to distinguish a registry-confirmed absence from a value we simply don't have |
| has_no_cr_number | yes/no | True when the registry confirms the company has NO Company Registration Number (post-2023 UBI companies), as opposed to a CRN we just don't have on record (in which case cr_number is empty and this is false) |
| english_name | text | Company name in English, as registered. Where the Companies Registry stored the name wrapped in enclosing parentheses — a marker it applies to the secondary-language name on records from roughly 1988-2005, not part of the registered name — those outer brackets are removed upstream; parentheses that belong to the name itself are kept |
| chinese_name | text | Company name in Chinese characters, as registered. Where the Companies Registry stored the name wrapped in enclosing parentheses — a marker it applies to the secondary-language name on records from roughly 1988-2005, not part of the registered name — those outer brackets are removed upstream; parentheses that belong to the name itself are kept |
| status | text | Reconciled legal lifecycle state, in the Companies Registry's own vocabulary (ICRIS ACTIVE_STATUS_*): Live, Dissolved, Ceased place of business, Ceased to exist as an entity after amalgamation, Ceased Registration; null if unknown. 'Ceased place of business' is a registered non-Hong Kong company (Cap. 622 Part 16) that filed Form NN13 — it is NOT dissolved and may still exist under its home jurisdiction. 'Struck off' is a MECHANISM of dissolution, not a status — a struck-off company reads status='Dissolved' with dissolution_mode='Struck Off'; compose the two for display (e.g. 'Dissolved — struck off'). A company that is still Live but has a strike-off or deregistration underway carries striking_off_in_progress / deregistration_in_progress. |
| is_active | yes/no | True if the company has a Live (registered) status. Note a Live company may still be in distress — check striking_off_in_progress, winding_up_in_progress and has_receiver_appointed. |
| is_dissolved | yes/no | True if status indicates dissolution/amalgamation/struck-off, or a dissolution date exists with a non-active status |
| is_dormant | yes/no | True if the company currently has an OPEN dormancy interval (registry's own dates) |
| dormant_since | text | Date the company's current dormancy interval commenced (null if not currently dormant) |
| lifecycle_substatus | text | Detailed lifecycle sub-status (e.g. live-but-dormant, ceased place of business), best-effort label |
| money_lender_licence_status | text | Money Lenders Ordinance (Cap. 163) register status for this company — licensed, application_pending, licence_expired, application_dismissed or application_withdrawn; empty for the vast majority of companies (no register entry). Linked by deterministic company-name match; full register entries and match rules in the crhk_money_lenders dataset |
| company_type | text | Legal entity form — the classification that cleanly splits every organisation, each mapping to its governing HK ordinance: Local company (Companies Ordinance Cap. 622), Registered non-Hong Kong company (Cap. 622 Part 16), Limited partnership (Cap. 37), Limited partnership fund (Cap. 637), Open-ended fund company (Cap. 571), Registered trustees (Cap. 306), Statutory body corporate, Mutual fund, Unregistered company, Overseas corporation with registered charge. Ownership and liability (below) further describe local companies |
| ownership | text | Ownership class of a local Hong Kong company (Companies Ordinance Cap. 622): Private (restricted share transfer, ≤50 members, no invitation to the public — s.11) or Public (s.12). Null for companies limited by guarantee (no share-ownership axis) and for all non-Cap.622 forms (funds, partnerships, non-Hong-Kong companies) |
| liability | text | Members' liability form of a local Hong Kong company (Companies Ordinance Cap. 622): Limited by shares (s.8), Limited by guarantee (s.9 — no share capital), or Unlimited (s.10). Null for non-Cap.622 forms (funds, partnerships, non-Hong-Kong companies) |
| incorporation_date | text | Date the company was incorporated in Hong Kong (YYYY-MM-DD format) |
| incorporation_year | number | Year the company was incorporated |
| years_since_incorporation | number | Number of years since the company was incorporated (calculated from today) |
| dissolution_date | text | Date the company was dissolved (null if still active) |
| dissolution_mode | text | How the company dissolved, best-effort label paired with dissolution_date |
| redomicile_date | text | Date the company re-domiciled into/out of Hong Kong (null if not applicable) |
| amalgamation_date | text | Date the company was amalgamated (merged), null if not applicable |
| ceased_business_date | text | Date a foreign company ceased its Hong Kong place of business (foreign analogue of dissolution) |
| registered_office_address | text | The most recent registered-office address we have observed for the company (for a registered non-Hong Kong company, its principal place of business in Hong Kong). It comes from the Companies Registry's open-data portal where we have read the company there, and otherwise from the last address we observed before 2024-04-18, so recency varies by company: address_as_of gives the date we observed it, and crhk_address_history holds every address we have observed. Null when we have never observed an address for the company. |
| has_address | yes/no | True if we have observed a registered-office address for the company. False means we have never observed one, not that the company has no registered office. |
| address_as_of | date | Date we last observed the registered-office address on record (full history in crhk_address_history) |
| charges_register | text | Charges register indicator from legacy registry data (有 = charges exist) |
| has_charges | yes/no | True if charges (mortgages, debentures or other security) are registered against the company (270,887 companies). Unified across both registry arms — the legacy charges register and the modern e-services indicator — so it stays correct even where one arm is silent. |
| winding_up_mode | text | Winding-up mode if the company is being wound up: Compulsory Winding Up, Members' Voluntary Winding Up, Creditors' Voluntary Winding Up, or Others (ICRIS canonical). Empty if not in winding up. |
| striking_off_in_progress | yes/no | True if the Companies Registry has commenced striking-off action against the company but it is not yet dissolved. Read with `status`: a company that is still Live with this flag set is being struck off right now — the single strongest distress signal in this dataset, and one no other column carries. |
| deregistration_in_progress | yes/no | True if a deregistration application is underway (Form NDR1, Cap. 622 s.751) but the company is not yet dissolved. Unlike striking-off, deregistration is voluntary — the members applied for it. |
| winding_up_in_progress | yes/no | True if winding-up proceedings have commenced but the company is not yet dissolved. See winding_up_mode for the mechanism (compulsory / members' voluntary / creditors' voluntary) and winding_up_date for the commencement date. |
| has_name_dispensation_licence | yes/no | True if the company holds a licence under s.103 of the Companies Ordinance to dispense with the word 'Limited' / '有限公司' in its name — granted to companies formed to promote commerce, art, science, religion, charity or any other useful object. Explains why a Hong Kong limited company may carry a name with no 'Limited' suffix. |
| is_listed_company_legacy_marker | yes/no | True if the legacy registry profile marked this company as listed (上市公司). FROZEN: the modern e-services API publishes no listing marker, so this reflects the registry profile as of 2023-12-22 and will never gain new values. Treat it as a historical cross-check, not a current listing status — use the HKEX datasets for that. |
| is_one_member_company | yes/no | True if registered as a one-member (sole-member) company |
| has_receiver_appointed | yes/no | True if a receiver or manager has been appointed (insolvency-distress signal, rare — 407 companies). Unified across the modern rcvrApptInd indicator and the registry notice set: the indicator alone identifies 357, and the notice set contributes 50 more that it does not carry. |
| is_deregistered | yes/no | True if the company is/was deregistered (voluntary deregistration; legacy ICRIS registry signal) |
| deregistration_date | text | Deregistration commencement date (ISO YYYY-MM-DD), when recorded |
| strike_off_date | text | Striking-off commencement date (ISO YYYY-MM-DD), when recorded |
| is_s291_striking_off | yes/no | True if flagged for striking off under s.291 as a defunct company (legacy ICRIS registry signal) |
| is_winding_up | yes/no | True if in winding-up (liquidation) proceedings, reconciled across the legacy and modern captures |
| winding_up_date | text | Winding-up commencement date (ISO YYYY-MM-DD), when recorded |
| restoration_date | text | Date the company was restored to the register after striking-off/deregistration (ISO YYYY-MM-DD) |
| accounting_reference_date | text | Registry accounting reference date (ISO YYYY-MM-DD), when recorded |
| last_agm_date | text | Date of the last annual general meeting on record (ISO YYYY-MM-DD) |
| one_member_status_date | text | Date the one-member (sole-member) status was last updated on the register (ISO YYYY-MM-DD) |
| registry_remark | text | Registry caution or notice about the company, verbatim and often BILINGUAL (English and Traditional Chinese in one value). One notice stream collapsed from its two historical sources (the e-services profile page and the legacy register remark; both frozen). Despite reading as free text it is largely TEMPLATED — see registry_notice_type for the classification; over a thousand are amalgamation notices naming the successor company and its CR number (extracted into amalgamated_into_crn). Kept verbatim on purpose: accuracy cautions are exactly the notices a diligence reader must see unabridged. |
| registry_notice_type | text | The registry notice classified into a fixed set of families — the commonest are 'Name changed by Registrar', 'Amalgamation', 'Secretary appointment disputed' and 'Accuracy caution'; 'Unclassified' marks the counted residual (the verbatim text in registry_remark is always the authority) |
| amalgamated_into_crn | text | For a company dissolved by amalgamation whose notice names the successor: the successor company's CR number (e.g. '1549159'), extracted from the notice text. Null for survivor-side notices (the company that REMAINS after the amalgamation has no successor by definition) and where the registry published no CR number |
| is_on_watch_list | yes/no | True if the company appears on the registry watch list (legacy ICRIS registry signal) |
| has_prosecution | yes/no | True if a prosecution has been recorded against the company (legacy ICRIS registry signal) |
| chapter_number | text | Hong Kong Ordinance chapter number for statutory bodies (modern API), where applicable |
| incorporation_country | text | Country of incorporation in English (foreign companies only), in the Companies Registry's own e-services display form: 'British Virgin Islands', 'Cayman Islands', 'the People's Republic of China', 'United States of America'. One label per country — derived from `incorporation_country_code` via a fixed 111-entry bijective map (normalised 2026-08-30; before that the column shipped TWO vocabularies — the Registry's published-register UPPERCASE short names on 90% of rows and this display form on the rest). For exact filtering prefer `incorporation_country_code` (ISO-3166 alpha-3, populated on 99.95% of rows carrying a country). The 18 rows without a code (NULL there) keep the Registry's published-register UPPERCASE form — the one declared remnant of the old vocabulary. Empty for local Hong Kong companies. |
| incorporation_country_code | text | Country of incorporation as the ISO-3166 alpha-3 code (foreign companies only, e.g., 'VGB', 'CYM', 'BMU') — the Registry's stable key, from which `incorporation_country` and `incorporation_country_chinese` are derived; prefer it for filtering. NULL on 18 legacy-only rows that carry a label but no code. Empty for local Hong Kong companies. |
| incorporation_country_chinese | text | Country of incorporation in Traditional Chinese (foreign companies only), in the Registry's e-services display form: '英屬維爾京群島', '開曼群島', '中華人民共和國'. Derived from `incorporation_country_code` via the same fixed 111-entry map as `incorporation_country` (normalised 2026-08-30). The 18 rows without a code keep the legacy published form. Empty for local Hong Kong companies. |
| address_building_id | text | The building the company's CURRENT registered office is in, under Renavon's own building id (HKB- and a hash, stable across rebuilds; links to hk_buildings). The current office is the newest address in crhk_address_history, not the last-known registered_office_address above. Null when the address matched no single building |
| address_canonical_en | text | The current registered office written out in English in the government address gazetteer's canonical form (flat, floor, building, street, district), as the address resolver matched it |
| address_canonical_zh | text | The current registered office written out in Chinese in the government address gazetteer's canonical form |
| address_floor | text | Floor of the current registered office as read from the address (e.g. '12', 'G', 'UG'); null when the address names none |
| address_unit | text | Flat, room or unit of the current registered office as read from the address (e.g. 'A', '1203'); null when the address names none |
| address_latitude | number | Latitude of the matched building, or of the street or area when the match is coarser (WGS84 degrees) |
| address_longitude | number | Longitude of the matched building, or of the street or area when the match is coarser (WGS84 degrees) |
| address_match_level | text | How precisely the current registered office was matched: 'unit', 'floor' or 'building' (a building id is set), or only to a 'phase', 'estate', 'street_number', 'street', 'village', 'district' or 'region'; 'none' when it matched nothing |
| address_match_confidence | number | The address resolver's probability that the match is right, from 0 to 1 |
| updated_at | date and time | When we last checked this company at the Companies Registry (UTC): the latest time we fetched its company record, whether or not anything had changed. Dissolved companies are not re-checked, so theirs can be months or years old. Where we hold no record of a check (companies known only from older bulk imports), this is the last date the company's details were observed, and updated_at_inferred is true |
| updated_at_inferred | yes/no | True when updated_at is not a recorded check of the company at the Registry but the best date we have for it, the last date its details were observed in an older bulk import; false when updated_at is the time of a recorded check |
| id | text | Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (race_id, horse_id, and the like) are unchanged. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.crhk_companies LIMIT 10
Ways to get this table
One-off archive
Hong Kong Companies Registry — Snapshot
All current + dissolved companies
US$99 one-off
Buy the archive Hong Kong Companies Registry — SnapshotSubscription
HK Corporate Diligence — Compliance Pass
1,000,000 rows a monthwith 14 other tables
Subscriptions and archives are sold by Renavon, which sets the prices shown here and handles checkout.