names

9 rows where place_id = 680870

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4042503 2039785 2039785 defendant Wathan Henry yeoman 680870 680870 Wathan, Henry, of Keynchurche, yeoman 0
4042504 2039785 2039785 defendant Wathan James yeoman 680870 680870 Wathan, James, of Keynchurche, yeoman 1
4131825 2071697 2071697 defendant William Hopkin sawyer 680870 680870 William, Hopkin, of Keynchurche, sawyer 1
4173688 2086251 2086251 defendant ap John William Thomas yeoman 680870 680870 ap John, William Thomas, of Keynchurche, yeoman 1
4173691 2086252 2086252 defendant ap John William Thomas yeoman 680870 680870 ap John, William Thomas, of Keynchurche, yeoman 1
4182585 2089385 2089385 defendant Charles Richard yeoman 680870 680870 Charles, Richard, of Keynchurche, yeoman 3
4190052 2092021 2092021 defendant Waytham John husbandman 680870 680870 Waytham, John, of Keynchurche, husbandman 1
4487314 2196748 2196748 defendant Skydmore John   680870 680870 Skydmore, John, of Keynchurche 0
4487320 2196749 2196749 plaintiff Skydmour John   680870 680870 Skydmour, John, of Keynchurche 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);