names

8 rows where case_id = 2420709

✎ 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
5216983 2420709 2420709 plaintiff Dyve Maud widow of Dyve, Edmund, esq   Dyve, Maud, widow of Dyve, Edmund, esq 0
5216984 2420709 2420709 defendant Merston Richard gent 592690 592690 Merston, Richard, of Shefford, gent 0
5216985 2420709 2420709 defendant Valette John husbandman 778127 778127 Valette, John, of Merston Morteyn, husbandman 1
5216986 2420709 2420709 defendant Odehill Robert husbandman 778127 778127 Odehill, Robert, of Merston Morteyn, husbandman 2
5216987 2420709 2420709 defendant Bodymede Thomas husbandman 778127 778127 Bodymede, Thomas, of Merston Morteyn, husbandman 3
5216988 2420709 2420709 defendant Bodymede John husbandman 778127 778127 Bodymede, John, of Merston Morteyn, husbandman 4
5216989 2420709 2420709 defendant Idehill John husbandman 778127 778127 Idehill, John, of Merston Morteyn, husbandman 5
5216990 2420709 2420709 defendant Frankeleyn John husbandman 778127 778127 Frankeleyn, John, of Merston Morteyn, husbandman 6

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