names

13 rows where case_id = 1938614

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3739639 1938614 1938614 plaintiff Pollard Lewis knight   Pollard, Lewis, knight 0
3739640 1938614 1938614 plaintiff Champernon Philip esq   Champernon, Philip, esq 1
3739641 1938614 1938614 plaintiff Caylesway John esq   Caylesway, John, esq 2
3739642 1938614 1938614 plaintiff Lane John     Lane, John 3
3739643 1938614 1938614 plaintiff Smyth John     Smyth, John 4
3739644 1938614 1938614 plaintiff Spurway John     Spurway, John 5
3739645 1938614 1938614 plaintiff Benett Richard     Benett, Richard 6
3739646 1938614 1938614 plaintiff Appohyll Thomas     Appohyll, Thomas 7
3739647 1938614 1938614 plaintiff Parkhouse Richard     Parkhouse, Richard 8
3739648 1938614 1938614 plaintiff Newman Richard     Newman, Richard 9
3739649 1938614 1938614 plaintiff Deyman John     Deyman, John 10
3739650 1938614 1938614 plaintiff Dun John     Dun, John 11
3739651 1938614 1938614 defendant Upcote Robert glover 598597 598597 Upcote, Robert, of Wellyngton, Soms, glover 0

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