servicemap

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

unitidpropertytimeexpiration_timevalue_finame_fivalue_svname_svprimaryname_envaluequalityvalue_en
40950 146 swimming_water_temperature 2019-06-06T10:43:25.862374+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 149 swimming_water_temperature 2019-06-06T10:43:26.250756+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41601 150 swimming_water_temperature 2019-06-06T11:02:33.045041+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40921 310 swimming_water_temperature 2019-06-09T08:58:41.314672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41326 312 swimming_water_temperature 2019-06-09T08:59:01.215687+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40020 314 swimming_water_temperature 2019-06-09T08:59:13.060529+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40677 316 swimming_water_temperature 2019-06-09T08:59:50.077804+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39322 381 swimming_water_temperature 2019-06-09T18:44:40.198426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 397 swimming_water_temperature 2019-06-10T10:18:09.001672+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39322 410 swimming_water_temperature 2019-06-10T13:45:12.831410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39322 424 swimming_water_temperature 2019-06-10T17:50:52.926026+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41031 429 swimming_water_temperature 2019-06-11T07:35:39.937460+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41326 431 swimming_water_temperature 2019-06-11T07:35:54.816735+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41907 433 swimming_water_temperature 2019-06-11T07:36:03.716690+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40921 435 swimming_water_temperature 2019-06-11T07:36:19.863504+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 437 swimming_water_temperature 2019-06-11T07:36:30.314633+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 438 swimming_water_temperature 2019-06-11T07:36:37.529518+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40677 440 swimming_water_temperature 2019-06-11T07:36:52.756253+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40020 442 swimming_water_temperature 2019-06-11T07:36:59.454932+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39910 444 swimming_water_temperature 2019-06-11T07:37:06.926794+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40356 448 swimming_water_temperature 2019-06-11T07:38:15.879350+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40386 450 swimming_water_temperature 2019-06-11T07:38:45.000109+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40802 469 swimming_water_temperature 2019-06-11T10:05:21.394543+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40802 574 swimming_water_temperature 2019-06-12T10:06:27.423087+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 592 swimming_water_temperature 2019-06-12T10:47:52.504313+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39527 627 swimming_water_temperature 2019-06-12T19:05:49.774401+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 644 swimming_water_temperature 2019-06-13T10:01:57.197184+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41601 655 swimming_water_temperature 2019-06-13T10:09:17.217746+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 681 swimming_water_temperature 2019-06-13T14:06:17.781360+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 690 swimming_water_temperature 2019-06-13T18:02:41.375121+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40157 714 swimming_water_temperature 2019-06-14T09:54:28.256267+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 727 swimming_water_temperature 2019-06-14T10:25:23.633557+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 731 swimming_water_temperature 2019-06-14T10:29:57.547045+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 734 swimming_water_temperature 2019-06-14T10:34:07.294329+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41601 736 swimming_water_temperature 2019-06-14T10:42:16.250645+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 740 swimming_water_temperature 2019-06-14T14:07:54.019329+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39815 747 swimming_water_temperature 2019-06-14T17:58:16.937142+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 749 swimming_water_temperature 2019-06-14T18:02:13.703810+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39815 752 swimming_water_temperature 2019-06-15T10:01:39.849686+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 764 swimming_water_temperature 2019-06-15T10:16:13.454535+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39897 768 swimming_water_temperature 2019-06-15T10:30:45.688174+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 769 swimming_water_temperature 2019-06-15T10:31:01.723046+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40157 775 swimming_water_temperature 2019-06-15T10:54:59.045008+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 787 swimming_water_temperature 2019-06-15T14:04:45.743477+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 794 swimming_water_temperature 2019-06-15T17:59:24.200487+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41031 799 swimming_water_temperature 2019-06-16T08:24:08.024679+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41326 801 swimming_water_temperature 2019-06-16T08:24:17.094527+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41907 803 swimming_water_temperature 2019-06-16T08:24:22.855167+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 805 swimming_water_temperature 2019-06-16T08:24:29.349014+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39910 807 swimming_water_temperature 2019-06-16T08:24:50.037289+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 813 swimming_water_temperature 2019-06-16T08:25:44.831783+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40020 815 swimming_water_temperature 2019-06-16T08:26:08.636211+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40993 817 swimming_water_temperature 2019-06-16T08:26:23.930829+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40677 819 swimming_water_temperature 2019-06-16T08:26:33.976465+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 836 swimming_water_temperature 2019-06-16T10:12:17.550830+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 841 swimming_water_temperature 2019-06-16T10:14:01.953509+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41791 843 swimming_water_temperature 2019-06-16T10:20:02.401592+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39693 847 swimming_water_temperature 2019-06-16T10:24:25.497786+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 850 swimming_water_temperature 2019-06-16T10:32:32.979167+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40258 856 swimming_water_temperature 2019-06-16T12:13:03.661920+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 859 swimming_water_temperature 2019-06-16T12:38:41.204100+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 860 swimming_water_temperature 2019-06-16T13:38:14.864282+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39568 894 swimming_water_temperature 2019-06-17T08:51:03.097139+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40802 909 swimming_water_temperature 2019-06-17T10:16:50.605572+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 915 swimming_water_temperature 2019-06-17T10:52:17.310522+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39527 920 swimming_water_temperature 2019-06-17T11:16:55.579731+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 923 swimming_water_temperature 2019-06-17T13:05:30.983059+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40142 924 swimming_water_temperature 2019-06-17T13:05:41.252238+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 940 swimming_water_temperature 2019-06-17T15:02:36.006791+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
41907 956 swimming_water_temperature 2019-06-18T08:41:25.194106+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40798 958 swimming_water_temperature 2019-06-18T08:41:33.977426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39910 960 swimming_water_temperature 2019-06-18T08:41:41.889759+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40098 964 swimming_water_temperature 2019-06-18T08:48:16.650619+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40802 994 swimming_water_temperature 2019-06-18T11:03:43.722426+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
52959 996 swimming_water_temperature 2019-06-18T11:39:35.170786+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 1000 swimming_water_temperature 2019-06-18T13:31:03.564720+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39568 1009 swimming_water_temperature 2019-06-18T14:07:06.253777+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
52959 1015 swimming_water_temperature 2019-06-18T15:39:09.272717+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
52959 1018 swimming_water_temperature 2019-06-18T17:43:59.085560+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39568 1023 swimming_water_temperature 2019-06-18T18:05:17.763908+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39568 1032 swimming_water_temperature 2019-06-19T09:49:50.906020+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39527 1046 swimming_water_temperature 2019-06-19T10:24:54.041705+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40802 1048 swimming_water_temperature 2019-06-19T10:43:49.796571+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
52959 1050 swimming_water_temperature 2019-06-19T10:52:59.683937+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39902 1054 swimming_water_temperature 2019-06-19T10:58:55.489579+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39875 1056 swimming_water_temperature 2019-06-19T10:59:21.634110+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 1060 swimming_water_temperature 2019-06-19T11:22:33.245881+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40559 1064 swimming_water_temperature 2019-06-19T12:15:44.263082+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39823 1067 swimming_water_temperature 2019-06-19T12:41:47.568465+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
53461 1070 swimming_water_temperature 2019-06-19T13:09:50.536410+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39606 1073 swimming_water_temperature 2019-06-19T13:48:50.963802+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39412 1075 swimming_water_temperature 2019-06-19T13:51:02.392224+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 1151 swimming_water_temperature 2019-06-20T10:46:41.164819+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40258 1153 swimming_water_temperature 2019-06-20T10:58:31.386420+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
39527 1157 swimming_water_temperature 2019-06-20T11:13:39.685236+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40258 1242 swimming_water_temperature 2019-06-21T12:10:42.990869+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 1263 swimming_water_temperature 2019-06-21T12:54:55.978481+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 1292 swimming_water_temperature 2019-06-22T12:17:17.840012+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40258 1294 swimming_water_temperature 2019-06-22T12:27:00.776515+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40950 1317 swimming_water_temperature 2019-06-23T10:55:25.298137+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown  
40150 1380 swimming_water_temperature 2019-06-24T10:20:55.726738+0300     15-17°C   15-17°C 0 15-17°C 15-17 unknown