names

16 rows where case_id = 2396136

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5132971 2396136 2396136 plaintiff Holeway John     Holeway, John 0
5132972 2396136 2396136 defendant Restall John clerk 655387 655387 Restall, John, of Stoke Gabriel, clerk 0
5132973 2396136 2396136 defendant Hobbeday Peter fish monger   Hobbeday, Peter, fish monger 1
5132974 2396136 2396136 defendant Julyan John mariner 850731 850731 Julyan, John, of Grixham, mariner 2
5132975 2396136 2396136 defendant Jule William   586089 586089 Jule, William, of Brixham 3
5132976 2396136 2396136 defendant Harry Thomas yeoman 661179 661179 Harry, Thomas, of Payngton, yeoman 4
5132977 2396136 2396136 defendant Langlegh Florence husbandman 661179 661179 Langlegh, Florence, of Payngton, husbandman 5
5132978 2396136 2396136 defendant Stevyn (illegible) mariner 586089 586089 Stevyn, ---, of Brixham, mariner 6
5132979 2396136 2396136 defendant Carter John fisher 597174 597174 Carter, John, of Galmeton, fisher 7
5132980 2396136 2396136 defendant another of Brixham mariner   another, of Brixham, mariner 8
5132981 2396136 2396136 defendant Berte Richard   850732 850732 Berte, Richard, of Brixham, marin 9
5132982 2396136 2396136 defendant Co-- Reginald tailor   Co--, Reginald, tailor 10
5132983 2396136 2396136 defendant William John mariner 586089 586089 William, John, of Brixham, mariner 11
5132984 2396136 2396136 defendant Ocley Derlugus mariner   Ocley, Derlugus, mariner 12
5132985 2396136 2396136 defendant Broke John husbandman 661179 661179 Broke, John, of Payngton, husbandman 13
5132986 2396136 2396136 defendant Tolke John laborer 661179 661179 Tolke, John, of Payngton, laborer 14

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