Skip to content

mek/retrosheet-schedules

Folders and files

NameName
Last commit message
Last commit date

Latest commit

author
Mat Kovach
Apr 28, 2024
ed0bbba · Apr 28, 2024

History

6 Commits
Apr 28, 2024
Apr 28, 2024
Apr 28, 2024
Apr 28, 2024
Apr 28, 2024
Apr 28, 2024

Repository files navigation

retrosheet-schedules

Various Bit of work wit the Retrosheet Schedule Dataset

Retrosheet has a done a usefull data about baseball, including play-by-play data, gamelogs, ejection logs, and schedules.

This report is a quick and easy way to grab and import the data files into a SQLite database.

I have create a setup script that will: Pull the zip files from 1877 - CURRENT_YEAR-1.

  • Unzip files the files.
  • Create an empty database using the sql file.
  • Load the csv files into the database.

The SQL file is very basic and should be easy to modify for use in any reasonable RMDBS out there.

The script should work on any reasonable compatible bourne shell. This means Linux and Mac users should be able to run the shell out of the box. Windows users will need to run WSL or install a UNIX-like subsystem.

I will be working on a Powershell script, but not at this time.

There script also assume you have the following in your PATH.

  • curl
  • unzip (that supports the -B command)
  • sqlite3

There are standard utilities that are generally installed by default on your Linux system, or can be installed with your package management tools (brew for MacOS as them all).

About

Various Bit of work wit the Retrosheet Schedule Dataset

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages