賽馬數據
HKJC Track Conditions
Hong Kong racecourse penetrometer and hammer readings
hkjc_track_conditions
行數
56
涵蓋期間
2026年1月至2026年10月
欄位數目
11
最新數據
2026-10-01
樣本
| race_date | venue_code | race_year | race_month | penetrometer_reading | penetrometer_reading_time | hammer_reading | hammer_reading_time | track_category | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-01 00:00:00 | ST | 2026 | 10 | 2.71 | 2026-10-01 04:00:00 | — | — | Good | 2026-10-01 11:20:07 | 13cd43ecc70cec402b722d7c80c0e7e3 |
| 2026-09-27 00:00:00 | ST | 2026 | 9 | 2.71 | 2026-09-27 03:45:00 | 9.13 | 2026-09-27 03:45:00 | Good | 2026-09-27 14:30:06 | b0f5f89dd7140f158e7ff191120cc061 |
| 2026-09-23 00:00:00 | HV | 2026 | 9 | 2.7199999999999998 | 2026-09-23 09:40:00 | — | — | Good | 2026-09-23 14:30:42 | 188c6e715d04368636fb7458d8b6f0d8 |
| 2026-09-16 00:00:00 | HV | 2026 | 9 | 2.7199999999999998 | 2026-09-16 10:10:00 | — | — | Good | 2026-09-16 15:11:35 | 2bbe1a85e7cebbb5c4540f65b71ef95f |
| 2026-09-13 00:00:00 | ST | 2026 | 9 | 2.71 | 2026-09-13 04:00:00 | — | — | Good | 2026-09-13 17:01:30 | 640d906a98e09c26116e4dcbe597e435 |
| 2026-09-09 00:00:00 | HV | 2026 | 9 | 2.7199999999999998 | 2026-09-09 10:05:00 | — | — | Good | 2026-09-09 15:06:17 | f58d9ab9f332ee904dcb4a6d293a61a8 |
| 2026-09-06 00:00:00 | ST | 2026 | 9 | 2.71 | 2026-09-06 03:30:00 | — | — | Good | 2026-09-06 15:10:06 | 92e48fabbb8b0c7e3c3efadc3a04da91 |
| 2026-07-15 00:00:00 | HV | 2026 | 7 | 2.73 | 2026-07-15 09:30:00 | — | — | Good | 2026-07-15 14:51:29 | b5dbd8a8f8c134a41e4253d67585d9c3 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| race_date | date and time | Date of the race meeting |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| race_year | number | Year of the meeting |
| race_month | number | Month of the meeting (1-12) |
| penetrometer_reading | number | Penetrometer reading measuring turf softness (higher = softer) |
| penetrometer_reading_time | date and time | Time when penetrometer reading was taken |
| hammer_reading | number | Hammer reading measuring turf firmness |
| hammer_reading_time | date and time | Time when hammer reading was taken |
| track_category | text | Derived track classification (Firm/Good/Good to Soft/Soft/Unknown) |
| updated_at | date and time | Timestamp when record was last scraped |
| 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_track_conditions LIMIT 10取得此數據表的方式
免費樣本
Last 12 months of track condition reports, full schema. Going codes, weather, and sectional pace data per race meeting.
免費
下載樣本