observation

51,120 rows sorted by unit

✎ View and edit SQL

This data as json, CSV (advanced)

primary ✖

  • 1 7,898
  • 0 4,916
id unit ▼ property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
1789 39267 swimming_water_temperature 2019-06-29T09:59:30.222957+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1790 39267 swimming_water_cyanobacteria 2019-06-29T09:59:32.992284+0300 2019-06-30T09:59:32.992284+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1833 39267 swimming_water_temperature 2019-06-29T13:56:02.824526+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1834 39267 swimming_water_cyanobacteria 2019-06-29T13:56:10.814640+0300 2019-06-30T13:56:10.814640+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1846 39267 swimming_water_temperature 2019-06-29T17:48:43.073234+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1847 39267 swimming_water_cyanobacteria 2019-06-29T17:48:50.016329+0300 2019-06-30T17:48:50.016329+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1876 39267 swimming_water_temperature 2019-06-30T10:12:20.686299+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1877 39267 swimming_water_cyanobacteria 2019-06-30T10:12:26.595205+0300 2019-07-01T10:12:26.595205+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1907 39267 swimming_water_temperature 2019-06-30T14:03:07.579893+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1908 39267 swimming_water_cyanobacteria 2019-06-30T14:03:13.873297+0300 2019-07-01T14:03:13.873297+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1923 39267 swimming_water_temperature 2019-06-30T17:38:52.157617+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1924 39267 swimming_water_cyanobacteria 2019-06-30T17:38:59.481516+0300 2019-07-01T17:38:59.481516+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
1953 39267 swimming_water_temperature 2019-07-01T09:59:33.828571+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
1954 39267 swimming_water_cyanobacteria 2019-07-01T09:59:39.080433+0300 2019-07-02T09:59:39.080433+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2009 39267 swimming_water_temperature 2019-07-01T13:51:44.519459+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2010 39267 swimming_water_cyanobacteria 2019-07-01T13:51:48.992729+0300 2019-07-02T13:51:48.992729+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2036 39267 swimming_water_temperature 2019-07-01T17:49:55.811806+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2037 39267 swimming_water_cyanobacteria 2019-07-01T17:49:59.217861+0300 2019-07-02T17:49:59.217861+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2110 39267 swimming_water_temperature 2019-07-03T10:13:45.186996+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2112 39267 swimming_water_temperature 2019-07-03T10:15:05.155744+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2114 39267 swimming_water_temperature 2019-07-03T10:15:47.945661+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2115 39267 swimming_water_cyanobacteria 2019-07-03T10:15:50.706358+0300 2019-07-04T10:15:50.706358+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2142 39267 swimming_water_temperature 2019-07-03T14:13:00.697612+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2143 39267 swimming_water_cyanobacteria 2019-07-03T14:13:04.257612+0300 2019-07-04T14:13:04.257612+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2189 39267 swimming_water_temperature 2019-07-04T10:10:10.186814+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2190 39267 swimming_water_cyanobacteria 2019-07-04T10:10:15.014333+0300 2019-07-05T10:10:15.014333+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2233 39267 swimming_water_temperature 2019-07-04T14:12:12.592060+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2234 39267 swimming_water_cyanobacteria 2019-07-04T14:12:16.814909+0300 2019-07-05T14:12:16.814909+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2244 39267 swimming_water_temperature 2019-07-04T17:45:26.344932+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2245 39267 swimming_water_cyanobacteria 2019-07-04T17:45:33.968651+0300 2019-07-05T17:45:33.968651+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2317 39267 swimming_water_temperature 2019-07-05T12:33:07.402395+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2318 39267 swimming_water_cyanobacteria 2019-07-05T12:33:19.308854+0300 2019-07-06T12:33:19.308854+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2326 39267 swimming_water_temperature 2019-07-05T14:05:04.871221+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2327 39267 swimming_water_cyanobacteria 2019-07-05T14:05:15.534562+0300 2019-07-06T14:05:15.534562+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2338 39267 swimming_water_temperature 2019-07-05T18:00:06.343013+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2340 39267 swimming_water_cyanobacteria 2019-07-05T18:00:10.779753+0300 2019-07-06T18:00:10.779753+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2373 39267 swimming_water_temperature 2019-07-06T10:17:47.427550+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2375 39267 swimming_water_cyanobacteria 2019-07-06T10:17:52.405252+0300 2019-07-07T10:17:52.405252+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2400 39267 swimming_water_temperature 2019-07-06T14:04:02.458633+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2401 39267 swimming_water_cyanobacteria 2019-07-06T14:04:07.409313+0300 2019-07-07T14:04:07.409313+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2411 39267 swimming_water_temperature 2019-07-06T17:48:22.255463+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2412 39267 swimming_water_cyanobacteria 2019-07-06T17:48:28.825465+0300 2019-07-07T17:48:28.825465+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2430 39267 swimming_water_cyanobacteria 2019-07-07T10:03:18.702191+0300 2019-07-08T10:03:18.702191+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2431 39267 swimming_water_temperature 2019-07-07T10:07:56.387691+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2471 39267 swimming_water_temperature 2019-07-07T13:54:25.098157+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2472 39267 swimming_water_cyanobacteria 2019-07-07T13:54:31.207894+0300 2019-07-08T13:54:31.207894+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2488 39267 swimming_water_temperature 2019-07-07T17:53:52.990159+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2489 39267 swimming_water_cyanobacteria 2019-07-07T17:53:55.571998+0300 2019-07-08T17:53:55.571998+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2507 39267 swimming_water_temperature 2019-07-08T10:01:25.838792+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2508 39267 swimming_water_cyanobacteria 2019-07-08T10:01:28.571989+0300 2019-07-09T10:01:28.571989+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2544 39267 swimming_water_temperature 2019-07-08T13:53:49.390740+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2545 39267 swimming_water_cyanobacteria 2019-07-08T13:53:53.200144+0300 2019-07-09T13:53:53.200144+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2565 39267 swimming_water_temperature 2019-07-08T17:37:10.792865+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
2566 39267 swimming_water_cyanobacteria 2019-07-08T17:37:16.075515+0300 2019-07-09T17:37:16.075515+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2603 39267 swimming_water_temperature 2019-07-09T10:50:29.075385+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2604 39267 swimming_water_cyanobacteria 2019-07-09T10:50:33.661335+0300 2019-07-10T10:50:33.661335+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2620 39267 swimming_water_temperature 2019-07-09T16:00:51.895245+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2621 39267 swimming_water_cyanobacteria 2019-07-09T16:00:54.993722+0300 2019-07-10T16:00:54.993722+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2622 39267 swimming_water_temperature 2019-07-09T17:48:13.835579+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2623 39267 swimming_water_cyanobacteria 2019-07-09T17:48:16.860886+0300 2019-07-10T17:48:16.860886+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2659 39267 swimming_water_temperature 2019-07-10T10:00:50.201105+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2660 39267 swimming_water_cyanobacteria 2019-07-10T10:00:53.096823+0300 2019-07-11T10:00:53.096823+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2716 39267 swimming_water_temperature 2019-07-10T14:49:51.523271+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2717 39267 swimming_water_cyanobacteria 2019-07-10T14:49:59.596844+0300 2019-07-11T14:49:59.596844+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2725 39267 swimming_water_temperature 2019-07-10T17:46:18.601814+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2726 39267 swimming_water_cyanobacteria 2019-07-10T17:46:26.116613+0300 2019-07-11T17:46:26.116613+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2801 39267 swimming_water_temperature 2019-07-11T15:15:35.883695+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2802 39267 swimming_water_cyanobacteria 2019-07-11T15:15:41.153681+0300 2019-07-12T15:15:41.153681+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2803 39267 swimming_water_cyanobacteria 2019-07-11T15:15:43.693659+0300 2019-07-12T15:15:43.693659+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2809 39267 swimming_water_temperature 2019-07-11T17:57:47.566309+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2810 39267 swimming_water_cyanobacteria 2019-07-11T17:57:50.323784+0300 2019-07-12T17:57:50.323784+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2827 39267 swimming_water_temperature 2019-07-12T10:04:28.034084+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2828 39267 swimming_water_cyanobacteria 2019-07-12T10:04:30.878488+0300 2019-07-13T10:04:30.878488+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2857 39267 swimming_water_temperature 2019-07-12T14:01:13.640568+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2858 39267 swimming_water_cyanobacteria 2019-07-12T14:01:16.595045+0300 2019-07-13T14:01:16.595045+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2873 39267 swimming_water_temperature 2019-07-12T17:47:57.139204+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2874 39267 swimming_water_cyanobacteria 2019-07-12T17:47:59.735519+0300 2019-07-13T17:47:59.735519+0300   Erittäin runsaasti sinilevää   Mycket rikligt med blågröna alger 1 Very high levels of cyanobacteria 3 unusable  
2888 39267 swimming_water_cyanobacteria 2019-07-13T10:03:16.125405+0300 2019-07-14T10:03:16.125405+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2889 39267 swimming_water_temperature 2019-07-13T10:03:49.496036+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2932 39267 swimming_water_temperature 2019-07-13T14:39:05.529237+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2933 39267 swimming_water_cyanobacteria 2019-07-13T14:39:08.561550+0300 2019-07-14T14:39:08.561550+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2939 39267 swimming_water_temperature 2019-07-13T17:45:21.461912+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2940 39267 swimming_water_cyanobacteria 2019-07-13T17:45:44.945271+0300 2019-07-14T17:45:44.945271+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
2975 39267 swimming_water_temperature 2019-07-14T10:14:52.184559+0300     17-19°C   17-19°C 0 17-19°C 17-19 unknown  
2976 39267 swimming_water_cyanobacteria 2019-07-14T10:15:00.625315+0300 2019-07-15T10:15:00.625315+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3004 39267 swimming_water_temperature 2019-07-14T14:53:49.894309+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3005 39267 swimming_water_cyanobacteria 2019-07-14T14:53:53.347520+0300 2019-07-15T14:53:53.347520+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3015 39267 swimming_water_temperature 2019-07-14T17:52:33.761530+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3016 39267 swimming_water_cyanobacteria 2019-07-14T17:52:36.351142+0300 2019-07-15T17:52:36.351142+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3038 39267 swimming_water_cyanobacteria 2019-07-15T10:04:23.444120+0300 2019-07-16T10:04:23.444120+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3039 39267 swimming_water_temperature 2019-07-15T10:04:27.014528+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3098 39267 swimming_water_temperature 2019-07-15T14:28:25.914776+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3099 39267 swimming_water_cyanobacteria 2019-07-15T14:28:31.862333+0300 2019-07-16T14:28:31.862333+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3105 39267 swimming_water_temperature 2019-07-15T17:44:05.128481+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3106 39267 swimming_water_cyanobacteria 2019-07-15T17:44:12.716109+0300 2019-07-16T17:44:12.716109+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3117 39267 swimming_water_temperature 2019-07-16T09:59:31.850108+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3119 39267 swimming_water_cyanobacteria 2019-07-16T09:59:50.396099+0300 2019-07-17T09:59:50.396099+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3162 39267 swimming_water_temperature 2019-07-16T15:09:56.292322+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  
3163 39267 swimming_water_cyanobacteria 2019-07-16T15:10:01.452514+0300 2019-07-17T15:10:01.452514+0300   Runsaasti sinilevää   Rikligt med blågröna alger 1 Plenty of cyanobacteria 2 unusable  
3200 39267 swimming_water_temperature 2019-07-17T10:05:54.033584+0300     19-21°C   19-21°C 0 19-21°C 19-21 unknown  

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