Difference between revisions of "Culture.si:Custom event list"
From Culture.si
| Line 1: | Line 1: | ||
| + | {{#data:grid | ||
| + | |country = Event.Country | ||
| + | |city = Event.City | ||
| + | |count = count(*) | ||
| + | |#where = Event.Country <> 'Slovenia' AND (extract(year from Event.Start) = 2013 OR extract(year from Event.End) = 2013) | ||
| + | |#orderby = Event.Country, Event.City | ||
| + | |#groupby = Event.City,Event.Country | ||
| + | |#limit = 2000 | ||
| + | }} | ||
{{#arr:dataloop | {{#arr:dataloop | ||
Revision as of 21:32, 15 April 2014
| country | city | count |
|---|---|---|
| Albania | Elbasan | 1 |
| Albania | Tirana | 1 |
| Argentina | Buenos_Aires | 7 |
| Argentina | Salta | 1 |
| Argentina | Yerba_Buena | 1 |
| Australia | Adelaide | 1 |
| Australia | Brisbane | 1 |
| Australia | Melbourne | 1 |
| Australia | Mullumbimby | 1 |
| Australia | Sydney | 1 |
| Austria | Bad_Eisenkappel/Železna_Kapla | 1 |
| Austria | Bad_Radkersburg/Radgona | 1 |
| Austria | Bleiburg/Pliberk | 4 |
| Austria | Feldbach | 2 |
| Austria | Graz | 17 |
| Austria | Hallein | 1 |
| Austria | Judenburg | 1 |
| Austria | Klagenfurt/Celovec | 11 |
| Austria | Kremsmünster | 1 |
| Austria | Linz | 1 |
| Austria | Mistelbach_an_der_Zaya | 1 |
| Austria | Oberwart | 1 |
| Austria | Oslip | 1 |
| Austria | Salzburg | 2 |
| Austria | Sankt_Paul_im_Lavanttal/Šentpavel_v_Labotski_dolini | 1 |
| Austria | Spitz_an_der_Donau | 1 |
| Austria | St._Johann_im_Rosental/Šentjanž_v_Rožu | 7 |
| Austria | St._Michael/Šmihel | 1 |
| Austria | Vienna | 57 |
| Austria | Villach/Beljak | 1 |
| Austria | Weissenback_am_Attersee | 1 |
| Austria | Wels | 1 |
| Belgium | Antwerp | 1 |
| Belgium | Bever | 1 |
| Belgium | Brussels | 11 |
| Belgium | Haacht | 1 |
| Belgium | Leuven | 1 |
| Belgium | Namur | 1 |
| Belgium | Schaerbeek | 1 |
| Bolivia | Santa_Cruz | 1 |
| Bosnia_and_Herzegovina | Banja_Luka | 1 |
| Bosnia_and_Herzegovina | Bugojno | 1 |
| Bosnia_and_Herzegovina | Konjic | 1 |
| Bosnia_and_Herzegovina | Mostar | 3 |
| Bosnia_and_Herzegovina | Sarajevo | 13 |
| Bosnia_and_Herzegovina | Zenica | 3 |
| Brazil | Brasília | 1 |
| Brazil | Curitiba | 1 |
| Brazil | Porto_Alegre | 2 |
| Brazil | Recife | 1 |
| Brazil | Rio_de_Janeiro | 4 |
| Brazil | São_Paulo | 4 |
| Brazil | Tiradentes | 1 |
| Bulgaria | Balčik | 2 |
| Bulgaria | Dobrič | 2 |
| Bulgaria | Sofia | 2 |
| Bulgaria | Stara_Zagora | 1 |
| Bulgaria | Varna | 3 |
| Canada | Edmonton | 1 |
| Canada | Montreal | 2 |
| Canada | Ottawa | 2 |
| Canada | Toronto | 3 |
| Canada | Vancouver | 3 |
| Chile | Providencia | 1 |
| Chile | Santiago | 2 |
| China | Beijing | 6 |
| China | Hong_Kong | 1 |
| China | Qinghai | 1 |
| China | Shanghai | 1 |
| Colombia | Bogotá | 2 |
| Colombia | Medellin | 1 |
| Croatia | Bjelovar | 1 |
| Croatia | Čakovec | 1 |
| Croatia | Dubrovnik | 2 |
| Croatia | Islam_Grčki | 1 |
| Croatia | Karlovac | 1 |
| Croatia | Makarska | 1 |
| Croatia | Motovun | 1 |
| Croatia | Osijek | 4 |
| Croatia | Poreč | 1 |
| Croatia | Pula | 6 |
| Croatia | Rijeka | 10 |
| Croatia | Rovinj | 1 |
| Croatia | Šibenik | 2 |
| Croatia | Silba | 1 |
| Croatia | Slavonski_Brod | 1 |
| Croatia | Split | 6 |
| Croatia | Starigrad | 1 |
| Croatia | Umag | 1 |
| Croatia | Varaždin | 4 |
| Croatia | Vinkovci | 1 |
| Croatia | Virovitica | 1 |
| Croatia | Vukovar | 2 |
| Croatia | Zabok | 2 |
| Croatia | Zadar | 1 |
| Croatia | Zagreb | 62 |
| Czech_Republic | Beroun | 1 |
| Czech_Republic | Bohumín | 1 |
| Czech_Republic | Boskovice | 1 |
| Czech_Republic | Brno | 8 |
| Czech_Republic | České_Budějovice | 1 |
| Czech_Republic | Český_Krumlov | 1 |
| Czech_Republic | Český_Těšín | 1 |
| Czech_Republic | Chrudim | 2 |
| Czech_Republic | Horni_Počernice | 1 |
| Czech_Republic | Hradec_Králové | 2 |
| Czech_Republic | Hronov | 1 |
| Czech_Republic | Jičín | 1 |
| Czech_Republic | Karlovy_Vary | 1 |
| Czech_Republic | Krakovec | 1 |
| Czech_Republic | Kroměříž | 1 |
| Czech_Republic | Kuks | 1 |
| Czech_Republic | Liberec | 1 |
| Czech_Republic | Olomouc | 1 |
| Czech_Republic | Opava | 1 |
| Czech_Republic | Ostrava | 5 |
| Czech_Republic | Plzeň | 1 |
| Czech_Republic | Prague | 15 |
| Czech_Republic | Prostějov | 1 |
| Czech_Republic | Sudoměřice_u_Bechyně | 1 |
| Czech_Republic | Tábor | 1 |
| Czech_Republic | Tetín | 1 |
| Denmark | Viborg | 1 |
| Ecuador | Guayaquil | 1 |
| Ecuador | Manta | 1 |
| Ecuador | Quito | 1 |
| Egypt | Cairo | 3 |
| Estonia | Tallinn | 4 |
| Ethiopia | Addis_Ababa | 1 |
| Finland | Helsinki | 4 |
| Finland | Kaustinen | 1 |
| Finland | Mikkeli | 1 |
| Finland | Siilinjärvi | 1 |
| France | Annecy | 1 |
| France | Arras | 1 |
| France | Aubagne | 1 |
| France | Besançon | 1 |
| France | Cannes | 1 |
| France | Chalon-sur-Saône | 1 |
| France | Charleville-Mézières | 1 |
| France | Guyancourt | 1 |
| France | Ivry-sur-Seine | 2 |
| France | La_Chapelle_Saint-Luc | 1 |
| France | Les_Arcs | 1 |
| France | Lille | 1 |
| France | Lyon | 2 |
| France | Marseille | 4 |
| France | Metz | 1 |
| France | Montpellier | 2 |
| France | Montreuil | 2 |
| France | Mulhouse | 1 |
| France | Nancy | 1 |
| France | Paris | 26 |
| France | Perpignan | 1 |
| France | Poitiers | 1 |
| France | Rennes | 1 |
| France | Saint-Erme-Outre-et-Ramecourt | 1 |
| France | Saint-Étienne | 1 |
| France | Sanary-sur-Mer | 1 |
| France | Sète | 1 |
| France | Strasbourg | 1 |
| France | Tinqueux | 5 |
| France | Toulouse | 2 |
| France | Villeurbanne | 1 |
| Georgia | Tbilisi | 1 |
| Germany | Badel | 1 |
| Germany | Baden-Baden | 1 |
| Germany | Berlin | 17 |
| Germany | Bochum | 1 |
| Germany | Braunschweig | 1 |
| Germany | Chemnitz | 1 |
| Germany | Cologne | 6 |
| Germany | Cottbus | 1 |
| Germany | Deutzen | 1 |
| Germany | Dresden | 5 |
| Germany | Düsseldorf | 2 |
| Germany | Essen | 2 |
| Germany | Frankfurt_am_Main | 4 |
| Germany | Freising | 1 |
| Germany | Gladbeck | 1 |
| Germany | Gotha | 1 |
| Germany | Halle_(Saale) | 1 |
| Germany | Hamburg | 3 |
| Germany | Hannover | 3 |
| Germany | Heidelberg | 1 |
| Germany | Holzminden | 1 |
| Germany | Ilmenau | 1 |
| Germany | Ingolstadt | 1 |
| Germany | Karlsruhe | 2 |
| Germany | Kiel | 1 |
| Germany | Langen | 1 |
| Germany | Lärz | 1 |
| Germany | Leipzig | 5 |
| Germany | Mannheim | 1 |
| Germany | Marseburg | 1 |
| Germany | Mülheim_an_der_Ruhr | 1 |
| Germany | Munich | 7 |
| Germany | Nürnberg | 1 |
| Germany | Oberhausen | 2 |
| Germany | Oldenburg | 1 |
| Germany | Osnabrück | 1 |
| Germany | Rostock | 1 |
| Germany | Schnaittach | 1 |
| Germany | Stuttgart | 3 |
| Germany | Villingen-Schwenningen | 1 |
| Germany | Wiesbaden | 1 |
| Germany | Witten | 1 |
| Germany | Würzburg | 1 |
| Ghana | Accra | 1 |
| Greece | Athens | 2 |
| Greece | Kilkis | 1 |
| Greece | Larissa | 1 |
| Greece | Thessaloniki | 2 |
| Greece | Xanthi | 1 |
| Greece | 1 | |
| Hungary | Budaörs | 1 |
| Hungary | Budapest | 16 |
| Hungary | Pécs | 1 |
| India | Bangalore | 2 |
| India | Chennai | 1 |
| India | Mumbai | 3 |
| India | New_Delhi | 1 |
| India | Panaji | 1 |
| Indonesia | Jakarta | 1 |
| Iran | Tehran | 1 |
| Ireland | Clifden | 1 |
| Ireland | Dublin | 6 |
| Ireland | Galway | 1 |
| Ireland | Limerick | 2 |
| Ireland | Newbridge | 1 |
| Israel | Haifa | 2 |
| Israel | Herzliya | 2 |
| Israel | Holon | 5 |
| Israel | Jerusalem | 2 |
| Israel | Nahariya | 1 |
| Israel | Rosh_Pina | 1 |
| Israel | Sderot | 1 |
| Israel | Shavei_Tzion | 1 |
| Israel | Tel_Aviv | 11 |
| Israel | Zikhron_Ya'akov | 1 |
| Italy | Amantea | 1 |
| Italy | Arezzo | 1 |
| Italy | Bari | 1 |
| Italy | Bologna | 2 |
| Italy | Brescia | 1 |
| Italy | Brunico | 1 |
| Italy | Cesena | 1 |
| Italy | Cremona | 1 |
| Italy | Florence | 2 |
| Italy | Gabicce_Mare | 1 |
| Italy | Gorizia/Gorica | 4 |
| Italy | La_Val | 1 |
| Italy | Milan | 1 |
| Italy | Naples | 1 |
| Italy | Ostia | 1 |
| Italy | Perugia | 1 |
| Italy | Pordenone | 1 |
| Italy | Prato | 1 |
| Italy | Rome | 7 |
| Italy | San_Michele_del_Carso/Vrh | 1 |
| Italy | San_Vito_dei_Normanni | 1 |
| Italy | Segrate | 1 |
| Italy | Staranzano | 1 |
| Italy | Trieste/Trst | 23 |
| Italy | Udine/Videm | 3 |
| Italy | Venice | 8 |
| Japan | Beppu | 1 |
| Japan | Fukushima | 1 |
| Japan | Kobe | 1 |
| Japan | Minamisōma | 1 |
| Japan | Osaka | 1 |
| Japan | Tokyo | 4 |
| Japan | Tsukuba | 1 |
| Kosovo | Peć | 1 |
| Kosovo | Pristina | 2 |
| Kosovo | Prizren | 1 |
| Latvia | Cēsis | 1 |
| Latvia | Riga | 2 |
| Lithuania | Druskininkai | 1 |
| Lithuania | Kaunas | 1 |
| Lithuania | Vilnius | 4 |
| Luxembourg | Luxembourg | 3 |
| Malta | Gozo | 1 |
| Malta | Valletta | 1 |
| Mexico | Guadalajara | 1 |
| Mexico | Mexico_City | 2 |
| Montenegro | Bar | 1 |
| Montenegro | Cetinje | 3 |
| Montenegro | Kotor | 2 |
| Montenegro | Mojkovac | 1 |
| Montenegro | Podgorica | 4 |
| Montenegro | Ulcinj | 1 |
| Netherlands | Amsterdam | 2 |
| Netherlands | Eindhoven | 3 |
| Netherlands | Enschede | 1 |
| Netherlands | Groningen | 1 |
| Netherlands | Midsland | 1 |
| Netherlands | Rotterdam | 1 |
| Nicaragua | Managua | 1 |
| North_Macedonia | Bitola | 3 |
| North_Macedonia | Kumanovo | 1 |
| North_Macedonia | Ohrid | 1 |
| North_Macedonia | Prilep | 1 |
| North_Macedonia | Radoviš | 1 |
| North_Macedonia | Resen | 1 |
| North_Macedonia | Skopje | 11 |
| North_Macedonia | Štip | 1 |
| North_Macedonia | Struga | 1 |
| North_Macedonia | Strumica | 1 |
| Norway | Bergen | 2 |
| Norway | Harstad | 1 |
| Norway | Oslo | 2 |
| Oman | Muscat | 1 |
| Paraguay | Asunción | 1 |
| Peru | Arequipa | 1 |
| Peru | Lima | 1 |
| Peru | Piura | 1 |
| Poland | Bielsko-Biała | 2 |
| Poland | Katowice | 1 |
| Poland | Kraków | 3 |
| Poland | Łomża | 1 |
| Poland | Lublin | 2 |
| Poland | Mikołów | 1 |
| Poland | Poznań | 1 |
| Poland | Warsaw | 4 |
| Poland | Wrocław | 2 |
| Portugal | Almada | 1 |
| Portugal | Cascais | 2 |
| Portugal | Lisbon | 2 |
| Portugal | Matosinhos | 1 |
| Portugal | Porto | 1 |
| Portugal | St._Maria_da_Feira | 1 |
| Romania | Bucharest | 9 |
| Romania | Giurgiu | 1 |
| Romania | Mediaș | 1 |
| Romania | Mogoşoaia | 1 |
| Romania | Sibiu | 1 |
| Russia | Irkutsk | 1 |
| Russia | Moscow | 7 |
| Russia | Omsk | 1 |
| Russia | Perm | 1 |
| Russia | Saint_Petersburg | 2 |
| Serbia | Belgrade | 32 |
| Serbia | Kragujevac | 3 |
| Serbia | Niš | 2 |
| Serbia | Novi_Sad | 7 |
| Serbia | Pančevo | 1 |
| Serbia | Smederevo | 1 |
| Serbia | Subotica | 2 |
| Serbia | Vršac | 1 |
| Serbia | Zemun | 1 |
| Singapore | Singapore | 3 |
| Slovakia | Banská_Bystrica | 2 |
| Slovakia | Bardejov | 2 |
| Slovakia | Bratislava | 11 |
| Slovakia | Košice | 5 |
| Slovakia | Kremnica | 1 |
| Slovakia | Nitra | 1 |
| Slovakia | Trenčín | 1 |
| Slovakia | Trnava | 1 |
| Slovakia | Žilina | 3 |
| South_Africa | Johannesburg | 1 |
| South_Korea | Busan | 1 |
| South_Korea | Gwacheon | 1 |
| South_Korea | Seoul | 2 |
| Spain | Alcalá_de_Henares | 1 |
| Spain | Barcelona | 2 |
| Spain | Getafe | 2 |
| Spain | Madrid | 13 |
| Spain | Sevilla | 1 |
| Spain | Valencia | 1 |
| Spain | Valladolid | 1 |
| Spain | Vic | 1 |
| Sri_Lanka | Colombo | 1 |
| Sweden | Gothenburg | 3 |
| Sweden | Stockholm | 2 |
| Sweden | Umeå | 2 |
| Switzerland | Basel | 8 |
| Switzerland | Bellinzona | 2 |
| Switzerland | Bern | 3 |
| Switzerland | Biel/Bienne | 1 |
| Switzerland | Chur | 2 |
| Switzerland | Geneva | 3 |
| Switzerland | Winterthur | 2 |
| Switzerland | Zürich | 5 |
| Turkey | Ankara | 1 |
| Turkey | Istanbul | 3 |
| Turkey | Izmir | 2 |
| Ukraine | Kharkiv | 2 |
| Ukraine | Kyiv | 2 |
| United_Arab_Emirates | Dubai | 1 |
| United_Kingdom | Aberdeen | 1 |
| United_Kingdom | Banchory | 1 |
| United_Kingdom | Belfast | 1 |
| United_Kingdom | Cardiff | 1 |
| United_Kingdom | East_Lothian | 1 |
| United_Kingdom | Ebrington | 1 |
| United_Kingdom | Findhorn | 1 |
| United_Kingdom | Glenrothes | 1 |
| United_Kingdom | Guildford | 1 |
| United_Kingdom | Isle_of_Mull | 1 |
| United_Kingdom | Liverpool | 2 |
| United_Kingdom | London | 31 |
| United_Kingdom | Manchester | 2 |
| United_Kingdom | Newcastle | 1 |
| United_Kingdom | North_Lanarkshire | 1 |
| United_Kingdom | Norwich | 1 |
| United_Kingdom | Nottingham | 1 |
| Uruguay | Montevideo | 1 |
| USA | Annapolis | 1 |
| USA | Bethlehem_(PA) | 1 |
| USA | Bristol | 1 |
| USA | Chicago | 1 |
| USA | Cleveland | 6 |
| USA | Emporia | 1 |
| USA | Franklin_(KS) | 1 |
| USA | Houston | 1 |
| USA | Huntsville | 1 |
| USA | Joliet | 1 |
| USA | Kansas_City | 1 |
| USA | Lancastre | 1 |
| USA | Los_Angeles | 2 |
| USA | Mason_City | 1 |
| USA | Milwaukee | 1 |
| USA | Minneapolis | 1 |
| USA | Munhall | 1 |
| USA | Nashville | 1 |
| USA | New_York | 13 |
| USA | North_Bethesda | 1 |
| USA | Orlando | 1 |
| USA | Park_City | 1 |
| USA | Riverside_(CA) | 1 |
| USA | Salisbury | 1 |
| USA | San_Francisco | 1 |
| USA | San_Jose | 1 |
| USA | Silver_Spring | 1 |
| USA | Washington | 10 |
| USA | Washington_D.C. | 1 |
| USA | Wilmington | 1 |
| USA | Youngstown | 1 |
