names

11 rows where place_id = 654129

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3931229 2000735 2000735 plaintiff Davye Isabel widow 654129 654129 Davye, Isabel, of Houeden, widow 0
4797697 2295460 2295460 defendant de Acome Stephen saddler 654129 654129 de Acome, Stephen, of Houeden, saddler 0
4797698 2295460 2295460 defendant Raskell Richard glover 654129 654129 Raskell, Richard, of Houeden, glover 1
4806599 2298274 2298274 defendant Williamson Thomas tanner 654129 654129 Williamson, Thomas, of Houeden, tanner 3
4855688 2313150 2313150 defendant Laverok William chaplain 654129 654129 Laverok, William, of Houeden, chaplain 0
4886007 2322483 2322483 defendant Kent William chapman 654129 654129 Kent, William, of Houeden, chapman 3
5033673 2366728 2366728 plaintiff Spofyrth Richard   654129 654129 Spofyrth, Richard, of Houeden 0
5269583 2436210 2436210 defendant Bell Thomas laborer 654129 654129 Bell, Thomas, of Houeden, laborer 1
5624339 2551557 2551557 defendant Blyburgh William butcher 654129 654129 Blyburgh, William, of Houeden, butcher 0
5635291 2555002 2555002 plaintiff Watson Richard   654129 654129 Watson, Richard, of Houeden 0
5636350 2555325 2555325 plaintiff Wresyll John   654129 654129 Wresyll, John, of Houeden 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);