names

3 rows where place_id = 835482

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ case_id role surname forename occupation place_id raw_segment seq
5015969 2361558 2361558 defendant Horsman William laborer 835482 835482 Horsman, William, of Helay juxta Masham, laborer 13
5015980 2361559 2361559 defendant Sawer William miller 835482 835482 Sawer, William, of Helay juxta Masham, miller 8
5057633 2373851 2373851 defendant Forster William shoemaker 835482 835482 Forster, William, of Helay juxta Masham, shoemaker 3

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