names

14 rows where place_id = 615858

✎ 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
3711147 1929799 1929799 defendant Jermyn William yeoman 615858 615858 Jermyn, William, of Rayleigh, yeoman 0
3711772 1929997 1929997 defendant Aleyn Thomas yeoman 615858 615858 Aleyn, Thomas, of Rayleigh, yeoman 0
3827747 1966545 1966545 defendant Aleyn John (legal representative) 615858 615858 Aleyn, John, of Rayleigh, gent, executor of 1
3843631 1971542 1971542 defendant Aleyn Thomas gent 615858 615858 Aleyn, Thomas, of Rayleigh, gent 0
3850063 1973610 1973610 defendant Cawston Thomas yeoman 615858 615858 Cawston, Thomas, of Rayleigh, yeoman 0
3920670 1997263 1997263 defendant Cawston Thomas yeoman 615858 615858 Cawston, Thomas, of Rayleigh, yeoman 0
3925529 1998848 1998848 defendant Cawston Thomas yeoman 615858 615858 Cawston, Thomas, of Rayleigh, yeoman 0
3925531 1998849 1998849 defendant Cawston Thomas yeoman 615858 615858 Cawston, Thomas, of Rayleigh, yeoman 0
4212904 2100042 2100042 defendant Mone Edward gent 615858 615858 Mone, Edward, of Rayleigh, gent 3
4223313 2103647 2103647 defendant Paperell John carpenter 615858 615858 Paperell, John, of Rayleigh, yeoman, carpenter 0
4385792 2159939 2159939 defendant Brett Agnes spinster 615858 615858 Brett, Agnes, of Rayleigh, spinster 3
4398583 2164106 2164106 defendant Harrison Richard yeoman 615858 615858 Harrison, Richard, of Rayleigh, yeoman 0
4410723 2168177 2168177 defendant Ford John beer brewer 615858 615858 Ford, John, of Rayleigh, beer brewer 0
4410725 2168178 2168178 defendant Ford John beer brewer 615858 615858 Ford, John, of Rayleigh, beer brewer 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);