names

4 rows where place_id = 755920

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4432600 2174953 2174953 defendant Brut John le   755920 755920 Brut, John le, of Wogham 14
4754263 2281712 2281712 defendant Lokere Henry smith 755920 755920 Lokere, Henry, of Wogham, smith 1
4887446 2322913 2322913 defendant Loker Henry smith 755920 755920 Loker, Henry, of Wogham, smith 0
5089436 2383284 2383284 defendant Stonyng John laborer 755920 755920 Stonyng, John, of Wogham, laborer 0

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