123 rows where letter = "e"

View and edit SQL

Suggested facets: street_municipality, 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
322 16   e 2018-08-07T16:12:26.163169+03:00 Point 25.1284344 60.2107656 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
335 6   e 2018-08-07T16:12:37.400505+03:00 Point 25.1325268 60.2103487 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
693 33   e 2018-08-07T16:12:37.474628+03:00 Point 25.066935 60.2567198 57 2018-08-07T16:12:22.724600+03:00 helsinki Alppikylänkatu Alpbygatan 00770
1866 2   e 2018-08-07T16:12:26.266375+03:00 Point 24.8660669 60.2234873 166 2018-08-07T16:12:22.949374+03:00 helsinki Atomitie Atomvägen 00370
4232 1   e 2018-08-07T16:12:37.831796+03:00 Point 25.0710838 60.2709166 398 2018-08-07T16:12:23.398453+03:00 helsinki Heikinlaaksontie Henriksdalsvägen 00760
4793 6   e 2018-08-07T16:12:47.099940+03:00 Point 25.1253161 60.1970901 453 2018-08-07T16:12:23.512284+03:00 helsinki Hiidenmaankatu Dagögatan 00980
6461 6   e 2018-08-07T16:12:26.599353+03:00 Point 24.9001141 60.2412526 579 2018-08-07T16:12:23.794321+03:00 helsinki Kaarelantie Kårbölevägen 00430
8629 1   e 2018-08-07T16:12:38.218991+03:00 Point 24.8895885 60.2361552 740 2018-08-07T16:12:24.099349+03:00 helsinki Kantelettarentie Kanteletarvägen 00420
9150 2   e 2018-08-07T16:12:38.400995+03:00 Point 24.8815216 60.2157562 780 2018-08-07T16:12:24.166620+03:00 helsinki Karvaamokuja Garverigränden 00380
9849 11   e 2018-08-07T16:12:47.363296+03:00 Point 25.0786732 60.2560133 858 2018-08-07T16:12:24.326264+03:00 helsinki Kankaretie Hympelvägen 00770
10815 16   e 2018-08-07T16:12:47.974730+03:00 Point 24.8910483 60.2150822 919 2018-08-07T16:12:24.466411+03:00 helsinki Isonnevantie Stormyrvägen 00320
11820 2   e 2018-08-07T16:12:26.963154+03:00 Point 25.0736805 60.2605397 1002 2018-08-07T16:12:24.668152+03:00 helsinki Jakomäentie Jakobackavägen 00770
11842 8   e 2018-08-07T16:12:47.191813+03:00 Point 25.0723708 60.2563939 1002 2018-08-07T16:12:24.668152+03:00 helsinki Jakomäentie Jakobackavägen 00770
13760 13   e 2018-08-07T16:12:42.065049+03:00 Point 24.933391 60.1761749 1207 2018-08-07T16:12:25.111055+03:00 helsinki Mannerheimintie Mannerheimvägen 00100
14669 2   e 2018-08-07T16:12:38.559255+03:00 Point 24.8532314 60.1806161 1256 2018-08-07T16:12:25.237346+03:00 helsinki Lehtisaarentie Lövövägen 00340
16907 5   e 2018-08-07T16:12:42.117014+03:00 Point 24.9716404 60.1979899 1466 2018-08-07T16:12:25.745477+03:00 helsinki Kyläsaarenkatu Byholmsgatan 00580
16964 22   e 2018-08-07T16:12:42.303493+03:00 Point 24.9304024 60.251782 1469 2018-08-07T16:12:25.750840+03:00 helsinki Kytöniityntie Kyttängsvägen 00670
16971 24   e 2018-08-07T16:12:27.414912+03:00 Point 24.9276742 60.2523909 1469 2018-08-07T16:12:25.750840+03:00 helsinki Kytöniityntie Kyttängsvägen 00670
16995 37   e 2018-08-07T16:12:27.416522+03:00 Point 24.9311059 60.2521234 1469 2018-08-07T16:12:25.750840+03:00 helsinki Kytöniityntie Kyttängsvägen 00670
17121 29   e 2018-08-07T16:12:27.363322+03:00 Point 24.8589572 60.185855 1479 2018-08-07T16:12:25.768435+03:00 helsinki Kuusiniementie Granuddsvägen 00340
17431 11   e 2018-08-07T16:12:48.005463+03:00 Point 24.9620824 60.2159473 1499 2018-08-07T16:12:25.809083+03:00 helsinki Käpyläntie Kottbyvägen 00600
18355 1   e 2018-08-07T16:12:47.550230+03:00 Point 25.0553695 60.2743706 1576 2018-08-07T16:12:25.964463+03:00 helsinki Laaksotie Dalvägen 00760
19335 4   e 2018-08-07T16:12:43.287618+03:00 Point 24.9013016 60.2005501 1676 2018-08-07T16:12:28.387789+03:00 helsinki Koroistentie Koroisvägen 00280
22493 2   e 2018-08-07T16:12:42.490898+03:00 Point 24.9208718 60.1676145 1928 2018-08-07T16:12:28.923424+03:00 helsinki Mechelininkatu Mechelingatan 00180
23980 2   e 2018-08-07T16:12:32.428726+03:00 Point 24.977927 60.2598942 2052 2018-08-07T16:12:29.204282+03:00 helsinki Ollilantie Ollasvägen 00780
24583 5   e 2018-09-18T18:27:10.865902+03:00 Point 25.1108436 60.2358228 2104 2018-08-07T16:12:29.328863+03:00 helsinki Naulakalliontie Spikbergsvägen 00970
24591 7   e 2018-09-18T18:27:10.866915+03:00 Point 25.1115101 60.2354363 2104 2018-08-07T16:12:29.328863+03:00 helsinki Naulakalliontie Spikbergsvägen 00970
28119 13   e 2018-08-07T16:12:43.289295+03:00 Point 24.9504695 60.213179 2439 2018-08-07T16:12:30.047021+03:00 helsinki Sampsantie Sampsavägen 00610
28663 17   e 2018-08-07T16:12:43.163433+03:00 Point 24.9329634 60.2533899 2488 2018-08-07T16:12:30.149297+03:00 helsinki Rakovalkeantie Nyingsvägen 00670
31341 4   e 2018-08-07T16:12:47.351739+03:00 Point 24.981932 60.2689778 2763 2018-08-07T16:12:30.806805+03:00 helsinki Peltokyläntie Åkerbyvägen 00740
32581 4   e 2018-08-07T16:12:47.350821+03:00 Point 25.032408 60.244634 2900 2018-08-07T16:12:31.088850+03:00 helsinki Tullivuorentie Tullbergsvägen 00700
32817 32   e 2018-08-07T16:12:43.121581+03:00 Point 24.9382363 60.1576789 2917 2018-08-07T16:12:31.122408+03:00 helsinki Tehtaankatu Fabriksgatan 00150
32822 34   e 2018-08-07T16:12:47.659195+03:00 Point 24.9357513 60.1577046 2917 2018-08-07T16:12:31.122408+03:00 helsinki Tehtaankatu Fabriksgatan 00150
33973 1   e 2020-08-24T15:47:54.902107+03:00 Point 24.8861034 60.2417529 2999 2018-08-07T16:12:31.282018+03:00 helsinki Vanhaistentie Gamlasvägen 00420
35530 5   e 2018-08-07T16:12:33.306464+03:00 Point 24.8739432 60.2444883 3118 2018-08-07T16:12:31.548292+03:00 helsinki Urkupillintie Orgelpipsvägen 00420
39354 5   e 2018-08-07T16:12:47.349571+03:00 Point 25.0292122 60.2444642 3517 2018-08-07T16:12:35.051792+03:00 helsinki Väärämäentie Vindobackavägen 00700
39361 7   e 2018-08-07T16:12:47.350202+03:00 Point 25.0301524 60.2459718 3517 2018-08-07T16:12:35.051792+03:00 helsinki Väärämäentie Vindobackavägen 00700
39732 26   e 2018-08-07T16:12:47.601248+03:00 Point 25.0222657 60.2511432 3544 2018-08-07T16:12:35.112947+03:00 helsinki Vilppulantie Filpusvägen 00700
40661 27   e 2018-08-07T16:12:43.294772+03:00 Point 24.8738117 60.2082816 3619 2018-08-07T16:12:35.257786+03:00 helsinki Ulvilantie Ulfsbyvägen 00350
43112 2   e 2018-08-07T16:12:48.080785+03:00 Point 24.7155553 60.2189238 4046 2018-08-07T16:12:46.166297+03:00 kauniainen Akatemiantie Akademivägen 02700
44382 8   e 2020-08-24T15:47:55.869674+03:00 Point 24.9704911 60.2933257 4170 2018-08-07T16:12:46.580897+03:00 vantaa Äyritie Örevägen 01510
45888 56   e 2018-09-18T18:27:10.867875+03:00 Point 24.8483713 60.2732814 4288 2018-08-07T16:12:47.004730+03:00 vantaa Vihertie Grönvägen 01600
46969 6   e 2020-08-24T15:48:02.068097+03:00 Point 24.814629 60.2677457 4368 2018-08-07T16:12:49.730164+03:00 vantaa Varistontie Varistovägen 01660
47504 256   e 2019-11-06T14:38:02.211623+02:00 Point 25.0931258 60.3082581 4399 2018-08-07T16:12:49.870914+03:00 vantaa Vanha Porvoontie Gamla Borgåvägen 01380
47600 354   e 2020-08-24T15:48:03.274699+03:00 Point 25.1483307 60.3391008 4399 2018-08-07T16:12:49.870914+03:00 vantaa Vanha Porvoontie Gamla Borgåvägen 01490
47606 356   e 2020-08-24T15:48:03.258498+03:00 Point 25.1505401 60.3391701 4399 2018-08-07T16:12:49.870914+03:00 vantaa Vanha Porvoontie Gamla Borgåvägen  
47614 358   e 2020-08-24T15:48:03.229129+03:00 Point 25.1508521 60.3400852 4399 2018-08-07T16:12:49.870914+03:00 vantaa Vanha Porvoontie Gamla Borgåvägen 01490
47732 2   e 2018-08-07T16:12:52.595597+03:00 Point 24.8416768 60.3236339 4404 2018-08-07T16:12:49.930392+03:00 vantaa Vanha Kannistontie Gamla Kannistovägen 01700
47842 2   e 2020-08-24T15:48:04.069746+03:00 Point 25.0623881 60.3350223 4413 2018-08-07T16:12:49.960201+03:00 vantaa Valtimotie Pulsvägen 01400
48609 1   e 2020-08-24T15:48:05.974324+03:00 Point 25.1079927 60.3402885 4470 2018-08-07T16:12:50.175352+03:00 vantaa Uranuksenkuja Uranusgränden 01480
48834 7   e 2018-08-07T16:12:52.745140+03:00 Point 24.8103212 60.2659625 4484 2018-08-07T16:12:50.235887+03:00 vantaa Ulkoniitynkuja Utängsgränden 01660
49154 28   e 2018-08-07T16:12:52.786851+03:00 Point 25.1106383 60.324804 4516 2018-08-07T16:12:50.325605+03:00 vantaa Tuulikintie Tuulikkivägen 01420
49855 10   e 2020-08-24T15:48:09.093496+03:00 Point 24.934341 60.2779291 4575 2018-08-07T16:12:50.525325+03:00 vantaa Tolkinkyläntie Tolkbyvägen 01690
50129 137   e 2020-08-24T15:48:09.726848+03:00 Point 24.9521249 60.3025649 4600 2018-08-07T16:12:50.592637+03:00 vantaa Tikkurilantie Dickursbyvägen 01530
51360 3   e 2020-08-24T15:48:12.822094+03:00 Point 24.874002 60.351357 4691 2018-08-07T16:12:50.951828+03:00 vantaa Tammirinteentie Ekbrinksvägen 01760
54204 17   e 2020-08-24T15:48:20.214784+03:00 Point 24.8783939 60.32965 4954 2018-08-07T16:12:51.851919+03:00 vantaa Santakuopantie Sandgropsvägen 01730
54231 9   e 2020-08-24T15:48:20.262318+03:00 Point 24.8715967 60.327355 4954 2018-08-07T16:12:51.851919+03:00 vantaa Santakuopantie Sandgropsvägen 01730
54676 7   e 2020-08-24T15:48:21.225953+03:00 Point 24.9729295 60.2964317 5001 2018-08-07T16:12:51.991318+03:00 vantaa Rälssitie Frälsevägen 01510
55036 6   e 2020-08-24T15:48:22.080484+03:00 Point 25.0308132 60.3343423 5045 2018-08-07T16:12:52.101280+03:00 vantaa Runotie Diktvägen 01390
55240 7   e 2020-08-24T15:48:22.539910+03:00 Point 24.857571 60.3227364 5056 2018-08-07T16:12:52.155319+03:00 vantaa Rubiinikehä Rubinringen 01700
55279 3   e 2018-08-07T16:12:53.631005+03:00 Point 24.9647016 60.2965105 5061 2018-08-07T16:12:52.174738+03:00 vantaa Robert Huberin tie Robert Hubers väg 01510
55312 25   e 2020-08-24T15:48:22.695802+03:00 Point 25.110342 60.3281789 5062 2018-08-07T16:12:52.179611+03:00 vantaa Ritvantie Ritvavägen 01420
55644 38   e 2018-08-07T16:12:53.692017+03:00 Point 24.8625385 60.3335837 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01730
55668 49   e 2020-08-24T15:48:23.678446+03:00 Point 24.8647235 60.3305433 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01730
55675 51   e 2020-08-24T15:48:23.660139+03:00 Point 24.8666054 60.3307158 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01730
55688 57   e 2020-08-24T15:48:23.631741+03:00 Point 24.8665539 60.3344494 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01730
55694 59   e 2020-08-24T15:48:23.616350+03:00 Point 24.8654466 60.3351663 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01730
55710 67   e 2020-08-24T15:48:23.578883+03:00 Point 24.8665696 60.3439093 5086 2018-08-07T16:12:52.260975+03:00 vantaa Riipiläntie Ripubyvägen 01760
56890 17   e 2020-08-24T15:48:26.475660+03:00 Point 24.8642384 60.3950296 5180 2018-08-07T16:12:54.888509+03:00 vantaa Rajakoskentie Råforsvägen 01760
59097 11   e 2020-08-24T15:48:31.733796+03:00 Point 24.86823 60.2869361 5384 2018-08-07T16:12:55.506743+03:00 vantaa Perkiöntie Nybolandsvägen 01670
61218 47   e 2020-08-24T15:48:36.575634+03:00 Point 25.1822337 60.2818951 5564 2018-08-07T16:12:56.119126+03:00 vantaa Nybyggetintie Nybyggesvägen 01200
61495 23   e 2018-08-07T16:12:58.428304+03:00 Point 25.1047205 60.3475789 5586 2018-08-07T16:12:56.203630+03:00 vantaa Norppatie Vikarvägen 01480
62663 2   e 2019-06-19T23:59:32.461222+03:00 Point 24.8535226 60.2649132 5677 2018-08-07T16:12:56.557002+03:00 vantaa Myyrmäentie Myrbackavägen 01600
62683 5   e 2019-06-19T23:59:32.462039+03:00 Point 24.8522765 60.2648221 5678 2018-08-07T16:12:56.559186+03:00 vantaa Myyrmäenraitti Myrbackaleden 01600
63538 14   e 2020-08-24T15:48:42.319271+03:00 Point 24.848705 60.3301401 5750 2018-08-07T16:12:56.825690+03:00 vantaa Miekkatie Svärdvägen 01700
63552 2   e 2020-08-24T15:48:42.381422+03:00 Point 24.8475621 60.3268 5750 2018-08-07T16:12:56.825690+03:00 vantaa Miekkatie Svärdvägen 01700
63954 52   e 2020-08-24T15:48:43.121162+03:00 Point 25.1023408 60.3510811 5772 2018-08-07T16:12:56.922065+03:00 vantaa Metsolantie Skogsbrinksvägen 01450
64531 17   e 2018-08-07T16:12:58.798912+03:00 Point 24.8399568 60.2830905 5821 2018-08-07T16:12:57.112571+03:00 vantaa Martinkyläntie Mårtensbyvägen 01620
67238 46   e 2018-08-07T16:13:02.841041+03:00 Point 25.0898559 60.3559457 6030 2018-08-07T16:13:00.171544+03:00 vantaa Leppäkorventie Alkärrsvägen 01450
67519 8   e 2020-08-24T15:48:51.130588+03:00 Point 25.1208792 60.3043764 6057 2018-08-07T16:13:00.261117+03:00 vantaa Lehtomäentie Lundbacksvägen 01260
67969 1   e 2020-08-24T15:48:52.744077+03:00 Point 25.1247916 60.3200615 6087 2018-08-07T16:13:00.381267+03:00 vantaa Laurintie Larsvägen 01420
68411 2   e 2020-08-24T15:48:53.519757+03:00 Point 24.8653449 60.3378947 6112 2018-08-07T16:13:00.492741+03:00 vantaa Lapintie Lappvägen 01760
68417 3   e 2020-08-24T15:48:53.503305+03:00 Point 24.8663137 60.3356429 6112 2018-08-07T16:13:00.492741+03:00 vantaa Lapintie Lappvägen 01760
68682 14   e 2020-08-24T15:48:54.224635+03:00 Point 25.0135897 60.3187013 6139 2018-08-07T16:13:00.576530+03:00 vantaa Laaksotie Dalvägen 01390
69377 2   e 2020-08-24T15:48:55.730490+03:00 Point 25.0955002 60.2602655 6206 2018-08-07T16:13:00.796640+03:00 vantaa Kuussillantie Sexbrovägen 01230
70090 16   e 2018-08-07T16:13:03.220129+03:00 Point 25.0698567 60.2971161 6253 2018-08-07T16:13:00.994451+03:00 vantaa Kunnaantie Stenkullavägen 01370
70810 6   e 2020-08-24T15:48:58.920081+03:00 Point 24.7904074 60.3570585 6297 2018-08-07T16:13:01.194731+03:00 vantaa Kuhajoentie Kuhajokivägen 01750
71667 3   e 2018-08-07T16:13:03.411523+03:00 Point 24.7755304 60.3469641 6361 2018-08-07T16:13:01.436793+03:00 vantaa Kongontie Kongovägen 01750
71879 10   e 2018-08-07T16:13:03.440084+03:00 Point 24.7856357 60.2918636 6383 2018-08-07T16:13:01.503115+03:00 vantaa Koivurinne Björkbrinken 01680
71933 9   e 2020-08-24T15:49:01.430254+03:00 Point 24.7858742 60.2913345 6383 2018-08-07T16:13:01.503115+03:00 vantaa Koivurinne Björkbrinken 01680
73445 11   e 2020-08-24T15:49:05.114497+03:00 Point 25.123376 60.3045716 6506 2018-08-07T16:13:01.948447+03:00 vantaa Kiertomäentie Ombacksvägen 01260
73505 9   e 2020-08-24T15:49:05.131908+03:00 Point 25.1203021 60.3048436 6506 2018-08-07T16:13:01.948447+03:00 vantaa Kiertomäentie Ombacksvägen 01260
73526 15   e 2020-08-24T15:49:05.353478+03:00 Point 24.8157731 60.2602619 6509 2018-08-07T16:13:01.968448+03:00 vantaa Kierretie Skruvgängsvägen 01650
75442 1   e 2020-08-24T15:49:09.450673+03:00 Point 24.8109831 60.2576882 6637 2018-08-07T16:13:02.511516+03:00 vantaa Karhunkierros Björnringen 01640
75448 2   e 2020-08-24T15:49:09.434656+03:00 Point 24.809749 60.2587096 6637 2018-08-07T16:13:02.511516+03:00 vantaa Karhunkierros Björnringen 01640
75617 51   e 2018-08-07T16:13:03.887971+03:00 Point 24.85826 60.3307789 6648 2018-08-07T16:13:02.547199+03:00 vantaa Kannistontie Kannistovägen 01730
75986 15   e 2020-08-24T15:49:11.325276+03:00 Point 25.1533545 60.2984013 6686 2018-08-07T16:13:04.839926+03:00 vantaa Kalkkiuunintie Kalkugnsvägen 01200
76107 5   e 2020-08-24T15:49:11.657435+03:00 Point 24.8730863 60.2653283 6701 2018-08-07T16:13:04.877224+03:00 vantaa Kaivokselantie Gruvstavägen 01610
76201 4   e 2020-08-24T15:49:11.906605+03:00 Point 24.8206627 60.2612828 6707 2018-08-07T16:13:04.901144+03:00 vantaa Kairakuja Navargränden 01650
79421 7   e 2020-08-24T15:49:19.506461+03:00 Point 25.0541348 60.2817219 6964 2018-08-07T16:13:05.908406+03:00 vantaa Heidehofinkaari Heidehofssvängen 00750

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