names

6 rows where place_id = 881683

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5388134 2471662 2471662 defendant Chamberleyn William husbandman 881683 881683 Chamberleyn, William, of Amwyke, husbandman 13
5388135 2471662 2471662 defendant Chamberleyn Thomas husbandman 881683 881683 Chamberleyn, Thomas, of Amwyke, husbandman 14
5388136 2471662 2471662 defendant Faukoner Robert husbandman 881683 881683 Faukoner, Robert, of Amwyke, husbandman 15
5449023 2489601 2489601 defendant Mayne Thomas clerk 881683 881683 Mayne, Thomas, of Amwyke, clerk 0
5461183 2493292 2493292 defendant Mayne Thomas clerk 881683 881683 Mayne, Thomas, of Amwyke, clerk 0
5473520 2497044 2497044 defendant Thonbyrlane William husbandman 881683 881683 Thonbyrlane, William, of Amwyke, husbandman 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);