observation
419 rows where name_fi = "Suljettu" sorted by id descending
This data as json, CSV (advanced)
Suggested facets: property
| id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51031 | 50265 | ice_skating_field_condition | 2021-01-04T15:14:15.618823+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51030 | 39269 | ice_skating_field_condition | 2021-01-04T15:13:26.045585+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51023 | 42672 | ice_skating_field_condition | 2021-01-04T15:00:41.465811+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51020 | 42562 | ice_skating_field_condition | 2021-01-04T14:56:55.478182+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51019 | 53095 | ice_skating_field_condition | 2021-01-04T14:56:16.662837+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51018 | 46192 | ice_skating_field_condition | 2021-01-04T14:55:41.835163+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 51017 | 42580 | ice_skating_field_condition | 2021-01-04T14:54:51.799457+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50903 | 50265 | ice_skating_field_condition | 2021-01-04T12:26:05.520577+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50902 | 39654 | ice_skating_field_condition | 2021-01-04T12:25:30.385154+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50901 | 39398 | ice_skating_field_condition | 2021-01-04T12:24:55.518697+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50900 | 39401 | ice_skating_field_condition | 2021-01-04T12:24:17.076045+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50899 | 39269 | ice_skating_field_condition | 2021-01-04T12:23:50.719939+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50898 | 39315 | ice_skating_field_condition | 2021-01-04T12:23:17.118693+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50897 | 39296 | ice_skating_field_condition | 2021-01-04T12:22:52.718150+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50896 | 39385 | ice_skating_field_condition | 2021-01-04T12:22:31.801698+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50895 | 50518 | ice_skating_field_condition | 2021-01-04T12:22:08.022311+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50894 | 39710 | ice_skating_field_condition | 2021-01-04T12:21:12.583086+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50893 | 39604 | ice_skating_field_condition | 2021-01-04T12:20:48.019048+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50890 | 39780 | ice_skating_field_condition | 2021-01-04T12:20:01.032534+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50889 | 39498 | ice_skating_field_condition | 2021-01-04T12:19:23.273010+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50888 | 50522 | ice_skating_field_condition | 2021-01-04T12:18:57.422985+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50887 | 50515 | ice_skating_field_condition | 2021-01-04T12:18:41.931507+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50405 | 40421 | ice_skating_field_condition | 2021-01-03T08:33:48.108169+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 50368 | 46144 | ice_skating_field_condition | 2021-01-03T06:15:26.387596+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 49340 | 40421 | ice_skating_field_condition | 2020-12-31T15:00:20.876900+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 49304 | 56438 | ice_skating_field_condition | 2020-12-31T13:27:38.531275+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 49223 | 41608 | ice_skating_field_condition | 2020-12-31T10:17:20.650223+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 48892 | 42699 | ice_skating_field_condition | 2020-12-30T14:07:19.906881+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 48803 | 40421 | ice_skating_field_condition | 2020-12-30T09:39:31.928981+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 48760 | 63147 | ice_skating_field_condition | 2020-12-30T07:02:43.816689+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 48542 | 41770 | ice_skating_field_condition | 2020-12-29T16:26:36.480465+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 47600 | 39663 | ice_skating_field_condition | 2020-12-27T11:03:03.622133+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 46750 | 39370 | ice_skating_field_condition | 2020-12-25T08:43:16.014984+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 46081 | 57401 | ski_trail_condition | 2020-12-23T07:47:10.744808+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45735 | 39370 | ice_skating_field_condition | 2020-12-22T10:28:31.320271+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45697 | 42593 | ice_skating_field_condition | 2020-12-22T08:34:20.671854+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45693 | 40421 | ice_skating_field_condition | 2020-12-22T08:20:09.453221+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45671 | 41770 | ice_skating_field_condition | 2020-12-22T07:01:46.360594+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45670 | 42185 | ice_skating_field_condition | 2020-12-22T07:01:39.999355+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45289 | 40421 | ice_skating_field_condition | 2020-12-21T07:59:14.102317+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45286 | 39370 | ice_skating_field_condition | 2020-12-21T07:56:51.682321+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 45281 | 39370 | ice_skating_field_condition | 2020-12-21T07:56:31.538028+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44879 | 40421 | ice_skating_field_condition | 2020-12-20T09:02:35.987640+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44841 | 51028 | ski_trail_condition | 2020-12-20T07:17:07.408618+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44280 | 42185 | ice_skating_field_condition | 2020-12-18T20:44:36.946950+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44233 | 47279 | ice_skating_field_condition | 2020-12-18T17:29:26.222019+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44224 | 42185 | ice_skating_field_condition | 2020-12-18T16:48:54.388195+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44169 | 53524 | ice_skating_field_condition | 2020-12-18T13:03:43.709602+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44168 | 53523 | ice_skating_field_condition | 2020-12-18T13:03:36.546079+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44100 | 39370 | ice_skating_field_condition | 2020-12-18T08:58:36.074466+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 44080 | 40421 | ice_skating_field_condition | 2020-12-18T07:35:22.652160+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43811 | 53524 | ice_skating_field_condition | 2020-12-17T11:05:41.345700+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43810 | 53523 | ice_skating_field_condition | 2020-12-17T11:05:34.097029+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43526 | 39911 | ice_skating_field_condition | 2020-12-16T14:34:44.291696+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43482 | 50568 | ice_skating_field_condition | 2020-12-16T11:35:07.513995+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43473 | 51086 | ski_trail_condition | 2020-12-16T10:52:39.287075+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43435 | 40421 | ice_skating_field_condition | 2020-12-16T08:21:45.058198+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43410 | 53524 | ice_skating_field_condition | 2020-12-16T07:04:46.581198+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43409 | 53523 | ice_skating_field_condition | 2020-12-16T07:04:23.744681+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43407 | 50568 | ice_skating_field_condition | 2020-12-16T07:03:26.776627+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43173 | 63147 | ice_skating_field_condition | 2020-12-15T13:39:28.597898+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43154 | 53524 | ice_skating_field_condition | 2020-12-15T11:54:28.443100+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 43151 | 53523 | ice_skating_field_condition | 2020-12-15T11:53:22.506073+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 42812 | 53524 | ice_skating_field_condition | 2020-12-14T11:13:27.218926+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 42811 | 53523 | ice_skating_field_condition | 2020-12-14T11:13:18.527909+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41865 | 40421 | ice_skating_field_condition | 2020-12-11T12:35:50.820994+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41569 | 53524 | ice_skating_field_condition | 2020-12-10T13:58:46.098667+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41568 | 53523 | ice_skating_field_condition | 2020-12-10T13:58:39.733399+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41312 | 53523 | ice_skating_field_condition | 2020-12-09T18:35:54.995204+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 41311 | 53524 | ice_skating_field_condition | 2020-12-09T18:35:44.355057+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40878 | 53524 | ice_skating_field_condition | 2020-12-08T11:33:37.155943+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40877 | 53523 | ice_skating_field_condition | 2020-12-08T11:33:30.750333+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40844 | 42413 | ice_skating_field_condition | 2020-12-08T09:22:19.212174+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40822 | 42518 | ice_skating_field_condition | 2020-12-08T08:02:25.564177+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40821 | 42338 | ice_skating_field_condition | 2020-12-08T08:02:05.961500+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40820 | 42549 | ice_skating_field_condition | 2020-12-08T08:01:35.812045+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40819 | 42581 | ice_skating_field_condition | 2020-12-08T08:01:19.329374+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40818 | 42669 | ice_skating_field_condition | 2020-12-08T08:00:54.601780+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40817 | 42806 | ice_skating_field_condition | 2020-12-08T08:00:31.518057+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40816 | 42565 | ice_skating_field_condition | 2020-12-08T08:00:05.743631+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40813 | 42750 | ice_skating_field_condition | 2020-12-08T07:59:35.719281+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40812 | 42701 | ice_skating_field_condition | 2020-12-08T07:59:11.211613+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40810 | 46175 | ice_skating_field_condition | 2020-12-08T07:58:51.659571+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40808 | 42319 | ice_skating_field_condition | 2020-12-08T07:57:58.504142+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40485 | 53523 | ice_skating_field_condition | 2020-12-07T07:06:59.219130+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40484 | 53524 | ice_skating_field_condition | 2020-12-07T07:06:48.924359+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 40483 | 39854 | ice_skating_field_condition | 2020-12-07T07:00:19.591803+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39933 | 53524 | ice_skating_field_condition | 2020-12-05T11:05:09.401977+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39932 | 53523 | ice_skating_field_condition | 2020-12-05T11:04:50.564084+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39919 | 41181 | ice_skating_field_condition | 2020-12-05T10:25:46.456941+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39636 | 53093 | ice_skating_field_condition | 2020-12-04T12:32:13.051409+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39635 | 42743 | ice_skating_field_condition | 2020-12-04T12:31:16.815056+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39634 | 42489 | ice_skating_field_condition | 2020-12-04T12:30:29.510736+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39630 | 42902 | ice_skating_field_condition | 2020-12-04T12:29:31.089998+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39629 | 42847 | ice_skating_field_condition | 2020-12-04T12:28:36.237673+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39628 | 53089 | ice_skating_field_condition | 2020-12-04T12:27:46.479078+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39627 | 42913 | ice_skating_field_condition | 2020-12-04T12:27:19.755050+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39198 | 53524 | ice_skating_field_condition | 2020-12-03T06:39:41.443838+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 39197 | 53523 | ice_skating_field_condition | 2020-12-03T06:39:21.054634+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 38591 | 53524 | ice_skating_field_condition | 2020-12-01T10:51:03.309259+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable |
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 );