Cologne, North Rhine-Westphalia
163,657 rows
This data as json, CSV (advanced)
Link | rowid ▼ | House number | Street name | Postal code | Latitude | Longitude |
---|---|---|---|---|---|---|
1 | 1 | 107 | Höninger Weg | 50969 | 50.9155914 | 6.9412465 |
2 | 2 | 7 | Ottoplatz | 50679 | 50.9404581 | 6.9740513 |
3 | 3 | 5 | Ehrenfeldgürtel | 50823 | 50.9491514 | 6.9150847 |
4 | 4 | 165 | Widdersdorfer Straße | 50825 | 50.9450045 | 6.9074639 |
5 | 5 | 30 | Rathenauplatz | 50674 | 50.9313358 | 6.9369729 |
6 | 6 | 57 | Hahnenstraße | 50667 | 50.9354109 | 6.9409484 |
7 | 7 | 1 | Buchforststraße | 51103 | 50.9408725 | 7.0081399 |
8 | 8 | 24 | Markt | 51103 | 50.9403976 | 7.0064900 |
9 | 9 | 30 | Eichendorffstraße | 50825 | 50.9563517 | 6.9225004 |
10 | 10 | 231b | Venloer Straße | 50823 | 50.9458003 | 6.9234550 |
11 | 11 | 1 | Kardinal-Höffner-Platz | 50667 | 50.9414704 | 6.9562010 |
12 | 12 | 354 | Venloer Straße | 50825 | 50.9509656 | 6.9158335 |
13 | 13 | 531 | Frankfurter Straße | 51145 | 50.8820468 | 7.0819618 |
14 | 14 | 11 | Am Pistorhof | 50827 | 50.9650548 | 6.9092410 |
15 | 15 | 543 | Subbelrather Straße | 50827 | 50.9604109 | 6.9025528 |
16 | 16 | 30 | Girlitzweg | 50829 | 50.9487691 | 6.8801290 |
17 | 17 | 165 | Godorfer Hauptstraße | 50997 | 50.8570393 | 6.9739829 |
18 | 18 | 628 | Venloer Straße | 50827 | 50.9575357 | 6.9010473 |
19 | 19 | 195 | Merheimer Straße | 50733 | 50.9649907 | 6.9476391 |
20 | 20 | 54 a | Akazienweg | 50827 | 50.9632796 | 6.8943621 |
21 | 21 | 83 | Severinstraße | 50678 | 50.9255261 | 6.9581475 |
22 | 22 | 494 | Neusser Straße | 50737 | 50.9755222 | 6.9502807 |
23 | 23 | 482 | Neusser Straße | 50733 | 50.9749464 | 6.9505653 |
24 | 24 | 35 | Donatusstraße | 50767 | 51.0012577 | 6.8773141 |
25 | 25 | 118c | Liebigstraße | 50823 | 50.9552745 | 6.9321013 |
26 | 26 | 161 | Liebigstraße | 50823 | 50.9556374 | 6.9323100 |
27 | 27 | 151 | Liebigstraße | 50823 | 50.9553742 | 6.9316059 |
28 | 28 | 153 | Liebigstraße | 50823 | 50.9554180 | 6.9317276 |
29 | 29 | 269 | Subbelrather Straße | 50825 | 50.9547349 | 6.9172551 |
30 | 30 | 120-122 | Sandweg | 50827 | 50.9667427 | 6.8976838 |
31 | 31 | 112 | Sandweg | 50827 | 50.9665163 | 6.8979450 |
32 | 32 | 674-678 | Venloer Straße | 50827 | 50.9588887 | 6.8980421 |
33 | 33 | 31 | Hackländerstraße | 50825 | 50.9570594 | 6.9115847 |
34 | 34 | 353 | Subbelrather Straße | 50825 | 50.9566763 | 6.9125427 |
35 | 35 | 2 | Halmstraße | 50825 | 50.9566402 | 6.9133840 |
36 | 36 | 349 | Subbelrather Straße | 50825 | 50.9564628 | 6.9129698 |
37 | 37 | 329 | Subbelrather Straße | 50825 | 50.9560691 | 6.9139599 |
38 | 38 | 72 | Ottostraße | 50823 | 50.9564907 | 6.9270626 |
39 | 39 | 15 | Hauptstraße | 50859 | 50.9646114 | 6.8297994 |
40 | 40 | 37-39 | Hauptstraße | 50859 | 50.9662752 | 6.8339333 |
41 | 41 | 18 | Siegesstraße | 50679 | 50.9386312 | 6.9736398 |
42 | 42 | 84 | Deutzer Freiheit | 50679 | 50.9367090 | 6.9747846 |
43 | 43 | 112 | Deutzer Freiheit | 50679 | 50.9368136 | 6.9770323 |
44 | 44 | 2 | Justinianstraße | 50679 | 50.9374127 | 6.9782451 |
45 | 45 | 94 | Constantinstraße | 50679 | 50.9389462 | 6.9777340 |
46 | 46 | 162 | Iltisstraße | 50825 | 50.9646275 | 6.9130488 |
47 | 47 | 17 | Rothenkruger Straße | 50825 | 50.9635517 | 6.9183215 |
48 | 48 | 257 | Liebigstraße | 50739 | 50.9585317 | 6.9405879 |
49 | 49 | 88 | Escher Straße | 50739 | 50.9592017 | 6.9404021 |
50 | 50 | 12c | Alzeyer Straße | 50739 | 50.9713624 | 6.9284929 |
51 | 51 | 59 | Am Bilderstöckchen | 50739 | 50.9737406 | 6.9268549 |
52 | 52 | 59 | Am Bilderstöckchen | 50739 | 50.9737637 | 6.9269098 |
53 | 53 | 57 | Am Bilderstöckchen | 50739 | 50.9738058 | 6.9270105 |
54 | 54 | 50 | Schiefersburger Weg | 50739 | 50.9690328 | 6.9299480 |
55 | 55 | 255 | Neue Kempener Straße | 50739 | 50.9744531 | 6.9394086 |
56 | 56 | 7 a | Wirtsgasse | 50739 | 50.9982226 | 6.9102249 |
57 | 57 | 92 | Mauenheimer Straße | 50733 | 50.9684534 | 6.9490557 |
58 | 58 | 18 | Simon-Meister-Straße | 50733 | 50.9660259 | 6.9494246 |
59 | 59 | 30 | Friedrich-Karl-Straße | 50739 | 50.9750511 | 6.9498106 |
60 | 60 | 10 | August-Haas-Straße | 50737 | 50.9962175 | 6.9205267 |
61 | 61 | 32 | Altonaer Straße | 50737 | 50.9956587 | 6.9241810 |
62 | 62 | 30 | Altonaer Straße | 50737 | 50.9955061 | 6.9253020 |
63 | 63 | 61 | Siebachstraße | 50733 | 50.9608398 | 6.9496582 |
64 | 64 | 150 | Merkenicher Hauptstraße | 50769 | 51.0246810 | 6.9597844 |
65 | 65 | 28 | Kleiner Griechenmarkt | 50676 | 50.9319646 | 6.9483053 |
66 | 66 | 32 | Neuhöfferstraße | 50679 | 50.9395399 | 6.9753385 |
67 | 67 | 3 | Gotenring | 50679 | 50.9366126 | 6.9781404 |
68 | 68 | 219 | Widdersdorfer Straße | 50825 | 50.9451841 | 6.8994991 |
69 | 69 | 301 | Vitalisstraße | 50933 | 50.9470886 | 6.8859955 |
70 | 70 | 303 | Vitalisstraße | 50933 | 50.9469573 | 6.8859112 |
71 | 71 | 393 | Vitalisstraße | 50933 | 50.9433421 | 6.8828213 |
72 | 72 | 13-15 | Görlinger Zentrum | 50829 | 50.9802848 | 6.8668264 |
73 | 73 | 1 | Johannisstraße | 50668 | 50.9421137 | 6.9589528 |
74 | 74 | 96 | Constantinstraße | 50679 | 50.9389185 | 6.9780129 |
75 | 75 | 6 | Im Mediapark | 50670 | 50.9486109 | 6.9441573 |
76 | 76 | 72 | Hackenbroicher Straße | 50769 | 51.0650638 | 6.8587862 |
77 | 77 | 39 | Zollstockgürtel | 50969 | 50.9058175 | 6.9379079 |
78 | 78 | 7 | Ottoplatz | 50679 | 50.9404307 | 6.9748290 |
79 | 79 | 4 | Turmstraße | 50733 | 50.9645067 | 6.9515413 |
80 | 80 | 32 | Mauenheimer Straße | 50733 | 50.9664155 | 6.9518029 |
81 | 81 | 12 | Schillstraße | 50733 | 50.9664800 | 6.9512066 |
82 | 82 | 2 | Florastraße | 50733 | 50.9649047 | 6.9540377 |
83 | 83 | 254 | Neusser Straße | 50733 | 50.9637582 | 6.9540820 |
84 | 84 | 323 | Neusser Straße | 50733 | 50.9663418 | 6.9531875 |
85 | 85 | 20-30 | Weißhausstraße | 50939 | 50.9200318 | 6.9357168 |
86 | 86 | 65 | Schildergasse | 50667 | 50.9359454 | 6.9526631 |
87 | 87 | 1-3 | Gereonstraße | 50670 | 50.9424726 | 6.9506705 |
88 | 88 | 2 | Appellhofplatz | 50667 | 50.9406395 | 6.9525326 |
89 | 89 | 1-9 | Dompropst-Ketzer-Straße | 50667 | 50.9426730 | 6.9569413 |
90 | 90 | 182 | Neusser Straße | 50733 | 50.9599996 | 6.9547383 |
91 | 91 | 450 | Neusser Straße | 50733 | 50.9727616 | 6.9514650 |
92 | 92 | 450 | Neusser Straße | 50733 | 50.9728169 | 6.9531184 |
93 | 93 | 47 | Machabäerstraße | 50668 | 50.9465135 | 6.9607660 |
94 | 94 | 308-310 | Niehler Straße | 50735 | 50.9754251 | 6.9601650 |
95 | 95 | 2 | Baudriplatz | 50733 | 50.9644644 | 6.9526336 |
96 | 96 | 295 | Neusser Straße | 50733 | 50.9650637 | 6.9533927 |
97 | 97 | 355 | Venloer Straße | 50823 | 50.9493861 | 6.9177017 |
98 | 98 | 457 | Neusser Straße | 50733 | 50.9727944 | 6.9509162 |
99 | 99 | 292-294 | Neusser Straße | 50733 | 50.9654144 | 6.9537522 |
100 | 100 | 39 | Marsdorfer Straße | 50858 | 50.9274680 | 6.8569580 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Cologne, North Rhine-Westphalia] ( [House number] TEXT, [Street name] TEXT, [Postal code] TEXT, [Latitude] TEXT, [Longitude] TEXT );