names

17 rows where place_id = 783177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4365713 2152782 2152782 defendant Wetrand alias Hundrethe Robert   783177 783177 Wetrand alias Hundrethe, Robert, of Emelton yeoman 3
4680945 2259665 2259665 defendant Rede Thomas yeoman 783177 783177 with Rede, Thomas, of Emelton, yeoman 4
5114191 2390549 2390549 defendant Atkynson William yeoman 783177 783177 Atkynson, William, of Emelton, yeoman 0
5114192 2390549 2390549 defendant Westwra William yeoman 783177 783177 Westwra, William, of Emelton, yeoman 1
5114193 2390549 2390549 defendant Bolton John yeoman 783177 783177 Bolton, John, of Emelton, yeoman 2
5114194 2390549 2390549 defendant Jakson William yeoman 783177 783177 Jakson, William, of Emelton, yeoman 3
5114195 2390549 2390549 defendant Bolton Peter yeoman 783177 783177 Bolton, Peter, of Emelton, yeoman 4
5114196 2390549 2390549 defendant Lemmynman William yeoman 783177 783177 Lemmynman, William, of Emelton, yeoman 5
5114198 2390549 2390549 defendant Hoggeson John yeoman 783177 783177 Hoggeson, John, of Emelton, yeoman 7
5114199 2390549 2390549 defendant Yodale Nicholas yeoman 783177 783177 Yodale, Nicholas, of Emelton, yeoman 8
5114200 2390549 2390549 defendant Westwra John yeoman 783177 783177 Westwra, John, of Emelton, yeoman 9
5114201 2390549 2390549 defendant Hexham Thomas yeoman 783177 783177 Hexham, Thomas, of Emelton, yeoman 10
5114202 2390549 2390549 defendant Rodere John, senior yeoman 783177 783177 Rodere, John, senior, of Emelton, yeoman 11
5114203 2390549 2390549 defendant Rodere John, junior yeoman 783177 783177 Rodere, John, junior, of Emelton, yeoman 12
5114204 2390549 2390549 defendant Rodere Robert yeoman 783177 783177 Rodere, Robert, of Emelton, yeoman 13
5114205 2390549 2390549 defendant Yodale William yeoman 783177 783177 Yodale, William, of Emelton, yeoman 14
5160323 2404113 2404113 defendant Thomson Alexander yeoman 783177 783177 Thomson, Alexander, of Emelton, 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);