observation
51,120 rows sorted by unit descending
This data as json, CSV (advanced)
name_en ✖
- No cyanobacteria 2,809
- Some cyanobacteria 1,881
- Ice-covered 1,401
- 17-19°C 1,261
- 19-21°C 1,246
- 15-17°C 818
- 21-23°C 746
- Cleared of snow 516
- below 15°C 497
- Closed 417
- Plenty of cyanobacteria 281
- Maintenance finished 220
- above 23°C 180
- Good condition 147
- The icing has begun 116
- Very high levels of cyanobacteria 94
- Decent 92
- Lack of snow 54
- Poor condition 20
- Closed for other reasons 16
- Snowmaking unfinished 16
- Season underway 10
- Season over 5
- Closed due to training or a competition 4
- Foundation laid (no skiing trail) 2
id | unit ▲ | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9106 | 62213 | notice | 2020-06-11T10:38:02.303974+0300 | 11.6. - 16.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | |||||||||
9107 | 62213 | season_status | 2020-06-11T10:38:11.281508+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
9118 | 62213 | season_status | 2020-06-11T14:35:59.683244+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
9648 | 62213 | notice | 2020-06-18T09:46:05.853079+0300 | 11.6. - 16.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm: Juhannuksena, pe 19. - su 21.6., ei ole valvontaa.• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | |||||||||
9832 | 62213 | notice | 2020-06-22T10:01:24.422714+0300 | 11.6. - 16.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | |||||||||
9853 | 62213 | season_status | 2020-06-22T10:24:04.934477+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
13866 | 62213 | season_status | 2020-08-16T19:22:42.648552+0300 | Kausi päättynyt | Säsongen är över | 1 | Season over | finished | unusable | ||||
13893 | 62213 | notice | 2020-08-18T08:22:14.292256+0300 | 11.6. - 30.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | |||||||||
13894 | 62213 | season_status | 2020-08-18T08:22:23.635629+0300 | Kausi käynnissä | Säsongen igång | 1 | Season underway | started | good | ||||
13895 | 62213 | notice | 2020-08-18T08:22:51.467163+0300 | 11.6. - 30.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | 11.6. - 30.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 2 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | ||||||||
13896 | 62213 | notice | 2020-08-18T08:23:05.870927+0300 | 11.6. - 30.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 1 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | 11.6. - 30.8.2020 Avoinna joka päivä klo 10-18 / öppen varje dag kl. 10-18 / open every day 10 am - 6 pm:• 2 suihkua / duschar / showers• 1 bajamajaa / toa / toilets• 2 pukukoppia / omklädningshytter / changing rooms• uimavalvonta / bevakning / supervision Tervetuloa Välkommen Welcome! | ||||||||
15389 | 62213 | season_status | 2020-08-31T07:36:03.896528+0300 | Kausi päättynyt | Säsongen är över | 1 | Season over | finished | unusable | ||||
7257 | 61464 | ice_skating_field_condition | 2020-02-04T12:31:19.353401+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7259 | 61464 | ice_skating_field_condition | 2020-02-04T12:35:55.483850+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7277 | 61464 | ice_skating_field_condition | 2020-02-05T07:51:41.382102+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7278 | 61464 | notice | 2020-02-05T07:51:53.103530+0200 | Ei saada auki kuin vasta päivähuollon jälkeen. Viivat tehty yöllä ja nyt täytyy pintaa kasvattaa | |||||||||
7319 | 61464 | ice_skating_field_condition | 2020-02-05T17:11:37.426027+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7320 | 61464 | notice | 2020-02-05T17:12:33.333746+0200 | 5.2 ke ollaan auki klo 17-21.30 | |||||||||
7321 | 61464 | ice_skating_field_condition | 2020-02-05T17:12:47.771932+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7337 | 61464 | ice_skating_field_condition | 2020-02-06T09:05:53.092677+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7364 | 61464 | notice | 2020-02-06T14:51:23.489038+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30 | |||||||||
7365 | 61464 | notice | 2020-02-06T14:52:59.552513+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7369 | 61464 | ice_skating_field_condition | 2020-02-06T17:05:06.480301+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7389 | 61464 | ice_skating_field_condition | 2020-02-07T08:55:16.020653+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7421 | 61464 | ice_skating_field_condition | 2020-02-07T17:15:15.880995+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7439 | 61464 | ice_skating_field_condition | 2020-02-08T09:21:27.512535+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7479 | 61464 | ice_skating_field_condition | 2020-02-09T08:36:55.573148+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7517 | 61464 | ice_skating_field_condition | 2020-02-10T07:59:09.439201+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7545 | 61464 | notice | 2020-02-10T18:15:37.444777+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7546 | 61464 | notice | 2020-02-10T18:16:05.388430+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7547 | 61464 | notice | 2020-02-10T18:16:08.871910+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7548 | 61464 | notice | 2020-02-10T18:16:09.904087+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7549 | 61464 | notice | 2020-02-10T18:16:11.769174+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7550 | 61464 | ice_skating_field_condition | 2020-02-10T20:16:20.584999+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7554 | 61464 | ice_skating_field_condition | 2020-02-11T07:37:36.431449+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7579 | 61464 | ice_skating_field_condition | 2020-02-11T17:24:55.623749+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7590 | 61464 | ice_skating_field_condition | 2020-02-12T08:47:48.592918+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7601 | 61464 | ice_skating_field_condition | 2020-02-12T17:08:07.659592+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7602 | 61464 | ice_skating_field_condition | 2020-02-12T17:08:11.196942+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7603 | 61464 | ice_skating_field_condition | 2020-02-12T17:08:20.842066+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7611 | 61464 | ice_skating_field_condition | 2020-02-13T08:37:00.540211+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7638 | 61464 | ice_skating_field_condition | 2020-02-14T12:50:37.599287+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7639 | 61464 | ice_skating_field_condition | 2020-02-14T12:50:51.012570+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7640 | 61464 | notice | 2020-02-14T12:51:14.177040+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle. | |||||||||
7644 | 61464 | ice_skating_field_condition | 2020-02-14T18:11:09.439502+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7645 | 61464 | ice_skating_field_condition | 2020-02-14T18:12:10.461852+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7665 | 61464 | ice_skating_field_condition | 2020-02-15T10:22:04.711930+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7672 | 61464 | ice_skating_field_condition | 2020-02-15T16:52:10.563129+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7678 | 61464 | ice_skating_field_condition | 2020-02-16T07:58:42.108605+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7694 | 61464 | ice_skating_field_condition | 2020-02-16T13:57:22.507126+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7706 | 61464 | ice_skating_field_condition | 2020-02-17T09:40:12.718988+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7714 | 61464 | ice_skating_field_condition | 2020-02-17T17:04:40.216881+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7727 | 61464 | ice_skating_field_condition | 2020-02-18T11:44:31.678087+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7728 | 61464 | ice_skating_field_condition | 2020-02-18T11:44:46.822122+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7737 | 61464 | ice_skating_field_condition | 2020-02-18T16:03:55.678985+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7750 | 61464 | notice | 2020-02-19T08:51:10.903746+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen puoli vapaaluistelulle.Huom! Ke 19.2 avaamme poikkeuksellisesti klo 10 | |||||||||
7751 | 61464 | ice_skating_field_condition | 2020-02-19T08:51:25.578320+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
7762 | 61464 | ice_skating_field_condition | 2020-02-19T10:10:44.606665+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7763 | 61464 | notice | 2020-02-19T10:13:27.804995+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
7776 | 61464 | ice_skating_field_condition | 2020-02-20T07:42:54.364140+0200 | Jäädytys aloitettu | Isningen har inletts | 1 | The icing has begun | freezing_started | unusable | ||||
7777 | 61464 | notice | 2020-02-20T07:43:49.075420+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu.Huom! Avaamme tänään to 20.2 klo 9.00 | |||||||||
7783 | 61464 | ice_skating_field_condition | 2020-02-20T08:41:41.428706+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7784 | 61464 | notice | 2020-02-20T08:42:02.569933+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
7790 | 61464 | ice_skating_field_condition | 2020-02-20T17:04:28.339218+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7805 | 61464 | ice_skating_field_condition | 2020-02-21T16:50:44.707967+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7809 | 61464 | ice_skating_field_condition | 2020-02-22T07:29:15.403732+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
7848 | 61464 | ice_skating_field_condition | 2020-02-24T18:37:58.775359+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7879 | 61464 | ice_skating_field_condition | 2020-02-25T17:07:30.835561+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7894 | 61464 | ice_skating_field_condition | 2020-02-26T09:03:57.662662+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7895 | 61464 | ice_skating_field_condition | 2020-02-26T09:04:23.242114+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7904 | 61464 | ice_skating_field_condition | 2020-02-26T18:11:25.013584+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7915 | 61464 | ice_skating_field_condition | 2020-02-27T08:45:34.961952+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7924 | 61464 | ice_skating_field_condition | 2020-02-27T16:57:18.730616+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7940 | 61464 | ice_skating_field_condition | 2020-02-28T11:23:27.893368+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7947 | 61464 | ice_skating_field_condition | 2020-02-28T16:51:47.520519+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7955 | 61464 | ice_skating_field_condition | 2020-02-29T08:54:17.867006+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7980 | 61464 | ice_skating_field_condition | 2020-02-29T17:10:42.633191+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7981 | 61464 | ice_skating_field_condition | 2020-02-29T17:11:02.251049+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7982 | 61464 | ice_skating_field_condition | 2020-02-29T17:11:19.031478+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
7983 | 61464 | notice | 2020-02-29T17:11:55.510600+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
7988 | 61464 | ice_skating_field_condition | 2020-03-01T08:37:51.682607+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
7999 | 61464 | ice_skating_field_condition | 2020-03-01T16:41:40.346915+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8000 | 61464 | ice_skating_field_condition | 2020-03-01T16:42:05.310106+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8001 | 61464 | notice | 2020-03-01T16:42:27.639071+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8002 | 61464 | ice_skating_field_condition | 2020-03-01T18:41:16.245570+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
8003 | 61464 | ice_skating_field_condition | 2020-03-02T07:35:45.738734+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
8011 | 61464 | ice_skating_field_condition | 2020-03-02T09:27:43.267929+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8025 | 61464 | ice_skating_field_condition | 2020-03-02T18:00:08.715774+0200 | Aurattu | Plogad | 1 | Cleared of snow | plowed | good | ||||
8026 | 61464 | notice | 2020-03-02T18:00:16.425378+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8038 | 61464 | ice_skating_field_condition | 2020-03-03T08:41:58.411325+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8050 | 61464 | ice_skating_field_condition | 2020-03-04T08:57:31.238232+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8051 | 61464 | notice | 2020-03-04T08:57:42.806955+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8060 | 61464 | ice_skating_field_condition | 2020-03-04T15:08:14.828629+0200 | Suljettu | Stängd | 1 | Closed | closed | unusable | ||||
8066 | 61464 | ice_skating_field_condition | 2020-03-05T07:55:30.420042+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8067 | 61464 | notice | 2020-03-05T07:55:34.103714+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8068 | 61464 | notice | 2020-03-05T07:55:38.116470+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8069 | 61464 | notice | 2020-03-05T07:55:42.052597+0200 | Aukioloajat: ma-ti klo 8.30-15.30 ja 17-21.30,Ke klo 9.00-15.30 ja 17-21.30,To-su klo 8.30-15.30 ja 17-21.30Toinen puoli mailalliset ja toinen vapaaluistelu. | |||||||||
8070 | 61464 | ice_skating_field_condition | 2020-03-05T07:55:59.489687+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8090 | 61464 | ice_skating_field_condition | 2020-03-06T08:42:26.876735+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
8091 | 61464 | ice_skating_field_condition | 2020-03-06T08:42:43.170468+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 );