names

6 rows where place_id = 663958

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3970880 2014385 2014385 defendant Byde Robert yeoman 663958 663958 Byde, Robert, of Aylberton, Glos, yeoman 10
4025854 2033898 2033898 plaintiff Buck James gent 663958 663958 Buck, James, of Aylberton, Glos, gent 0
4025856 2033899 2033899 plaintiff Buck James gent 663958 663958 Buck, James, of Aylberton, Glos, gent 0
4187560 2091150 2091150 defendant Champneys Henry gent 663958 663958 Champneys, Henry, of Aylberton, Glos, gent 0
4787092 2292025 2292025 defendant Champeneyes John gent 663958 663958 Champeneyes, John, of Aylberton, Glos, gent 0
4980361 2351069 2351069 defendant Birdwode John, senior nailer 663958 663958 Birdwode, John, senior, of Aylberton, Glos, nailer 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);