observation

117 rows where name_sv = "Isningen har inletts" and value = "freezing_started"

✎ View and edit SQL

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
6008 53524 ice_skating_field_condition 2019-11-05T20:08:15.996395+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6013 42185 ice_skating_field_condition 2019-11-07T09:58:30.402180+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6029 42185 ice_skating_field_condition 2019-11-12T09:21:40.830633+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6040 41770 ice_skating_field_condition 2019-11-14T08:17:50.132865+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6058 42185 ice_skating_field_condition 2019-11-18T07:28:32.000508+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6059 41770 ice_skating_field_condition 2019-11-18T07:28:46.375521+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6081 42185 ice_skating_field_condition 2019-11-23T13:08:07.889101+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6083 41770 ice_skating_field_condition 2019-11-23T13:08:25.935238+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6089 41549 ice_skating_field_condition 2019-11-24T11:22:09.494605+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6090 41657 ice_skating_field_condition 2019-11-25T06:07:43.288923+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6096 42185 ice_skating_field_condition 2019-11-25T07:20:28.019854+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6097 41770 ice_skating_field_condition 2019-11-25T07:20:35.373233+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6114 46144 ice_skating_field_condition 2019-11-25T11:11:52.386098+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
6164 40493 ice_skating_field_condition 2019-11-27T13:51:02.941174+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7143 53524 ice_skating_field_condition 2020-01-30T07:45:29.146931+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7144 53523 ice_skating_field_condition 2020-01-30T07:45:37.598516+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7187 42185 ice_skating_field_condition 2020-02-01T09:22:51.005398+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7242 41398 ice_skating_field_condition 2020-02-04T10:53:14.730366+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7243 41617 ice_skating_field_condition 2020-02-04T10:54:20.474941+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7244 40455 ice_skating_field_condition 2020-02-04T10:54:48.555474+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7245 41568 ice_skating_field_condition 2020-02-04T10:55:15.062496+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7246 51402 ice_skating_field_condition 2020-02-04T10:55:30.282898+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7248 40934 ice_skating_field_condition 2020-02-04T10:56:06.551146+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7249 40218 ice_skating_field_condition 2020-02-04T11:03:46.260342+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7250 40059 ice_skating_field_condition 2020-02-04T11:04:18.935802+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7251 40013 ice_skating_field_condition 2020-02-04T11:27:47.301730+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7254 41096 ice_skating_field_condition 2020-02-04T12:04:59.924082+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7255 41994 ice_skating_field_condition 2020-02-04T12:12:19.682878+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7256 42034 ice_skating_field_condition 2020-02-04T12:18:31.895282+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7260 42241 ice_skating_field_condition 2020-02-04T13:16:44.949309+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7261 40040 ice_skating_field_condition 2020-02-04T13:17:21.053348+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7264 40970 ice_skating_field_condition 2020-02-04T16:30:41.256899+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7265 50605 ice_skating_field_condition 2020-02-04T16:40:15.288413+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7269 40934 ice_skating_field_condition 2020-02-04T21:36:35.646880+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7279 40013 ice_skating_field_condition 2020-02-05T08:00:10.153763+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7286 40934 ice_skating_field_condition 2020-02-05T09:00:52.861594+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7292 42553 ice_skating_field_condition 2020-02-05T09:02:19.291968+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7293 53090 ice_skating_field_condition 2020-02-05T09:03:13.384035+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7294 42511 ice_skating_field_condition 2020-02-05T09:04:16.782755+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7296 42419 ice_skating_field_condition 2020-02-05T09:04:32.531500+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7298 42644 ice_skating_field_condition 2020-02-05T09:04:47.626440+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7303 42542 ice_skating_field_condition 2020-02-05T09:36:14.810340+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7311 40252 ice_skating_field_condition 2020-02-05T11:09:05.440881+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7312 50605 ice_skating_field_condition 2020-02-05T11:22:28.110402+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7339 50354 ice_skating_field_condition 2020-02-06T09:28:54.516377+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7342 41494 ice_skating_field_condition 2020-02-06T10:50:26.951821+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7348 39911 ice_skating_field_condition 2020-02-06T10:58:17.561990+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7355 58433 ice_skating_field_condition 2020-02-06T14:09:17.565827+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7356 42669 ice_skating_field_condition 2020-02-06T14:10:06.079147+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7357 42338 ice_skating_field_condition 2020-02-06T14:10:21.991242+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7366 42034 ice_skating_field_condition 2020-02-06T15:54:02.160489+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7370 42111 ice_skating_field_condition 2020-02-06T19:13:37.755649+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7371 51451 ice_skating_field_condition 2020-02-06T19:14:13.278272+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7381 42185 ice_skating_field_condition 2020-02-07T07:58:42.062650+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7399 42319 ice_skating_field_condition 2020-02-07T12:31:33.115775+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7400 42701 ice_skating_field_condition 2020-02-07T12:32:19.221895+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7401 42750 ice_skating_field_condition 2020-02-07T12:32:43.946401+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7402 42565 ice_skating_field_condition 2020-02-07T12:33:03.016864+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7403 42806 ice_skating_field_condition 2020-02-07T12:33:20.540063+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7404 42581 ice_skating_field_condition 2020-02-07T12:33:35.287872+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7405 42549 ice_skating_field_condition 2020-02-07T12:33:52.126998+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7406 42518 ice_skating_field_condition 2020-02-07T12:34:32.039229+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7407 42913 ice_skating_field_condition 2020-02-07T13:46:16.871643+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7408 42593 ice_skating_field_condition 2020-02-07T13:47:42.779105+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7409 42847 ice_skating_field_condition 2020-02-07T13:48:23.345643+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7410 42902 ice_skating_field_condition 2020-02-07T13:49:35.344137+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7411 42489 ice_skating_field_condition 2020-02-07T13:50:10.947975+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7412 42743 ice_skating_field_condition 2020-02-07T13:50:43.440505+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7413 42562 ice_skating_field_condition 2020-02-07T13:51:51.165205+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7414 53093 ice_skating_field_condition 2020-02-07T13:52:22.413590+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7415 53089 ice_skating_field_condition 2020-02-07T13:52:53.581201+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7418 46175 ice_skating_field_condition 2020-02-07T13:54:08.942542+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7419 46175 ice_skating_field_condition 2020-02-07T14:00:55.148783+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7573 41148 ice_skating_field_condition 2020-02-11T15:23:37.163140+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7751 61464 ice_skating_field_condition 2020-02-19T08:51:25.578320+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7776 61464 ice_skating_field_condition 2020-02-20T07:42:54.364140+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7864 40970 ice_skating_field_condition 2020-02-25T09:20:54.321661+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
7888 50354 ice_skating_field_condition 2020-02-26T08:00:01.859542+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
8278 50518 ice_skating_field_condition 2020-03-16T20:43:15.370264+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
13892 41148 ice_skating_field_condition 2020-08-17T13:38:31.778812+0300     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
32228 53615 ice_skating_field_condition 2020-11-10T10:52:34.650072+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
32540 42699 ice_skating_field_condition 2020-11-11T12:04:51.433799+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
32807 63148 ice_skating_field_condition 2020-11-12T09:39:36.019096+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
33222 46144 ice_skating_field_condition 2020-11-13T18:23:40.315989+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
33223 42699 ice_skating_field_condition 2020-11-13T18:26:52.312319+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
33994 47279 ice_skating_field_condition 2020-11-16T07:08:38.096537+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
35640 41770 ice_skating_field_condition 2020-11-21T17:09:25.124052+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started unusable  
35811 40493 ice_skating_field_condition 2020-11-22T10:01:32.264991+0200     Jäädytys aloitettu   Isningen har inletts 1 The icing has begun freezing_started 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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);