names

24 rows where place_id = 607387

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3669038 1916246 1916246 defendant Porter William yeoman 607387 607387 Porter, William, of Bexley, Kent, yeoman 1
3674406 1918040 1918040 defendant Shelley John gent 607387 607387 Shelley, John, of Bexley, Kent, gent 1
3687239 1922187 1922187 defendant Rawllens John gent 607387 607387 Rawllens, John, of Bexley, Kent, gent 3
3687244 1922188 1922188 defendant Rawllens John gent 607387 607387 Rawllens, John, of Bexley, Kent, gent 3
3748799 1941560 1941560 defendant Lanne John yeoman 607387 607387 Lanne, John, of Bexley, Kent, yeoman 0
3752481 1942700 1942700 defendant Rawlyns John gent 607387 607387 Rawlyns, John, of Bexley, Kent, gent 0
3763377 1946173 1946173 defendant Lane John yeoman 607387 607387 Lane, John, of Bexley, Kent, yeoman 1
3864208 1978219 1978219 defendant Shelley William esq 607387 607387 Shelley, William, of Bexley, Kent, esq 0
3911235 1994082 1994082 defendant Williams John gent 607387 607387 Williams, John, of Bexley, Kent, gent 0
3911242 1994083 1994083 defendant Wyllyamson John gent 607387 607387 Wyllyamson, John, of Bexley, Kent, gent 0
3929893 2000339 2000339 defendant Combes John yeoman 607387 607387 Combes, John, of Bexley, Kent, yeoman 0
3931905 2000973 2000973 defendant Combes John   607387 607387 Combes, John, of Bexley, Kent, ship wright 0
4262843 2117241 2117241 defendant Wyndes Mathew yeoman 607387 607387 Wyndes, Mathew, of Bexley, Kent, yeoman 0
4273517 2120697 2120697 defendant Wyndes Mathew yeoman 607387 607387 Wyndes, Mathew, of Bexley, Kent, yeoman 0
4288161 2125816 2125816 defendant Champneys Justinian esq 607387 607387 (Champneys, Justinian, of Bexley, Kent, esq 1
4305244 2131972 2131972 defendant Champneys Justinian esq 607387 607387 (Champneys, Justinian, of Bexley, Kent, esq 1
4308592 2133155 2133155 defendant Champnes Justinian esq 607387 607387 (Champnes, Justinian, of Bexley, Kent, esq 3
4310418 2133799 2133799 defendant Champnes Justinian esq 607387 607387 (Champnes, Justinian, of Bexley, Kent, esq 1
4323983 2138431 2138431 defendant Chempulesse Justinian esq 607387 607387 (Chempulesse, Justinian, of Bexley, Kent, esq 1
5071931 2378097 2378097 defendant Snelgare Richard   607387 607387 Snelgare, Richard, of Bexley, Kent, bailiff 0
5527811 2513267 2513267 defendant Bocher John butcher 607387 607387 Bocher, John, of Bexley, Kent, butcher 3
5561584 2523375 2523375 defendant Colyns Thomas husbandman 607387 607387 Colyns, Thomas, of Bexley, Kent, husbandman 0
5561590 2523376 2523376 defendant Breten Thomas husbandman 607387 607387 Breten, Thomas, of Bexley, Kent, husbandman 1
5593912 2533084 2533084 defendant Shelley John gent 607387 607387 Shelley, John, of Bexley, Kent, gent 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);