observation
1,452 rows where name_sv = "Isad"
This data as json, CSV (advanced)
| id ▼ | unit | property | time | expiration_time | value_fi | name_fi | value_sv | name_sv | primary | name_en | value | quality | value_en |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5988 | 41976 | ice_skating_field_condition | 2019-09-10T08:18:25.228210+0300 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6007 | 40201 | ice_skating_field_condition | 2019-10-10T14:35:54.667908+0300 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6020 | 39370 | ice_skating_field_condition | 2019-11-11T12:38:51.856733+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6023 | 53615 | ice_skating_field_condition | 2019-11-11T13:39:10.373117+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6028 | 53615 | ice_skating_field_condition | 2019-11-12T08:49:09.303828+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6031 | 39370 | ice_skating_field_condition | 2019-11-12T09:38:30.127423+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6033 | 39370 | ice_skating_field_condition | 2019-11-12T11:48:27.342025+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6035 | 40550 | ice_skating_field_condition | 2019-11-12T12:50:31.638369+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6038 | 43205 | ice_skating_field_condition | 2019-11-12T12:51:28.037292+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6041 | 39370 | ice_skating_field_condition | 2019-11-14T11:00:02.037902+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6045 | 39370 | ice_skating_field_condition | 2019-11-15T12:41:12.060308+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6046 | 53615 | ice_skating_field_condition | 2019-11-15T12:54:16.670431+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6049 | 53615 | ice_skating_field_condition | 2019-11-16T08:28:44.086080+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6050 | 53615 | ice_skating_field_condition | 2019-11-16T08:28:52.938038+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6051 | 39834 | ice_skating_field_condition | 2019-11-16T18:17:06.273807+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6053 | 39834 | ice_skating_field_condition | 2019-11-17T09:57:49.502114+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6054 | 39834 | ice_skating_field_condition | 2019-11-17T09:57:57.917092+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6055 | 39834 | ice_skating_field_condition | 2019-11-17T09:58:02.152657+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6056 | 39834 | ice_skating_field_condition | 2019-11-17T15:22:29.773006+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6057 | 42185 | ice_skating_field_condition | 2019-11-18T07:28:12.175017+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6060 | 39370 | ice_skating_field_condition | 2019-11-18T10:20:37.379298+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6061 | 39834 | ice_skating_field_condition | 2019-11-18T11:53:23.349645+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6066 | 39834 | ice_skating_field_condition | 2019-11-18T16:08:20.353856+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6070 | 39834 | ice_skating_field_condition | 2019-11-20T11:23:04.032825+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6071 | 53615 | ice_skating_field_condition | 2019-11-21T19:18:45.657208+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6072 | 53615 | ice_skating_field_condition | 2019-11-22T08:20:16.830362+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6073 | 39834 | ice_skating_field_condition | 2019-11-22T08:40:47.737391+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6076 | 53615 | ice_skating_field_condition | 2019-11-22T17:41:09.041273+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6077 | 53615 | ice_skating_field_condition | 2019-11-23T07:45:38.397211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6078 | 39834 | ice_skating_field_condition | 2019-11-23T08:55:38.247230+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6085 | 53615 | ice_skating_field_condition | 2019-11-24T08:12:59.550914+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6086 | 39834 | ice_skating_field_condition | 2019-11-24T08:54:04.462734+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6098 | 53615 | ice_skating_field_condition | 2019-11-25T08:32:40.460336+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6101 | 41770 | ice_skating_field_condition | 2019-11-25T09:14:44.118270+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6103 | 42185 | ice_skating_field_condition | 2019-11-25T09:17:31.674678+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6105 | 42852 | ice_skating_field_condition | 2019-11-25T09:41:04.381497+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6106 | 42526 | ice_skating_field_condition | 2019-11-25T09:41:27.657675+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6109 | 39370 | ice_skating_field_condition | 2019-11-25T10:51:26.977518+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6110 | 39834 | ice_skating_field_condition | 2019-11-25T11:05:20.242286+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6112 | 46144 | ice_skating_field_condition | 2019-11-25T11:11:37.430631+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6115 | 46144 | ice_skating_field_condition | 2019-11-25T11:11:58.166068+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6116 | 42699 | ice_skating_field_condition | 2019-11-25T11:12:48.089288+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6117 | 41549 | ice_skating_field_condition | 2019-11-25T11:18:14.826235+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6118 | 41549 | ice_skating_field_condition | 2019-11-25T11:37:37.566506+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6123 | 53615 | ice_skating_field_condition | 2019-11-25T15:42:25.590641+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6124 | 53615 | ice_skating_field_condition | 2019-11-26T07:58:51.213053+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6129 | 46144 | ice_skating_field_condition | 2019-11-26T08:55:41.408252+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6130 | 42699 | ice_skating_field_condition | 2019-11-26T08:55:56.260054+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6131 | 47279 | ice_skating_field_condition | 2019-11-26T09:14:49.768523+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6132 | 41549 | ice_skating_field_condition | 2019-11-26T09:31:56.863994+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6133 | 41549 | ice_skating_field_condition | 2019-11-26T09:41:15.637472+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6134 | 42185 | ice_skating_field_condition | 2019-11-26T09:56:17.218914+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6135 | 41770 | ice_skating_field_condition | 2019-11-26T09:56:22.650732+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6139 | 53563 | ice_skating_field_condition | 2019-11-26T10:25:55.899082+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6141 | 42852 | ice_skating_field_condition | 2019-11-26T10:32:34.491592+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6142 | 42526 | ice_skating_field_condition | 2019-11-26T10:32:46.033216+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6149 | 39370 | ice_skating_field_condition | 2019-11-26T11:34:35.053176+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6150 | 46144 | ice_skating_field_condition | 2019-11-26T13:58:47.902817+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6151 | 53615 | ice_skating_field_condition | 2019-11-26T15:42:10.754903+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6152 | 47279 | ice_skating_field_condition | 2019-11-26T16:33:25.561030+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6154 | 47279 | ice_skating_field_condition | 2019-11-27T07:16:49.520197+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6155 | 53615 | ice_skating_field_condition | 2019-11-27T08:19:13.418414+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6156 | 53563 | ice_skating_field_condition | 2019-11-27T08:28:38.201739+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6158 | 41549 | ice_skating_field_condition | 2019-11-27T09:03:08.881066+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6159 | 39834 | ice_skating_field_condition | 2019-11-27T09:07:01.645931+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6165 | 47279 | ice_skating_field_condition | 2019-11-28T07:06:02.774139+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6167 | 53563 | ice_skating_field_condition | 2019-11-28T07:47:06.018019+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6169 | 41770 | ice_skating_field_condition | 2019-11-28T08:42:44.530149+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6170 | 39834 | ice_skating_field_condition | 2019-11-28T08:44:58.143862+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6177 | 47279 | ice_skating_field_condition | 2019-11-30T08:36:51.686804+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6178 | 53615 | ice_skating_field_condition | 2019-11-30T08:37:04.260422+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6182 | 40725 | ice_skating_field_condition | 2019-11-30T14:16:26.680528+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6188 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:38.046092+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6189 | 39834 | ice_skating_field_condition | 2019-11-30T15:28:40.421511+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6190 | 53563 | ice_skating_field_condition | 2019-11-30T15:28:50.673211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6193 | 42526 | ice_skating_field_condition | 2019-11-30T16:09:03.260912+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6195 | 47279 | ice_skating_field_condition | 2019-12-01T09:29:22.068204+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6196 | 53615 | ice_skating_field_condition | 2019-12-01T09:29:44.832465+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6197 | 42185 | ice_skating_field_condition | 2019-12-01T09:38:49.859244+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6198 | 41770 | ice_skating_field_condition | 2019-12-01T09:39:08.231451+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6202 | 53563 | ice_skating_field_condition | 2019-12-01T18:49:03.388511+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6204 | 40493 | ice_skating_field_condition | 2019-12-02T06:36:24.249080+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6209 | 53615 | ice_skating_field_condition | 2019-12-02T08:37:06.492448+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6210 | 47279 | ice_skating_field_condition | 2019-12-02T08:38:58.204779+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6211 | 39370 | ice_skating_field_condition | 2019-12-02T10:20:56.683189+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6213 | 42185 | ice_skating_field_condition | 2019-12-02T12:47:54.665036+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6214 | 41770 | ice_skating_field_condition | 2019-12-02T12:48:12.538048+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6216 | 47279 | ice_skating_field_condition | 2019-12-03T07:07:11.332542+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6217 | 42185 | ice_skating_field_condition | 2019-12-03T08:35:18.715948+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6218 | 41770 | ice_skating_field_condition | 2019-12-03T08:35:19.909809+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6219 | 42185 | ice_skating_field_condition | 2019-12-03T08:35:36.289105+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6220 | 51402 | ice_skating_field_condition | 2019-12-03T08:51:31.988258+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6221 | 53615 | ice_skating_field_condition | 2019-12-03T08:57:36.672279+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6223 | 40402 | ice_skating_field_condition | 2019-12-03T09:06:01.593874+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6224 | 50354 | ice_skating_field_condition | 2019-12-03T11:31:34.403950+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6227 | 39834 | ice_skating_field_condition | 2019-12-03T14:37:30.361057+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6228 | 53563 | ice_skating_field_condition | 2019-12-03T16:03:48.863301+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6229 | 47279 | ice_skating_field_condition | 2019-12-04T07:08:08.678077+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6230 | 53615 | ice_skating_field_condition | 2019-12-04T07:32:47.615172+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 6231 | 40402 | ice_skating_field_condition | 2019-12-04T07:34:55.655757+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );