names

11 rows where place_id = 626421

✎ 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
3770010 1948280 1948280 defendant Brytt Alexander gent 626421 626421 Brytt, Alexander, of Pylton, Devon, gent 0
4080992 2053518 2053518 defendant Punchard John yeoman 626421 626421 Punchard, John, of Pylton, Devon, yeoman 0
4182067 2089207 2089207 defendant Punchard William miller 626421 626421 Punchard, William, of Pylton, Devon, miller 0
4194438 2093604 2093604 defendant Williams Thomas yeoman 626421 626421 Williams, Thomas, of Pylton, Devon, yeoman 0
4307934 2132917 2132917 defendant Chaldon William miller 626421 626421 Chaldon, William, of Pylton, Devon, miller 0
4316704 2135960 2135960 defendant Darte John fuller 626421 626421 Darte, John, of Pylton, Devon, fuller 0
5060129 2374597 2374597 defendant Phelipp John yeoman 626421 626421 (Phelipp, John, of Pylton, Devon, yeoman 1
5060133 2374598 2374598 defendant Phelipp John yeoman 626421 626421 (Phelipp, John, of Pylton, Devon, yeoman 1
5241627 2427755 2427755 defendant Monke Thomas tucker 626421 626421 Monke, Thomas, of Pylton, Devon, tucker 0
5257168 2432377 2432377 defendant Chichester Richard esq 626421 626421 Chichester, Richard, of Pylton, Devon, esq 0
5373499 2467309 2467309 defendant Hyket John clerk 626421 626421 Hyket, John, of Pylton, Devon, clerk 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);