observation

2 rows where name_fi = "Lumetus kesken" and unit = 51028

✎ View and edit SQL

This data as json, CSV (advanced)

unit ✖

  • 51028 · 2 ✖

name_fi ✖

  • Lumetus kesken · 2 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
6328 51028 ski_trail_condition 2019-12-10T17:34:12.368332+0200     Lumetus kesken   Snöproduktionen oavslutad 1 Snowmaking unfinished snowmaking unusable  
6329 51028 ski_trail_condition 2019-12-11T07:38:18.388923+0200     Lumetus kesken   Snöproduktionen oavslutad 1 Snowmaking unfinished snowmaking unusable  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [observation] (
   [unit] INTEGER,
   [id] INTEGER PRIMARY KEY,
   [property] TEXT,
   [time] TEXT,
   [expiration_time] TEXT,
   [value_fi] TEXT,
   [name_fi] TEXT,
   [value_sv] TEXT,
   [name_sv] TEXT,
   [primary] INTEGER,
   [name_en] TEXT,
   [value] TEXT,
   [quality] TEXT,
   [value_en] TEXT
);