Who tenders
Part of the Public tenders in the open
The administrations with the most tenders, by kind of body. The count is robust; ANAC amounts contain source errors, so here we rank by **number of tenders**, not totals.
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
# 📊 Who tenders
## The most active bodies
The administrations with the most tenders, by kind of body. The count is robust;
ANAC amounts contain source errors, so here we rank by **number of tenders**,
not totals.
::od-query{into="enti" sql="SELECT i.denominazione AS body, i.categoria AS kind, count(DISTINCT a.cig) AS tenders FROM anac_cig a JOIN indicepa i ON i.cf = a.cf_amministrazione_appaltante GROUP BY 1, 2 ORDER BY tenders DESC LIMIT 25" limit="25"}
:::table{path="enti" headers="Body,Kind,Tenders" pagesize="12"}
{body} | {kind} | {tenders}
:::