crhk_money_lenders

PREMIUM 6,738 rows

Licensed money lenders, applications and expirations in Hong Kong

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

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

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
May 2026 – May 2026
Volume
6,738 rows
Last updated
31 May, 2026 (1 month ago)

Rows over time

month
2026-05-01 2026-05-01
Schema & column quality (14 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. — —

Sample data

CSV Excel

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.

SELECT * FROM renavon_exports.crhk_money_lenders 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 →

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
Hong Kong Company Filings
Hong Kong Money Lenders Register this dataset
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