names

20 rows where case_id = 2198710

✎ 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
4493640 2198710 2198710 plaintiff (not given) Ralph bishop of Bath & Wells   Bath & Wells, Ralph, bishop of 0
4493641 2198710 2198710 defendant Maunsell John     Maunsell, John 0
4493642 2198710 2198710 defendant Colynnesson John, senior     Colynnesson, John, senior 1
4493643 2198710 2198710 defendant Colynnesson John, junior     Colynnesson, John, junior 2
4493644 2198710 2198710 defendant Colynnesson Thomas     Colynnesson, Thomas 3
4493645 2198710 2198710 defendant Joye John   763043 763043 Joye, John, of East Merk 4
4493646 2198710 2198710 defendant Kynges William     Kynges, William 5
4493647 2198710 2198710 defendant Sulye Richard     Sulye, Richard 6
4493648 2198710 2198710 defendant atte Welles John     atte Welles, John 7
4493649 2198710 2198710 defendant Gripe John     Gripe, John 8
4493650 2198710 2198710 defendant Kynges Nicholas   759704 759704 Kynges, Nicholas, of Glastyngbury 9
4493651 2198710 2198710 defendant Nio--- John     Nio---, John 10
4493652 2198710 2198710 defendant Smok John     Smok, John 11
4493653 2198710 2198710 defendant Kynges John     Kynges, John 12
4493654 2198710 2198710 defendant Kynges Reginald     Kynges, Reginald 13
4493655 2198710 2198710 defendant Lokke Walter, junior     Lokke, Walter, junior 14
4493656 2198710 2198710 defendant Venne Richard     Venne, Richard 15
4493657 2198710 2198710 defendant Joye Richard     Joye, Richard 16
4493658 2198710 2198710 defendant Tele Thomas, senior     Tele, Thomas, senior 17
4493659 2198710 2198710 defendant Jakkesson Thomas     Jakkesson, Thomas 18

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