observation
10 rows where name_en = "Season underway"
This data as json, CSV (advanced)
Suggested facets: unit
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52 | 41047 | season_status | 2019-06-03T15:14:36.432563+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 53 | 50401 | season_status | 2019-06-03T15:14:54.977849+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 1406 | 40823 | season_status | 2019-06-24T11:00:36.870285+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9107 | 62213 | season_status | 2020-06-11T10:38:11.281508+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9118 | 62213 | season_status | 2020-06-11T14:35:59.683244+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 9853 | 62213 | season_status | 2020-06-22T10:24:04.934477+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 10235 | 41047 | season_status | 2020-06-26T11:29:54.733944+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 10236 | 40823 | season_status | 2020-06-26T11:30:20.418561+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 10997 | 48917 | season_status | 2020-07-07T10:21:01.054366+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 13894 | 62213 | season_status | 2020-08-18T08:22:23.635629+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );