The map
Part of the Workplace safety
Each province colored by **injuries per 1,000 inhabitants** (2024): the numerator is INAIL, the denominator the ISTAT population. Hover for the value.
data space «sicurezza-lavoro» — this micro app reads and writes the suite’s shared data space.
The other micro apps in the same suite
How it works
This is a Reactive app: a plain text document that your browser turns into a working app — forms, live data, tables, statistics and even charts, with nothing to install or configure.
- Use it right away. Hit “Use this app”: it opens right in your browser, ready to go, with data saved only on your device.
- Your data stays yours. Everything is stored locally on your device, kept separate for each app: no account, no server, nothing to set up.
- Make it your own. The text below is the entire app: copy it, tweak fields, views and words, and your changes become interactive instantly.
- Share it as a file. An app is a simple file: save it, export it or share it with a link; and with encrypted collaboration several people edit the same data in real time.
The app’s source
# 🗺️ The map
## The injury rate, province by province
Each province colored by **injuries per 1,000 inhabitants** (2024): the
numerator is INAIL, the denominator the ISTAT population. Hover for the value.
::od-query{into="mappa" sql="SELECT p.provincia AS provincia, p.geojson AS geojson, t.tasso AS tasso FROM istat_confini_province p JOIN (SELECT i.sigla, round(1000.0 * sum(i.infortuni) / ab.pop, 1) AS tasso FROM inail_infortuni i JOIN (SELECT c.sigla, sum(po.popolazione) AS pop FROM istat_confini_comuni c JOIN istat_popolazione po ON po.codice_istat = c.codice_istat GROUP BY 1) ab ON ab.sigla = i.sigla WHERE i.anno = 2024 GROUP BY i.sigla, ab.pop) t ON t.sigla = p.sigla" limit="150"}
:::map{path="mappa" geojson="geojson" fill="tasso" height="28rem"}
**{provincia}** — {tasso} injuries per 1,000 inhabitants
:::
The rate per inhabitant (not per worker) is an indicator of *impact on the
territory*: manufacturing and agricultural provinces stand out.