526 rows where name_en = "Cleared of snow"

View and edit SQL

name_en

  • Cleared of snow · 526
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
6068 53615 ice_skating_field_condition 2019-11-19T16:48:00.193786+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6069 53615 ice_skating_field_condition 2019-11-20T08:43:13.642764+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6107 42852 ice_skating_field_condition 2019-11-25T09:43:48.162988+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6108 42526 ice_skating_field_condition 2019-11-25T09:44:25.224077+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6113 46144 ice_skating_field_condition 2019-11-25T11:11:43.205941+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6128 46144 ice_skating_field_condition 2019-11-26T08:55:36.648076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6143 42852 ice_skating_field_condition 2019-11-26T10:34:45.266526+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6144 42526 ice_skating_field_condition 2019-11-26T10:35:05.067897+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6145 46144 ice_skating_field_condition 2019-11-26T10:35:42.508793+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6146 42699 ice_skating_field_condition 2019-11-26T10:35:57.982288+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6153 46144 ice_skating_field_condition 2019-11-26T19:31:48.784188+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6166 53615 ice_skating_field_condition 2019-11-28T07:26:39.378359+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6168 42185 ice_skating_field_condition 2019-11-28T08:41:58.115490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6175 42185 ice_skating_field_condition 2019-11-29T20:39:35.724042+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6176 41770 ice_skating_field_condition 2019-11-29T20:39:43.931626+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6191 42526 ice_skating_field_condition 2019-11-30T16:08:57.940097+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6192 42526 ice_skating_field_condition 2019-11-30T16:08:57.990103+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6194 42852 ice_skating_field_condition 2019-11-30T16:09:15.245065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6203 39834 ice_skating_field_condition 2019-12-01T18:49:21.145615+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6215 42526 ice_skating_field_condition 2019-12-02T14:09:55.944068+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6234 40438 ice_skating_field_condition 2019-12-04T08:02:53.902024+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6256 53615 ice_skating_field_condition 2019-12-05T08:18:51.190959+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6268 53563 ice_skating_field_condition 2019-12-06T16:18:19.963065+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6269 39834 ice_skating_field_condition 2019-12-06T16:19:13.675861+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6276 53615 ice_skating_field_condition 2019-12-07T09:45:36.715951+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6277 53615 ice_skating_field_condition 2019-12-07T09:45:43.825119+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6278 53563 ice_skating_field_condition 2019-12-07T11:34:18.389811+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6279 39834 ice_skating_field_condition 2019-12-07T11:34:27.315239+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6286 42185 ice_skating_field_condition 2019-12-07T17:06:26.069486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6287 41770 ice_skating_field_condition 2019-12-07T17:06:34.713219+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6311 41770 ice_skating_field_condition 2019-12-09T18:48:51.180019+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6312 42185 ice_skating_field_condition 2019-12-09T18:49:14.494178+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6315 53615 ice_skating_field_condition 2019-12-10T08:34:49.572512+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6317 42185 ice_skating_field_condition 2019-12-10T09:02:52.503670+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6318 41770 ice_skating_field_condition 2019-12-10T09:03:19.546316+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6319 42852 ice_skating_field_condition 2019-12-10T10:20:33.982313+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6323 46144 ice_skating_field_condition 2019-12-10T13:30:29.428737+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6365 53615 ice_skating_field_condition 2019-12-12T09:23:29.595050+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6394 47279 ice_skating_field_condition 2019-12-14T17:18:59.281156+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6397 53615 ice_skating_field_condition 2019-12-15T09:01:34.898744+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6398 47279 ice_skating_field_condition 2019-12-15T09:01:59.549022+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6399 53524 ice_skating_field_condition 2019-12-15T10:00:44.447329+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6400 53523 ice_skating_field_condition 2019-12-15T10:00:56.550334+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6401 40493 ice_skating_field_condition 2019-12-15T11:50:06.338212+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6415 53524 ice_skating_field_condition 2019-12-16T10:04:15.049415+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6416 53523 ice_skating_field_condition 2019-12-16T10:04:49.479697+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6422 47279 ice_skating_field_condition 2019-12-17T07:25:35.700039+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6423 53615 ice_skating_field_condition 2019-12-17T07:25:47.162629+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6425 46144 ice_skating_field_condition 2019-12-17T08:42:01.437711+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6426 53523 ice_skating_field_condition 2019-12-17T09:14:54.828452+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6427 53524 ice_skating_field_condition 2019-12-17T09:15:04.284350+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6438 42185 ice_skating_field_condition 2019-12-18T17:53:32.897531+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6439 47279 ice_skating_field_condition 2019-12-18T20:25:59.692407+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6449 53523 ice_skating_field_condition 2019-12-19T09:44:46.755132+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6450 53524 ice_skating_field_condition 2019-12-19T09:45:02.272158+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6480 53615 ice_skating_field_condition 2019-12-22T08:12:23.768639+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6500 53615 ice_skating_field_condition 2019-12-23T10:40:03.289903+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6521 47279 ice_skating_field_condition 2019-12-26T09:19:02.929863+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6522 53615 ice_skating_field_condition 2019-12-26T09:19:15.134912+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6523 53524 ice_skating_field_condition 2019-12-26T10:00:37.631415+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6524 53523 ice_skating_field_condition 2019-12-26T10:01:12.053513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6527 47279 ice_skating_field_condition 2019-12-27T07:14:41.665707+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6528 53615 ice_skating_field_condition 2019-12-27T07:14:48.857940+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6531 42185 ice_skating_field_condition 2019-12-27T08:14:28.181535+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6532 41770 ice_skating_field_condition 2019-12-27T08:14:38.262025+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6588 42185 ice_skating_field_condition 2019-12-30T10:56:24.869647+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6589 41770 ice_skating_field_condition 2019-12-30T10:56:43.457255+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6591 53523 ice_skating_field_condition 2019-12-30T12:18:18.871219+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6592 53524 ice_skating_field_condition 2019-12-30T12:18:31.031445+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6593 39834 ice_skating_field_condition 2019-12-30T14:57:05.376948+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6594 53563 ice_skating_field_condition 2019-12-30T14:57:24.377111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6595 53563 ice_skating_field_condition 2019-12-30T19:27:41.657738+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6596 42185 ice_skating_field_condition 2019-12-30T20:20:51.573083+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6613 42185 ice_skating_field_condition 2020-01-01T12:16:08.717657+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6614 41770 ice_skating_field_condition 2020-01-01T12:16:17.186336+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6627 42185 ice_skating_field_condition 2020-01-02T09:17:03.259292+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6628 41770 ice_skating_field_condition 2020-01-02T09:17:13.530853+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6640 53523 ice_skating_field_condition 2020-01-03T09:14:41.614767+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6641 53524 ice_skating_field_condition 2020-01-03T09:14:46.378735+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6642 53524 ice_skating_field_condition 2020-01-03T09:14:50.453486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6656 53615 ice_skating_field_condition 2020-01-04T08:25:22.197372+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6688 41770 ice_skating_field_condition 2020-01-06T08:23:02.858368+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6693 42185 ice_skating_field_condition 2020-01-06T12:25:49.584450+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6706 53563 ice_skating_field_condition 2020-01-07T07:53:35.498007+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6707 53523 ice_skating_field_condition 2020-01-07T08:55:56.160294+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6708 53524 ice_skating_field_condition 2020-01-07T08:56:02.190243+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6709 39834 ice_skating_field_condition 2020-01-07T09:44:56.590761+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6713 47279 ice_skating_field_condition 2020-01-08T07:08:51.887080+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6714 53615 ice_skating_field_condition 2020-01-08T07:09:30.837837+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6718 53523 ice_skating_field_condition 2020-01-08T08:29:01.310647+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6719 53524 ice_skating_field_condition 2020-01-08T08:29:08.133111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6768 46144 ice_skating_field_condition 2020-01-11T15:54:33.698929+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6784 42185 ice_skating_field_condition 2020-01-12T09:32:49.063627+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6785 41770 ice_skating_field_condition 2020-01-12T09:32:57.615187+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6788 40402 ice_skating_field_condition 2020-01-12T11:10:07.888152+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6789 46144 ice_skating_field_condition 2020-01-12T11:24:00.937355+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6790 46144 ice_skating_field_condition 2020-01-12T11:24:20.908524+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6792 40421 ice_skating_field_condition 2020-01-12T12:56:27.436367+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6794 46144 ice_skating_field_condition 2020-01-12T16:04:51.645585+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6830 39834 ice_skating_field_condition 2020-01-14T15:00:00.976818+0200     Aurattu   Plogad 1 Cleared of snow plowed good  

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