Making a Datasette out of Freebase species data

datasette-freebase-species.md

Making a Datasette out of Freebase species data

I stumbled across an old export of Freebase data we used to build WildlifeNearYou:

https://github.com/devfort/wildlifenearyou/blob/master/freebase_data/data/organism_classification.tsv

It's a 6.89MB TSV file. Here's how I turned it into a Datasette instance at https://organisms.now.sh/

cd /tmp
wget https://raw.githubusercontent.com/devfort/wildlifenearyou/master/freebase_data/data/organism_classification.tsv
csvs-to-sqlite organism_classification.tsv organisms.db -s $'\t' \
    -c rank -f name -f scientific_name -f higher_classification \
    -c higher_classification -f lower_classifications
datasette publish now organisms.db \
    --source_url=https://github.com/devfort/wildlifenearyou/tree/master/freebase_data/data \
    --source=Freebase \
    --license="CC-BY" \
    --license_url="https://creativecommons.org/licenses/by/2.5/" \
    --title="Organisms and Species"