names

5 rows where place_id = 593431

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611805 1871355 1871355 defendant Skune Alexander yeoman 593431 593431 Skune, Alexander, of Flyxburghstather, yeoman 15
3611806 1871355 1871355 defendant Dubyng William laborer 593431 593431 Dubyng, William, of Flyxburghstather, laborer 16
3611807 1871355 1871355 defendant Haldesworth John yeoman 593431 593431 Haldesworth, John, of Flyxburghstather, yeoman 17
3611808 1871355 1871355 defendant Lyndesey Thomas laborer 593431 593431 Lyndesey, Thomas, of Flyxburghstather, laborer 18
3611809 1871355 1871355 defendant Dubyng John laborer 593431 593431 Dubyng, John, of Flyxburghstather, laborer 19

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