crhk_company_names
Hong Kong company name changes and historical records
Download a file
CSV · Excel · Parquet · JSON. Filtered exports.
See pricingQuery with SQL
DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.
Open connection detailsConnect to AI
MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.
See setupHistorical record of company names for Hong Kong registered companies. Each row is one distinct name in one language (English, Chinese, or Other) for one company, with the registry's effective date range where available. Exactly one name per company and language is flagged as the current name. Reconciled across legacy Companies Registry data, the modern ICRIS API, company profiles, and the crhkall database. Useful for identifying predecessor companies and tracing corporate history.
Evaluate it in full below: the evidence and a working sample are open to everyone. Buy or subscribe to unlock the complete dataset — your account is created automatically at checkout.
The evidence
Schema & column quality (11 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| business_registration_number | String | Business Registration Number (primary company identifier) | — | — |
| cr_number | String | Company Registration Number (may be empty for modern-only records) | — | — |
| company_name | String | 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 | String | Name language: English, Chinese, or Other (replaces the legacy E/C/I/O/T name_type codes) | — | — |
| name_sequence | Int32 | Source-provided ordinal of this name within the company's history for this language (0-based; lower = earlier) | — | — |
| is_current | Bool | True if this is the company's current name for this language — exactly one per (company, language) | — | — |
| effective_from | Nullable(String) | 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 | Bool | 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 | Nullable(String) | Registry effective-to date for this name, as an ISO 'YYYY-MM-DD' string (null = current name) | — | — |
| updated_at | Nullable(DateTime64(3, 'UTC')) | Timestamp when record was last observed | — | — |
| id | String | 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. | — | — |
All historical name changes for the companies in the crhk_companies sample. Bundled — accessed through the parent dataset.
Choose your access
A Pass gives you freshness within a rolling window. The Full Archive gives you the full history we hold for the dataset, frozen at purchase. They solve different problems, and they work together.
One-off purchase
Full Archive
The full history we hold, frozen at purchase. Yours to keep.
Full details →- What you get
- The full history we hold, to your purchase date
- History depth
- All current + dissolved companies, refreshed monthly, in full
- Updates
- None. Frozen at purchase
- Delivery
- Gzipped CSV, opens in Excel; link valid 7 days
- API access
- Not included
Pass subscription
HK Corporate Diligence — Compliance Pass
Continuously updated, with API access.
View full package →- Access window
- Full history (no window)
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 1,000,000 rows/month included
Included Datasets
Get notified when this dataset is updated.
Questions about this data?
Our data experts are ready to help clarify any aspects of this dataset.
Contact Our Team