crhk_documents
Hong Kong Companies Registry document filings and annual returns
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 setupDocument filings from the Hong Kong Companies Registry including annual returns, financial statements, director changes, and other regulatory filings. Search by company, document type, or filing date. Contains filing metadata, document pricing, and availability for online viewing. Useful for corporate research and compliance monitoring.
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 (29 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| company_identifier | String | Company identifier (CR number or BRN depending on source) | — | — |
| business_registration_number | String | Business Registration Number | — | — |
| document_id | String | Document identifier within the company's filing history | — | — |
| document_number | String | Document number assigned by the Companies Registry | — | — |
| document_sequence_number | String | Sequence number for multi-part document filings | — | — |
| document_barcode | String | Companies Registry barcode used to track and retrieve the physical or scanned document | — | — |
| document_english_name | String | Document type name in English (e.g., Annual Return, Accounts) | — | — |
| document_chinese_name | String | Document type name in Chinese | — | — |
| document_short_form | String | Document short form code (AR=Annual Return, ACC=Accounts, NNC=New Company, etc.) | — | — |
| document_type_category | String | Simplified type: Annual Return, Accounts, Director/Secretary Change, Address Change, Share Related, Name Change, Incorporation, Charges, Winding Up, Other | — | — |
| document_size | String | Document size category (S=Small, M=Medium, L=Large) | — | — |
| num_pages | Nullable(Int32) | Number of pages in the document | — | — |
| file_size_bytes | Nullable(Int64) | Document file size in bytes | — | — |
| filing_date | Nullable(String) | Date and time the document was filed with the Companies Registry, as an ISO 'YYYY-MM-DD HH:MM:SS' string. Filings run from 1865 to the present, so this is text rather than a date type — dates that old cannot be represented by any ClickHouse date type. Null only where the Registry itself records no filing date. | — | — |
| filing_year | Nullable(UInt16) | Year the document was filed, taken from filing_date. Values before 1970 are real — the Registry's oldest filings date to the 1860s. | — | — |
| annual_return_year | Nullable(UInt16) | Annual return reporting year (null for non-AR documents) | — | — |
| status | String | Document status (Available, Pending, Unavailable) | — | — |
| company_activity_status | String | Company activity status code at time of filing (L, D, C, A, X) | — | — |
| company_activity_status_label | Nullable(String) | Company activity status label — human-readable name for company_activity_status (Live, Dissolved, Ceased, Amalgamated, Struck Off) | — | — |
| image_indicator | String | Document image availability code (A, S, M) | — | — |
| image_indicator_label | Nullable(String) | Document image availability label — human-readable name for image_indicator (Available, Scanned, Microfilm) | — | — |
| is_preview_available | Bool | True if a preview of the document is available for online viewing | — | — |
| is_bulky | Bool | True if the document exceeds the standard page limit for online viewing | — | — |
| is_viewable_online | Bool | True if document image is available or preview exists | — | — |
| download_price | Nullable(Float64) | Download price in HKD | — | — |
| certified_price | Nullable(Float64) | Certified copy price in HKD | — | — |
| paper_price | Nullable(Float64) | Paper copy price in HKD | — | — |
| updated_at | DateTime64(3, 'UTC') | Timestamp when record was last updated | — | — |
| 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. | — | — |
200 documents linked to the 500 companies in the crhk_companies sample. Lets buyers evaluate document availability and date coverage before subscribing.
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 documents, all-time, 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