names

19 rows where place_id = 690369

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4084624 2054777 2054777 defendant Maners Edward yeoman 690369 690369 Maners, Edward, of Edlyngham, yeoman 3
4084627 2054777 2054777 defendant Gibison William yeoman 690369 690369 Gibison, William, of Edlyngham, yeoman 6
4084628 2054777 2054777 defendant Lighten John yeoman 690369 690369 Lighten, John, of Edlyngham, yeoman 7
4084629 2054777 2054777 defendant Barker James yeoman 690369 690369 Barker, James, of Edlyngham, yeoman 8
4084630 2054777 2054777 defendant Newton William yeoman 690369 690369 Newton, William, of Edlyngham, yeoman 9
4084632 2054778 2054778 defendant Erryngton William gent 690369 690369 Erryngton, William, of Edlyngham, gent 0
4084633 2054778 2054778 defendant Maners Edward yeoman 690369 690369 Maners, Edward, of Edlyngham, yeoman 1
4084634 2054778 2054778 defendant Gibison William yeoman 690369 690369 Gibison, William, of Edlyngham, yeoman 2
4084635 2054778 2054778 defendant Lighton Thomas yeoman 690369 690369 Lighton, Thomas, of Edlyngham, yeoman 3
4653931 2247136 2247136 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4653949 2247137 2247137 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4653967 2247138 2247138 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4653985 2247139 2247139 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4654003 2247140 2247140 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4654021 2247141 2247141 defendant Berker John yeoman 690369 690369 Berker, John, of Edlyngham, yeoman 8
4764212 2284799 2284799 defendant Pyngle Richard yeoman 690369 690369 Pyngle, Richard, of Edlyngham, yeoman 0
4764214 2284800 2284800 defendant Pyngle Richard   690369 690369 Pyngle, Richard, of Edlyngham, vicar 0
4788097 2292348 2292348 defendant Pyngle Richard clerk 690369 690369 Pyngle, Richard, of Edlyngham, clerk 0
4809653 2299184 2299184 defendant Barker William   690369 690369 Barker, William, of Edlyngham 2

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