names

16 rows where case_id = 2352520

✎ 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
4985271 2352520 2352520 plaintiff Yeo John     Yeo, John 0
4985272 2352520 2352520 defendant Gobbe John, senior mariner 655467 655467 Gobbe, John, senior, of Ilfardcombe, mariner 0
4985273 2352520 2352520 defendant Garlond Thomas husbandman 655467 655467 Garlond, Thomas, of Ilfardcombe, husbandman 1
4985274 2352520 2352520 defendant Olyver John husbandman 655467 655467 Olyver, John, of Ilfardcombe, husbandman 2
4985275 2352520 2352520 defendant Davy Richard husbandman 655467 655467 Davy, Richard, of Ilfardcombe, husbandman 3
4985276 2352520 2352520 defendant Kycke John yeoman 655467 655467 Kycke, John, of Ilfardcombe, yeoman 4
4985277 2352520 2352520 defendant Broun Thomas seaman 655467 655467 Broun, Thomas, of Ilfardcombe, seaman 5
4985278 2352520 2352520 defendant Wylhay William smith 655467 655467 Wylhay, William, of Ilfardcombe, smith 6
4985279 2352520 2352520 defendant Stykke Thomas husbandman 655467 655467 Stykke, Thomas, of Ilfardcombe, husbandman 7
4985280 2352520 2352520 defendant Gobbe John junioe, of Ilfardcombe, fisher   Gobbe, John, junioe, of Ilfardcombe, fisher 8
4985281 2352520 2352520 defendant Brounyng Thomas husbandman 655467 655467 Brounyng, Thomas, of Ilfardcombe, husbandman 9
4985282 2352520 2352520 defendant Rede Richard baker 655467 655467 Rede, Richard, of Ilfardcombe, baker 10
4985283 2352520 2352520 defendant Leye John mariner 655467 655467 Leye, John, of Ilfardcombe, mariner 11
4985284 2352520 2352520 defendant Wyke Auncel fisher 655467 655467 Wyke, Auncel, of Ilfardcombe, fisher 12
4985285 2352520 2352520 defendant Pytman Henry weaver 655467 655467 Pytman, Henry, of Ilfardcombe, weaver 13
4985286 2352520 2352520 defendant Aleyn John husbandman 830707 830707 Aleyn, John, of Brandewelle, husbandman 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);