names

17 rows where case_id = 2379259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5075798 2379259 2379259 plaintiff Arundell John esq 843451 843451 Arundell, John, of Lanhern, esq 0
5075799 2379259 2379259 defendant Arundell John esq 600312 600312 Arundell, John, of Talvern, esq 0
5075800 2379259 2379259 defendant Tregass Henry yeoman 843452 843452 together with Tregass, Henry, of Tregass, St Gerens in Roselond, yeoman 1
5075801 2379259 2379259 defendant Bodrygy Stephen yeoman 843453 843453 Bodrygy, Stephen, of Bodrygy, St Gerens in Roselond, yeoman 2
5075802 2379259 2379259 defendant Tregassa John yeoman 843454 843454 Tregassa, John, of Tregassa, St Gerens in Roselond, yeoman 3
5075803 2379259 2379259 defendant Bodrygy William yeoman 843453 843453 Bodrygy, William, of Bodrygy, St Gerens in Roselond, yeoman 4
5075804 2379259 2379259 defendant Wolcok Michael husbandman 600312 600312 Wolcok, Michael, of Talvern, husbandman 5
5075805 2379259 2379259 defendant Restenrek John yeoman 843455 843455 Restenrek, John, of Trevelgon, St Mangan in Maneke, yeoman 6
5075806 2379259 2379259 defendant Botrell Reginald tailor 587468 587468 Botrell, Reginald, of St Keveran, tailor 7
5075807 2379259 2379259 defendant Carenthenek James yeoman 843456 843456 Carenthenek, James, of Merthyn, yeoman 8
5075808 2379259 2379259 defendant Carenthenek Michael yeoman 843457 843457 Carenthenek, Michael, of Cerenthenek, yeoman 9
5075809 2379259 2379259 defendant Eglosdery William husbandman 843458 843458 Eglosdery, William, of Eglosdery, husbandman 10
5075810 2379259 2379259 defendant James John shoemaker 593036 593036 James, John, of Helstonburgh, shoemaker 11
5075811 2379259 2379259 defendant Snyll John yeoman 593036 593036 Snyll, John, of Helstonburgh, yeoman 12
5075812 2379259 2379259 defendant Mener or Mever John smith 843459 843459 Mener or Mever, John, of Affyne, St Costantyn, smith 13
5075813 2379259 2379259 defendant Boswesek John yeoman 843460 843460 Boswesek, John, of Boswesek, St Costantyn, yeoman 14
5075814 2379259 2379259 defendant Baudyn Thomas   843461 843461 Baudyn, Thomas, of St Mangan, Manoke, holy water clerk 15

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);