names

13 rows where case_id = 2373725

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5057172 2373725 2373725 plaintiff Clyderowe Roger esq   Clyderowe, Roger, esq 0
5057173 2373725 2373725 defendant Slegge Stephen gent 591492 591492 Slegge, Stephen, of Woldham, gent 0
5057174 2373725 2373725 defendant Est Robert gent 589001 589001 Est, Robert, of Maydeston, gent 1
5057175 2373725 2373725 defendant Yonge John yeoman 626876 626876 Yonge, John, of Westgate, Canterbury, yeoman 2
5057176 2373725 2373725 defendant Brokke John gent 589001 589001 Brokke, John, of Maydeston, gent 3
5057177 2373725 2373725 defendant Bukley William yeoman 589487 589487 Bukley, William, of Folkeston, yeoman 4
5057178 2373725 2373725 defendant Hykelyn John yeoman 590039 590039 Hykelyn, John, of Huntyngdon, yeoman 5
5057179 2373725 2373725 defendant Drele John yeoman 590039 590039 Drele, John, of Huntyngdon, yeoman 6
5057180 2373725 2373725 defendant Butteller William yeoman 590039 590039 Butteller, William, of Huntyngdon, yeoman 7
5057181 2373725 2373725 defendant Kays Thomas yeoman 589487 589487 Kays, Thomas, of Folkeston, yeoman 8
5057182 2373725 2373725 defendant Alphey John gent 591092 591092 together with Alphey, John, of Chedyngston, gent 9
5057183 2373725 2373725 defendant Clynton John esq 589487 589487 Clynton, John, of Folkeston, esq 10
5057184 2373725 2373725 defendant Baldewyn John yeoman 841214 841214 Baldewyn, John, of Assge juxta Sandwich, yeoman 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);