query
RESULTSET
query
  PRESIDENT TERMEND TERMSTART YEARLIST
1 George Washington March 4, 1797 April 30, 1789 1789,1790,1791,1792,1793,1794,1795,1796
2 John Adams March 4, 1801 March 4, 1797 1797,1798,1799,1800
3 Thomas Jefferson March 4, 1809 March 4, 1801 1801,1802,1803,1804,1805,1806,1807,1808
4 James Madison March 4, 1817 March 4, 1809 1809,1810,1811,1812,1813,1814,1815,1816
5 James Monroe March 4, 1825 March 4, 1817 1817,1818,1819,1820,1821,1822,1823,1824
6 John Quincy Adams March 4, 1829 March 4, 1825 1825,1826,1827,1828
7 Andrew Jackson March 4, 1837 March 4, 1829 1829,1830,1831,1832,1833,1834,1835,1836
8 Martin Van Buren March 4, 1841 March 4, 1837 1837,1838,1839,1840
9 William Henry Harrison April 4, 1841 March 4, 1841 [empty string]
10 John Tyler March 4, 1845 April 4, 1841 1841,1842,1843,1844
11 James K. Polk March 4, 1849 March 4, 1845 1845,1846,1847,1848
12 Zachary Taylor July 9, 1850 March 4, 1849 1849,1850
13 Millard Fillmore March 4, 1853 July 9, 1850 1851,1852
14 Franklin Pierce March 4, 1857 March 4, 1853 1853,1854,1855,1856
15 James Buchanan March 4, 1861 March 4, 1857 1857,1858,1859,1860
16 Abraham Lincoln April 15, 1865 March 4, 1861 1861,1862,1863,1864
17 Andrew Johnson March 4, 1869 April 15, 1865 1865,1866,1867,1868
18 Ulysses S. Grant March 4, 1877 March 4, 1869 1869,1870,1871,1872,1873,1874,1875,1876
19 Rutherford B. Hayes March 4, 1881 March 4, 1877 1877,1878,1879,1880
20 James A. Garfield September 19, 1881 March 4, 1881 1881
21 Chester A. Arthur March 4, 1885 September 19, 1881 1882,1883,1884
22 Grover Cleveland March 4, 1889 March 4, 1885 1885,1886,1887,1888
23 Benjamin Harrison March 4, 1893 March 4, 1889 1889,1890,1891,1892
24 Grover Cleveland March 4, 1897 March 4, 1893 1893,1894,1895,1896
25 William McKinley September 14, 1901 March 4, 1897 1897,1898,1899,1900,1901
26 Theodore Roosevelt March 4, 1909 September 14, 1901 1902,1903,1904,1905,1906,1907,1908
27 William Howard Taft March 4, 1913 March 4, 1909 1909,1910,1911,1912
28 Woodrow Wilson March 4, 1921 March 4, 1913 1913,1914,1915,1916,1917,1918,1919,1920
29 Warren G. Harding August 2, 1923 March 4, 1921 1921,1922,1923
30 Calvin Coolidge March 4, 1929 August 2, 1923 1924,1925,1926,1927,1928
31 Herbert Hoover March 4, 1933 March 4, 1929 1929,1930,1931,1932
32 Franklin D. Roosevelt April 12, 1945 March 4, 1933 1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944
33 Harry S. Truman January 20, 1953 April 12, 1945 1945,1946,1947,1948,1949,1950,1951,1952
34 Dwight D. Eisenhower January 20, 1961 January 20, 1953 1953,1954,1955,1956,1957,1958,1959,1960
35 John F. Kennedy November 22, 1963 January 20, 1961 1961,1962,1963
36 Lyndon B. Johnson January 20, 1969 November 22, 1963 1964,1965,1966,1967,1968
37 Richard Nixon August 9, 1974 January 20, 1969 1969,1970,1971,1972,1973,1974
38 Gerald Ford January 20, 1977 August 9, 1974 1975,1976
39 Jimmy Carter January 20, 1981 January 20, 1977 1977,1978,1979,1980
40 Ronald Reagan January 20, 1989 January 20, 1981 1981,1982,1983,1984,1985,1986,1987,1988
41 George H. W. Bush January 20, 1993 January 20, 1989 1989,1990,1991,1992
42 Bill Clinton January 20, 2001 January 20, 1993 1993,1994,1995,1996,1997,1998,1999,2000
43 George W. Bush January 20, 2009 January 20, 2001 2001,2002,2003,2004,2005,2006,2007,2008
44 Barack Obama January 20, 2017 January 20, 2009 2009,2010,2011,2012,2013,2014,2015,2016
45 Donald Trump [empty string] January 20, 2017 2017,2018
CACHED false
EXECUTIONTIME 71
SQL SELECT President, TermStart, TermEnd, YearList FROM us_presidents