免費
Hong Kong Money Lenders Register
Licensed money lenders, applications and expirations in Hong Kong
crhk_money_lenders
- 行數
- 6,767
- 涵蓋期間
- 2026年8月至2026年8月
- 欄位數目
- 14
- 最新數據
- 2026-08-31
樣本
顯示 8 行
The full Money Lenders register, no row cap — current licensees, pending applications, expired licences, and dismissed and withdrawn applications. The register is small and freely public, so the sample is the complete dataset.
| register_status | mlr_no | licence_no | name_en | name_zh | licence_expiry_date | is_renewal_in_progress | remarks_en | remarks_zh | business_registration_number | brn_match_rule | register_as_at | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| licence_expired | 1 | — | Ching Tai Finance & Investment Co. | 正大財務投資公司 | 1993-12-08 | — | — | — | — | — | 2026-08-31 | 2026-09-21 03:41:59 | fdfe75103dc34b0df20b82b4838b3d3e |
| licence_expired | 10 | — | Oriental Manufacturing Company (H.K.) Limited | 香港百昌行有限公司 | 1983-04-22 | — | — | — | — | — | 2026-08-31 | 2026-09-21 03:41:59 | f5cd3e1b063836b9190a26bac2a871d9 |
| licence_expired | 100 | — | Honorway Nominees Limited | 恒威代理人有限公司 | 1986-06-20 | — | — | — | 05899777 | unique_name | 2026-08-31 | 2026-09-21 03:41:59 | 1ac59c9cbcfb00c535aa5f354d881ad7 |
| licence_expired | 1000 | — | Mitsubishi Heavy Industries, (Hong Kong) Ltd. | 三菱重工業(香港)有限公司 | 1998-06-06 | — | — | — | — | — | 2026-08-31 | 2026-09-21 03:41:59 | 541f643966c129ed6f40a4fd9528cf01 |
| licence_expired | 1001 | — | Ryoshin Finance (Hong Kong) Co., Ltd. | 香港菱信財務有限公司 | 1994-06-06 | — | — | — | — | — | 2026-08-31 | 2026-09-21 03:41:59 | aa7137e90c229f58affd404534f68760 |
| licensed | 1002 | 1130/2025 | King Fook Finance Company Limited | 景福金融有限公司 | 2026-09-04 | true | — | — | 03813466 | unique_name | 2026-08-31 | 2026-09-21 03:42:01 | f006ce052441acaef39e9c84d0a79402 |
| licence_expired | 1003 | — | Chow Sang Sang Finance Limited | 周生生財務有限公司 | 2001-07-06 | — | — | — | 03574846 | unique_name | 2026-08-31 | 2026-09-21 03:41:59 | 70857aff763069a913f6c1adbcb9b50b |
| licence_expired | 1004 | — | Solid Pacific Finance Limited | 實利財務有限公司 | 1991-04-22 | — | — | — | 06236526 | unique_name | 2026-08-31 | 2026-09-21 03:41:59 | 3a58ac566341bbce51b9823436269de3 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| register_status | text | Which register list the entry is on: licensed, application_pending, licence_expired, application_dismissed or application_withdrawn |
| mlr_no | text | Registrar's MLR file number — reused across withdrawn applications, so not unique on its own |
| licence_no | text | Money lenders licence number (e.g. 577/2026); only current licensees carry one |
| name_en | text | Money lender's English name (a handful of register entries genuinely have none) |
| name_zh | text | Money lender's Traditional-Chinese name (sparse on older entries) |
| licence_expiry_date | date | Licence expiry date — current licences (future-dated) and expired licences (past-dated); null for application rows |
| is_renewal_in_progress | yes/no | True when a current licensee's renewal application is in progress (the register's 'R' remark); null for non-licensee rows |
| remarks_en | text | Registry free-text remarks in English (e.g. Licensing Court revocation notes on expired licences) |
| remarks_zh | text | Registry free-text remarks in Traditional Chinese |
| business_registration_number | text | 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 | text | 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 | date | The register's own "As at" date — the date the registry states the lists reflect |
| updated_at | date and time | When we captured the register files this row comes from |
| id | text | 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.crhk_money_lenders LIMIT 10