What

This is a follow up to the Pinochet-Rettig post. I've learned a lot since then and I wanted to revisit the dataset with a more robust approach. I was motivated also by the conmemoration of the 50th anniversary of the coup d'etat in Chile.

The project highlights and contributions as of now are:

• dbt documentation
• Elementary Report using Elementary
• FastAPI Docs hosted on fly.io
• Graphql endpoint using strawberry-graphql

I'm using dbt to transform the data and expose it as a REST API using FastAPI with a GraphQL layer, as well as a semantic layer for running SPARQL queries. I'm also serving the api using fly.io, which is a really cool service that is not charging me anything for this project (bills below USD 5 monthly are 100% free as of now).

The data is stored in a Postgres database with postgis, and everything is running in Docker containers.

Make sure to visit the Github repo and its README for more details.

I wish I had more time to work on this, but I'm happy with the results so far. Let me know if you want to contribute!