names

8 rows where place_id = 786874

✎ 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
4699687 2265347 2265347 defendant Stokes William yeoman 786874 786874 Stokes, William, of Pruston, yeoman 23
4759570 2283335 2283335 defendant Selman Thomas laborer 786874 786874 Selman, Thomas, of Pruston, laborer 1
4759588 2283341 2283341 defendant Selman Thomas laborer 786874 786874 Selman, Thomas, of Pruston, laborer 1
4781746 2290305 2290305 defendant Selman Thomas laborer 786874 786874 Selman, Thomas, of Pruston, laborer 1
5021894 2363297 2363297 defendant Pruston Richard husbandman 786874 786874 Pruston, Richard, of Pruston, husbandman 0
5141485 2398628 2398628 defendant Babbe Warin husbandman 786874 786874 Babbe, Warin, of Pruston, husbandman 0
5162353 2404715 2404715 defendant Brytte Thomas husbandman 786874 786874 Brytte, Thomas, of Pruston, husbandman 0
5162355 2404715 2404715 defendant Brytte John laborer 786874 786874 Brytte, John, of Pruston, laborer 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);