executive_terms

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

29 rows where start starts with "18" and type = "prez"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: party, how, executive_id, start (date), end (date)

Link rowid ▼ type start end party how executive_id
7 7 prez 1801-03-04 1805-03-04 Democratic-Republican election Thomas Jefferson 3
8 8 prez 1805-03-04 1809-03-04 Democratic-Republican election Thomas Jefferson 3
13 13 prez 1809-03-04 1813-03-04 Democratic-Republican election James Madison 7
14 14 prez 1813-03-04 1817-03-04 Democratic-Republican election James Madison 7
17 17 prez 1817-03-04 1821-03-05 Democratic-Republican election James Monroe 9
18 18 prez 1821-03-05 1825-03-04 Democratic-Republican election James Monroe 9
19 19 prez 1825-03-04 1829-03-04 Democratic-Republican election John Adams 10
22 22 prez 1829-03-04 1833-03-04 Democratic election Andrew Jackson 12
23 23 prez 1833-03-04 1837-03-04 Democratic election Andrew Jackson 12
26 26 prez 1837-03-04 1841-03-04 Democratic election Martin Van Buren 14
27 27 prez 1841-03-04 1841-04-04 Whig election William Harrison 15
29 29 prez 1841-04-04 1845-03-04 Whig succession John Tyler 16
31 31 prez 1845-03-04 1849-03-04 Democratic election James Polk 18
32 32 prez 1849-03-04 1850-07-09 Whig election Zachary Taylor 19
34 34 prez 1850-07-09 1853-03-04 Whig succession Millard Fillmore 20
36 36 prez 1853-03-04 1857-03-04 Democratic election Franklin Pierce 22
38 38 prez 1857-03-04 1861-03-04 Democratic election James Buchanan 24
40 40 prez 1861-03-04 1865-03-04 Republican election Abraham Lincoln 26
41 41 prez 1865-03-04 1865-04-15 Republican election Abraham Lincoln 26
43 43 prez 1865-04-15 1869-03-04 Democratic succession Andrew Johnson 27
46 46 prez 1869-03-04 1873-03-04 Republican election Ulysses Grant 30
47 47 prez 1873-03-04 1877-03-04 Republican election Ulysses Grant 30
49 49 prez 1877-03-04 1881-03-04 Republican election Rutherford Hayes 32
50 50 prez 1881-03-04 1881-09-19 Republican election James Garfield 33
52 52 prez 1881-09-19 1885-03-04 Republican succession Chester Arthur 34
55 55 prez 1889-03-04 1893-03-04 Republican election Benjamin Harrison 37
57 57 prez 1885-03-04 1889-03-04 Democratic election Grover Cleveland 39
58 58 prez 1893-03-04 1897-03-04 Democratic election Grover Cleveland 39
60 60 prez 1897-03-04 1901-03-04 Republican election William McKinley 41

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [executive_terms] (
   [type] TEXT,
   [start] TEXT,
   [end] TEXT,
   [party] TEXT,
   [how] TEXT,
   [executive_id] INTEGER REFERENCES [executives]([id])
);