names

5 rows where place_id = 799055

✎ 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
4765309 2285134 2285134 defendant Carpenter John butcher 799055 799055 Carpenter, John, of West Hertyng, butcher 0
4916231 2331581 2331581 defendant Benke John husbandman 799055 799055 Benke, John, of West Hertyng, husbandman 1
5095504 2385103 2385103 defendant Bynke Jhn yeoman 799055 799055 Bynke, Jhn, of West Hertyng, yeoman 1
5113211 2390258 2390258 defendant atte Hole John husbandman 799055 799055 atte Hole, John, of West Hertyng, husbandman 10
5227048 2423568 2423568 defendant Wode John clerk 799055 799055 Wode, John, of West Hertyng, clerk 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);