names

19 rows where place_id = 596051

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622903 1874693 1874693 defendant Tame John merchant 596051 596051 Tame, John, of Fayreford, Glos, merchant 0
4324205 2138499 2138499 defendant Arden Virgil chapman 596051 596051 Arden, Virgil, of Fayreford, Glos, chapman 0
4786913 2291969 2291969 defendant Thame John chapman 596051 596051 Thame, John, of Fayreford, Glos, chapman 0
4866242 2316409 2316409 defendant Tame John   596051 596051 Tame, John, of Fayreford, Glos 0
4868099 2316995 2316995 defendant Tame John husbandman 596051 596051 Tame, John, of Fayreford, Glos, husbandman 0
4903651 2327758 2327758 defendant Thame John chapman 596051 596051 Thame, John, of Fayreford, Glos, chapman 0
4906164 2328519 2328519 defendant Thame John chapman 596051 596051 Thame, John, of Fayreford, Glos, chapman 0
4934963 2337340 2337340 defendant Thame John yeoman 596051 596051 Thame, John, of Fayreford, Glos, yeoman 0
4937561 2338121 2338121 defendant Thame John gent 596051 596051 Thame, John, of Fayreford, Glos, gent 3
4957037 2344058 2344058 defendant Baron Thomas husbandman 596051 596051 Baron, Thomas, of Fayreford, Glos, husbandman 18
5019881 2362692 2362692 defendant Tame John chapman 596051 596051 Tame, John, of Fayreford, Glos, chapman 0
5056139 2373412 2373412 defendant Baron Thomas husbandman 596051 596051 Baron, Thomas, of Fayreford, Glos, husbandman 0
5086319 2382390 2382390 defendant Martyn John miller 596051 596051 Martyn, John, of Fayreford, Glos, miller 1
5222850 2422395 2422395 defendant Tame John   596051 596051 (Tame, John, of Fayreford, Glos, franklin 4
5227232 2423596 2423596 plaintiff Tame John, junior woolman 596051 596051 Tame, John, junior, of Fayreford, Glos, woolman 0
5363822 2464336 2464336 defendant Pole William husbandman 596051 596051 Pole, William, of Fayreford, Glos, husbandman 0
5570912 2526050 2526050 defendant Mabley William yeoman 596051 596051 Mabley, William, of Fayreford, Glos, yeoman 0
5590200 2531907 2531907 defendant Broun John yeoman 596051 596051 Broun, John, of Fayreford, Glos, yeoman 1
5590203 2531908 2531908 defendant Broun John yeoman 596051 596051 Broun, John, of Fayreford, Glos, yeoman 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);