names

24 rows where case_id = 2364040

✎ 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
5024355 2364040 2364040 plaintiff Holm William, senior (legal representative)   Holm, William, senior, executors of 0
5024356 2364040 2364040 plaintiff Holm Mary     (Holm, Mary 1
5024357 2364040 2364040 plaintiff Holm John     Holm, John 2
5024358 2364040 2364040 plaintiff Holm William     Holm, William 3
5024359 2364040 2364040 plaintiff Holm John   591957 591957 Holm, John, of Helmyngham 4
5024360 2364040 2364040 defendant Wyght Anne widow 615153 615153 Wyght, Anne, of Gretyngham, widow 0
5024361 2364040 2364040 defendant Roger John of Ipswich butcher   Roger, John of Ipswich, butcher 1
5024362 2364040 2364040 defendant Wode Thomas yeoman 587091 587091 Wode, Thomas, of Braunston, yeoman 2
5024363 2364040 2364040 defendant Waryn Thomas laborer 585947 585947 Waryn, Thomas, of Hadley, laborer 3
5024364 2364040 2364040 defendant Knyght Thomas   587058 587058 Knyght, Thomas, of Sutton, bailiff 4
5024365 2364040 2364040 defendant Savage Richard husbandman 591957 591957 Savage, Richard, of Helmyngham, husbandman 5
5024366 2364040 2364040 defendant Suklyng John yeoman 601078 601078 Suklyng, John, of Framesden, yeoman 6
5024367 2364040 2364040 defendant Suklyng John, senior merchant 586134 586134 Suklyng, John, senior, of Ipswich, merchant 7
5024368 2364040 2364040 defendant Martyn John yeoman 591957 591957 Martyn, John, of Helmyngham, yeoman 8
5024369 2364040 2364040 defendant Skeyton John yeoman 615153 615153 Skeyton, John, of Gretyngham, yeoman 9
5024370 2364040 2364040 defendant Deve John   586134 586134 Deve, John, of Ipswich, administrators of 10
5024371 2364040 2364040 defendant Drayll John mercer 586134 586134 (Drayll, John, of Ipswich, mercer 11
5024372 2364040 2364040 defendant Deve Isabel widow   Deve, Isabel, widow 12
5024373 2364040 2364040 defendant Wade John administrators of   Wade, John, administrators of 13
5024374 2364040 2364040 defendant Wade Joan widow 587091 587091 (Wade, Joan, of Braunston, widow 14
5024375 2364040 2364040 defendant Wade John laborer 587091 587091 Wade, John, of Braunston, laborer 15
5024376 2364040 2364040 defendant Wodeward John (legal representative)   Wodeward, John, executors of 16
5024377 2364040 2364040 defendant Bougbrook Walter yeoman 591957 591957 (Bougbrook, Walter, of Helmyngham, yeoman 17
5024378 2364040 2364040 defendant Walle Richard mercer 586134 586134 Walle, Richard, of Ipswich, mercer 18

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