賽馬數據
HKJC Race Catalog
Hong Kong horse race specifications and historical archive
hkjc_races
行數
31,104
涵蓋期間
1977年5月至2026年10月
欄位數目
28
最新數據
2026-10-01
樣本
| 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 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_races LIMIT 10取得此數據表的方式
免費樣本
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.
免費
下載樣本