observation
1,452 rows where name_en = "Ice-covered" sorted by unit
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35593 | 39315 | ice_skating_field_condition | 2020-11-21T13:20:57.681976+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6020 | 39370 | ice_skating_field_condition | 2019-11-11T12:38:51.856733+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6031 | 39370 | ice_skating_field_condition | 2019-11-12T09:38:30.127423+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6033 | 39370 | ice_skating_field_condition | 2019-11-12T11:48:27.342025+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6041 | 39370 | ice_skating_field_condition | 2019-11-14T11:00:02.037902+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6045 | 39370 | ice_skating_field_condition | 2019-11-15T12:41:12.060308+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6060 | 39370 | ice_skating_field_condition | 2019-11-18T10:20:37.379298+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6109 | 39370 | ice_skating_field_condition | 2019-11-25T10:51:26.977518+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6149 | 39370 | ice_skating_field_condition | 2019-11-26T11:34:35.053176+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6211 | 39370 | ice_skating_field_condition | 2019-12-02T10:20:56.683189+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6501 | 39370 | ice_skating_field_condition | 2019-12-23T11:31:10.081674+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8099 | 39370 | ice_skating_field_condition | 2020-03-06T12:02:09.316656+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
36452 | 39370 | ice_skating_field_condition | 2020-11-24T11:38:16.866746+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
39243 | 39370 | ice_skating_field_condition | 2020-12-03T08:56:55.015031+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
40854 | 39370 | ice_skating_field_condition | 2020-12-08T10:02:17.482732+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
41310 | 39370 | ice_skating_field_condition | 2020-12-09T18:33:02.480111+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
42235 | 39370 | ice_skating_field_condition | 2020-12-12T15:34:38.692585+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
42466 | 39370 | ice_skating_field_condition | 2020-12-13T08:54:40.315526+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
43827 | 39370 | ice_skating_field_condition | 2020-12-17T12:11:54.753247+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
43830 | 39370 | ice_skating_field_condition | 2020-12-17T12:12:18.898587+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
46208 | 39370 | ice_skating_field_condition | 2020-12-23T14:07:44.142464+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
46214 | 39370 | ice_skating_field_condition | 2020-12-23T14:09:34.712720+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
46853 | 39370 | ice_skating_field_condition | 2020-12-25T13:22:20.390199+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
47162 | 39370 | ice_skating_field_condition | 2020-12-26T09:15:19.527523+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
47332 | 39370 | ice_skating_field_condition | 2020-12-26T17:32:33.126686+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49749 | 39370 | ice_skating_field_condition | 2021-01-01T16:41:06.870108+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
49984 | 39370 | ice_skating_field_condition | 2021-01-02T08:33:48.816201+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
46784 | 39663 | ice_skating_field_condition | 2020-12-25T10:11:39.089664+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
35786 | 39675 | ice_skating_field_condition | 2020-11-22T08:29:26.252257+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6051 | 39834 | ice_skating_field_condition | 2019-11-16T18:17:06.273807+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6053 | 39834 | ice_skating_field_condition | 2019-11-17T09:57:49.502114+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6054 | 39834 | ice_skating_field_condition | 2019-11-17T09:57:57.917092+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6055 | 39834 | ice_skating_field_condition | 2019-11-17T09:58:02.152657+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6056 | 39834 | ice_skating_field_condition | 2019-11-17T15:22:29.773006+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6061 | 39834 | ice_skating_field_condition | 2019-11-18T11:53:23.349645+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6066 | 39834 | ice_skating_field_condition | 2019-11-18T16:08:20.353856+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6070 | 39834 | ice_skating_field_condition | 2019-11-20T11:23:04.032825+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6073 | 39834 | ice_skating_field_condition | 2019-11-22T08:40:47.737391+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6078 | 39834 | ice_skating_field_condition | 2019-11-23T08:55:38.247230+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6086 | 39834 | ice_skating_field_condition | 2019-11-24T08:54:04.462734+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6110 | 39834 | ice_skating_field_condition | 2019-11-25T11:05:20.242286+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6159 | 39834 | ice_skating_field_condition | 2019-11-27T09:07:01.645931+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6170 | 39834 | ice_skating_field_condition | 2019-11-28T08:44:58.143862+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6188 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:38.046092+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6189 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:40.421511+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6227 | 39834 | ice_skating_field_condition | 2019-12-03T14:37:30.361057+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6238 | 39834 | ice_skating_field_condition | 2019-12-04T08:45:25.897006+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6247 | 39834 | ice_skating_field_condition | 2019-12-04T14:53:29.416610+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6264 | 39834 | ice_skating_field_condition | 2019-12-05T14:50:22.152246+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6297 | 39834 | ice_skating_field_condition | 2019-12-08T09:59:07.693072+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6299 | 39834 | ice_skating_field_condition | 2019-12-08T15:08:15.828425+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6368 | 39834 | ice_skating_field_condition | 2019-12-12T11:35:37.457672+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6383 | 39834 | ice_skating_field_condition | 2019-12-14T09:10:00.050636+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6411 | 39834 | ice_skating_field_condition | 2019-12-16T08:48:27.775922+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6421 | 39834 | ice_skating_field_condition | 2019-12-16T14:36:15.050222+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6448 | 39834 | ice_skating_field_condition | 2019-12-19T09:16:12.258500+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6504 | 39834 | ice_skating_field_condition | 2019-12-23T15:16:07.085490+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6541 | 39834 | ice_skating_field_condition | 2019-12-27T11:32:14.787149+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6542 | 39834 | ice_skating_field_condition | 2019-12-27T15:00:57.610950+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6556 | 39834 | ice_skating_field_condition | 2019-12-28T09:25:48.151251+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6559 | 39834 | ice_skating_field_condition | 2019-12-28T15:12:16.270449+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6578 | 39834 | ice_skating_field_condition | 2019-12-29T10:46:02.284147+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6582 | 39834 | ice_skating_field_condition | 2019-12-29T14:56:55.092507+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6604 | 39834 | ice_skating_field_condition | 2019-12-31T08:47:56.168864+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6624 | 39834 | ice_skating_field_condition | 2020-01-02T08:33:24.148580+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6658 | 39834 | ice_skating_field_condition | 2020-01-04T08:51:58.779423+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6675 | 39834 | ice_skating_field_condition | 2020-01-05T08:46:03.623845+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6727 | 39834 | ice_skating_field_condition | 2020-01-09T09:44:38.639017+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6771 | 39834 | ice_skating_field_condition | 2020-01-11T16:02:50.446604+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6893 | 39834 | ice_skating_field_condition | 2020-01-17T15:24:42.889765+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6910 | 39834 | ice_skating_field_condition | 2020-01-18T11:39:28.771945+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6939 | 39834 | ice_skating_field_condition | 2020-01-19T14:16:38.721196+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6954 | 39834 | ice_skating_field_condition | 2020-01-20T10:21:39.519308+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6955 | 39834 | ice_skating_field_condition | 2020-01-20T10:21:43.888929+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6962 | 39834 | ice_skating_field_condition | 2020-01-20T14:26:36.260095+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6979 | 39834 | ice_skating_field_condition | 2020-01-21T11:11:20.029150+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6985 | 39834 | ice_skating_field_condition | 2020-01-21T14:59:22.284842+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7002 | 39834 | ice_skating_field_condition | 2020-01-22T11:48:17.358387+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7009 | 39834 | ice_skating_field_condition | 2020-01-22T16:48:48.074959+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7019 | 39834 | ice_skating_field_condition | 2020-01-23T09:46:10.050272+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7023 | 39834 | ice_skating_field_condition | 2020-01-23T16:37:08.039424+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7028 | 39834 | ice_skating_field_condition | 2020-01-24T08:40:44.543729+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7056 | 39834 | ice_skating_field_condition | 2020-01-25T08:53:33.479936+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7064 | 39834 | ice_skating_field_condition | 2020-01-25T16:03:48.041010+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7076 | 39834 | ice_skating_field_condition | 2020-01-26T09:06:15.434897+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7084 | 39834 | ice_skating_field_condition | 2020-01-26T14:43:20.023098+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7106 | 39834 | ice_skating_field_condition | 2020-01-27T16:14:07.004565+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7177 | 39834 | ice_skating_field_condition | 2020-01-31T10:21:05.553240+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7193 | 39834 | ice_skating_field_condition | 2020-02-01T11:46:15.767729+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7212 | 39834 | ice_skating_field_condition | 2020-02-02T14:23:36.871642+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7226 | 39834 | ice_skating_field_condition | 2020-02-03T09:17:33.621370+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7262 | 39834 | ice_skating_field_condition | 2020-02-04T14:30:57.120387+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7285 | 39834 | ice_skating_field_condition | 2020-02-05T08:43:31.868580+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7310 | 39834 | ice_skating_field_condition | 2020-02-05T10:38:48.724560+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7316 | 39834 | ice_skating_field_condition | 2020-02-05T14:33:09.393375+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7363 | 39834 | ice_skating_field_condition | 2020-02-06T14:47:43.580262+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7482 | 39834 | ice_skating_field_condition | 2020-02-09T09:12:15.519454+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7564 | 39834 | ice_skating_field_condition | 2020-02-11T11:43:48.953172+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7589 | 39834 | ice_skating_field_condition | 2020-02-12T08:36:52.843696+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7600 | 39834 | ice_skating_field_condition | 2020-02-12T15:40:51.111922+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | 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 );