names

9 rows where place_id = 592247

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607082 1869879 1869879 defendant Causton or Canston Thomas yeoman 592247 592247 Causton or Canston, Thomas, of Tyllyngham, Essex, yeoman 0
3811254 1961416 1961416 defendant Bowen James yeoman 592247 592247 Bowen, James, of Tyllyngham, Essex, yeoman 0
3885116 1985278 1985278 defendant Stephyn Thomas yeoman 592247 592247 Stephyn, Thomas, of Tyllyngham, Essex, yeoman 11
4198338 2094969 2094969 defendant Legg Edward yeoman 592247 592247 Legg, Edward, of Tyllyngham, Essex, yeoman 1
4334013 2141656 2141656 defendant Steward Robert tailor 592247 592247 Steward, Robert, of Tyllyngham, Essex, tailor 4
5346758 2459144 2459144 defendant Tyrell Thomas esq 592247 592247 Tyrell, Thomas, of Tyllyngham, Essex, esq 0
5360390 2463282 2463282 defendant Pourte William yeoman 592247 592247 Pourte, William, of Tyllyngham, Essex, yeoman 0
5360399 2463286 2463286 defendant Pourt William yeoman 592247 592247 Pourt, William, of Tyllyngham, Essex, yeoman 0
5393626 2473238 2473238 defendant Sutton Thomas husbandman 592247 592247 Sutton, Thomas, of Tyllyngham, Essex, husbandman 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);