legislators

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

Custom SQL query returning 10 rows (hide)

This data as json, copyable, CSV

idnametermsnum_terms
A000001 Fred Aandahl 
[
    {
        "type": "rep",
        "state": "ND",
        "start": "1951-01-03",
        "end": "1953-01-03",
        "party": "Republican"
    }
]
 1
A000002 Watkins Abbitt 
[
    {
        "type": "rep",
        "state": "VA",
        "start": "1947-01-03",
        "end": "1949-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1949-01-03",
        "end": "1951-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1951-01-03",
        "end": "1953-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1953-01-03",
        "end": "1955-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1955-01-05",
        "end": "1957-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1957-01-03",
        "end": "1959-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1959-01-07",
        "end": "1961-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1961-01-03",
        "end": "1963-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1963-01-09",
        "end": "1965-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1965-01-04",
        "end": "1967-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1967-01-10",
        "end": "1969-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1969-01-03",
        "end": "1971-01-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "VA",
        "start": "1971-01-21",
        "end": "1973-01-03",
        "party": "Democrat"
    }
]
 13
A000003 Joel Abbott 
[
    {
        "type": "rep",
        "state": "GA",
        "start": "1817-12-01",
        "end": "1819-03-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "GA",
        "start": "1819-12-06",
        "end": "1821-03-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "GA",
        "start": "1821-12-03",
        "end": "1823-03-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "GA",
        "start": "1823-12-01",
        "end": "1825-03-03",
        "party": "Republican"
    }
]
 4
A000004 Amos Abbott 
[
    {
        "type": "rep",
        "state": "MA",
        "start": "1843-12-04",
        "end": "1845-03-03",
        "party": "Whig"
    },
    {
        "type": "rep",
        "state": "MA",
        "start": "1845-12-01",
        "end": "1847-03-03",
        "party": "Whig"
    },
    {
        "type": "rep",
        "state": "MA",
        "start": "1847-12-06",
        "end": "1849-03-03",
        "party": "Whig"
    }
]
 3
A000005 Jo Abbott 
[
    {
        "type": "rep",
        "state": "TX",
        "start": "1887-12-05",
        "end": "1889-03-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "TX",
        "start": "1889-12-02",
        "end": "1891-03-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "TX",
        "start": "1891-12-07",
        "end": "1893-03-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "TX",
        "start": "1893-08-07",
        "end": "1895-03-03",
        "party": "Democrat"
    },
    {
        "type": "rep",
        "state": "TX",
        "start": "1895-12-02",
        "end": "1897-03-03",
        "party": "Democrat"
    }
]
 5
A000006 Joseph Abbott 
[
    {
        "type": "sen",
        "state": "NC",
        "start": "1868-01-01",
        "end": "1871-03-03",
        "party": "Republican"
    }
]
 1
A000007 Josiah Abbott 
[
    {
        "type": "rep",
        "state": "MA",
        "start": "1875-12-06",
        "end": "1877-03-03",
        "party": "Democrat"
    }
]
 1
A000008 Nehemiah Abbott 
[
    {
        "type": "rep",
        "state": "ME",
        "start": "1857-12-07",
        "end": "1859-03-03",
        "party": "Republican"
    }
]
 1
A000009 James Abdnor 
[
    {
        "type": "rep",
        "state": "SD",
        "start": "1973-01-03",
        "end": "1975-01-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "SD",
        "start": "1975-01-14",
        "end": "1977-01-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "SD",
        "start": "1977-01-04",
        "end": "1979-01-03",
        "party": "Republican"
    },
    {
        "type": "rep",
        "state": "SD",
        "start": "1979-01-15",
        "end": "1981-01-03",
        "party": "Republican"
    },
    {
        "type": "sen",
        "state": "SD",
        "start": "1981-01-05",
        "end": "1987-01-03",
        "party": "Republican"
    }
]
 5
A000010 Hazel Abel 
[
    {
        "type": "sen",
        "state": "NE",
        "start": "1954-01-01",
        "end": "1955-01-03",
        "party": "Republican"
    }
]
 1