names

16 rows where place_id = 798467

✎ 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
4762021 2284105 2284105 defendant Coupe William gent 798467 798467 Coupe, William, of Colshull, Warws, gent 1
4988770 2353597 2353597 defendant Corpeson Richard yeoman 798467 798467 Corpeson, Richard, of Colshull, Warws, yeoman 1
5156239 2402985 2402985 defendant Mountford Edmund   798467 798467 Mountford, Edmund, of Colshull, Warws, knight 0
5172503 2407683 2407683 defendant Mountford Edmund   798467 798467 Mountford, Edmund, of Colshull, Warws, knight 0
5192171 2413440 2413440 defendant Corall William   798467 798467 Corall, William, of Colshull, Warws, surgeon 1
5196136 2414614 2414614 defendant Burton Thomas yeoman 798467 798467 Burton, Thomas, of Colshull, Warws, yeoman 2
5196140 2414615 2414615 defendant Burton Thomas yeoman 798467 798467 Burton, Thomas, of Colshull, Warws, yeoman 2
5207654 2417978 2417978 defendant Corall William   798467 798467 Corall, William, of Colshull, Warws, surgeon 1
5209528 2418524 2418524 defendant Burton Thomas yeoman 798467 798467 Burton, Thomas, of Colshull, Warws, yeoman 2
5209532 2418525 2418525 defendant Burton Thomas yeoman 798467 798467 Burton, Thomas, of Colshull, Warws, yeoman 2
5387276 2471434 2471434 defendant Grene John smith 798467 798467 Grene, John, of Colshull, Warws, smith 1
5387279 2471434 2471434 defendant Taillour Thomas yeoman 798467 798467 Taillour, Thomas, of Colshull, Warws, yeoman 4
5399705 2475007 2475007 defendant Grene John smith 798467 798467 Grene, John, of Colshull, Warws, smith 0
5399709 2475009 2475009 defendant Taillour Thomas yeoman 798467 798467 Taillour, Thomas, of Colshull, Warws, yeoman 0
5411561 2478414 2478414 defendant Mounford Simon   798467 798467 Mounford, Simon, of Colshull, Warws, knight 0
5425882 2482702 2482702 defendant Mountford Simon   798467 798467 Mountford, Simon, of Colshull, Warws, knight 1

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