Racing data
HKJC Race Catalog
HKJC Race Catalog holds 31,234 races from the Hong Kong Jockey Club's published race cards, covering May 1977 to November 2026, and is updated hourly.
Hong Kong horse race specifications and historical archive
hkjc_races
Races
31,234
Coverage
May 1977 to November 2026
Columns
28
Latest data
2026-11-14
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_20261114_R01 | 2026-11-14 00:00:00 | ST | Sha Tin | 1 | PANASONIC WATER DISPENSER HANDICAP | 1200 | Class 4 (Restricted) | GOOD TO YIELDING | 2026-11-14 04:30:00 | 14 | 14 | H | RESULT | Sprint | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=01&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | 2026-11-14 22:10:54 | 8c115f7b61faa074857082b673971e62 | |
| ST_20261114_R02 | 2026-11-14 00:00:00 | ST | Sha Tin | 2 | PANASONIC TV HANDICAP | 1400 | Class 5 | GOOD TO YIELDING | 2026-11-14 05:00:00 | 14 | 14 | H | RESULT | Mile | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=02&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=02&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=2 | 2026-11-14 22:10:54 | 9907690dd6d7e56ac5273446f11f2a82 | |
| ST_20261114_R03 | 2026-11-14 00:00:00 | ST | Sha Tin | 3 | PANASHOP HANDICAP | 1650 | Class 5 | WET SLOW | 2026-11-14 05:55:00 | 14 | 13 | H | RESULT | Mile | Wet | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=03&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=03&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=3 | 2026-11-14 22:10:54 | b448effce958e66aa9cbf010e1b8882e | |
| ST_20261114_R04 | 2026-11-14 00:00:00 | ST | Sha Tin | 4 | PANASONIC AIR-CONDITIONER HANDICAP | 2000 | Class 4 | GOOD TO YIELDING | 2026-11-14 06:25:00 | 14 | 14 | H | RESULT | Middle | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=04&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=04&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=4 | 2026-11-14 22:10:54 | 425100adbaa3e3c785af425c7edebfab | |
| ST_20261114_R05 | 2026-11-14 00:00:00 | ST | Sha Tin | 5 | PANASONIC RICE COOKER HANDICAP | 1000 | Class 3 | GOOD TO YIELDING | 2026-11-14 07:00:00 | 14 | 14 | H | RESULT | Sprint | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=05&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=05&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=5 | 2026-11-14 22:10:54 | 54b6635e52335fe22012e03b47e6919c | |
| ST_20261114_R06 | 2026-11-14 00:00:00 | ST | Sha Tin | 6 | PANASONIC NANOE HAIR DRYER HANDICAP | 1650 | Class 4 | 2026-11-14 07:25:00 | 14 | 16 | H | ABANDONED | Mile | 2026 | 11 | 1 | 2.73 | 6.15 | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=6 | 2026-11-14 22:10:54 | 96b9c05d43721237133ea433811ab56c | |||||
| ST_20261114_R07 | 2026-11-14 00:00:00 | ST | Sha Tin | 7 | THE PANASONIC CUP (HANDICAP) | 1200 | Class 2 | GOOD TO YIELDING | 2026-11-14 08:00:00 | 14 | 13 | H | RESULT | Sprint | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=07&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=07&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=7 | 2026-11-14 22:10:54 | 89d51cbc32d212ffd3239c0797243978 | |
| ST_20261114_R08 | 2026-11-14 00:00:00 | ST | Sha Tin | 8 | PANASONIC IH COOKER HANDICAP | 1200 | Class 4 | GOOD | 2026-11-14 08:35:00 | 14 | 14 | H | RESULT | Sprint | Good | 2026 | 11 | 1 | 2.73 | 6.15 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=08&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=passthrough&date=20261114&no=08&lang=eng&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | https://info.cld.hkjc.com/graphql/base/ | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=8 | 2026-11-14 22:10:54 | c86667b1b197d0a9f5adaf8c8496b0b9 |
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 as HKJC publishes it: DECLARED (card out, not yet run), CLOSED (betting closed, not yet resulted), RESULT (official result) or ABANDONED (race abandoned and not run to a result) |
| 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 10
Ways 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 sampleRacing Pass Pro
A rolling 24-month window, currently from November 2024with 13 other tables
US$1,490/yr
billed yearly · or US$149/mo Racing Pass Pro
Subscribe to Racing Pass ProPrices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.