names

13 rows where place_id = 655522

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3936611 2002570 2002570 defendant Tutte Joan widow 655522 655522 Tutte, Joan, of Whitchurche, Hants, widow 0
4168480 2084461 2084461 defendant Butler John clothier 655522 655522 Butler, John, of Whitchurche, Hants, clothier 0
4176019 2087092 2087092 defendant Butler John clothier 655522 655522 Butler, John, of Whitchurche, Hants, clothier 0
4325412 2138878 2138878 plaintiff Carye Richard yeoman 655522 655522 Carye, Richard, of Whitchurche, Hants, yeoman 0
4378760 2157477 2157477 defendant Pearce John yeoman 655522 655522 Pearce, John, of Whitchurche, Hants, yeoman 0
4711472 2268919 2268919 defendant Groundy William husbandman 655522 655522 Groundy, William, of Whitchurche, Hants, husbandman 0
5085776 2382236 2382236 defendant Bodycot Richard chapman 655522 655522 Bodycot, Richard, of Whitchurche, Hants, chapman 2
5148024 2400567 2400567 defendant Felton Nicholas clerk 655522 655522 Felton, Nicholas, of Whitchurche, Hants, clerk 0
5158453 2403593 2403593 defendant Hunte William yeoman 655522 655522 Hunte, William, of Whitchurche, Hants, yeoman 2
5167488 2406221 2406221 defendant Felton Nicholas clerk 655522 655522 Felton, Nicholas, of Whitchurche, Hants, clerk 0
5174008 2408097 2408097 defendant Hunte William yeoman 655522 655522 Hunte, William, of Whitchurche, Hants, yeoman 2
5245234 2428760 2428760 defendant Hunt William yeoman 655522 655522 Hunt, William, of Whitchurche, Hants, yeoman 0
5245239 2428762 2428762 defendant Hunte William yeoman 655522 655522 Hunte, William, of Whitchurche, Hants, 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);