names

17 rows where place_id = 765843

✎ 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
4521570 2207079 2207079 defendant Bernard Robert   765843 765843 Bernard, Robert, of Knesale 0
4602305 2231938 2231938 plaintiff Webster Hugh   765843 765843 Webster, Hugh, of Knesale 0
4839766 2308350 2308350 plaintiff Gilby John master & parson 765843 765843 Gilby, John, of Knesale, master & parson 1
4839769 2308351 2308351 plaintiff Gilby John master & parson 765843 765843 Gilby, John, of Knesale, master & parson 1
4839772 2308352 2308352 plaintiff Gilby John master & parson 765843 765843 Gilby, John, of Knesale, master & parson 1
4839775 2308353 2308353 plaintiff Gilby John master & parson 765843 765843 Gilby, John, of Knesale, master & parson 1
4839782 2308355 2308355 plaintiff Gylby John   765843 765843 Gylby, John, of Knesale, parson 1
4866289 2316424 2316424 defendant Webster Alexander husbandman 765843 765843 Webster, Alexander, of Knesale, husbandman 0
4866290 2316424 2316424 defendant Webster Hugh   765843 765843 together with Webster, Hugh, of Knesale, laborer, his son 1
4866292 2316425 2316425 defendant Webster Alexander husbandman 765843 765843 Webster, Alexander, of Knesale, husbandman 0
4866293 2316425 2316425 defendant Webster Hugh   765843 765843 Webster, Hugh, of Knesale, laborer, son of Alexander 1
4930443 2335923 2335923 plaintiff Toll John husbandman 765843 765843 Toll, John, of Knesale, husbandman 0
4966050 2346773 2346773 defendant Styresacre Robert husbandman 765843 765843 Styresacre, Robert, of Knesale, husbandman 0
4966051 2346773 2346773 defendant Styresacre John yeoman 765843 765843 Styresacre, John, of Knesale, yeoman 1
4978153 2350431 2350431 defendant Chapman William husbandman 765843 765843 Chapman, William, of Knesale, husbandman 0
4978154 2350431 2350431 defendant As- John husbandman 765843 765843 As-, John, of Knesale, husbandman 1
4980544 2351121 2351121 defendant Chapman William husbandman 765843 765843 Chapman, William, of Knesale, 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);