names

11 rows where place_id = 597695

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629489 1904077 1904077 defendant Cosyngton Thomas gent 597695 597695 Cosyngton, Thomas, of Aylysford, gent 0
3643475 1908385 1908385 defendant Buntyng James butcher 597695 597695 Buntyng, James, of Aylysford, butcher 0
3663155 1914393 1914393 defendant Gose Nicholas laborer 597695 597695 Gose, Nicholas, of Aylysford, laborer 1
3671681 1917129 1917129 defendant Cochett Thomas laborer 597695 597695 Cochett, Thomas, of Aylysford, laborer 0
3749535 1941767 1941767 defendant Clagate Geoffrey yeoman 597695 597695 Clagate, Geoffrey, of Aylysford, yeoman 0
3749536 1941767 1941767 defendant Thornton Richard yeoman 597695 597695 Thornton, Richard, of Aylysford, yeoman 1
3859811 1976781 1976781 defendant Thorneton Henry laborer 597695 597695 Thorneton, Henry, of Aylysford, laborer 1
4693061 2263336 2263336 defendant Baker Richard husbandman 597695 597695 Baker, Richard, of Aylysford, husbandman 2
5472177 2496644 2496644 defendant Culpepir William esq 597695 597695 Culpepir, William, of Aylysford, esq 0
5472178 2496644 2496644 defendant Culpepir Edward gent 597695 597695 Culpepir, Edward, of Aylysford, gent 1
5487844 2501252 2501252 defendant Smyth William husbandman 597695 597695 Smyth, William, of Aylysford, husbandman 4

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