hk_property_phases
Development phases with completion span, building count and location
Download a file
CSV and Parquet. 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 setupDevelopment phases: the middle level of the estate→phase→building hierarchy. A phase groups buildings within an estate (e.g. "PHASE 2 CROWN OF ST BARTHS"). The parent estate code and numeric ids, bilingual phase names, the completion-date span of its buildings, a building count, and the phase's centre coordinates and neighbourhood. Join hk_property_buildings.phase_code (members) and, via estate_code, hk_property_estates (parent estate).
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
Schema & column quality (14 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| phase_code | String | Centaline phase code — primary identifier | — | — |
| estate_code | Nullable(String) | Parent TRUE estate code (links hk_property_estates); null for standalone single-phase / village developments | — | — |
| centa_phase_id | Nullable(Int64) | Stable numeric Centaline phase id (centaest) — integer alternate key | — | — |
| centa_estate_id | Nullable(Int64) | Stable numeric parent-estate id; null where estate_code is null | — | — |
| phase_name_en | Nullable(String) | Phase name in English (modal across observations) | — | — |
| phase_name_zh | Nullable(String) | Phase name in Chinese (modal across observations) | — | — |
| completion_date_min | Nullable(Date32) | Earliest completion date among the phase's buildings, including completions before 1970 | — | — |
| completion_date_max | Nullable(Date32) | Latest completion date among the phase's buildings | — | — |
| building_count | Int64 | Distinct member buildings observed in this phase | — | — |
| latitude | Nullable(Float64) | Phase-centre latitude (WGS84), from the weekly autocomplete; null when unobserved | — | — |
| longitude | Nullable(Float64) | Phase-centre longitude (WGS84), from the weekly autocomplete; null when unobserved | — | — |
| hma | Nullable(String) | Centaline Housing Market Area code, from the weekly autocomplete; null when unobserved | — | — |
| updated_at | Nullable(DateTime64(3)) | Timestamp of the latest source observation for this phase; null for phases with no dated source observation | — | — |
| 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 (phase_code) are unchanged. | — | — |
A slice of the phase register, the most recently completed first, full schema.
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
Hong Kong Property — Property 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