User:Data Gamer/Cypriot Mayors/Nicosia Mayors

Mayor of Nicosia Municipality (Q12878858)

Some mayors were in office two or three non-continuous term. This is not showing in the list. The check can be done with query.

SELECT ?officeLabel ?item ?itemLabel ?itemDescription ?start ?end ?order ?predecessorLabel ?successorLabel ?ordernumber
{
  ?item p:P39 ?fc_stmt .
  ?fc_stmt ps:P39 ?office ; pq:P580 ?start  .
  values ?office { wd:Q12878858 }
  optional { ?fc_stmt pq:P582 ?end } 
  optional { ?fc_stmt pq:P1545 ?order 
    bind(if(strlen(str(?order))=1,concat("0",?order),?order) as  ?ordernumber)            
           }
  optional { ?fc_stmt  pq:P1365 ?predecessor }
  optional { ?fc_stmt  pq:P1366 ?successor}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
} order by ?ordernumber

Try it!

Manually update list

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

SELECT ?office ?item ?itemLabel ?itemDescription ?start ?end ?order ?predecessor ?successor {   ?item p:P39 ?fc_stmt .   ?fc_stmt ps:P39 ?office ; pq:P580 ?start  .   values ?office { wd:Q12878858 }   optional { ?fc_stmt pq:P582 ?end . }    optional { ?fc_stmt pq:P1545 ?order . bind(if(strlen(str(?order))=1,concat("0",?order),?order) as  ?ordernumber) }   optional { ?fc_stmt  pq:P1365 ?predecessor . }   optional { ?fc_stmt  pq:P1366 ?successor . } } order by ?start

Wikidata	?office	?start	?end	?order	?predecessor	?successor
Eleni Mavrou	Mayor of Nicosia Municipality	2007-01-01	2011-12-31	14	Michalis Zampelas	Konstantinos Yiorkadjis
Michalis Zampelas	Mayor of Nicosia Municipality	2001-01-01	2006-12-31	13	Lellos Demetriades	Eleni Mavrou
Odysseas Ioannides	Mayor of Nicosia Municipality	1964-01-01	1970-01-01	10	Georgios Spanos	Lellos Demetriades
Konstantinos Yiorkadjis	Mayor of Nicosia Municipality	2012-01-01 2017-01-01	2016-12-31	15	Eleni Mavrou
Ioannis Clerides	Mayor of Nicosia Municipality	1946-06-01	1949-05-31	7	Themistoklis Dervis	Themistoklis Dervis
Lellos Demetriades	Mayor of Nicosia Municipality	1971-12-01 1974-08-01 1986-01-01 1992-01-01 1997-01-01	1974-07-01 1986-05-31 1991-12-31 1996-12-31 2001-12-31	11	Odysseas Ioannides Christophoros Kythreotis	Christophoros Kythreotis Michalis Zampelas
Christophoros Kythreotis	Mayor of Nicosia Municipality	1974-08-01	1974-08-01	12	Lellos Demetriades	Lellos Demetriades
Georgios Spanos	Mayor of Nicosia Municipality	1960-01-01 1963-01-01	1962-01-01 1964-01-01	9	Diomidis Sketos	Odysseas Ioannides
Christodoulos Severis	Mayor of Nicosia Municipality	1882-11-15	1888-07-31	1		Achilleas Liasides
Achilleas Liasides	Mayor of Nicosia Municipality	1888-08-01 1911-04-01	1908-04-10 1924-01-02	2	Christodoulos Severis Mehmet Shevket Bey Podamialyzade	Mehmet Shevket Bey Podamialyzade Antonios Theodotou
Mehmet Shevket Bey Podamialyzade	Mayor of Nicosia Municipality	1908-04-11	1911-03-31	3	Achilleas Liasides	Achilleas Liasides
Antonios Theodotou	Mayor of Nicosia Municipality	1924-01-08	1926-03-31	4	Achilleas Liasides	Georgios Markides
Georgios Markides	Mayor of Nicosia Municipality	1926-04-06	1929-03-31	5	Antonios Theodotou	Themistoklis Dervis
Themistoklis Dervis	Mayor of Nicosia Municipality	1929-04-05 1949-06-01	1946-05-28 1959-12-18	6	Georgios Markides Ioannis Clerides	Ioannis Clerides Diomidis Sketos
Diomidis Sketos	Mayor of Nicosia Municipality	1959-01-01	1960-01-01	8	Themistoklis Dervis	Georgios Spanos

End of automatically generated list.