names

14 rows where case_id = 1916182

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668805 1916182 1916182 plaintiff Bampton Robert abbot of St Agatha Abbey by Richmond   Bampton, Robert, abbot of St Agatha Abbey by Richmond 0
3668806 1916182 1916182 defendant Besse Richard yeoman 590061 590061 Besse, Richard, of Barton, yeoman 0
3668807 1916182 1916182 defendant Robynson John husbandman 590061 590061 Robynson, John, of Barton, husbandman 1
3668808 1916182 1916182 defendant Valiande Simon husbandman 590061 590061 Valiande, Simon, of Barton, husbandman 2
3668809 1916182 1916182 defendant Peirson Robert husbandman 590061 590061 Peirson, Robert, of Barton, husbandman 3
3668810 1916182 1916182 defendant Grethede Richard husbandman 590061 590061 Grethede, Richard, of Barton, husbandman 4
3668811 1916182 1916182 defendant Thomson John laborer 590061 590061 Thomson, John, of Barton, laborer 5
3668812 1916182 1916182 defendant Wyseman James laborer 590061 590061 Wyseman, James, of Barton, laborer 6
3668813 1916182 1916182 defendant Henne Richard weaver 590061 590061 Henne, Richard, of Barton, weaver 7
3668814 1916182 1916182 defendant Ottryngton Robert laborer 590061 590061 Ottryngton, Robert, of Barton, laborer 8
3668815 1916182 1916182 defendant Robynson Thomas laborer 590061 590061 Robynson, Thomas, of Barton, laborer 9
3668816 1916182 1916182 defendant Taillour Robert laborer 590061 590061 Taillour, Robert, of Barton, laborer 10
3668817 1916182 1916182 defendant Peirson William laborer 590061 590061 Peirson, William, of Barton, laborer 11
3668818 1916182 1916182 defendant Smyth Hugh smith 590061 590061 Smyth, Hugh, of Barton, smith 12

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