Data source: api.existenz.ch

4 rows where unit = "km/h"

View and edit SQL

unit

  • km/h · 4
Link rowid ▼ name code unit description latest_values last_24h_values
3 ff fu3010z0 km/h Wind speed; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=ff https://api.existenz.ch/apiv1/smn/daterange?parameters=ff
4 ff_tow fu3towz0 km/h Wind speed tower; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=ff_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=ff_tow
5 fx fu3010z1 km/h Gust peak (one second); maximum https://api.existenz.ch/apiv1/smn/latest?parameters=fx https://api.existenz.ch/apiv1/smn/daterange?parameters=fx
6 fx_tow fu3towz1 km/h Gust peak (one second) tower; maximum https://api.existenz.ch/apiv1/smn/latest?parameters=fx_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=fx_tow

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE smn_parameters (name string, code string, unit real, description real, latest_values string, last_24h_values string);
CREATE UNIQUE INDEX smn_parameters_name_index ON smn_parameters(name);