names

22 rows where place_id = 587325

✎ 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
3591074 1864838 1864838 defendant Myners John gent 587325 587325 Myners, John, of Uttoxhater, gent 0
3591075 1864838 1864838 defendant Myners William gent 587325 587325 Myners, William, of Uttoxhater, gent 1
3591076 1864838 1864838 defendant Holys James yeoman 587325 587325 Holys, James, of Uttoxhater, yeoman 2
3591077 1864838 1864838 defendant More William, senior yeoman 587325 587325 More, William, senior, of Uttoxhater, yeoman 3
3591078 1864838 1864838 defendant More William, junior yeoman 587325 587325 More, William, junior, of Uttoxhater, yeoman 4
3591079 1864838 1864838 defendant Hyde Randolph yeoman 587325 587325 Hyde, Randolph, of Uttoxhater, yeoman 5
3591080 1864838 1864838 defendant Wright Thomas yeoman 587325 587325 Wright, Thomas, of Uttoxhater, yeoman 6
3591081 1864838 1864838 defendant Staley Thrustan yeoman 587325 587325 Staley, Thrustan, of Uttoxhater, yeoman 7
3591082 1864838 1864838 defendant Sutton Robert yeoman 587325 587325 Sutton, Robert, of Uttoxhater, yeoman 8
3591083 1864838 1864838 defendant Milward Thomas yeoman 587325 587325 Milward, Thomas, of Uttoxhater, yeoman 9
3591088 1864838 1864838 defendant Eton Richard laborer 587325 587325 Eton, Richard, of Uttoxhater, laborer 14
3591089 1864838 1864838 defendant Kyrkeby Richard laborer 587325 587325 Kyrkeby, Richard, of Uttoxhater, laborer 15
3591091 1864838 1864838 defendant Kyrstor Richard   587325 587325 Kyrstor, Richard, of Uttoxhater, hat maker 17
3591092 1864838 1864838 defendant Howette Richard laborer 587325 587325 Howette, Richard, of Uttoxhater, laborer 18
3591093 1864838 1864838 defendant Foxlowe Thomas smith 587325 587325 Foxlowe, Thomas, of Uttoxhater, smith 19
3591094 1864838 1864838 defendant Lelehed William glover 587325 587325 Lelehed, William, of Uttoxhater, glover 20
3591095 1864838 1864838 defendant Harden Thomas tailor 587325 587325 Harden, Thomas, of Uttoxhater, tailor 21
3591096 1864838 1864838 defendant Wright Henry yeoman 587325 587325 Wright, Henry, of Uttoxhater, yeoman 22
5130283 2395340 2395340 defendant Dethyk Thomas esq 587325 587325 Dethyk, Thomas, of Uttoxhater, esq 1
5149614 2401016 2401016 defendant Dethyk Thomas esq 587325 587325 Dethyk, Thomas, of Uttoxhater, esq 1
5184472 2411199 2411199 defendant Dethyk Thomas esq 587325 587325 Dethyk, Thomas, of Uttoxhater, esq 1
5385875 2471034 2471034 defendant Hert William yeoman 587325 587325 Hert, William, of Uttoxhater, yeoman 2

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