Cohesion funds
Part of the Public tenders in the open
Tenders are half the circle: the other half is the **projects financed** with cohesion funds (EU + national Development and Cohesion Fund) in the town set on the "By town" page — same ISTAT code.
data space «appalti-trasparenti-en» — 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
# 💶 Cohesion funds
## Who spends, not just who tenders
Tenders are half the circle: the other half is the **projects financed** with
cohesion funds (EU + national Development and Cohesion Fund) in the town set
on the "By town" page — same ISTAT code.
::od-query{into="fondiComune" sql="SELECT count(*) AS progetti, round(sum(finanz_totale_pubblico)) AS totale FROM opencoesione WHERE codice_istat = '{#comune}'"}
:::cards{path="fondiComune" search="false"}
💶 **{progetti}** financed projects, **€{totale}** total
:::
::od-query{into="progettiComune" sql="SELECT titolo AS title, tema AS theme, finanz_totale_pubblico AS amount, stato_progetto AS status FROM opencoesione WHERE codice_istat = '{#comune}' ORDER BY finanz_totale_pubblico DESC LIMIT 30" limit="30"}
:::table{path="progettiComune" headers="Project,Theme,Amount €,Status" pagesize="10"}
{title} | {theme} | {amount} | {status}
:::