names

13 rows where place_id = 590612

✎ 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
3601783 1868215 1868215 defendant Wastell Richard (legal representative) 590612 590612 Wastell, Richard, of Brydbroke, executor of 1
3601787 1868216 1868216 defendant Wastell Richard (legal representative) 590612 590612 Wastell, Richard, of Brydbroke, executor of 1
3601790 1868217 1868217 defendant Bocher William husbandman 590612 590612 Bocher, William, of Brydbroke, husbandman 0
4801470 2296641 2296641 defendant Clerk Edmund smith 590612 590612 Clerk, Edmund, of Brydbroke, smith 0
5016615 2361753 2361753 defendant Crapenell John husbandman 590612 590612 (Crapenell, John, of Brydbroke, husbandman 1
5016621 2361754 2361754 defendant Grapenell John husbandman 590612 590612 (Grapenell, John, of Brydbroke, husbandman 1
5040299 2368696 2368696 defendant Wellys Thomas husbandman 590612 590612 Wellys, Thomas, of Brydbroke, husbandman 0
5040309 2368701 2368701 defendant Wellys Thomas husbandman 590612 590612 Wellys, Thomas, of Brydbroke, husbandman 0
5094217 2384714 2384714 defendant Broun John gent 590612 590612 Broun, John, of Brydbroke, gent 0
5138420 2397743 2397743 defendant Broun John gent 590612 590612 Broun, John, of Brydbroke, gent 0
5159219 2403813 2403813 defendant Broun John gent 590612 590612 Broun, John, of Brydbroke, gent 0
5174436 2408224 2408224 defendant Broun John gent 590612 590612 Broun, John, of Brydbroke, gent 0
5209090 2418391 2418391 defendant Broun John gent 590612 590612 Broun, John, of Brydbroke, gent 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);