names

15 rows where case_id = 2522852

✎ 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
5559881 2522852 2522852 plaintiff Serlby Hugh     Serlby, Hugh 0
5559882 2522852 2522852 defendant Marshall Robert yeoman 605602 605602 Marshall, Robert, of Blyth, yeoman 0
5559883 2522852 2522852 defendant Broke Christopher barber 605602 605602 Broke, Christopher, of Blyth, barber 1
5559884 2522852 2522852 defendant Rawelyn William mercer   Rawelyn, William, mercer 2
5559885 2522852 2522852 defendant Rawlynson John yeoman 605602 605602 Rawlynson, John, of Blyth, yeoman 3
5559886 2522852 2522852 defendant Gybson Peter     Gybson, Peter 4
5559887 2522852 2522852 defendant Jebbe William     Jebbe, William 5
5559888 2522852 2522852 defendant Thomason Thomas     Thomason, Thomas 6
5559889 2522852 2522852 defendant Pye Edmund     Pye, Edmund 7
5559890 2522852 2522852 defendant Oldfeld William     Oldfeld, William 8
5559891 2522852 2522852 defendant Oldfeld Christopher     Oldfeld, Christopher 9
5559892 2522852 2522852 defendant Bocher John     Bocher, John 10
5559893 2522852 2522852 defendant Rawelyn Ralph     Rawelyn, Ralph 11
5559894 2522852 2522852 defendant Robertson Thomas     Robertson, Thomas 12
5559895 2522852 2522852 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);