names

19 rows where case_id = 2285866

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4767645 2285866 2285866 plaintiff Mauleverer Robert     Mauleverer, Robert 0
4767646 2285866 2285866 defendant Wright Roger yeoman 593653 593653 Wright, Roger, of Polyngton, yeoman 0
4767647 2285866 2285866 defendant Goldale John yeoman 799462 799462 Goldale, John, of Hensale, yeoman 1
4767648 2285866 2285866 defendant Balne Thomas yeoman 587101 587101 Balne, Thomas, of Snayth, yeoman 2
4767649 2285866 2285866 defendant Barbour William yeoman 587101 587101 Barbour, William, of Snayth, yeoman 3
4767650 2285866 2285866 defendant Sharp Richard tailor 587101 587101 Sharp, Richard, of Snayth, tailor 4
4767651 2285866 2285866 defendant Lyndlay William yeoman 595156 595156 Lyndlay, William, of Cowyk, yeoman 5
4767652 2285866 2285866 defendant Jollan John porter 595156 595156 Jollan, John, of Cowyk, porter 6
4767653 2285866 2285866 defendant Perton Robert clerk 799463 799463 Perton, Robert, of Metam, clerk 7
4767654 2285866 2285866 defendant Manyngham Richard yeoman 587101 587101 Manyngham, Richard, of Snayth, yeoman 8
4767655 2285866 2285866 defendant Passelewe John yeoman 799463 799463 Passelewe, John, of Metam, yeoman 9
4767656 2285866 2285866 defendant Best Thomas yeoman 616809 616809 Best, Thomas, of Yokflete, yeoman 10
4767657 2285866 2285866 defendant Cowyk John de gent 595156 595156 Cowyk, John de, of Cowyk, gent 11
4767658 2285866 2285866 defendant Darnald Thomas gent 595156 595156 Darnald, Thomas, of Cowyk, gent 12
4767659 2285866 2285866 defendant Brok John yeoman 753410 753410 Brok, John, of Rouclyf, yeoman 13
4767660 2285866 2285866 defendant Fyssher William potter 595156 595156 Fyssher, William, of Cowyk, potter 14
4767661 2285866 2285866 defendant Cok Thomas yeoman 593550 593550 Cok, Thomas, of Polyng, yeoman 15
4767662 2285866 2285866 defendant Robynson John yeoman 632010 632010 Robynson, John, of Balne, yeoman 16
4767663 2285866 2285866 defendant Bukshawe William husbandman 764534 764534 Bukshawe, William, of Thornour, husbandman 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);