Hong Kong Company Name History
Hong Kong company name changes and historical records
crhk_company_names
- 行數
- 7,732,616
- 涵蓋期間
- 1865年10月至2026年10月
- 欄位數目
- 11
- 最新數據
- 2026-10-05
樣本
顯示 8 行
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 72676764 | Aurelius Capital Limited Partnership Fund | English | 0 | true | 2026-04-23 | true | — | 2026-08-25 06:55:03.635000 | c9443f643e098ba44c548e1b46c08616 | |
| 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 | |
| 78555091 | Blooming Grape Corporation | English | 0 | true | 2025-08-01 | true | — | 2026-08-26 08:06:25.049000 | 28e3314dd259e84a92845882889e8b48 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.crhk_company_names LIMIT 10取得此數據表的方式
一次性存檔
Hong Kong Companies Registry — Snapshot
All current + dissolved companies, refreshed monthly
一次性 US$99
購買存檔 Hong Kong Companies Registry — Snapshot （在新分頁開啟）訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表