names

17 rows where place_id = 641729

✎ 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
3863519 1977994 1977994 defendant Hynley John clerk 641729 641729 Hynley, John, of Shelve, clerk 0
4108315 2063235 2063235 defendant Underwood Thomas husbandman 641729 641729 Underwood, Thomas, of Shelve, husbandman 3
4108316 2063235 2063235 defendant Warde Thomas husbandman 641729 641729 Warde, Thomas, of Shelve, husbandman 4
4119043 2067094 2067094 defendant Underwood Thomas yeoman 641729 641729 Underwood, Thomas, of Shelve, yeoman 0
4119044 2067094 2067094 defendant Warde Thomas yeoman 641729 641729 Warde, Thomas, of Shelve, yeoman 1
4334100 2141685 2141685 defendant Harper Anthony gent 641729 641729 Harper, Anthony, of Shelve, gent 0
4472423 2192044 2192044 defendant Baker John   641729 641729 Baker, John, of Shelve 1
4658158 2248430 2248430 defendant Wyllys John yeoman 641729 641729 Wyllys, John, of Shelve, yeoman 0
4658159 2248430 2248430 defendant Walton Thomas yeoman 641729 641729 Walton, Thomas, of Shelve, yeoman 1
4658160 2248430 2248430 defendant Dodde John parter 641729 641729 Dodde, John, of Shelve, parter 2
4658163 2248431 2248431 defendant Wyllys John yeoman 641729 641729 Wyllys, John, of Shelve, yeoman 0
4658165 2248431 2248431 defendant Dodde John porter 641729 641729 Dodde, John, of Shelve, porter 2
4668427 2255837 2255837 defendant Bolt Simon husbandman 641729 641729 Bolt, Simon, of Shelve, husbandman 3
4706763 2267499 2267499 defendant Beneyt Thomas   641729 641729 Beneyt, Thomas, of Shelve, parson 0
4909491 2329504 2329504 defendant Bent Roger yeoman 641729 641729 Bent, Roger, of Shelve, yeoman 1
4909495 2329505 2329505 defendant Bent Roger yeoman 641729 641729 Bent, Roger, of Shelve, yeoman 1
5608550 2537574 2537574 defendant Taillour Ewylym   641729 641729 Taillour, Ewylym, of Shelve 0

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