51,120 rows sorted by unit

View and edit SQL

id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
166 39267 swimming_water_cyanobacteria 2019-06-06T11:41:52.590712+0300 2019-06-07T11:41:52.590712+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
167 39267 notice 2019-06-06T11:41:52.730227+0300                    
173 39267 swimming_water_temperature 2019-06-06T12:51:32.063938+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
180 39267 swimming_water_temperature 2019-06-06T14:10:39.608279+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
181 39267 swimming_water_cyanobacteria 2019-06-06T14:10:39.762394+0300 2019-06-07T14:10:39.762394+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
296 39267 swimming_water_temperature 2019-06-08T17:01:07.633245+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
297 39267 swimming_water_cyanobacteria 2019-06-08T17:01:12.529283+0300 2019-06-09T17:01:12.529283+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
301 39267 swimming_water_temperature 2019-06-08T17:58:54.777603+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
302 39267 swimming_water_cyanobacteria 2019-06-08T17:58:58.552883+0300 2019-06-09T17:58:58.552883+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
339 39267 swimming_water_temperature 2019-06-09T10:21:42.793020+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
340 39267 swimming_water_cyanobacteria 2019-06-09T10:21:47.250145+0300 2019-06-10T10:21:47.250145+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
374 39267 swimming_water_temperature 2019-06-09T17:54:11.286114+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
375 39267 swimming_water_cyanobacteria 2019-06-09T17:54:15.065650+0300 2019-06-10T17:54:15.065650+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
402 39267 swimming_water_temperature 2019-06-10T10:34:16.433547+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
414 39267 swimming_water_temperature 2019-06-10T13:56:59.031717+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
476 39267 swimming_water_cyanobacteria 2019-06-11T10:10:11.349976+0300 2019-06-12T10:10:11.349976+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
477 39267 swimming_water_temperature 2019-06-11T10:10:30.491830+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
559 39267 swimming_water_cyanobacteria 2019-06-11T14:00:01.071450+0300 2019-06-12T14:00:01.071450+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
560 39267 swimming_water_temperature 2019-06-11T14:00:08.545368+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
567 39267 swimming_water_temperature 2019-06-11T17:56:58.976591+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
568 39267 swimming_water_cyanobacteria 2019-06-11T17:57:02.168113+0300 2019-06-12T17:57:02.168113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
586 39267 swimming_water_temperature 2019-06-12T10:22:49.596387+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
590 39267 swimming_water_temperature 2019-06-12T10:45:40.373126+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
591 39267 swimming_water_cyanobacteria 2019-06-12T10:45:42.523400+0300 2019-06-13T10:45:42.523400+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
607 39267 swimming_water_temperature 2019-06-12T14:02:38.897497+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
608 39267 swimming_water_cyanobacteria 2019-06-12T14:02:40.781786+0300 2019-06-13T14:02:40.781786+0300   Ei sinilevää   Inga blågröna alger 1 No cyanobacteria 0 good  
654 39267 swimming_water_temperature 2019-06-13T10:08:49.115932+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
685 39267 swimming_water_temperature 2019-06-13T15:03:53.067568+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
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  
720 39267 swimming_water_temperature 2019-06-14T10:04:47.457711+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
721 39267 swimming_water_cyanobacteria 2019-06-14T10:05:35.446913+0300 2019-06-15T10:05:35.446913+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
745 39267 swimming_water_temperature 2019-06-14T17:56:22.115728+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
746 39267 swimming_water_cyanobacteria 2019-06-14T17:56:44.684015+0300 2019-06-15T17:56:44.684015+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
766 39267 swimming_water_temperature 2019-06-15T10:23:55.291543+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
767 39267 swimming_water_cyanobacteria 2019-06-15T10:24:01.520366+0300 2019-06-16T10:24:01.520366+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
789 39267 swimming_water_temperature 2019-06-15T15:47:49.654002+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
790 39267 swimming_water_cyanobacteria 2019-06-15T15:47:53.775392+0300 2019-06-16T15:47:53.775392+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
839 39267 swimming_water_temperature 2019-06-16T10:13:35.683029+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
840 39267 swimming_water_cyanobacteria 2019-06-16T10:13:39.756849+0300 2019-06-17T10:13:39.756849+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
866 39267 swimming_water_temperature 2019-06-16T13:57:23.060048+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
867 39267 swimming_water_cyanobacteria 2019-06-16T13:57:29.422195+0300 2019-06-17T13:57:29.422195+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
876 39267 swimming_water_temperature 2019-06-16T17:52:59.322927+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
877 39267 swimming_water_cyanobacteria 2019-06-16T17:53:02.260278+0300 2019-06-17T17:53:02.260278+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
902 39267 swimming_water_cyanobacteria 2019-06-17T10:04:00.803311+0300 2019-06-18T10:04:00.803311+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
903 39267 swimming_water_temperature 2019-06-17T10:04:13.439995+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
933 39267 swimming_water_temperature 2019-06-17T13:59:33.608988+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
934 39267 swimming_water_cyanobacteria 2019-06-17T13:59:41.167721+0300 2019-06-18T13:59:41.167721+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
951 39267 swimming_water_temperature 2019-06-17T17:52:53.460520+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
952 39267 swimming_water_cyanobacteria 2019-06-17T17:52:56.665844+0300 2019-06-18T17:52:56.665844+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
979 39267 swimming_water_temperature 2019-06-18T10:04:57.735750+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
980 39267 swimming_water_temperature 2019-06-18T10:05:00.762138+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
981 39267 swimming_water_cyanobacteria 2019-06-18T10:05:04.684092+0300 2019-06-19T10:05:04.684092+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1002 39267 swimming_water_temperature 2019-06-18T13:57:25.844224+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1003 39267 swimming_water_cyanobacteria 2019-06-18T13:57:29.809081+0300 2019-06-19T13:57:29.809081+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1016 39267 swimming_water_cyanobacteria 2019-06-18T17:41:54.059959+0300 2019-06-19T17:41:54.059959+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1017 39267 swimming_water_temperature 2019-06-18T17:41:59.020786+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1040 39267 swimming_water_temperature 2019-06-19T10:10:03.476058+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1041 39267 swimming_water_cyanobacteria 2019-06-19T10:10:09.189838+0300 2019-06-20T10:10:09.189838+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1089 39267 swimming_water_temperature 2019-06-19T14:03:19.520056+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1090 39267 swimming_water_cyanobacteria 2019-06-19T14:03:23.722331+0300 2019-06-20T14:03:23.722331+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1095 39267 swimming_water_temperature 2019-06-19T17:34:57.302155+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1096 39267 swimming_water_cyanobacteria 2019-06-19T17:35:00.848562+0300 2019-06-20T17:35:00.848562+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1155 39267 swimming_water_temperature 2019-06-20T11:10:35.672801+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1156 39267 swimming_water_cyanobacteria 2019-06-20T11:10:42.343577+0300 2019-06-21T11:10:42.343577+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1185 39267 swimming_water_temperature 2019-06-20T14:07:46.017198+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1186 39267 swimming_water_cyanobacteria 2019-06-20T14:07:52.466674+0300 2019-06-21T14:07:52.466674+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1194 39267 swimming_water_temperature 2019-06-20T17:48:34.570676+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1195 39267 swimming_water_cyanobacteria 2019-06-20T17:48:38.752324+0300 2019-06-21T17:48:38.752324+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1359 39267 swimming_water_temperature 2019-06-24T10:07:46.646036+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1360 39267 swimming_water_cyanobacteria 2019-06-24T10:07:58.914113+0300 2019-06-25T10:07:58.914113+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1426 39267 swimming_water_temperature 2019-06-24T14:13:53.042983+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1427 39267 swimming_water_cyanobacteria 2019-06-24T14:13:55.769110+0300 2019-06-25T14:13:55.769110+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1443 39267 swimming_water_temperature 2019-06-24T17:46:11.049406+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1444 39267 swimming_water_cyanobacteria 2019-06-24T17:46:14.434426+0300 2019-06-25T17:46:14.434426+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1470 39267 swimming_water_temperature 2019-06-25T10:16:26.334389+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1474 39267 swimming_water_cyanobacteria 2019-06-25T10:16:50.559655+0300 2019-06-26T10:16:50.559655+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1499 39267 swimming_water_temperature 2019-06-25T13:56:36.662049+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1500 39267 swimming_water_cyanobacteria 2019-06-25T13:56:40.296869+0300 2019-06-26T13:56:40.296869+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1537 39267 swimming_water_temperature 2019-06-25T17:45:23.883233+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1538 39267 swimming_water_cyanobacteria 2019-06-25T17:45:28.044838+0300 2019-06-26T17:45:28.044838+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1556 39267 swimming_water_temperature 2019-06-26T10:21:48.404757+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1557 39267 swimming_water_cyanobacteria 2019-06-26T10:21:56.337607+0300 2019-06-27T10:21:56.337607+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
1578 39267 swimming_water_temperature 2019-06-26T14:04:59.960700+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1579 39267 swimming_water_cyanobacteria 2019-06-26T14:05:07.395076+0300 2019-06-27T14:05:07.395076+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1589 39267 swimming_water_temperature 2019-06-26T18:01:29.156373+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1590 39267 swimming_water_cyanobacteria 2019-06-26T18:01:32.930330+0300 2019-06-27T18:01:32.930330+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1614 39267 swimming_water_temperature 2019-06-27T10:12:18.028207+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1615 39267 swimming_water_cyanobacteria 2019-06-27T10:12:28.446126+0300 2019-06-28T10:12:28.446126+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1629 39267 swimming_water_cyanobacteria 2019-06-27T10:37:00.225862+0300 2019-06-28T10:37:00.225862+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1700 39267 swimming_water_temperature 2019-06-27T14:45:09.722913+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1701 39267 swimming_water_cyanobacteria 2019-06-27T14:45:15.617184+0300 2019-06-28T14:45:15.617184+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1706 39267 swimming_water_temperature 2019-06-27T17:48:29.213219+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1707 39267 swimming_water_cyanobacteria 2019-06-27T17:48:31.873013+0300 2019-06-28T17:48:31.873013+0300   Vähän sinilevää   Lite blågröna alger 1 Some cyanobacteria 1 satisfactory  
1722 39267 swimming_water_temperature 2019-06-28T10:03:09.841126+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1723 39267 swimming_water_cyanobacteria 2019-06-28T10:03:13.874257+0300 2019-06-29T10:03:13.874257+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1755 39267 swimming_water_temperature 2019-06-28T12:30:03.099858+0300     21-23°C   21-23°C 0 21-23°C 21-23 unknown  
1756 39267 swimming_water_temperature 2019-06-28T14:01:28.720519+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1757 39267 swimming_water_cyanobacteria 2019-06-28T14:01:32.873491+0300 2019-06-29T14:01:32.873491+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1775 39267 swimming_water_temperature 2019-06-28T17:42:46.574985+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1776 39267 swimming_water_cyanobacteria 2019-06-28T17:42:49.663827+0300 2019-06-29T17:42:49.663827+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
);