names

24 rows where case_id = 2510518

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5518175 2510518 2510518 plaintiff Wottley Nicholas esq   Wottley, Nicholas, esq 0
5518176 2510518 2510518 defendant Graunt Thomas husbandman 837716 837716 Graunt, Thomas, of Hoton Panell, husbandman 0
5518177 2510518 2510518 defendant Anne Elizabeth     Anne, Elizabeth 1
5518178 2510518 2510518 defendant Jill John     Jill, John 2
5518179 2510518 2510518 defendant Trown John     Trown, John 3
5518180 2510518 2510518 defendant Staynton William     Staynton, William 4
5518181 2510518 2510518 defendant Styryng Godfrey     Styryng, Godfrey 5
5518182 2510518 2510518 defendant Haumbre Thomas     Haumbre, Thomas 6
5518183 2510518 2510518 defendant Whitacres William     Whitacres, William 7
5518184 2510518 2510518 defendant Clarell John     Clarell, John 8
5518185 2510518 2510518 defendant Haweme William     Haweme, William 9
5518186 2510518 2510518 defendant Clerk Robert     Clerk, Robert 10
5518187 2510518 2510518 defendant Elys Stephen     Elys, Stephen 11
5518188 2510518 2510518 defendant Thirlefall Thomas     Thirlefall, Thomas 12
5518189 2510518 2510518 defendant Robynson John     Robynson, John 13
5518190 2510518 2510518 defendant Elyot Thomas     Elyot, Thomas 14
5518191 2510518 2510518 defendant England William     England, William 15
5518192 2510518 2510518 defendant Wykeham John     Wykeham, John 16
5518193 2510518 2510518 defendant Diconson Robert     Diconson, Robert 17
5518194 2510518 2510518 defendant Stele Robert     Stele, Robert 18
5518195 2510518 2510518 defendant Wilson John     Wilson, John 19
5518196 2510518 2510518 defendant Okeden Denis     Okeden, Denis 20
5518197 2510518 2510518 defendant Stele John     Stele, John 21
5518198 2510518 2510518 defendant Hudson Robert     Hudson, Robert 22

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