126,220 rows sorted by id descending

View and edit SQL

Suggested facets: modified_at (date), street_modified_at (date)

id ▲ number number_end letter modified_at location_type location_coordinates_0 location_coordinates_1 street_id street_modified_at street_municipality street_name_fi street_name_sv postal_code
126220 1     2020-08-24T15:49:46.596204+03:00 Point 24.6327425 60.1565561 11654 2020-08-24T15:49:44.819185+03:00 espoo Höyrylaivantie Ångbåtsvägen 02320
126219 4     2020-08-24T15:49:46.591668+03:00 Point 24.9783397 60.209372 11653 2020-08-24T15:47:54.477232+03:00 helsinki Muotoilijankuja Designergränden 00560
126218 3     2020-08-24T15:49:46.591500+03:00 Point 24.9780871 60.2095245 11653 2020-08-24T15:47:54.477232+03:00 helsinki Muotoilijankuja Designergränden 00560
126217 2     2020-08-24T15:49:46.591588+03:00 Point 24.9787181 60.2098208 11653 2020-08-24T15:47:54.477232+03:00 helsinki Muotoilijankuja Designergränden 00560
126216 1     2020-08-24T15:49:46.591421+03:00 Point 24.9785377 60.2099375 11653 2020-08-24T15:47:54.477232+03:00 helsinki Muotoilijankuja Designergränden 00560
126215 1     2020-08-24T15:49:46.591261+03:00 Point 24.9301084 60.2202335 11652 2020-08-24T15:47:54.474254+03:00 helsinki Kollipolku Kollistigen 00240
126214 4     2020-08-24T15:49:46.020790+03:00 Point 24.8301972 60.1746558 11651 2020-06-15T15:07:19.521772+03:00 espoo Keilaniementori Kägeluddstorget 02150
126213 2     2020-06-15T15:07:19.884214+03:00 Point 24.8293513 60.1744932 11651 2020-06-15T15:07:19.521772+03:00 espoo Keilaniementori Kägeluddstorget 02150
126212 8     2020-06-15T15:07:19.883515+03:00 Point 24.5907338 60.1825878 11650 2020-06-15T15:07:19.488981+03:00 espoo Vesikelkantie Vattenkälkvägen 02780
126211 6     2020-06-15T15:07:19.883423+03:00 Point 24.5906027 60.1829823 11650 2020-06-15T15:07:19.488981+03:00 espoo Vesikelkantie Vattenkälkvägen 02780
126210 4     2020-06-15T15:07:19.884418+03:00 Point 24.5904383 60.1831613 11650 2020-06-15T15:07:19.488981+03:00 espoo Vesikelkantie Vattenkälkvägen 02780
126209 2     2020-06-15T15:07:19.883347+03:00 Point 24.5902194 60.183376 11650 2020-06-15T15:07:19.488981+03:00 espoo Vesikelkantie Vattenkälkvägen 02780
126208 10     2020-06-15T15:07:19.883786+03:00 Point 24.5904883 60.1820395 11650 2020-06-15T15:07:19.488981+03:00 espoo Vesikelkantie Vattenkälkvägen 02780
126207 4     2020-06-02T17:52:34.873541+03:00 Point 24.7589661 60.1714938 11649 2020-06-02T17:52:33.606629+03:00 espoo Rälssitilankuja Frälsehemmansgränden 02200
126206 2     2020-05-18T14:37:58.751053+03:00 Point 24.631712 60.1569212 11648 2020-05-18T14:37:58.163690+03:00 espoo Kiviruukinkatu Stenbruksgatan 02320
126205 1     2020-08-24T15:49:46.595826+03:00 Point 24.6325466 60.1563581 11648 2020-05-18T14:37:58.163690+03:00 espoo Kiviruukinkatu Stenbruksgatan 02320
126204 9     2020-05-18T14:37:58.738713+03:00 Point 24.5988264 60.1691851 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126203 8     2020-05-18T14:37:58.743379+03:00 Point 24.5990392 60.169464 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126202 7     2020-05-18T14:37:58.750389+03:00 Point 24.5986455 60.1692474 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126201 6     2020-05-18T14:37:58.744924+03:00 Point 24.5987512 60.1694452 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126200 5     2020-05-18T14:37:58.738856+03:00 Point 24.5983382 60.1693362 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126199 4     2020-05-18T14:37:58.738588+03:00 Point 24.598444 60.169525 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126198 3     2020-05-18T14:37:58.739036+03:00 Point 24.5981213 60.1693984 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126197 2     2020-05-18T14:37:58.752193+03:00 Point 24.5982088 60.1696051 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126196 1     2020-05-18T14:37:58.748211+03:00 Point 24.5978141 60.1694782 11647 2020-05-18T14:37:57.505402+03:00 espoo Kapsäkinkuja Kappsäcksgränden 02780
126195 8     2020-05-18T14:37:58.746166+03:00 Point 24.5985091 60.1700907 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126194 6     2020-05-18T14:37:58.738292+03:00 Point 24.5982941 60.1700003 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126193 5     2020-05-18T14:37:58.742153+03:00 Point 24.5987643 60.1698491 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126192 4     2020-05-18T14:37:58.748514+03:00 Point 24.5979716 60.1698557 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126191 3     2020-08-24T15:49:44.182975+03:00 Point 24.5981359 60.1696767 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126190 2     2020-08-24T15:49:45.887318+03:00 Point 24.5972927 60.1693959 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126189 1     2020-08-24T15:49:44.563421+03:00 Point 24.5977607 60.1694242 11646 2020-05-18T14:37:57.502297+03:00 espoo Kanisteritie Kanistervägen 02780
126188 9     2020-08-24T15:49:46.597841+03:00 Point 24.5966496 60.1704261 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126187 8     2020-05-18T14:37:58.737929+03:00 Point 24.5967627 60.1700136 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126186 7     2020-05-18T14:37:58.747459+03:00 Point 24.5969221 60.1702384 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126185 6     2020-05-18T14:37:58.737819+03:00 Point 24.5969625 60.1698795 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126184 5     2020-05-18T14:37:58.738027+03:00 Point 24.5971038 60.1701133 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126183 4     2020-05-18T14:37:58.737723+03:00 Point 24.5971256 60.1697993 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126182 3     2020-05-18T14:37:58.750498+03:00 Point 24.5973397 60.1699704 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126181 2     2020-05-18T14:37:58.749772+03:00 Point 24.5973253 60.1696742 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126180 12     2020-08-24T15:49:46.597447+03:00 Point 24.5962366 60.1703171 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126179 10     2020-05-18T14:37:58.750284+03:00 Point 24.5964545 60.1701742 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126178 1     2020-05-18T14:37:58.738151+03:00 Point 24.597539 60.1698723 11645 2020-05-18T14:37:57.485261+03:00 espoo Kanisterikuja Kanistergränden 02780
126177 6     2020-05-18T14:37:58.745542+03:00 Point 24.721107 60.2747087 11644 2020-05-18T14:37:57.310644+03:00 espoo Lambertinoja Lambertsbäcken 02920
126176 4     2020-05-18T14:37:58.746767+03:00 Point 24.7217041 60.2746202 11644 2020-05-18T14:37:57.310644+03:00 espoo Lambertinoja Lambertsbäcken 02920
126175 2     2020-05-18T14:37:58.732219+03:00 Point 24.7206032 60.2744473 11644 2020-05-18T14:37:57.310644+03:00 espoo Lambertinoja Lambertsbäcken 02920
126174 1     2020-05-18T14:37:58.748714+03:00 Point 24.7210746 60.2742688 11644 2020-05-18T14:37:57.310644+03:00 espoo Lambertinoja Lambertsbäcken 02920
126173 8     2020-05-18T14:37:58.743942+03:00 Point 24.7203518 60.2742583 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126172 7     2020-05-18T14:37:58.751775+03:00 Point 24.7212202 60.2741524 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126171 6   b 2020-05-18T14:37:58.751163+03:00 Point 24.7203011 60.2738543 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126170 6   a 2020-05-18T14:37:58.747793+03:00 Point 24.720914 60.2740351 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126169 5     2020-05-18T14:37:58.745662+03:00 Point 24.721728 60.2739381 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126168 4     2020-05-18T14:37:58.750713+03:00 Point 24.7220203 60.2735617 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126167 3     2020-05-18T14:37:58.745758+03:00 Point 24.7223081 60.2737149 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126166 21     2020-05-18T14:37:58.745032+03:00 Point 24.716132 60.2753354 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02940
126165 20     2020-05-18T14:37:58.744732+03:00 Point 24.7154286 60.2751723 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126164 2     2020-05-18T14:37:58.749036+03:00 Point 24.7228183 60.2732134 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126163 19     2020-05-18T14:37:58.732680+03:00 Point 24.7170545 60.2752386 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126162 18     2020-05-18T14:37:58.749889+03:00 Point 24.7165678 60.275094 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126161 17   b 2020-05-18T14:37:58.746046+03:00 Point 24.7175923 60.2757334 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126160 17   a 2020-05-18T14:37:58.745187+03:00 Point 24.7175968 60.2752129 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126159 16     2020-05-18T14:37:58.750953+03:00 Point 24.717454 60.2750061 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126158 15     2020-05-18T14:37:58.747980+03:00 Point 24.7189529 60.275126 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126157 14     2020-05-18T14:37:58.731372+03:00 Point 24.7182858 60.274954 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126156 13     2020-05-18T14:37:58.745295+03:00 Point 24.7198232 60.2747957 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126155 12     2020-05-18T14:37:58.740746+03:00 Point 24.7190631 60.2749198 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126154 11     2020-05-18T14:37:58.745408+03:00 Point 24.7202409 60.2745543 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126153 10     2020-05-18T14:37:58.744608+03:00 Point 24.7197529 60.2745622 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126152 1     2020-05-18T14:37:58.745934+03:00 Point 24.7231063 60.2733576 11643 2020-05-18T14:37:57.211735+03:00 espoo Lambertinsilta Lambertsbron 02920
126151 4     2020-05-18T14:37:58.744434+03:00 Point 24.7206304 60.2733793 11642 2020-05-18T14:37:57.210204+03:00 espoo Lambertinpiha Lambertsgården 02920
126150 3     2020-05-18T14:37:58.750844+03:00 Point 24.7197978 60.2735391 11642 2020-05-18T14:37:57.210204+03:00 espoo Lambertinpiha Lambertsgården 02920
126149 2     2020-05-18T14:37:58.744132+03:00 Point 24.7215325 60.2735517 11642 2020-05-18T14:37:57.210204+03:00 espoo Lambertinpiha Lambertsgården 02920
126148 1     2020-05-18T14:37:58.731252+03:00 Point 24.7208804 60.2737299 11642 2020-05-18T14:37:57.210204+03:00 espoo Lambertinpiha Lambertsgården 02920
126147 9     2020-05-18T14:37:58.743565+03:00 Point 24.5937946 60.1711354 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126146 8     2020-05-18T14:37:58.735304+03:00 Point 24.5939177 60.1713781 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126145 7     2020-05-18T14:37:58.752302+03:00 Point 24.5936306 60.1712875 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126144 6     2020-05-18T14:37:58.739324+03:00 Point 24.5937524 60.1716379 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126143 5     2020-05-18T14:37:58.735650+03:00 Point 24.5934669 60.1714127 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126142 4     2020-05-18T14:37:58.735412+03:00 Point 24.5936962 60.1718083 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126141 3     2020-08-24T15:49:46.230235+03:00 Point 24.593374 60.1716457 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126140 2     2020-05-18T14:37:58.729752+03:00 Point 24.5934432 60.1718703 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126139 13     2020-08-24T15:49:44.058238+03:00 Point 24.5941404 60.1708493 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126138 12     2020-05-18T14:37:58.746320+03:00 Point 24.5942086 60.1711636 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126137 11     2020-05-18T14:37:58.736199+03:00 Point 24.5939941 60.1710283 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126136 10     2020-05-18T14:37:58.735191+03:00 Point 24.5940268 60.1712977 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126135 1     2020-05-18T14:37:58.735509+03:00 Point 24.5928501 60.1717608 11641 2020-05-18T14:37:57.073830+03:00 espoo Rengasuunintie Ringugnsvägen 02780
126134 5     2020-03-05T15:01:43.936234+02:00 Point 24.6025524 60.1753805 11640 2020-03-05T15:01:42.984456+02:00 espoo Auerinkuja Auergränden 02780
126133 3   b 2020-03-05T15:01:43.936694+02:00 Point 24.6021912 60.1754512 11640 2020-03-05T15:01:42.984456+02:00 espoo Auerinkuja Auergränden 02780
126132 3   a 2020-08-24T15:49:43.059691+03:00 Point 24.6024777 60.1755957 11640 2020-03-05T15:01:42.984456+02:00 espoo Auerinkuja Auergränden 02780
126131 1     2020-08-24T15:49:46.597372+03:00 Point 24.602475 60.1758201 11640 2020-03-05T15:01:42.984456+02:00 espoo Auerinkuja Auergränden 02780
126130 8     2020-03-05T15:01:43.935591+02:00 Point 24.765654 60.2189141 11639 2020-03-05T15:01:38.694687+02:00 espoo Karamalmintie Karamalmsvägen 02610
126129 6     2020-03-05T15:01:43.935914+02:00 Point 24.765551 60.2181779 11639 2020-03-05T15:01:38.694687+02:00 espoo Karamalmintie Karamalmsvägen 02610
126128 2     2020-03-05T15:01:43.935729+02:00 Point 24.7633385 60.2122861 11639 2020-03-05T15:01:38.694687+02:00 espoo Karamalmintie Karamalmsvägen 02630
126127 7     2020-08-24T15:49:45.932353+03:00 Point 24.5723225 60.1918283 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126126 5     2020-08-24T15:49:46.010804+03:00 Point 24.5721225 60.1919623 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126125 4     2020-03-05T15:01:43.937302+02:00 Point 24.5717036 60.1922931 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126124 3     2020-08-24T15:49:45.409634+03:00 Point 24.5719036 60.1921591 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126123 2     2020-03-05T15:01:43.937132+02:00 Point 24.5714157 60.1922562 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126122 1     2020-03-05T15:01:43.937382+02:00 Point 24.5713101 60.1920584 11638 2020-03-03T09:11:29.770277+02:00 espoo Kaipuunkuja Längtans gränd 02780
126121 3     2020-03-03T09:11:32.006407+02:00 Point 24.6580413 60.1721784 11637 2020-03-03T09:11:29.351120+02:00 espoo Teerimäenportti Teerimäkiporten 02340

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [address] (
   [id] INTEGER PRIMARY KEY,
   [number] TEXT,
   [number_end] TEXT,
   [letter] TEXT,
   [modified_at] TEXT,
   [location_type] TEXT,
   [location_coordinates_0] FLOAT,
   [location_coordinates_1] FLOAT,
   [street_id] INTEGER,
   [street_modified_at] TEXT,
   [street_municipality] TEXT,
   [street_name_fi] TEXT,
   [street_name_sv] TEXT,
   [postal_code] TEXT
);