{"repo":"droher/boxball","free":true,"listed":false,"github":"https://github.com/droher/boxball","clone":"git clone https://github.com/droher/boxball.git","description":"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.","language":"Python","stars":132,"topics":["retrosheet","docker","postgres","sql","baseball","sports","sqlite","mysql","column-store","postgresql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Update : I have released a new project, baseball.computer, which is designed as the successor to boxball. It is much easier to use (no Docker required, runs entirely in your browser/program) and includes many more tables, features, and quality controls. The event schema is different, which will be the main migration pain point. I aim to continue Boxball maintenence and updates as long as people are still using it, and I may try to rebase boxball on top of the new project to make maintaining both easier. Please let me know if there are things you can do in Boxball that you can't do yet in baseball.computer by filing an issue on the repo or reaching me at david.roher@baseball.computer. Introduction Boxball creates prepopulated databases of the two most significant open source baseball datasets: Retrosheet and the Baseball Databank. Retrosheet contains information on every major-league pitch since 2000, every play since 1928, every box score since 1901, and every game since 1871. The Databank (based on the Lahman Database) contains yearly summaries for every player and team in history. In addition to the data and databases themselves, Boxball relies on the following tools: Docker for repeatable builds and easy distribution SQLAlchemy for abstracting away DDL differences between databases Chadwick for translating Retrosheet's complex event files into a relational format Follow the instructions below to install your distribution of choice. The full set of images is also available ","default_branch":null,"files":null,"tree":[],"storefront":"/r/droher","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/droher/boxball/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}