names

15 rows where case_id = 2526472

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5572400 2526472 2526472 plaintiff Mordaunt William     Mordaunt, William 0
5572401 2526472 2526472 defendant Shirley Ralph   860151 860151 Shirley, Ralph, of Oulep, Leics, knight 0
5572402 2526472 2526472 defendant Brighous George   901514 901514 Brighous, George, of Tanshelf, Yorks, yeoman, son of Brighous, John 1
5572403 2526472 2526472 defendant Pope John gent 835741 835741 Pope, John, of Bukstede, Sussex, gent 2
5572404 2526472 2526472 defendant Wheler Walter gent 586058 586058 Wheler, Walter, of Enfeld, Middx, gent 3
5572405 2526472 2526472 defendant Asshburnham Thomas esq 611673 611673 Asshburnham, Thomas, of Gestlyng, Sussex, esq 4
5572406 2526472 2526472 defendant Savage John, senior knight   Savage, John, senior, knight, executors of 5
5572407 2526472 2526472 defendant Dalby Thomas clerk 586067 586067 (Dalby, Thomas, of York, clerk 6
5572408 2526472 2526472 defendant Magnus Thomas clerk 586067 586067 Magnus, Thomas, of York, clerk 7
5572409 2526472 2526472 defendant Lowes Richard (legal representative)   Lowes, Richard, executor of 8
5572410 2526472 2526472 defendant Lowes William husbandman 901515 901515 Lowes, William, of Asshmynhowe, Norf, husbandman 9
5572411 2526472 2526472 defendant Bettys John (legal representative)   Bettys, John, executor of 10
5572412 2526472 2526472 defendant Bettys Thomas yeoman 901516 901516 Bettys, Thomas, of South Erpyngham, Norf, yeoman 11
5572413 2526472 2526472 defendant Smyth Richard (legal representative)   Smyth, Richard, executor of 12
5572414 2526472 2526472 defendant Smyth Thomas husbandman 626418 626418 Smyth, Thomas, of Long Benyngton, Lincs, husbandman 13

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