names

34 rows where place_id = 590933

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602756 1868529 1868529 defendant Wenslowe John yeoman 590933 590933 Wenslowe, John, of Quene Camell, yeoman 0
3770775 1948547 1948547 defendant Browne John husbandman 590933 590933 Browne, John, of Quene Camell, husbandman 2
3866297 1978959 1978959 defendant Browne Thomas yeoman 590933 590933 Browne, Thomas, of Quene Camell, yeoman 2
3872931 1981161 1981161 defendant Pollard alias Powell John clothier 590933 590933 Pollard alias Powell, John, of Quene Camell, clothier 3
3877240 1982631 1982631 plaintiff Hocke Thomas baker 590933 590933 Hocke, Thomas, of Quene Camell, baker 0
3877241 1982631 1982631 plaintiff Pollwebbe John draper 590933 590933 Pollwebbe, John, of Quene Camell, draper 1
3877242 1982631 1982631 defendant Tunckys Thomas clerk 590933 590933 Tunckys, Thomas, of Quene Camell, clerk 0
3881687 1984122 1984122 defendant Moryce William, junior yeoman 590933 590933 Moryce, William, junior, of Quene Camell, yeoman 0
3890666 1987143 1987143 defendant Gibbes Richard yeoman 590933 590933 Gibbes, Richard, of Quene Camell, yeoman 1
3975721 2016068 2016068 defendant Gybbes Richard husbandman 590933 590933 Gybbes, Richard, of Quene Camell, husbandman 1
3975722 2016068 2016068 defendant Lundy alias Gylham John smith 590933 590933 Lundy alias Gylham, John, of Quene Camell, smith 2
4030390 2035522 2035522 defendant Sampson James husbandman 590933 590933 Sampson, James, of Quene Camell, husbandman 2
4042269 2039715 2039715 defendant Morrys Walter husbandman 590933 590933 Morrys, Walter, of Quene Camell, husbandman 0
4056237 2044616 2044616 defendant Gybbes Richard husbandman 590933 590933 Gybbes, Richard, of Quene Camell, husbandman 0
4115001 2065654 2065654 defendant Morris Richard weaver 590933 590933 Morris, Richard, of Quene Camell, weaver 1
4115002 2065654 2065654 defendant Morris John weaver 590933 590933 Morris, John, of Quene Camell, weaver 2
4130678 2071284 2071284 defendant Morris John yeoman 590933 590933 Morris, John, of Quene Camell, yeoman 1
4130679 2071284 2071284 defendant Morris William, junior yeoman 590933 590933 Morris, William, junior, of Quene Camell, yeoman 2
4181407 2088975 2088975 defendant Addames John, junior yeoman 590933 590933 Addames, John, junior, of Quene Camell, yeoman 1
4181408 2088975 2088975 defendant Morrys William, junior yeoman 590933 590933 Morrys, William, junior, of Quene Camell, yeoman 2
4181409 2088975 2088975 defendant Morrys Stephen yeoman 590933 590933 Morrys, Stephen, of Quene Camell, yeoman 3
4185593 2090466 2090466 defendant Gulley John husbandman 590933 590933 Gulley, John, of Quene Camell, husbandman 1
4201959 2096230 2096230 defendant Morrys John yeoman 590933 590933 Morrys, John, of Quene Camell, yeoman 0
4527578 2208903 2208903 defendant Skynnere Robert   590933 590933 Skynnere, Robert, of Quene Camell 0
4720632 2271786 2271786 plaintiff Brystowe Philip   590933 590933 Brystowe, Philip, of Quene Camell, vicar 0
4741812 2278099 2278099 plaintiff Bristowe Philip   590933 590933 Bristowe, Philip, of Quene Camell, vicar, on his own account 0
4811779 2299796 2299796 plaintiff Gilbert John merchant 590933 590933 Gilbert, John, of Quene Camell, merchant 0
4811781 2299797 2299797 plaintiff Gilbert John merchant 590933 590933 Gilbert, John, of Quene Camell, merchant, on his own account 0
4968101 2347407 2347407 defendant Lane Thomas husbandman 590933 590933 Lane, Thomas, of Quene Camell, husbandman 0
4995535 2355505 2355505 plaintiff Gilbert John merchant 590933 590933 Gilbert, John, of Quene Camell, merchant 0
5109603 2389240 2389240 plaintiff Gilbert John (legal representative) 590933 590933 Gilbert, John, of Quene Camell, executors of 0
5245889 2428959 2428959 defendant Wynd Thomas tucker 590933 590933 Wynd, Thomas, of Quene Camell, tucker 1
5245890 2428959 2428959 defendant Barbour Roger husbandman 590933 590933 Barbour, Roger, of Quene Camell, husbandman 2
5245891 2428959 2428959 defendant Jope William husbandman 590933 590933 Jope, William, of Quene Camell, husbandman 3

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