names

13 rows where case_id = 2424360

✎ 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
5229886 2424360 2424360 plaintiff Arundell John esq 600312 600312 Arundell, John, of Talvern, esq 0
5229887 2424360 2424360 defendant Trewyke Robert tucker 861897 861897 Trewyke, Robert, of Treuruburgh, tucker 0
5229888 2424360 2424360 defendant Dyer Richard dyer 861897 861897 Dyer, Richard, of Treuruburgh, dyer 1
5229889 2424360 2424360 defendant Walyngton Henry hooper 861897 861897 Walyngton, Henry, of Treuruburgh, hooper 2
5229890 2424360 2424360 defendant Kene Richard souter 861897 861897 Kene, Richard, of Treuruburgh, souter 3
5229891 2424360 2424360 defendant Trewyns Ralph souter 861897 861897 Trewyns, Ralph, of Treuruburgh, souter 4
5229892 2424360 2424360 defendant Toware James souter 861897 861897 Toware, James, of Treuruburgh, souter 5
5229893 2424360 2424360 defendant Berthey James tanner 861897 861897 Berthey, James, of Treuruburgh, tanner 6
5229894 2424360 2424360 defendant Berthey Drew tanner 861897 861897 Berthey, Drew, of Treuruburgh, tanner 7
5229895 2424360 2424360 defendant Mylward John   861897 861897 Mylward, John, of Treuruburgh, cook 8
5229896 2424360 2424360 defendant Moton Martin   861897 861897 Moton, Martin, of Treuruburgh, millward 9
5229897 2424360 2424360 defendant Taillour Vivian tailor 861897 861897 Taillour, Vivian, of Treuruburgh, tailor 10
5229898 2424360 2424360 defendant Ingakys Henry carpenter 861897 861897 Ingakys, Henry, of Treuruburgh, carpenter 11

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