names

7 rows where place_id = 780415

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4667855 2255649 2255649 defendant Iveson Richard yeoman 780415 780415 Iveson, Richard, of Kyghlay, yeoman 0
4667856 2255649 2255649 defendant Holgate Richard yeoman 780415 780415 Holgate, Richard, of Kyghlay, yeoman 1
4887603 2322959 2322959 defendant de Kyghlay Lawrence gent 780415 780415 de Kyghlay, Lawrence, of Kyghlay, gent 14
4887604 2322959 2322959 defendant de Gill Richard laborer 780415 780415 de Gill, Richard, of Kyghlay, laborer 15
5188408 2412324 2412324 defendant Wolhous William yeoman 780415 780415 Wolhous, William, of Kyghlay, yeoman 5
5566154 2524697 2524697 defendant Brig John yeoman 780415 780415 Brig, John, of Kyghlay, yeoman 1
5566156 2524697 2524697 defendant Widhope John yeoman 780415 780415 Widhope, John, of Kyghlay, yeoman 3

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