Reactive
Build your app
Catalog ›Public data ›Constitutional and administrative justice — searchable rulings › Trial length

Trial length

Part of the Constitutional and administrative justice

The most-cited statistic on Italian justice: the average length, in days, of proceedings closed by the chosen court (SICID register — ordinary civil litigation).

▶ Use this app

data space «giustizia» — this micro app reads and writes the suite’s shared data space.

What it records

  • Court name, e.g. Milano, Napoli, Torino…

The other micro apps in the same suite

🏛️Constitutional Court🔍Regional courts & Council of State

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
# ⏳ Trial length

## How long a civil trial takes

The most-cited statistic on Italian justice: the average length, in days, of
proceedings closed by the chosen court (SICID register — ordinary civil
litigation).

::input[sede]{value="Milano" placeholder="Court name, e.g. Milano, Napoli, Torino…"}

::od-query{into="trend" sql="SELECT anno AS anno, durata_media_giorni AS giorni FROM giustizia_durata WHERE sede = '{#sede}' AND tipo_ufficio = 'Tribunale' AND materia = 'Totale delle materie' AND registro = 'SICID' ORDER BY anno" limit="20"}

::chart-line{data="trend" x="anno" y="giorni" height="16rem"}

### By subject matter, latest available year

::od-query{into="materie" sql="SELECT materia AS materia, durata_media_giorni AS giorni, definiti AS definiti FROM giustizia_durata WHERE sede = '{#sede}' AND tipo_ufficio = 'Tribunale' AND registro = 'SICID' AND anno = (SELECT max(anno) FROM giustizia_durata WHERE sede = '{#sede}' AND tipo_ufficio = 'Tribunale') ORDER BY giorni DESC" limit="10"}

:::table{path="materie" headers="Subject matter,Days,Closed proceedings" pagesize="10"}
{materia} | {giorni} | {definiti}
:::

Voluntary jurisdiction and special proceedings are usually the fastest;
ordinary civil litigation the slowest. Civil only: the Ministry has no
downloadable export for criminal proceedings.