How can I access hk_streets?

Bilingual directory of Hong Kong street names organized by district. Search streets in English or Chinese with automatic street type classification (Road, Street, Avenue, Lane, etc.). Useful for address validation, geographic analysis, and location-based research.

Free dataset

Create a free account to unlock the complete dataset, SQL, and the API.

Create free account

The evidence

Data coverage

Aug 2023 – May 2024

Volume

4,584 rows

Last updated

24 May, 2024 (2 years ago)

Schema & column quality (7 columns)

Column	Type	Description	Populated	Distinct
district	String	Hong Kong district name	—	—
name_english	String	Street name in English	—	—
name_chinese	String	Street name in Chinese	—	—
street_type	String	Street type classification: Road, Street, Avenue, Lane, Path, Terrace, Drive, Square, Circuit, Other	—	—
source_url	String	Source URL for the street data	—	—
updated_at	DateTime64(3)	Timestamp when record was last updated	—	—
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 (race_id, horse_id, and the like) are unchanged.	—	—

Sample data

CSV Excel

Full Hong Kong street directory, no row cap. Reference dataset shipped in its entirety.

SELECT * FROM renavon_exports.hk_streets LIMIT 50 0.02s

Loading data… | Click a header to sort; drag headers to reorder.

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