names

15 rows where case_id = 2328786

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4907079 2328786 2328786 plaintiff Penreth Thomas (legal representative)   Penreth, Thomas, executors of 0
4907080 2328786 2328786 plaintiff Penreth Agnes     (Penreth, Agnes 1
4907081 2328786 2328786 plaintiff Penreth John     Penreth, John 2
4907082 2328786 2328786 defendant Bennall Edward mariner 592959 592959 Bennall, Edward, of Plymmouth, Devon, mariner 0
4907083 2328786 2328786 defendant Mote John mariner 586834 586834 Mote, John, of Plymmouth, mariner 1
4907084 2328786 2328786 defendant Loselan John mariner 586834 586834 Loselan, John, of Plymmouth, mariner 2
4907085 2328786 2328786 defendant Button or Buccon Thomas mariner 586834 586834 Button or Buccon, Thomas, of Plymmouth, mariner 3
4907086 2328786 2328786 defendant Stanton henry mariner 586834 586834 Stanton, henry, of Plymmouth, mariner 4
4907087 2328786 2328786 defendant Manchestre John mercer 586834 586834 Manchestre, John, of Plymmouth, mercer 5
4907088 2328786 2328786 defendant Martyn Lawrence tailor 586834 586834 Martyn, Lawrence, of Plymmouth, tailor 6
4907089 2328786 2328786 defendant Yonge William mariner 820022 820022 Yonge, William, of Orwell, Suff, mariner 7
4907090 2328786 2328786 defendant Hedman John mariner 602396 602396 Hedman, John, of Orwell, mariner 8
4907091 2328786 2328786 defendant Richard Simon mariner 602396 602396 Richard, Simon, of Orwell, mariner 9
4907092 2328786 2328786 defendant Williamson John mariner 820023 820023 Williamson, John, of Shouth Shelys, Essex, mariner 10
4907093 2328786 2328786 defendant Oke John merchant 585925 585925 Oke, John, of Bristol, merchant 11

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