names

7 rows where place_id = 758826

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4457043 2187217 2187217 defendant Jely Thomas   758826 758826 Jely, Thomas, of Hoton in the Forest 0
4675295 2257883 2257883 defendant Canoun Robert de husbandman 758826 758826 Canoun, Robert de, of Hoton in the Forest, husbandman 2
4851700 2311965 2311965 defendant Burton John yeoman 758826 758826 Burton, John, of Hoton in the Forest, yeoman 0
4899602 2326514 2326514 defendant Hoton John gent 758826 758826 Hoton, John, of Hoton in the Forest, gent 2
4899621 2326514 2326514 defendant Cutbersom William yeoman 758826 758826 Cutbersom, William, of Hoton in the Forest, yeoman 21
5005964 2358646 2358646 defendant Wyseman John tailor 758826 758826 Wyseman, John, of Hoton in the Forest, tailor 5
5005994 2358649 2358649 defendant Wyseman Robert yeoman 758826 758826 Wyseman, Robert, of Hoton in the Forest, yeoman 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);