names

9 rows where place_id = 619741

✎ 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
3731684 1936139 1936139 defendant Mapleton Robert butcher 619741 619741 Mapleton, Robert, of Depyng St James, butcher 0
3850487 1973740 1973740 defendant Derby William laborer 619741 619741 Derby, William, of Depyng St James, laborer 0
3870290 1980313 1980313 defendant Frances William fisher 619741 619741 Frances, William, of Depyng St James, fisher 0
3870655 1980427 1980427 defendant Androwe Alan fisher 619741 619741 Androwe, Alan, of Depyng St James, fisher 0
3884381 1985044 1985044 defendant Andrewe Alan fisher 619741 619741 Andrewe, Alan, of Depyng St James, fisher 0
3892568 1987756 1987756 defendant Cook William husbandman 619741 619741 Cook, William, of Depyng St James, husbandman 0
3897060 1989236 1989236 defendant Mason Humphrey tailor 619741 619741 Mason, Humphrey, of Depyng St James, tailor 0
3984355 2019160 2019160 defendant Buck John yeoman 619741 619741 Buck, John, of Depyng St James, yeoman 19
5351060 2460437 2460437 defendant Bocher Richard husbandman 619741 619741 Bocher, Richard, of Depyng St James, husbandman 6

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