observation

526 rows where value = "plowed"

✎ View and edit SQL

This data as json, CSV (advanced)

value ✖

  • plowed · 426 ✖
id ▼ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
6831 53563 ice_skating_field_condition 2020-01-14T15:00:22.360874+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6832 42699 ice_skating_field_condition 2020-01-14T16:16:59.222264+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6859 40421 ice_skating_field_condition 2020-01-16T09:45:01.903463+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6864 40402 ice_skating_field_condition 2020-01-16T14:21:36.304981+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6866 39834 ice_skating_field_condition 2020-01-16T15:10:26.385509+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6867 53563 ice_skating_field_condition 2020-01-16T15:10:41.394712+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6868 53563 ice_skating_field_condition 2020-01-16T18:17:16.461445+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6886 42185 ice_skating_field_condition 2020-01-17T12:34:29.999132+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6887 41770 ice_skating_field_condition 2020-01-17T12:34:38.574441+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6891 39834 ice_skating_field_condition 2020-01-17T14:48:15.891076+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6912 39834 ice_skating_field_condition 2020-01-18T14:44:34.605732+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6913 53563 ice_skating_field_condition 2020-01-18T14:45:02.785453+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6919 42185 ice_skating_field_condition 2020-01-19T08:23:19.984872+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6922 53524 ice_skating_field_condition 2020-01-19T08:32:16.848348+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6924 53524 ice_skating_field_condition 2020-01-19T08:34:55.538700+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6925 47279 ice_skating_field_condition 2020-01-19T08:39:52.892792+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6926 53615 ice_skating_field_condition 2020-01-19T08:40:18.552544+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6930 41770 ice_skating_field_condition 2020-01-19T09:47:47.352804+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6956 40421 ice_skating_field_condition 2020-01-20T11:28:15.809542+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6966 40421 ice_skating_field_condition 2020-01-21T06:57:12.566365+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6976 40421 ice_skating_field_condition 2020-01-21T09:45:15.092308+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
6986 42699 ice_skating_field_condition 2020-01-21T15:54:49.664977+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7040 42699 ice_skating_field_condition 2020-01-24T10:19:38.985332+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7046 53563 ice_skating_field_condition 2020-01-24T15:20:15.302312+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7047 39834 ice_skating_field_condition 2020-01-24T15:20:29.671490+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7079 40421 ice_skating_field_condition 2020-01-26T10:01:49.316444+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7086 53563 ice_skating_field_condition 2020-01-27T07:17:57.867407+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7091 42699 ice_skating_field_condition 2020-01-27T08:05:42.604439+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7092 42185 ice_skating_field_condition 2020-01-27T08:14:02.276283+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7093 41770 ice_skating_field_condition 2020-01-27T08:14:48.474896+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7094 53523 ice_skating_field_condition 2020-01-27T08:17:50.365336+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7095 53524 ice_skating_field_condition 2020-01-27T08:18:08.731590+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7098 40402 ice_skating_field_condition 2020-01-27T08:35:08.491965+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7100 39834 ice_skating_field_condition 2020-01-27T09:01:51.922726+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7101 40421 ice_skating_field_condition 2020-01-27T09:04:09.156021+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7107 42699 ice_skating_field_condition 2020-01-27T19:11:27.496931+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7108 53523 ice_skating_field_condition 2020-01-28T07:30:39.697321+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7109 53524 ice_skating_field_condition 2020-01-28T07:30:52.438593+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7110 53615 ice_skating_field_condition 2020-01-28T07:55:56.079334+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7111 47279 ice_skating_field_condition 2020-01-28T07:56:12.610146+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7113 39834 ice_skating_field_condition 2020-01-28T08:43:57.570540+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7116 40421 ice_skating_field_condition 2020-01-28T10:19:13.343558+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7118 53563 ice_skating_field_condition 2020-01-28T11:52:21.507001+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7120 42185 ice_skating_field_condition 2020-01-28T13:56:50.876268+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7125 42699 ice_skating_field_condition 2020-01-28T17:59:57.417582+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7129 53615 ice_skating_field_condition 2020-01-29T07:51:15.654848+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7135 53523 ice_skating_field_condition 2020-01-29T08:39:39.504112+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7136 53524 ice_skating_field_condition 2020-01-29T08:39:46.141636+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7137 42699 ice_skating_field_condition 2020-01-29T09:32:20.443385+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7139 41770 ice_skating_field_condition 2020-01-29T18:59:18.454413+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7141 42185 ice_skating_field_condition 2020-01-29T19:00:09.592568+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7142 53563 ice_skating_field_condition 2020-01-30T07:24:30.199056+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7145 40402 ice_skating_field_condition 2020-01-30T07:47:06.528957+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7147 47279 ice_skating_field_condition 2020-01-30T07:49:56.837903+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7150 53615 ice_skating_field_condition 2020-01-30T08:35:26.062231+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7151 39834 ice_skating_field_condition 2020-01-30T08:44:27.590486+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7152 42699 ice_skating_field_condition 2020-01-30T08:46:08.120846+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7155 42185 ice_skating_field_condition 2020-01-30T08:57:50.495046+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7157 40421 ice_skating_field_condition 2020-01-30T09:10:52.174189+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7158 53523 ice_skating_field_condition 2020-01-30T11:51:00.512077+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7159 53524 ice_skating_field_condition 2020-01-30T11:51:08.375969+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7170 42185 ice_skating_field_condition 2020-01-31T08:28:01.138106+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7172 53524 ice_skating_field_condition 2020-01-31T08:31:31.831100+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7173 40421 ice_skating_field_condition 2020-01-31T09:05:31.734764+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7174 53523 ice_skating_field_condition 2020-01-31T09:27:12.638102+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7180 42699 ice_skating_field_condition 2020-01-31T12:28:57.132094+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7185 46144 ice_skating_field_condition 2020-02-01T09:10:54.364537+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7188 40421 ice_skating_field_condition 2020-02-01T09:44:47.686837+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7202 42185 ice_skating_field_condition 2020-02-02T08:11:05.410374+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7203 41770 ice_skating_field_condition 2020-02-02T08:11:15.416832+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7205 46144 ice_skating_field_condition 2020-02-02T08:59:10.545204+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7208 40421 ice_skating_field_condition 2020-02-02T09:28:57.091991+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7209 40402 ice_skating_field_condition 2020-02-02T12:02:42.556980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7210 46144 ice_skating_field_condition 2020-02-02T12:42:28.417402+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7213 46144 ice_skating_field_condition 2020-02-02T16:09:39.459985+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7228 40421 ice_skating_field_condition 2020-02-03T09:42:18.557760+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7240 40421 ice_skating_field_condition 2020-02-04T09:31:03.710741+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7338 40421 ice_skating_field_condition 2020-02-06T09:09:35.309980+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7428 40013 ice_skating_field_condition 2020-02-08T07:06:18.408892+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7430 40455 ice_skating_field_condition 2020-02-08T07:48:51.324598+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7431 50354 ice_skating_field_condition 2020-02-08T07:48:56.825987+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7432 40455 ice_skating_field_condition 2020-02-08T07:49:03.405727+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7433 53615 ice_skating_field_condition 2020-02-08T07:49:16.291676+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7434 42249 ice_skating_field_condition 2020-02-08T08:20:45.432821+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7439 61464 ice_skating_field_condition 2020-02-08T09:21:27.512535+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7440 42241 ice_skating_field_condition 2020-02-08T09:34:55.637011+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7441 40040 ice_skating_field_condition 2020-02-08T09:35:23.564237+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7442 42699 ice_skating_field_condition 2020-02-08T09:45:11.320090+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7445 40421 ice_skating_field_condition 2020-02-08T09:58:03.764478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7453 41096 ice_skating_field_condition 2020-02-08T12:39:09.505436+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7454 40934 ice_skating_field_condition 2020-02-08T13:12:26.224648+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7462 40934 ice_skating_field_condition 2020-02-08T17:59:49.123909+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7476 53615 ice_skating_field_condition 2020-02-09T07:18:07.597018+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7483 40421 ice_skating_field_condition 2020-02-09T09:20:19.901251+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7484 53523 ice_skating_field_condition 2020-02-09T09:38:57.442638+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7485 53524 ice_skating_field_condition 2020-02-09T09:39:03.720968+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7489 40725 ice_skating_field_condition 2020-02-09T10:54:06.398555+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7496 42699 ice_skating_field_condition 2020-02-09T12:02:03.244009+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7502 39834 ice_skating_field_condition 2020-02-09T15:16:42.742454+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
7503 53563 ice_skating_field_condition 2020-02-09T15:17:05.537614+0200     Aurattu   Plogad 1 Cleared of snow plowed 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
);