names

12 rows where case_id = 2038295

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4038182 2038295 2038295 plaintiff Lakyn Miles gent, attorney of the Bench   Lakyn, Miles, gent, attorney of the Bench 0
4038183 2038295 2038295 defendant Wyseman Robert gent 602938 602938 Wyseman, Robert, of Est Grenewiche, Kent, gent 0
4038184 2038295 2038295 defendant Harvy John gent 679924 679924 Harvy, John, of Tower of London, Middx, gent 1
4038185 2038295 2038295 defendant Hyll Richard gent 669055 669055 Hyll, Richard, of Heybridge, Essex, gent 2
4038186 2038295 2038295 defendant Lloyd Griffin gent 679925 679925 Lloyd, Griffin, of Gylfyld, Montgomery, gent 3
4038187 2038295 2038295 defendant Fylby Robert yeoman 679926 679926 Fylby, Robert, of Moulton, Norf, yeoman 4
4038188 2038295 2038295 defendant Pawne William gent 679927 679927 Pawne, William, of Hygh Ongar, Essex, gent 5
4038189 2038295 2038295 defendant Bodye John gent 635857 635857 Bodye, John, of Rayleygh, Essex, gent 6
4038190 2038295 2038295 defendant Myll Richard sawyer 632040 632040 Myll, Richard, of Walton, Essex, sawyer 7
4038191 2038295 2038295 defendant Rivett John yeoman 679928 679928 Rivett, John, of Tendring, Essex, yeoman 8
4038192 2038295 2038295 defendant Massy William gent 589772 589772 Massy, William, of Barkyng, Essex, gent 9
4038193 2038295 2038295 defendant Lake Richard husbandman 679929 679929 Lake, Richard, of Southweld, Essex, husbandman 10

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