names

15 rows where case_id = 2522853

✎ 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
5559896 2522853 2522853 plaintiff Serlby Hugh     Serlby, Hugh 0
5559897 2522853 2522853 defendant Marshall Robert yeoman 605602 605602 Marshall, Robert, of Blyth, yeoman 0
5559898 2522853 2522853 defendant Croke Christopher barber 605602 605602 Croke, Christopher, of Blyth, barber 1
5559899 2522853 2522853 defendant Rawelyn William mercer   Rawelyn, William, mercer 2
5559900 2522853 2522853 defendant Rawlynson John yeoman 605602 605602 Rawlynson, John, of Blyth, yeoman 3
5559901 2522853 2522853 defendant Gybson Peter tailor 605602 605602 Gybson, Peter, of Blyth, tailor 4
5559902 2522853 2522853 defendant Gebbe William     Gebbe, William 5
5559903 2522853 2522853 defendant Thomason Thomas     Thomason, Thomas 6
5559904 2522853 2522853 defendant Pye Edmund     Pye, Edmund 7
5559905 2522853 2522853 defendant Oldfeld William     Oldfeld, William 8
5559906 2522853 2522853 defendant Oldfeld Christopher     Oldfeld, Christopher 9
5559907 2522853 2522853 defendant Bocher John     Bocher, John 10
5559908 2522853 2522853 defendant Rawelyn Ralph     Rawelyn, Ralph 11
5559909 2522853 2522853 defendant Robertson Thomas     Robertson, Thomas 12
5559910 2522853 2522853 defendant Adamson Robert     Adamson, Robert 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);