names

30 rows where place_id = 619411

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3729817 1935582 1935582 defendant Jakson Robert butcher 619411 619411 Jakson, Robert, of Assheborne, butcher 0
3729818 1935582 1935582 defendant Brydon John laborer 619411 619411 Brydon, John, of Assheborne, laborer 1
3729819 1935582 1935582 defendant Bradley Nicholas laborer 619411 619411 Bradley, Nicholas, of Assheborne, laborer 2
3736477 1937657 1937657 defendant Derby Nicholas glover 619411 619411 Derby, Nicholas, of Assheborne, glover 0
3736478 1937657 1937657 defendant Moseley James yeoman 619411 619411 Moseley, James, of Assheborne, yeoman 1
3736479 1937657 1937657 defendant Calver Richard shoemaker 619411 619411 Calver, Richard, of Assheborne, shoemaker 2
3736481 1937657 1937657 defendant Bolfeld William laborer 619411 619411 Bolfeld, William, of Assheborne, laborer 4
3772537 1949100 1949100 defendant Hobyns Thomas glover 619411 619411 Hobyns, Thomas, of Assheborne, glover 3
3785421 1953228 1953228 defendant Hollyns Thomas glover 619411 619411 Hollyns, Thomas, of Assheborne, glover 0
3834307 1968672 1968672 defendant Leeche Robert gent 619411 619411 Leeche, Robert, of Assheborne, gent 6
3836786 1969405 1969405 defendant Mylnys Robert baker 619411 619411 Mylnys, Robert, of Assheborne, baker 0
3852828 1974492 1974492 defendant Mylnes Robert baker 619411 619411 Mylnes, Robert, of Assheborne, baker 0
3890834 1987203 1987203 plaintiff Jackysson Roger butcher 619411 619411 Jackysson, Roger, of Assheborne, butcher 0
3911869 1994295 1994295 defendant Tomlynson alias North Henry butcher 619411 619411 Tomlynson alias North, Henry, of Assheborne, butcher 0
3938079 2003071 2003071 defendant Asshenhurst John husbandman 619411 619411 Asshenhurst, John, of Assheborne, husbandman 0
3938085 2003072 2003072 defendant Asshenherst John husbandman 619411 619411 Asshenherst, John, of Assheborne, husbandman 0
3940720 2003902 2003902 defendant Robynson Thomas yeoman 619411 619411 Robynson, Thomas, of Assheborne, yeoman 1
4062371 2046828 2046828 defendant Bestowe John chapman 619411 619411 Bestowe, John, of Assheborne, chapman 2
4080432 2053312 2053312 defendant Pereson James yeoman 619411 619411 Pereson, James, of Assheborne, yeoman 0
4104518 2061897 2061897 defendant Bagshawe William shoemaker 619411 619411 Bagshawe, William, of Assheborne, shoemaker 0
4111819 2064477 2064477 defendant Carter Mathew weaver 619411 619411 Carter, Mathew, of Assheborne, weaver 2
4111827 2064481 2064481 defendant Northe Thomas husbandman 619411 619411 Northe, Thomas, of Assheborne, husbandman 0
4816413 2301227 2301227 defendant Aleyn John yeoman 619411 619411 Aleyn, John, of Assheborne, yeoman 3
4816432 2301231 2301231 defendant Dunbabyn John gent 619411 619411 Dunbabyn, John, of Assheborne, gent 2
4843019 2309355 2309355 defendant Dunbaben John gent 619411 619411 Dunbaben, John, of Assheborne, gent 0
4843028 2309356 2309356 defendant Dunbaben John gent 619411 619411 Dunbaben, John, of Assheborne, gent 1
4843029 2309356 2309356 defendant Baker John baker 619411 619411 Baker, John, of Assheborne, baker 2
4975977 2349780 2349780 defendant Derby John cordwainer 619411 619411 Derby, John, of Assheborne, cordwainer 0
4975978 2349780 2349780 defendant Gudale John weaver 619411 619411 Gudale, John, of Assheborne, weaver 1
5016251 2361640 2361640 defendant Cokeyn John esq 619411 619411 Cokeyn, John, of Assheborne, esq 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);