names

6 rows where place_id = 814552

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4864659 2315916 2315916 defendant Pikergill William yeoman 814552 814552 Pikergill, William, of Ilketon, yeoman 8
4864660 2315916 2315916 defendant Jonson Thomas yeoman 814552 814552 Jonson, Thomas, of Ilketon, yeoman 9
4864661 2315916 2315916 defendant Horsman William, junior yeoman 814552 814552 Horsman, William, junior, of Ilketon, yeoman 10
4864662 2315916 2315916 defendant Horsman William, senior yeoman 814552 814552 Horsman, William, senior, of Ilketon, yeoman 11
4864663 2315916 2315916 defendant Lamhyrd Thomas yeoman 814552 814552 Lamhyrd, Thomas, of Ilketon, yeoman 12
4864664 2315916 2315916 defendant Looge Thomas yeoman 814552 814552 Looge, Thomas, of Ilketon, yeoman 13

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