names

16 rows where case_id = 2390549

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5114190 2390549 2390549 plaintiff Louther Hugh esq   Louther, Hugh, esq 0
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
5114197 2390549 2390549 defendant Bolton William yeoman 775307 775307 Bolton,William, of Emylton, yeoman 6
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

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