names

13 rows where case_id = 2005408

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3945186 2005408 2005408 plaintiff Blomevill Robert gent   Blomevill, Robert, gent 0
3945187 2005408 2005408 defendant Lowe George gent 640711 640711 Lowe, George, of Denbigh, gent 0
3945188 2005408 2005408 defendant Staley William   640711 640711 Staley, William, of Denbigh yeoman 1
3945189 2005408 2005408 defendant Grenewood Robert yeoman 657656 657656 Grenewood, Robert, of Denigh, yeoman 2
3945190 2005408 2005408 defendant Garratt Edward yeoman 657656 657656 Garratt, Edward, of Denigh, yeoman 3
3945191 2005408 2005408 defendant Smythe Robert yeoman 657656 657656 Smythe, Robert, of Denigh, yeoman 4
3945192 2005408 2005408 defendant Homage Nicholas yeoman 657656 657656 Homage, Nicholas, of Denigh, yeoman 5
3945193 2005408 2005408 defendant Fletcher William yeoman 657656 657656 Fletcher, William, of Denigh, yeoman 6
3945194 2005408 2005408 defendant Bolror Henry yeoman 657656 657656 Bolror, Henry, of Denigh, yeoman 7
3945195 2005408 2005408 defendant Nayler John laborer 657656 657656 Nayler, John, of Denigh, laborer 8
3945196 2005408 2005408 defendant Dyconson Thomas yeoman 657656 657656 Dyconson, Thomas, of Denigh, yeoman 9
3945197 2005408 2005408 defendant Gybson Thomas yeoman 657656 657656 Gybson, Thomas, of Denigh, yeoman 10
3945198 2005408 2005408 defendant Lowe Francis esq 640711 640711 together with Lowe, Francis, of Denbigh, esq 11

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