Name: Hong Kong Horse Races From 2013 To 2020
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

Hong Kong Horse Races From 2013 To 2020

Context

I'm sharing my work started few months ago on gathering data about Hong Kong horse races. The initial goal was to perform quantitative analysis over this dataset. I'm convinced we will be stronger together than me alone, so let's share our ideas around this. 😄

Content

`races.csv`

This CSV data file describes each races that had happened in Hong Kong (only Sha Tin and Happy Valley racecourses have been taken into account here).

Features will be described soon.

`performance.csv`

This CSV data file describes each horses performance within a race.

Features will be described soon.

What next?

I extracted some more data locally that I need to process and format as CSV. This includes:

Horse information (age, color, origin, sex, sire, ...) ;
Gear that has been used on a horse within a race ;
Horse trackwork ;
Horse veterinary details ;
Weather ;
...

I will update the dataset from time to time if this interested some people around!

Tables

Performances

@kaggle.jeffreymuller_hong_kong_horse_races_from_2013_to_2020.performances

1.63 MB
80,320 rows
17 columns

CREATE TABLE performances (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "horse_id" BIGINT,
  "race_id" BIGINT,
  "jockey_id" DOUBLE,
  "trainer_id" DOUBLE,
  "place" DOUBLE,
  "number" DOUBLE,
  "draw" DOUBLE,
  "actual_weight" BIGINT,
  "declared_weight" DOUBLE,
  "win_odds" DOUBLE,
  "finish_time" VARCHAR,
  "won" DOUBLE,
  "win_dividend" DOUBLE,
  "place_dividend" DOUBLE,
  "tips_index1" DOUBLE,
  "tips_index2" DOUBLE
);

Races

@kaggle.jeffreymuller_hong_kong_horse_races_from_2013_to_2020.races

191.31 kB
6,361 rows
11 columns

CREATE TABLE races (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "date" TIMESTAMP,
  "race_no" BIGINT,
  "location" VARCHAR,
  "horse_class" VARCHAR,
  "distance" BIGINT,
  "track_condition" VARCHAR,
  "track_type" VARCHAR,
  "prize_money" BIGINT,
  "section_time" VARCHAR
);