observation
419 rows where name_en = "Closed" sorted by id descending
This data as json, CSV (advanced)
| id ▲ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38590 | 53523 | ice_skating_field_condition | 2020-12-01T10:50:56.301354+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 38292 | 53523 | ice_skating_field_condition | 2020-11-30T10:58:26.546886+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 38291 | 53523 | ice_skating_field_condition | 2020-11-30T10:53:27.951819+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 38290 | 53524 | ice_skating_field_condition | 2020-11-30T10:53:16.800817+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37600 | 61464 | ice_skating_field_condition | 2020-11-28T06:57:03.573354+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37525 | 41657 | ice_skating_field_condition | 2020-11-28T01:29:26.671925+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37373 | 53523 | ice_skating_field_condition | 2020-11-27T13:37:40.005885+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37372 | 53524 | ice_skating_field_condition | 2020-11-27T13:37:30.876621+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36786 | 40224 | ice_skating_field_condition | 2020-11-25T13:56:01.060911+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36785 | 40744 | ice_skating_field_condition | 2020-11-25T13:55:11.220194+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36784 | 42119 | ice_skating_field_condition | 2020-11-25T13:54:52.750342+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36472 | 47279 | ice_skating_field_condition | 2020-11-24T13:20:02.684012+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36416 | 53523 | ice_skating_field_condition | 2020-11-24T09:04:46.349864+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36414 | 53524 | ice_skating_field_condition | 2020-11-24T09:04:20.431350+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 36079 | 39834 | ice_skating_field_condition | 2020-11-23T07:33:05.611519+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35812 | 40493 | ice_skating_field_condition | 2020-11-22T10:03:54.125961+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35809 | 39675 | ice_skating_field_condition | 2020-11-22T09:59:48.877310+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35807 | 53615 | ice_skating_field_condition | 2020-11-22T09:59:02.863813+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35646 | 42185 | ice_skating_field_condition | 2020-11-21T17:10:53.492809+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35594 | 39315 | ice_skating_field_condition | 2020-11-21T13:21:05.342364+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 35252 | 46144 | ice_skating_field_condition | 2020-11-20T11:59:05.787206+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34967 | 42526 | ice_skating_field_condition | 2020-11-19T11:14:53.612228+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34966 | 42852 | ice_skating_field_condition | 2020-11-19T11:14:40.715222+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34961 | 46144 | ice_skating_field_condition | 2020-11-19T10:44:38.537134+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34940 | 53523 | ice_skating_field_condition | 2020-11-19T08:10:50.171226+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34939 | 53524 | ice_skating_field_condition | 2020-11-19T08:10:41.768596+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34934 | 39834 | ice_skating_field_condition | 2020-11-19T08:08:58.141971+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34927 | 42699 | ice_skating_field_condition | 2020-11-19T07:22:40.046370+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34914 | 53615 | ice_skating_field_condition | 2020-11-19T06:25:36.478708+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34789 | 53615 | ice_skating_field_condition | 2020-11-18T20:01:43.429391+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34671 | 42699 | ice_skating_field_condition | 2020-11-18T10:43:48.038297+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34431 | 40550 | ice_skating_field_condition | 2020-11-17T16:05:06.503586+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34378 | 53523 | ice_skating_field_condition | 2020-11-17T12:11:36.795328+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34377 | 53524 | ice_skating_field_condition | 2020-11-17T12:11:29.220392+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34055 | 53523 | ice_skating_field_condition | 2020-11-16T11:37:39.677144+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 34054 | 53524 | ice_skating_field_condition | 2020-11-16T11:37:32.532454+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33744 | 56438 | ice_skating_field_condition | 2020-11-15T11:34:03.347612+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33149 | 53523 | ice_skating_field_condition | 2020-11-13T12:34:01.776074+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 33148 | 53524 | ice_skating_field_condition | 2020-11-13T12:33:54.122995+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 32206 | 53523 | ice_skating_field_condition | 2020-11-10T09:28:52.236093+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 32205 | 53524 | ice_skating_field_condition | 2020-11-10T09:28:45.118590+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 30097 | 53524 | ice_skating_field_condition | 2020-11-03T08:05:37.245801+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 30096 | 53523 | ice_skating_field_condition | 2020-11-03T08:05:13.146477+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 28002 | 39834 | ice_skating_field_condition | 2020-10-27T07:54:05.643745+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 27695 | 53523 | ice_skating_field_condition | 2020-10-26T09:06:24.730850+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 27694 | 53524 | ice_skating_field_condition | 2020-10-26T09:06:07.413936+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8356 | 60871 | ski_trail_condition | 2020-03-25T07:49:14.730651+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8353 | 53615 | ice_skating_field_condition | 2020-03-24T10:54:05.487564+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8351 | 40725 | ice_skating_field_condition | 2020-03-23T13:17:17.696674+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8350 | 53710 | ski_trail_condition | 2020-03-23T10:30:24.232670+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8347 | 39834 | ice_skating_field_condition | 2020-03-23T07:56:29.038648+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8346 | 53563 | ice_skating_field_condition | 2020-03-23T07:56:22.582450+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8345 | 57401 | ski_trail_condition | 2020-03-23T06:57:22.601868+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8335 | 53523 | ice_skating_field_condition | 2020-03-22T07:01:28.542964+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8334 | 53524 | ice_skating_field_condition | 2020-03-22T07:01:21.182531+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8331 | 53524 | ice_skating_field_condition | 2020-03-21T14:42:29.588941+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8330 | 53523 | ice_skating_field_condition | 2020-03-21T14:42:21.194885+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8321 | 47279 | ice_skating_field_condition | 2020-03-20T08:34:19.953997+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8309 | 53524 | ice_skating_field_condition | 2020-03-19T14:40:23.316417+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8308 | 53523 | ice_skating_field_condition | 2020-03-19T14:39:43.937007+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8305 | 41770 | ice_skating_field_condition | 2020-03-18T14:21:04.534989+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8302 | 41770 | ice_skating_field_condition | 2020-03-18T14:20:21.397877+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8299 | 42185 | ice_skating_field_condition | 2020-03-18T14:19:21.563988+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8277 | 47279 | ice_skating_field_condition | 2020-03-16T20:42:55.401835+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8276 | 39370 | ice_skating_field_condition | 2020-03-16T20:42:16.171030+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8275 | 53563 | ice_skating_field_condition | 2020-03-16T20:41:11.151092+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8274 | 39834 | ice_skating_field_condition | 2020-03-16T20:40:52.980568+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8263 | 40550 | ice_skating_field_condition | 2020-03-16T11:14:43.669450+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8260 | 53524 | ice_skating_field_condition | 2020-03-16T07:22:37.692239+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8259 | 53523 | ice_skating_field_condition | 2020-03-16T07:22:24.563026+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8252 | 42699 | ice_skating_field_condition | 2020-03-15T18:03:45.945732+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8251 | 42526 | ice_skating_field_condition | 2020-03-15T18:03:25.353122+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8250 | 42852 | ice_skating_field_condition | 2020-03-15T18:03:19.960490+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8249 | 46144 | ice_skating_field_condition | 2020-03-15T18:03:10.660681+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8248 | 53563 | ice_skating_field_condition | 2020-03-15T16:09:54.990079+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8211 | 42526 | ice_skating_field_condition | 2020-03-13T00:25:37.663687+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8210 | 42852 | ice_skating_field_condition | 2020-03-13T00:25:27.027741+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8209 | 42852 | ice_skating_field_condition | 2020-03-13T00:25:09.519806+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8208 | 46144 | ice_skating_field_condition | 2020-03-13T00:24:59.764754+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8205 | 53524 | ice_skating_field_condition | 2020-03-12T14:13:28.598400+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8204 | 53523 | ice_skating_field_condition | 2020-03-12T14:13:22.706403+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8201 | 41549 | ice_skating_field_condition | 2020-03-12T11:10:51.330922+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8185 | 40421 | ice_skating_field_condition | 2020-03-10T17:07:12.255322+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8184 | 53523 | ice_skating_field_condition | 2020-03-10T14:48:22.902809+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8183 | 53524 | ice_skating_field_condition | 2020-03-10T14:48:18.394968+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8180 | 42185 | ice_skating_field_condition | 2020-03-10T12:30:35.757221+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8179 | 41770 | ice_skating_field_condition | 2020-03-10T12:30:26.009418+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8178 | 40421 | ice_skating_field_condition | 2020-03-10T10:52:02.277831+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8177 | 42699 | ice_skating_field_condition | 2020-03-10T08:55:23.461797+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8171 | 43205 | ice_skating_field_condition | 2020-03-10T08:14:50.586311+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8169 | 61464 | ice_skating_field_condition | 2020-03-10T07:59:54.255286+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8168 | 61464 | ice_skating_field_condition | 2020-03-10T07:59:45.499112+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8165 | 40402 | ice_skating_field_condition | 2020-03-09T15:01:00.091728+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8162 | 40402 | ice_skating_field_condition | 2020-03-09T15:00:22.960874+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8151 | 61464 | ice_skating_field_condition | 2020-03-09T07:54:29.008951+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8140 | 40493 | ice_skating_field_condition | 2020-03-08T12:20:47.491096+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8110 | 61464 | ice_skating_field_condition | 2020-03-06T17:14:50.319009+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8101 | 40493 | ice_skating_field_condition | 2020-03-06T12:12:37.795286+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8060 | 61464 | ice_skating_field_condition | 2020-03-04T15:08:14.828629+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 8057 | 50354 | ice_skating_field_condition | 2020-03-04T12:04:10.647704+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 );