names

13 rows where case_id = 2386164

✎ 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
5099071 2386164 2386164 plaintiff Welbek John     Welbek, John 0
5099072 2386164 2386164 defendant Ade Thomas ostler 585869 585869 Ade, Thomas, of London, ostler 0
5099073 2386164 2386164 defendant Kynfeld Adam butcher 846207 846207 Kynfeld, Adam, of Kenyngton, Surrey, butcher 1
5099074 2386164 2386164 defendant Cyperton Nicholas butcher 607294 607294 Cyperton, Nicholas, of Magna Brikhill, Bucks, butcher 2
5099075 2386164 2386164 defendant Hervy Thomas yeoman 846208 846208 Hervy, Thomas, of Esthene or Estheve, Surrey, yeoman 3
5099076 2386164 2386164 defendant Kent John glover 590576 590576 Kent, John, of Assheburn, Derbs, glover 4
5099077 2386164 2386164 defendant Lowe Ralph laborer 588590 588590 Lowe, Ralph, of Assheburn, laborer 5
5099078 2386164 2386164 defendant Fende Robert carpenter 846209 846209 Fende, Robert, of Compedon, Derbs, carpenter 6
5099079 2386164 2386164 defendant Hill Richard husbandman 776157 776157 Hill, Richard, of Hertyngton, Derbs, husbandman 7
5099080 2386164 2386164 defendant Hoke Richard husbandman 846210 846210 together with Hoke, Richard, of Puttenhith, Surrey, husbandman 8
5099081 2386164 2386164 defendant Bocher Gilbert butcher 846211 846211 Bocher, Gilbert, of Puttenhith, butcher 9
5099082 2386164 2386164 defendant Bocher Richard waterman 846211 846211 Bocher, Richard, of Puttenhith, waterman 10
5099083 2386164 2386164 defendant Hoygge Henry chapman 607646 607646 Hoygge, Henry, of Whitchurche, Bucks, chapman 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);