names

15 rows where case_id = 2455437

✎ 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
5334668 2455437 2455437 plaintiff Foliambe Henry esq   Foliambe, Henry, esq 0
5334669 2455437 2455437 defendant Hybelyn John yeoman 625044 625044 Hybelyn, John, of Bankewell, yeoman 0
5334670 2455437 2455437 defendant Herryson Thomas yeoman 625044 625044 Herryson, Thomas, of Bankewell, yeoman 1
5334671 2455437 2455437 defendant Berdall Ralph husbandman 625044 625044 Berdall, Ralph, of Bankewell, husbandman 2
5334672 2455437 2455437 defendant Mader John husbandman 625044 625044 Mader, John, of Bankewell, husbandman 3
5334673 2455437 2455437 defendant Bonne Godfrey yeoman 625044 625044 Bonne, Godfrey, of Bankewell, yeoman 4
5334674 2455437 2455437 defendant Wolstroncrofte Thomas husbandman 625044 625044 Wolstroncrofte, Thomas, of Bankewell, husbandman 5
5334675 2455437 2455437 defendant Fleccher Richard husbandman 625044 625044 Fleccher, Richard, of Bankewell, husbandman 6
5334676 2455437 2455437 defendant Harryesson Roland husbandman 625044 625044 Harryesson, Roland, of Bankewell, husbandman 7
5334677 2455437 2455437 defendant Sheldon John husbandman 625044 625044 Sheldon, John, of Bankewell, husbandman 8
5334678 2455437 2455437 defendant Jacson John butcher 625044 625044 Jacson, John, of Bankewell, butcher 9
5334679 2455437 2455437 defendant Knolles Richard husbandman 625044 625044 Knolles, Richard, of Bankewell, husbandman 10
5334680 2455437 2455437 defendant Mader Roger husbandman 625044 625044 Mader, Roger, of Bankewell, husbandman 11
5334681 2455437 2455437 defendant Crichelowe John husbandman 625044 625044 Crichelowe, John, of Bankewell, husbandman 12
5334682 2455437 2455437 defendant Leom John husbandman 625044 625044 Leom, John, of Bankewell, husbandman 13

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