observation
526 rows where name_fi = "Aurattu" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46124 | 40421 | ice_skating_field_condition | 2020-12-23T10:03:34.303346+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
46114 | 53563 | ice_skating_field_condition | 2020-12-23T09:46:09.153930+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
46096 | 41770 | ice_skating_field_condition | 2020-12-23T08:42:53.077392+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
46087 | 42185 | ice_skating_field_condition | 2020-12-23T08:09:29.389077+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
45453 | 47279 | ice_skating_field_condition | 2020-12-21T16:27:23.008489+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
45452 | 53615 | ice_skating_field_condition | 2020-12-21T16:27:08.325832+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
45275 | 50568 | ice_skating_field_condition | 2020-12-21T07:38:10.953272+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44943 | 63148 | ice_skating_field_condition | 2020-12-20T12:01:52.266650+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44870 | 53524 | ice_skating_field_condition | 2020-12-20T08:33:05.173312+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44867 | 53523 | ice_skating_field_condition | 2020-12-20T08:32:05.060436+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44864 | 39834 | ice_skating_field_condition | 2020-12-20T08:30:08.321627+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44851 | 63148 | ice_skating_field_condition | 2020-12-20T07:42:27.379676+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44848 | 53615 | ice_skating_field_condition | 2020-12-20T07:36:43.762549+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44847 | 47279 | ice_skating_field_condition | 2020-12-20T07:36:30.219808+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44843 | 53563 | ice_skating_field_condition | 2020-12-20T07:28:18.694647+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44516 | 63148 | ice_skating_field_condition | 2020-12-19T11:50:35.317420+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44462 | 41770 | ice_skating_field_condition | 2020-12-19T09:19:03.899786+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44460 | 42185 | ice_skating_field_condition | 2020-12-19T09:18:48.123095+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44308 | 41770 | ice_skating_field_condition | 2020-12-18T22:53:52.615015+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44307 | 42185 | ice_skating_field_condition | 2020-12-18T22:53:39.826528+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44228 | 42185 | ice_skating_field_condition | 2020-12-18T17:02:56.420717+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44223 | 41770 | ice_skating_field_condition | 2020-12-18T16:45:24.192592+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44207 | 53615 | ice_skating_field_condition | 2020-12-18T15:37:33.881394+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44197 | 63148 | ice_skating_field_condition | 2020-12-18T14:57:18.148174+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44187 | 39370 | ice_skating_field_condition | 2020-12-18T14:26:05.072018+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44180 | 50568 | ice_skating_field_condition | 2020-12-18T14:09:56.011535+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44110 | 42185 | ice_skating_field_condition | 2020-12-18T09:07:48.400384+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44109 | 41770 | ice_skating_field_condition | 2020-12-18T09:07:29.660992+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44098 | 53615 | ice_skating_field_condition | 2020-12-18T08:43:02.198591+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
44097 | 47279 | ice_skating_field_condition | 2020-12-18T08:42:47.119819+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43767 | 40421 | ice_skating_field_condition | 2020-12-17T08:33:11.500465+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43510 | 46144 | ice_skating_field_condition | 2020-12-16T13:34:19.953931+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43509 | 42699 | ice_skating_field_condition | 2020-12-16T13:34:19.899259+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43499 | 41770 | ice_skating_field_condition | 2020-12-16T12:45:57.789307+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43498 | 42185 | ice_skating_field_condition | 2020-12-16T12:45:48.672575+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43496 | 39370 | ice_skating_field_condition | 2020-12-16T12:38:51.734391+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43443 | 53615 | ice_skating_field_condition | 2020-12-16T08:47:52.052968+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43408 | 50568 | ice_skating_field_condition | 2020-12-16T07:03:50.710079+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43168 | 50568 | ice_skating_field_condition | 2020-12-15T13:07:37.684505+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43102 | 53615 | ice_skating_field_condition | 2020-12-15T08:52:45.990613+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43083 | 41770 | ice_skating_field_condition | 2020-12-15T07:59:44.548921+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
43082 | 41770 | ice_skating_field_condition | 2020-12-15T07:59:33.509067+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42947 | 53615 | ice_skating_field_condition | 2020-12-14T21:29:23.418119+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42630 | 53615 | ice_skating_field_condition | 2020-12-13T21:36:48.706089+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42629 | 53615 | ice_skating_field_condition | 2020-12-13T21:36:05.934103+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42628 | 47279 | ice_skating_field_condition | 2020-12-13T21:35:36.828134+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42554 | 46144 | ice_skating_field_condition | 2020-12-13T15:35:48.133893+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42240 | 53615 | ice_skating_field_condition | 2020-12-12T15:48:26.805254+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42130 | 39370 | ice_skating_field_condition | 2020-12-12T08:04:28.689517+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
42003 | 53615 | ice_skating_field_condition | 2020-12-11T21:42:24.915456+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
41980 | 46144 | ice_skating_field_condition | 2020-12-11T20:11:20.783272+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
40549 | 40421 | ice_skating_field_condition | 2020-12-07T11:06:12.551078+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
40548 | 40421 | ice_skating_field_condition | 2020-12-07T11:06:04.593444+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
40314 | 39370 | ice_skating_field_condition | 2020-12-06T18:07:31.617144+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39979 | 39834 | ice_skating_field_condition | 2020-12-05T14:55:41.259871+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39978 | 53563 | ice_skating_field_condition | 2020-12-05T14:55:33.168704+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39931 | 39370 | ice_skating_field_condition | 2020-12-05T11:04:09.703884+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39671 | 39370 | ice_skating_field_condition | 2020-12-04T15:47:13.161205+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39648 | 63147 | ice_skating_field_condition | 2020-12-04T13:48:19.393302+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39638 | 53615 | ice_skating_field_condition | 2020-12-04T12:41:09.888384+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39606 | 41770 | ice_skating_field_condition | 2020-12-04T11:36:33.676699+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39593 | 39854 | ice_skating_field_condition | 2020-12-04T10:56:00.622280+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39412 | 47279 | ice_skating_field_condition | 2020-12-03T21:39:04.451688+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39411 | 53615 | ice_skating_field_condition | 2020-12-03T21:32:11.923926+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
39085 | 53615 | ice_skating_field_condition | 2020-12-02T21:31:43.962021+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38995 | 53615 | ice_skating_field_condition | 2020-12-02T15:35:27.940729+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38994 | 53615 | ice_skating_field_condition | 2020-12-02T15:34:51.537364+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38685 | 47279 | ice_skating_field_condition | 2020-12-01T17:28:17.932373+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38674 | 53615 | ice_skating_field_condition | 2020-12-01T16:46:53.530752+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38593 | 53615 | ice_skating_field_condition | 2020-12-01T10:52:09.508746+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38592 | 47279 | ice_skating_field_condition | 2020-12-01T10:51:55.359869+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38559 | 53563 | ice_skating_field_condition | 2020-12-01T08:40:03.458974+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38558 | 39834 | ice_skating_field_condition | 2020-12-01T08:39:32.094168+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38551 | 39370 | ice_skating_field_condition | 2020-12-01T08:05:37.895637+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38334 | 39370 | ice_skating_field_condition | 2020-11-30T14:25:21.488076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38321 | 53563 | ice_skating_field_condition | 2020-11-30T13:18:55.250399+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38265 | 53615 | ice_skating_field_condition | 2020-11-30T08:55:40.635169+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38264 | 47279 | ice_skating_field_condition | 2020-11-30T08:55:26.562725+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38014 | 42852 | ice_skating_field_condition | 2020-11-29T14:00:52.621124+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
38013 | 42526 | ice_skating_field_condition | 2020-11-29T14:00:47.044101+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
37953 | 46144 | ice_skating_field_condition | 2020-11-29T09:26:41.508583+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
36271 | 53615 | ice_skating_field_condition | 2020-11-23T21:42:03.677902+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
34339 | 42699 | ice_skating_field_condition | 2020-11-17T09:21:52.638748+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
34333 | 46144 | ice_skating_field_condition | 2020-11-17T09:02:23.601016+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
27814 | 39834 | ice_skating_field_condition | 2020-10-26T17:14:03.327211+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8294 | 39834 | ice_skating_field_condition | 2020-03-17T15:08:29.761463+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8293 | 53563 | ice_skating_field_condition | 2020-03-17T15:08:14.430496+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8220 | 41770 | ice_skating_field_condition | 2020-03-13T17:23:34.094671+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8218 | 42185 | ice_skating_field_condition | 2020-03-13T17:22:54.209871+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8216 | 53524 | ice_skating_field_condition | 2020-03-13T11:56:34.671020+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8215 | 53523 | ice_skating_field_condition | 2020-03-13T11:55:54.360500+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8206 | 41770 | ice_skating_field_condition | 2020-03-12T17:19:35.957808+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8193 | 53524 | ice_skating_field_condition | 2020-03-12T08:37:16.639554+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8192 | 53523 | ice_skating_field_condition | 2020-03-12T08:37:04.647081+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8191 | 39834 | ice_skating_field_condition | 2020-03-12T08:17:25.348096+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8190 | 53524 | ice_skating_field_condition | 2020-03-11T07:15:04.364746+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8189 | 53523 | ice_skating_field_condition | 2020-03-11T07:14:58.191193+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8187 | 53523 | ice_skating_field_condition | 2020-03-10T20:50:52.527500+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8186 | 53524 | ice_skating_field_condition | 2020-03-10T20:50:41.354821+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8176 | 53524 | ice_skating_field_condition | 2020-03-10T08:25:00.546306+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | 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 );