A generous amount of crossing safety information has been published by Network Rail in an Open Data JSON. This project is an exploration of the data available, focused on making it accessible.

The JSON has several embedded arrays, each reflecting a different many-to-many relationship.

The initial processing was completed in python using the powerful functions of its pandas library, json_normalize and explode.

The data was then cleaned in Google Sheets. The data isn't perfect, find out more. It was then normalized into the appropriate tables and saved in csv.

A dedicated instance was then established on Google Cloud SQL for MySQL, and a database created with the csv data uploaded via Cloud Storage Buckets.

Finally, a Looker Studio report was built using the GCP MySQL connector.

It currently addresses Protection Arrangements and Risk Scores. More visualizations will be added soon.