names

19 rows where case_id = 2293612

✎ 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
4792025 2293612 2293612 plaintiff Mauleverer Robert esq   Mauleverer, Robert, esq 0
4792026 2293612 2293612 defendant de Cowyk John gent 595156 595156 de Cowyk, John, of Cowyk, gent 0
4792027 2293612 2293612 defendant Darnald Thomas gent 595156 595156 Darnald, Thomas, of Cowyk, gent 1
4792028 2293612 2293612 defendant Wryght Roger yeoman 593653 593653 Wryght, Roger, of Polyngton, yeoman 2
4792029 2293612 2293612 defendant Goldale John yeoman 799462 799462 Goldale, John, of Hensale, yeoman 3
4792030 2293612 2293612 defendant Balne Thomas yeoman 587101 587101 Balne, Thomas, of Snayth, yeoman 4
4792031 2293612 2293612 defendant Barbour William yeoman 587101 587101 Barbour, William, of Snayth, yeoman 5
4792032 2293612 2293612 defendant Sharp Richard tailor 587101 587101 Sharp, Richard, of Snayth, tailor 6
4792033 2293612 2293612 defendant Lyndlay William yeoman 595156 595156 Lyndlay, William, of Cowyk, yeoman 7
4792034 2293612 2293612 defendant Jallan John porter 595156 595156 Jallan, John, of Cowyk, porter 8
4792035 2293612 2293612 defendant Person Robert clerk 799463 799463 Person, Robert, of Metam, clerk 9
4792036 2293612 2293612 defendant Manyngham Richard yeoman 587101 587101 Manyngham, Richard, of Snayth, yeoman 10
4792037 2293612 2293612 defendant Passelewe John yeoman 799463 799463 Passelewe, John, of Metam, yeoman 11
4792038 2293612 2293612 defendant Best Thomas yeoman 616809 616809 Best, Thomas, of Yokflete, yeoman 12
4792039 2293612 2293612 defendant Brok John yeoman 753410 753410 Brok, John, of Rouclyf, yeoman 13
4792040 2293612 2293612 defendant Fyssher William potter 595156 595156 Fyssher, William, of Cowyk, potter 14
4792041 2293612 2293612 defendant Cok Thomas yeoman 593653 593653 Cok, Thomas, of Polyngton, yeoman 15
4792042 2293612 2293612 defendant Robynson John yeoman 632010 632010 Robynson, John, of Balne, yeoman 16
4792043 2293612 2293612 defendant Bukshawe William husbandman 802908 802908 Bukshawe, William, of Thornoure, 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);