observation

497 rows where value = "0-15" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • 0-15 · 397 ✖

primary ✖

  • 0 397
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
8843 39527 swimming_water_temperature 2020-06-08T08:43:51.423919+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8833 40098 swimming_water_temperature 2020-06-07T17:53:48.035442+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8819 39527 swimming_water_temperature 2020-06-07T14:16:27.736246+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8811 40142 swimming_water_temperature 2020-06-07T11:20:39.076680+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8809 39527 swimming_water_temperature 2020-06-07T10:58:53.139152+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8795 40993 swimming_water_temperature 2020-06-07T10:28:03.100008+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8793 40950 swimming_water_temperature 2020-06-07T10:11:15.318366+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8790 40258 swimming_water_temperature 2020-06-07T10:08:49.068254+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8783 41791 swimming_water_temperature 2020-06-07T10:04:18.107546+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8779 40559 swimming_water_temperature 2020-06-07T09:57:43.062624+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8774 39693 swimming_water_temperature 2020-06-07T09:44:08.744730+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8761 58015 swimming_water_temperature 2020-06-06T13:43:29.021115+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8758 40677 swimming_water_temperature 2020-06-06T13:43:19.222413+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8756 39910 swimming_water_temperature 2020-06-06T13:43:12.599708+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8754 41907 swimming_water_temperature 2020-06-06T13:43:06.924231+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8753 40798 swimming_water_temperature 2020-06-06T13:43:03.008210+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8751 40356 swimming_water_temperature 2020-06-06T13:42:43.863657+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8748 40020 swimming_water_temperature 2020-06-06T13:41:58.578383+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8746 41326 swimming_water_temperature 2020-06-06T13:41:40.223590+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8745 40921 swimming_water_temperature 2020-06-06T13:41:32.919203+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8742 41031 swimming_water_temperature 2020-06-06T13:41:07.752334+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8727 40150 swimming_water_temperature 2020-06-06T10:41:37.383207+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8726 40150 swimming_water_temperature 2020-06-06T10:41:37.148481+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8725 40258 swimming_water_temperature 2020-06-06T10:23:49.955035+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8723 40142 swimming_water_temperature 2020-06-06T10:15:24.720346+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8720 41791 swimming_water_temperature 2020-06-06T10:09:26.816916+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8717 40559 swimming_water_temperature 2020-06-06T09:59:49.776718+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8715 40950 swimming_water_temperature 2020-06-06T09:56:32.517869+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8711 40993 swimming_water_temperature 2020-06-06T09:30:35.901131+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8709 39693 swimming_water_temperature 2020-06-06T09:29:04.143822+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8697 39568 swimming_water_temperature 2020-06-05T14:20:04.905257+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8692 39693 swimming_water_temperature 2020-06-05T13:59:06.348321+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8688 40098 swimming_water_temperature 2020-06-05T13:35:30.422787+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8680 40258 swimming_water_temperature 2020-06-05T10:56:50.910102+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8676 40993 swimming_water_temperature 2020-06-05T10:43:45.567770+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8669 40559 swimming_water_temperature 2020-06-05T10:18:00.996127+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8661 41791 swimming_water_temperature 2020-06-05T09:59:50.937864+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8660 41791 swimming_water_temperature 2020-06-05T09:59:45.098075+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8659 41791 swimming_water_temperature 2020-06-05T09:59:41.347194+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8655 40950 swimming_water_temperature 2020-06-05T09:58:21.526316+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8654 40150 swimming_water_temperature 2020-06-05T09:58:20.175668+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8653 39693 swimming_water_temperature 2020-06-05T09:55:21.464997+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8650 39568 swimming_water_temperature 2020-06-05T09:52:58.076787+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8649 39568 swimming_water_temperature 2020-06-05T09:52:53.521156+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8648 39568 swimming_water_temperature 2020-06-05T09:52:48.469011+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8647 40142 swimming_water_temperature 2020-06-05T09:47:29.910847+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8646 40142 swimming_water_temperature 2020-06-05T09:46:00.238737+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8630 52959 swimming_water_temperature 2020-06-04T16:53:35.561262+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8618 40950 swimming_water_temperature 2020-06-04T12:08:41.991243+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8614 40258 swimming_water_temperature 2020-06-04T10:43:42.086087+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8612 40993 swimming_water_temperature 2020-06-04T10:40:12.555602+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8610 39568 swimming_water_temperature 2020-06-04T10:30:50.607339+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8609 39693 swimming_water_temperature 2020-06-04T10:28:07.990941+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8595 39815 swimming_water_temperature 2020-06-04T10:02:32.927331+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8592 40559 swimming_water_temperature 2020-06-04T09:57:55.620951+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8587 40142 swimming_water_temperature 2020-06-04T09:54:30.594054+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8585 41791 swimming_water_temperature 2020-06-04T09:46:29.659259+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8555 40993 swimming_water_temperature 2020-06-03T12:33:56.287695+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8542 39527 swimming_water_temperature 2020-06-03T10:13:44.753310+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8532 52959 swimming_water_temperature 2020-06-03T10:03:51.315121+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8529 40559 swimming_water_temperature 2020-06-03T10:01:17.142176+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8527 40258 swimming_water_temperature 2020-06-03T10:01:03.655191+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8525 41791 swimming_water_temperature 2020-06-03T10:00:27.686988+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8524 40950 swimming_water_temperature 2020-06-03T09:57:21.841538+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8520 40142 swimming_water_temperature 2020-06-03T09:50:32.224919+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8519 40142 swimming_water_temperature 2020-06-03T09:50:19.060138+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8511 39693 swimming_water_temperature 2020-06-03T09:20:48.500114+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8508 39527 swimming_water_temperature 2020-06-02T18:01:14.285686+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8499 39568 swimming_water_temperature 2020-06-02T15:30:38.994620+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8497 52959 swimming_water_temperature 2020-06-02T14:35:40.040080+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8485 40150 swimming_water_temperature 2020-06-02T14:03:49.633771+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8483 58015 swimming_water_temperature 2020-06-02T14:01:17.721756+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8481 40356 swimming_water_temperature 2020-06-02T14:01:11.911858+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8479 40921 swimming_water_temperature 2020-06-02T14:01:05.299602+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8477 41326 swimming_water_temperature 2020-06-02T14:00:59.214385+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8475 40798 swimming_water_temperature 2020-06-02T14:00:52.720230+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8473 40020 swimming_water_temperature 2020-06-02T14:00:39.943729+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8471 41907 swimming_water_temperature 2020-06-02T14:00:33.359936+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8469 39910 swimming_water_temperature 2020-06-02T14:00:24.928367+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8467 40677 swimming_water_temperature 2020-06-02T14:00:18.172194+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8465 41031 swimming_water_temperature 2020-06-02T14:00:08.015626+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8455 40258 swimming_water_temperature 2020-06-02T11:01:52.556303+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8451 39583 swimming_water_temperature 2020-06-02T10:26:55.404461+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8448 40150 swimming_water_temperature 2020-06-02T10:23:50.490039+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8447 40950 swimming_water_temperature 2020-06-02T10:23:47.904991+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8444 52959 swimming_water_temperature 2020-06-02T10:19:39.723516+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8442 39527 swimming_water_temperature 2020-06-02T10:04:25.196825+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8440 41791 swimming_water_temperature 2020-06-02T10:04:08.856526+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8435 40142 swimming_water_temperature 2020-06-02T09:57:03.327252+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8431 40098 swimming_water_temperature 2020-06-02T09:56:42.584261+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8428 39693 swimming_water_temperature 2020-06-02T09:48:42.296314+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8424 40993 swimming_water_temperature 2020-06-02T09:42:47.645679+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8423 40559 swimming_water_temperature 2020-06-02T09:42:44.927413+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8421 39815 swimming_water_temperature 2020-06-02T08:18:11.802238+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8417 39815 swimming_water_temperature 2020-06-01T15:26:53.680375+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8408 39568 swimming_water_temperature 2020-06-01T13:33:35.638740+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8405 39815 swimming_water_temperature 2020-06-01T12:47:15.173935+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8403 40802 swimming_water_temperature 2020-06-01T12:13:10.064930+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8400 40157 swimming_water_temperature 2020-06-01T11:39:29.957404+0300     alle 15°C   under 15°C 0 below 15°C 0-15 unknown  
8398 40386 swimming_water_temperature 2020-06-01T11:32:06.030926+0300     alle 15°C   under 15°C 0 below 15°C 0-15 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
);