names

19 rows where case_id = 2446786

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5306003 2446786 2446786 plaintiff Maleverer Edmund esq   Maleverer, Edmund, esq 0
5306004 2446786 2446786 defendant Casse Ralph   871235 871235 Casse, Ralph, of Thorp by Haukesworth 0
5306005 2446786 2446786 defendant Chalener Richard     Chalener, Richard 1
5306006 2446786 2446786 defendant Sele Thomas     Sele, Thomas 2
5306007 2446786 2446786 defendant Miton John     Miton, John 3
5306008 2446786 2446786 defendant Dykson Thomas     Dykson, Thomas 4
5306009 2446786 2446786 defendant Dykon John, sen     Dykon, John, sen 5
5306010 2446786 2446786 defendant Dykson John jun   Dykson, John, jun 6
5306011 2446786 2446786 defendant Walker Richard     Walker, Richard 7
5306012 2446786 2446786 defendant Walker John     Walker, John 8
5306013 2446786 2446786 defendant Walker Robert     Walker, Robert 9
5306014 2446786 2446786 defendant Taillour William     Taillour, William 10
5306015 2446786 2446786 defendant Laweson William     Laweson, William 11
5306016 2446786 2446786 defendant Gomersall Richard     Gomersall, Richard 12
5306017 2446786 2446786 defendant Grene Hugh     Grene, Hugh 13
5306018 2446786 2446786 defendant Brand Robert     Brand, Robert 14
5306019 2446786 2446786 defendant Rodys John   649755 649755 Rodys, John, of Menston 15
5306020 2446786 2446786 defendant Rodys William   649755 649755 Rodys, William, of Menston 16
5306021 2446786 2446786 defendant Smyth William of Haukesworth Baylsa, John, of Haukesworth   Smyth, William of Haukesworth, Baylsa, John, of Haukesworth 17

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