names

24 rows where place_id = 685237

✎ 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
4061598 2046546 2046546 defendant Barrette John yeoman 685237 685237 Barrette, John, of Kilkhampton, yeoman 0
4061606 2046550 2046550 defendant Barrette John yeoman 685237 685237 Barrette, John, of Kilkhampton, yeoman 0
4240690 2109868 2109868 defendant Gist John yeoman 685237 685237 Gist, John, of Kilkhampton, yeoman 2
4246465 2111794 2111794 defendant Kinsman Leonard yeoman 685237 685237 Kinsman, Leonard, of Kilkhampton, yeoman 0
4263706 2117520 2117520 defendant Gist John yeoman 685237 685237 Gist, John, of Kilkhampton, yeoman 2
4293689 2127807 2127807 defendant Kinsman Leonard yeoman or gent 685237 685237 Kinsman, Leonard, of Kilkhampton, yeoman or gent 0
4298528 2129575 2129575 defendant Deymond James yeoman 685237 685237 Deymond, James, of Kilkhampton, yeoman 0
4298530 2129576 2129576 defendant Maye Malachias or Malachi yeoman 685237 685237 Maye, Malachias or Malachi, of Kilkhampton, yeoman 0
4331732 2140909 2140909 defendant Kinsman Leonard yeoman 685237 685237 Kinsman, Leonard, of Kilkhampton, yeoman 0
4331733 2140909 2140909 defendant Neale Nicholas husbandman 685237 685237 Neale, Nicholas, of Kilkhampton, husbandman 1
4388257 2160702 2160702 defendant Brooke John   685237 685237 Brooke, John, of Kilkhampton, mason 0
4388258 2160702 2160702 defendant Baman John yeoman 685237 685237 Baman, John, of Kilkhampton, yeoman 1
4388262 2160703 2160703 defendant Caddaye William husbandman 685237 685237 Caddaye, William, of Kilkhampton, husbandman 2
4403398 2165702 2165702 defendant Kinsman Leonard yeoman 685237 685237 Kinsman, Leonard, of Kilkhampton, yeoman 0
4406137 2166617 2166617 defendant Brooke John   685237 685237 Brooke, John, of Kilkhampton, mason 0
4406138 2166617 2166617 defendant White Digory yeoman 685237 685237 White, Digory, of Kilkhampton, yeoman 1
4673372 2257313 2257313 defendant Gof John husbandman 685237 685237 Gof, John, of Kilkhampton, husbandman 0
4698407 2264979 2264979 defendant Gof John husbandman 685237 685237 Gof, John, of Kilkhampton, husbandman 0
4780063 2289769 2289769 defendant Cole John laborer 685237 685237 Cole, John, of Kilkhampton, laborer 0
4839435 2308257 2308257 defendant Stanbury John husbandman 685237 685237 Stanbury, John, of Kilkhampton, husbandman 0
4899828 2326585 2326585 defendant Loman John clerk 685237 685237 Loman, John, of Kilkhampton, clerk 3
5296068 2443841 2443841 defendant Jolyff John, junior dyer 685237 685237 Jolyff, John, junior, of Kilkhampton, dyer 1
5370478 2466350 2466350 defendant Whyte John clerk 685237 685237 Whyte, John, of Kilkhampton, clerk 0
5373949 2467448 2467448 defendant Whyte John clerk 685237 685237 Whyte, John, of Kilkhampton, clerk 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);