hkjc_horses
Hong Kong racehorse profiles, pedigree and career statistics
Download a file
CSV · Excel · Parquet · JSON. 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 setupDetailed profiles of every active and retired Hong Kong racehorse. Look up any horse's breeding (sire, dam, origin country), current HKJC rating, career win record, total prize money earned, and trainer/owner details. Track rating changes throughout the season and identify horses on the rise or decline. Updated after every race meeting with the latest statistics.
Create a free account to subscribe and get full access — SQL queries, CSV/Excel downloads, and API.
Dataset Statistics
You're viewing a 20-row preview. Subscribe to unlock the full interactive data explorer, downloads, and SQL access.
| {'name': 'horse_id', 'type': 'String'} | {'name': 'horse_name', 'type': 'Nullable(String)'} | {'name': 'registration_status', 'type': 'String'} | {'name': 'colour', 'type': 'Nullable(String)'} | {'name': 'sex', 'type': 'Nullable(String)'} | {'name': 'age', 'type': 'Nullable(Int32)'} | {'name': 'origin_country', 'type': 'Nullable(String)'} | {'name': 'import_date', 'type': 'Nullable(DateTime)'} | {'name': 'import_type', 'type': 'Nullable(String)'} | {'name': 'years_in_hk', 'type': 'Nullable(Int64)'} | {'name': 'sire', 'type': 'Nullable(String)'} | {'name': 'dam', 'type': 'Nullable(String)'} | {'name': 'dam_sire', 'type': 'Nullable(String)'} | {'name': 'owner', 'type': 'Nullable(String)'} | {'name': 'trainer', 'type': 'Nullable(String)'} | {'name': 'current_rating', 'type': 'Nullable(Int32)'} | {'name': 'last_rating', 'type': 'Nullable(Int32)'} | {'name': 'start_of_season_rating', 'type': 'Nullable(Int32)'} | {'name': 'season_rating_change', 'type': 'Nullable(Int64)'} | {'name': 'wins', 'type': 'Nullable(Int32)'} | {'name': 'seconds', 'type': 'Nullable(Int32)'} | {'name': 'thirds', 'type': 'Nullable(Int32)'} | {'name': 'total_starts', 'type': 'Nullable(Int32)'} | {'name': 'win_rate', 'type': 'Nullable(Float64)'} | {'name': 'place_rate', 'type': 'Nullable(Float64)'} | {'name': 'career_stage', 'type': 'String'} | {'name': 'total_prize_money', 'type': 'Nullable(Float64)'} | {'name': 'season_prize_money', 'type': 'Nullable(Float64)'} | {'name': 'last_race_date', 'type': 'Nullable(DateTime)'} | {'name': 'days_since_last_race', 'type': 'Nullable(Int64)'} | {'name': 'stable_location', 'type': 'Nullable(String)'} | {'name': 'updated_at', 'type': 'DateTime'} |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data Dictionary
Not ready to subscribe? 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 TeamThis is a premium dataset
Pick a plan above and pay directly — your account will be created automatically.