names

16 rows where case_id = 2081573

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4160017 2081573 2081573 plaintiff Raphe John clerk   Raphe, John, clerk 0
4160018 2081573 2081573 defendant Peers Thomas yeoman 603621 603621 Peers, Thomas, of Helston, yeoman 0
4160019 2081573 2081573 defendant John Richard yeoman 603621 603621 John, Richard, of Helston, yeoman 1
4160020 2081573 2081573 defendant Studwell Stephen yeoman 603621 603621 Studwell, Stephen, of Helston, yeoman 2
4160021 2081573 2081573 defendant James Thomas yeoman 603621 603621 James, Thomas, of Helston, yeoman 3
4160022 2081573 2081573 defendant Trelace Nicholas yeoman 603621 603621 Trelace, Nicholas, of Helston, yeoman 4
4160023 2081573 2081573 defendant Peers alias Richarde John yeoman 603621 603621 Peers alias Richarde, John, of Helston, yeoman 5
4160024 2081573 2081573 defendant Peers henry yeoman 603621 603621 Peers, henry, of Helston, yeoman 6
4160025 2081573 2081573 defendant Pasmore Robert yeoman 603621 603621 Pasmore, Robert, of Helston, yeoman 7
4160026 2081573 2081573 defendant Penhalnrecke Peter yeoman 603621 603621 Penhalnrecke, Peter, of Helston, yeoman 8
4160027 2081573 2081573 defendant Penhelicke John yeoman 603621 603621 Penhelicke, John, of Helston, yeoman 9
4160028 2081573 2081573 defendant Steman William yeoman 603621 603621 Steman, William, of Helston, yeoman 10
4160029 2081573 2081573 defendant Stephyn Isaac yeoman 603621 603621 Stephyn, Isaac, of Helston, yeoman 11
4160030 2081573 2081573 defendant Bryan John yeoman 603621 603621 Bryan, John, of Helston, yeoman 12
4160031 2081573 2081573 defendant Caron Robert yeoman 603621 603621 Caron, Robert, of Helston, yeoman 13
4160032 2081573 2081573 defendant James alias Wolcocke John yeoman 603621 603621 James alias Wolcocke, John, of Helston, yeoman 14

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