Hong Kong Company Address History
Registered-office timeline for Hong Kong companies
crhk_address_history
- 行數
- 2,468,417
- 涵蓋期間
- 2023年9月至2026年10月
- 欄位數目
- 9
- 最新數據
- 2026-10-02
樣本
顯示 8 行
500 registered-office address records, full schema. Recency varies by company — the live arm is still filling in, so read last_observed_at per row rather than assuming a single as-of date.
| business_registration_number | address | effective_from | effective_to | first_observed_at | last_observed_at | observation_count | is_current | id |
|---|---|---|---|---|---|---|---|---|
| 00000018 | 48TH FLOOR, CHEUNG KONG CENTER 2 QUEEN'S ROAD CENTRAL HONG KONG | 2019-01-28 | — | 2023-09-24 21:15:11.941000 | 2026-09-03 16:56:14 | 6 | true | 1c3b5c41b8d7ef247101ffe19b699797 |
| 00000026 | 8 FUK WANG STREET, YUEN LONG INDUSTRIAL ESTATE, YUEN LONG, NT, HONG KONG | — | — | 2023-11-05 19:28:08.538000 | 2026-09-02 14:43:54 | 3 | true | c7d3d40d37535a456f37df3576593377 |
| 00000107 | RM 3 1/F GOLDFIELD BLDG 42-44 CONNAUGHT RD WEST HONG KONG | 2007-03-19 | — | 2023-11-05 19:30:10.782000 | 2026-09-03 20:17:53 | 4 | true | 73922c102a83a4424edb5b00d095fa23 |
| 00000173 | FLAT A, 7/F, CHEUNG LUNG INDUSTRIAL BUILDING 10 CHEUNG YEE STREET KOWLOON HONG KONG | 2019-01-31 | — | 2023-11-05 19:35:04.438000 | 2026-09-05 11:43:42 | 5 | true | c34aa7d36ca68ac1221046e807e4a20f |
| 00000181 | 31ST FLOOR, ONE PACIFIC PLACE, 88 QUEENSWAY, HONG KONG | — | 2010-08-09 | 2026-09-02 17:57:12 | 2026-09-02 17:57:12 | 1 | false | 7f78d06a4bf2b01c85e73598fd10dbe3 |
| 00000181 | 33/F ONE PACIFIC PLACE 88 QUEENSWAY HONG KONG | 2010-08-09 | — | 2023-11-05 19:26:31.313000 | 2024-04-13 10:21:56.230000 | 4 | true | 651468cec0d6807406d9693504786fec |
| 00000424 | 31ST FLOOR, ONE PACIFIC PLACE, 88 QUEENSWAY, HONG KONG | — | — | 2026-09-05 09:13:14 | 2026-09-05 09:13:14 | 1 | true | b63ccff5d70c566d2125365e97ca38fd |
| 00000424 | 33/F, ONE PACIFIC PLACE 88 QUEENSWAY, HONG KONG | — | — | 2023-11-05 19:26:51.202000 | 2023-12-06 20:12:31.373000 | 2 | false | ee8b4224c03fab1548bc9d0ac903bdcb |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| business_registration_number | text | The company's 8-digit Hong Kong Business Registration Number — the join key to every other CRHK dataset (companies, documents, name history) |
| address | text | Registered-office address observed on record |
| effective_from | date | Registry effective-from date for this address, where the source provides it (Plan A; null otherwise) |
| effective_to | date | Registry effective-to date for this address. NULL means the address was still open at our most recent observation of that company — it does NOT mean the address is open today. |
| first_observed_at | date and time | Timestamp we first witnessed this address on record |
| last_observed_at | date and time | Timestamp we most recently witnessed this address on record |
| observation_count | number | Number of observations witnessing this (company, address) tuple |
| is_current | yes/no | True if this is the most-recent address we OBSERVED for the company. NOT a current-address flag: how much it is worth depends on when we last looked, which last_observed_at gives per row. Sampled against the Companies Registry's live open-data API on 2026-09-02 — before the live arm landed — 11 of 52 is_current addresses (21.2%) had been superseded by a relocation we had not seen. Read it as 'last known', and re-verify against the registry before relying on it. |
| 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.crhk_address_history LIMIT 10取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表