crhk_company_names

PREMIUM 7,319,919 rows

Hong Kong company name changes and historical records

No-code

Download a file

CSV · Excel · Parquet · JSON. Filtered exports.

See pricing
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

Historical 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.

Premium dataset

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.

See access options

The evidence

Data coverage
Jan 1970 – present
Volume
7,319,919 rows
Last updated
17 July, 2026 (5 days ago)

Rows over time

month
1970-01-01 2026-07-01
Schema & column quality (11 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 — —
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(Date32) Effective-from date for this name. 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. Null when neither is available — —
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(Date32) Registry effective-to date for this name (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. — —

Sample data

CSV Excel

All historical name changes for the companies in the crhk_companies sample. Bundled — accessed through the parent dataset.

SELECT * FROM renavon_exports.crhk_company_names LIMIT 50 0.02s
Loading data… | Click a header to sort; drag headers to reorder.

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.

Satisfaction guarantee: 14-day money-back. Details →

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
US$99
one-time purchase

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

Hong Kong Companies
Hong Kong Company Name History this dataset
Hong Kong Company Filings
Hong Kong Money Lenders Register
HKEX Company Directors
HKEX Disclosure Codes
HKEX Insider Disclosures
SFC Corporation Addresses & Contacts
SFC Complaints Officers
SFC Disciplinary Actions
SFC Executive Officers
SFC Licensed Persons
SFC Licensed Representatives
SFC Responsible Officers
US$299
per month

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