51,120 rows sorted by property

View and edit SQL

Suggested facets: primary, name_en, quality

value

id unit property ▼ time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
5987 42852 ice_skating_field_condition 2019-09-07T18:40:27.198231+0300     Suljettu   Stängd 1 Closed closed unusable  
5988 41976 ice_skating_field_condition 2019-09-10T08:18:25.228210+0300     Jäädytetty   Isad 1 Ice-covered frozen good  
5989 41976 ice_skating_field_condition 2019-09-11T07:24:08.373689+0300     Suljettu   Stängd 1 Closed closed unusable  
6007 40201 ice_skating_field_condition 2019-10-10T14:35:54.667908+0300     Jäädytetty   Isad 1 Ice-covered frozen good  
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  
6011 41770 ice_skating_field_condition 2019-11-07T09:56:49.171260+0200     Suljettu   Stängd 1 Closed closed 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  
6014 42185 ice_skating_field_condition 2019-11-07T09:58:40.112027+0200     Suljettu   Stängd 1 Closed closed unusable  
6020 39370 ice_skating_field_condition 2019-11-11T12:38:51.856733+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6023 53615 ice_skating_field_condition 2019-11-11T13:39:10.373117+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6026 53615 ice_skating_field_condition 2019-11-11T16:09:42.262419+0200     Suljettu   Stängd 1 Closed closed unusable  
6028 53615 ice_skating_field_condition 2019-11-12T08:49:09.303828+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
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  
6030 41770 ice_skating_field_condition 2019-11-12T09:21:57.649587+0200     Suljettu   Stängd 1 Closed closed unusable  
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  
6035 40550 ice_skating_field_condition 2019-11-12T12:50:31.638369+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6038 43205 ice_skating_field_condition 2019-11-12T12:51:28.037292+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
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  
6041 39370 ice_skating_field_condition 2019-11-14T11:00:02.037902+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6042 53524 ice_skating_field_condition 2019-11-14T14:00:38.837026+0200     Suljettu   Stängd 1 Closed closed unusable  
6043 53523 ice_skating_field_condition 2019-11-14T14:01:03.454848+0200     Suljettu   Stängd 1 Closed closed unusable  
6045 39370 ice_skating_field_condition 2019-11-15T12:41:12.060308+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6046 53615 ice_skating_field_condition 2019-11-15T12:54:16.670431+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6049 53615 ice_skating_field_condition 2019-11-16T08:28:44.086080+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6050 53615 ice_skating_field_condition 2019-11-16T08:28:52.938038+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  
6052 53563 ice_skating_field_condition 2019-11-17T09:56:26.450995+0200     Suljettu   Stängd 1 Closed closed unusable  
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  
6057 42185 ice_skating_field_condition 2019-11-18T07:28:12.175017+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
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  
6060 39370 ice_skating_field_condition 2019-11-18T10:20:37.379298+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  
6062 53563 ice_skating_field_condition 2019-11-18T11:54:30.323399+0200     Suljettu   Stängd 1 Closed closed unusable  
6066 39834 ice_skating_field_condition 2019-11-18T16:08:20.353856+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6067 53615 ice_skating_field_condition 2019-11-19T14:49:25.099218+0200     Suljettu   Stängd 1 Closed closed unusable  
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  
6070 39834 ice_skating_field_condition 2019-11-20T11:23:04.032825+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6071 53615 ice_skating_field_condition 2019-11-21T19:18:45.657208+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6072 53615 ice_skating_field_condition 2019-11-22T08:20:16.830362+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  
6074 53524 ice_skating_field_condition 2019-11-22T12:50:21.925939+0200     Suljettu   Stängd 1 Closed closed unusable  
6075 53523 ice_skating_field_condition 2019-11-22T12:50:42.715838+0200     Suljettu   Stängd 1 Closed closed unusable  
6076 53615 ice_skating_field_condition 2019-11-22T17:41:09.041273+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6077 53615 ice_skating_field_condition 2019-11-23T07:45:38.397211+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  
6079 53563 ice_skating_field_condition 2019-11-23T08:56:25.190468+0200     Suljettu   Stängd 1 Closed closed 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  
6084 47279 ice_skating_field_condition 2019-11-23T15:54:15.448380+0200     Suljettu   Stängd 1 Closed closed unusable  
6085 53615 ice_skating_field_condition 2019-11-24T08:12:59.550914+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  
6087 53563 ice_skating_field_condition 2019-11-24T08:54:42.027456+0200     Suljettu   Stängd 1 Closed closed 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  
6094 53524 ice_skating_field_condition 2019-11-25T06:32:50.409420+0200     Suljettu   Stängd 1 Closed closed unusable  
6095 53523 ice_skating_field_condition 2019-11-25T06:32:57.544183+0200     Suljettu   Stängd 1 Closed closed 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  
6098 53615 ice_skating_field_condition 2019-11-25T08:32:40.460336+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6099 53523 ice_skating_field_condition 2019-11-25T09:05:57.015330+0200     Suljettu   Stängd 1 Closed closed unusable  
6100 53524 ice_skating_field_condition 2019-11-25T09:06:08.220871+0200     Suljettu   Stängd 1 Closed closed unusable  
6101 41770 ice_skating_field_condition 2019-11-25T09:14:44.118270+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6103 42185 ice_skating_field_condition 2019-11-25T09:17:31.674678+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6105 42852 ice_skating_field_condition 2019-11-25T09:41:04.381497+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6106 42526 ice_skating_field_condition 2019-11-25T09:41:27.657675+0200     Jäädytetty   Isad 1 Ice-covered frozen 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  
6109 39370 ice_skating_field_condition 2019-11-25T10:51:26.977518+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  
6111 53563 ice_skating_field_condition 2019-11-25T11:05:54.025272+0200     Suljettu   Stängd 1 Closed closed unusable  
6112 46144 ice_skating_field_condition 2019-11-25T11:11:37.430631+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6113 46144 ice_skating_field_condition 2019-11-25T11:11:43.205941+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
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  
6115 46144 ice_skating_field_condition 2019-11-25T11:11:58.166068+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6116 42699 ice_skating_field_condition 2019-11-25T11:12:48.089288+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6117 41549 ice_skating_field_condition 2019-11-25T11:18:14.826235+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6118 41549 ice_skating_field_condition 2019-11-25T11:37:37.566506+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6123 53615 ice_skating_field_condition 2019-11-25T15:42:25.590641+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6124 53615 ice_skating_field_condition 2019-11-26T07:58:51.213053+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6128 46144 ice_skating_field_condition 2019-11-26T08:55:36.648076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6129 46144 ice_skating_field_condition 2019-11-26T08:55:41.408252+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6130 42699 ice_skating_field_condition 2019-11-26T08:55:56.260054+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6131 47279 ice_skating_field_condition 2019-11-26T09:14:49.768523+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6132 41549 ice_skating_field_condition 2019-11-26T09:31:56.863994+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6133 41549 ice_skating_field_condition 2019-11-26T09:41:15.637472+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6134 42185 ice_skating_field_condition 2019-11-26T09:56:17.218914+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6135 41770 ice_skating_field_condition 2019-11-26T09:56:22.650732+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6139 53563 ice_skating_field_condition 2019-11-26T10:25:55.899082+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6141 42852 ice_skating_field_condition 2019-11-26T10:32:34.491592+0200     Jäädytetty   Isad 1 Ice-covered frozen good  
6142 42526 ice_skating_field_condition 2019-11-26T10:32:46.033216+0200     Jäädytetty   Isad 1 Ice-covered frozen 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  

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