Completed

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
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
5
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.
HorseTable
Fields:
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
RaceTable
Fields:
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

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