The detail
Part of the Tourism
The latest available year, for the chosen province.
data space «turismo» — 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
# 🌍 The detail
## Domestic and foreign
The latest available year, for the chosen province.
::od-query{into="quota" sql="SELECT quota_straniera AS quota_straniera, permanenza_media AS permanenza_media, arrivi AS arrivi, arrivi_stranieri AS arrivi_stranieri FROM turismo WHERE sigla = '{#prov}' AND anno = (SELECT max(anno) FROM turismo WHERE sigla = '{#prov}')"}
:::cards{path="quota" search="false"}
🌍 Foreign tourists: **{quota_straniera}%** of arrivals — average stay **{permanenza_media}** nights
:::
::od-query{into="origine" sql="SELECT unnest(['Foreign', 'Domestic']) AS origine, unnest([arrivi_stranieri, arrivi - arrivi_stranieri]) AS arrivi FROM turismo WHERE sigla = '{#prov}' AND anno = (SELECT max(anno) FROM turismo WHERE sigla = '{#prov}')"}
::chart-pie{data="origine" label="origine" value="arrivi" height="16rem"}