names

15 rows where case_id = 2486517

✎ 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
5438748 2486517 2486517 plaintiff Thwaytes Alice widow   Thwaytes, Alice, widow 0
5438749 2486517 2486517 plaintiff Thwaytes John esq   Thwaytes, John, esq 1
5438750 2486517 2486517 defendant Eltoftys Margaret widow 885697 885697 Eltoftys, Margaret, of Farnehill, widow 0
5438751 2486517 2486517 defendant Clare Edward gent 887542 887542 Clare, Edward, of Gylstede by Byngeley, gent 1
5438752 2486517 2486517 defendant Sawer William tailor 885697 885697 Sawer, William, of Farnehill, tailor 2
5438753 2486517 2486517 defendant Sawer Peter tailor 885697 885697 Sawer, Peter, of Farnehill, tailor 3
5438754 2486517 2486517 defendant Walssh John laborer 885697 885697 Walssh, John, of Farnehill, laborer 4
5438755 2486517 2486517 defendant Wilson Hugh laborer 885697 885697 Wilson, Hugh, of Farnehill, laborer 5
5438756 2486517 2486517 defendant Caudray John laborer 885697 885697 Caudray, John, of Farnehill, laborer 6
5438757 2486517 2486517 defendant Janyn Richard tailor 885697 885697 Janyn, Richard, of Farnehill, tailor 7
5438758 2486517 2486517 defendant Todyngton John husbandman 885697 885697 Todyngton, John, of Farnehill, husbandman 8
5438759 2486517 2486517 defendant Colthyrst Edmunds yeoman 885697 885697 Colthyrst, Edmunds, of Farnehill, yeoman 9
5438760 2486517 2486517 defendant Atkynson William weaver 885697 885697 Atkynson, William, of Farnehill, weaver 10
5438761 2486517 2486517 defendant Michell John laborer 885697 885697 Michell, John, of Farnehill, laborer 11
5438762 2486517 2486517 defendant Dalton Richard yeoman 593199 593199 Dalton, Richard, of Almondbury, yeoman 12

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