names

47 rows where place_id = 600203

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640157 1907366 1907366 defendant Garlond Richard gent 600203 600203 Garlond, Richard, of Totnes, gent 8
3692151 1923715 1923715 defendant Davy John gent 600203 600203 Davy, John, of Totnes, gent 1
3714200 1930740 1930740 defendant Pase Henry mercer 600203 600203 Pase, Henry, of Totnes, mercer 0
3783873 1952728 1952728 defendant Pase Henry mercer 600203 600203 Pase, Henry, of Totnes, mercer 0
3783874 1952728 1952728 defendant Hamerdon Richard hooper 600203 600203 Hamerdon, Richard, of Totnes, hooper 1
3931571 2000857 2000857 plaintiff Dowse Walter merchant 600203 600203 Dowse, Walter, of Totnes, merchant 0
3931573 2000858 2000858 plaintiff Dowse Walter merchant 600203 600203 Dowse, Walter, of Totnes, merchant 0
3946547 2005859 2005859 defendant Blackealler Christopher merchant 600203 600203 Blackealler, Christopher, of Totnes, merchant 0
3967225 2013166 2013166 plaintiff Buggyns Walter merchant 600203 600203 Buggyns, Walter, of Totnes, merchant 0
3967227 2013167 2013167 plaintiff Buggyns Walter merchant 600203 600203 Buggyns, Walter, of Totnes, merchant 0
3967229 2013168 2013168 plaintiff Buggyns Walter merchant 600203 600203 Buggyns, Walter, of Totnes, merchant 0
3975419 2015967 2015967 defendant Adams William chapman 600203 600203 Adams, William, of Totnes, chapman 2
3975423 2015968 2015968 defendant Adams William chapman 600203 600203 Adams, William, of Totnes, chapman 2
3979492 2017421 2017421 defendant Torryn William merchant 600203 600203 Torryn, William, of Totnes, merchant 0
4014135 2029785 2029785 plaintiff Savery Alan   600203 600203 Savery, Alan, of Totnes 0
4014488 2029907 2029907 plaintiff Seret Lucas merchant 600203 600203 Seret, Lucas, of Totnes, merchant 0
4014491 2029908 2029908 plaintiff Serrett Luke merchant 600203 600203 Serrett, Luke, of Totnes, merchant 0
4026821 2034241 2034241 plaintiff Carswill Henry merchant 600203 600203 Carswill, Henry, of Totnes, merchant 0
4039868 2038879 2038879 plaintiff Martyn Thomas   600203 600203 Martyn, Thomas, of Totnes 0
4061155 2046398 2046398 plaintiff Dowse Walter merchant 600203 600203 Dowse, Walter, of Totnes, merchant 0
4092625 2057671 2057671 defendant Collyns Tobias yeoman 600203 600203 Collyns, Tobias, of Totnes, yeoman 1
4141603 2075227 2075227 defendant Mortymer Richard, senior merchant 600203 600203 Mortymer, Richard, senior, of Totnes, merchant 0
4141604 2075227 2075227 defendant Mortymer Richard, junior   600203 600203 Mortymer, Richard, junior, of Totnes, merchant, his son 1
4143563 2075906 2075906 defendant Mortymer Richard merchant 600203 600203 Mortymer, Richard, of Totnes, merchant 0
4191894 2092725 2092725 defendant Mortymer Richard merchant 600203 600203 Mortymer, Richard, of Totnes, merchant 0
4204868 2097244 2097244 defendant Mortymer William yeoman 600203 600203 Mortymer, William, of Totnes, yeoman 1
4246330 2111749 2111749 defendant Pettye Nicholas glasier 600203 600203 Pettye, Nicholas, of Totnes, glasier 3
4247688 2112207 2112207 defendant Mortymer Richard merchant 600203 600203 Mortymer, Richard, of Totnes, merchant 0
4249442 2112798 2112798 defendant Nyle Robert butcher 600203 600203 Nyle, Robert, of Totnes, butcher 0
4249443 2112798 2112798 defendant Davye Peter husbandman 600203 600203 Davye, Peter, of Totnes, husbandman 1
4253742 2114244 2114244 defendant Haughton Anne widow 600203 600203 Haughton, Anne, of Totnes, widow 1
4298893 2129700 2129700 defendant Ferrys John weaver 600203 600203 Ferrys, John, of Totnes, weaver 0
4334187 2141712 2141712 defendant Treherne Thomas gent 600203 600203 Treherne, Thomas, of Totnes, gent 2
4355501 2149145 2149145 defendant Ulcott Alexander draper 600203 600203 Ulcott, Alexander, of Totnes, draper 1
4366970 2153239 2153239 defendant Mondy Robert merchant 600203 600203 Mondy, Robert, of Totnes, merchant 0
4366971 2153239 2153239 defendant Russell William merchant 600203 600203 Russell, William, of Totnes, merchant 1
4385168 2159727 2159727 defendant Everye Henry merchant 600203 600203 Everye, Henry, of Totnes, merchant 0
4395648 2163131 2163131 defendant Tom William merchant 600203 600203 Tom, William, of Totnes, merchant 0
4688858 2262069 2262069 defendant Kyng John butcher 600203 600203 Kyng, John, of Totnes, butcher 2
4694572 2263796 2263796 defendant Bastard Henry yeoman 600203 600203 Bastard, Henry, of Totnes, chaplain Symond, John, of Uggeburgh, yeoman 0
4823870 2303546 2303546 plaintiff Sutham John   600203 600203 Sutham, John, of Totnes, prior 0
4844824 2309905 2309905 defendant Bocher John yeoman 600203 600203 Bocher, John, of Totnes, yeoman 1
4893319 2324616 2324616 defendant Soper William baker 600203 600203 Soper, William, of Totnes, baker 2
5342534 2457865 2457865 defendant Kary Peter merchant 600203 600203 Kary, Peter, of Totnes, merchant 1
5386373 2471170 2471170 defendant Smale William butcher 600203 600203 Smale, William, of Totnes, butcher 0
5523804 2512266 2512266 defendant Shilston John (legal representative) 600203 600203 Shilston, John, of Totnes, gent, executrix of 1
5523805 2512266 2512266 defendant Shilston Joan widow 600203 600203 Shilston, Joan, of Totnes, widow 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);