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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51161 | 47279 | ice_skating_field_condition | 2021-01-04T21:57:34.403708+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51140 | 63148 | ice_skating_field_condition | 2021-01-04T20:39:45.794307+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51136 | 46144 | ice_skating_field_condition | 2021-01-04T20:10:52.483239+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51120 | 40493 | ice_skating_field_condition | 2021-01-04T19:36:32.901669+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51084 | 42185 | ice_skating_field_condition | 2021-01-04T17:48:00.697438+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51082 | 41770 | ice_skating_field_condition | 2021-01-04T17:47:24.147192+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51072 | 47279 | ice_skating_field_condition | 2021-01-04T17:15:22.662801+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51057 | 46144 | ice_skating_field_condition | 2021-01-04T16:38:22.468391+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51043 | 40493 | ice_skating_field_condition | 2021-01-04T15:49:13.821722+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51040 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:36.236905+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51039 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:14.866885+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51038 | 63148 | ice_skating_field_condition | 2021-01-04T15:37:13.975225+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 51035 | 47279 | ice_skating_field_condition | 2021-01-04T15:25:33.491015+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50843 | 40493 | ice_skating_field_condition | 2021-01-04T10:09:38.311784+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50811 | 42249 | ice_skating_field_condition | 2021-01-04T08:25:29.165792+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50801 | 41770 | ice_skating_field_condition | 2021-01-04T07:50:02.902094+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50800 | 42185 | ice_skating_field_condition | 2021-01-04T07:49:44.789500+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50796 | 39834 | ice_skating_field_condition | 2021-01-04T07:35:17.129029+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50795 | 53563 | ice_skating_field_condition | 2021-01-04T07:34:39.921956+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50583 | 42249 | ice_skating_field_condition | 2021-01-03T17:13:37.230197+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50440 | 42249 | ice_skating_field_condition | 2021-01-03T10:38:17.675431+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50069 | 63148 | ice_skating_field_condition | 2021-01-02T12:26:49.327928+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50024 | 61464 | ice_skating_field_condition | 2021-01-02T10:11:25.208516+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 50016 | 42249 | ice_skating_field_condition | 2021-01-02T10:00:06.511791+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49988 | 40493 | ice_skating_field_condition | 2021-01-02T08:42:02.133172+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49984 | 39370 | ice_skating_field_condition | 2021-01-02T08:33:48.816201+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49975 | 53615 | ice_skating_field_condition | 2021-01-02T08:01:32.908182+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49974 | 53615 | ice_skating_field_condition | 2021-01-02T08:01:14.870146+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49973 | 47279 | ice_skating_field_condition | 2021-01-02T08:01:03.648651+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49972 | 47279 | ice_skating_field_condition | 2021-01-02T08:00:57.376635+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49965 | 63148 | ice_skating_field_condition | 2021-01-02T07:31:23.626857+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49749 | 39370 | ice_skating_field_condition | 2021-01-01T16:41:06.870108+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49686 | 53524 | ice_skating_field_condition | 2021-01-01T13:14:28.278871+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49685 | 53523 | ice_skating_field_condition | 2021-01-01T13:14:20.885097+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49662 | 53615 | ice_skating_field_condition | 2021-01-01T12:04:55.807273+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49646 | 42699 | ice_skating_field_condition | 2021-01-01T11:21:23.839080+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49642 | 47279 | ice_skating_field_condition | 2021-01-01T11:11:37.944182+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49591 | 41770 | ice_skating_field_condition | 2021-01-01T09:16:51.869280+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49590 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:41.104564+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49588 | 42185 | ice_skating_field_condition | 2021-01-01T09:16:25.012566+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49586 | 41770 | ice_skating_field_condition | 2021-01-01T09:15:50.628938+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49578 | 42249 | ice_skating_field_condition | 2021-01-01T08:52:12.058302+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49564 | 42185 | ice_skating_field_condition | 2021-01-01T08:07:02.560166+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49563 | 41770 | ice_skating_field_condition | 2021-01-01T08:06:51.803136+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49306 | 42699 | ice_skating_field_condition | 2020-12-31T13:28:05.364012+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49303 | 42249 | ice_skating_field_condition | 2020-12-31T13:23:33.339578+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49293 | 63147 | ice_skating_field_condition | 2020-12-31T13:05:58.488641+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49225 | 42249 | ice_skating_field_condition | 2020-12-31T10:19:25.060836+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49200 | 41770 | ice_skating_field_condition | 2020-12-31T09:22:35.354288+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49182 | 56438 | ice_skating_field_condition | 2020-12-31T08:49:56.781697+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49173 | 39834 | ice_skating_field_condition | 2020-12-31T08:03:00.941936+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49172 | 53563 | ice_skating_field_condition | 2020-12-31T08:02:53.016291+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49170 | 53615 | ice_skating_field_condition | 2020-12-31T07:51:11.674593+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49169 | 53615 | ice_skating_field_condition | 2020-12-31T07:50:45.999203+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 49006 | 63148 | ice_skating_field_condition | 2020-12-30T19:51:57.515619+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48819 | 42249 | ice_skating_field_condition | 2020-12-30T10:30:00.158498+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48791 | 63147 | ice_skating_field_condition | 2020-12-30T09:00:56.488265+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48614 | 63148 | ice_skating_field_condition | 2020-12-29T20:05:48.432741+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48528 | 63148 | ice_skating_field_condition | 2020-12-29T15:33:45.799060+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48498 | 63147 | ice_skating_field_condition | 2020-12-29T13:50:15.103664+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48209 | 63148 | ice_skating_field_condition | 2020-12-28T20:05:05.126818+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48156 | 42699 | ice_skating_field_condition | 2020-12-28T17:32:55.018385+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48147 | 41549 | ice_skating_field_condition | 2020-12-28T17:10:04.173174+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48140 | 63148 | ice_skating_field_condition | 2020-12-28T16:54:32.951047+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48055 | 42249 | ice_skating_field_condition | 2020-12-28T12:44:53.340211+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 48052 | 50568 | ice_skating_field_condition | 2020-12-28T12:39:50.414792+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47976 | 53523 | ice_skating_field_condition | 2020-12-28T09:03:49.595661+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47975 | 53524 | ice_skating_field_condition | 2020-12-28T09:03:41.386099+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47966 | 61464 | ice_skating_field_condition | 2020-12-28T08:47:13.960410+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47956 | 41770 | ice_skating_field_condition | 2020-12-28T08:04:22.323970+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47954 | 42185 | ice_skating_field_condition | 2020-12-28T08:03:54.737126+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47951 | 53615 | ice_skating_field_condition | 2020-12-28T07:55:04.763089+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47935 | 47279 | ice_skating_field_condition | 2020-12-28T06:46:11.282127+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47762 | 41549 | ice_skating_field_condition | 2020-12-27T19:01:33.319103+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47687 | 42249 | ice_skating_field_condition | 2020-12-27T15:06:55.346360+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47608 | 42699 | ice_skating_field_condition | 2020-12-27T11:32:11.924227+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47601 | 63147 | ice_skating_field_condition | 2020-12-27T11:03:13.295377+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47569 | 39834 | ice_skating_field_condition | 2020-12-27T09:49:13.465033+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47568 | 53563 | ice_skating_field_condition | 2020-12-27T09:49:01.161933+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47452 | 40493 | ice_skating_field_condition | 2020-12-27T01:06:48.073587+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47332 | 39370 | ice_skating_field_condition | 2020-12-26T17:32:33.126686+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47257 | 41549 | ice_skating_field_condition | 2020-12-26T13:51:22.797258+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47187 | 40493 | ice_skating_field_condition | 2020-12-26T10:18:05.487475+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47175 | 53524 | ice_skating_field_condition | 2020-12-26T09:56:14.612908+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47174 | 53523 | ice_skating_field_condition | 2020-12-26T09:55:48.091003+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47170 | 50568 | ice_skating_field_condition | 2020-12-26T09:48:02.280500+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47167 | 42699 | ice_skating_field_condition | 2020-12-26T09:34:57.534255+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47162 | 39370 | ice_skating_field_condition | 2020-12-26T09:15:19.527523+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47158 | 61464 | ice_skating_field_condition | 2020-12-26T09:06:21.896770+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47151 | 63147 | ice_skating_field_condition | 2020-12-26T08:48:23.506351+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47150 | 39834 | ice_skating_field_condition | 2020-12-26T08:44:14.655036+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47149 | 53563 | ice_skating_field_condition | 2020-12-26T08:44:04.440598+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47143 | 42249 | ice_skating_field_condition | 2020-12-26T08:29:40.366588+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47135 | 53615 | ice_skating_field_condition | 2020-12-26T07:52:39.699160+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47130 | 63148 | ice_skating_field_condition | 2020-12-26T07:39:46.253264+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 47123 | 47279 | ice_skating_field_condition | 2020-12-26T06:52:25.583019+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46988 | 41549 | ice_skating_field_condition | 2020-12-25T20:38:43.175834+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46924 | 41770 | ice_skating_field_condition | 2020-12-25T17:23:06.259648+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46890 | 40493 | ice_skating_field_condition | 2020-12-25T15:25:04.466055+0200 | Jäädytetty | Isad | 1 | Ice-covered | frozen | good | ||||
| 46853 | 39370 | ice_skating_field_condition | 2020-12-25T13:22:20.390199+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 );