names

8 rows where place_id = 643441

✎ 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
3873772 1981449 1981449 defendant Spycer Thomas husbandman 643441 643441 Spycer, Thomas, of Hokham, Norf, husbandman 0
3873776 1981450 1981450 defendant Spycer Thomas husbandman 643441 643441 Spycer, Thomas, of Hokham, Norf, husbandman 1
4731953 2275171 2275171 defendant Baxster Thomas baker 643441 643441 Baxster, Thomas, of Hokham, Norf, baker 10
4930625 2335985 2335985 defendant Hokham Peter gent 643441 643441 Hokham, Peter, of Hokham, Norf, gent 0
5517559 2510333 2510333 defendant Barsham John mercer 643441 643441 Barsham, John, of Hokham, Norf, mercer 0
5544598 2518419 2518419 defendant Purdy Peter   643441 643441 Purdy, Peter, of Hokham, Norf, tallow chandler 3
5572933 2526632 2526632 defendant Bele Thomas yeoman 643441 643441 Bele, Thomas, of Hokham, Norf, yeoman 2
5601079 2535224 2535224 defendant Ballys Richard warrener 643441 643441 Ballys, Richard, of Hokham, Norf, warrener 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);