names

10 rows where place_id = 813608

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
4679869 2259310 2259310 defendant Rodeney Alice   813608 813608 Rodeney, Alice, of Shete, Devon, widow & formerly wife of John Rodeney, knight 0
4857511 2313736 2313736 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
4857513 2313737 2313737 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
4907343 2328858 2328858 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
4907347 2328860 2328860 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
5095250 2385029 2385029 defendant Grenefeld Thomas   813608 813608 Grenefeld, Thomas, of Shete, Devon, gent, dwelling with Bonvyle, William, knight 0
5126044 2394101 2394101 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
5179479 2409732 2409732 defendant Bonevyle William   813608 813608 Bonevyle, William, of Shete, Devon, knight 0
5225284 2423066 2423066 defendant Fortescu John gent 813608 813608 Fortescu, John, of Shete, Devon, gent 0
5246218 2429054 2429054 defendant Fortescu John gent 813608 813608 Fortescu, John, of Shete, Devon, gent 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);