names

13 rows where case_id = 2329476

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4909385 2329476 2329476 plaintiff Barton William     Barton, William 0
4909386 2329476 2329476 defendant Wyvell William esq 590359 590359 Wyvell, William, of Stonton, esq 0
4909387 2329476 2329476 defendant Wyvell Thomas Stonton, esq   Wyvell, Thomas, Stonton, esq 1
4909388 2329476 2329476 defendant Langeford Gregory esq 820404 820404 Langeford, Gregory, of Langeford, Derbs, esq 2
4909389 2329476 2329476 defendant Langeford Henry esq 753366 753366 Langeford, Henry, of Langeford, esq 3
4909390 2329476 2329476 defendant Barker William yeoman 590359 590359 Barker, William, of Stonton, yeoman 4
4909391 2329476 2329476 defendant Stavyll or Stabyll of Stonton yeoman   Stavyll or Stabyll, of Stonton, yeoman 5
4909392 2329476 2329476 defendant Brewester Richard yeoman 590359 590359 Brewester, Richard, of Stonton, yeoman 6
4909393 2329476 2329476 defendant Brewester John yeoman 590359 590359 Brewester, John, of Stonton, yeoman 7
4909394 2329476 2329476 defendant Crake Thomas yeoman 820405 820405 Crake, Thomas, of Gloweston, yeoman 8
4909395 2329476 2329476 defendant Bartilby William yeoman 820405 820405 Bartilby, William, of Gloweston, yeoman 9
4909396 2329476 2329476 defendant Crkae Hugh yeoman 820405 820405 Crkae, Hugh, of Gloweston, yeoman 10
4909397 2329476 2329476 defendant Petyvere William   820406 820406 Petyvere, William, of Stonton, serant 11

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