names

7 rows where case_id = 2478327

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5411254 2478327 2478327 plaintiff Cloos John   884808 884808 Cloos, John, of Chichester, dean of Holy Trinity Cathedral 0
5411255 2478327 2478327 defendant Hereward Edward gent 588550 588550 Hereward, Edward, of Erlyngton, gent 0
5411256 2478327 2478327 defendant Herward John gent 588550 588550 Herward, John, of Erlyngton, gent 1
5411257 2478327 2478327 defendant Tomber Henry yeoman 588550 588550 Tomber, Henry, of Erlyngton, yeoman 2
5411258 2478327 2478327 defendant Taillour Thomas yeoman 588550 588550 Taillour, Thomas, of Erlyngton, yeoman 3
5411259 2478327 2478327 defendant Godfrey John husbandman 588550 588550 Godfrey, John, of Erlyngton, husbandman 4
5411260 2478327 2478327 defendant Bukhorne John yeoman 588550 588550 Bukhorne, John, of Erlyngton, yeoman 5

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