names

13 rows where place_id = 778087

✎ 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
4651814 2246513 2246513 defendant atte Downe William husbandman 778087 778087 atte Downe, William, of Saltwode, Kent, husbandman 8
4652702 2246783 2246783 defendant Kempe Hugh husbandman 778087 778087 Kempe, Hugh, of Saltwode, Kent, husbandman 17
4675062 2257810 2257810 defendant Hoke Simon clerk 778087 778087 Hoke, Simon, of Saltwode, Kent, clerk 2
4708265 2267964 2267964 defendant Baldewyne John   778087 778087 Baldewyne, John, of Saltwode, Kent, wax chandler 0
4954997 2343451 2343451 defendant Sellyng Richard esq 778087 778087 Sellyng, Richard, of Saltwode, Kent, esq 1
4965675 2346658 2346658 defendant Sellyng Richard esq 778087 778087 Sellyng, Richard, of Saltwode, Kent, esq 0
4965678 2346659 2346659 defendant Sellyng Richard esq 778087 778087 Sellyng, Richard, of Saltwode, Kent, esq 0
5038387 2368116 2368116 defendant Stone Richard yeoman 778087 778087 Stone, Richard, of Saltwode, Kent, yeoman 0
5270569 2436487 2436487 defendant Sellyng John gent 778087 778087 Sellyng, John, of Saltwode, Kent, gent 2
5271189 2436669 2436669 defendant Sellyng John esq 778087 778087 Sellyng, John, of Saltwode, Kent, esq 3
5273219 2437236 2437236 defendant Sellyard John esq 778087 778087 Sellyard, John, of Saltwode, Kent, esq 0
5273222 2437237 2437237 defendant Sellyng John esq 778087 778087 Sellyng, John, of Saltwode, Kent, esq 0
5295843 2443775 2443775 defendant Sellyng John esq 778087 778087 Sellyng, John, of Saltwode, Kent, esq 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);