In Progress

Basketball Play-By-Play Database

I would like somebody to write a program that can parse [url removed, login to view]'s basketball play-by-play summaries into a database. I am open to parsing other sites (cbs, yahoo, etc) if they are easier to work with - as long as the data quality and data history is the same or better.

I would prefer if the program is written in Java along with SQL Server 2005 (although MySQL is fine as well). C# and Perl are also acceptable, although I would need more help setting those up on my machine.

As far as the database is concerned, I would like to be able to run fairly complex queries on the dataset - the more that can be defined on each play, the better. I put together a spreadsheet that gives you a rough idea of what I'm looking for. I didn't put a lot of thought into it, so feel free to propose a better scehma. I would say that I'm leaning toward a more compact setup as opposed to lots of connecting tables for simple queries.

I would like to be able to calculate +/- stats easily. That is, I'd like to be able to calculate what players are on the floor whenever either team scores. Any schema that makes this easier to do would be ideal. I would like the database to be loaded with stats going back through all years available on ESPN's website.

Here's an example box score :

[url removed, login to view]

I've attached an excel document with one version of how one might populate a simple one-table schema.

I'd like this project to be completed by Friday, November 20th.

Skills: C# Programming, Java, Perl, SQL

See more: basketball sql database, basketball stats database schema, sql basketball database, basketball play database schema, sql basketball database schema, play java basketball, basketball program, sql database basketball, basketball database sql, sql basketball, spreadsheet basketball stats, play i, need write play, propose project, program website java, free excel help, connecting mysql database, basketball stats excel spreadsheet, database sql basketball, basketball spreadsheet database, database basketball project, dataset basketball box scores, play, nba, java play

About the Employer:
( 0 reviews ) New York, United States

Project ID: #550065

Awarded to:

nitetalk

Please see PMB for details.

$50 USD in 2 days
(0 Reviews)
0.0

10 freelancers are bidding on average $145 for this job

gangabass

I can do this job for you. See PM for details.

$130 USD in 4 days
(148 Reviews)
5.9
Blashyrkh888

Hi! Please read your PMB.

$220 USD in 7 days
(5 Reviews)
3.1
quincyj

Hello. I can do what you have specified. I will PM you

$200 USD in 7 days
(0 Reviews)
0.0
alibz

I can do this for you. I use java and mysql az my database.

$200 USD in 7 days
(0 Reviews)
0.0
tipsoft

please check your PMB

$190 USD in 10 days
(0 Reviews)
0.0
CaaamSoftware

Quality work. Proven experience.

$150 USD in 7 days
(0 Reviews)
1.8
TBUTech

I can do it cheaply, since I need rating

$30 USD in 3 days
(0 Reviews)
0.0
indiman

From what you have mentioned I should be able to do this. I will use Java and MySQL from my side. Also can you provide more information on this.

$150 USD in 5 days
(0 Reviews)
0.0
stephenlance

Please see my PM.

$125 USD in 3 days
(0 Reviews)
0.0