names

38 rows where place_id = 593760

✎ 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
3613202 1871784 1871784 defendant Mercer William husbandman 593760 593760 Mercer, William, of Est Grynsted, husbandman 0
3627957 1903600 1903600 defendant Holman Thomas glover 593760 593760 Holman, Thomas, of Est Grynsted, glover 0
3632648 1905027 1905027 defendant Coole Richard husbandman 593760 593760 Coole, Richard, of Est Grynsted, husbandman 8
3632649 1905027 1905027 defendant Coole John laborer 593760 593760 Coole, John, of Est Grynsted, laborer 9
3812468 1961787 1961787 defendant Cocheford Thomas yeoman 593760 593760 Cocheford, Thomas, of Est Grynsted, yeoman 0
3812469 1961787 1961787 defendant Cole John, senior   593760 593760 Cole, John, senior, of Est Grynsted, laborer, son of Cole, Robert 1
3818807 1963790 1963790 defendant Yong Thomas husbandman 593760 593760 Yong, Thomas, of Est Grynsted, husbandman 0
3820322 1964232 1964232 defendant Elys William husbandman 593760 593760 Elys, William, of Est Grynsted, husbandman 0
3820323 1964232 1964232 defendant Weller Richard carpenter 593760 593760 Weller, Richard, of Est Grynsted, carpenter 1
3907619 1992840 1992840 plaintiff Payne Gregory (legal representative) 593760 593760 Payne, Gregory, of Est Grynsted, executors of 0
3909402 1993445 1993445 defendant Gellett John capper 593760 593760 Gellett, John, of Est Grynsted, capper 1
3916082 1995763 1995763 defendant Clerke John   593760 593760 Clerke, John, of Est Grynsted, surgeon 0
3956104 2009205 2009205 defendant Lullyngdon Thomas smith 593760 593760 Lullyngdon, Thomas, of Est Grynsted, smith 0
4043911 2040272 2040272 defendant Crippes Thomas yeoman 593760 593760 Crippes, Thomas, of Est Grynsted, yeoman 2
4170170 2085063 2085063 defendant Duffeld Thomas butcher 593760 593760 Duffeld, Thomas, of Est Grynsted, or of Horsted Keynes, butcher 0
4379461 2157736 2157736 defendant Mathye Edward drover 593760 593760 Mathye, Edward, of Est Grynsted, drover 0
5263742 2434413 2434413 plaintiff Boteler John   593760 593760 Boteler, John, of Est Grynsted 0
5272847 2437133 2437133 defendant Alfray John gent 593760 593760 Alfray, John, of East Grynsted, gent 0
5272848 2437133 2437133 defendant Alfray Richard gent 593760 593760 Alfray, Richard, of East Grynsted, gent 1
5383713 2470426 2470426 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5395505 2473794 2473794 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5395507 2473795 2473795 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5395545 2473806 2473806 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5415668 2479630 2479630 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5460634 2493126 2493126 defendant Alfray Peter gent 593760 593760 Alfray, Peter, of East Grynsted, gent 0
5477835 2498388 2498388 defendant Hasylden Andrew yeoman 593760 593760 Hasylden, Andrew, of Est Grynsted, yeoman 0
5477836 2498388 2498388 defendant Lorkyn Richard baker 593760 593760 Lorkyn, Richard, of Est Grynsted, baker 1
5477837 2498388 2498388 defendant Thomas John mercer 593760 593760 Thomas, John, of Est Grynsted, mercer 2
5504450 2506308 2506308 defendant Wody John, senior yeoman 593760 593760 Wody, John, senior, of Est Grynsted, yeoman 0
5504451 2506308 2506308 defendant Page Thomas yeoman 593760 593760 Page, Thomas, of Est Grynsted, yeoman 1
5521851 2511649 2511649 defendant Drewe Thomas yeoman 593760 593760 Drewe, Thomas, of Est Grynsted, yeoman 1
5534430 2515311 2515311 defendant Leukenore Richard, senior esq 593760 593760 Leukenore, Richard, senior, of Est Grynsted, or of Brambylty, esq 0
5556785 2521942 2521942 defendant Elys Robert yeoman 593760 593760 Elys, Robert, of Est Grynsted, yeoman 1
5556786 2521942 2521942 defendant Plawe John yeoman 593760 593760 Plawe, John, of Est Grynsted, yeoman 2
5556787 2521942 2521942 defendant Elys Thomas yeoman 593760 593760 Elys, Thomas, of Est Grynsted, yeoman 3
5567598 2525097 2525097 plaintiff Duffeld Henry yeoman 593760 593760 Duffeld, Henry, of Est Grynsted, yeoman 0
5567599 2525097 2525097 defendant Wody William, senior yeoman 593760 593760 Wody, William, senior, of Est Grynsted, yeoman 0
5604901 2536403 2536403 defendant Wody William husbandman 593760 593760 Wody, William, of Est Grynsted, husbandman 0

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