names

10 rows where place_id = 682304

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4048988 2042082 2042082 defendant Oiesbye Christopher yeoman 682304 682304 Oiesbye, Christopher, of Wynthorp, Lincs, yeoman 0
4812488 2300018 2300018 defendant Redyng John gent 682304 682304 Redyng, John, of Wynthorp, Lincs, gent 3
5034806 2367035 2367035 defendant Waselhede William husbandman 682304 682304 (Waselhede, William, of Wynthorp, Lincs, husbandman 4
5156938 2403173 2403173 defendant Arlyrk John merchant 682304 682304 Arlyrk, John, of Wynthorp, Lincs, merchant 4
5172970 2407813 2407813 defendant Arlyk John merchant 682304 682304 Arlyk, John, of Wynthorp, Lincs, merchant 3
5172981 2407814 2407814 defendant Arlyrk John merchant 682304 682304 Arlyrk, John, of Wynthorp, Lincs, merchant 3
5207869 2418037 2418037 defendant Stephenson John merchant 682304 682304 Stephenson, John, of Wynthorp, Lincs, merchant 10
5221657 2422030 2422030 defendant Arlyk John merchant of the staple 682304 682304 Arlyk, John, of Wynthorp, Lincs, merchant of the staple 1
5286949 2441188 2441188 defendant Athelek John merchant 682304 682304 Athelek, John, of Wynthorp, Lincs, merchant 0
5299032 2444697 2444697 defendant Sherman John husbandman 682304 682304 Sherman, John, of Wynthorp, Lincs, 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);