names

10 rows where place_id = 664353

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3972538 2014971 2014971 defendant Phelpott John husbandman 664353 664353 Phelpott, John, of Bushopston, husbandman 0
3972539 2014971 2014971 defendant Phelpott Nicholas husbandman 664353 664353 Phelpott, Nicholas, of Bushopston, husbandman 1
4068786 2049126 2049126 plaintiff Lambe John yeoman 664353 664353 Lambe, John, of Bushopston, yeoman 0
4155538 2080022 2080022 defendant Chamberlen John, junior gent 664353 664353 Chamberlen, John, junior, of Bushopston, gent 2
4221500 2103011 2103011 defendant Savacre Richard gent 664353 664353 Savacre, Richard, of Bushopston, gent 1
4230155 2106033 2106033 defendant Savacre Richard yeoman 664353 664353 Savacre, Richard, of Bushopston, yeoman 1
4340312 2143876 2143876 defendant Landecke William gent 664353 664353 Landecke, William, of Bushopston, gent 1
4340313 2143876 2143876 defendant William Griffin yeoman 664353 664353 William, Griffin, of Bushopston, yeoman 2
4376422 2156636 2156636 defendant Abraham Christopher yeoman 664353 664353 Abraham, Christopher, of Bushopston, yeoman 0
4406212 2166642 2166642 defendant Hawling Thomas yeoman 664353 664353 Hawling, Thomas, of Bushopston, yeoman 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);