SFC Disciplinary Actions
Enforcement and disciplinary history for Hong Kong SFC-licensed firms
sfc_disciplinary_actions
- 行數
- 134
- 涵蓋期間
- 2021年4月至2026年7月
- 欄位數目
- 8
- 最新數據
- 2026-07-28
樣本
顯示 8 行
The last 12 months of SFC disciplinary actions.
| corp_ceref | action_date | action_type | action_type_chi | eng_doc_seq | chi_doc_seq | updated_at | id |
|---|---|---|---|---|---|---|---|
| AAU638 | 2025-11-13 | Public Reprimand | 公開譴責 | 3327 | 3328 | 2026-09-24 07:16:19.376000 | a97db640b2e96ab7f91e64b5bd708ef0 |
| AAU638 | 2025-11-13 | Fine | 罰款 | 3327 | 3328 | 2026-09-24 07:16:19.376000 | aec3427c34d6ba390ad4988b987ac398 |
| ABN091 | 2026-07-22 | Public Reprimand | 公開譴責 | 3369 | 3370 | 2026-09-24 07:16:19.376000 | dc8b005bbd0c119c3ed85fa386135b9f |
| ABN091 | 2026-07-22 | Fine | 罰款 | 3367 | 3368 | 2026-09-24 07:16:19.376000 | a7a5ee951bb3ec74ce0b253c3fe5ddf0 |
| ACU547 | 2026-07-28 | Public Reprimand | 公開譴責 | 3379 | 3380 | 2026-09-25 07:15:48.122000 | 665e6880c0da813582b98282b4585773 |
| ACU547 | 2026-07-28 | Fine | 罰款 | 3377 | 3378 | 2026-09-25 07:15:48.122000 | 730d45dd4ce70111df3f7db342362baa |
| AEP554 | 2025-10-17 | Fine | 罰款 | 3319 | 3320 | 2026-09-26 07:17:15.617000 | ff5018400b9dadf3577a0393653e09b1 |
| AEP554 | 2025-10-17 | Public Reprimand | 公開譴責 | 3317 | 3318 | 2026-09-26 07:17:15.617000 | 82b3814439cf3dee284a9646d782dbd0 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| corp_ceref | text | CE Reference of the disciplined SFC-licensed corporation |
| action_date | date | Date the disciplinary action was taken |
| action_type | text | Type of action (e.g. Fine, Public Reprimand, Suspension, Revocation) |
| action_type_chi | text | Action type in Chinese |
| eng_doc_seq | text | Sequence number of the English press-release document for this action |
| chi_doc_seq | text | Sequence number of the Chinese press-release document for this action |
| updated_at | date and time | Timestamp of the most recent fetch that witnessed this action |
| 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 (race_id, horse_id, and the like) are unchanged. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.sfc_disciplinary_actions LIMIT 10取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表