names

13 rows where place_id = 587856

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592630 1865308 1865308 defendant Hampden Edmund esq 587856 587856 Hampden, Edmund, of Wodstoke, Oxon, esq 0
3656465 1912269 1912269 defendant Chamberleyn Edward   587856 587856 Chamberleyn, Edward, of Wodstoke, Oxon, knight 0
3695160 1924707 1924707 defendant Nowers Thomas gent 587856 587856 Nowers, Thomas, of Wodstoke, Oxon, gent 0
3809131 1960740 1960740 defendant Chamberleyn Edward   587856 587856 Chamberleyn, Edward, of Wodstoke, Oxon, knight 0
3983960 2019031 2019031 defendant Gannon John clothier 587856 587856 Gannon, John, of Wodstoke, Oxon, clothier 0
4903530 2327716 2327716 defendant Blakenale John dyer 587856 587856 Blakenale, John, of Wodstoke, Oxon, dyer 0
5327063 2453170 2453170 defendant Monmouth John chapman 587856 587856 Monmouth, John, of Wodstoke, Oxon, chapman 2
5338024 2456458 2456458 defendant Monmuth John chapman 587856 587856 Monmuth, John, of Wodstoke, Oxon, chapman 2
5375043 2467785 2467785 defendant Wysseman John mercer 587856 587856 Wysseman, John, of Wodstoke, Oxon, mercer 0
5396702 2474149 2474149 defendant Wyseman John chapman 587856 587856 Wyseman, John, of Wodstoke, Oxon, chapman 0
5403321 2476025 2476025 defendant Wyseman John chapman 587856 587856 Wyseman, John, of Wodstoke, Oxon, chapman 0
5534528 2515345 2515345 defendant Hampden Edmund gent 587856 587856 Hampden, Edmund, of Wodstoke, Oxon, gent 4
5600043 2534895 2534895 defendant Chamberleyn Edward esq 587856 587856 Chamberleyn, Edward, of Wodstoke, Oxon, esq 1

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