names

17 rows where place_id = 646632

✎ 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
3892063 1987597 1987597 defendant Juell Richard   646632 646632 Juell, Richard, of Launcells 0
4059726 2045873 2045873 defendant Pentyer Richard gent 646632 646632 Pentyer, Richard, of Launcells, gent 0
4059727 2045873 2045873 defendant Pentyer Thomas yeoman 646632 646632 Pentyer, Thomas, of Launcells, yeoman 1
4061605 2046550 2046550 plaintiff Ebotte William   646632 646632 Ebotte, William, of Launcells 0
4089589 2056566 2056566 defendant Juell James husbandman 646632 646632 Juell, James, of Launcells, husbandman 1
4089592 2056567 2056567 defendant Sangwyne Digory tanner 646632 646632 Sangwyne, Digory, of Launcells, tanner 1
4181120 2088872 2088872 defendant Jule Jeremy yeoman 646632 646632 Jule, Jeremy, of Launcells, yeoman 0
4220425 2102647 2102647 defendant Gard Stephen husbandman 646632 646632 Gard, Stephen, of Launcells, husbandman 0
4236134 2108209 2108209 defendant Pentyer Thomas cordwainer 646632 646632 Pentyer, Thomas, of Launcells, cordwainer 0
4241228 2110053 2110053 defendant Sangwen Digory husbandman 646632 646632 Sangwen, Digory, of Launcells, husbandman 0
4245701 2111543 2111543 defendant Moyse William laborer 646632 646632 Moyse, William, of Launcells, laborer 2
4352404 2148079 2148079 defendant Sangwyn Digory husbandman 646632 646632 Sangwyn, Digory, of Launcells, husbandman 0
4376033 2156492 2156492 defendant Paityre John yeoman 646632 646632 Paityre, John, of Launcells, yeoman 1
4376034 2156492 2156492 defendant Uglowe Richard yeoman 646632 646632 Uglowe, Richard, of Launcells, yeoman 2
4376035 2156492 2156492 defendant Moyse William yeoman 646632 646632 Moyse, William, of Launcells, yeoman 3
4402137 2165304 2165304 defendant Warde Stephen husbandman 646632 646632 Warde, Stephen, of Launcells, husbandman 2
4406146 2166620 2166620 defendant Sangwyn Digory husbandman 646632 646632 Sangwyn, Digory, of Launcells, husbandman 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);