names

4 rows where place_id = 783487

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4682437 2260129 2260129 defendant Greneak Willalim clerk 783487 783487 Greneak, Willalim, of Norburgh, Leics, clerk 0
5165163 2405555 2405555 defendant Broun John yeoman 783487 783487 Broun, John, of Norburgh, Leics, yeoman 10
5322828 2451908 2451908 defendant Mylner William miller 783487 783487 Mylner, William, of Norburgh, Leics, miller 3
5322833 2451909 2451909 defendant Milner William miller 783487 783487 Milner, William, of Norburgh, Leics, miller 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);