names

20 rows where place_id = 670376

✎ 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
3996808 2023625 2023625 plaintiff Dobson William yeoman 670376 670376 Dobson, William, of Armyn, yeoman 0
4017423 2030936 2030936 defendant Horssell John yeoman 670376 670376 Horssell, John, of Armyn, yeoman 0
4017751 2031056 2031056 defendant Horsall John yeoman 670376 670376 Horsall, John, of Armyn, yeoman 0
4041223 2039351 2039351 defendant Jackson Robert yeoman 670376 670376 Jackson, Robert, of Armyn, yeoman 0
4049751 2042353 2042353 defendant Hope Peter yeoman 670376 670376 Hope, Peter, of Armyn, yeoman 0
4100079 2060359 2060359 defendant Hope Margaret   670376 670376 Hope, Margaret, of Armyn, widow of Peter Hoope, of Armyn 1
4100080 2060359 2060359 defendant Hope William yeoman 670376 670376 Hope, William, of Armyn, yeoman 2
4142214 2075455 2075455 defendant Trymyngham John gent 670376 670376 Trymyngham, John, of Armyn, gent 1
4167667 2084186 2084186 defendant Trymyngham John gent 670376 670376 Trymyngham, John, of Armyn, gent 5
4274965 2121196 2121196 defendant Moore John yeoman 670376 670376 Moore, John, of Armyn, yeoman 0
4320210 2137169 2137169 defendant Hoope Cuthbert yeoman 670376 670376 Hoope, Cuthbert, of Armyn or of Ayremyne, yeoman 3
4348319 2146664 2146664 defendant Hoope Cuthbert yeoman 670376 670376 Hoope, Cuthbert, of Armyn, yeoman 0
4402255 2165340 2165340 defendant Jackson John husbandman 670376 670376 Jackson, John, of Armyn, husbandman 0
4403508 2165745 2165745 defendant Trymingham John, junior gent 670376 670376 Trymingham, John, junior, of Armyn, gent 0
4854650 2312828 2312828 defendant Cook John (legal representative) 670376 670376 Cook, John, of Armyn, shipman, executor of 3
4877053 2319794 2319794 defendant Cooke John (legal representative) 670376 670376 Cooke, John, of Armyn, shipman, executor of 2
5377775 2468632 2468632 defendant Okesby Robert loaborer 670376 670376 Okesby, Robert, of Armyn, loaborer 5
5503519 2506014 2506014 defendant Reder William yeoman 670376 670376 (Reder, William, of Armyn, yeoman 1
5503522 2506015 2506015 defendant Reder William   670376 670376 (Reder, William, of Armyn 1
5503525 2506016 2506016 defendant Reder William   670376 670376 (Reder, William, of Armyn 1

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