observation

526 rows where name_fi = "Aurattu" sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

name_fi ✖

  • Aurattu · 526 ✖
id ▲ unit property time expiration_time value_fi name_fi value_sv name_sv primary name_en value quality value_en
51160 53615 ice_skating_field_condition 2021-01-04T21:56:39.719521+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
51071 53615 ice_skating_field_condition 2021-01-04T17:14:29.700935+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50935 50265 ice_skating_field_condition 2021-01-04T13:16:06.429717+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50934 39269 ice_skating_field_condition 2021-01-04T13:15:53.672873+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50853 39498 ice_skating_field_condition 2021-01-04T10:36:55.339893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50814 40421 ice_skating_field_condition 2021-01-04T08:33:23.302497+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50812 50522 ice_skating_field_condition 2021-01-04T08:29:30.610446+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50799 39604 ice_skating_field_condition 2021-01-04T07:41:49.161325+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50673 53615 ice_skating_field_condition 2021-01-03T21:52:01.252674+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50597 47849 ice_skating_field_condition 2021-01-03T17:51:58.987327+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50554 40421 ice_skating_field_condition 2021-01-03T15:49:14.887724+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50535 39370 ice_skating_field_condition 2021-01-03T14:41:47.515737+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50534 39604 ice_skating_field_condition 2021-01-03T14:40:40.730513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50502 40493 ice_skating_field_condition 2021-01-03T13:20:32.890468+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50499 39710 ice_skating_field_condition 2021-01-03T13:17:39.975338+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50483 40493 ice_skating_field_condition 2021-01-03T12:29:17.311470+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50469 63148 ice_skating_field_condition 2021-01-03T11:51:58.445877+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50467 39398 ice_skating_field_condition 2021-01-03T11:44:23.405663+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50465 39654 ice_skating_field_condition 2021-01-03T11:43:33.539915+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50450 46144 ice_skating_field_condition 2021-01-03T10:55:05.242835+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50446 40493 ice_skating_field_condition 2021-01-03T10:50:25.859806+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50439 42249 ice_skating_field_condition 2021-01-03T10:38:05.705272+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50413 39780 ice_skating_field_condition 2021-01-03T09:02:49.801111+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50406 40493 ice_skating_field_condition 2021-01-03T08:39:45.203053+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50403 39370 ice_skating_field_condition 2021-01-03T08:26:28.057241+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50396 63148 ice_skating_field_condition 2021-01-03T07:57:39.585831+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50395 47279 ice_skating_field_condition 2021-01-03T07:50:18.786508+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50392 53615 ice_skating_field_condition 2021-01-03T07:50:00.506457+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50222 40493 ice_skating_field_condition 2021-01-02T19:14:01.360460+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50213 41770 ice_skating_field_condition 2021-01-02T18:56:50.112833+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50211 42185 ice_skating_field_condition 2021-01-02T18:56:29.417401+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50155 40421 ice_skating_field_condition 2021-01-02T16:04:32.786529+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50153 39370 ice_skating_field_condition 2021-01-02T16:00:18.836318+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50121 50515 ice_skating_field_condition 2021-01-02T14:10:07.838409+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50117 39296 ice_skating_field_condition 2021-01-02T14:09:21.163492+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50116 39385 ice_skating_field_condition 2021-01-02T14:08:15.782544+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50115 50265 ice_skating_field_condition 2021-01-02T14:07:26.392533+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50114 39398 ice_skating_field_condition 2021-01-02T14:05:21.784611+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50113 39401 ice_skating_field_condition 2021-01-02T14:04:52.717175+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50112 39269 ice_skating_field_condition 2021-01-02T14:04:11.634280+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50111 39315 ice_skating_field_condition 2021-01-02T14:03:31.347039+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50109 39710 ice_skating_field_condition 2021-01-02T14:02:25.181872+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50108 39604 ice_skating_field_condition 2021-01-02T14:01:56.584990+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50106 39780 ice_skating_field_condition 2021-01-02T14:01:04.787142+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50104 39498 ice_skating_field_condition 2021-01-02T14:00:32.977245+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
50100 50522 ice_skating_field_condition 2021-01-02T13:59:51.226091+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49730 40421 ice_skating_field_condition 2021-01-01T15:36:40.196064+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49625 63147 ice_skating_field_condition 2021-01-01T10:36:55.767287+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49604 39370 ice_skating_field_condition 2021-01-01T09:52:36.166153+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49589 42185 ice_skating_field_condition 2021-01-01T09:16:32.474175+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49587 41770 ice_skating_field_condition 2021-01-01T09:15:56.086948+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49577 42249 ice_skating_field_condition 2021-01-01T08:52:09.343198+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49573 40493 ice_skating_field_condition 2021-01-01T08:46:45.291733+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49285 40493 ice_skating_field_condition 2020-12-31T12:51:16.450478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49222 41608 ice_skating_field_condition 2020-12-31T10:17:13.524716+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49201 41770 ice_skating_field_condition 2020-12-31T09:22:55.932893+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49198 41805 ice_skating_field_condition 2020-12-31T09:22:26.229235+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49194 40421 ice_skating_field_condition 2020-12-31T09:10:58.784530+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49186 53524 ice_skating_field_condition 2020-12-31T08:52:51.572167+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49185 53523 ice_skating_field_condition 2020-12-31T08:52:43.946843+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49165 47279 ice_skating_field_condition 2020-12-31T07:50:03.914149+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
49164 40493 ice_skating_field_condition 2020-12-31T07:48:33.075406+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48930 40493 ice_skating_field_condition 2020-12-30T15:53:20.880025+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48919 63148 ice_skating_field_condition 2020-12-30T15:16:47.071706+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48840 41770 ice_skating_field_condition 2020-12-30T11:28:01.036102+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48838 53524 ice_skating_field_condition 2020-12-30T11:21:19.932760+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48779 40493 ice_skating_field_condition 2020-12-30T08:12:03.252495+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48776 53615 ice_skating_field_condition 2020-12-30T08:05:00.704748+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48773 47279 ice_skating_field_condition 2020-12-30T07:58:25.365271+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48515 53563 ice_skating_field_condition 2020-12-29T14:46:59.542005+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48456 41770 ice_skating_field_condition 2020-12-29T11:55:18.638365+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48455 42185 ice_skating_field_condition 2020-12-29T11:55:09.008375+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48417 53523 ice_skating_field_condition 2020-12-29T10:12:12.877985+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48416 53524 ice_skating_field_condition 2020-12-29T10:11:23.579513+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48402 41770 ice_skating_field_condition 2020-12-29T09:37:35.296207+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48401 42185 ice_skating_field_condition 2020-12-29T09:37:25.636501+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48400 42249 ice_skating_field_condition 2020-12-29T09:33:38.249660+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48394 63147 ice_skating_field_condition 2020-12-29T09:14:09.348215+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48381 47279 ice_skating_field_condition 2020-12-29T08:35:22.744251+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48380 53615 ice_skating_field_condition 2020-12-29T08:32:35.225643+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48378 40421 ice_skating_field_condition 2020-12-29T08:28:09.444452+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48375 39834 ice_skating_field_condition 2020-12-29T08:18:29.729323+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48372 40493 ice_skating_field_condition 2020-12-29T08:03:39.715570+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
48364 53563 ice_skating_field_condition 2020-12-29T07:31:06.433442+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47999 40493 ice_skating_field_condition 2020-12-28T10:18:41.189772+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47677 41549 ice_skating_field_condition 2020-12-27T14:33:19.562478+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47667 53615 ice_skating_field_condition 2020-12-27T14:04:39.046378+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47666 47279 ice_skating_field_condition 2020-12-27T14:04:31.289524+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47633 53523 ice_skating_field_condition 2020-12-27T12:34:06.412066+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47632 53524 ice_skating_field_condition 2020-12-27T12:33:55.824520+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47609 41770 ice_skating_field_condition 2020-12-27T11:32:28.007843+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47588 42185 ice_skating_field_condition 2020-12-27T10:47:00.324313+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47561 41770 ice_skating_field_condition 2020-12-27T09:12:21.560363+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47554 42185 ice_skating_field_condition 2020-12-27T08:57:12.750237+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
47547 50568 ice_skating_field_condition 2020-12-27T08:35:26.776227+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46925 42185 ice_skating_field_condition 2020-12-25T17:23:16.756314+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46761 39370 ice_skating_field_condition 2020-12-25T09:20:55.461705+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46137 40493 ice_skating_field_condition 2020-12-23T10:22:09.159264+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46129 41770 ice_skating_field_condition 2020-12-23T10:09:47.118072+0200     Aurattu   Plogad 1 Cleared of snow plowed good  
46127 41549 ice_skating_field_condition 2020-12-23T10:06:12.068045+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
);