names

13 rows where case_id = 2380625

✎ 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
5080378 2380625 2380625 plaintiff Clyderowe Roger esq   Clyderowe, Roger, esq 0
5080379 2380625 2380625 defendant Est Robert gent 589001 589001 Est, Robert, of Maydeston, gent 0
5080380 2380625 2380625 defendant Alphey John gent 591092 591092 Alphey, John, of Chedyngston, gent 1
5080381 2380625 2380625 defendant Clynton John esq 589487 589487 Clynton, John, of Folkeston, esq 2
5080382 2380625 2380625 defendant Baldewyn John yeoman 593912 593912 Baldewyn, John, of Asshe juxta Sandwich, yeoman 3
5080383 2380625 2380625 defendant Brokke John gent 589001 589001 Brokke, John, of Maydeston, gent 4
5080384 2380625 2380625 defendant Bukley William yeoman 589487 589487 Bukley, William, of Folkeston, yeoman 5
5080385 2380625 2380625 defendant Hykelyn John yeoman 590039 590039 Hykelyn, John, of Huntyngdon, yeoman 6
5080386 2380625 2380625 defendant Drele John yeoman 590039 590039 Drele, John, of Huntyngdon, yeoman 7
5080387 2380625 2380625 defendant Butteller William yeoman 590039 590039 Butteller, William, of Huntyngdon, yeoman 8
5080388 2380625 2380625 defendant Kays Thomas yeoman 589487 589487 Kays, Thomas, of Folkeston, yeoman 9
5080389 2380625 2380625 defendant Slegge Stephen gent 591492 591492 together with Slegge, Stephen, of Woldham, gent 10
5080390 2380625 2380625 defendant Yonge John yeoman 626876 626876 Yonge, John, of Westgate, Canterbury, 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);