By town
Part of the Public tenders in the open
Enter the town's **ISTAT code** (six digits, e.g. `058091` for Rome, `015146` for Milan): see the most recent lots above a chosen threshold.
data space «appalti-trasparenti-en» — this micro app reads and writes the suite’s shared data space.
What it records
- Town's ISTAT code
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
# 📍 By town
## Tenders in your town
Enter the town's **ISTAT code** (six digits, e.g. `058091` for Rome, `015146`
for Milan): see the most recent lots above a chosen threshold.
::input[comune]{value="058091" placeholder="Town's ISTAT code"}
::range[soglia]{min="0" max="500000" value="50000" legend="Minimum amount (€)"}
::od-query{into="gareComune" sql="SELECT oggetto_gara AS subject, importo_lotto AS amount, amministrazione AS body, data_pubblicazione AS date FROM anac_cig WHERE luogo_istat = '{#comune}' AND importo_lotto >= {#soglia} ORDER BY data_pubblicazione DESC LIMIT 40" limit="40"}
:::table{path="gareComune" headers="Subject,Amount €,Body,Date" pagesize="10"}
{subject} | {amount} | {body} | {date}
:::