names

20 rows where case_id = 2257410

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4673723 2257410 2257410 plaintiff de la Pole Michael (legal representative) 794974 794974 de la Pole, Michael, of Suffolk, Earl, executors of 0
4673724 2257410 2257410 plaintiff de la Pole Katherine formerly wife of Testator   (de la Pole, Katherine, formerly wife of Testator 1
4673725 2257410 2257410 plaintiff de la Pole Edmund knight   de la Pole, Edmund, knight 2
4673726 2257410 2257410 plaintiff de la Pole Walter knight   de la Pole, Walter, knight 3
4673727 2257410 2257410 plaintiff Staverton John     Staverton, John 4
4673728 2257410 2257410 plaintiff Bolton Robert de clerk   Bolton, Robert de, clerk 5
4673729 2257410 2257410 plaintiff Frampton Thomas clerk   Frampton, Thomas, clerk 6
4673730 2257410 2257410 plaintiff Drury Edmund clerk   Drury, Edmund, clerk 7
4673731 2257410 2257410 plaintiff atte Hoo Robert     atte Hoo, Robert 8
4673732 2257410 2257410 plaintiff Hedon Richard clerk   Hedon, Richard, clerk 9
4673733 2257410 2257410 plaintiff Glemham John     Glemham, John 10
4673734 2257410 2257410 plaintiff Wode John esq   Wode, John, esq 11
4673735 2257410 2257410 plaintiff Bolton Robert esq   Bolton, Robert, esq 12
4673736 2257410 2257410 defendant Waldegrave Richard   781647 781647 Waldegrave, Richard, of Bury St Mary, knight 0
4673737 2257410 2257410 defendant Stapleton Miles de   640950 640950 Stapleton, Miles de, of Ingham, Norf, knight 1
4673738 2257410 2257410 defendant Fastolf John esq 781649 781649 Fastolf, John, of Okenhill, esq 2
4673739 2257410 2257410 defendant Bowet William   586241 586241 Bowet, William, of Wrentham, knight 3
4673740 2257410 2257410 defendant Danyele Richard clerk 586785 586785 Danyele, Richard, of Blyburgh, clerk 4
4673741 2257410 2257410 defendant Wynfeld John clerk 619296 619296 Wynfeld, John, of Bliburgh, clerk 5
4673742 2257410 2257410 defendant Copledych William esq 643468 643468 Copledych, William, of Apulton, Norf, esq 6

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