observation

2,809 rows where name_sv = "Inga blågröna alger" and primary = 1

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 1 · 2,614 ✖

name_sv ✖

  • Inga blågröna alger · 2,614 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
680 52959 swimming_water_cyanobacteria 2019-06-13T14:04:24.716882+0300 2019-06-14T14:04:24.716882+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
682 39693 swimming_water_cyanobacteria 2019-06-13T14:06:23.422071+0300 2019-06-14T14:06:23.422071+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
686 39267 swimming_water_cyanobacteria 2019-06-13T15:03:58.499130+0300 2019-06-14T15:03:58.499130+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
688 39568 swimming_water_cyanobacteria 2019-06-13T16:33:43.907634+0300 2019-06-14T16:33:43.907634+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
691 39693 swimming_water_cyanobacteria 2019-06-13T18:02:43.040796+0300 2019-06-14T18:02:43.040796+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
693 39568 swimming_water_cyanobacteria 2019-06-13T18:16:59.277736+0300 2019-06-14T18:16:59.277736+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
696 39322 swimming_water_cyanobacteria 2019-06-13T18:42:37.809008+0300 2019-06-14T18:42:37.809008+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
698 39823 swimming_water_cyanobacteria 2019-06-14T07:39:11.855315+0300 2019-06-15T07:39:11.855315+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
700 53461 swimming_water_cyanobacteria 2019-06-14T07:52:58.907547+0300 2019-06-15T07:52:58.907547+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
702 39606 swimming_water_cyanobacteria 2019-06-14T08:04:22.205335+0300 2019-06-15T08:04:22.205335+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
704 39902 swimming_water_cyanobacteria 2019-06-14T08:14:40.620870+0300 2019-06-15T08:14:40.620870+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
706 39875 swimming_water_cyanobacteria 2019-06-14T08:29:48.158864+0300 2019-06-15T08:29:48.158864+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
708 39713 swimming_water_cyanobacteria 2019-06-14T08:44:33.769724+0300 2019-06-15T08:44:33.769724+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
710 39322 swimming_water_cyanobacteria 2019-06-14T09:44:12.773863+0300 2019-06-15T09:44:12.773863+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
712 39412 swimming_water_cyanobacteria 2019-06-14T09:53:18.309847+0300 2019-06-15T09:53:18.309847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
715 40157 swimming_water_cyanobacteria 2019-06-14T09:54:34.311727+0300 2019-06-15T09:54:34.311727+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
719 41960 swimming_water_cyanobacteria 2019-06-14T10:02:54.075070+0300 2019-06-15T10:02:54.075070+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
723 40802 swimming_water_cyanobacteria 2019-06-14T10:09:24.570033+0300 2019-06-15T10:09:24.570033+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
725 52959 swimming_water_cyanobacteria 2019-06-14T10:11:35.804338+0300 2019-06-15T10:11:35.804338+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
728 39693 swimming_water_cyanobacteria 2019-06-14T10:25:27.495194+0300 2019-06-15T10:25:27.495194+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
732 40559 swimming_water_cyanobacteria 2019-06-14T10:29:59.856384+0300 2019-06-15T10:29:59.856384+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
735 40150 swimming_water_cyanobacteria 2019-06-14T10:34:07.496242+0300 2019-06-15T10:34:07.496242+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
737 41601 swimming_water_cyanobacteria 2019-06-14T10:42:22.036517+0300 2019-06-15T10:42:22.036517+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
741 39693 swimming_water_cyanobacteria 2019-06-14T14:07:56.224571+0300 2019-06-15T14:07:56.224571+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
750 39693 swimming_water_cyanobacteria 2019-06-14T18:02:15.473684+0300 2019-06-15T18:02:15.473684+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
754 39815 swimming_water_cyanobacteria 2019-06-15T10:01:41.993410+0300 2019-06-16T10:01:41.993410+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
756 41960 swimming_water_cyanobacteria 2019-06-15T10:01:44.545282+0300 2019-06-16T10:01:44.545282+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
760 41791 swimming_water_cyanobacteria 2019-06-15T10:05:51.819768+0300 2019-06-16T10:05:51.819768+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
762 40559 swimming_water_cyanobacteria 2019-06-15T10:11:27.935990+0300 2019-06-16T10:11:27.935990+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
765 40150 swimming_water_cyanobacteria 2019-06-15T10:16:16.253353+0300 2019-06-16T10:16:16.253353+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
773 40258 swimming_water_cyanobacteria 2019-06-15T10:52:30.641758+0300 2019-06-16T10:52:30.641758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
776 40157 swimming_water_cyanobacteria 2019-06-15T10:55:02.791724+0300 2019-06-16T10:55:02.791724+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
778 40142 swimming_water_cyanobacteria 2019-06-15T12:20:16.464612+0300 2019-06-16T12:20:16.464612+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
781 40950 swimming_water_cyanobacteria 2019-06-15T13:44:11.537883+0300 2019-06-16T13:44:11.537883+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
783 39815 swimming_water_cyanobacteria 2019-06-15T13:49:52.772080+0300 2019-06-16T13:49:52.772080+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
788 39693 swimming_water_cyanobacteria 2019-06-15T14:04:53.274329+0300 2019-06-16T14:04:53.274329+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
792 39527 swimming_water_cyanobacteria 2019-06-15T15:56:26.559779+0300 2019-06-16T15:56:26.559779+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
795 39693 swimming_water_cyanobacteria 2019-06-15T17:59:28.788313+0300 2019-06-16T17:59:28.788313+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
800 41031 swimming_water_cyanobacteria 2019-06-16T08:24:10.222166+0300 2019-06-17T08:24:10.222166+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
802 41326 swimming_water_cyanobacteria 2019-06-16T08:24:19.151081+0300 2019-06-17T08:24:19.151081+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
804 41907 swimming_water_cyanobacteria 2019-06-16T08:24:24.540430+0300 2019-06-17T08:24:24.540430+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
806 40798 swimming_water_cyanobacteria 2019-06-16T08:24:31.219659+0300 2019-06-17T08:24:31.219659+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
808 39910 swimming_water_cyanobacteria 2019-06-16T08:24:51.994758+0300 2019-06-17T08:24:51.994758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
810 40921 swimming_water_cyanobacteria 2019-06-16T08:25:15.052868+0300 2019-06-17T08:25:15.052868+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
816 40020 swimming_water_cyanobacteria 2019-06-16T08:26:10.578011+0300 2019-06-17T08:26:10.578011+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
818 40993 swimming_water_cyanobacteria 2019-06-16T08:26:25.457563+0300 2019-06-17T08:26:25.457563+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
820 40677 swimming_water_cyanobacteria 2019-06-16T08:26:35.516847+0300 2019-06-17T08:26:35.516847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
822 52959 swimming_water_cyanobacteria 2019-06-16T09:16:17.039314+0300 2019-06-17T09:16:17.039314+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
824 39815 swimming_water_cyanobacteria 2019-06-16T09:48:16.661376+0300 2019-06-17T09:48:16.661376+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
833 39322 swimming_water_cyanobacteria 2019-06-16T10:08:53.647603+0300 2019-06-17T10:08:53.647603+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
835 41960 swimming_water_cyanobacteria 2019-06-16T10:11:37.127515+0300 2019-06-17T10:11:37.127515+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
837 40150 swimming_water_cyanobacteria 2019-06-16T10:12:19.971699+0300 2019-06-17T10:12:19.971699+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
842 40950 swimming_water_cyanobacteria 2019-06-16T10:14:06.351951+0300 2019-06-17T10:14:06.351951+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
844 41791 swimming_water_cyanobacteria 2019-06-16T10:20:05.332453+0300 2019-06-17T10:20:05.332453+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
846 40802 swimming_water_cyanobacteria 2019-06-16T10:23:41.932085+0300 2019-06-17T10:23:41.932085+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
849 40157 swimming_water_cyanobacteria 2019-06-16T10:25:01.096932+0300 2019-06-17T10:25:01.096932+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
851 40559 swimming_water_cyanobacteria 2019-06-16T10:32:35.162427+0300 2019-06-17T10:32:35.162427+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
855 41601 swimming_water_cyanobacteria 2019-06-16T11:26:45.823624+0300 2019-06-17T11:26:45.823624+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
857 40258 swimming_water_cyanobacteria 2019-06-16T12:13:08.571645+0300 2019-06-17T12:13:08.571645+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
861 40142 swimming_water_cyanobacteria 2019-06-16T13:38:17.003734+0300 2019-06-17T13:38:17.003734+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
864 39815 swimming_water_cyanobacteria 2019-06-16T13:55:10.297721+0300 2019-06-17T13:55:10.297721+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
875 39568 swimming_water_cyanobacteria 2019-06-16T14:18:40.192923+0300 2019-06-17T14:18:40.192923+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
880 39815 swimming_water_cyanobacteria 2019-06-16T17:54:47.460698+0300 2019-06-17T17:54:47.460698+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
882 39568 swimming_water_cyanobacteria 2019-06-16T18:15:21.339903+0300 2019-06-17T18:15:21.339903+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
887 39713 swimming_water_cyanobacteria 2019-06-17T07:41:17.000271+0300 2019-06-18T07:41:17.000271+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
889 39875 swimming_water_cyanobacteria 2019-06-17T08:06:45.742388+0300 2019-06-18T08:06:45.742388+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
891 39902 swimming_water_cyanobacteria 2019-06-17T08:24:43.470303+0300 2019-06-18T08:24:43.470303+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
893 39606 swimming_water_cyanobacteria 2019-06-17T08:37:26.441842+0300 2019-06-18T08:37:26.441842+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
897 53461 swimming_water_cyanobacteria 2019-06-17T09:16:33.034954+0300 2019-06-18T09:16:33.034954+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
899 39823 swimming_water_cyanobacteria 2019-06-17T09:34:09.734799+0300 2019-06-18T09:34:09.734799+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
905 39412 swimming_water_cyanobacteria 2019-06-17T10:05:21.419065+0300 2019-06-18T10:05:21.419065+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
910 40802 swimming_water_cyanobacteria 2019-06-17T10:16:55.530860+0300 2019-06-18T10:16:55.530860+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
912 40150 swimming_water_cyanobacteria 2019-06-17T10:31:50.180847+0300 2019-06-18T10:31:50.180847+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
914 40157 swimming_water_cyanobacteria 2019-06-17T10:42:14.993300+0300 2019-06-18T10:42:14.993300+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
916 40559 swimming_water_cyanobacteria 2019-06-17T10:52:19.847758+0300 2019-06-18T10:52:19.847758+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
919 41601 swimming_water_cyanobacteria 2019-06-17T10:58:25.195607+0300 2019-06-18T10:58:25.195607+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
921 39527 swimming_water_cyanobacteria 2019-06-17T11:16:58.025091+0300 2019-06-18T11:16:58.025091+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
925 40142 swimming_water_cyanobacteria 2019-06-17T13:05:46.817394+0300 2019-06-18T13:05:46.817394+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
941 40950 swimming_water_cyanobacteria 2019-06-17T15:02:38.139510+0300 2019-06-18T15:02:38.139510+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
943 39815 swimming_water_cyanobacteria 2019-06-17T15:06:05.169957+0300 2019-06-18T15:06:05.169957+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
947 39568 swimming_water_cyanobacteria 2019-06-17T17:05:24.741147+0300 2019-06-18T17:05:24.741147+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
949 39693 swimming_water_cyanobacteria 2019-06-17T17:52:06.230768+0300 2019-06-18T17:52:06.230768+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
954 39815 swimming_water_cyanobacteria 2019-06-17T18:12:35.428225+0300 2019-06-18T18:12:35.428225+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
957 41907 swimming_water_cyanobacteria 2019-06-18T08:41:26.993898+0300 2019-06-19T08:41:26.993898+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
959 40798 swimming_water_cyanobacteria 2019-06-18T08:41:35.744206+0300 2019-06-19T08:41:35.744206+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
961 39910 swimming_water_cyanobacteria 2019-06-18T08:41:43.573696+0300 2019-06-19T08:41:43.573696+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
963 41031 swimming_water_cyanobacteria 2019-06-18T08:47:43.293645+0300 2019-06-19T08:47:43.293645+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
965 40098 swimming_water_cyanobacteria 2019-06-18T08:48:18.197341+0300 2019-06-19T08:48:18.197341+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
967 39815 swimming_water_cyanobacteria 2019-06-18T08:51:48.980139+0300 2019-06-19T08:51:48.980139+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
970 39815 swimming_water_cyanobacteria 2019-06-18T08:51:54.309581+0300 2019-06-19T08:51:54.309581+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
976 39568 swimming_water_cyanobacteria 2019-06-18T09:52:16.388390+0300 2019-06-19T09:52:16.388390+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
978 41791 swimming_water_cyanobacteria 2019-06-18T10:04:25.212457+0300 2019-06-19T10:04:25.212457+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
986 39815 swimming_water_cyanobacteria 2019-06-18T10:09:02.282535+0300 2019-06-19T10:09:02.282535+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
988 41601 swimming_water_cyanobacteria 2019-06-18T10:09:06.083741+0300 2019-06-19T10:09:06.083741+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
990 40150 swimming_water_cyanobacteria 2019-06-18T10:32:15.083719+0300 2019-06-19T10:32:15.083719+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
992 40142 swimming_water_cyanobacteria 2019-06-18T10:40:37.102727+0300 2019-06-19T10:40:37.102727+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
995 40802 swimming_water_cyanobacteria 2019-06-18T11:03:45.500073+0300 2019-06-19T11:03:45.500073+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
997 52959 swimming_water_cyanobacteria 2019-06-18T11:39:37.507316+0300 2019-06-19T11:39:37.507316+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
999 41960 swimming_water_cyanobacteria 2019-06-18T12:25:56.239477+0300 2019-06-19T12:25:56.239477+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
1001 40950 swimming_water_cyanobacteria 2019-06-18T13:31:07.169507+0300 2019-06-19T13:31:07.169507+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  

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