names

13 rows where case_id = 2386166

✎ 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
5099095 2386166 2386166 plaintiff Welbek John     Welbek, John 0
5099096 2386166 2386166 defendant Kynfeld Adam butcher 846207 846207 Kynfeld, Adam, of Kenyngton, Surrey, butcher 0
5099097 2386166 2386166 defendant Typerton Nicholas butcher 600314 600314 Typerton, Nicholas, of Magna Brykhyll, Bucks, butcher 1
5099098 2386166 2386166 defendant Hervy Thomas yeoman 846213 846213 Hervy, Thomas, of Eschem, Surrey, yeoman 2
5099099 2386166 2386166 defendant Kent John glover 590576 590576 Kent,John, of Assheburn, Derbs, glover 3
5099100 2386166 2386166 defendant Lowe Ralph laborer 588590 588590 Lowe, Ralph, of Assheburn, laborer 4
5099101 2386166 2386166 defendant Fenton Robert carpenter 846209 846209 Fenton, Robert, of Compedon, Derbs, carpenter 5
5099102 2386166 2386166 defendant Hyll Richard husbandman 776157 776157 Hyll, Richard, of Hertyngton, Derbs, husbandman 6
5099103 2386166 2386166 defendant Hoygge Henry chapman 607646 607646 Hoygge, Henry, of Whitchurche, Bucks, chapman 7
5099104 2386166 2386166 defendant Hoke Richard husbandman 846210 846210 Hoke, Richard, of Puttenhith, Surrey, husbandman 8
5099105 2386166 2386166 defendant Bocher Gilbert bytcher 846211 846211 Bocher, Gilbert, of Puttenhith, bytcher 9
5099106 2386166 2386166 defendant Bocher Richard waterman 846211 846211 Bocher, Richard, of Puttenhith, waterman 10
5099107 2386166 2386166 defendant Ade Thomas ostler 585869 585869 Ade, Thomas, of London, ostler 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);