Visualizing UK Environment Agency Flood Data with DuckDB and Rill

This post details the author's experience visualizing UK Environment Agency flood and river level data using DuckDB and Rill. The author efficiently loaded JSON data from the agency's API into DuckDB, using `read_json` and `UNNEST` functions to handle nested JSON structures. Challenges with API data limits and nested JSON were overcome. Rill provided an intuitive and fast way to visualize the data, leading to a dashboard displaying hourly water levels. The process highlighted the power of DuckDB for rapid data ingestion and prototyping, and Rill for quick data exploration and visualization.