names

18 rows where case_id = 2429661

✎ 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
5248386 2429661 2429661 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5248387 2429661 2429661 defendant Spycer John yeoman 764707 764707 Spycer, John, of Hokenall, yeoman 0
5248388 2429661 2429661 defendant Skalgresse Richard yeoman 764707 764707 Skalgresse, Richard, of Hokenall, yeoman 1
5248389 2429661 2429661 defendant Gemme John, senior husbandman 764707 764707 Gemme, John, senior, of Hokenall, husbandman 2
5248390 2429661 2429661 defendant Gemme John, junior husbandman 764707 764707 Gemme, John, junior, of Hokenall, husbandman 3
5248391 2429661 2429661 defendant Lytill Robert yeoman 764707 764707 Lytill, Robert, of Hokenall, yeoman 4
5248392 2429661 2429661 defendant Wryght William     Wryght, William 5
5248393 2429661 2429661 defendant Sprey Roger     Sprey, Roger 6
5248394 2429661 2429661 defendant Nelson Christopher     Nelson, Christopher 7
5248395 2429661 2429661 defendant Brewode Robert     Brewode, Robert 8
5248396 2429661 2429661 defendant Cleye Agnes     Cleye, Agnes 9
5248397 2429661 2429661 defendant Chamberleyn Richad     Chamberleyn, Richad 10
5248398 2429661 2429661 defendant Wright Robert     Wright, Robert 11
5248399 2429661 2429661 defendant Lytster John     Lytster, John 12
5248400 2429661 2429661 defendant Anydon William     Anydon, William 13
5248401 2429661 2429661 defendant Parkende Robert     Parkende, Robert 14
5248402 2429661 2429661 defendant Shawe Henry     Shawe, Henry 15
5248403 2429661 2429661 defendant Strutte John et al     Strutte, John et al 16

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