observation
7,945 rows where primary = 1 sorted by expiration_time
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52 | 41047 | season_status | 2019-06-03T15:14:36.432563+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 53 | 50401 | season_status | 2019-06-03T15:14:54.977849+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 1406 | 40823 | season_status | 2019-06-24T11:00:36.870285+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
| 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 | ||||
| 6009 | 53710 | ski_trail_condition | 2019-11-07T05:43:34.175106+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | 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 | ||||
| 6016 | 53710 | ski_trail_condition | 2019-11-08T14:21:00.052967+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 6019 | 53710 | ski_trail_condition | 2019-11-09T23:47:01.036909+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 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 | ||||
| 6044 | 53710 | ski_trail_condition | 2019-11-15T07:30:50.342752+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | 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 | ||||
| 6048 | 53710 | ski_trail_condition | 2019-11-16T01:05:56.223240+0200 | Hyvä | Bra | 1 | Good condition | good | 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 | ||||
| 6063 | 53710 | ski_trail_condition | 2019-11-18T15:29:15.961698+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
| 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 | ||||
| 6120 | 53710 | ski_trail_condition | 2019-11-25T14:06:25.226345+0200 | Hyvä | Bra | 1 | Good condition | good | 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 | ||||
| 6126 | 53710 | ski_trail_condition | 2019-11-26T08:37:51.926400+0200 | Hyvä | Bra | 1 | Good condition | good | 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 |
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 );