names

15 rows where place_id = 685285

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4061809 2046620 2046620 defendant Twygge John gent 685285 685285 Twygge, John, of Tavestoke, Devon, gent 0
4340951 2144113 2144113 defendant Masters Walter merchant 685285 685285 Masters, Walter, of Tavestoke, Devon, merchant 0
4352047 2147951 2147951 defendant Masters Walter chapman 685285 685285 Masters, Walter, of Tavestoke, Devon, merchant, chapman 0
4352049 2147952 2147952 defendant Byrche Francis chapman 685285 685285 Byrche, Francis, of Tavestoke, Devon, chapman 0
4777138 2288831 2288831 defendant Virgo John merchant 685285 685285 Virgo, John, of Tavestoke, Devon, merchant 0
4886421 2322613 2322613 defendant Maister John chapman 685285 685285 Maister, John, of Tavestoke, Devon, chapman 2
4897576 2325903 2325903 defendant Draper John (legal representative) 685285 685285 Draper, John, of Tavestoke, Devon, executrix of 4
5000313 2356966 2356966 defendant Bulpyt Stephen chapman 685285 685285 Bulpyt, Stephen, of Tavestoke, Devon, chapman 1
5127703 2394586 2394586 defendant Bachyler John yeoman 685285 685285 Bachyler, John, of Tavestoke, Devon, yeoman 0
5155558 2402782 2402782 defendant Soper Simon miller or smelter 685285 685285 Soper, Simon, of Tavestoke, Devon, miller or smelter 16
5222279 2422222 2422222 defendant Assheford William chapman 685285 685285 Assheford, William, of Tavestoke, Devon, chapman 0
5222283 2422223 2422223 defendant Assheford William chapman 685285 685285 Assheford, William, of Tavestoke, Devon, chapman 0
5323496 2452106 2452106 defendant Keyoowe Edmund husbandman 685285 685285 Keyoowe, Edmund, of Tavestoke, Devon, husbandman 0
5323498 2452107 2452107 defendant Keyrowe Edmund husbandman 685285 685285 Keyrowe, Edmund, of Tavestoke, Devon, husbandman 0
5501865 2505508 2505508 defendant Salle John yeoman 685285 685285 (Salle, John, of Tavestoke, Devon, yeoman 5

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