names

13 rows where place_id = 594851

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617844 1873205 1873205 defendant Bonam John gent 594851 594851 Bonam, John, of Lacok, Wilts, gent 0
3667043 1915632 1915632 defendant Gervys Richard chapman 594851 594851 Gervys, Richard, of Lacok, Wilts, chapman 0
3777657 1950760 1950760 defendant Capper William yeoman 594851 594851 Capper, William, of Lacok, Wilts, yeoman 3
3986413 2019883 2019883 defendant Smyth William clothier 594851 594851 (Smyth, William, of Lacok, Wilts, clothier 1
4683054 2260316 2260316 defendant Selyman Robert taverner 594851 594851 Selyman, Robert, of Lacok, Wilts, taverner 0
4709727 2268401 2268401 defendant Cook John   594851 594851 Cook, John, of Lacok, Wilts, cook 0
4746989 2279622 2279622 defendant Draper John husbandman 594851 594851 Draper, John, of Lacok, Wilts, husbandman 1
4875330 2319240 2319240 defendant Ocbourne Walter   594851 594851 Ocbourne, Walter, of Lacok, Wilts, mason 0
4890964 2323911 2323911 defendant Hungerford Edmund   594851 594851 Hungerford, Edmund, of Lacok, Wilts, knight 2
5233696 2425442 2425442 defendant Strang John osteler 594851 594851 Strang, John, of Lacok, Wilts, osteler 2
5270660 2436519 2436519 defendant Croke John gent 594851 594851 Croke, John, of Lacok, Wilts, gent 0
5283422 2440207 2440207 defendant Croke John gent 594851 594851 Croke, John, of Lacok, Wilts, gent 0
5331633 2454543 2454543 defendant Croke John gent 594851 594851 Croke, John, of Lacok, Wilts, gent 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);