Skip to content

HKJC Guru is an independent statistics service and is not affiliated with, endorsed by, or connected to The Hong Kong Jockey Club.

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

8 rows shown
HKJC Race Catalog: Sample
race_idrace_datevenue_codevenuerace_numberracenamedistancerace_classtrack_goingpost_timefield_sizefield_size_effectiverating_typerace_statusdistance_categorytrack_condition_categoryrace_yearrace_monthdays_since_racepenetrometer_readinghammer_readingvideo_replay_urlpass_through_urlaerial_replay_urlsource_urlrace_urlupdated_atid
ST_20261114_R012026-11-14 00:00:00STSha Tin1PANASONIC WATER DISPENSER HANDICAP1200Class 4 (Restricted)GOOD TO YIELDING2026-11-14 04:30:001414HRESULTSprintGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=12026-11-14 22:10:548c115f7b61faa074857082b673971e62
ST_20261114_R022026-11-14 00:00:00STSha Tin2PANASONIC TV HANDICAP1400Class 5GOOD TO YIELDING2026-11-14 05:00:001414HRESULTMileGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=22026-11-14 22:10:549907690dd6d7e56ac5273446f11f2a82
ST_20261114_R032026-11-14 00:00:00STSha Tin3PANASHOP HANDICAP1650Class 5WET SLOW2026-11-14 05:55:001413HRESULTMileWet20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=32026-11-14 22:10:54b448effce958e66aa9cbf010e1b8882e
ST_20261114_R042026-11-14 00:00:00STSha Tin4PANASONIC AIR-CONDITIONER HANDICAP2000Class 4GOOD TO YIELDING2026-11-14 06:25:001414HRESULTMiddleGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=42026-11-14 22:10:54425100adbaa3e3c785af425c7edebfab
ST_20261114_R052026-11-14 00:00:00STSha Tin5PANASONIC RICE COOKER HANDICAP1000Class 3GOOD TO YIELDING2026-11-14 07:00:001414HRESULTSprintGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=52026-11-14 22:10:5454b6635e52335fe22012e03b47e6919c
ST_20261114_R062026-11-14 00:00:00STSha Tin6PANASONIC NANOE HAIR DRYER HANDICAP1650Class 42026-11-14 07:25:001416HABANDONEDMile20261112.736.15https://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=62026-11-14 22:10:5496b9c05d43721237133ea433811ab56c
ST_20261114_R072026-11-14 00:00:00STSha Tin7THE PANASONIC CUP (HANDICAP)1200Class 2GOOD TO YIELDING2026-11-14 08:00:001413HRESULTSprintGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=72026-11-14 22:10:5489d51cbc32d212ffd3239c0797243978
ST_20261114_R082026-11-14 00:00:00STSha Tin8PANASONIC IH COOKER HANDICAP1200Class 4GOOD2026-11-14 08:35:001414HRESULTSprintGood20261112.736.15https://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/localhttps://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/localhttps://info.cld.hkjc.com/graphql/base/https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=82026-11-14 22:10:54c86667b1b197d0a9f5adaf8c8496b0b9

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

28
HKJC Race Catalog: 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

Get a key on renavon.com (opens in new tab)

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 sample

One-off archive

7 May 1977 to present · does not update

US$149

Buy the archive Race Specifications

Racing 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 Pro

Prices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.

See all pricing