Racing data
HKJC Race Catalog
Hong Kong horse race specifications and historical archive
hkjc_races
Rows
31,104
Coverage
May 1977 to October 2026
Columns
28
Latest data
2026-10-01
Sample
| race_id | race_date | venue_code | venue | race_number | racename | distance | race_class | track_going | post_time | field_size | field_size_effective | rating_type | race_status | distance_category | track_condition_category | race_year | race_month | days_since_race | penetrometer_reading | hammer_reading | video_replay_url | pass_through_url | aerial_replay_url | source_url | race_url | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | NANNING HANDICAP | 1200 | Class 5 | GOOD TO FIRM | 2026-10-01 05:00:00 | 14 | 14 | H | RESULT | Sprint | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | 2026-10-01 11:20:07 | 3bce17c60d304c69090e2de633523c88 | ||
| ST_20261001_R02 | 2026-10-01 00:00:00 | ST | Sha Tin | 2 | SHENYANG HANDICAP | 1600 | Class 5 | GOOD TO FIRM | 2026-10-01 05:30:00 | 14 | 14 | H | RESULT | Mile | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=02&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=2 | 2026-10-01 11:20:07 | a69a1dc8b83d9530c74317df2160a79c | ||
| ST_20261001_R03 | 2026-10-01 00:00:00 | ST | Sha Tin | 3 | THE NATIONAL DAY CUP (HANDICAP) | 1000 | Group 3 | GOOD TO FIRM | 2026-10-01 06:00:00 | 8 | 8 | H | RESULT | Sprint | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=03&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=3 | 2026-10-01 11:20:07 | eba01b4e70321074676622be439bf6ff | ||
| ST_20261001_R04 | 2026-10-01 00:00:00 | ST | Sha Tin | 4 | CHENGDU HANDICAP | 1400 | Class 4 | GOOD TO FIRM | 2026-10-01 06:35:00 | 14 | 14 | H | RESULT | Mile | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=04&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=4 | 2026-10-01 11:20:07 | 4bf5ff8a7b7701d387982e4b24ff9202 | ||
| ST_20261001_R05 | 2026-10-01 00:00:00 | ST | Sha Tin | 5 | HANGZHOU HANDICAP | 1000 | Class 4 | GOOD TO FIRM | 2026-10-01 07:10:00 | 14 | 14 | H | RESULT | Sprint | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=05&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=5 | 2026-10-01 11:20:07 | 33a2048f45e4e5ded544c62c2d7577fe | ||
| ST_20261001_R06 | 2026-10-01 00:00:00 | ST | Sha Tin | 6 | JINAN HANDICAP | 1800 | Class 4 | GOOD TO FIRM | 2026-10-01 07:45:00 | 14 | 14 | H | RESULT | Middle | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=06&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=6 | 2026-10-01 11:20:07 | 4958c2856cfb6f1331e0ba7e173cedf7 | ||
| ST_20261001_R07 | 2026-10-01 00:00:00 | ST | Sha Tin | 7 | CHONGQING HANDICAP | 1200 | Class 4 | GOOD TO FIRM | 2026-10-01 08:15:00 | 14 | 14 | H | RESULT | Sprint | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=07&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=7 | 2026-10-01 11:20:07 | 0fb6fb05b172c2f945c21ac42a1d5d6f | ||
| ST_20261001_R08 | 2026-10-01 00:00:00 | ST | Sha Tin | 8 | CHONGQING HANDICAP | 1200 | Class 4 | GOOD TO FIRM | 2026-10-01 08:45:00 | 14 | 14 | H | RESULT | Sprint | Firm | 2026 | 10 | 0 | 2.71 | — | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=08&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=8 | 2026-10-01 11:20:07 | dc934d64ac4462f8801aeede00ea8c61 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| race_id | text | Unique race identifier (format: ST_20250928_R01) |
| race_date | date and time | Date of the race (YYYY-MM-DD) |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| venue | text | Full venue name (Sha Tin / Happy Valley) |
| race_number | number | Race number within the meeting (1-11) |
| racename | text | Official race name (e.g., 'FAT CHOI HANDICAP') |
| distance | number | Race distance in meters (1000-2400m typical) |
| race_class | text | Race class (Class 1-5, Group One/Two/Three, Griffin, etc.) |
| track_going | text | Official track condition (Good to Firm, Good, Yielding, etc.) |
| post_time | date and time | Scheduled race start time |
| field_size | number | Number of horses in the race (1-14 typical) |
| field_size_effective | number | Effective (starting) field size — distinct horses that actually started, i.e. field_size minus scratchings, withdrawals and non-runners |
| rating_type | text | Rating band for the race (H=Handicap, I=International) |
| race_status | text | Race status (completed, cancelled, etc.) |
| distance_category | text | Distance grouping for easy filtering: Sprint (1000-1200m), Mile (1400-1650m), Middle (1800-2000m), Long (2200m+) |
| track_condition_category | text | Simplified track condition grouping (Firm, Good, Soft, etc.) |
| race_year | number | Year of the race for grouping |
| race_month | number | Month of the race (1-12) |
| days_since_race | number | Days since this race was run (for recency filtering) |
| penetrometer_reading | number | Penetrometer reading measuring turf softness (higher = softer ground). Available for races from late 2024. |
| hammer_reading | number | Hammer reading measuring turf firmness. Available for races from late 2024. |
| video_replay_url | text | Direct URL to watch the race video replay |
| pass_through_url | text | URL for pass-through camera angle (if available) |
| aerial_replay_url | text | URL for aerial camera angle (if available) |
| source_url | text | Original source URL for the race data |
| race_url | text | HKJC race page URL |
| updated_at | date and time | Timestamp when record was last updated |
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_races LIMIT 10Ways to get this table
Free sample
Last 12 months of race meetings, full schema, no row cap. Use this to evaluate column coverage and update cadence before subscribing or buying the snapshot.
Free
Download the sampleOne-off archive
7 May 1977 to present · does not update
$99
Buy the archive Race Specifications (opens in new tab)Racing Pass Starter
A rolling 24-month window, currently from October 2024with 5 other tables
$49/mo
Subscribe to Racing Pass Starter (opens in new tab)