Description: A listing of past presidents and mayors in the village of Cleveland.
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,e5.eventdate as eventdate5,e5.info as info5,birthdate,deathdate, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e5 ON tng_people.personID = e5.persfamID AND tng_people.gedcom = e5.gedcom AND e5.eventtypeID = "5" WHERE ((e5.info LIKE "%Cleveland Village President%" OR e5.info LIKE "%Cleveland Village Mayor%") AND ((tng_people.living !=1 && tng_people.private != 1))) AND tng_people.gedcom = "CHSTree01" ORDER BY e5.eventdate,lastname,firstname,CAST(SUBSTRING(tng_people.personID,2) as UNSIGNED)
Matches 1 to 33 of 33 » Comma-delimited CSV file
# | Last Name, Given Name(s) | Occupation: Date | Occupation | Birth Date | Death Date | Person ID |
1 | Foster, William H. | 1857-1858 | Cleveland Village President | 27 Dec 1813 | 25 Jul 1893 | I41 |
2 | Sperry, Walter D. | 1859 | Cleveland Village President | Abt. 1815 | I1607 | |
3 | Foster, William H. | 1860 | Cleveland Village President | 27 Dec 1813 | 25 Jul 1893 | I41 |
4 | Duncan, Seth P. | 1861 | Cleveland Village President | Abt. 1818 | I440 | |
5 | Sanders, Lucian J. | 1862 | Cleveland Village President | 1836 | 12 Jun 1863 | I1608 |
6 | Kathern, Charles | 1863 | Cleveland Village President | Abt. 1803 | 7 Jul 1884 | I598 |
7 | Caswell, Henry Jay | 1864 | Cleveland Village President | Abt. 1829 | I859 | |
8 | Duncan, Seth P. | 1865 - 1866 | Cleveland Village President | Abt. 1818 | I440 | |
9 | Chisholm, Archibald Scott | 1867 - 1868 | Cleveland Village President | 25 Aug 1828 | 10 Apr 1874 | I1610 |
10 | Getman, Crawford | 1869 - 1870 | Cleveland Village President | 23 Jan 1834 | 28 Nov 1917 | I1110 |
11 | Foster, William H. | 1871 | Cleveland Village President | 27 Dec 1813 | 25 Jul 1893 | I41 |
12 | Chisholm, Archibald Scott | 1872 | Cleveland Village President | 25 Aug 1828 | 10 Apr 1874 | I1610 |
13 | Lane, Giles Willlard | 1873 | Cleveland Village President | 25 Nov 1820 | 26 Apr 1878 | I733 |
14 | Caswell, Henry Jay | 1874 | Cleveland Village President | Abt. 1829 | I859 | |
15 | Foster, William Henry Jr. | 1875 | Cleveland Village President | 21 Sep 1842 | 29 Aug 1887 | I46 |
16 | Caswell, Henry Jay | 1876 | Cleveland Village President | Abt. 1829 | I859 | |
17 | Harding, George | 1877 | Cleveland Village President | 6 Aug 1831 | 16 Nov 1893 | I450 |
18 | Yale, Albert A. | 1878 | Cleveland Village President | Sep 1834 | I379 | |
19 | Sherman, Edward | 1878 - 1880 | Cleveland Village President | 10 Jun 1807 | Abt. 1907 | I464 |
20 | Foster, William Henry Jr. | 1879 | Cleveland Village President | 21 Sep 1842 | 29 Aug 1887 | I46 |
21 | Wilder, Daniel L. | 1880 - 1881 | Cleveland Village President | Abt. 1837 - 1842 | I389 | |
22 | Duncan, Seth P. | 1882 | Cleveland Village President | Abt. 1818 | I440 | |
23 | Getman, Oliver | 1883 | Cleveland Village President | I1612 | ||
24 | Wilder, Daniel L. | 1884 - 1885 | Cleveland Village President | Abt. 1837 - 1842 | I389 | |
25 | Getman, Oliver | 1886 | Cleveland Village President | I1612 | ||
26 | Kime, John Philip | 1887 - 1888 | Cleveland Village President | 23 May 1854 | 23 Feb 1934 | I646 |
27 | Morenus, Granville W. | 1889 | Cleveland Village President | 7 Jun 1856 | 5 Mar 1926 | I612 |
28 | Nickerson, Isaac T. | 1890 - 1891 | Cleveland Village President | 24 Aug 1930 | I1551 | |
29 | Getman, Crawford | 1892 | Cleveland Village President | 23 Jan 1834 | 28 Nov 1917 | I1110 |
30 | Morenus, Charles W. | 1893 | Cleveland Village President | Jun 1851 | Nov 1921 | I1200 |
31 | Conterman, Dr. William Henry | 1894 | Cleveland Village President | 20 Feb 1862 | 19 Jan 1929 | I1613 |
32 | Dunham, Frederick O. | 1933 | Cleveland Village Mayor | 1867 | 1 Feb 1939 | I2342 |
33 | Fitzpatrick, William V. | 1934 - 1935 | Cleveland Village Mayor | 1884 | 1959 | I1630 |