droher / boxball

Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
Apache License 2.0
120 stars 16 forks source link

Update data to the Summer 2023 Release #68

Closed double-dose-larry closed 1 year ago

double-dose-larry commented 1 year ago

Hi,

Tom Thress recently announced the availability of the first semi-annual Summer 2023 Release.

https://www.retrosheet.org/june2023release.html

I was wondering if boxball can be updated to reflect the changes. Mainly, I'm interested in the new optional field, gametype, that's now included. It's been a real sore point for me to figure out based on game dates and what not.

A new info record type was introduced in 2023 describing the type of game.

info,gametype,regular

The possible types are:
regular
exhibition
preseason
allstar
playoff
worldseries
lcs
divisionseries
wildcard
championship

Thank you so much for putting this project together.

droher commented 1 year ago

Boxball relies on the Chadwick Bureau's retrosheet repo, which hasn't updated yet: https://github.com/chadwickbureau/retrosheet

I'll keep tabs on that and should be able to update soon after. However, you may end up being disappointed in the result, because new info fields in the raw data don't automatically end up in Chadwick's data outputs.

double-dose-larry commented 1 year ago

Dang it! I was so excited when I saw that. I'll go open an issue there and see if goes anywhere.

Well, in any case, thank you again for your efforts!

droher commented 1 year ago

I'm working on a project which will serve as the successor to Boxball (which will still be maintained) - here is a list of game IDs along with their game types. More to come, hope this is useful in the interim! game_types.csv

double-dose-larry commented 1 year ago

dude...

you're the man. this is great. I'm gonna close this issue out because this is exactly what I was looking for. Looking forward to your next project.