names

30 rows where case_id = 2010311

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3959216 2010311 2010311 plaintiff Seynt Quynten Gabriel esq   Seynt Quynten, Gabriel, esq 0
3959217 2010311 2010311 defendant Pockley Richard husbandman 661113 661113 Pockley, Richard, of Burton Agnes, husbandman 0
3959218 2010311 2010311 defendant Graye William husbandman 661113 661113 Graye, William, of Burton Agnes, husbandman 1
3959219 2010311 2010311 defendant Peycoke John husbandman 661113 661113 Peycoke, John, of Burton Agnes, husbandman 2
3959220 2010311 2010311 defendant Atkynson Richard husbandman 661113 661113 Atkynson, Richard, of Burton Agnes, husbandman 3
3959221 2010311 2010311 defendant Mayson Edward husbandman 661113 661113 Mayson, Edward, of Burton Agnes, husbandman 4
3959222 2010311 2010311 defendant Sharpe George husbandman 661113 661113 Sharpe, George, of Burton Agnes, husbandman 5
3959223 2010311 2010311 defendant Egleston John husbandman 661113 661113 Egleston, John, of Burton Agnes, husbandman 6
3959224 2010311 2010311 defendant Peycoke Thomas husbandman 661113 661113 Peycoke, Thomas, of Burton Agnes, husbandman 7
3959225 2010311 2010311 defendant Wynde Nicholas butcher 661113 661113 Wynde, Nicholas, of Burton Agnes, butcher 8
3959226 2010311 2010311 defendant Lowthropp Thomas laborer 661113 661113 Lowthropp, Thomas, of Burton Agnes, laborer 9
3959227 2010311 2010311 defendant Pereson Robert butcher 661113 661113 Pereson, Robert, of Burton Agnes, butcher 10
3959228 2010311 2010311 defendant Bodye Robert laborer 661113 661113 Bodye, Robert, of Burton Agnes, laborer 11
3959229 2010311 2010311 defendant Watson Peter laborer 661113 661113 Watson, Peter, of Burton Agnes, laborer 12
3959230 2010311 2010311 defendant Yowle John laborer 661113 661113 Yowle, John, of Burton Agnes, laborer 13
3959231 2010311 2010311 defendant Garnett John weaver 661113 661113 Garnett, John, of Burton Agnes, weaver 14
3959232 2010311 2010311 defendant Yowle William tailor 661113 661113 Yowle, William, of Burton Agnes, tailor 15
3959233 2010311 2010311 defendant Ryston John laborer 661113 661113 Ryston, John, of Burton Agnes, laborer 16
3959234 2010311 2010311 defendant Dickson Thomas   661113 661113 Dickson, Thomas, of Burton Agnes, "grasman" 17
3959235 2010311 2010311 defendant Capellman John husbandman 661113 661113 Capellman, John, of Burton Agnes, husbandman 18
3959236 2010311 2010311 defendant Dickson William thatcher 661113 661113 Dickson, William, of Burton Agnes, thatcher 19
3959237 2010311 2010311 defendant Clarke Stephen husbandman 661113 661113 Clarke, Stephen, of Burton Agnes, husbandman 20
3959238 2010311 2010311 defendant Smythe Alexander laborer 661113 661113 Smythe, Alexander, of Burton Agnes, laborer 21
3959239 2010311 2010311 defendant Leynge Robert laborer 661113 661113 Leynge, Robert, of Burton Agnes, laborer 22
3959240 2010311 2010311 defendant Walche Thomas laborer 661113 661113 Walche, Thomas, of Burton Agnes, laborer 23
3959241 2010311 2010311 defendant Chekyn Robert laborer 661113 661113 Chekyn, Robert, of Burton Agnes, laborer 24
3959242 2010311 2010311 defendant Baron Thomas laborer 661113 661113 Baron, Thomas, of Burton Agnes, laborer 25
3959243 2010311 2010311 defendant Thomson Thomas laborer 661113 661113 Thomson, Thomas, of Burton Agnes, laborer 26
3959244 2010311 2010311 defendant Galland Robert laborer 661113 661113 Galland, Robert, of Burton Agnes, laborer 27
3959245 2010311 2010311 defendant Baytson James laborer 661113 661113 Baytson, James, of Burton Agnes, laborer 28

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