Reactive
Build your app
Catalog ›Public data ›Your municipality in numbers — a portrait from official data › The map

The map

Part of the Your municipality in numbers

The same Italy seen from above: each region coloured by average declared income. Hover for the value.

▶ Use this app

data space «comune-in-cifre» — this micro app reads and writes the suite’s shared data space.

The other micro apps in the same suite

🔎Your municipality🏫The schools🏆Rankings

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.

  1. Use it right away. Hit “Use this app”: it opens right in your browser, ready to go, with data saved only on your device.
  2. Your data stays yours. Everything is stored locally on your device, kept separate for each app: no account, no server, nothing to set up.
  3. Make it your own. The text below is the entire app: copy it, tweak fields, views and words, and your changes become interactive instantly.
  4. 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

## Average income by region

The same Italy seen from above: each region coloured by average declared
income. Hover for the value.

::od-query{into="mappa" sql="SELECT r.regione AS regione, r.geojson AS geojson, m.reddito AS reddito FROM istat_confini_regioni r JOIN (SELECT c.cod_reg, round(sum(x.reddito_complessivo) / sum(x.dichiaranti)) AS reddito FROM istat_confini_comuni c JOIN mef_redditi x ON x.codice_istat = c.codice_istat GROUP BY c.cod_reg) m ON m.cod_reg = r.cod_reg" limit="30"}

:::map{path="mappa" geojson="geojson" fill="reddito" height="30rem"}
**{regione}** — average income {reddito} €
:::

The colour runs from light (lower incomes) to dark (higher): the classic
North-South divide, in a map that draws itself from the data.