names

29 rows where place_id = 592582

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608167 1870209 1870209 defendant Lyon John yeoman 592582 592582 Lyon, John, of Colyton, Devon, yeoman 0
3828096 1966654 1966654 defendant Lechelond Nicholas mercer 592582 592582 Lechelond, Nicholas, of Colyton, Devon, mercer 0
3940777 2003923 2003923 plaintiff Strobridge John, junior (legal representative) 592582 592582 Strobridge, John, junior, of Colyton, Devon, merchant, executors of 0
3941292 2004092 2004092 defendant Kerswell John gent 592582 592582 Kerswell, John, of Colyton, Devon, gent 4
3943999 2005011 2005011 plaintiff Bagwell Peter yeoman 592582 592582 Bagwell, Peter, of Colyton, Devon, yeoman 0
4044175 2040369 2040369 defendant Strobrige George gent 592582 592582 Strobrige, George, of Colyton, Devon, gent 0
4050101 2042465 2042465 defendant Rede John tanner 592582 592582 Rede, John, of Colyton, Devon, tanner 0
4050103 2042466 2042466 defendant Rede John tanner 592582 592582 Rede, John, of Colyton, Devon, tanner 0
4086209 2055342 2055342 defendant Rawson Walter yeoman 592582 592582 Rawson, Walter, of Colyton, Devon, yeoman 0
4086213 2055344 2055344 defendant Rawlyn Walter yeoman 592582 592582 Rawlyn, Walter, of Colyton, Devon, yeoman 0
4088110 2056043 2056043 defendant Rawlyns Walter yeoman 592582 592582 Rawlyns, Walter, of Colyton, Devon, yeoman 3
4089601 2056571 2056571 defendant Rawlyn Walter yeoman 592582 592582 Rawlyn, Walter, of Colyton, Devon, clothier, yeoman 0
4089603 2056572 2056572 defendant Rawlyns Walter clothier 592582 592582 Rawlyns, Walter, of Colyton, Devon, clothier 0
4089621 2056579 2056579 defendant Rawlyns Peter merchant 592582 592582 Rawlyns, Peter, of Colyton, Devon, merchant 0
4111723 2064441 2064441 defendant Perryn alias Pussell Hugh gent 592582 592582 Perryn alias Pussell, Hugh, of Colyton, Devon, gent 2
4111726 2064442 2064442 defendant Quyntyn Henry chapman 592582 592582 Quyntyn, Henry, of Colyton, Devon, yeoman, chapman 0
4127322 2070064 2070064 defendant Marler John yeoman 592582 592582 Marler, John, of Colyton, Devon, yeoman 0
4151341 2078591 2078591 defendant Dassell Robert yeoman 592582 592582 Dassell, Robert, of Colyton, Devon, yeoman 0
4194952 2093797 2093797 defendant Carswell Francis gent 592582 592582 Carswell, Francis, of Colyton, Devon, gent 0
4231978 2106685 2106685 defendant Bagwell John husbandman 592582 592582 Bagwell, John, of Colyton, Devon, husbandman 0
4243383 2110779 2110779 defendant Tyrlyng Andrew gent 592582 592582 Tyrlyng, Andrew, of Colyton, Devon, gent 0
4288971 2126112 2126112 defendant Travers Ralph clerk 592582 592582 Travers, Ralph, of Colyton, Devon, clerk 0
4288973 2126113 2126113 defendant Travers Ralph clerk 592582 592582 Travers, Ralph, of Colyton, Devon, clerk 0
4301982 2130817 2130817 defendant Wideslade John husbandman 592582 592582 Wideslade, John, of Colyton, Devon, husbandman 0
4401832 2165209 2165209 defendant Hunt Nicholas merchant 592582 592582 Hunt, Nicholas, of Colyton, Devon, or of Lyme Regis, merchant 0
4695322 2264017 2264017 defendant Berneburgh John husbandman 592582 592582 Berneburgh, John, of Colyton, Devon, husbandman 4
4879036 2320372 2320372 defendant Hille alias Panter Richard yeoman 592582 592582 Hille alias Panter, Richard, of Colyton, Devon, yeoman 0
5219421 2421405 2421405 defendant Mylbery Robert yeoman 592582 592582 Mylbery, Robert, of Colyton, Devon, yeoman 3
5490447 2502037 2502037 defendant Waget William yeoman 592582 592582 Waget, William, of Colyton, Devon, yeoman 4

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);