names

17 rows where place_id = 604797

✎ 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
3659321 1913176 1913176 defendant Trenure Benedict yeoman 604797 604797 Trenure, Benedict, of Treburthek, yeoman 0
3659322 1913176 1913176 defendant Hill John husbandman 604797 604797 Hill, John, of Treburthek, husbandman 1
4623023 2238177 2238177 defendant Perynseys John   604797 604797 Perynseys, John, of Treburthek 0
4657773 2248315 2248315 defendant Clouter William   604797 604797 Clouter, William, of Treburthek, "clouter" or one who repairs 0
5147601 2400437 2400437 defendant Wylle John husbandman 604797 604797 Wylle, John, of Treburthek, husbandman 2
5147602 2400437 2400437 defendant Watta William husbandman 604797 604797 Watta, William, of Treburthek, husbandman 3
5167223 2406146 2406146 defendant Wylle John husbandman 604797 604797 Wylle, John, of Treburthek, husbandman 2
5167225 2406147 2406147 defendant Watta William husbandman 604797 604797 Watta, William, of Treburthek, husbandman 0
5167228 2406147 2406147 defendant Wylle John husbandman 604797 604797 Wylle, John, of Treburthek, husbandman 3
5203472 2416769 2416769 defendant Wylle John   604797 604797 Wylle, John, of Treburthek, husbandman [derived from the bleed thro' of Wydslade's name, and previous entries] 2
5203474 2416770 2416770 defendant Watta William husbandman 604797 604797 Watta, William, of Treburthek, husbandman 0
5203477 2416770 2416770 defendant Wylle John husbandman 604797 604797 Wylle, John, of Treburthek, husbandman 3
5215479 2420251 2420251 defendant Watta William husbadman 604797 604797 Watta, William, of Treburthek, husbadman 0
5215482 2420251 2420251 defendant Wylle John husbandman 604797 604797 Wylle, John, of Treburthek, husbandman 3
5233856 2425488 2425488 defendant Watte William husbandman 604797 604797 Watte, William, of Treburthek, husbandman 0
5439236 2486663 2486663 defendant Pasewe Thomas husbandman 604797 604797 Pasewe, Thomas, of Treburthek, husbandman 0
5488082 2501327 2501327 defendant Pascowe Richard husbandman 604797 604797 Pascowe, Richard, of Treburthek, 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);