hkjc_track_conditions
Hong Kong racecourse penetrometer and hammer readings
Download a file
CSV · Excel · Parquet · JSON. Filtered exports.
See pricingQuery with SQL
DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.
Open connection detailsConnect to AI
MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.
See setupTrack condition readings (penetrometer and hammer) for Hong Kong racecourses. Use this to analyze ground conditions and their correlation with race outcomes. Penetrometer readings indicate turf softness; hammer readings measure firmness. One row per meeting date and venue (readings are taken once per meeting).
Evaluate it in full below: the evidence and a working sample are open to everyone. Buy or subscribe to unlock the complete dataset — your account is created automatically at checkout.
The evidence
Schema & column quality (11 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| race_date | DateTime | Date of the race meeting | — | — |
| venue_code | String | Venue code (ST=Sha Tin, HV=Happy Valley) | — | — |
| race_year | UInt16 | Year of the meeting | — | — |
| race_month | UInt8 | Month of the meeting (1-12) | — | — |
| penetrometer_reading | Nullable(Float64) | Penetrometer reading measuring turf softness (higher = softer) | — | — |
| penetrometer_reading_time | Nullable(DateTime) | Time when penetrometer reading was taken | — | — |
| hammer_reading | Nullable(Float64) | Hammer reading measuring turf firmness | — | — |
| hammer_reading_time | Nullable(DateTime) | Time when hammer reading was taken | — | — |
| track_category | String | Derived track classification (Firm/Good/Good to Soft/Soft/Unknown) | — | — |
| updated_at | DateTime | Timestamp when record was last scraped | — | — |
| id | String | 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. | — | — |
Last 12 months of track condition reports, full schema. Going codes, weather, and sectional pace data per race meeting.
Choose your access
A Pass gives you freshness within a rolling window. The Full Archive gives you the full history we hold for the dataset, frozen at purchase. They solve different problems, and they work together.
One-off purchase
Full Archive
The full history we hold, frozen at purchase. Yours to keep.
Full details →- What you get
- The full history we hold, to your purchase date
- History depth
- Jan 2026 – present, in full
- Updates
- None. Frozen at purchase
- Delivery
- Gzipped CSV, opens in Excel; link valid 7 days
- API access
- Not included
- Access window
- Most recent 24 months, rolling
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 1,000,000 rows/month included
Included Datasets
- Access window
- Most recent 24 months, rolling
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- Uncapped
Included Datasets
Get notified when this dataset is updated.
Questions about this data?
Our data experts are ready to help clarify any aspects of this dataset.
Contact Our Team