observation
1,452 rows where value = "frozen"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6238 | 39834 | ice_skating_field_condition | 2019-12-04T08:45:25.897006+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6239 | 53563 | ice_skating_field_condition | 2019-12-04T08:45:44.437487+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6242 | 42185 | ice_skating_field_condition | 2019-12-04T09:03:04.364640+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6243 | 41770 | ice_skating_field_condition | 2019-12-04T09:03:19.822177+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6244 | 42185 | ice_skating_field_condition | 2019-12-04T09:29:59.277886+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6245 | 41770 | ice_skating_field_condition | 2019-12-04T09:30:11.621193+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6246 | 40402 | ice_skating_field_condition | 2019-12-04T12:43:51.766804+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 | ||||
6248 | 53563 | ice_skating_field_condition | 2019-12-04T14:53:44.696649+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6255 | 47279 | ice_skating_field_condition | 2019-12-05T07:24:18.010882+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6257 | 40402 | ice_skating_field_condition | 2019-12-05T10:07:15.036459+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6258 | 41549 | ice_skating_field_condition | 2019-12-05T12:13:57.927416+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6262 | 42185 | ice_skating_field_condition | 2019-12-05T13:40:59.557937+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6263 | 41770 | ice_skating_field_condition | 2019-12-05T13:41:19.158236+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 | ||||
6265 | 53563 | ice_skating_field_condition | 2019-12-05T14:50:46.549796+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6266 | 40402 | ice_skating_field_condition | 2019-12-06T09:54:15.176953+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6267 | 46144 | ice_skating_field_condition | 2019-12-06T13:30:58.400233+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6270 | 47279 | ice_skating_field_condition | 2019-12-07T08:40:27.709421+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6271 | 42185 | ice_skating_field_condition | 2019-12-07T08:44:57.287150+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6272 | 41770 | ice_skating_field_condition | 2019-12-07T08:45:16.186406+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6282 | 42699 | ice_skating_field_condition | 2019-12-07T16:07:17.694802+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6283 | 46144 | ice_skating_field_condition | 2019-12-07T16:07:27.250189+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6284 | 42852 | ice_skating_field_condition | 2019-12-07T16:07:47.833127+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6285 | 42526 | ice_skating_field_condition | 2019-12-07T16:08:13.818363+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6290 | 47279 | ice_skating_field_condition | 2019-12-08T08:44:54.400892+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6291 | 53615 | ice_skating_field_condition | 2019-12-08T08:45:08.545750+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6294 | 42185 | ice_skating_field_condition | 2019-12-08T09:33:33.267564+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6295 | 41770 | ice_skating_field_condition | 2019-12-08T09:33:56.806562+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6296 | 53563 | ice_skating_field_condition | 2019-12-08T09:59:01.316770+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 | ||||
6298 | 40402 | ice_skating_field_condition | 2019-12-08T13:46:25.009053+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 | ||||
6300 | 53563 | ice_skating_field_condition | 2019-12-08T15:08:35.642695+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6302 | 47279 | ice_skating_field_condition | 2019-12-09T08:43:35.498157+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6303 | 40402 | ice_skating_field_condition | 2019-12-09T08:49:02.787774+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6307 | 53615 | ice_skating_field_condition | 2019-12-09T12:21:08.062748+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6313 | 40402 | ice_skating_field_condition | 2019-12-10T08:14:47.219049+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6314 | 40493 | ice_skating_field_condition | 2019-12-10T08:17:00.479929+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6316 | 47279 | ice_skating_field_condition | 2019-12-10T08:35:03.903911+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6330 | 40402 | ice_skating_field_condition | 2019-12-11T07:50:04.950286+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6335 | 53615 | ice_skating_field_condition | 2019-12-11T08:50:33.543217+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6336 | 47279 | ice_skating_field_condition | 2019-12-11T08:50:46.998901+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6341 | 46144 | ice_skating_field_condition | 2019-12-11T09:06:33.881352+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6344 | 53524 | ice_skating_field_condition | 2019-12-11T12:04:43.364849+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6361 | 42185 | ice_skating_field_condition | 2019-12-12T08:05:31.631899+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6362 | 41770 | ice_skating_field_condition | 2019-12-12T08:05:40.481853+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6363 | 40402 | ice_skating_field_condition | 2019-12-12T08:38:08.255814+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6364 | 47279 | ice_skating_field_condition | 2019-12-12T09:23:12.377825+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6366 | 53524 | ice_skating_field_condition | 2019-12-12T10:09:07.826603+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6367 | 53563 | ice_skating_field_condition | 2019-12-12T11:34:58.971298+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 | ||||
6370 | 46144 | ice_skating_field_condition | 2019-12-12T14:01:43.782670+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6371 | 41549 | ice_skating_field_condition | 2019-12-12T16:34:49.332448+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6372 | 42185 | ice_skating_field_condition | 2019-12-13T08:43:58.184758+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6373 | 41770 | ice_skating_field_condition | 2019-12-13T08:44:06.222435+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6374 | 46144 | ice_skating_field_condition | 2019-12-13T08:58:00.654651+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6375 | 40402 | ice_skating_field_condition | 2019-12-13T09:16:55.051453+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6376 | 47279 | ice_skating_field_condition | 2019-12-13T09:18:52.768741+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6377 | 53615 | ice_skating_field_condition | 2019-12-13T09:19:14.052428+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6378 | 53524 | ice_skating_field_condition | 2019-12-13T09:58:16.014618+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6382 | 53563 | ice_skating_field_condition | 2019-12-14T08:01:12.367656+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 | ||||
6384 | 53523 | ice_skating_field_condition | 2019-12-14T10:21:28.220619+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6385 | 53524 | ice_skating_field_condition | 2019-12-14T10:21:38.947923+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6386 | 40493 | ice_skating_field_condition | 2019-12-14T10:24:05.471248+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6389 | 41549 | ice_skating_field_condition | 2019-12-14T11:33:30.492289+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6390 | 42699 | ice_skating_field_condition | 2019-12-14T15:25:02.205631+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6391 | 42526 | ice_skating_field_condition | 2019-12-14T15:25:16.188973+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6392 | 42852 | ice_skating_field_condition | 2019-12-14T15:25:27.644863+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6393 | 46144 | ice_skating_field_condition | 2019-12-14T15:25:34.116156+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6405 | 40402 | ice_skating_field_condition | 2019-12-15T16:35:43.228859+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6406 | 53563 | ice_skating_field_condition | 2019-12-16T08:03:54.181138+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6407 | 42185 | ice_skating_field_condition | 2019-12-16T08:18:36.314481+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6408 | 41770 | ice_skating_field_condition | 2019-12-16T08:18:44.089211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6409 | 41549 | ice_skating_field_condition | 2019-12-16T08:31:52.812089+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6410 | 41549 | ice_skating_field_condition | 2019-12-16T08:32:10.719138+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 | ||||
6412 | 47279 | ice_skating_field_condition | 2019-12-16T08:58:34.648224+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6413 | 53615 | ice_skating_field_condition | 2019-12-16T08:58:59.610183+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6414 | 40402 | ice_skating_field_condition | 2019-12-16T09:58:24.536121+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6419 | 46144 | ice_skating_field_condition | 2019-12-16T14:32:54.320027+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6420 | 53563 | ice_skating_field_condition | 2019-12-16T14:36:08.335999+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 | ||||
6424 | 40402 | ice_skating_field_condition | 2019-12-17T08:17:27.644282+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6430 | 46144 | ice_skating_field_condition | 2019-12-17T12:47:00.553065+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6431 | 40493 | ice_skating_field_condition | 2019-12-17T15:54:42.830521+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6432 | 40402 | ice_skating_field_condition | 2019-12-18T08:23:38.560529+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6440 | 53563 | ice_skating_field_condition | 2019-12-19T06:55:19.684179+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6443 | 47279 | ice_skating_field_condition | 2019-12-19T08:25:33.128922+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6444 | 53615 | ice_skating_field_condition | 2019-12-19T08:25:56.447237+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6447 | 40402 | ice_skating_field_condition | 2019-12-19T09:13:11.947752+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 | ||||
6451 | 42185 | ice_skating_field_condition | 2019-12-19T12:47:45.520932+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6452 | 41770 | ice_skating_field_condition | 2019-12-19T12:48:33.980440+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6453 | 42185 | ice_skating_field_condition | 2019-12-19T18:09:00.192377+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6454 | 41770 | ice_skating_field_condition | 2019-12-19T18:09:30.299945+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6459 | 42185 | ice_skating_field_condition | 2019-12-20T08:39:35.721951+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6460 | 41770 | ice_skating_field_condition | 2019-12-20T08:40:04.716072+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6461 | 47279 | ice_skating_field_condition | 2019-12-20T08:41:31.389143+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 );