observation
51,120 rows 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 6136 | 42185 | notice | 2019-11-26T10:00:18.738270+0200 | Puoli kenttää auki mailattomalle vapaaluistelulle. Toinen puoli avataan mailalliselle luistelulle kun siihen on saatu tarpeeksi jäätä.Huoltotauko klo 16-17 joka päivä, jolloin ei pääsyä kentille tai kaukaloon.Ma-pe 8-16 & 17-21:30La-su 9-16 & 17-21:30 | |||||||||
| 6137 | 41770 | notice | 2019-11-26T10:03:24.587190+0200 | Huoltotauko 16-17 joka päivä. Ei pääsyä kentille tuolloin.Alue aukima-pe 8-16 & 17-21:30la-su 9-16 & 17-21:30 | |||||||||
| 6138 | 41770 | notice | 2019-11-26T10:05:01.958121+0200 | Huoltotauko 16-17 joka päivä. Ei pääsyä kentille tuolloin.Kaukalo varattu keskiviikkoisin klo 17-18:30.Alue aukima-pe 8-16 & 17-21:30la-su 9-16 & 17-21:30 | |||||||||
| 6139 | 53563 | ice_skating_field_condition | 2019-11-26T10:25:55.899082+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6140 | 53563 | notice | 2019-11-26T10:27:18.168774+0200 | Kaukalo suljettu,kenttä avoinna | |||||||||
| 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 | ||||
| 6147 | 53524 | ice_skating_field_condition | 2019-11-26T10:38:59.037211+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6148 | 53523 | ice_skating_field_condition | 2019-11-26T10:39:05.599252+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6149 | 39370 | ice_skating_field_condition | 2019-11-26T11:34:35.053176+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6150 | 46144 | ice_skating_field_condition | 2019-11-26T13:58:47.902817+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6151 | 53615 | ice_skating_field_condition | 2019-11-26T15:42:10.754903+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6152 | 47279 | ice_skating_field_condition | 2019-11-26T16:33:25.561030+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6153 | 46144 | ice_skating_field_condition | 2019-11-26T19:31:48.784188+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6154 | 47279 | ice_skating_field_condition | 2019-11-27T07:16:49.520197+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6155 | 53615 | ice_skating_field_condition | 2019-11-27T08:19:13.418414+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6156 | 53563 | ice_skating_field_condition | 2019-11-27T08:28:38.201739+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6157 | 53563 | notice | 2019-11-27T08:29:11.544258+0200 | ||||||||||
| 6158 | 41549 | ice_skating_field_condition | 2019-11-27T09:03:08.881066+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6159 | 39834 | ice_skating_field_condition | 2019-11-27T09:07:01.645931+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6160 | 53710 | ski_trail_maintenance | 2019-11-27T10:12:39.120372+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6161 | 53710 | ski_trail_condition | 2019-11-27T10:12:39.120372+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 6162 | 53524 | ice_skating_field_condition | 2019-11-27T12:33:09.121453+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6163 | 53523 | ice_skating_field_condition | 2019-11-27T12:33:16.752238+0200 | Suljettu | Stängd | 1 | Closed | closed | 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 | ||||
| 6165 | 47279 | ice_skating_field_condition | 2019-11-28T07:06:02.774139+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6166 | 53615 | ice_skating_field_condition | 2019-11-28T07:26:39.378359+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6167 | 53563 | ice_skating_field_condition | 2019-11-28T07:47:06.018019+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6168 | 42185 | ice_skating_field_condition | 2019-11-28T08:41:58.115490+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6169 | 41770 | ice_skating_field_condition | 2019-11-28T08:42:44.530149+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6170 | 39834 | ice_skating_field_condition | 2019-11-28T08:44:58.143862+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6171 | 42185 | notice | 2019-11-28T17:33:47.578240+0200 | Kenttä todella lätäköillä!Puoli kenttää auki mailattomalle vapaaluistelulle. Toinen puoli avataan mailalliselle luistelulle kun siihen on saatu tarpeeksi jäätä.Huoltotauko klo 16-17 joka päivä, jolloin ei pääsyä kentille tai kaukaloon.Ma-pe 8-16 & 17-21:30La-su 9-16 & 17-21:30 | |||||||||
| 6172 | 42852 | ice_skating_field_condition | 2019-11-29T08:47:37.827839+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6173 | 42526 | ice_skating_field_condition | 2019-11-29T08:47:51.729878+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6174 | 42185 | notice | 2019-11-29T20:39:31.637759+0200 | Puoli kenttää auki mailattomalle vapaaluistelulle. Toinen puoli avataan mailalliselle luistelulle kun siihen on saatu tarpeeksi jäätä.Huoltotauko klo 16-17 joka päivä, jolloin ei pääsyä kentille tai kaukaloon.Ma-pe 8-16 & 17-21:30La-su 9-16 & 17-21:30 | |||||||||
| 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 | ||||
| 6177 | 47279 | ice_skating_field_condition | 2019-11-30T08:36:51.686804+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6178 | 53615 | ice_skating_field_condition | 2019-11-30T08:37:04.260422+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6179 | 53710 | ski_trail_condition | 2019-11-30T11:24:00.805300+0200 | Lumetus kesken | Snöproduktionen oavslutad | 1 | Snowmaking unfinished | snowmaking | unusable | ||||
| 6180 | 53710 | notice | 2019-11-30T11:24:58.056973+0200 | LATU SULJETTU KOKO LAUANTAIN! hiihtämään pääsee sunnuntaina 1.12 iltapäivällä735m latua, lumetus jatkuu. | |||||||||
| 6181 | 53710 | ski_trail_condition | 2019-11-30T11:25:11.706636+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6182 | 40725 | ice_skating_field_condition | 2019-11-30T14:16:26.680528+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6183 | 40725 | notice | 2019-11-30T14:21:17.312282+0200 | Luistelulle avoinna 30.11.2019 klo.14.00 eteenpäin. maksuton luistelu 30.11 ja 1.12. Maanantaista 2.12.2019 eteenpäin luistelu maksullista! | |||||||||
| 6184 | 40725 | notice | 2019-11-30T14:22:26.132147+0200 | Luistelulle avoinna lauantaina 30.11.2019 klo.14.00 eteenpäin. Maksuton luistelu 30.11 ja 1.12. HUOM! Maanantaista 2.12.2019 eteenpäin luistelu maksullista! | |||||||||
| 6185 | 40725 | notice | 2019-11-30T14:23:27.380550+0200 | Luistelulle avoinna lauantaina 30.11.2019 klo.14.00 eteenpäin. Maksuton luistelu 30.11 ja 1.12. HUOM! Maanantaista 2.12.2019 eteenpäin luistelu maksullista! | |||||||||
| 6186 | 40725 | notice | 2019-11-30T14:27:47.727122+0200 | Luistelulle avoinna lauantaina 30.11.2019 klo.14.00 eteenpäin. Maksuton luistelu 30.11 ja 1.12. HUOM! Maanantaista 2.12.2019 eteenpäin luistelu maksullista! Luistelu aika 30.11-1.12.2019 päättyy klo.19.30 | |||||||||
| 6187 | 40725 | notice | 2019-11-30T14:29:24.273003+0200 | Luistelulle avoinna lauantaina 30.11.2019 klo.14.00 eteenpäin. Maksuton luistelu 30.11 ja 1.12 klo 09.00-19.30. HUOM! Maanantaista 2.12.2019 eteenpäin luistelu maksullista! | |||||||||
| 6188 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:38.046092+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6189 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:40.421511+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6190 | 53563 | ice_skating_field_condition | 2019-11-30T15:28:50.673211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | 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 | ||||
| 6193 | 42526 | ice_skating_field_condition | 2019-11-30T16:09:03.260912+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6194 | 42852 | ice_skating_field_condition | 2019-11-30T16:09:15.245065+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6195 | 47279 | ice_skating_field_condition | 2019-12-01T09:29:22.068204+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6196 | 53615 | ice_skating_field_condition | 2019-12-01T09:29:44.832465+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6197 | 42185 | ice_skating_field_condition | 2019-12-01T09:38:49.859244+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6198 | 41770 | ice_skating_field_condition | 2019-12-01T09:39:08.231451+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6199 | 53710 | notice | 2019-12-01T11:08:59.707226+0200 | 735m latua, lumetus jatkuu. | |||||||||
| 6200 | 53710 | ski_trail_maintenance | 2019-12-01T11:09:04.755950+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6201 | 53710 | ski_trail_condition | 2019-12-01T11:09:04.755950+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 6202 | 53563 | ice_skating_field_condition | 2019-12-01T18:49:03.388511+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6203 | 39834 | ice_skating_field_condition | 2019-12-01T18:49:21.145615+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6204 | 40493 | ice_skating_field_condition | 2019-12-02T06:36:24.249080+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6205 | 53710 | ski_trail_maintenance | 2019-12-02T07:12:42.393218+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
| 6206 | 53710 | ski_trail_condition | 2019-12-02T07:12:42.393218+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
| 6207 | 53524 | ice_skating_field_condition | 2019-12-02T08:31:28.972795+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6208 | 53523 | ice_skating_field_condition | 2019-12-02T08:31:35.919352+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6209 | 53615 | ice_skating_field_condition | 2019-12-02T08:37:06.492448+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6210 | 47279 | ice_skating_field_condition | 2019-12-02T08:38:58.204779+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6211 | 39370 | ice_skating_field_condition | 2019-12-02T10:20:56.683189+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6212 | 42185 | notice | 2019-12-02T12:47:46.456835+0200 | Huoltotauko klo 16-17 joka päivä, jolloin ei pääsyä kentille tai kaukaloon.Ma-pe 8-16 & 17-21:30La-su 9-16 & 17-21:30 | |||||||||
| 6213 | 42185 | ice_skating_field_condition | 2019-12-02T12:47:54.665036+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6214 | 41770 | ice_skating_field_condition | 2019-12-02T12:48:12.538048+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6215 | 42526 | ice_skating_field_condition | 2019-12-02T14:09:55.944068+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
| 6216 | 47279 | ice_skating_field_condition | 2019-12-03T07:07:11.332542+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6217 | 42185 | ice_skating_field_condition | 2019-12-03T08:35:18.715948+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6218 | 41770 | ice_skating_field_condition | 2019-12-03T08:35:19.909809+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6219 | 42185 | ice_skating_field_condition | 2019-12-03T08:35:36.289105+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6220 | 51402 | ice_skating_field_condition | 2019-12-03T08:51:31.988258+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6221 | 53615 | ice_skating_field_condition | 2019-12-03T08:57:36.672279+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6222 | 51402 | ice_skating_field_condition | 2019-12-03T09:02:35.675224+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6223 | 40402 | ice_skating_field_condition | 2019-12-03T09:06:01.593874+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6224 | 50354 | ice_skating_field_condition | 2019-12-03T11:31:34.403950+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6225 | 53523 | ice_skating_field_condition | 2019-12-03T11:47:43.112761+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6226 | 53524 | ice_skating_field_condition | 2019-12-03T11:47:55.237699+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
| 6227 | 39834 | ice_skating_field_condition | 2019-12-03T14:37:30.361057+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6228 | 53563 | ice_skating_field_condition | 2019-12-03T16:03:48.863301+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6229 | 47279 | ice_skating_field_condition | 2019-12-04T07:08:08.678077+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6230 | 53615 | ice_skating_field_condition | 2019-12-04T07:32:47.615172+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6231 | 40402 | ice_skating_field_condition | 2019-12-04T07:34:55.655757+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 );