hk_streets

FREE 4,584 rows

Hong Kong bilingual street name directory by district

No-code

Download a file

The complete dataset. No account needed.

Download full CSV
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

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

The complete dataset is free to download below. No account needed.

Create a free account for SQL and the API

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)

Scroll table sideways to see more 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. — —

Full 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