names

18 rows where place_id = 598533

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632929 1905115 1905115 defendant Squyer John merchant 598533 598533 Squyer, John, of Opsham, merchant 0
3688078 1922433 1922433 defendant Boyle Thomas merchant 598533 598533 Boyle, Thomas, of Opsham, merchant 3
3688364 1922516 1922516 defendant Squier John merchant 598533 598533 Squier, John, of Opsham, merchant 3
3700226 1926305 1926305 defendant Shewete Thomas yeoman 598533 598533 Shewete, Thomas, of Opsham, yeoman 0
3730483 1935767 1935767 defendant Taylor John merchant 598533 598533 Taylor, John, of Opsham, yeoman, servant of Mychell, Roger, of Opsham, merchant 0
3731420 1936050 1936050 defendant Longmede Nicholas merchant 598533 598533 Longmede, Nicholas, of Opsham, merchant 0
3805778 1959751 1959751 defendant Michell Roger merchant 598533 598533 Michell, Roger, of Opsham, merchant 0
3824439 1965514 1965514 plaintiff Wegott William   598533 598533 Wegott, William, of Opsham 0
3824440 1965514 1965514 defendant Budde William merchant 598533 598533 Budde, William, of Opsham, merchant 0
3827406 1966437 1966437 defendant Johns Richard merchant 598533 598533 Johns, Richard, of Opsham, merchant 1
3881538 1984086 1984086 defendant Momoye Thomas yeoman 598533 598533 Momoye, Thomas, of Opsham, yeoman 0
3881539 1984086 1984086 defendant Wagytt Robert yeoman 598533 598533 Wagytt, Robert, of Opsham, yeoman 1
3881540 1984086 1984086 defendant Dyer alias Gregory Richard yeoman 598533 598533 Dyer alias Gregory, Richard, of Opsham, yeoman 2
5361915 2463751 2463751 defendant Taillour Richard merchant 598533 598533 Taillour, Richard, of Opsham, merchant 0
5571926 2526330 2526330 defendant Sterre John merchant 598533 598533 Sterre, John, of Opsham, merchant 0
5583433 2529888 2529888 defendant Roper Nicholas roper 598533 598533 Roper, Nicholas, of Opsham, roper 1
5592666 2532699 2532699 defendant Squyer John merchant 598533 598533 Squyer, John, of Opsham, merchant 0
5592670 2532700 2532700 defendant Tayllour Peter merchant 598533 598533 Tayllour, Peter, of Opsham, merchant 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);