names

15 rows where case_id = 2334685

✎ 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
4926418 2334685 2334685 plaintiff Quarell Thomas     Quarell, Thomas 0
4926419 2334685 2334685 defendant Knardesley William laborer 610479 610479 Knardesley, William, of Brompton, laborer 0
4926420 2334685 2334685 defendant Cusope Katherine widow 823167 823167 Cusope, Katherine, of Durlyston, widow 1
4926421 2334685 2334685 defendant Morys Richard yeoman 823168 823168 Morys, Richard, of Lnydlyd pryour, yeoman 2
4926422 2334685 2334685 defendant ap Gryffyth David laborer 586208 586208 ap Gryffyth, David, of Hereford, laborer 3
4926423 2334685 2334685 defendant Deo William husbandman 650639 650639 Deo, William, of Turneston, husbandman 4
4926424 2334685 2334685 defendant Boton William husbandman 650639 650639 Boton, William, of Turneston, husbandman 5
4926425 2334685 2334685 defendant Skele Richard husbandman 823169 823169 Skele, Richard, of Wrombrigge, husbandman 6
4926426 2334685 2334685 defendant Skele Margaret     Margaret, his wife 7
4926427 2334685 2334685 defendant ap Gyllym John laborer 593413 593413 ap Gyllym, John, of Alensmore, laborer 8
4926428 2334685 2334685 defendant Aldesford William husbandman 823170 823170 Aldesford, William, of Wolnehope, husbandman 9
4926429 2334685 2334685 defendant Thloyde John husbandman 782977 782977 Thloyde, John, of Culpek, husbandman 10
4926430 2334685 2334685 defendant Hugyns Thomas husbandman 795135 795135 Hugyns, Thomas, of Tyburton, husbandman 11
4926431 2334685 2334685 defendant ap Howell Gechyn Geoffrey laborer 803375 803375 ap Howell Gechyn, Geoffrey, of Petirchirche, laborer 12
4926432 2334685 2334685 defendant ap Yerward David husbandman 782987 782987 ap Yerward, David, of Honton, husbandman 13

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