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 );