names

7 rows where case_id = 2397897

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5138986 2397897 2397897 plaintiff Schut alias Shitte alias Bowden Thomas (legal representative) 851813 851813 Schut alias Shitte alias Bowden, Thomas, of Haverbergh or Market Harborough, wool man, executors of 0
5138987 2397897 2397897 plaintiff Schut Margaret formerly wife of Testator   (Schut Margaret, formerly wife of Testator 1
5138988 2397897 2397897 plaintiff Bowdon alias Shitte Richard, son of Thomas   Bowdon, alias Shitte, Richard, son of Thomas 2
5138989 2397897 2397897 defendant Page John   755065 755065 Page, John, of Haverbergh, fish monger 0
5138990 2397897 2397897 defendant Lyche Nicholas husbandman 783291 783291 (Lyche, Nicholas, of Flore, Nhants, husbandman 1
5138991 2397897 2397897 defendant Mannyng Margeret widow, formerly wife of Thomas Mannyng, of Pedyngton, Nhants   Mannyng, Margeret, widow, formerly wife of Thomas Mannyng, of Pedyngton, Nhants 2
5138992 2397897 2397897 defendant Mann John husbandman 589181 589181 Mann, John, of Pedyngton, husbandman 3

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