names

10 rows where case_id = 2421517

✎ 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
5219800 2421517 2421517 plaintiff Hilton Godfrey esq   Hilton, Godfrey, esq 0
5219801 2421517 2421517 defendant Darly Philip gent 675074 675074 Darly, Philip, of Grymesthorp, gent 0
5219802 2421517 2421517 defendant Vernon Edmund gent 675074 675074 Vernon, Edmund, of Grymesthorp, gent 1
5219803 2421517 2421517 defendant Bokwyth Thomas yeoman 675074 675074 Bokwyth, Thomas, of Grymesthorp, yeoman 2
5219804 2421517 2421517 defendant Atkok William yeoman 675074 675074 Atkok, William,of Grymesthorp, yeoman 3
5219805 2421517 2421517 defendant Taillour James tailor 598096 598096 Taillour, James, of Folkyngham, tailor 4
5219806 2421517 2421517 defendant Hornclyff Thomas   675074 675074 Hornclyff, Thomas, of Grymesthorp, groom 5
5219807 2421517 2421517 defendant Bell Robert   675074 675074 Bell, Robert, of Grymesthorp, servant 6
5219808 2421517 2421517 defendant Browederer John yeoman 675074 675074 Browederer, John, of Grymesthorp, yeoman 7
5219809 2421517 2421517 defendant Vernon Walter Edmund   675074 675074 Vernon, Walter Edmund, of Grymesthorp, servant 8

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