names

12 rows where case_id = 2521380

✎ 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
5554596 2521380 2521380 plaintiff Hobart James     Hobart, James 0
5554597 2521380 2521380 defendant Pygot Thomas bishop of Bangor   Pygot, Thomas, bishop of Bangor 0
5554598 2521380 2521380 defendant Botry William merchant 585869 585869 Botry William, of London, merchant 1
5554599 2521380 2521380 defendant Clapton Hugh merchant 585869 585869 Clapton, Hugh, of London, merchant 2
5554600 2521380 2521380 defendant Habraham Henry merchant 585869 585869 Habraham, Henry, of London, merchant 3
5554601 2521380 2521380 defendant Arowsmyth Edward yeoman 899528 899528 Arowsmyth, Edward, of Nw Wyndesore, yeoman 4
5554602 2521380 2521380 defendant Skelton Bernard gent 589712 589712 Skelton, Bernard, of New Wyndesore, gent 5
5554603 2521380 2521380 defendant Pasche Richard yeoman 589712 589712 Pasche, Richard, of New Wyndesore, yeoman 6
5554604 2521380 2521380 defendant A Wode Robert yeoman 589712 589712 A Wode, Robert, of New Wyndesore, yeoman 7
5554605 2521380 2521380 defendant Harryson John yeoman 585869 585869 Harryson, John, of London, yeoman 8
5554606 2521380 2521380 defendant Moryng Robert yeoman 589282 589282 Moryng, Robert, of Chertesey, Surrey, yeoman 9
5554607 2521380 2521380 defendant Ferrour John yeoman 899529 899529 Ferrour, John, of Old Wydesore, yeoman 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);