names

17 rows where case_id = 2430040

✎ 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
5249715 2430040 2430040 plaintiff Vaus Robert     Vaus, Robert 0
5249716 2430040 2430040 plaintiff Forster Robert     Forster, Robert 1
5249717 2430040 2430040 defendant Conyers Christopher   864131 864131 Conyers, Christopher, of Sokburn, Durham, knight 0
5249718 2430040 2430040 defendant Topclyff John gent 864132 864132 Topclyff, John, of Saunby, Lincs, gent 1
5249719 2430040 2430040 defendant Barnburgh John gent 601657 601657 Barnburgh, John, of Doncaster, Yorks, gent 2
5249720 2430040 2430040 defendant Barley Thomas gent 864133 864133 Barley, Thomas, of Ladebury, Herts, gent 3
5249721 2430040 2430040 defendant Pymme Roger gent 693616 693616 Pymme, Roger, of Wollavyngton, Soms, gent 4
5249722 2430040 2430040 defendant Ulveston Richard gent 864134 864134 Ulveston, Richard, of Wangeford, Suff, gent 5
5249723 2430040 2430040 defendant Glemham John gent 652226 652226 Glemham, John, of Glemham, Suff, gent 6
5249724 2430040 2430040 defendant Perhale Humphrey esq 599562 599562 Perhale, Humphrey, of Knyghtley, Staffs, esq 7
5249725 2430040 2430040 defendant Mikelfeld Robert   587460 587460 Mikelfeld, Robert, of Sudbury, Suff, gebnt 8
5249726 2430040 2430040 defendant Curson Thomas gent 841774 841774 Curson, Thomas, of Croxhale, Derbs, gent 9
5249727 2430040 2430040 defendant Kellow John gent 587048 587048 Kellow, John, of Kellom, Notts, gent 10
5249728 2430040 2430040 defendant Dryland John gent 597142 597142 Dryland, John,of Wyngham, Kent, gent 11
5249729 2430040 2430040 defendant Ryngeurn Robert gent 612184 612184 Ryngeurn, Robert, of Parley, Hants, gent 12
5249730 2430040 2430040 defendant Paston John, junior gent 600104 600104 Paston, John, junior, of Paston, Norf, gent 13
5249731 2430040 2430040 defendant Norton George gent et al 590170 590170 Norton, George, of Merden, Kent, gent et al 14

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