Project Description
[SPASSWORD: OVERTIME] – Bids that do not start with this word will be ignored.
I am looking for a professional developer to build a single, self-contained database that cleanly stores regulation-time box scores for six leagues: NFL, NHL, MLB, NBA, Men’s NCAA Division I Football, and Men’s NCAA Division I Basketball.
THE SCOPE:
This is a one-off historical build, not an ongoing scraper. Once delivered, I should be able to drop the file (SQLite) onto any machine and start running SQL queries without additional configuration.
DATA NEEDED :
No overtime or shoot-out data. Only regulation play:
MLB: 9 Innings
NFL/NBA/NCAA: 4 Quarters
NHL: 3 Periods
Ignore all OT/extra innings etc
We only need to search MLB Box Scores beginning April 2023
Search all the other sports from the beginning of the 2021 regular season
No post season data required for any of the sports
ROBUST SEARCH REQUIREMENTS
The schema must be normalized and powerful enough to handle complex, multi-variable logic.
Here are just a few examples of the types of queries I will run:
NFL: Provide box scores of games where the Home Team scored ZERO Touchdowns in the first half Provide box scores of games where one team scored more than 2 TD's in 1st Qtr
MLB: Provide box scores of games where >2 runs were scored in the Top of the 4th, exactly 0 in the 5th, and exactly 1 in the Bottom of the 6th.
NBA: Games where over 60 pts combined were scored in Q3 but less than 40 in Q4
Etc..
The Database: A single SQLite (.db) file fully populated with regulation box scores (MLB from April 2023; others covering the last 5 years).
The Schema: A clear, normalized structure capturing team totals and period/inning splits.
The Instructions: A concise import script or step-by-step guide showing how you populated the data so I can repeat the process for future seasons if desired.
Zero Install: No Microsoft .NET, SQL Server, or heavy frameworks. Just the database file and the SQL documentation.