observation
1,026 rows where quality = "unusable" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 45660 | 57401 | ski_trail_condition | 2020-12-22T06:21:16.259314+0200 | Heikko | Svag | 1 | Poor condition | poor | 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 | ||||
| 45257 | 57401 | ski_trail_condition | 2020-12-21T06:30:28.549857+0200 | Heikko | Svag | 1 | Poor condition | poor | 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 | ||||
| 44422 | 61464 | ice_skating_field_condition | 2020-12-19T07:25:17.432276+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 43873 | 61464 | ice_skating_field_condition | 2020-12-17T15:11:39.112974+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 41485 | 61464 | ice_skating_field_condition | 2020-12-10T07:44:13.137670+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 41272 | 61464 | ice_skating_field_condition | 2020-12-09T16:03:00.652834+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 41150 | 42185 | ice_skating_field_condition | 2020-12-09T08:05:46.416732+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 40809 | 42185 | ice_skating_field_condition | 2020-12-08T07:58:48.786119+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 39950 | 40421 | ice_skating_field_condition | 2020-12-05T12:27:40.638392+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 39948 | 41549 | ice_skating_field_condition | 2020-12-05T12:22:42.055717+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 39911 | 39716 | ice_skating_field_condition | 2020-12-05T09:40:00.319235+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 39218 | 40493 | ice_skating_field_condition | 2020-12-03T07:39:42.076577+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 38608 | 61464 | ice_skating_field_condition | 2020-12-01T11:52:05.163363+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 38591 | 53524 | ice_skating_field_condition | 2020-12-01T10:51:03.309259+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 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 | ||||
| 37601 | 61464 | ice_skating_field_condition | 2020-11-28T06:57:08.798139+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 37600 | 61464 | ice_skating_field_condition | 2020-11-28T06:57:03.573354+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37598 | 61464 | ice_skating_field_condition | 2020-11-28T06:56:20.132436+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 37525 | 41657 | ice_skating_field_condition | 2020-11-28T01:29:26.671925+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 37523 | 40725 | ice_skating_field_condition | 2020-11-28T01:26:55.177956+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 37282 | 42249 | ice_skating_field_condition | 2020-11-27T07:29:56.677804+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | 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 | ||||
| 36451 | 42185 | ice_skating_field_condition | 2020-11-24T11:32:35.095539+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
| 36416 | 53523 | ice_skating_field_condition | 2020-11-24T09:04:46.349864+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 );