cboettig/fishbase

该数据集是FishBase数据表的快照，用于rOpenSci包`rfishbase`和FishBase API。数据集由Carl Boettiger整理，许可证为CC-BY-NC。数据来源是FishBase和SeaLifeBase的后端MySQL数据库的独家导出。数据集的主要用途是通过`rfishbase`访问FishBase统计数据，但不允许用于商业应用。数据集的结构是来自MySQL数据库后端的原始CSV和parquet导出，数据表结构可能不直观，通常需要跨多个表进行连接。数据集的创建过程涉及将FishBase团队提供的MySQL转储导入到Docker中的MySQL服务器，然后使用`duckdb`的`mysql`扩展导出为parquet和CSV格式。

The FishBase dataset contains snapshots of the MySQL database backend of FishBase and SeaLifeBase, primarily used to support the rOpenSci package `rfishbase` and the FishBase API. The dataset is curated by Carl Boettiger and includes raw CSV and parquet format exports from the MySQL database backend. The dataset structure is complex, containing multiple tables that have evolved over decades and were not designed for direct access. The creation of the dataset relies on an annual MySQL dump from the FishBase team, which is imported into a MySQL server and then exported as parquet and csv using the `creation.py` script.