Hong Kong Company Name History
Hong Kong company name changes and historical records
crhk_company_names
- Rows
- 7,754,333
- Coverage
- October 1865 to October 2026
- Columns
- 11
- Latest data
- 2026-10-24
Sample
8 rows shown
All historical name changes for the companies in the crhk_companies sample. Bundled — accessed through the parent dataset.
| business_registration_number | cr_number | company_name | name_language | name_sequence | is_current | effective_from | effective_from_is_estimated | effective_to | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 25450070 | 鵬程德實業一人有限公司 | Chinese | 0 | true | 2026-10-02 | true | — | 2026-10-14 04:32:14 | 031dfdda4c4bf4b05665c05abfff0ad9 | |
| 57045106 | STARWAY PHARM CO., LIMITED | English | 0 | true | 2026-04-14 | true | — | 2026-10-23 05:09:02.449000 | faf8639c0e96d8c244860a6eb9461582 | |
| 72676861 | EliteRock Primero Limited Partnership Fund | English | 0 | true | 2026-04-28 | true | — | 2026-08-30 13:06:08.387000 | 61c74eab8cfb171fc57f1aab595b050b | |
| 78554582 | Blooming Garnet Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-08-27 22:32:41 | 35cf3bfcc42846097554c6cf0e7e788e | |
| 78554875 | Blooming Azalea Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-09-07 01:08:35.942000 | 765638fba44dd176b13489c24f209cdd | |
| 78554906 | Blooming Gentiana Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-08-25 09:12:30.113000 | e3ddd0000fe07bfea65dee6d409f6daa | |
| 78554980 | Blooming Begonia Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-09-07 15:06:22.268000 | ddfc516e0c59a74821b68bb958728c63 | |
| 78555067 | Blooming Bletilla Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-08-26 08:06:25.049000 | f7ee30f3205a9ab1705ec3bb96be969f |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| business_registration_number | text | Business Registration Number (primary company identifier) |
| cr_number | text | Company Registration Number (may be empty for modern-only records) |
| company_name | text | The company name (current or former) for this language. 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. Removing them merges entries the Registry had recorded as two names when they are one, so a name held continuously across such a record reads as one period rather than two |
| name_language | text | Name language: English, Chinese, or Other (replaces the legacy E/C/I/O/T name_type codes) |
| name_sequence | number | Source-provided ordinal of this name within the company's history for this language (0-based; lower = earlier) |
| is_current | yes/no | True if this is the company's current name for this language — exactly one per (company, language) |
| effective_from | text | Effective-from date for this name, as an ISO 'YYYY-MM-DD' string. Normally the registry's own date; for a never-renamed company's current name with no registry date it is backfilled with the incorporation date — see effective_from_is_estimated. The oldest backfilled dates reach 1878, older than any ClickHouse date type can hold, so this is text rather than a date type. Null when neither source provides a date |
| effective_from_is_estimated | yes/no | True when effective_from is the inferred incorporation date (never-renamed founding name) rather than a registry-provided date — treat it as approximate. False when effective_from is registry-sourced or null |
| effective_to | text | Registry effective-to date for this name, as an ISO 'YYYY-MM-DD' string (null = current name) |
| updated_at | date and time | Timestamp when record was last observed |
| 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_company_names LIMIT 10Ways 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.