Reactive
Build your app
Catalog ›Public data ›Constitutional and administrative justice — searchable rulings › Regional courts & Council of State

Regional courts & Council of State

Part of the Constitutional and administrative justice

Regional courts & Council of State: part of the Constitutional and administrative justice suite, on the shared “giustizia” data.

▶ Use this app

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

What it records

  • Region (empty for the Council of State)
  • A word in the subject, e.g. «competition», «tender»

The other micro apps in the same suite

🏛️Constitutional Court⏳Trial length

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
# 🔍 Regional courts & Council of State

## Rulings in your region

::input[regione]{value="Lazio" placeholder="Region (empty for the Council of State)"}

::od-query{into="riepilogo" sql="SELECT esito AS esito, count(*) AS n FROM giustizia_amministrativa WHERE regione = '{#regione}' GROUP BY esito ORDER BY n DESC LIMIT 8"}

::chart-bar{data="riepilogo" x="esito" y="n" height="16rem"}

### Search by subject

::input[q]{placeholder="A word in the subject, e.g. «competition», «tender»"}

::od-query{into="sentenze" sql="SELECT sede AS sede, sezione AS sezione, data_pubblicazione AS data_pubblicazione, esito AS esito, oggetto AS oggetto FROM giustizia_amministrativa WHERE regione = '{#regione}' AND oggetto ILIKE '%' || '{#q}' || '%' ORDER BY data_pubblicazione DESC LIMIT 30" limit="30"}

:::table{path="sentenze" headers="Seat,Section,Date,Outcome,Subject" pagesize="10"}
{sede} | {sezione} | {data_pubblicazione} | {esito} | {oggetto}
:::