Contains info of a value and what currency it is. The sum in a certain currency The currency Date contains info about a date Year Month Day st:DateTime contains info about date and time The dateobject The timeobject st:Time contains info about time Hour Minute Second Tenth st:KmTime contains info about kmTime CodeText contains Text in 3 diffrent ways: as a code, as domestic text and as an english text The Code for the text The text The english text Identifies a track. Sportsystem id Shoeinformation for the horse in the race. Shows if the horse wore foreshoes in the race, (front). Shows if the horse wore hindshoes in the race, (back). Sulkyinformation for the horse in the race. Sulky type code. Sulky type colour code Sulky type short name Sulky type name The breeder/owner of the horse. Name of the breeder ID of the breeder City of residence of the breeder Contains information about a LicenceOwner Forename Surname Short version of the name Driver initials Id of the driver Licence owner's sex. Trotting or galopp Is the driver amateur Is driver swedish Shows if a driver is an apprentice for a professional trainer. Shows if a driver is an apprentice for an amateur trainer. Shows the statistics for the licence owner's monte races. ResultRow holds information about a horse performance in a race. Key information about a race. Row number for the horse in the race. Starting number for the horse in the race. Starting ID for the horse in the race. Startpoint for the horse in the race. Information regarding the place in the race result. Information about circumstances regarding the horse and the race. First prize in the race. Amount that the horse won in the race. Driver information, (jockey included). Identification info for the horse Name. Swedish registration number. Empty if unknown in the swedish system. UELN number. Empty if unknown in the swedish system. Identification number. Zero if unknown in the swedish system. Key information about a race. Date. Identifies a track. Track. Race number. Track. Shows if the race has a result. Information regarding the place in the race result. Place in the race. Shows if the horse was reported, (poor trotting). Shows if the horse was disqualified. Shows if the horse was scratched. If the horse was scratched, the reason why. If the horse did not finish the race. information about circumstances regarding the horse and the race. Race distance. Starting lane for the horse in the race. Shows if the race was a monte race. The state of the track during the race. Shoeinformation for the horse in the race. Shoeinformation for the horse in the race. If the horse was favourite. The terms to be met for the horse to qualify for the race. Minimum age to participate in the race. Maximum age to participate in the race. Minimum earnings to participate in the race. Maximum earnings to participate in the race. Information about the handicap in the race regarding the horses age. Ex 20 m added for horses 4 year old. Information about the handicap in the race regarding the horses price money. Ex 20 m added for horses with over 20000 kr earned. The sums of money for each place in the race. Which genders can participate in the race. If the race contains under aged driver. Information available if the race was a thouroughbred race. Rating number describing the horses form, the higher the better. Weight carried by the horse in the race. Shows the type of blinkers the horse is going to use in the race. Possible values are: B = Blinkers, F = Flexible bridle, S = Soft bridle, N = Nothing. Can be null. The type of surface of the track, (ex dirt, grass). Information about the handicap in the race regarding the horses age. The min age of the horse. The max age of the horse. Number of meters. Information about the handicap in the race regarding the horses price money. Sum of money. Number of meters. Information regarding the prizes in the race. Place in the race. The prize money. YearStat holds a specific year or life total achievements, (wins, places, earnings). Number of starts this year. Number of times disqualified this year. Number of times unplaced this year. Nr of times as winner. Nr of times as runner up. Nr of times the horse came in third place. Nr of times the horse came in forth place. Nr of times the horse came in fifth place. Earned money this year. Forced amount added to earning. Only trav/harness racing. Bonus amount added to earning. Only gallop/thoroughbread. Record for the year with the starting method American Auto regardless distance, (start behind the gate, 1609 m track length). Note that the information about track is missing. Only trav/harness racing. Record for the year with the starting method Volt regardless distance, (circular starting method without car). Note that the information about track is missing. Only trav/harness racing. Record for the year with the starting method Auto regardless distance, (start behind the gate, 1000 m track length). Note that the information about track is missing. Only trav/harness racing. The fastest time the horse has run on a sepcific distance and starting method. Record date. The track where the record was set. Race number for the race in which the record was set. Record time. The records distance. Type of record. Place for the the horse in the record race. Shows if the horse won when setting the record. The weigth a horse will be carrying in a thoroughbred race. Swedish programvikt. Swedish propositionsvikt. Swedish term. Swedish term. Swedish term.