names

27 rows where place_id = 592737

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608703 1870383 1870383 defendant Baron John chapman 592737 592737 Baron, John, of Wodstok, Oxon, chapman 0
3626250 1903066 1903066 defendant Tayler John yeoman 592737 592737 Tayler, John, of Wodstok, Oxon, yeoman 3
3626252 1903066 1903066 defendant Geffrey Richard yeoman 592737 592737 Geffrey, Richard, of Wodstok, Oxon, yeoman 5
3633979 1905433 1905433 defendant Chamberley Edward   592737 592737 Chamberley, Edward, of Wodstok, Oxon, knight 7
3669202 1916305 1916305 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3683684 1921029 1921029 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3685952 1921763 1921763 defendant Chamberleyn Sybil widow 592737 592737 Chamberleyn, Sybil, of Wodstok, Oxon, widow 0
3693172 1924075 1924075 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 1
3698508 1925753 1925753 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3702037 1926890 1926890 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3774767 1949836 1949836 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3792421 1955492 1955492 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3796982 1956935 1956935 defendant Chamberlayn Edward   592737 592737 Chamberlayn, Edward, of Wodstok, Oxon, knight 0
3798332 1957378 1957378 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3869274 1979965 1979965 defendant Chamberleyn Edward   592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, knight 0
3885709 1985476 1985476 defendant Sklater John mercer 592737 592737 Sklater, John, of Wodstok, Oxon, mercer 0
3918942 1996656 1996656 defendant Westall Jerome mercer 592737 592737 Westall, Jerome, of Wodstok, Oxon, mercer 0
4857073 2313592 2313592 defendant Maynard Thomas yeoman 592737 592737 Maynard, Thomas, of Wodstok, Oxon, yeoman 2
4953492 2343013 2343013 defendant Frome Thomas baker 592737 592737 Frome, Thomas, of Wodstok, Oxon, baker 0
4953494 2343014 2343014 defendant Frome Thomas baker 592737 592737 Frome, Thomas, of Wodstok, Oxon, baker 0
5370461 2466345 2466345 defendant Austyn Alice widow 592737 592737 Austyn, Alice, of Wodstok, Oxon, widow 0
5370471 2466347 2466347 defendant Austyn Alice widow 592737 592737 Austyn, Alice, of Wodstok, Oxon, widow 3
5375380 2467889 2467889 defendant Marchall Nicholas chapman 592737 592737 Marchall, Nicholas, of Wodstok, Oxon, chapman 0
5533053 2514880 2514880 defendant Wales John carter 592737 592737 Wales, John, of Wodstok, Oxon, carter 1
5559197 2522654 2522654 defendant Colsell henry innholder 592737 592737 Colsell, henry, of Wodstok, Oxon, innholder 0
5601525 2535368 2535368 defendant Chamberleyn Edward gent 592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, gent 2
5601530 2535369 2535369 defendant Chamberleyn Edward gent 592737 592737 Chamberleyn, Edward, of Wodstok, Oxon, gent 1

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