names

9 rows where place_id = 698919

✎ 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
4126467 2069749 2069749 defendant Sawyer or Sayer Thomas clerk 698919 698919 Sawyer or Sayer, Thomas, of Wrabnes, clerk 0
4184618 2090130 2090130 defendant Marvyn Edward husbandman 698919 698919 Marvyn, Edward, of Wrabnes, husbandman 1
4217065 2101462 2101462 defendant Godfrey Edward yeoman 698919 698919 Godfrey, Edward, of Wrabnes, yeoman 0
4221762 2103107 2103107 defendant Sayer Thomas clerk 698919 698919 Sayer, Thomas, of Wrabnes, clerk 0
4247476 2112140 2112140 defendant Sayer Thomas clerk 698919 698919 Sayer, Thomas, of Wrabnes, clerk 0
4278539 2122429 2122429 defendant Godfrey Edward yeoman 698919 698919 Godfrey, Edward, of Wrabnes, yeoman 0
4282386 2123739 2123739 defendant Godfrye Edward yeoman 698919 698919 Godfrye, Edward, of Wrabnes, yeoman 0
4377434 2157004 2157004 defendant Godfrey Edward yeoman 698919 698919 Godfrey, Edward, of Wrabnes, yeoman 0
4378866 2157517 2157517 defendant Godfrey Edward   698919 698919 Godfrey, Edward, of Wrabnes 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);