names

15 rows where case_id = 2358845

✎ 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
5006647 2358845 2358845 plaintiff Shirley Ralph knight   Shirley, Ralph, knight 0
5006648 2358845 2358845 defendant Bate John yeoman 588590 588590 Bate, John, of Assheburn, yeoman 0
5006649 2358845 2358845 defendant Coken John esq 588590 588590 Coken, John, of Assheburn, esq 1
5006650 2358845 2358845 defendant Verun Thurstan esq 588590 588590 Verun, Thurstan, of Assheburn, esq 2
5006651 2358845 2358845 defendant Godeale John yeoman 588590 588590 Godeale, John, of Assheburn, yeoman 3
5006652 2358845 2358845 defendant Adlyne William smith 834044 834044 Adlyne, William, of Asshebufn, smith 4
5006653 2358845 2358845 defendant Derby Nichoals   588590 588590 Derby, Nichoals, of Assheburn, glove maker 5
5006654 2358845 2358845 defendant Fricer Thomas fricer 588590 588590 Fricer, Thomas, of Assheburn, fricer 6
5006655 2358845 2358845 defendant Dunton John weaver 588590 588590 Dunton, John, of Assheburn, weaver 7
5006656 2358845 2358845 defendant Bayle John yeoman 588590 588590 Bayle, John,of Assheburn, yeoman 8
5006657 2358845 2358845 defendant Brendwode Robert yeoman 588590 588590 Brendwode, Robert, of Assheburn, yeoman 9
5006658 2358845 2358845 defendant Damport Thomas mercer 588590 588590 Damport, Thomas, of Assheburn, mercer 10
5006659 2358845 2358845 defendant Coke John yeoman 588590 588590 Coke, John, of Assheburn, yeoman 11
5006660 2358845 2358845 defendant Borowes Henry laborer 834046 834046 Borowes, Henry, of Axsheburn, laborer 12
5006661 2358845 2358845 defendant Derby William   588590 588590 Derby, William, of Assheburn, glove maker 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);