crhk_money_lenders
Licensed money lenders, applications and expirations in Hong Kong
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 setupHong Kong's official money lender register under the Money Lenders Ordinance (Cap. 163), published by the Companies Registry: current licensees with licence numbers and expiry dates, pending licence applications, expired licences, and dismissed or withdrawn applications — one row per register entry, bilingual names, refreshed weekly from the registry's data files.
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
Rows over time
monthSchema & column quality (14 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| register_status | Nullable(String) | Which register list the entry is on: licensed, application_pending, licence_expired, application_dismissed or application_withdrawn | — | — |
| mlr_no | Nullable(String) | Registrar's MLR file number — reused across withdrawn applications, so not unique on its own | — | — |
| licence_no | Nullable(String) | Money lenders licence number (e.g. 577/2026); only current licensees carry one | — | — |
| name_en | Nullable(String) | Money lender's English name (a handful of register entries genuinely have none) | — | — |
| name_zh | Nullable(String) | Money lender's Traditional-Chinese name (sparse on older entries) | — | — |
| licence_expiry_date | Nullable(Date) | Licence expiry date — current licences (future-dated) and expired licences (past-dated); null for application rows | — | — |
| is_renewal_in_progress | Nullable(Bool) | True when a current licensee's renewal application is in progress (the register's 'R' remark); null for non-licensee rows | — | — |
| remarks_en | Nullable(String) | Registry free-text remarks in English (e.g. Licensing Court revocation notes on expired licences) | — | — |
| remarks_zh | Nullable(String) | Registry free-text remarks in Traditional Chinese | — | — |
| business_registration_number | Nullable(String) | Business Registration Number of the matching company on the Companies Registry — linked by deterministic exact-name match (the register itself publishes no BRN); empty when no unambiguous match exists. Join key to crhk_companies and the rest of the family | — | — |
| brn_match_rule | Nullable(String) | How the BRN link was made: unique_name (the name matches exactly one company) or single_active_name (several companies share the name, exactly one is Active); empty when unlinked | — | — |
| register_as_at | Nullable(Date) | The register's own "As at" date — the date the registry states the lists reflect | — | — |
| updated_at | Nullable(DateTime64(3)) | When we captured the register files this row comes from | — | — |
| 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 (mlr_no and the like) are unchanged. | — | — |
250 register entries stratified across the five register statuses — current licensees, pending applications, expired licences, dismissed and withdrawn applications — including BRN-linked examples. Regenerated quarterly.
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.
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