observation
1,452 rows where name_fi = "Jäädytetty" sorted by id descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46831 | 47279 | ice_skating_field_condition | 2020-12-25T12:30:08.238270+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46828 | 53615 | ice_skating_field_condition | 2020-12-25T12:29:56.958287+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46813 | 41770 | ice_skating_field_condition | 2020-12-25T11:48:58.511794+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46812 | 42185 | ice_skating_field_condition | 2020-12-25T11:48:47.241208+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46784 | 39663 | ice_skating_field_condition | 2020-12-25T10:11:39.089664+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46779 | 39834 | ice_skating_field_condition | 2020-12-25T10:09:26.098033+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46777 | 53563 | ice_skating_field_condition | 2020-12-25T10:09:08.343717+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46773 | 42249 | ice_skating_field_condition | 2020-12-25T10:00:34.642735+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46763 | 42699 | ice_skating_field_condition | 2020-12-25T09:24:55.396666+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46762 | 42699 | ice_skating_field_condition | 2020-12-25T09:24:46.917604+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46731 | 63148 | ice_skating_field_condition | 2020-12-25T07:22:32.386777+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46541 | 46144 | ice_skating_field_condition | 2020-12-24T15:34:55.436486+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46466 | 42699 | ice_skating_field_condition | 2020-12-24T09:36:09.770802+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46337 | 53563 | ice_skating_field_condition | 2020-12-23T23:06:31.083399+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46327 | 39834 | ice_skating_field_condition | 2020-12-23T22:13:38.223482+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46312 | 63148 | ice_skating_field_condition | 2020-12-23T21:10:04.738220+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46286 | 50568 | ice_skating_field_condition | 2020-12-23T19:21:31.952593+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46214 | 39370 | ice_skating_field_condition | 2020-12-23T14:09:34.712720+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46208 | 39370 | ice_skating_field_condition | 2020-12-23T14:07:44.142464+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46128 | 41770 | ice_skating_field_condition | 2020-12-23T10:09:44.017518+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46126 | 42249 | ice_skating_field_condition | 2020-12-23T10:05:19.847654+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45917 | 40493 | ice_skating_field_condition | 2020-12-22T19:30:57.487367+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45913 | 41549 | ice_skating_field_condition | 2020-12-22T19:28:42.927025+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45850 | 40493 | ice_skating_field_condition | 2020-12-22T16:05:18.913749+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45847 | 40421 | ice_skating_field_condition | 2020-12-22T15:57:57.465971+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45844 | 63148 | ice_skating_field_condition | 2020-12-22T15:51:09.767285+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45817 | 42185 | ice_skating_field_condition | 2020-12-22T14:14:24.736586+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45816 | 41770 | ice_skating_field_condition | 2020-12-22T14:14:10.918421+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45789 | 46144 | ice_skating_field_condition | 2020-12-22T12:57:13.990399+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45713 | 41549 | ice_skating_field_condition | 2020-12-22T09:29:41.674559+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45708 | 47279 | ice_skating_field_condition | 2020-12-22T09:08:45.986148+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45689 | 42249 | ice_skating_field_condition | 2020-12-22T08:14:47.245283+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45445 | 40493 | ice_skating_field_condition | 2020-12-21T16:09:26.471015+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45399 | 53524 | ice_skating_field_condition | 2020-12-21T13:32:43.955970+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45398 | 53523 | ice_skating_field_condition | 2020-12-21T13:32:35.271163+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45350 | 40493 | ice_skating_field_condition | 2020-12-21T11:05:43.153899+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45322 | 53615 | ice_skating_field_condition | 2020-12-21T09:41:29.868361+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45321 | 53615 | ice_skating_field_condition | 2020-12-21T09:41:22.791307+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45318 | 42249 | ice_skating_field_condition | 2020-12-21T09:31:18.889827+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45305 | 39834 | ice_skating_field_condition | 2020-12-21T08:57:12.636368+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45301 | 41770 | ice_skating_field_condition | 2020-12-21T08:51:03.852728+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45300 | 42185 | ice_skating_field_condition | 2020-12-21T08:50:37.382399+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45288 | 63147 | ice_skating_field_condition | 2020-12-21T07:57:39.946486+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45287 | 63147 | ice_skating_field_condition | 2020-12-21T07:57:23.450305+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45274 | 47279 | ice_skating_field_condition | 2020-12-21T07:32:02.882874+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45271 | 53563 | ice_skating_field_condition | 2020-12-21T07:29:32.520179+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45124 | 40493 | ice_skating_field_condition | 2020-12-20T20:48:39.981295+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45113 | 63148 | ice_skating_field_condition | 2020-12-20T20:01:55.251857+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45079 | 40493 | ice_skating_field_condition | 2020-12-20T18:14:39.631861+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45024 | 42699 | ice_skating_field_condition | 2020-12-20T15:38:21.883147+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 45023 | 46144 | ice_skating_field_condition | 2020-12-20T15:38:15.210992+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44994 | 40493 | ice_skating_field_condition | 2020-12-20T14:07:10.516996+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44897 | 39834 | ice_skating_field_condition | 2020-12-20T09:58:11.567553+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44896 | 53563 | ice_skating_field_condition | 2020-12-20T09:57:36.427360+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44885 | 42249 | ice_skating_field_condition | 2020-12-20T09:14:40.751217+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44868 | 41770 | ice_skating_field_condition | 2020-12-20T08:32:13.988486+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44866 | 42185 | ice_skating_field_condition | 2020-12-20T08:31:52.187484+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44865 | 42185 | ice_skating_field_condition | 2020-12-20T08:31:42.851559+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44852 | 63147 | ice_skating_field_condition | 2020-12-20T07:45:07.453668+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44696 | 40493 | ice_skating_field_condition | 2020-12-19T20:36:43.766402+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44692 | 63148 | ice_skating_field_condition | 2020-12-19T20:11:57.265195+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44623 | 42699 | ice_skating_field_condition | 2020-12-19T16:47:03.272362+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44618 | 40493 | ice_skating_field_condition | 2020-12-19T16:34:19.745272+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44599 | 46144 | ice_skating_field_condition | 2020-12-19T15:44:47.254059+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44592 | 63148 | ice_skating_field_condition | 2020-12-19T15:20:17.323162+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44573 | 42249 | ice_skating_field_condition | 2020-12-19T14:33:45.538044+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44500 | 63147 | ice_skating_field_condition | 2020-12-19T11:00:49.714885+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44490 | 63147 | ice_skating_field_condition | 2020-12-19T10:34:28.243024+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44470 | 53523 | ice_skating_field_condition | 2020-12-19T09:49:18.618293+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44469 | 53524 | ice_skating_field_condition | 2020-12-19T09:49:10.368453+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44461 | 41770 | ice_skating_field_condition | 2020-12-19T09:18:56.671336+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44459 | 42185 | ice_skating_field_condition | 2020-12-19T09:18:44.029890+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44458 | 42185 | ice_skating_field_condition | 2020-12-19T09:12:22.262653+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44457 | 42185 | ice_skating_field_condition | 2020-12-19T09:12:08.133744+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44453 | 40421 | ice_skating_field_condition | 2020-12-19T09:01:59.665664+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44439 | 39834 | ice_skating_field_condition | 2020-12-19T08:27:31.482318+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44438 | 61464 | ice_skating_field_condition | 2020-12-19T08:27:30.809173+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44429 | 53615 | ice_skating_field_condition | 2020-12-19T07:46:17.275366+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44428 | 47279 | ice_skating_field_condition | 2020-12-19T07:45:48.506657+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44427 | 63148 | ice_skating_field_condition | 2020-12-19T07:45:43.726833+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44415 | 53563 | ice_skating_field_condition | 2020-12-19T06:54:56.208368+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44306 | 42185 | ice_skating_field_condition | 2020-12-18T22:53:34.350539+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44273 | 63148 | ice_skating_field_condition | 2020-12-18T20:12:30.007120+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44249 | 47279 | ice_skating_field_condition | 2020-12-18T18:38:47.337271+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44157 | 42249 | ice_skating_field_condition | 2020-12-18T12:20:39.378889+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44104 | 63147 | ice_skating_field_condition | 2020-12-18T08:59:30.054877+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44103 | 63147 | ice_skating_field_condition | 2020-12-18T08:59:18.661570+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44093 | 39834 | ice_skating_field_condition | 2020-12-18T08:39:11.797305+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 44069 | 53563 | ice_skating_field_condition | 2020-12-18T06:52:30.458457+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43885 | 42249 | ice_skating_field_condition | 2020-12-17T16:04:05.609744+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43874 | 63148 | ice_skating_field_condition | 2020-12-17T15:22:47.402827+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43830 | 39370 | ice_skating_field_condition | 2020-12-17T12:12:18.898587+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43827 | 39370 | ice_skating_field_condition | 2020-12-17T12:11:54.753247+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43793 | 53563 | ice_skating_field_condition | 2020-12-17T09:33:26.931577+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43792 | 39834 | ice_skating_field_condition | 2020-12-17T09:33:06.269356+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43789 | 40402 | ice_skating_field_condition | 2020-12-17T09:28:43.328872+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43773 | 53615 | ice_skating_field_condition | 2020-12-17T08:43:13.196152+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43772 | 41770 | ice_skating_field_condition | 2020-12-17T08:41:53.132023+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43771 | 42185 | ice_skating_field_condition | 2020-12-17T08:41:41.752893+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 43758 | 40493 | ice_skating_field_condition | 2020-12-17T08:06:02.952614+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 );