Database for HK racing

This project was successfully completed by nekhbet for $147 USD in 3 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
Project Description

I would like someone to write python code to screen scrape data from the [url removed, login to view] website. Sorry for the abrupt nature of the instructions below. It was for internal use only.

Hong Kong Racing Database Spec

We want a database for Hong Kong racing. Full data goes back to 2008-2009 season. They generally race two days a week. Do it in sqlite3. It is on python already by default. Please comment all code

1. Need 2 tables in database.



RaceID, Place, HorseNumber, HorseName, HorseID, JockeyName, JockeyID, TrainerName, TrainerID, ActualWeight, DeclaredWeight, Draw, FinishTime, WinOdds, Gear, 1stSectPos, 1stSectDist, 2ndSectPos, 2ndSectDist, 3rdSectPos, 3rdSectDist, 4thSectPos, 4thSectDist, 5thSectPos, 5thSectDist, 6thSectPos, 6thSectDist



RaceID, RaceNumber, Date, CourseName, Class, Distance, PrizeMoney, Going, CourseDescription, SectTime1, SectTime2, SectTime3, SectTime4, SectTime5, SectTime6

Add anything else to fields you think we might need?

2. Need Python code to setup database (sqlite3 example)

import sqlite3

# set up new database

conn = [url removed, login to view]("D:\bf_only_soccer\[url removed, login to view]")

conn.text_factory = str

cur = [url removed, login to view]()

# create new table

[url removed, login to view]("CREATE TABLE main(event_id INT, HL FLOAT, HB FLOAT, AL FLOAT, AB FLOAT)")

# insert string of values 'x' into table

[url removed, login to view]("INSERT INTO main VALUES (?,?,?,?,?);", x)

3. Need Python code to screen scrape all historical data from

[url removed, login to view]

[url removed, login to view]

4. Need Python code that will automatically update database after each new race

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online