names

16 rows where case_id = 1933270

✎ 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
3722400 1933270 1933270 plaintiff Merston John abbot of Notley Abbey   Merston, John, abbot of Notley Abbey 0
3722401 1933270 1933270 defendant Smyth Lawrence yeoman 618011 618011 Smyth, Lawrence, of Rossen, yeoman 0
3722402 1933270 1933270 defendant Donne John yeoman 618011 618011 Donne, John, of Rossen, yeoman 1
3722403 1933270 1933270 defendant Barnard Richard husbandman 588765 588765 Barnard, Richard, of Hadnam, husbandman 2
3722404 1933270 1933270 defendant Chapman John husbandman 588765 588765 Chapman, John, of Hadnam, husbandman 3
3722405 1933270 1933270 defendant Chapman William     Chapman, William 4
3722406 1933270 1933270 defendant Hill Thomas     Hill, Thomas 5
3722407 1933270 1933270 defendant Fulkys Robert     Fulkys, Robert 6
3722408 1933270 1933270 defendant Smyth William     Smyth, William 7
3722409 1933270 1933270 defendant Bowdon Edward     Bowdon, Edward 8
3722410 1933270 1933270 defendant Peerse Richard     Peerse, Richard 9
3722411 1933270 1933270 defendant Ball Robert     Ball, Robert 10
3722412 1933270 1933270 defendant Myng Giles     Myng, Giles 11
3722413 1933270 1933270 defendant Harys Edward     Harys, Edward 12
3722414 1933270 1933270 defendant Playter John     Playter, John 13
3722415 1933270 1933270 defendant More William husbandman 588765 588765 More, William, of Hadnam, husbandman 14

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