names

27 rows where place_id = 757094

✎ 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
4443176 2182827 2182827 defendant Ordeseye Richard de   757094 757094 Ordeseye, Richard de, of Russhale 0
4444659 2183309 2183309 plaintiff Colman Thomas   757094 757094 Colman, Thomas, of Russhale, son of Richard 0
4472561 2192086 2192086 defendant Smyth Thomas   757094 757094 Smyth, Thomas, of Russhale 2
4583744 2226329 2226329 defendant Smyth Thomas   757094 757094 Smyth, Thomas, of Russhale 0
4624286 2238584 2238584 defendant Colman Robert   757094 757094 Colman, Robert, of Russhale 0
4624287 2238584 2238584 defendant Colman John   757094 757094 Colman, John, of Russhale 1
4624289 2238584 2238584 defendant Smyth John   757094 757094 Smyth, John, of Russhale 3
4624291 2238584 2238584 defendant Wryght John   757094 757094 Wryght, John, of Russhale 5
4624294 2238584 2238584 defendant Smyth Thomas   757094 757094 Smyth, Thomas, of Russhale 8
4624296 2238584 2238584 defendant Wright William   757094 757094 Wright, William, of Russhale 10
4624307 2238588 2238588 defendant Colman Robert   757094 757094 together with Colman, Robert, of Russhale 1
4624308 2238588 2238588 defendant Colman John   757094 757094 Colman, John, of Russhale 2
4624310 2238588 2238588 defendant Smyth John   757094 757094 Smyth, John, of Russhale 4
4624312 2238588 2238588 defendant Wryght John   757094 757094 Wryght, John, of Russhale 6
4624315 2238588 2238588 defendant Smyth Thomas   757094 757094 Smyth, Thomas, of Russhale 9
4624317 2238588 2238588 defendant Wright William   757094 757094 Wright, William, of Russhale 11
4624320 2238589 2238589 defendant Colman Robert   757094 757094 together with Colman, Robert, of Russhale 1
4624321 2238589 2238589 defendant Colman John   757094 757094 Colman, John, of Russhale 2
4624323 2238589 2238589 defendant Smyth John   757094 757094 Smyth, John, of Russhale 4
4624325 2238589 2238589 defendant Wryght John   757094 757094 Wryght, John, of Russhale 6
4624328 2238589 2238589 defendant Smyth Thomas   757094 757094 Smyth, Thomas, of Russhale 9
4624330 2238589 2238589 defendant Wryght William   757094 757094 Wryght, William, of Russhale 11
4724833 2273064 2273064 defendant atte Bryggenede Richard husbandman 757094 757094 atte Bryggenede, Richard, of Russhale, husbandman 0
4724834 2273064 2273064 defendant Colman Robert husbandman 757094 757094 Colman, Robert, of Russhale, husbandman 1
4724837 2273064 2273064 defendant Othemosse John husbandman 757094 757094 Othemosse, John, of Russhale, husbandman 4
4857144 2313617 2313617 defendant Mosse Thomas   757094 757094 Mosse, Thomas, of Russhale carpenter 0
5086076 2382319 2382319 defendant Lee Wiliam yeoman 757094 757094 Lee, Wiliam, of Russhale, yeoman 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);