names

13 rows where case_id = 2033391

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4024338 2033391 2033391 plaintiff Bigilston Philip attorney of the bench   Bigilston, Philip, attorney of the bench 0
4024339 2033391 2033391 defendant Mathewe Elizabeth widow 655894 655894 Mathewe, Elizabeth, of Pynho, Devon, widow 0
4024340 2033391 2033391 defendant Parker William tailor 676810 676810 Parker, William, of Pynho, tailor 1
4024341 2033391 2033391 defendant White John shoemaker 586036 586036 White, John, of Exeter, shoemaker 2
4024342 2033391 2033391 defendant Payne William yeoman 668384 668384 Payne, William, of Newton St Ciric, Devon, yeoman 3
4024343 2033391 2033391 defendant Mounder alias Smythe Thomas husbandman 676837 676837 Mounder alias Smythe, Thomas, of Cheryton Bishop, Devon, husbandman 4
4024344 2033391 2033391 defendant Hancocke Henry husbandman 676813 676813 Hancocke, Henry, of West Putford, Devon, husbandman 5
4024345 2033391 2033391 defendant Hunt Richard husbandman 676838 676838 Hunt, Richard, of Lexneare, Devon, husbandman 6
4024346 2033391 2033391 defendant Froste Mathew husbandman 668400 668400 Froste, Mathew, of Credyton, Devon, husbandman 7
4024347 2033391 2033391 defendant Syms Leonard husbandman 676839 676839 Syms, Leonard, of Witheridge, Devon, husbandman 8
4024348 2033391 2033391 defendant Elworthy Hugh husbandman 676840 676840 Elworthy, Hugh, of West Worlyngton, Devon, husbandman 9
4024349 2033391 2033391 defendant Croke Edward clerk 676815 676815 Croke, Edward, of Thelbridge, Devon, clerk 10
4024350 2033391 2033391 defendant Weneman Edward husbandman 676841 676841 Weneman, Edward, of St Sydwell, Devon, husbandman 11

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