User:Gz260/Roads/E/Wikidata/en-gb

From Wikidata
Jump to navigation Jump to search

Last update : Monday 25 November 2024 23:41:36

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images | Recent changes | Query: SELECT DISTINCT ?item ?itemLabel ?article (IF(bound(?article),CONCAT("{","{subst:Urltowiki\u007Curl=", str(?article), "\u007Cdisplay=", str(?itemLabel), "}","}"),str(?itemLabel)) As ?wparticle) WHERE { { ?item wdt:P16 wd:Q106123 . } UNION { ?item wdt:P31 wd:Q106123 . } . MINUS { ?item wdt:P361 ?part . ?part wdt:P16 wd:Q106123 } . OPTIONAL { ?item wdt:P1824 ?p1824 } BIND(STRLEN(str(?p1824)) as ?longp1824) BIND(SUBSTR(str(?p1824),1,1) as ?statut) BIND(SUBSTR(str(?p1824),2,(?longp1824 - 1)) as ?numero) BIND(REPLACE(SUBSTR(str(?numero),1,4),"[A-Za-z]","") as ?num) BIND(STRLEN(str(?num)) as ?longnum) BIND(CONCAT(IF(?longnum=1,"000",IF(?longnum=2,"00",IF(?longnum=3,"0",""))), str(?num)) as ?numz) BIND(CONCAT(str(?statut),str(?num)) as ?numsp) BIND(STRLEN(str(?numsp)) as ?longnumsp) BIND((?longp1824 - ?longnumsp) as ?longprefixe) BIND(SUBSTR(str(?p1824),(?longnumsp 1),?longprefixe) as ?prefixe) BIND(CONCAT(str(?statut),str(?numz),str(?prefixe)) as ?cledetri) . OPTIONAL { SELECT DISTINCT ?item (COUNT(?pays) as ?count) WHERE { { ?item wdt:P16 wd:Q106123 . } UNION { ?item wdt:P31 wd:Q106123 . } . ?item wdt:P17 ?pays . } GROUP BY ?item } . OPTIONAL { ?article schema:about ?item ; schema:inLanguage "en" ; schema:isPartOf <https://en.wikipedia.org/> } SERVICE wikibase:label { bd:serviceParam wikibase:language "en-gb" . } } ORDER BY ?cledetri ?longnum DESC(?count)
# Article (en-gb) Item Wikidata country Commons traffic sign road number
1 European route E01 European route E01 Q751771 United Kingdom
Ireland
Spain
Portugal
E01
E1
2 European route E001 European route E001 Q2621085 Georgia
Armenia
E001
E001
3 European route E2 Q56326601 Q56326601 United Kingdom
France
Switzerland
Italy
E2
4 European route E002 European route E002 Q2620531 Armenia
Azerbaijan
E002
E002
5 European route E03 European route E03 Q585439 France E3 (France)
E3
6 European route E003 European route E003 Q2295054 Uzbekistan
Turkmenistan
E003
E003
7 European route E04 European route E04 Q782249 Finland
Sweden
E4
E4
8 European route E004 European route E004 Q2253476 Kazakhstan
Uzbekistan
E004
E004
9 European route E05 European route E05 Q693493 United Kingdom
France
Spain
E5
E5
10 European route E005 European route E005 Q731942 Uzbekistan E005
E005
11 European route E06 European route E06 Q921422 Norway
Sweden
E6
E6
12 European route E006 European route E006 Q1900649 Tajikistan
Uzbekistan
E006
13 European route E07 European route E07 Q388884 France
Spain
E7
E7
14 European route E007 European route E007 Q2129887 Uzbekistan
Kyrgyzstan
E007
E007
15 European route E08 European route E08 Q1129207 Norway
Finland
E8
E8
16 European route E008 European route E008 Q666933 Tajikistan
E008
17 European route E09 European route E09 Q1320233 France
Spain
E9
E9
18 European route E009 European route E009 Q2109391 Tajikistan
E009
19 European route E10 European route E10 Q586592 Norway
Sweden
E10
E10
20 European route E010 European route E010 Q1861681 Kyrgyzstan Osh-Bishkek road
E010
21 European route E11 European route E11 Q1276480 France E11
E11
22 European route E011 European route E011 Q536536 Kazakhstan
Kyrgyzstan
E011
23 European route E12 European route E12 Q1346648 Norway
Sweden
Finland
E12
E12
24 European route E012 European route E012 Q1375783 Kazakhstan
China
E012
25 European route E13 European route E13 Q1247738 United Kingdom E13
E13
26 European route E013 European route E013 Q1375778 Kazakhstan
E013
27 European route E14 European route E14 Q1164832 Norway
Sweden
E14
E14
28 European route E014 European route E014 Q1375781 Kazakhstan
E014
29 European route E15 European route E15 Q862476 United Kingdom
France
Spain
E15
E15
30 European route E015 European route E015 Q662647 Kazakhstan E015
E015
31 European route E16 European route E16 Q642043 United Kingdom
Norway
Sweden
E16
E16
32 European route E016 European route E016 Q2329549 Kazakhstan E016
E016
33 European route E17 European route E17 Q1348422 Belgium
France
E17
E17
34 European route E017 European route E017 Q746156 Q159 E017
E017
35 European route E18 European route E18 Q945810 United Kingdom
Norway
Sweden
Finland
Q159
E18
E18
36 European route E018 European route E018 Q1945568 Kazakhstan E018
E018
37 European route E19 European route E19 Q1375828 Netherlands
Belgium
France
E19
E19
38 European route E019 European route E019 Q2194280 Kazakhstan E019
E019
39 European route E20 European route E20 Q987346 Ireland
United Kingdom
Denmark
Sweden
Estonia
Q159
E20
E20
40 European route E21 European route E21 Q662587 France
Switzerland
E21
E21
41 European route E22 European route E22 Q322164 United Kingdom
Netherlands
Germany
Sweden
Latvia
Q159
E22
E22
42 European route E23 European route E23 Q664809 France
Switzerland
E23
E23
43 European route E24 European route E24 Q1375832 United Kingdom E24
E24
44 European route E25 European route E25 Q659345 Netherlands
Belgium
Luxembourg
France
Switzerland
Italy
E25
E25
45 European route E26 European route E26 Q694396 Germany E26
E26
46 European route E27 European route E27 Q688946 France
Switzerland
Italy
E27
E27
47 European route E28 European route E28 Q314656 Germany
Q36
Q159
Lithuania
Belarus
E28
E28
48 European route E29 European route E29 Q688868 Germany
Luxembourg
France
E29
E29
49 European route E30 European route E30 Q160249 Ireland
United Kingdom
Netherlands
Germany
Q36
Belarus
Q159
E30
E30
50 European route E31 European route E31 Q699601 Netherlands
Germany
E31
E31
51 European route E32 European route E32 Q1375862 United Kingdom E32
E32
52 European route E33 European route E33 Q1375866 Italy E33
E33
53 European route E34 European route E34 Q819141 Belgium
Netherlands
Germany
E34
E34
54 European route E35 European route E35 Q313416 Netherlands
Germany
Switzerland
Italy
E35
E35
55 European route E36 European route E36 Q240696 Germany
Q36
E36
E36
56 European route E37 European route E37 Q701223 Germany E37
E37
57 European route E38 European route E38 Q289474 Ukraine
Q159
Kazakhstan
E38
E38
58 European route E39 European route E39 Q1375888 Norway
Denmark
E39
E39
59 European route E40 European route E40 Q327162 France
Belgium
Germany
Q36
Ukraine
Q159
Kazakhstan
Uzbekistan
Turkmenistan
Kyrgyzstan
E40
E40
60 European route E41 European route E41 Q662616 Germany
Switzerland
E41
E41
61 European route E42 European route E42 Q599910 France
Belgium
Germany
E42
E42
62 European route E43 European route E43 Q662603 Switzerland
Austria
Germany
E43
E43
63 European route E44 European route E44 Q705125 France
Luxembourg
Germany
E44
E44
64 European route E45 European route E45 Q276570 Norway
Finland
Sweden
Denmark
Germany
Austria
Italy
E45
E45
65 European route E46 European route E46 Q1375900 Belgium
France
E46
E46
66 European route E47 European route E47 Q692012 Germany
Denmark
Sweden
E47
E47
67 European route E48 European route E48 Q819705 Germany
Q213
E48
E48
68 European route E49 European route E49 Q667743 Germany
Q213
Austria
E49
E49
69 European route E50 European route E50 Q687438 France
Germany
Q213
Slovakia
Ukraine
Q159
E50
E50
70 European route E51 European route E51 Q692108 Germany E51
E51
71 European route E52 European route E52 Q691059 Austria
Germany
France
E52
E52
72 European route E53 European route E53 Q701208 Q213
Germany
E53
E53
73 European route E54 European route E54 Q664865 France
Switzerland
Germany
E54
E54
74 European route E55 European route E55 Q313410 Sweden
Denmark
Germany
Q213
Austria
Italy
Greece
E55
E55
75 European route E56 European route E56 Q690065 Austria
Germany
E56
E56
76 European route E57 European route E57 Q592509 Austria
Slovenia
E57
E57
77 European route E58 European route E58 Q180384 Austria
Slovakia
Ukraine
Romania
Moldova
Q159
Transnistria
E58
E58
78 European route E59 European route E59 Q674617 Q213
Austria
Slovenia
Q224
E59
E59
79 European route E60 European route E60 Q168020 France
Switzerland
Austria
Germany
Hungary
Romania
Georgia
Azerbaijan
Turkmenistan
Uzbekistan
Tajikistan
Kyrgyzstan
China
E60
E60
80 European route E61 European route E61 Q695537 Austria
Slovenia
Italy
Q224
E61
E61
81 European route E62 European route E62 Q665254 France
Switzerland
Italy
E62
E62
82 European route E63 European route E63 Q1375933 Finland E63
E63
83 European route E64 European route E64 Q736643 Italy E64
E64
84 European route E65 European route E65 Q911135 Sweden
Q36
Q213
Slovakia
Hungary
Q224
Bosnia and Herzegovina
Montenegro
Serbia
Kosovo
North Macedonia
Greece
E65
E65
85 European route E66 European route E66 Q689827 Italy
Austria
Hungary
E66
E66
86 European route E67 European route E67 Q754430 Finland
Estonia
Latvia
Lithuania
Q36
Q213
E67
E67
87 European route E68 European route E68 Q1375951 Hungary
Romania
E68
E68
88 European route E69 European route E69 Q1375971 Norway E69
E69
89 European route E70 European route E70 Q741488 Spain
France
Italy
Slovenia
Q224
Serbia
Romania
Bulgaria
Q43
Georgia
E70
E70
90 European route E71 European route E71 Q1375976 Slovakia
Hungary
Q224
Bosnia and Herzegovina
E71
E71
91 European route E72 European route E72 Q1375978 France E72
E72
92 European route E73 European route E73 Q1375987 Hungary
Q224
Bosnia and Herzegovina
E73
E73
93 European route E74 European route E74 Q600011 France
Italy
E74
E74
94 European route E75 European route E75 Q638912 Norway
Finland
Q36
Q213
Slovakia
Hungary
Serbia
North Macedonia
Greece
E75
E75
95 European route E76 European route E76 Q768830 Italy E76
E76
96 European route E77 European route E77 Q918092 Q159
Estonia
Latvia
Lithuania
Q36
Slovakia
Hungary
E77
E77
97 European route E78 European route E78 Q1376002 Italy E78
E78
98 European route E79 European route E79 Q580571 Hungary
Romania
Bulgaria
Greece
E79
E79
99 European route E80 European route E80 Q877647 Portugal
Spain
France
Italy
Q224
Montenegro
Serbia
Kosovo
Bulgaria
Q43
E80
E80
100 European route E81 European route E81 Q987350 Romania
Ukraine
E81
E81
101 European route E82 European route E82 Q1376012 Spain
Portugal
E82
E82
102 European route E83 European route E83 Q955939 Bulgaria E83
E83
103 European route E84 European route E84 Q612223 Q43 E84
E84
104 European route E85 European route E85 Q926976 Lithuania
Belarus
Ukraine
Romania
Bulgaria
Greece
E85
E85
105 European route E86 European route E86 Q1376023 Greece
Albania
E86
E86
106 European route E87 European route E87 Q1376032 Ukraine
Moldova
Romania
Bulgaria
Q43
E87
E87
107 European route E88 European route E88 Q607197 Q43 E88
E88
108 European route E89 European route E89 Q2419632 Q43 E89
E89
109 European route E90 European route E90 Q370080 Portugal
Spain
Italy
Greece
Q43
E90
E90
110 European route E91 European route E91 Q2163648 Q43 E91
E91
111 European route E92 European route E92 Q2579452 Greece E92
E92
112 European route E93 European route E93 Q3444696 Q159
Belarus
Ukraine
E93
113 European route E94 European route E94 Q2586090 Greece E94
E94
114 European route E95 European route E95 Q1165682 Q159
Belarus
Ukraine
Q43
E95
E95
115 European route E96 European route E96 Q2373964 Q43 E96
E96
116 European route E97 European route E97 Q784392 Ukraine
Q159
Georgia
Q43
E97
E97
117 European route E98 European route E98 Q2296040 Q43 E98
E98
118 European route E99 European route E99 Q548533 Azerbaijan
Q43
Syria
E99
E99
119 European route E101 European route E101 Q2283567 Q159
Ukraine
E101
E101
120 European route E104 Q60856181 Q60856181 United Kingdom E104
121 European route E105 European route E105 Q1321545 Norway
Q159
Ukraine
E105
E105
122 European route E109 Q108114490 Q108114490 United Kingdom E109
123 European route E114 Q65169436 Q65169436 United Kingdom E114
124 European route E115 European route E115 Q1375790 Q159 E115
E115
125 European route E116 Q111456842 Q111456842 United Kingdom E116
126 European route E117 European route E117 Q1375799 Q159
Georgia
Armenia
E117
E117
127 European route E118 Q108114524 Q108114524 United Kingdom
Ireland
E118
128 European route E119 European route E119 Q2535163 Q159
Azerbaijan
Iran
E119
E119
129 European route E121 European route E121 Q649131 Q159
Kazakhstan
Turkmenistan
E121
E121
130 European route E123 European route E123 Q1821054 Q159
Kazakhstan
Uzbekistan
Tajikistan
E123
E123
131 European route E125 European route E125 Q2625376 Q159
Kazakhstan
Kyrgyzstan
E125
E125
132 European route E127 European route E127 Q2078255 Q159
Kazakhstan
E127
E127
133 European route E134 European route E134 Q1589334 Norway E134
E134
134 European route E136 European route E136 Q2345677 Norway E136
E136
135 European route E201 European route E201 Q3444668 Ireland E201
E201
136 European route E231 European route E231 Q2707350 Netherlands E231
E231
137 European route E232 European route E232 Q1375818 Netherlands E232
E232
138 European route E233 European route E233 Q658777 Germany
Netherlands
E233
E233
139 European route E234 European route E234 Q2521396 Germany E234
E234
140 European route E251 European route E251 Q819547 Germany E251
E251
141 European route E261 European route E261 Q1375834 Q36 E261
E261
142 European route E262 European route E262 Q1995013 Lithuania
Latvia
Q159
E262
E262
143 European route E263 European route E263 Q1375845 Estonia E263
E263
144 European route E264 European route E264 Q2718918 Estonia
Latvia
E264
E264
145 European route E265 European route E265 Q2728829 Estonia
Sweden
E265
E265
146 European route E271 European route E271 Q3041902 Belarus E271
E271
147 European route E272 European route E272 Q2477727 Lithuania E272
E272
148 European route E311 European route E311 Q613422 Netherlands E311
E311
149 European route E312 European route E312 Q2138240 Netherlands E312
E312
150 European route E313 European route E313 Q1375855 Belgium E313
E313
151 European route E314 European route E314 Q669854 Belgium
Netherlands
Germany
E314
E314
152 European route E331 European route E331 Q669799 Germany E331
E331
153 European route E371 European route E371 Q2436200 Q36
Slovakia
E371
E371
154 European route E372 European route E372 Q2418651 Ukraine
Q36
E372
E372
155 European route E373 European route E373 Q1978383 Q36
Ukraine
E373
E373
156 European route E381 European route E381 Q2575132 Q159
Ukraine
E381
157 European route E391 European route E391 Q693049 Q159
Ukraine
E391
E391
158 European route E401 European route E401 Q1922885 France E401
E401
159 European route E402 European route E402 Q644844 France E402
E402
160 European route E403 European route E403 Q2679997 Belgium E403
E403
161 European route E404 European route E404 Q2771746 Belgium E404
E404
162 European route E411 European route E411 Q1920250 Belgium
France
E411
E411
163 European route E420 European route E420 Q3177582 Belgium
France
E420
E420
164 European route E421 European route E421 Q2023107 Belgium
Luxembourg
E421
E421
165 European route E422 European route E422 Q637443 Germany E422
E422
166 European route E429 European route E429 Q2655746 Belgium E429
E429
167 European route E441 European route E441 Q2181304 Germany E441
E441
168 European route E442 European route E442 Q1375889 Q213
Slovakia
E442
E442
169 European route E451 European route E451 Q637808 Germany E451
E451
170 European route E461 European route E461 Q662928 Austria
Q213
E461
E461
171 European route E462 European route E462 Q1375896 Q213
Q36
E462
E462
172 European route E471 European route E471 Q2013618 Ukraine E471
E471
173 European route E501 European route E501 Q2481606 France E501
E501
174 European route E502 European route E502 Q2474511 France E502
E502
175 European route E511 European route E511 Q2197886 France E511
E511
176 European route E512 European route E512 Q572356 France E512
E512
177 European route E531 European route E531 Q555518 Germany E531
E531
178 European route E532 European route E532 Q324855 Germany
Austria
E532
E532
179 European route E533 European route E533 Q745665 Germany
Austria
Bundesautobahn 95
E533
180 European route E551 European route E551 Q2743430 Q213 E551
E551
181 European route E552 European route E552 Q1792888 Austria
Germany
E552
E552
182 European route E571 European route E571 Q2438196 Slovakia E571
E571
183 European route E572 European route E572 Q2791074 Slovakia E572
E572
184 European route E573 European route E573 Q928483 Hungary
Ukraine
E573
E573
185 European route E574 European route E574 Q987339 Romania E574
E574
186 European route E575 European route E575 Q2078433 Slovakia
Hungary
E575
E575
187 European route E576 European route E576 Q338977 Romania E576
E576
188 European route E577 European route E577 Q1375910 Romania E577
E577
189 European route E578 European route E578 Q987340 Romania E578
E578
190 European route E579 European route E579 Q10478772 Hungary
E579
191 European route E581 European route E581 Q2243600 Romania
Moldova
Ukraine
E581
E581
192 European route E583 European route E583 Q1852724 Romania
Moldova
Ukraine
E583
E583
193 European route E584 European route E584 Q546742 Ukraine
Moldova
Romania
E584
E584
194 European route E591 European route E591 Q53828736 Q159
E591
195 European route E592 European route E592 Q2137859 Q159 E592
E592
196 European route E601 European route E601 Q2450792 France E601
E601
197 European route E602 European route E602 Q1797423 France E602
E602
198 European route E603 European route E603 Q1794844 France E603
E603
199 European route E604 European route E604 Q2091528 France E604
E604
200 European route E606 European route E606 Q2333741 France E606
E606
201 European route E607 European route E607 Q1795007 France E607
E607
202 European route E611 European route E611 Q1795057 France E611
E611
203 European route E612 European route E612 Q1637858 Italy E612
E612
204 European route E641 European route E641 Q514182 Austria
Germany
E641
E641
205 European route E651 European route E651 Q688368 Austria Ennstal-Straße
E651
206 European route E652 European route E652 Q2150243 Austria
Slovenia
E652
E652
207 European route E653 European route E653 Q2604283 Hungary
Slovenia
E653
E653
208 European route E661 European route E661 Q676174 Hungary
Q224
Bosnia and Herzegovina
E661
E661
209 European route E662 European route E662 Q2456332 Q224
Serbia
E662
E662
210 European route E671 European route E671 Q1378637 Romania E671
E671
211 European route E673 European route E673 Q1375938 Romania E673
E673
212 European route E675 European route E675 Q2579632 Romania
Bulgaria
E675
E675
213 European route E691 European route E691 Q1375961 Armenia
Georgia
Q43
E691
E691
214 European route E692 European route E692 Q1960959 Georgia E692
E692
215 European route E711 European route E711 Q3120429 France E711
E711
216 European route E712 European route E712 Q1955315 France
Switzerland
E712
E712
217 European route E713 European route E713 Q746049 France E713
E713
218 European route E714 European route E714 Q2265961 France E714
E714
219 European route E717 European route E717 Q2099373 Italy E717
E717
220 European route E751 European route E751 Q1871269 Q224
Slovenia
E751
E751
221 European route E761 European route E761 Q745873 Bosnia and Herzegovina
Serbia
E761
E761
222 European route E762 European route E762 Q2425402 Bosnia and Herzegovina
Montenegro
Albania
E762
E762
223 European route E763 European route E763 Q2425390 Serbia
Montenegro
E763
E763
224 European route E771 European route E771 Q2621685 Romania
Serbia
E771
E771
225 European route E772 European route E772 Q2303347 Bulgaria E772
E772
226 European route E773 European route E773 Q3041141 Bulgaria E773
E773
227 European route E801 European route E801 Q2154690 Spain
Portugal
E801
E801
228 European route E802 European route E802 Q27383 Portugal E802
E802
229 European route E803 European route E803 Q2433065 Spain E803
E803
230 European route E804 European route E804 Q2741026 Spain E804
E804
231 European route E805 European route E805 Q129065 Portugal E805
E805
232 European route E806 European route E806 Q129067 Portugal E806
E806
233 European route E821 European route E821 Q1641750 Italy E821
E821
234 European route E840 European route E840 Q2564356 Italy E840
E840
235 European route E841 European route E841 Q1375993 Italy E841
E841
236 European route E842 European route E842 Q2444194 Italy E842
E842
237 European route E843 European route E843 Q744600 Italy E843
E843
238 European route E844 European route E844 Q2707357 Italy E844
E844
239 European route E846 European route E846 Q2446271 Italy E846
E846
240 European route E847 European route E847 Q972968 Italy E847
E847
241 European route E848 European route E848 Q2266100 Italy E848
E848
242 European route E851 European route E851 Q947951 Montenegro
Albania
Kosovo
E851
E851
243 European route E852 European route E852 Q2041537 North Macedonia
Albania
E852
E852
244 European route E853 European route E853 Q374394 Greece
Albania
E853
E853
245 European route E871 European route E871 Q2694282 Bulgaria
North Macedonia
E871
E871
246 European route E881 European route E881 Q2521873 Q43 E881
E881
247 European route E901 European route E901 Q1812428 Spain E901
E901
248 European route E902 European route E902 Q8353069 Spain E902
E902
249 European route E903 European route E903 Q17629116 Spain
E903
250 European route E931 European route E931 Q2106476 Italy E931
E931
251 European route E932 European route E932 Q2033565 Italy E932
E932
252 European route E933 European route E933 Q2497220 Italy E933
E933
253 European route E951 European route E951 Q2467961 Greece E951
E951
254 European route E952 European route E952 Q1956688 Greece E952
E952
255 European route E961 European route E961 Q2516367 Greece
E961
256 European route E962 European route E962 Q2182124 Greece E962
E962
257 European route E981 European route E981 Q10478786 Q43 E981
E981
258 European route E982 European route E982 Q10478788 Q43 E982
E982
End of automatically generated list.