names

9 rows where place_id = 818626

✎ 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
4895683 2325324 2325324 defendant Blyke Richard gent 818626 818626 Blyke, Richard, of Bruggenorth, Salop, gent 2
4903635 2327752 2327752 defendant Blyke Richard gent 818626 818626 Blyke, Richard, of Bruggenorth, Salop, gent 2
4958320 2344455 2344455 defendant Bocher Roger butcher 818626 818626 Bocher, Roger, of Bruggenorth, Salop, butcher 2
4958326 2344456 2344456 defendant Bocher Roger butcher 818626 818626 Bocher, Roger, of Bruggenorth, Salop, butcher 2
5065024 2376070 2376070 defendant Yate John yeoman 818626 818626 Yate, John, of Bruggenorth, Salop, yeoman 0
5083639 2381610 2381610 defendant Barbour Hugh yeoman 818626 818626 Barbour, Hugh, of Bruggenorth, Salop, yeoman 12
5213816 2419769 2419769 defendant Styche Thomas gent 818626 818626 Styche, Thomas, of Bruggenorth, Salop, or of Hodnet, gent 1
5250383 2430234 2430234 defendant Horde Thomas esq 818626 818626 Horde, Thomas, of Bruggenorth, Salop, esq 0
5313983 2449204 2449204 defendant Smyth Thurstan chapman 818626 818626 Smyth, Thurstan, of Bruggenorth, Salop, chapman 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);