observation
51,120 rows
This data as json, CSV (advanced)
name_sv ✖
- Inga blågröna alger 1,556
- Lite blågröna alger 1,063
- Isad 1,057
- 17-19°C 594
- 19-21°C 514
- Plogad 424
- 15-17°C 415
- 21-23°C 373
- Stängd 319
- under 15°C 213
- Iståndsatt 160
- över 23°C 125
- Isningen har inletts 103
- Bra 96
- Hyfsad 74
- Rikligt med blågröna alger 54
- Snöbrist 54
- Stängd av andra skäl 16
- Svag 16
- Snöproduktionen oavslutad 7
- Säsongen igång 7
- Mycket rikligt med blågröna alger 5
- Säsongen är över 5
- Tävlingar/träningar 3
- Grunden lagd (inget skidspår) 2
id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6851 | 60871 | ski_trail_condition | 2020-01-15T21:21:28.793075+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6852 | 53710 | ski_trail_maintenance | 2020-01-16T07:42:51.652733+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6853 | 53710 | ski_trail_condition | 2020-01-16T07:42:51.652733+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6854 | 53615 | ice_skating_field_condition | 2020-01-16T07:54:07.831518+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6855 | 57401 | ski_trail_maintenance | 2020-01-16T07:55:35.906710+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6856 | 57401 | ski_trail_condition | 2020-01-16T07:55:35.906710+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6857 | 53524 | ice_skating_field_condition | 2020-01-16T08:09:13.267322+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6858 | 53523 | ice_skating_field_condition | 2020-01-16T08:09:20.082547+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6859 | 40421 | ice_skating_field_condition | 2020-01-16T09:45:01.903463+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6860 | 57401 | ski_trail_maintenance | 2020-01-16T10:45:40.686359+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6861 | 57401 | ski_trail_condition | 2020-01-16T10:45:40.686359+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6862 | 47279 | ice_skating_field_condition | 2020-01-16T12:31:59.932540+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6863 | 47279 | ice_skating_field_condition | 2020-01-16T13:52:38.421614+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6864 | 40402 | ice_skating_field_condition | 2020-01-16T14:21:36.304981+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6865 | 53524 | ice_skating_field_condition | 2020-01-16T15:08:15.261424+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6866 | 39834 | ice_skating_field_condition | 2020-01-16T15:10:26.385509+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6867 | 53563 | ice_skating_field_condition | 2020-01-16T15:10:41.394712+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6868 | 53563 | ice_skating_field_condition | 2020-01-16T18:17:16.461445+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6869 | 53710 | ski_trail_maintenance | 2020-01-17T06:35:55.553872+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6870 | 53710 | ski_trail_condition | 2020-01-17T06:35:55.553872+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6871 | 53710 | notice | 2020-01-17T06:36:08.077015+0200 | ||||||||||
6872 | 53710 | notice | 2020-01-17T06:36:40.848679+0200 | Latua noin 1.8 km | |||||||||
6873 | 47279 | ice_skating_field_condition | 2020-01-17T07:31:18.971650+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6874 | 57401 | ski_trail_maintenance | 2020-01-17T07:46:21.549817+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6875 | 57401 | ski_trail_condition | 2020-01-17T07:46:21.549817+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6876 | 60871 | ski_trail_maintenance | 2020-01-17T08:15:49.872372+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6877 | 60871 | ski_trail_condition | 2020-01-17T08:15:49.872372+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6878 | 41549 | ice_skating_field_condition | 2020-01-17T08:36:13.299140+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6879 | 53615 | ice_skating_field_condition | 2020-01-17T08:40:04.482516+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6880 | 53524 | ice_skating_field_condition | 2020-01-17T09:12:49.893445+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6881 | 53523 | ice_skating_field_condition | 2020-01-17T09:13:00.754676+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6882 | 40402 | ice_skating_field_condition | 2020-01-17T09:16:04.095930+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6883 | 40421 | ice_skating_field_condition | 2020-01-17T09:39:32.342085+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6884 | 40421 | ice_skating_field_condition | 2020-01-17T09:40:19.612886+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6885 | 60871 | notice | 2020-01-17T09:57:35.816255+0200 | ||||||||||
6886 | 42185 | ice_skating_field_condition | 2020-01-17T12:34:29.999132+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6887 | 41770 | ice_skating_field_condition | 2020-01-17T12:34:38.574441+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6888 | 57401 | ski_trail_maintenance | 2020-01-17T13:29:49.942021+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6889 | 57401 | ski_trail_condition | 2020-01-17T13:29:49.942021+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6890 | 40421 | notice | 2020-01-17T14:02:23.978558+0200 | Avoinna säävarauksella 10.00 - 21.30 | |||||||||
6891 | 39834 | ice_skating_field_condition | 2020-01-17T14:48:15.891076+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6892 | 53563 | ice_skating_field_condition | 2020-01-17T15:24:23.819217+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6893 | 39834 | ice_skating_field_condition | 2020-01-17T15:24:42.889765+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6894 | 53710 | ski_trail_maintenance | 2020-01-18T00:51:56.860643+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6895 | 53710 | ski_trail_condition | 2020-01-18T00:51:56.860643+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6896 | 57401 | ski_trail_maintenance | 2020-01-18T07:25:32.604944+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6897 | 57401 | ski_trail_condition | 2020-01-18T07:25:32.604944+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6898 | 47279 | ice_skating_field_condition | 2020-01-18T07:50:31.798131+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6899 | 50354 | ice_skating_field_condition | 2020-01-18T07:51:14.309712+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6900 | 60871 | ski_trail_maintenance | 2020-01-18T07:57:33.829939+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6901 | 60871 | ski_trail_condition | 2020-01-18T07:57:33.829939+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6902 | 53615 | ice_skating_field_condition | 2020-01-18T09:34:52.391406+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6903 | 42185 | ice_skating_field_condition | 2020-01-18T09:36:04.853355+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6904 | 41770 | ice_skating_field_condition | 2020-01-18T09:36:22.557478+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6905 | 53524 | ice_skating_field_condition | 2020-01-18T09:45:18.989286+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6906 | 53523 | ice_skating_field_condition | 2020-01-18T09:45:25.075395+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6907 | 40421 | ice_skating_field_condition | 2020-01-18T10:15:15.856264+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6908 | 42699 | ice_skating_field_condition | 2020-01-18T10:47:55.299521+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6909 | 53563 | ice_skating_field_condition | 2020-01-18T11:39:20.910975+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6910 | 39834 | ice_skating_field_condition | 2020-01-18T11:39:28.771945+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6911 | 40493 | ice_skating_field_condition | 2020-01-18T12:12:13.948379+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6912 | 39834 | ice_skating_field_condition | 2020-01-18T14:44:34.605732+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6913 | 53563 | ice_skating_field_condition | 2020-01-18T14:45:02.785453+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6914 | 53710 | ski_trail_condition | 2020-01-19T03:09:43.545641+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6915 | 57401 | ski_trail_condition | 2020-01-19T07:02:49.458039+0200 | Heikko | Svag | 1 | Poor condition | poor | unusable | ||||
6916 | 60871 | ski_trail_maintenance | 2020-01-19T07:47:33.094254+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6917 | 60871 | ski_trail_condition | 2020-01-19T07:47:33.094254+0200 | Tyydyttävä | Hyfsad | 1 | Decent | satisfactory | satisfactory | ||||
6918 | 41770 | ice_skating_field_condition | 2020-01-19T08:22:55.706889+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6919 | 42185 | ice_skating_field_condition | 2020-01-19T08:23:19.984872+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6920 | 53524 | ice_skating_field_condition | 2020-01-19T08:30:59.201108+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6921 | 53523 | ice_skating_field_condition | 2020-01-19T08:31:10.128243+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6922 | 53524 | ice_skating_field_condition | 2020-01-19T08:32:16.848348+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6923 | 53524 | notice | 2020-01-19T08:34:48.547212+0200 | Ma-Su 10-21,00 , Kaukalo suljettu. | |||||||||
6924 | 53524 | ice_skating_field_condition | 2020-01-19T08:34:55.538700+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6925 | 47279 | ice_skating_field_condition | 2020-01-19T08:39:52.892792+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6926 | 53615 | ice_skating_field_condition | 2020-01-19T08:40:18.552544+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6927 | 40402 | ice_skating_field_condition | 2020-01-19T08:51:34.531914+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6928 | 53615 | ice_skating_field_condition | 2020-01-19T09:19:17.283390+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6929 | 53615 | notice | 2020-01-19T09:20:58.788322+0200 | Kenttä avoinna päivittäin klo 08-22. Huoltotöitä kentällä tehdään aukioloaikana aina tarpeen mukaan. | |||||||||
6930 | 41770 | ice_skating_field_condition | 2020-01-19T09:47:47.352804+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
6931 | 40725 | notice | 2020-01-19T13:07:48.241662+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! | |||||||||
6932 | 40725 | notice | 2020-01-19T13:09:06.836721+0200 | 19.1.2020 Ei yleisöluistelua klo.12.00-17.00! Muuten auki normaalisti. | |||||||||
6933 | 40725 | notice | 2020-01-19T13:09:09.182773+0200 | 19.1.2020 Ei yleisöluistelua klo.12.00-17.00! Muuten auki normaalisti. | |||||||||
6934 | 40725 | notice | 2020-01-19T13:09:16.781503+0200 | 19.1.2020 Ei yleisöluistelua klo.12.00-17.00! Muuten auki normaalisti. | |||||||||
6935 | 41657 | ice_skating_field_condition | 2020-01-19T13:34:29.227140+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6936 | 40725 | notice | 2020-01-19T13:36:44.498666+0200 | 19.1.2020 Ei yleisöluistelua klo.12.00-17.00! Muuten auki normaalisti. Lauantaina 1.2.2020 Ei yleisöluistelua klo 10.30 - 17.00! | |||||||||
6937 | 40725 | notice | 2020-01-19T13:37:15.562596+0200 | 19.1.2020 Ei yleisöluistelua klo.12.00-17.00! Muuten auki normaalisti. Lauantaina 1.2.2020 Ei yleisöluistelua klo 10.30 - 17.00! | |||||||||
6938 | 42185 | notice | 2020-01-19T13:57:04.217503+0200 | Puoli kenttää kiinni: jää puhki!Huoltotauko klo 16-17 joka päivä, jolloin ei pääsyä kentille tai kaukaloon.Kaukalo varattu keskiviikkoisin 17-18:30 ja torataisin 17-19:30.Ma-pe 8-16 & 17-21:30La-su 9-16 & 17-21:30 | |||||||||
6939 | 39834 | ice_skating_field_condition | 2020-01-19T14:16:38.721196+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6940 | 53563 | ice_skating_field_condition | 2020-01-19T14:55:49.455106+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6941 | 53563 | ice_skating_field_condition | 2020-01-19T17:56:10.612624+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6942 | 41770 | ice_skating_field_condition | 2020-01-19T19:36:06.520927+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6943 | 42185 | ice_skating_field_condition | 2020-01-19T19:36:30.303928+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6944 | 57401 | ski_trail_condition | 2020-01-20T07:28:16.861669+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
6945 | 47279 | ice_skating_field_condition | 2020-01-20T07:31:06.500161+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6946 | 53710 | ski_trail_maintenance | 2020-01-20T07:34:37.896855+0200 | Kunnostettu | Iståndsatt | 0 | Maintenance finished | maintenance_finished | unknown | ||||
6947 | 53710 | ski_trail_condition | 2020-01-20T07:34:37.896855+0200 | Hyvä | Bra | 1 | Good condition | good | good | ||||
6948 | 60871 | ski_trail_condition | 2020-01-20T08:14:14.650798+0200 | Heikko | Svag | 1 | Poor condition | poor | unusable | ||||
6949 | 53615 | ice_skating_field_condition | 2020-01-20T08:33:06.760893+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
6950 | 40402 | ice_skating_field_condition | 2020-01-20T08:38:49.481021+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 );