names

16 rows where case_id = 2480913

✎ 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
5420042 2480913 2480913 plaintiff Thwaytes Alesia widow   Thwaytes, Alesia, widow 0
5420043 2480913 2480913 plaintiff Thwaytes John esq   Thwaytes, John, esq 1
5420044 2480913 2480913 defendant Hltoftys Margaret widow 885697 885697 Hltoftys, Margaret, of Farnehill, widow 0
5420045 2480913 2480913 defendant Elotfes Edward gent 885698 885698 Elotfes, Edward, of Gylstede by Byngley, gent 1
5420046 2480913 2480913 defendant Sewer William tailor 885697 885697 Sewer, William, of Farnehill, tailor 2
5420047 2480913 2480913 defendant Sawer Peter tailor 885697 885697 Sawer, Peter, of Farnehill, tailor 3
5420048 2480913 2480913 defendant Walssh John laborer 885697 885697 Walssh, John, of Farnehill, laborer 4
5420049 2480913 2480913 defendant Wilson Hugn laborer 720659 720659 Wilson, Hugn, of Fernehill, laborer 5
5420050 2480913 2480913 defendant Caudray John laborer 885697 885697 Caudray, John, of Farnehill, laborer 6
5420051 2480913 2480913 defendant Janyn Richard tailor 885697 885697 Janyn, Richard, of Farnehill, tailor 7
5420052 2480913 2480913 defendant Todyngton John husbandman 885697 885697 Todyngton, John, of Farnehill, husbandman 8
5420053 2480913 2480913 defendant (illegible) Edmund yeoman 885697 885697 _, Edmund, of Farnehill, yeoman 9
5420054 2480913 2480913 defendant Atkynson William weaver 885697 885697 Atkynson, William, of Farnehill, weaver 10
5420055 2480913 2480913 defendant Michell John laborer 885697 885697 Michell, John, of Farnehill, laborer 11
5420056 2480913 2480913 defendant Hertley Thomas laborer 885697 885697 Hertley, Thomas, of Farnehill, laborer 12
5420057 2480913 2480913 defendant Dalton Richard yeoman 620648 620648 Dalton, Richard, of Almonbury, yeoman 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);