observation

51,120 rows

✎ View and edit SQL

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
3726 41326 swimming_water_cyanobacteria 2019-07-22T08:11:56.421547+0300 2019-07-23T08:11:56.421547+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3727 40020 swimming_water_temperature 2019-07-22T08:15:38.866993+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3728 39568 swimming_water_temperature 2019-07-22T08:16:04.529423+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3729 40020 swimming_water_cyanobacteria 2019-07-22T08:16:06.698654+0300 2019-07-23T08:16:06.698654+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3730 39568 swimming_water_cyanobacteria 2019-07-22T08:16:08.894946+0300 2019-07-23T08:16:08.894946+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3731 39568 swimming_water_temperature 2019-07-22T08:16:15.631992+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3732 39568 swimming_water_cyanobacteria 2019-07-22T08:16:18.899205+0300 2019-07-23T08:16:18.899205+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3733 40921 swimming_water_temperature 2019-07-22T08:16:24.279440+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3734 40921 swimming_water_cyanobacteria 2019-07-22T08:16:30.286356+0300 2019-07-23T08:16:30.286356+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3735 39823 swimming_water_temperature 2019-07-22T08:16:40.107990+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3736 39910 swimming_water_temperature 2019-07-22T08:16:42.547882+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3737 39910 swimming_water_cyanobacteria 2019-07-22T08:16:47.276469+0300 2019-07-23T08:16:47.276469+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3738 40798 swimming_water_temperature 2019-07-22T08:17:02.714892+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3739 40798 swimming_water_cyanobacteria 2019-07-22T08:17:09.444473+0300 2019-07-23T08:17:09.444473+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3740 39823 swimming_water_cyanobacteria 2019-07-22T08:17:12.311416+0300 2019-07-23T08:17:12.311416+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3741 39823 swimming_water_cyanobacteria 2019-07-22T08:17:23.094466+0300 2019-07-23T08:17:23.094466+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3742 40993 swimming_water_temperature 2019-07-22T08:17:35.492919+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3743 53461 swimming_water_temperature 2019-07-22T08:17:42.935395+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3744 40993 swimming_water_cyanobacteria 2019-07-22T08:17:54.773819+0300 2019-07-23T08:17:54.773819+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3745 53461 swimming_water_cyanobacteria 2019-07-22T08:18:39.672717+0300 2019-07-23T08:18:39.672717+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3746 39713 swimming_water_temperature 2019-07-22T08:53:15.319743+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3747 39713 swimming_water_cyanobacteria 2019-07-22T08:53:20.405941+0300 2019-07-23T08:53:20.405941+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3748 39875 swimming_water_temperature 2019-07-22T09:16:24.688593+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3749 39875 swimming_water_cyanobacteria 2019-07-22T09:16:28.470908+0300 2019-07-23T09:16:28.470908+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3750 39568 notice 2019-07-22T09:22:12.642368+0300   Valvontaa rannalla joka päivä klo 8-20 aina 11.8. saakka, tervetuloa!                
3751 39568 notice 2019-07-22T09:22:18.626877+0300   Valvontaa rannalla joka päivä klo 8-20 aina 11.8. saakka, tervetuloa!                
3752 39527 swimming_water_cyanobacteria 2019-07-22T09:30:27.536267+0300 2019-07-23T09:30:27.536267+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3753 39527 swimming_water_temperature 2019-07-22T09:30:50.084259+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3754 39902 swimming_water_temperature 2019-07-22T09:34:57.155273+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3755 39902 swimming_water_cyanobacteria 2019-07-22T09:35:00.255110+0300 2019-07-23T09:35:00.255110+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3756 39693 swimming_water_temperature 2019-07-22T09:35:13.821370+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3757 39693 swimming_water_cyanobacteria 2019-07-22T09:35:17.056241+0300 2019-07-23T09:35:17.056241+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3758 39693 notice 2019-07-22T09:35:29.615080+0300   Veden lämpötila 21ºC.                
3759 39606 swimming_water_temperature 2019-07-22T09:50:11.274865+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3760 39606 swimming_water_cyanobacteria 2019-07-22T09:50:32.555222+0300 2019-07-23T09:50:32.555222+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3761 39815 swimming_water_temperature 2019-07-22T09:51:42.309735+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3762 39815 swimming_water_cyanobacteria 2019-07-22T09:51:48.030598+0300 2019-07-23T09:51:48.030598+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3763 39815 notice 2019-07-22T09:52:00.097844+0300   Veden lämpötila 20ºC                
3764 40559 swimming_water_cyanobacteria 2019-07-22T10:02:48.084565+0300 2019-07-23T10:02:48.084565+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3765 40559 swimming_water_temperature 2019-07-22T10:02:54.366650+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3766 41601 swimming_water_temperature 2019-07-22T10:03:05.164866+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3767 41601 swimming_water_cyanobacteria 2019-07-22T10:03:08.402996+0300 2019-07-23T10:03:08.402996+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3768 39322 swimming_water_temperature 2019-07-22T10:04:21.673127+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3769 39322 swimming_water_cyanobacteria 2019-07-22T10:04:24.708658+0300 2019-07-23T10:04:24.708658+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3770 41791 swimming_water_temperature 2019-07-22T10:06:44.447315+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3771 41791 swimming_water_cyanobacteria 2019-07-22T10:06:48.537519+0300 2019-07-23T10:06:48.537519+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3772 40098 swimming_water_temperature 2019-07-22T10:08:01.858151+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3773 40098 swimming_water_cyanobacteria 2019-07-22T10:08:02.049268+0300 2019-07-23T10:08:02.049268+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3774 40098 notice 2019-07-22T10:08:02.242281+0300   Uimaranta auki. Rannalla valvoja paikalla 3.6.-10.8.2019 saakka klo 10-18. Ranta hyvässä kunnossa.                
3775 40098 notice 2019-07-22T10:08:02.422797+0300   Uimaranta auki. Rannalla valvoja paikalla 3.6.-10.8.2019 saakka klo 10-18. Ranta hyvässä kunnossa.                
3776 41960 swimming_water_temperature 2019-07-22T10:08:20.466247+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3777 41960 swimming_water_cyanobacteria 2019-07-22T10:08:24.492906+0300 2019-07-23T10:08:24.492906+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3778 40157 swimming_water_cyanobacteria 2019-07-22T10:08:44.136053+0300 2019-07-23T10:08:44.136053+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3779 40157 swimming_water_temperature 2019-07-22T10:09:06.198105+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3780 40386 swimming_water_temperature 2019-07-22T10:12:55.367129+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3781 40386 swimming_water_cyanobacteria 2019-07-22T10:13:02.935136+0300 2019-07-23T10:13:02.935136+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3782 39583 swimming_water_temperature 2019-07-22T10:21:25.008435+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3783 39583 swimming_water_cyanobacteria 2019-07-22T10:21:28.514540+0300 2019-07-23T10:21:28.514540+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3784 39583 notice 2019-07-22T10:21:45.810929+0300   Valvontaa rannalla joka päivä klo 10-18 aina 11.8. saakka. Veden lämpötila 21°C, sinilevää runsaasti.                
3785 40150 swimming_water_temperature 2019-07-22T10:29:57.175795+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3786 40150 swimming_water_cyanobacteria 2019-07-22T10:30:00.122845+0300 2019-07-23T10:30:00.122845+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
3787 39267 swimming_water_temperature 2019-07-22T10:30:29.201404+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3788 39267 swimming_water_cyanobacteria 2019-07-22T10:30:32.509663+0300 2019-07-23T10:30:32.509663+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
3789 40559 notice 2019-07-22T10:32:08.436209+0300   Puh/tel: +358503420926 |FI| Uimaranta on valvottu 3.6. -11.8.2019 klo 10.00-18.00. WC:t ja ulkoliikuntasali auki klo 7.00 - 17.45. POIKKEUKSELLISESTI TIISTAINA JA KESKIVIIKKONA 23. - 24.7. ULKOSALI JA WC:T POIKKEUKSELLISESTI AUKI 10.00- 17.45. Pukukopit ja ulkosuihkut ovat avoinna vuorokauden ympäri.|SV| Badstranden är övervakad 3.6- 11.8.2019 kl. 10.00-18.00. Toaletterna och utegymmet är öppna kl. 7.00- 17.45. TISDAGEN OCH ONSDAGEN 23. - 24.7 ÄR UTEGYMMET OCH TOALETTERNA ÖPPNA KL. 10.00-17.45. Omklädningsrummen och duscharna är öppna dygnet runt. |EN| The beach is guarded 3.6.-11.8.2019 at 10:00am-6:00pm. The toilets and the outdoor gym are open at 7:00am-5:45pm. TUESDAY AND WEDNESDAY 23rd - 24th OF JULY THE TOILETS AND OUTDOORGYM OPEN 10.00am - 5.45pm. The changing rooms and showers are open around the clock.                
3790 40802 swimming_water_temperature 2019-07-22T10:32:32.624333+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3791 40802 swimming_water_cyanobacteria 2019-07-22T10:32:37.023803+0300 2019-07-23T10:32:37.023803+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3792 39412 swimming_water_temperature 2019-07-22T10:55:58.092753+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3793 39412 swimming_water_cyanobacteria 2019-07-22T10:56:10.022312+0300 2019-07-23T10:56:10.022312+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3794 40950 swimming_water_temperature 2019-07-22T10:59:54.343644+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3795 40950 swimming_water_cyanobacteria 2019-07-22T11:00:04.505924+0300 2019-07-23T11:00:04.505924+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3796 52959 swimming_water_temperature 2019-07-22T11:57:18.259840+0300     yli 23°C   över 23°C 0 above 23°C 23-100 unknown  
3797 52959 swimming_water_cyanobacteria 2019-07-22T11:57:35.791785+0300 2019-07-23T11:57:35.791785+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3798 39693 notice 2019-07-22T13:56:25.938426+0300   Veden lämpötila 21ºC.                
3799 39815 swimming_water_temperature 2019-07-22T14:05:59.089055+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3800 39815 swimming_water_cyanobacteria 2019-07-22T14:06:03.152934+0300 2019-07-23T14:06:03.152934+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3801 39815 notice 2019-07-22T14:06:16.239657+0300   Veden lämpötila 21ºC                
3802 39267 swimming_water_temperature 2019-07-22T14:07:58.998499+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3803 39267 swimming_water_cyanobacteria 2019-07-22T14:08:04.367743+0300 2019-07-23T14:08:04.367743+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
3804 39322 swimming_water_temperature 2019-07-22T14:11:03.444364+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3805 39322 swimming_water_cyanobacteria 2019-07-22T14:11:05.610354+0300 2019-07-23T14:11:05.610354+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3806 39568 swimming_water_temperature 2019-07-22T14:23:04.067597+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3807 39568 swimming_water_cyanobacteria 2019-07-22T14:23:09.247433+0300 2019-07-23T14:23:09.247433+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3808 39583 swimming_water_temperature 2019-07-22T14:42:45.991490+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3809 39583 swimming_water_cyanobacteria 2019-07-22T14:42:48.954718+0300 2019-07-23T14:42:48.954718+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3810 39583 notice 2019-07-22T14:42:50.739394+0300   Valvontaa rannalla joka päivä klo 10-18 aina 11.8. saakka. Veden lämpötila 21°C, sinilevää runsaasti.                
3811 40258 swimming_water_temperature 2019-07-22T15:58:23.376726+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3812 40258 swimming_water_cyanobacteria 2019-07-22T15:58:38.039181+0300 2019-07-23T15:58:38.039181+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3813 39267 swimming_water_temperature 2019-07-22T17:42:43.626233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3814 39267 swimming_water_cyanobacteria 2019-07-22T17:42:46.894045+0300 2019-07-23T17:42:46.894045+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
3815 39815 swimming_water_temperature 2019-07-22T18:01:58.683573+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3816 39815 notice 2019-07-22T18:02:01.547230+0300   Veden lämpötila 21ºC                
3817 39815 notice 2019-07-22T18:02:04.460404+0300   Veden lämpötila 21ºC                
3818 39693 swimming_water_cyanobacteria 2019-07-22T18:07:27.941291+0300 2019-07-23T18:07:27.941291+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3819 39693 swimming_water_temperature 2019-07-22T18:07:32.680206+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3820 39693 swimming_water_temperature 2019-07-22T18:07:36.199011+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3821 39693 notice 2019-07-22T18:07:37.406140+0300   Veden lämpötila 21ºC.                
3822 39322 swimming_water_temperature 2019-07-22T18:20:20.549804+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
3823 39322 swimming_water_cyanobacteria 2019-07-22T18:20:24.897439+0300 2019-07-23T18:20:24.897439+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
3824 39568 swimming_water_temperature 2019-07-22T19:13:08.021048+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3825 39568 swimming_water_cyanobacteria 2019-07-22T19:13:11.853299+0300 2019-07-23T19:13:11.853299+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  

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