names

13 rows where case_id = 2403492

✎ 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
5158101 2403492 2403492 plaintiff Pomeray Henry de la     Pomeray, Henry de la 0
5158102 2403492 2403492 defendant Holeway John gent 661179 661179 Holeway, John, of Payngton, gent 0
5158103 2403492 2403492 defendant Cranford William husbandman 661179 661179 Cranford, William, of Payngton, husbandman 1
5158104 2403492 2403492 defendant Germyn John mariner 661179 661179 Germyn, John, of Payngton, mariner 2
5158105 2403492 2403492 defendant Amys Richard yeoman 661179 661179 Amys, Richard, of Payngton, yeoman 3
5158106 2403492 2403492 defendant Walsshe Nicholas yeoman 661179 661179 Walsshe, Nicholas, of Payngton, yeoman 4
5158107 2403492 2403492 defendant Moulyssh Richard tailor 854365 854365 Moulyssh, Richard, of Great Totteneys, tailor 5
5158108 2403492 2403492 defendant Bokell John yeoman 661179 661179 Bokell, John, of Payngton, yeoman 6
5158109 2403492 2403492 defendant Salle Henry husbandman 661179 661179 Salle, Henry, of Payngton, husbandman 7
5158110 2403492 2403492 defendant Preter William laborer 661179 661179 Preter, William, of Payngton, laborer 8
5158111 2403492 2403492 defendant Belleworthy John butcher 596906 596906 Belleworthy, John, of Newton Abbot, butcher 9
5158112 2403492 2403492 defendant Cane or Cave Nicholas husbandman 661179 661179 Cane or Cave, Nicholas, of Payngton, husbandman 10
5158113 2403492 2403492 defendant Broun Denis laborer 661179 661179 Broun, Denis, of Payngton, laborer 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);